mysql vs sql

Forum Moderators: open

Message Too Old, No Replies

3:38 pm on May 5, 2009 (gmt 0)

I usually work with mysql but a new client is using sql server.

My question has to do with inserts, more specifically when inserting a new row in a table.

So in MySql I can do:

INSERT into table VALUES(DEFAULT,"'.$post['variable'].'")

Notice the DEFAULT for the new id created for a new row in the table.

How do I do that in SQL? I have tried a few things and nothing has worked. Is there an equivalent to DEFAULT for a new row id in SQL?

Thanks!

4:02 pm on May 5, 2009 (gmt 0)

If you don't supply a value, SQL uses the default value set in the table definition.

4:36 pm on May 5, 2009 (gmt 0)

Yes, just make sure that you list the values you are passing in, you can only skip that step if you are passing in a value for each column.

So you will want something like this.

INSERT into table (column_name) VALUES("'.$post['variable'].'")

4:41 pm on May 5, 2009 (gmt 0)

OK cool, thanks for the info.

If I look in the frontend of the db for that table, the id column is blank under the DEFAULT value.

What should I do there?

5:39 pm on May 5, 2009 (gmt 0)

assign a default value to that field.

If you want it to generate an id for you, then you may have to create a sequence or something else to use for that id.