Wednesday, January 13, 2010

Generate script for MySQL table

The following script gets create table script of vtiger_account table in vtigerCRM.

SHOW CREATE TABLE vtiger_account;

at 9:53 PM

Labels: , ,

1 comment:

  1. Gerry NarvajaJanuary 14, 2010 at 4:08 PM

    You need to finish your query with '\G' instead of ';', try:

    SHOW CREATE TABLE vtiger_account\G

    ReplyDelete

Subscribe to: Post Comments (Atom)