undcemcs02> mysql -h undcsmysql.mysql.database.azure.com -u userid -p
Enter password: **********
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2140
Server version: 5.1.73 Source distribution
Copyright (c) 2000, 2012, MySQL and/or its affiliates.
All rights reserved. MySQL is a registered trademark of
MySQL Corporation and/or its
affiliates. Other names may be trademarks of their
respective owners.
Type 'help;' or '\h' for help. Type '\c' to clear the
current input statement.
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| wenchen |
+--------------------+
2 rows in set (0.00 sec)
mysql> -- Comment: wenchen is the instructor’s database
mysql> use wenchen;
Database changed
mysql> DROP TABLE IF EXISTS student3;
Query OK, 0 row affected (0.234 sec)
mysql> CREATE TABLE student3 (
-> name VARCHAR(32) PRIMARY KEY,
-> city VARCHAR(16) NOT NULL,
-> country VARCHAR(16) NOT NULL );
Query OK, 0 rows affected (0.219 sec)
mysql> INSERT INTO student3 VALUES ( 'Alfreds Futterkiste', 'Berlin', 'Germany' );
Query OK, 1 row affected (0.141 sec)
mysql> INSERT INTO student3 VALUES ( 'Berglunds snabbköp', 'Luleå', 'Sweden' );
Query OK, 1 row affected (0.141 sec)
mysql> INSERT INTO student3 VALUES ( 'Centro comercial Moctezuma', 'México D.F.', 'Mexico' );
Query OK, 1 row affected (0.141 sec)
mysql> INSERT INTO student3 VALUES ( 'Ernst Handel', 'Graz', 'Austria' );
Query OK, 1 row affected (0.141 sec)
mysql> INSERT INTO student3 VALUES ( 'FISSA Fabrica Inter. Salchichas', 'Madrid', 'Spain' );
Query OK, 1 row affected (0.141 sec)
mysql> SELECT * FROM student3;
+---------------------------------+-------------+-----------+
| name | city | country |
+---------------------------------+-------------+-----------+
| Alfreds Futterkiste | Berlin | Germany |
| Berglunds snabbköp | Luleå | Sweden |
| Centro comercial Moctezuma | Mexico D.F. | Mexico |
| Ernst Handel | Graz | Austria |
| FISSA Fabrica Inter. Salchichas | Madrid | Spain |
+---------------------------------+-------------+-----------+
5 rows in set (0.031 sec)
mysql> commit;
Query OK, 0 rows affected (0.00 sec)
mysql> exit;
Bye
undcemcs02>
|