Troubleshooters.Com, Code Corner and Steve's SQL Builder Present

INSERT Statement Builder
Copyright (C) 2009 by Steve Litt




x

Tablename Column names Column values
INSERT INTO   ( )  VALUES  ( );

Enter column names of any columns you want filled in the inserted row. Put commas between the column names. Do not prepend tablenames in front of the column names, just use the column names themselves.

If you want to fill all columns, leave this blank. If you have auto-incrementing columns, you do NOT want to fill them in, so if you have auto-incrementing columns you'll need to put names of all OTHER columns here.
Enter column values in the same order you put the column names. If you put no column names, put all column values in the order of the columns in the table.

Surround each value with SINGLE quotes, and put commas between the values.






  


y

test=# insert into peeps (lname, fname, job_id) values ('Biden', 'Joe', 5);

Troubleshooters.ComCode Corner * Linux Library