insert or update rows into mysql

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
aaaphp000000
Forum Newbie
Posts: 22
Joined: Mon Aug 29, 2005 5:39 am

insert or update rows into mysql

Post 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?
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post 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
Post Reply