Xojo Conferences
MBSSep2018MunichDE
XDCMay2019MiamiUSA

Re: SQL: CREATE TABLE IF NOT EXISTS Employees (…/…) (Real Studio network user group Mailinglist archive)

Back to the thread list
Previous thread: Texas Instruments CC3000?
Next thread: Compilation strange behaviour: same size but I added two TeaxtArea.Text = "" ???


Re: Recording audio from RB?   -   Garth Hjelte
  Re: SQL: CREATE TABLE IF NOT EXISTS Employees (…/…)   -   emile.a.schwarz
    SQL: CREATE TABLE IF NOT EXISTS Employees (…/…)   -   emile.a.schwarz

Re: SQL: CREATE TABLE IF NOT EXISTS Employees (…/…)
Date: 07.08.13 13:29 (Wed, 7 Aug 2013 14:29:33 +0200 (CEST))
From: emile.a.schwarz
Sometimes you search, search again, encore search and do not found. Once you send the mail to ask… an answer comes to you. That is what I saw:

http://dev.mysql.com/doc/refman/5.1/en/create-table.html

the first syntax example is:

CREATE [TEMPORARY] TABLE [IF NOT EXISTS] tbl_name

I will read a bit more what they display; there certainly have some things to learn from there !

Enjoy,

Emile

_______________________________________________
Unsubscribe by sending a message to:
<<email address removed>>

Search the archives:
<http://support.realsoftware.com/listarchives/lists.html>

SQL: CREATE TABLE IF NOT EXISTS Employees (…/…)
Date: 07.08.13 13:21 (Wed, 7 Aug 2013 14:21:26 +0200 (CEST))
From: emile.a.schwarz
Hi,

 

every now and then (when I recall), I am searching where this particular syntax appears, but I failed.

 

Today links:

http://www.tutorialspoint.com/sql/sql-create-table.htm

http://sql-info.de/mysql/examples/CREATE-TABLE-examples.html

http://www.1keydata.com/sql/sqlcreate.html

 

PLUS: one French magazine (I get an eye inside it); a special SQL issue.

 

BUT, all found entries talks about adding a PRIMARY KEY (even for some a FOREIGN KEY). I wonder why people does not include a PRIMARY KEY in their DB.

 

Syntax example:

SQLCmd = "CREATE TABLE IF NOT EXISTS Employees (Name VARCHAR, Job VARCHAR, Year_Joined Date, ID INTEGER NOT NULL PRIMARY KEY)"

 

Emile
_______________________________________________
Unsubscribe by sending a message to:
<<email address removed>>

Search the archives:
<http://support.realsoftware.com/listarchives/lists.html>