We must have to use proper names while giving any SQL command. NOTE: All the database names, table names, and table field names are case sensitive. Here, we are going to create a database name "employeedb" using the following statement: Open the MySQL console and write down the password, if we have set during installation. Let us understand how to create a database in MySQL with the help of an example. It is optional that compares characters in a particular character set. If we do not provide this in the statement, MySQL takes the default character set. MySQL database server supports many character sets. It is the name of the character set to store every character in a string. The IF NOT EXIST clause avoids an error when we create a database that already exists. It is the name of a new database that should be unique in the MySQL server instance. The parameter descriptions of the above syntax are as follows: Parameter
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |