mysql 5.5 Create Table with "type=innodb" problem

Alles, was MySQL betrifft, kann hier besprochen werden.

mysql 5.5 Create Table with "type=innodb" problem

Postby kokookao » 10. February 2011 06:26

hi all:

After updae mysql 5.5 CREATE TABLE not work .

CREATE TABLE `temp302` (
`date` DATE,
`sno` CHAR (10) ,
`cno` CHAR (8) ,
) Type=InnoDb ;

Need change as :
CREATE TABLE `temp302` (
`date` DATE,
`sno` CHAR (10) ,
`cno` CHAR (8) ,
) ENGINE=InnoDb ;

How can I do not to edit all source code for xampp ver.1.7.4 ?

--
Best Regards
--------------------------------------------------------------
kokoo KAO
kokookao
 
Posts: 3
Joined: 23. March 2010 17:00

Re: mysql 5.5 Create Table with "type=innodb" problem

Postby Nobbie » 10. February 2011 22:55

Am besten schreibst Du ein kleines Script, welches die SQL Deklarationen im Batch Modus anpasst. Unter Linux wäre das sehr einfach.
Nobbie
 
Posts: 6918
Joined: 09. March 2008 13:04

Re: mysql 5.5 Create Table with "type=innodb" problem

Postby kokookao » 02. June 2011 02:57

Sorry , I don't understand .

After update lampp 1.73a to 1.74 , Mysql change version from 5.1x to 5.5x .
All the source code
.." Create table ...( ..) Type=InnoDb "
have to change as
".. Create table ...( ..) Engine=InnoDb "

How can I work without change all the source code ?
Because my application call a old Library(SQLRDD) not support mysql 5.5x , it is not work for recompiler it ?

--
Best Regards
kokookao
 
Posts: 3
Joined: 23. March 2010 17:00


Return to MySQL

Who is online

Users browsing this forum: No registered users and 3 guests