mysql bug

1 отговора 304 прегледа
#1

mysql bug

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>

Отговор
в отговор на sqli #2

expected result?

Какво нередно виждаш в това, което става?

Everything louder than everything else...
Отговор