Bug #30406 insert into values() where
Submitted: 14 Aug 2007 12:15 Modified: 14 Aug 2007 15:32
Reporter: harika m Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server: DML Severity:S1 (Critical)
Version:mySQL5.0 OS:Microsoft Windows
Assigned to: CPU Architecture:Any

[14 Aug 2007 12:15] harika m
Description:
i have created a table like this

Create add(ad_id primarykey varchar(50),min_ age integer(20),max_age(20);

now i am trying into insert into table add by passing a paramter for ad_id

insert into add(min_age,max_age) values(23,24) where ad_id="001";

here it is giving sql sytax error can u help me regarding this 

How to repeat:
Create add(ad_id primarykey varchar(50),min_ age integer(20),max_age(20);

now i am trying into insert into table add by passing a paramter for ad_id

insert into add(min_age,max_age) values(23,24) where ad_id="001";

here it is giving sql sytax error can u help me regarding this
[14 Aug 2007 15:32] Miguel Solorzano
We're sorry, but the bug system is not the appropriate forum for asking help on using MySQL products. Your problem is not the result of a bug.

Support on using our products is available both free in our forums at http://forums.mysql.com/ and for a reasonable fee direct from our skilled support engineers at http://www.mysql.com/support/

Thank you for your interest in MySQL.