To install MySQL database software click on this link. Download the latest version depending on your operation system. For example Linux Ubuntu user can download and install the version directly from Ubuntu libraries. Use the default setting unless you have done it before too and you know that your customization would not cause any problems. During the installation process the MySQL database software will ask you to enter root user password. Do not loose it or it will be quite difficult to reset. In addition you don not need a mysql hosting server to try the database it works on your computer without problems.
The next database software we are going to download and install is MySQL Workbench. This database software helps you to connect with MySQL database in more easier and visual way. Through all the examples we will use the same software. After executing the MySQL Workbench database software you should see a program as on the following picture.
To connect with your MySQL database use the “New Connection” button and if you have MySQL database installed then the installation Wizard should show you database details and you have left to enter your password you did set above for your root user. If the Wizard tool does not show any details then you can try to set to Hostname text box “127.0.0.1” and Port should be by default “3306“. If you didn’t set any other user name then default user should be “root“. See the following picture.
To continue press “OK” button and the database connection will open with the default “Test” schema. Through this examples we would not change the schema name, but it is recommended to create a new schema that’s name reflecting to the data group you will store in it.
To create a new table open your schema link and right click on the “Tables” link. Fill in the Mysql table details for example as on the following picture.
Press on the “Apply” button to continue the MySQL database software will show you the table script and it ask confirmation to execute it. Through all our examples use this script in the MySQL sql windows and create the table.
delimiter $$ CREATE TABLE `customers` ( `id` int(11) NOT NULL DEFAULT '0', `surname` varchar(500) NOT NULL, `forename` varchar(500) NOT NULL, `birth_date` date NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Customers'$$
Now insert into the MySQL table the following lines using the next script.
INSERT INTO `test`.`customers` (`id`, `surname`, `forename`, `birth_date`) VALUES (1, 'John', 'Sea', '1980-01-19'); INSERT INTO `test`.`customers` (`id`, `surname`, `forename`, `birth_date`) VALUES (2, 'Emma', 'Nice', '1971-02-21'); INSERT INTO `test`.`customers` (`id`, `surname`, `forename`, `birth_date`) VALUES (3, 'Sean', 'Willems', '1982-12-01');
The next steps are to take a look at our examples. We do recomment to start with the MySQL Select statement.