Форум пользователей MySQL

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

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> showdatabases;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'showd
atabases' at line 1
mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| database2010       |
| mysql              |
| test               |
+--------------------+
4 rows in set (0.02 sec)

mysql> use database2010;
Database changed
mysql> show reate table karta;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'reate
 table karta' at line 1
mysql> show reate table 'karta';
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'reate
 table 'karta'' at line 1
mysql> show create table 'karta';
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near ''kart
a'' at line 1
mysql> show create table karta;
+-------+-----------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------+
| Table | Create Table






                                                                          |
+-------+-----------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------+
| karta | CREATE TABLE `karta` (
  `id_Nomer` smallint(5) unsigned NOT NULL,
  `id_Date` text NOT NULL,
  `id_Time` text NOT NULL,
  `id_NomerIBM` text NOT NULL,
  `id_FPolizovatel` text NOT NULL,
  `id_IPolizovatel` text NOT NULL,
  `id_OPolizovatel` text NOT NULL,
  `id_OtdelPolizovatelja` text NOT NULL,
  `id_VidRabot` text NOT NULL,
  `id_Opicanie` text NOT NULL,
  `id_ChtoCdelano1` text,
  `id_Neicpravnocti` text NOT NULL,
  `id_ChtoCdelano2` text,
  `id_Prichina` text,
  `id_Podrobnocti` text,
  `id_KtoCdelal` text NOT NULL,
  `id_Vipolnenie` text NOT NULL,
  `id_put_file` tinytext
) ENGINE=InnoDB DEFAULT CHARSET=cp1251 |
+-------+-----------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------+
1 row in set (0.00 sec)

mysql> show show variables lik '%char%';
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'show
variables lik '%char%'' at line 1
mysql> show variables lik '%char%';
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'lik '
%char%'' at line 1
mysql> show variables like '%char%';
+--------------------------+--------------------------------------------+
| Variable_name            | Value                                      |
+--------------------------+--------------------------------------------+
| character_set_client     | latin1                                     |
| character_set_connection | latin1                                     |
| character_set_database   | cp1251                                     |
| character_set_filesystem | binary                                     |
| character_set_results    | latin1                                     |
| character_set_server     | cp1251                                     |
| character_set_system     | utf8                                       |
| character_sets_dir       | C:\Server\MySQL Server 5.0\share\charsets\ |
+--------------------------+--------------------------------------------+
8 rows in set (0.00 sec)

mysql> set names cp1251;
Query OK, 0 rows affected (0.00 sec)

mysql> show variables like '%char%';
+--------------------------+--------------------------------------------+
| Variable_name            | Value                                      |
+--------------------------+--------------------------------------------+
| character_set_client     | cp1251                                     |
| character_set_connection | cp1251                                     |
| character_set_database   | cp1251                                     |
| character_set_filesystem | binary                                     |
| character_set_results    | cp1251                                     |
| character_set_server     | cp1251                                     |
| character_set_system     | utf8                                       |
| character_sets_dir       | C:\Server\MySQL Server 5.0\share\charsets\ |
+--------------------------+--------------------------------------------+
8 rows in set (0.00 sec)

mysql> show create table karta;
+-------+-----------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------+
| Table | Create Table






                                                                          |
+-------+-----------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------+
| karta | CREATE TABLE `karta` (
  `id_Nomer` smallint(5) unsigned NOT NULL,
  `id_Date` text NOT NULL,
  `id_Time` text NOT NULL,
  `id_NomerIBM` text NOT NULL,
  `id_FPolizovatel` text NOT NULL,
  `id_IPolizovatel` text NOT NULL,
  `id_OPolizovatel` text NOT NULL,
  `id_OtdelPolizovatelja` text NOT NULL,
  `id_VidRabot` text NOT NULL,
  `id_Opicanie` text NOT NULL,
  `id_ChtoCdelano1` text,
  `id_Neicpravnocti` text NOT NULL,
  `id_ChtoCdelano2` text,
  `id_Prichina` text,
  `id_Podrobnocti` text,
  `id_KtoCdelal` text NOT NULL,
  `id_Vipolnenie` text NOT NULL,
  `id_put_file` tinytext
) ENGINE=InnoDB DEFAULT CHARSET=cp1251 |
+-------+-----------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------+
1 row in set (0.00 sec)

mysql>