Re: I'd like to know SQL query for table description.

Try this query - show table status from YourDatabaseName; ninjajs wrote: Hi. ALL i have a database in MySQL. A middleware request to MySQL DB server. and then, result is table description. ex) dbms_type,table_name,column_name,data_type,data_size,constraint_type What SQL query can I get this

RE: I'd like to know SQL query for table description.

[snip] and then, result is table description. ex) dbms_type,table_name,column_name,data_type,data_size,constraint_type What SQL query can I get this information ? [/snip] DESCRIBE `tablename`; -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Re: I'd like to know SQL query for table description.

Hello. See: http://dev.mysql.com/doc/mysql/en/SHOW_CREATE_TABLE.html ninjajs [EMAIL PROTECTED] wrote: Hi. ALL i have a database in MySQL. A middleware request to MySQL DB server. and then, result is table description. ex)

I'd like to know SQL query for table description.

Hi. ALL i have a database in MySQL. A middleware request to MySQL DB server. and then, result is table description. ex) dbms_type,table_name,column_name,data_type,data_size,constraint_type What SQL query can I get this information ? thank you. -- MySQL General Mailing List For list