Creating a database in MySQL
CREATE DATABASE mydb;
Return value:
Query OK, 1 row affected (0.05 sec)
Using the created database mydb
USE mydb;
Return value:
Database Changed
Creating a table in MySQL
CREATE TABLE mytable
(
id int unsigned NOT NULL auto_increment,
username varchar(100) NOT NULL,
email varchar(100) NOT NULL,
PRIMARY KEY (id)
);
CREATE TABLE mytable
will create a new table called mytable
.
id int unsigned NOT NULL auto_increment
creates the id
column, this type of field will assign a unique numeric ID to each record in the table (meaning that no two rows can have the same id
in this case), MySQL will automatically assign a new, unique value to the record’s id
field (starting with 1).
Return value:
Query OK, 0 rows affected (0.10 sec)
Inserting a row into a MySQL table
INSERT INTO mytable ( username, email )
VALUES ( "myuser", "[email protected]" );
Example return value:
Query OK, 1 row affected (0.06 sec)
The varchar
a.k.a strings
can be also be inserted using single quotes:
INSERT INTO mytable ( username, email )
VALUES ( 'username', '[email protected]' );