INSERT dump (mySQL)
| From: | Fredrik Stark | Date: | Wed, 28 Feb 2001 14:35:22 +0000 |
| Subject: | INSERT dump (mySQL) | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-7018@lists.php.net to get a copy of this message | ||
I have a problem with an INSERT into a mySQL database (3.23.32),
the insert comes from a dump from another mySQL database (3.23.24-beta) generated by phpMyAdmin
2.1.0
See messy code below:
INSERT INTO member_info
VALUES ( '2', '', 'Blah blah blah',
'a:13:{i:0;s:2:\"35\";i:1;s:2:\"27\";i:2;s:1:\"1\";i:3;s:1:\"2\";i:4;s:2:\"37\";i:5;s:1:\"8\";i:6;s:1:\"4\";i:7;s:1:\"7\";i:8;s:2:\"10\";i:9;s:2:\"15\";i:10;s:2:\"14\";i:11;s:2:\"43\";i:12;s:2:\"44\";}',
'2001-02-28 10:36:14', '2001-02-02 11:11:11', '0',
'a:2:{i:0;s:1:\"6\";i:1;s:1:\"5\";}');
Generates:
MySQL said:
You have an error in your SQL syntax near ''a:13:{i:0' at line 1
Anyone have a clue?
/fredrik