which is the correct way

[expired user #7454]'s profile image [expired user #7454] posted 10 years ago in General Permalink
when i add collumns in a auto increament file do i do this

INSERT INTO data2 (data, item, address, city, state, zip, phone, note)
VALUES ('key','item','address','city','state','zip','phone','note');

or this

INSERT INTO data2 (data) (item, address, city, state, zip, phone, note)
VALUES ('key','item','address','city','state','zip','phone','note');
kalvaro's profile image kalvaro posted 10 years ago Permalink
Click on the "Query" tab, paste your SQL there and push the blue arrow button to run it. HeidiSQL will report the syntax errors detected by the server.

(You should find a book or tutorial about SQL. Learning by guessing the syntax is going to be painful.)
[expired user #7454]'s profile image [expired user #7454] posted 10 years ago Permalink
its not like basic that gives lee way
by the way. would basica or cobel work
I can do bit and cobel basica is to simple so that's out

Please login to leave a reply, or register at first.