[PHP-DB] Get MySql DB diagram
Hi All, Any one knows a free software / tool that can use to gat MySql DB diagram. Like MS SQL 2000, get database diagram. Cheers, Lasitha. DOTW DISCLAIMER: This e-mail and any attachments are strictly confidential and intended for the addressee only. If you are not the named addressee you must not disclose, copy or take any action in reliance of this transmission and you should notify us as soon as possible. If you have received it in error, please contact the message sender immediately. This e-mail and any attachments are believed to be free from viruses but it is your responsibility to carry out all necessary virus checks and DOTW accepts no liability in connection therewith. This e-mail and all other electronic (including voice) communications from the sender's company are for informational purposes only. No such communication is intended by the sender to constitute either an electronic record or an electronic signature or to constitute any agreement by the sender to conduct a transaction by electronic means. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] MySQL Error 1366
Hi All, I want to load data from dump file to MySQL table using LOAD DATA INFILE but there is Error 1366 : mysql LOAD DATA - INFILE 'D:/SITE/SOMETABLE.SQL' - INTO TABLE SOMETABLE - FIELDS TERMINATED BY ',' - OPTIONALLY ENCLOSED BY '' - LINES TERMINATED BY ')'; ERROR 1366 (HY000): Incorrect integer value: '--MySQL dump 10.10 -- --S' for column 'ID' at row 1 this is the header of my dump file: DROP TABLE IF EXISTS `sometable`; CREATE TABLE `sometableo` ( `ID` smallint(6) NOT NULL auto_increment, `Name` varchar(30) NOT NULL, `title` tinytext, `description` tinytext, `cat` tinytext, PRIMARY KEY (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; LOCK TABLES `sometable` WRITE; /*!4 ALTER TABLE `sometable` DISABLE KEYS */; INSERT INTO `sometable` VALUES (79,'110_1099','AAA','AA','AAA'),(80,'110_1100','AAA','DFGDFGF','AAA'), any idea for solving the problem? - Sick sense of humor? Visit Yahoo! TV's Comedy with an Edge to see what's on, when.
Re: [PHP-DB] MySQL Error 1366
elk dolk wrote: Hi All, I want to load data from dump file to MySQL table using LOAD DATA INFILE but there is Error 1366 : mysql LOAD DATA - INFILE 'D:/SITE/SOMETABLE.SQL' - INTO TABLE SOMETABLE - FIELDS TERMINATED BY ',' - OPTIONALLY ENCLOSED BY '' - LINES TERMINATED BY ')'; ERROR 1366 (HY000): Incorrect integer value: '--MySQL dump 10.10 -- --S' for column 'ID' at row 1 LOAD DATA INFILE imports a CSV like file, it can't contain create table statements or insert statements. See the documentation: http://dev.mysql.com/doc/refman/4.1/en/load-data.html If you have a script with create table insert statements, use source: source (\.)Execute a SQL script file. Takes a file name as an argument. So \. filename -- Postgresql php tutorials http://www.designmagick.com/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] MySQL Error 1366
Chetanji says, This may be a typo of yours. Look at the header... CREATE TABLE `sometableo` The 'o' is added by mistake? Blessings, Chetanji elk dolk wrote: Hi All, I want to load data from dump file to MySQL table using LOAD DATA INFILE but there is Error 1366 : mysql LOAD DATA - INFILE 'D:/SITE/SOMETABLE.SQL' - INTO TABLE SOMETABLE - FIELDS TERMINATED BY ',' - OPTIONALLY ENCLOSED BY '' - LINES TERMINATED BY ')'; ERROR 1366 (HY000): Incorrect integer value: '--MySQL dump 10.10 -- --S' for column 'ID' at row 1 this is the header of my dump file: DROP TABLE IF EXISTS `sometable`; CREATE TABLE `sometableo` ( `ID` smallint(6) NOT NULL auto_increment, `Name` varchar(30) NOT NULL, `title` tinytext, `description` tinytext, `cat` tinytext, PRIMARY KEY (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; LOCK TABLES `sometable` WRITE; /*!4 ALTER TABLE `sometable` DISABLE KEYS */; INSERT INTO `sometable` VALUES (79,'110_1099','AAA','AA','AAA'),(80,'110_1100','AAA','DFGDFGF','AAA'), any idea for solving the problem? - Sick sense of humor? Visit Yahoo! TV's Comedy with an Edge to see what's on, when. -- View this message in context: http://www.nabble.com/MySQL-Error-1366-tf3830472.html#a10846547 Sent from the Php - Database mailing list archive at Nabble.com. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php