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

Creating, Dropping, and Selecting a Database

Now that you have seen how to use MySQL's basic client tools, it's time to start putting them to use. You will first use them as you learn how to create a database and then go on to do other kinds of database manipulation.

Creating and dropping a database is something that you may seldom do, except during the design phase of a project, yet the ways of doing these things are important for you to grasp. As you will see, there are often two or more ways to do the same thing, so you will learn both the SQL and the client-driven ways to manipulate databases.

Creating a Database

To create a database from a Unix console, use the mysqladmin command with the following format:

mysqladmin create database_name ...
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