MYsql code

[BlueIce]

Can some one help me out with a bit of sql code, Ok i have made a table and rows with

CREATE TABLE `Sheet1`"what ever table"
INSERT INTO `Sheet1`VALUES "what ever data"

ok now i want to put in more data but if i use the
INSERT INTO and then the data I just get a sql error, how do you insert more data into a table that is all ready made

if that makes any sence to anyone else

[nishark]

UPDATE might help.

the database experts tend to browse the 'Databases' forum under 'WebProgramming, ..,Software Development'. so i guess these kinda questions will get quicker replies there

[vass0922]

Does the table exist?

can you do

SELECT * FROM Sheet1?

(btw, you may want a more descriptive tablename in the future but I'm assuming this just playing around)

don't use the 'quotes' or "quotes" (at least not in any sql I've ever seen)

INSERT INTO tablename
VALUES ('some string', 23432, 'values from a string');

Doing it that method you must insert values into ALL fields.
You maybe able to use
INSERT INTO tablename
VALUES (NULL, 23432, "values from a string");
but not sure in MySQL

What is the error you're getting?


-- edit --
forgot mysql requires semi colons after statements and to use single quotes in sql to represent strings
Dont' use quotes for table names as they are objects in the database.

UPDATE Only works for existing rows

INSERT INTO

INSERT INTO tbl_name (col1,col2) VALUES(col2*2,15);

IS what you want, from the docs nishark provided