April 2008
Intermediate to advanced
566 pages
21h 55m
English
Content preview from MySQL in a Nutshell, 2nd EditionBecome 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,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Name
CREATE DATABASE
Synopsis
CREATE {DATABASE|SCHEMA} [IF NOT EXISTS] database [options]This statement creates a new database with the name given. As
of version 5.0.2 of MySQL, the keyword DATABASE is
synonymous with SCHEMA wherever used in any SQL
statement. You can use the IF NOT EXISTS flag to
suppress an error message when the statement fails if a database with
the same name already exists.
A database name cannot be longer than 64 bytes (not characters)
in size. The system uses Unicode (UTF-8), so any character that is
part of the UTF-8 character set may be used. The name cannot be the
ASCII value of 0 (0x00) or 255
(0xff)—these are reserved. Database names should
not include single or double quotation marks or end with a space. If
you want a database name to include quotes, though, you will have to
enable the SQL mode of ANSI_QUOTES. This can be
done with the --sql-mode server option. As of
version 5.1.6 of MySQL, database names can contain backslashes,
forward slashes, periods, and other characters that may not be
permitted in a directory name at the filesystem level. If you use a
name that is a reserved word, you must always enclose it in quotes
when referring to it.
Special characters in the name are encoded in the filesystem
names. If you upgrade your system to a new version of MySQL and you
have a database that has special characters in its name, the database
will be displayed with a prefix of #mysql50#. For
instance, a database named human-resources will be displayed as ...
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.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.