How do I create a table in MySQL?

[Former Community Member]

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

[Hodmi]

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/

[Former Community Member]

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

[Former Community Member · Accepted solution]

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