[SOLVED] What is the proper syntax for adding a new row into a table?

[bobleny]

Just a quick question...

 

What is the proper syntax for adding a new row into a table?

 

Thanks!

[printf]

It depends on what you mean...

 

If you want to add a new column, then...

 

ALTER TABLE table_name ADD column_name_to_add column_type_and_default_value_if_approbate;

 

example 1. (add a column)

 

ALTER TABLE users ADD auto_login tinyint(1) unsigned default '0' NOT NULL;

 

example 2. (add a column)

 

ALTER TABLE users ADD notes TEXT NOT NULL;

 

example 3. (change a column type, top_id)

 

ALTER TABLE topics CHANGE topic_id topic_id int(10) default '0' NOT NULL;

 

printf

[artacus]

That's a column.

 

You have two options to add a row

 

Either

INSERT INTO table (field1, field2, field4) VALUES ('thing',1,334)

 

or

INSERT INTO table VALUES ('thing',1,NULL,334)

[bobleny]

Alright, thanks!

 

That is what I needed to know. I wanted to make sure that I was doing it right. But I finally got it to work.