Skip to Main Content
Sams Teach Yourself MySQL in 21 Days, Second Edition
book

Sams Teach Yourself MySQL in 21 Days, Second Edition

by Tony Butcher
December 2002
Beginner content levelBeginner
640 pages
16h 41m
English
Sams
Content preview from Sams Teach Yourself MySQL in 21 Days, Second Edition

Importing Data

MySQL offers a variety of ways of getting data into a database. You've just seen how to use SQL statements to do this. This section looks at how you can import and process data in bulk.

Batch Import Using mysql

Recall from Day 6 that you can import data by using the mysql client program in batch mode.

You can write the syntax in two ways. One is like this:

mysql [options] databasename < filename
						

The same is possible by changing the order of things on the command line and using the Unix cat program and a | (bar, or pipe) to pipe an entire file to mysql for processing:

cat filename | /usr/local/mysql/bin/mysql [options] databasename
						

Provided that your PATH Unix environment variable contains the path to mysql, this shorter form ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Sams Teach Yourself MySQL

Sams Teach Yourself MySQL

Chris Newman
Oracle® Database 10g Insider Solutions

Oracle® Database 10g Insider Solutions

Arun Kumar R., John Kanagaraj, Richard Stroupe
MySQL and mSQL

MySQL and mSQL

Tim King, George Reese, Randy Yarger
Jump Start MySQL

Jump Start MySQL

Timothy Boronczyk

Publisher Resources

ISBN: 0672323923Purchase book