Re: Problem with insert data

2003-10-29 Thread Rafal Kedziorski
hi, 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 [(co

Re: Problem with insert data

2003-10-28 Thread Rafal Kedziorski
At 15:09 28.10.2003 -0600, gerald_clark wrote: 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,

Re: Problem with insert data

2003-10-28 Thread 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 ('35F7A

Problem with insert data

2003-10-28 Thread Rafal Kedziorski
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 ('35F7A660096411D89BC0D1907F