Create Table MySQL

[Quinton B.]

Good day, I'm trying to create a table in a MySQL database with the following code:

Code: Select all

put "CREATE TABLE IF NOT EXISTS PAV2_ACCOUNTS (User_ID int(50) NOT NULL auto_incriment, User_Name varchar(50) NOT NULL, Password varchar(50) NOT NULL, Authentication_Code varchar(50) NOT NULL, DoD_Email varchar(50) NOT NULL, DSN varchar(50) NOT NULL, Personell_Number varchar(50) NOT NULL, Address varchar(100) NOT NULL, Security_Question_1 varchar(100) NOT NULL, Security_Answer_1 varchar(100) NOT NULL, Security_Question_2 varchar(100) NOT NULL, Security_Answer_2 varchar(100) NOT NULL, Security_Question_3 varchar(100) NOT NULL, Security_Answer_3 varchar(100) NOT NULL, Picture blob(), Privilages varchar(100), Branch varchar(4) NOT NULL, Duty_Code varchar(10) NOT NULL, Duty_Status varchar(2) NOT NULL, Rank varchar(15) NOT NULL, MAJCOM varchar(20) NOT NULL, Base varchar(100) NOT NULL, Group varchar(100) NOT NULL, Squadron varchar(100) NOT NULL, Flight varchar(100) NOT NULL, Position varchar(100), Additional_Position varchar(100), PRIMARY KEY(User_ID)" into tSQL
   revExecuteSQL gConnectionID, tSQL

The above code status a code that something is wrong with how it is worded, I have no idea what is wrong with it.

[Klaus]

Hi Quinton,

looks like there is no closing bracket at the end.

Code: Select all

...
## put "CREATE TABLE IF NOT EXISTS PAV2_ACCOUNTS (User_ID int(50) NOT NULL...PRIMARY KEY(User_ID)" into tSQL
put "CREATE TABLE IF NOT EXISTS PAV2_ACCOUNTS (User_ID int(50) NOT NULL...PRIMARY KEY(User_ID))" into tSQL
...

Best

Klaus

[Quinton B.]

I'm still getting the same error regardless of the forgotten parentheses.

[Klaus]

Hm, I can spot a typo here:
... (User_ID int(50) NOT NULL auto_incriment
But then my SQL kowledge leaves me...

[Quinton B.]

Well, it fixed all the way up to this part.

[Klaus]

Hm, Group is maybe a "reseved" word in the mariaDB engine? SQL -> group by...

And/or maybe you need to QUOTE the names?
I have two little functions for exactly this purpose

Code: Select all

## Add quotes "
function q tString
  return QUOTE & tString & QUOTE
end q

## Add single quotes '
function q2 tString
  return "'" & tString & "'"
end q

[Quinton B.]

I was able to create it by changing the name group to something else.

[Klaus]

I was able to create it by changing the name group to something else.

Great!