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;

1 comment:

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

    SHOW CREATE TABLE vtiger_account\G

    ReplyDelete