String length of SQl-Statements, creating table

"Peter Prinzen" <[email protected]>
Newsgroups gmane.comp.db.mysql.odbc
Message-ID <[email protected]>
Hi,

I'm creating a table with ADO and ODBC, and use therefor a CONExecute
"SQL..." w SQL="CREATE TABLE /*!32300 IF NOT EXISTS*/  test.table `ID`
INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, ...". No problem so far, but
two questions: When I create a more complicated table, I get an error,
I guess because the SQL-string is too long. Are there any limits?
Another point: How can I create and ALTER an existing table, to create
the table column after column? Are there any functions to get a list
of existing columns?

The last one: I copied the "CREATE TABLE /*!32300 IF NOT EXISTS*/
from soem other i-net forum. But I would like to know the meaning of
"/*!32300 IF NOT EXISTS*/ ". Any hints here?

Thanks a lot

Peter

-- 
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe:    http://lists.mysql.com/[email protected]
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.