Re: Problem with insert data

[gerald_clark]

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)
This is incorrect.



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.
This is corerect.



Regards,
Rafal

user() is a function.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]