• Home
  • Systems
  • Networking
  • WordPress
  • Web
  • Geekery

Analysis and Review

Mass Insert Data into a mySQL Table

August 13, 2010 by Kurt Turner

How to mass insert data into a table via mySQL.

INSERT INTO table_name_goes_here(
group_id,
parent_id,
type,
name)
VALUES(
'1',
'2',
'option',
'Aaron Rodgers'
),
(
'1',
'2',
'option',
'
)

Or just add one item

INSERT INTO NFL2010_ProjectedStats(`player`,`pos`,`team`,`p-yds`,`p-td`,`int`,`ru-yds`,`ru-td`,`rec`,`re-yds`,`re-td`,`bonus`)VALUES('Kareem Huggins','RB','TB','0','0','0','500','2','35','350','1','0')

Filed Under: Systems

Latest and Greatest

Apache vs Nginx for WordPress

Certbot Lets Encrypt And WordPress MU Multi-Site

How To Find and Replace Multiple File in MS Word

How To Get Stretch Res on Windows 10 AMD Radeon For Game Play

This is the ASUS Chromebox we've been running for 2 years as our "brain" for our home grown digital display kiosk.

DIY Digital Signage Bulletin Board or Kiosk

© Copyright Analysis And Review · All Rights Reserved ·