![]() |
Hello and Welcome from United States to the UNIX and Linux Forums! Thank You for Visiting and Joining Our Global Community.
|
|
google unix.com
|
|||||||
| Forums | Register | Forum Rules | Links | Albums | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| UNIX and Linux Applications Discuss UNIX and Linux software applications. This includes SQL, Databases, Middleware, MOM, SOA, EDA, CEP, BI, BPM and similar topics. |
More UNIX and Linux Forum Topics You Might Find Helpful
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| sed error : Syntax error: redirection unexpected | phpfreak | Shell Programming and Scripting | 3 | 12-04-2008 05:19 AM |
| nim mksysb error :/usr/bin/savevg[33]: 1016,07: syntax error | astjen | AIX | 9 | 10-03-2008 11:44 AM |
| awk Shell Script error : "Syntax Error : `Split' unexpected | Herry | UNIX for Dummies Questions & Answers | 2 | 03-17-2008 11:16 AM |
| I got error like...syntax error on line 1, teletype | koti_rama | UNIX for Advanced & Expert Users | 2 | 07-07-2007 07:35 PM |
| awk syntax error | k@ssidy | UNIX for Dummies Questions & Answers | 12 | 06-15-2005 10:00 AM |
![]() |
|
|
LinkBack | Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
|
|
||||
|
mysql syntax error ?
hi,
I receive this error when I export/import a table from a database to another one: Code:
Error SQL query: -- -- Database: `mil` -- -- -------------------------------------------------------- -- -- Table structure for table `jos_taoj` -- CREATE TABLE IF NOT EXISTS `jos_taoj` ( `id` INT( 10 ) NOT NULL AUTO_INCREMENT , `extension` VARCHAR( 100 ) NOT NULL COMMENT 'The extension', `version` VARCHAR( 16 ) NOT NULL COMMENT 'Version number', `installed_date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Date-time modified or installed', `log` MEDIUMTEXT, PRIMARY KEY ( `id` ) USING BTREE, KEY `idx_extension` ( `extension` ) ) ENGINE = MYISAM DEFAULT CHARSET = utf8 COMMENT = 'The Art of Joomla extension version history' AUTO_INCREMENT =2; MySQL said: #1064 - Erreur de syntaxe près de 'USING BTREE, KEY `idx_extension` (`extension`) ) ENGINE=MyISAM' à la ligne 7 thanks |
|
||||
|
Hi.
Should it not be: Code:
PRIMARY KEY USING BTREE( `id` ), Code:
Your SQL query has been executed successfully (Query took 0.0847 sec) SQL query: CREATE TABLE IF NOT EXISTS `jos_taoj` ( `id` INT( 10 ) NOT NULL AUTO_INCREMENT , `extension` VARCHAR( 100 ) NOT NULL COMMENT 'The extension', `version` VARCHAR( 16 ) NOT NULL COMMENT 'Version number', `installed_date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Date-time modified or installed', `log` MEDIUMTEXT, PRIMARY KEY USING BTREE( `id` ), KEY `idx_extension` ( `extension` ) ) ENGINE = MYISAM DEFAULT CHARSET = utf8 AUTO_INCREMENT =2; |
![]() |
| Bookmarks |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|