Bug #30406 insert into values() where

• Submitted: 14 Aug 2007 12:15
• Modified: 14 Aug 2007 15:32
• Reporter: harika m
• Status: Not a Bug
• Category: MySQL Server: DML
• Severity: S1 (Critical)
• Version: mySQL5.0
• OS: Windows
• 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] MySQL Verification Team

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.