Use MySQL with Python by m. MOka

Author:m. MOka [MOka, m.]
Language: eng
Format: azw3, epub
Published: 2016-03-22T16:00:00+00:00

Creating databases

Creating a database in MySQL is as simple as declaring the name of the database that you want to create. The syntax reads: CREATE DATABASE <database name>;

An example of this is:

CREATE DATABASE csv;

As with all SQL statements, blank space is the token by which the command is divided. We first need to tell MySQL that we want to create something by using that keyword. Then we need to tell it what we want to create, a database. Finally, we give it the name of the database followed by the requisite semi-colon (when in MySQL itself).

Note that, in order to create databases in MySQL, the account you use must have the CREATE privilege on the database. CREATE statements are also sensitive to user privileges. If a user is only granted CREATE privileges on a single database (for example, csv.*), then that user cannot create databases, but can create tables on that specific database.

Unlike some commands in MySQL, database creation is case-sensitive. So the following CREATE statements each create a different database: CREATE DATABASE csv;

CREATE DATABASE Csv;

CREATE DATABASE CSV;

CREATE DATABASE C_S_V;;

Whether the CREATE DATABASE statement is case-sensitive ultimately depends on the filesystem and configuration of your server. Unix-based systems are usually case-sensitive by default. However, Windows and Mac servers may not be.

While Mac OS X is derived from Unix, it uses the HFS+ filesystem. So database names are not case-sensitive by default. To add the case sensitivity feature for Mac OS X, one would need to use the UFS filesystem.

To configure MySQL for case-sensitivity when it is not the default, you need to set the variable lower_case_table_names. More information on that variable can be found at:

http://dev.mysql.com/doc/refman/5.5/en/server-systemvariables.html#sysvar_lower_case_table_names

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.