Page 1 of 1

insert or update rows into mysql

Posted: Mon Aug 29, 2005 9:25 pm
by aaaphp000000
i read help docs of mysql functions, i can not find any function for inserting or updating rows.

Q: must we query SQL to insert and update rows?

if so, how do we lock rows to prevent data from beening multiplly (by multiple persons) updated at same time?

Posted: Mon Aug 29, 2005 11:00 pm
by feyd
INSERT/UPDATE

As for locking, the storage engine for the table needs to support locks: http://dev.mysql.com/doc/mysql/en/lock-tables.html