Inserting multiple rows

Ask about general coding issues or problems here.

Moderators: macek, egami, gesf

liquedus
php-forum Active User
php-forum Active User
Posts: 266
Joined: Tue Apr 08, 2003 5:18 am
Location: Ottawa, Canada
Contact:

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.

Return to “PHP coding => General”

Who is online

Users browsing this forum: No registered users and 1 guest