MySQL Setup<\/h1>\n\n- The raw data for the tutorial is on my github here<\/a>.<\/li>\n
- MySQL Installer :\u00a0https:\/\/dev.mysql.com\/downloads\/mysql\/<\/a><\/li>\n
- MySQL Workbench Installer :\u00a0https:\/\/dev.mysql.com\/downloads\/workbench\/<\/a><\/li>\n<\/ul>\n
Connecting to the Database<\/h2>\n
Open MySQL Workbench. Click Database -> Connect to Database<\/span><\/p>\n![\"Connect](\"http:\/\/technicalelvis.com\/blog\/wp-content\/uploads\/2017\/10\/workbench_connect_to_database-300x174.png\")
Connect to a MySQL Database via Menu<\/figcaption><\/figure>\nThe local MySQL server should be running on Hostname: 127.0.0.1 and Port 3306. Your hostname or IP address may be different if you are connecting to another host running MySQL. Click on \u201cPassword\u201d to enter the password generated during installation.<\/span><\/p>\n![\"Enter](\"http:\/\/technicalelvis.com\/blog\/wp-content\/uploads\/2017\/10\/workbench_connect_to_db_ip_password-300x129.png\")
Enter IP and Password for MySQL database.<\/figcaption><\/figure>\nSave the password here:<\/span><\/p>\n![\"Save](\"http:\/\/technicalelvis.com\/blog\/wp-content\/uploads\/2017\/10\/workbench_save_password-300x158.png\")
Save your password (MacOS)<\/figcaption><\/figure>\nNow that you connected to the server, list the installed databases using.<\/p>\n
SHOW SCHEMAS<\/code><\/pre>\nYou should see the following output similar to this:<\/span><\/p>\n![\"MySQL](\"http:\/\/technicalelvis.com\/blog\/wp-content\/uploads\/2017\/10\/workbench_show_schema-300x92.png\")
MySQL Workbench Output of Show Schema<\/figcaption><\/figure>\nCreating the Diabetes Database<\/span><\/h2>\nIn MySQL workbench, execute \u201ccreate_diabetes_db.sql\u201d using \u201cFile -> Open SQL Script\u201d.<\/span><\/p>\n![\""Open](\"http:\/\/technicalelvis.com\/blog\/wp-content\/uploads\/2017\/10\/workbench_open_sql_script-300x161.png\")
\"Open SQL Script\" Menu<\/figcaption><\/figure>\nYou can find this file in my github within the medical_databases\/sql\/ directory<\/a>.<\/p>\n![\"Open](\"http:\/\/technicalelvis.com\/blog\/wp-content\/uploads\/2017\/10\/workbench_open_create_diabetes_db_sql-300x110.png\")
Open \"create_diabetes_db.sql\"<\/figcaption><\/figure>\nOnce the file is open, use Command-A to \u201cSelect ALL\u201d - or (Edit -> Select ALL).<\/span><\/p>\n![\""Select](\"http:\/\/technicalelvis.com\/blog\/wp-content\/uploads\/2017\/10\/workbench_select_all_create_diabetes_sql-300x220.png\")
\"Select All\" SQL in window<\/figcaption><\/figure>\nNow Click the Execute (leftmost lightning bolt) button. The \u201cAction Output\u201d window should show:<\/span><\/p>\n![\"Output](\"http:\/\/technicalelvis.com\/blog\/wp-content\/uploads\/2017\/10\/workbench_create_db_output_window-300x20.png\")
Output from \"create db\" script<\/figcaption><\/figure>\nLoading the Diabetes Data into the Database<\/span><\/h2>\nNow open \u201cdiabetes_data.sql\u201d. Click here to download that file from github<\/a>.<\/span><\/p>\n![\"Open](\"http:\/\/technicalelvis.com\/blog\/wp-content\/uploads\/2017\/10\/workbench_open_diabetes_data_sql-300x92.png\")
Open \"diabetes_data.sql\"<\/figcaption><\/figure>\nOnce the file is open, use Command-A to \u201cSelect ALL\u201d - or (Edit -> Select ALL). This is a big file so you\u2019ll only see the beginning part in the window.<\/span><\/p>\n![\""Select](\"http:\/\/technicalelvis.com\/blog\/wp-content\/uploads\/2017\/10\/workbench_select_all_diabetes_data_sql-300x212.png\")
\"Select All\" Diabetes data SQL<\/figcaption><\/figure>\nNow Click the Execute button (leftmost lightning bolt). The \u201cAction Output\u201d window should show something similar to the output below. There are lot of commands in this file but you should see some \u201cCREATE TABLE\u201d and \u201cINSERTS\u201d statements.<\/span><\/p>\n![\"Output](\"http:\/\/technicalelvis.com\/blog\/wp-content\/uploads\/2017\/10\/workbench_ouput_diabetes_data_sql-300x28.png\")
Output from executing diabetes data SQL<\/figcaption><\/figure>\nNow create a new \u201cQuery Tab\u201d. (File -> New Query Tab) or COMMAND-T then try the query:<\/span><\/p>\nSELECT * FROM patients;<\/span><\/pre>\nThe result grid pane should show something similar to the following.<\/span><\/p>\n![\""SELECT](\"http:\/\/technicalelvis.com\/blog\/wp-content\/uploads\/2017\/10\/workbench_select_star_from_patients-300x62.png\")
\"SELECT * FROM patients\" Output<\/figcaption><\/figure>\n","protected":false},"excerpt":{"rendered":"Introduction This tutorial demonstrates how to use MySQL and MySQL Workbench to create and explore a MYSQL database containing diabetes treatment records. Original Dataset I generated the SQL for this tutorial using the Diabetes Data Set from the UCI Machine Learning Repository. I added a “patients” table using random celebrity names. MySQL Setup The raw … Continue reading Data 101: MySQL Tutorial using a Diabetes Database<\/span>
Connecting to the Database<\/h2>\n
Open MySQL Workbench. Click Database -> Connect to Database<\/span><\/p>\n The local MySQL server should be running on Hostname: 127.0.0.1 and Port 3306. Your hostname or IP address may be different if you are connecting to another host running MySQL. Click on \u201cPassword\u201d to enter the password generated during installation.<\/span><\/p>\n Save the password here:<\/span><\/p>\n Now that you connected to the server, list the installed databases using.<\/p>\n You should see the following output similar to this:<\/span><\/p>\n In MySQL workbench, execute \u201ccreate_diabetes_db.sql\u201d using \u201cFile -> Open SQL Script\u201d.<\/span><\/p>\n You can find this file in my github within the medical_databases\/sql\/ directory<\/a>.<\/p>\n Once the file is open, use Command-A to \u201cSelect ALL\u201d - or (Edit -> Select ALL).<\/span><\/p>\n Now Click the Execute (leftmost lightning bolt) button. The \u201cAction Output\u201d window should show:<\/span><\/p>\n Now open \u201cdiabetes_data.sql\u201d. Click here to download that file from github<\/a>.<\/span><\/p>\n Once the file is open, use Command-A to \u201cSelect ALL\u201d - or (Edit -> Select ALL). This is a big file so you\u2019ll only see the beginning part in the window.<\/span><\/p>\n Now Click the Execute button (leftmost lightning bolt). The \u201cAction Output\u201d window should show something similar to the output below. There are lot of commands in this file but you should see some \u201cCREATE TABLE\u201d and \u201cINSERTS\u201d statements.<\/span><\/p>\n Now create a new \u201cQuery Tab\u201d. (File -> New Query Tab) or COMMAND-T then try the query:<\/span><\/p>\n The result grid pane should show something similar to the following.<\/span><\/p>\n Introduction This tutorial demonstrates how to use MySQL and MySQL Workbench to create and explore a MYSQL database containing diabetes treatment records. Original Dataset I generated the SQL for this tutorial using the Diabetes Data Set from the UCI Machine Learning Repository. I added a “patients” table using random celebrity names. MySQL Setup The raw … Continue reading Data 101: MySQL Tutorial using a Diabetes Database<\/span> SHOW SCHEMAS<\/code><\/pre>\nCreating the Diabetes Database<\/span><\/h2>\n
Loading the Diabetes Data into the Database<\/span><\/h2>\n
SELECT * FROM patients;<\/span><\/pre>\n