Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

How do I create a table in MySQL?

Avatar

Level 5

Hello!

I need to create a table in the database to be used by a simple process.

How do I create it once I have the SQL ready (just two statements, CREATE TABLE and INSERT)?

Thank you for any hints.

Marcos

1 Accepted Solution

Avatar

Correct answer by
Level 4

Hi Marcos,

There is no harm in creating table in Adobe schema itself.

You can create any number of tables in Adobe Schema and access it, but dont not make any changes in the Adobe Tables.

All the Best.

Regards--

Chalukya

View solution in original post

3 Replies

Avatar

Level 8

I don't recommend using the Adobe MySQL database for anything other than LiveCycle.   I suggest you create another MySQL instance to hold your own data.

You can get the MySQL database and tools from the MySQL web page:

http://www.mysql.com

http://www.mysql.com/downloads/workbench/

Avatar

Level 5

Hi Hodmi,

Thanks for replying.

Well, here's what I need to do... maybe you can help.

I need to create a process to control a sequence number to be applied to a PDF form every time a button is pressed on the form (or whenever the form is opened to be filled in).

So, in order to store the last number used I need a database, right? Are you saying I must have another database outside LiveCycle to store this number?

Thank you!

Marcos

Avatar

Correct answer by
Level 4

Hi Marcos,

There is no harm in creating table in Adobe schema itself.

You can create any number of tables in Adobe Schema and access it, but dont not make any changes in the Adobe Tables.

All the Best.

Regards--

Chalukya