|
|
| Тема |
 mysql bug |
|
| Автор | sqli (Нерегистриран) | |
| Публикувано | 08.09.05 21:44 |
|
|
|
zashto stava tova!?
mysql> create database foo; use foo;
Query OK, 1 row affected (0.00 sec)
Database changed
mysql> show create database foo;
+----------+----------------------------------------------------------------+
| Database | Create Database |
+----------+----------------------------------------------------------------+
| foo | CREATE DATABASE `foo` /*!40100 DEFAULT CHARACTER SET latin1 */ |
+----------+----------------------------------------------------------------+
1 row in set (0.00 sec)
mysql> create table bar (x varchar(20), y varchar(5));
Query OK, 0 rows affected (0.00 sec)
mysql> show create table bar;
+-------+---------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table |
+-------+---------------------------------------------------------------------------------------------------------------------------+
| bar | CREATE TABLE `bar` (
`x` varchar(20) default NULL,
`y` varchar(5) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 |
+-------+---------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
mysql> status;
--------------
mysql Ver 14.7 Distrib 4.1.8, for pc-linux (i686)
Connection id: 3
Current database: foo
Current user: root@localhost
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server version: 4.1.8-standard
Protocol version: 10
Connection: Localhost via UNIX socket
Server characterset: latin1
Db characterset: latin1
Client characterset: latin1
Conn. characterset: latin1
UNIX socket: /tmp/mysql.sock
Uptime: 2 min 5 sec
Threads: 1 Questions: 15 Slow queries: 0 Opens: 13 Flush tables: 1 Open tables: 1 Queries per second avg: 0.120
--------------
mysql>
| |
| |
| 
|
|
