mysql syntax

insert into A (name) values(rsReport.fields("name")) ??? is this syntax correct?

re: mysql syntax

re: mysql syntax

INSERT INTO 'tablename' VALUES ('value1','value2'.....);

forexample:

insert into data (firstname,lastname,age) values ('bas','sab',21)

if u want to insert only two field means

insert into data (firstname,age) values ('baas',21)

if u want to insert all field means

insert into data values('das','sad',24)

re: mysql syntax

Where does the 'rsReport' come from?

The value you specified is not valid SQL syntax no, but if you are trying to build a query in some coding language or a script then this is pretty close.

The previous replies explained how MySQL expects a INSERT query to be formatted, so its just a matter of getting you code to create it correctly.

P.S.
This is true, it is however good practice to always specify the columns you want to insert into. This will ensure that your queries will work, even if at some point the table layout is altered.