Expand my Community achievements bar.

Guidelines for the Responsible Use of Generative AI in the Experience Cloud Community.
SOLVED

How do I create a table in MySQL?

Avatar

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

1 Accepted Solution

Avatar

Correct answer by
Former Community Member

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

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

Avatar

Correct answer by
Former Community Member

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

The following has evaluated to null or missing: ==> liqladmin("SELECT id, value FROM metrics WHERE id = 'net_accepted_solutions' and user.id = '${acceptedAnswer.author.id}'").data.items [in template "analytics-container" at line 83, column 41] ---- Tip: It's the step after the last dot that caused this error, not those before it. ---- Tip: If the failing expression is known to be legally refer to something that's sometimes null or missing, either specify a default value like myOptionalVar!myDefault, or use <#if myOptionalVar??>when-present<#else>when-missing. (These only cover the last step of the expression; to cover the whole expression, use parenthesis: (myOptionalVar.foo)!myDefault, (myOptionalVar.foo)?? ---- ---- FTL stack trace ("~" means nesting-related): - Failed at: #assign answerAuthorNetSolutions = li... [in template "analytics-container" at line 83, column 5] ----