phpmyadmin - Updating multiple rows in SQL -
using phpmyadmin, want update multiple rows of data new information.
the 'uid' unique each record. 'pid' field same records.
i modified insert statment after exported data database.
update `tabme_name` set (`uid`, `pid`, `title`, `category`) values (230952, 1902, 112, 27634), (230953, 1902, 179, 27641), (230954, 1902, 75, 27630), (230955, 1902, 38, 27626);
i can find information on updating 1 record, or updating records same information. show me correct sql statment? havn't got clause in it!?!
assuming uid pk must execute multiple updates:
update tabme_name set pid = 1902, title =112, category=27634 uid=230952 update tabme_name set pid = 1902, title =179, category=27641 uid=230953 ...
Comments
Post a Comment