Enter password: ***
Welcome to the MySQL monitor.  Commands end with ' ; ' or ' \g'.
Your MySQL connection id is 2
Server version: 6.0.8-alpha-community MySQL Community Server (GPL)
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
Добро пожаловать в монитор MySQL. Команды заканчиваются ; или \g.
Ваше подключение MySQL id 2
Версия сервера: Сервер Сообщества MySQL (GPL)
Введите  'help;' или '\h' для получения справки. Для очистки буфера введите '\c'.
 
mysql> \h
 
For information about MySQL products and services, visit:
            http://www.mysql.com/
            For developer information, including the MySQL Reference Manual, visit:
            http://dev.mysql.com/
            To buy MySQL Network Support, training, or other products, visit:
            https://shop.mysql.com/
List of all MySQL commands:
            Note that all text commands must be first on line and end with ';'
            ?         (\?) Synonym for `help'.   Справка
            clear     (\c) Clear command.
            connect   (\r) Reconnect to the server. Optional arguments are db and host.
            delimiter (\d) Set statement delimiter. NOTE: Takes the rest of the line as new
            delimiter.
            ego       (\G) Send command to mysql server, display result vertically.
                           отобразить результат вертикально.
            exit      (\q) Exit mysql. Same as quit.     Выход из mysql. То же самое, что и quit.
            go        (\g) Send command to mysql server.
            help      (\h) Display this help.
            notee     (\t) Don't write into outfile.
            print     (\p) Print current command.
            prompt    (\R) Change your mysql prompt.
            quit      (\q) Quit mysql.
            rehash    (\#) Rebuild completion hash.
            source    (\.) Execute an SQL script file. Takes a file name as an argument.
            status    (\s) Get status information from the server.
            tee       (\T) Set outfile [to_outfile]. Append everything into given outfile.
            use       (\u) Use another database. Takes database name as argument.
            charset   (\C) Switch to another charset. Might be needed for processing binlog
                             with multi-byte charsets.
            warnings  (\W) Show warnings after every statement.
            nowarning (\w) Don't show warnings after every statement.
For server side help, type 'help contents'
mysql>
 

 
Enter password: ***
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 4
Server version: 6.0.8-alpha-community MySQL Community Server (GPL)
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
 
mysql>  use mysql
Database changed
 
mysql> show tables;
+---------------------------+
| Tables_in_mysql           |
+---------------------------+
| backup_history            |
| backup_progress           |
| columns_priv              |
| db                        |
| event                     |
| func                      |
| general_log               |
| help_category             |
| help_keyword              |
| help_relation             |
| help_topic                |
| host                      |
| ndb_binlog_index          |
| plugin                    |
| proc                      |
| procs_priv                |
| servers                   |
| slow_log                  |
| tables_priv               |
| time_zone                 |
| time_zone_leap_second     |
| time_zone_name            |
| time_zone_transition      |
| time_zone_transition_type |
| user                      |
+---------------------------+
25 rows in set (0.25 sec)

mysql>   
        

 
Enter password: ***
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 6.0.8-alpha-community MySQL Community Server (GPL)
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
 
mysql> use information_schema;
Database changed
 

mysql> show tables;
+---------------------------------------+
| Tables_in_information_schema          |
+---------------------------------------+
| CHARACTER_SETS                        |
| COLLATIONS                            |
| COLLATION_CHARACTER_SET_APPLICABILITY |
| COLUMNS                               |
| COLUMN_PRIVILEGES                     |
| ENGINES                               |
| EVENTS                                |
| FILES                                 |
| GLOBAL_STATUS                         |
| GLOBAL_VARIABLES                      |
| KEY_COLUMN_USAGE                      |
| PARAMETERS                            |
| PARTITIONS                            |
| PLUGINS                               |
| PROCESSLIST                           |
| PROFILING                             |
| REFERENTIAL_CONSTRAINTS               |
| ROUTINES                              |
| SCHEMATA                              |
| SCHEMA_PRIVILEGES                     |
| SESSION_STATUS                        |
| SESSION_VARIABLES                     |
| STATISTICS                            |
| TABLES                                |
| TABLESPACES                           |
| TABLE_CONSTRAINTS                     |
| TABLE_PRIVILEGES                      |
| TRIGGERS                              |
| USER_PRIVILEGES                       |
| VIEWS                                 |
| FALCON_RECORD_CACHE_SUMMARY           |
| FALCON_SYSTEM_MEMORY_DETAIL           |
| FALCON_TABLESPACE_IO                  |
| FALCON_SYSTEM_MEMORY_SUMMARY          |
| FALCON_VERSION                        |
| FALCON_TRANSACTION_SUMMARY            |
| FALCON_SERIAL_LOG_INFO                |
| FALCON_SYNCOBJECTS                    |
| FALCON_TRANSACTIONS                   |
| FALCON_RECORD_CACHE_DETAIL            |
+---------------------------------------+
40 rows in set (0.02 sec)

mysql>
        

        
Enter password: ***
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 6.0.8-alpha-community MySQL Community Server (GPL)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
 
mysql>  SHOW DATABASES;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| test               |
+--------------------+
3 rows in set (0.00 sec)
 
mysql>  Use test;
Database changed
 
mysql>  SHOW TABLES;
+----------------+
| Tables_in_test |
+----------------+
| test           |
+----------------+
1 row in set (0.01 sec)
 
mysql> CREATE TABLE test (
       date DATE, 
       time DATE, 
       ipaddress VARCHAR(20), 
       prishel CHAR(200), 
       prosmotpel CHAR(200));
Query OK, 0 rows affected (0.02 sec)
 
mysql>  DESCRIBE test;
+------------+-------------+------+-----+---------+-------+
| Field      | Type        | Null | Key | Default | Extra |
+------------+-------------+------+-----+---------+-------+
| date       | date        | YES  |     | NULL    |       |
| time       | date        | YES  |     | NULL    |       |
| ipaddress  | varchar(20) | YES  |     | NULL    |       |
| prishel    | char(200)   | YES  |     | NULL    |       |
| prosmotpel | char(200)   | YES  |     | NULL    |       |
+------------+-------------+------+-----+---------+-------+
5 rows in set (0.01 sec)
  

  
mysql>  ALTER TABLE test CHANGE time time TIME; 
Query OK, 0 rows affected (0.09 sec)
Records: 0  Duplicates: 0  Warnings: 0
 

mysql>  DESCRIBE test;
+------------+-------------+------+-----+---------+-------+
| Field      | Type        | Null | Key | Default | Extra |
+------------+-------------+------+-----+---------+-------+
| date       | date        | YES  |     | NULL    |       |
| time       | time        | YES  |     | NULL    |       |
| ipaddress  | varchar(20) | YES  |     | NULL    |       |
| prishel    | char(200)   | YES  |     | NULL    |       |
| prosmotpel | char(200)   | YES  |     | NULL    |       |
+------------+-------------+------+-----+---------+-------+
5 rows in set (0.01 sec)


        

 

Enter password: ***
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 7
Server version: 6.0.8-alpha-community MySQL Community Server (GPL)
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
 
mysql>  SHOW FULL PROCESSLIST;
+----+------+-----------------+------+---------+------+-------+-----------------------+
| Id | User | Host            | db   | Command | Time | State | Info                  |
+----+------+-----------------+------+---------+------+-------+-----------------------+
|  7 | root | localhost:50407 | NULL | Query   |    0 | NULL  | SHOW FULL PROCESSLIST |
+----+------+-----------------+------+---------+------+-------+-----------------------+
1 row in set (0.00 sec)

mysql>
 

 
Enter password: ***
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 6.0.8-alpha-community MySQL Community Server (GPL)
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
 
mysql>  Use test;
Database changed
 
mysql>  DESCRIBE test;
+------------+-------------+------+-----+---------+-------+
| Field      | Type        | Null | Key | Default | Extra |
+------------+-------------+------+-----+---------+-------+
| date       | date        | YES  |     | NULL    |       |
| time       | time        | YES  |     | NULL    |       |
| ipaddress  | varchar(20) | YES  |     | NULL    |       |
| prishel    | char(200)   | YES  |     | NULL    |       |
| prosmotpel | char(200)   | YES  |     | NULL    |       |
+------------+-------------+------+-----+---------+-------+
5 rows in set (0.00 sec)
 
mysql> INSERT INTO test VALUES ('1999-03-30', '19:03:30', '110.175.131', '/php01_523.shtml
', '/sitemap.shtml');
Query OK, 1 row affected (0.01 sec)
 
mysql> select * from test;
+------------+----------+-------------+------------------+----------------+
| date       | time     | ipaddress   | prishel          | prosmotpel     |
+------------+----------+-------------+------------------+----------------+
| 1999-03-30 | 19:03:30 | 110.175.131 | /php01_523.shtml | /sitemap.shtml |
+------------+----------+-------------+------------------+----------------+
1 row in set (0.00 sec)
 
mysql> exit
        

  
mysql>  delete from test;
Query OK, 53 rows affected (0.00 sec)
 
mysql>  DESCRIBE test;
+------------+-------------+------+-----+---------+-------+
| Field      | Type        | Null | Key | Default | Extra |
+------------+-------------+------+-----+---------+-------+
| date       | date        | YES  |     | NULL    |       |
| time       | time        | YES  |     | NULL    |       |
| ipaddress  | varchar(20) | YES  |     | NULL    |       |
| prishel    | char(200)   | YES  |     | NULL    |       |
| prosmotpel | char(200)   | YES  |     | NULL    |       |
+------------+-------------+------+-----+---------+-------+
5 rows in set (0.01 sec)