the MySQL syntax said:
INSERT [LOW_PRIORITY | DELAYED] [IGNORE] [INTO] tbl_name [(col_name,...)] VALUES ((expression | DEFAULT),...),(...),... [ ON DUPLICATE KEY UPDATE col_name=expression, ... ] or INSERT [LOW_PRIORITY | DELAYED] [IGNORE] [INTO] tbl_name [(col_name,...)] SELECT ... or INSERT [LOW_PRIORITY | DELAYED] [IGNORE] [INTO] tbl_name SET col_name=(expression | DEFAULT), ... [ ON DUPLICATE KEY UPDATE col_name=expression, ... ]
also while insert into user(...) failed is an MySQL problem, while after INSERT or INTO follows table name an not a function.
Regards, Rafal At 17:58 28.10.2003, Rafal Kedziorski wrote:
hi,
I'm using MySQL 4.0.13 and 4.0.14 (4.0.16 I will test tomorrow). And I have problems with this query:
insert into user(class_id, retail_id, mandant_id, language_id, user_data_id, nickname, login_name, password, status, creation_date, last_login_date) values ('35F7A660096411D89BC0D1907F000001', '1234', 2, 1, null, null, '[EMAIL PROTECTED]', 'demo', 8, '2003-10-28 17:31:36', null)
but the same query with space after user
insert into user (class_id, retail_id, mandant_id, language_id, user_data_id, nickname, login_name, password, status, creation_date, last_login_date) values ('35F7A660096411D89BC0D1907F000001', '1234', 2, 1, null, null, '[EMAIL PROTECTED]', 'demo', 8, '2003-10-28 17:31:36', null)
works.
Regards, Rafal
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
