Mysql
Enter password: *****
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.5.29 MySQL Community Server (GPL)
Copyright (c) 2000, 2012, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> create database company;
Query OK, 1 row affected (0.02 sec)
mysql> use company;
Database changed mysql> create table salesman(SID char(5) primary key,Sname char(10) not null,Cit y char(15),Salary int(5),product int(20),target int(10));
Query OK, 0 rows affected (0.42 sec)
mysql> create table salesman(SID char(5) primary key,Sname char(10) not null,Cit y char(15),Salary int(5),product char(20),target int(10));
ERROR 1050 (42S01): Table 'salesman' already exists mysql> create table Salesman(SID char(5) primary key,Sname char(10) not null,Cit y char(15),Salary int(5),product char(20),target int(10));
ERROR 1050 (42S01): Table 'salesman' already exists mysql> create table Salesman1(SID char(5) primary key,Sname char(10) not null,Ci ty char(15),Salary int(5),product char(20),target int(10));
Query OK, 0 rows affected (0.00 sec)
mysql> insert into salesman1 values("sA","Rahul","Noida",15,000,"books",100);
ERROR 1136 (21S01): Column count doesn't match value count at row 1 mysql> insert into salesman1 values("sA","Rahul","Noida",15000,"books",100);
Query OK, 1 row affected (0.06 sec)
mysql> insert into salesman1 values("sB","Rohan","Delhi",25000,"Notebook",150);
Query OK, 1 row affected (0.28 sec)
mysql> insert into salesman1 values("sC","Jitu","Mumbai",21200,"Paper",250);
Query OK, 1 row affected (0.31 sec)
mysql> insert into salesman1 values("sD","Atul","Ghaziabad",10200,"Register",300
);
Query OK, 1 row affected (0.30 sec)
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.5.29 MySQL Community Server (GPL)
Copyright (c) 2000, 2012, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> create database company;
Query OK, 1 row affected (0.02 sec)
mysql> use company;
Database changed mysql> create table salesman(SID char(5) primary key,Sname char(10) not null,Cit y char(15),Salary int(5),product int(20),target int(10));
Query OK, 0 rows affected (0.42 sec)
mysql> create table salesman(SID char(5) primary key,Sname char(10) not null,Cit y char(15),Salary int(5),product char(20),target int(10));
ERROR 1050 (42S01): Table 'salesman' already exists mysql> create table Salesman(SID char(5) primary key,Sname char(10) not null,Cit y char(15),Salary int(5),product char(20),target int(10));
ERROR 1050 (42S01): Table 'salesman' already exists mysql> create table Salesman1(SID char(5) primary key,Sname char(10) not null,Ci ty char(15),Salary int(5),product char(20),target int(10));
Query OK, 0 rows affected (0.00 sec)
mysql> insert into salesman1 values("sA","Rahul","Noida",15,000,"books",100);
ERROR 1136 (21S01): Column count doesn't match value count at row 1 mysql> insert into salesman1 values("sA","Rahul","Noida",15000,"books",100);
Query OK, 1 row affected (0.06 sec)
mysql> insert into salesman1 values("sB","Rohan","Delhi",25000,"Notebook",150);
Query OK, 1 row affected (0.28 sec)
mysql> insert into salesman1 values("sC","Jitu","Mumbai",21200,"Paper",250);
Query OK, 1 row affected (0.31 sec)
mysql> insert into salesman1 values("sD","Atul","Ghaziabad",10200,"Register",300
);
Query OK, 1 row affected (0.30 sec)