Enter password: Welcome to the Mysql monitor. Commands end with; or \g


Download 9.13 Kb.
Sana20.10.2023
Hajmi9.13 Kb.
#1713216
Bog'liq
2-kurs dedlayn


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

Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.


This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL v2 license

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| lombard |
| mysql |
| test |
| test2 |
| turist_firm |
+--------------------+
6 rows in set (0.01 sec)

mysql> use malaka_oshirish;


ERROR 1049 (42000): Unknown database 'malaka_oshirish'
mysql> create database malaka_oshirish;
Query OK, 1 row affected (0.01 sec)

mysql> create table prepodavateli (kod_prepodavatelya int(5), familiya varchar (13), imya varchar(7), ochestva varchar (8), telefon varchar(10), staj int(5));


ERROR 1046 (3D000): No database selected
mysql> use malaka_oshirish
Database changed
mysql> create table prepodavateli (kod_prepodavatelya int(5), familiya varchar (13), imya ┌───────────────────────────┐(8), telefon varchar(10), staj int(5));
Query OK, 0 rows affected (0.01 sec) │Enter command number: │
└───────────────────────────┘
mysql> use malaka_oshirish;
Database changed
mysql> create teble nagruzka ((kod_prepodavatelya int(5), nomer gruppa int(5), kolichestva chasov int(5), predmet varchar(7), tip zanyatiya varchar(9), oplata varchar(8));
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 'teble nagruzka ((kod_prepodavatelya int(5), nomer gruppa int(5), kolichestva cha' at line 1
mysql> create teble nagruzka ((kod_prepodavatelya int(5), nomer_gruppa int(5), kolichestva_chasov int(5), predmet varchar(7), tip_zanyatiya varchar(9), oplata varchar(8));
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 'teble nagruzka ((kod_prepodavatelya int(5), nomer_gruppa int(5), kolichestva_cha' at line 1
mysql> create table nagruzka ((kod_prepodavatelya int(5), nomer_gruppa int(5), kolichestva_chasov int(5), predmet varchar(7), tip_zanyatiya varchar(9), oplata varchar(8));
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 '(kod_prepodavatelya int(5), nomer_gruppa int(5), kolichestva_chasov int(5), pred' at line 1
mysql> create table nagruzka (kod_prepodavatelya int(5), nomer_gruppa int(5), kolichestva_chasov int(5), predmet varchar(7), tip_zanyatiya varchar(9), oplata varchar(8));
Query OK, 0 rows affected (0.02 sec)

mysql> show tables;


+---------------------------+
| Tables_in_malaka_oshirish |
+---------------------------+
| nagruzka |
| prepodavateli |
+---------------------------+
2 rows in set (0.00 sec)

mysql>
Download 9.13 Kb.

Do'stlaringiz bilan baham:




Ma'lumotlar bazasi mualliflik huquqi bilan himoyalangan ©fayllar.org 2024
ma'muriyatiga murojaat qiling