GNU/Linux Desktop Survival Guide by Graham Williams
Desktop Survival Project Home Preface Advocacy History Distributions Installing GNU/Linux Basic Survival Wajig Applications AI, Machine Learning, Data Science Android - GNU/Linux Devices Audio Backup Booting CD Chinese ChRoot Clock Command Line Databases DIA Directories Disks EcoSysL Emacs Email Evolution Files File Systems Firewalls Floppy Disks FreedomBox Glade GNOME Graphics, Images, Photos Hardware Initialisations on Booting Installation Examples Internet IOT Java KDE Kernels Keyboard Konqueror KVM Switch LATEX Log System Login Magellan MATE Mathematics Memory Modems Mounting Devices MS/Windows Music MySQL Nautilus Networks Nextcloud Network File System NFS NT File System Oracle Packages Partitions Passwords PDF Power Management PPP Presentations Printing Python R Remote Desktops Rsync Samba Scanning Science Screens Security Spreadsheet SSH Swap Teradata Data Warehouse Themes TV Unity USB Version Control Video Virtualization Voice over IP WebCam WordPress Web Sites Word Processing and Printing X XML Troubleshooting Index

CLICK HERE TO VISIT THE UPDATED SURVIVAL GUIDE

Creating New Database

Create a new database called nhds (National Hospital Discharge Suvery). The sample data we use comes from http://www.cdc.gov/nchs/.

  $ mysql -u root -p mysql
  Password: 

  mysql> CREATE DATABASE nhds;

The data to populate a new table we will create is stored in the file nhds99.data as comma separated values. We can write a simple script to create the table and import the data. The script is called nhds99.sql:

USE nhds;

CREATE TABLE nhds99 (
svy_year        int,
newborn         char(1),
age_unit        char(1),
age             int,
sex             char(1),
race            char(1),
m_status        char(1),
dis_month       int,
dis_status      char(1),
days_care       int,
los_flag        char(1),
geo_region      char(1),
no_beds         char(1),
hos_ownership   char(1),
ana_weight      int,
dc1             char(5),
dc2             char(5),
dc3             char(5),
dc4             char(5),
dc5             char(5),
dc6             char(5),
dc7             char(5),
pc1             char(4),
pc2             char(4),
pc3             char(4),
pc4             char(4),
p_src_payment   char(2),
s_src_payment   char(2),
drg             char(3));

LOAD DATA 
     LOCAL INFILE 'nhds99.data' 
     INTO TABLE nhds99 
     FIELDS TERMINATED BY ',';

Then simply run it through mysql:

  $ mysql -u root -p nhds < nhds99.sql

You can remove the table from the database with:

  $ mysql -u root -p nhds
  mysql> DROP TABLE nhds99;

Using mysql-navigator you can not currently create new databases (except by running an external script) but you can create tables. You can also run SQL scripts. So create your database for nhds as above. Then start up the navigator and open root@localhost. Then under the MySQL menu choose Script. Identify the script and a log file then Fire. The new table should then appear under the nhds database.

With the navigator you can even edit the script files with the Edit item in the MySQL menu.