Enter password: ***********
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 5.5.15 MySQL Community Server (GPL)
Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle 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> select version(),current_date();
+-----------+----------------+
| version() | current_date() |
+-----------+----------------+
| 5.5.15 | 2011-11-06 |
+-----------+----------------+
1 row in set (0.02 sec)
mysql> select (20+5)*4;
+----------+
| (20+5)*4 |
+----------+
| 100 |
+----------+
1 row in set (0.00 sec)
mysql> select sin(pi()/3);
+--------------------+
| sin(pi()/3) |
+--------------------+
| 0.8660254037844386 |
+--------------------+
1 row in set (0.02 sec)
mysql> select
-> user()
-> ,
-> now()
-> ;
+----------------+---------------------+
| user() | now() |
+----------------+---------------------+
| root@localhost | 2011-11-06 00:05:46 |
+----------------+---------------------+
1 row in set (0.00 sec)
mysql> select user(); select now();
+----------------+
| user() |
+----------------+
| root@localhost |
+----------------+
1 row in set (0.00 sec)
+---------------------+
| now() |
+---------------------+
| 2011-11-06 00:06:13 |
+---------------------+
1 row in set (0.00 sec)
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| sakila |
| test |
| world |
+--------------------+
6 rows in set (0.00 sec)
mysql> use mysql
Database changed
mysql> show tables;
+---------------------------+
| Tables_in_mysql |
+---------------------------+
| columns_priv |
| db |
| event |
| func |
| general_log |
| help_category |
| help_keyword |
| help_relation |
| help_topic |
| host |
| ndb_binlog_index |
| plugin |
| proc |
| procs_priv |
| proxies_priv |
| servers |
| slow_log |
| tables_priv |
| time_zone |
| time_zone_leap_second |
| time_zone_name |
| time_zone_transition |
| time_zone_transition_type |
| user |
+---------------------------+
24 rows in set (0.06 sec)
mysql> select * from db;
Empty set (0.00 sec)
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| sakila |
| test |
| world |
+--------------------+
6 rows in set (0.00 sec)
mysql> create database abccs;
Query OK, 1 row affected (0.00 sec)
mysql> use abccs
Database changed
mysql> show tables;
Empty set (0.00 sec)
mysql> create table mytable(name varchar(10),sex char(1), qq varchar(15));
Query OK, 0 rows affected (0.21 sec)
mysql> show tables;
+-----------------+
| Tables_in_abccs |
+-----------------+
| mytable |
+-----------------+
1 row in set (0.00 sec)
mysql> describe mytable
-> ;
+-------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------+-------------+------+-----+---------+-------+
| name | varchar(10) | YES | | NULL | |
| sex | char(1) | YES | | NULL | |
| qq | varchar(15) | YES | | NULL | |
+-------+-------------+------+-----+---------+-------+
3 rows in set (0.10 sec)
mysql> select *from mytable;
Empty set (0.00 sec)
mysql> insert into mytable
-> values('mayadong', 'm', '1033826629');
Query OK, 1 row affected (0.08 sec)
mysql> select * from mytable;
+----------+------+------------+
| name | sex | qq |
+----------+------+------------+
| mayadong | m | 1033826629 |
+----------+------+------------+
1 row in set (0.00 sec)
mysql> insert into mytable
-> values('a', 'f', '1')
-> ;
Query OK, 1 row affected (0.08 sec)
mysql> insert into mytable
-> values('b', 'm', '2');
Query OK, 1 row affected (0.03 sec)
mysql> insert into mytable
-> values('c', 'f', '3');
Query OK, 1 row affected (0.03 sec)
mysql> select * from mytable;
+----------+------+------------+
| name | sex | qq |
+----------+------+------------+
| mayadong | m | 1033826629 |
| a | f | 1 |
| b | m | 2 |
| c | f | 3 |
+----------+------+------------+
4 rows in set (0.00 sec)
mysql> select * from mytable;
+----------+------+------------+
| name | sex | qq |
+----------+------+------------+
| mayadong | m | 1033826629 |
| a | f | 1 |
| b | m | 2 |
| c | f | 3 |
+----------+------+------------+
4 rows in set (0.00 sec)
mysql> update mytable set qq = "0" where name = "mayadong"
-> ;
Query OK, 1 row affected (0.06 sec)
Rows matched: 1 Changed: 1 Warnings: 0
mysql> select * from mytable;
+----------+------+------+
| name | sex | qq |
+----------+------+------+
| mayadong | m | 0 |
| a | f | 1 |
| b | m | 2 |
| c | f | 3 |
+----------+------+------+
4 rows in set (0.00 sec)
mysql> select * from mytable where name = "mayadong";
+----------+------+------+
| name | sex | qq |
+----------+------+------+
| mayadong | m | 0 |
+----------+------+------+
1 row in set (0.00 sec)
mysql> select name from mytable;
+----------+
| name |
+----------+
| mayadong |
| a |
| b |
| c |
+----------+
4 rows in set (0.00 sec)
mysql> insert into mytable
-> values('d', 'm', '2');
Query OK, 1 row affected (0.08 sec)
mysql> select * from mytable;
+----------+------+------+
| name | sex | qq |
+----------+------+------+
| mayadong | m | 0 |
| a | f | 1 |
| b | m | 2 |
| c | f | 3 |
| d | m | 2 |
+----------+------+------+
5 rows in set (0.00 sec)
mysql> select * from mytable where sex = 'm' and qq = '2';
+------+------+------+
| name | sex | qq |
+------+------+------+
| b | m | 2 |
| d | m | 2 |
+------+------+------+
2 rows in set (0.02 sec)
mysql> select name, qq from mytable;
+----------+------+
| name | qq |
+----------+------+
| mayadong | 0 |
| a | 1 |
| b | 2 |
| c | 3 |
| d | 2 |
+----------+------+
5 rows in set (0.00 sec)
mysql> select * from mytable order by name;
+----------+------+------+
| name | sex | qq |
+----------+------+------+
| a | f | 1 |
| b | m | 2 |
| c | f | 3 |
| d | m | 2 |
| mayadong | m | 0 |
+----------+------+------+
5 rows in set (0.03 sec)
mysql> select * from mytable order by name desc;
+----------+------+------+
| name | sex | qq |
+----------+------+------+
| mayadong | m | 0 |
| d | m | 2 |
| c | f | 3 |
| b | m | 2 |
| a | f | 1 |
+----------+------+------+
5 rows in set (0.00 sec)
mysql> select count(*) from mytable;
+----------+
| count(*) |
+----------+
| 5 |
+----------+
1 row in set (0.03 sec)
mysql> select sex, count(*) from mytable group by sex;
+------+----------+
| sex | count(*) |
+------+----------+
| f | 2 |
| m | 3 |
+------+----------+
2 rows in set (0.07 sec)
mysql> create table title(writer varchar(20) not null,
-> title varchar(40) not null,
-> senddate date);
Query OK, 0 rows affected (0.07 sec)
mysql> select * from title;
Empty set (0.00 sec)