Tutorial Addendum on SQL - Addition to MySQL

This affiliate describes:

    

    
• What s in MySQL?
  
      



    
• How to use the SQL applicant apparatus - mysql.
  
      



    
• How to dump data into files.
  
      



    
• How to amount data from files aback to tables.
  
      



    

What s in MySQL?

    

Programs and accoutrement offered in MySQL:

    

    
• mysqld - MySQL server daemon.
  
      



    
• mysqladmin - Ambassador tool, command band based.
  
      



    
• mysql - SQL applicant tool, command band based.
  
      



    
• mysqlimport - Apparatus to amount data into tables from argument files.
  
      



    
• mysqldump - Apparatus to dump data of the an absolute database.
  
      



    
• mysqlcheck - Apparatus to analysis and adjustment databases.
  
      



    
• mysqlmanager - SQL applicant tool, GUI based.
  
      



    

Using the SQL Applicant Apparatus - mysql

    

mysql is actual simple to use:

    

    
• To barrage mysql, run "mysqlinmysql --host hostName databaseName".
  
      



    
• To run any SQL statement, access "sqlStatement;". The endure character,
  
      

  ";", triggers mysql to assassinate the account on the server.
  
      



    
• To abdicate from mysql, access "quit".
  
      



    
• To get help, access "help".
  
      



    

In the afterward example, I accomplished 4 SQL statements with mysql:

    

 

    
mysqlinmysql --host localhost test

    
......

    
mysql> make table accost (message varchar(80));

    
Query OK, 0 rows afflicted (0.41 sec)

    
mysql> admit into accost (message) ethics ( Accost world! );

    
Query OK, 1 row afflicted (0.03 sec)

    
mysql> baddest * from hello;

    
+--------------+

    
| bulletin      |

    
+--------------+

    
| Accost world! |

    
+--------------+

    
1 row in set (0.00 sec)

    
mysql> bead table hello;

    
Query OK, 0 rows afflicted (0.00 sec)

    
mysql> quit

    
Bye

    

Note that:

    

    
• The official name of mysql is MySQL Monitor.
  
      



    
• mysql letters you aback on the beheading time of anniversary statement.
  
      



    
• Result of the Baddest account is accurately formatted.
  
      



    

In the antecedent example, SQL statements were accomplished interactively one by one.

    

Another way to assassinate SQL statements is to put them into a file, and assassinate them

    

in one command. First let s all the statements we acclimated in the antecedent into a file,

    

hello.sql:

    

 

    
-- hello.sql

    
-- Absorb (c) 1999 by Dr.  Yang

    
--

    
create table accost (message varchar(80));

    
insert into accost (message) ethics ( Accost world! );

    
select * from hello;

    
drop table hello;