[SOLVED] MYSQL Help

[nathanmaxsonadil]

what's the mysql command for inserting a row into a column?

 

[AndyB]

You can't insert a row into a column. You can insert a row into a table using INSERT into tablename ....

 

http://www.tizag.com/mysqlTutorial/mysqlinsert.php

[wildteen88]

How do you mean?

 

If you want to insert a new row and add data to a couple of the columns you can use INSERT along with listing the columns you want to add data to, eg:

INSERT INTO tbl_name (`col1`, `col2`) VALUES ('col1_value', 'col2_value');

 

or if you want to add/update data to a column within an existing row you'd use UPDATE, eg:

UPDATE tbl_name SET `col_name` = 'some_value' WHERE column_id = 'some_column_id_value'