Board index   FAQ   Search  
Register  Login
Board index php forum :: php coding PHP coding => General

Inserting multiple rows

Ask about general coding issues or problems here.

Moderators: macek, egami, gesf

Postby liquedus » Sat Apr 12, 2003 5:54 pm

it executes one query but in that query has multiple rows to be added here is an easy on the eye example

INSERT INTO bob (name,age) VALUES ("Remi","20"), ("Joe","102");

"name" and "age" are column names that you will be inserting into, and the data following VALUES are the data to be inserted into those columns, hope that helps.
php-forum Active User
php-forum Active User
Posts: 266
Joined: Tue Apr 08, 2003 5:18 am
Location: Ottawa, Canada

Return to PHP coding => General

Who is online

Users browsing this forum: Bing [Bot] and 1 guest

Sponsored by Sitebuilder Web hosting and Traduzioni Italiano Rumeno and antispam for cPanel.