Inserting multiple rows

Ask about general coding issues or problems here.

Moderators: macek, egami, gesf

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

Post by 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.

Post Reply

Who is online

Users browsing this forum: No registered users and 8 guests