Inserting multiple rows

Ask about general coding issues or problems here.

Moderators: egami, macek, gesf

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

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
  • Information
  • Who is online

    Users browsing this forum: Baidu [Spider] and 5 guests