27 января 2011, 12:29

Mysql show create

mysql> show create database AAA;
+----------+-----------------------------------------------------------------------------------+
| Database | Create Database                                                                   |
+----------+-----------------------------------------------------------------------------------+
| AAA      | CREATE DATABASE `AAA` /*!40100 DEFAULT CHARACTER SET cp1251 COLLATE cp1251_bin */ |
+----------+-----------------------------------------------------------------------------------+
1 row in set (0.00 sec)

mysql> show create table charset_test2;
+---------------+------------------------------------------------------------------------------+
| Table         | Create Table                                                                 |
+---------------+------------------------------------------------------------------------------+
| charset_test2 | CREATE TABLE `charset_test2` (
  `str` varchar(20) collate cp1251_bin default NULL,
  `str2` varchar(20) character set cp1251 default NULL
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 COLLATE=cp1251_bin |
+---------------+------------------------------------------------------------------------------+
1 row in set (0.00 sec)

Ваш комментарий

адрес не будет опубликован

ХТМЛ не работает


Ctrl + Enter