Pastebin

New Paste Add Image

Enter password: ******
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 12
Server version: 8.0.40 MySQL Community Server - GPL

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> SELECT * from employee;3
ERROR 1046 (3D000): No database selected
    -> ;
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 '3' at line 1
mysql> USE company3
ERROR 1049 (42000): Unknown database 'company3'
mysql> USE company
Database changed
mysql> SELECT * from employee;3
+--------+-----------+-----------+---------+
| emp_id | name      | salary    | dept_id |
+--------+-----------+-----------+---------+
|    101 | Raj Kumar |  15000.00 |      23 |
|    102 | Karmarr   | 155000.00 |      24 |
|    103 | Ajumar    | 150500.00 |      25 |
|    104 | Amar      |  25000.00 |      26 |
|    105 | PRaj      | 265000.00 |      20 |
|    106 | Humar     |  45000.00 |       2 |
+--------+-----------+-----------+---------+
6 rows in set (0.00 sec)

-> ;
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 '3' at line 1
mysql> INSERT INTO dept VALUES(2, "Testing", "Remote");
Query OK, 1 row affected (0.03 sec)

mysql> INSERT INTO dept VALUES(20, "Anger Management", "Delhi");
Query OK, 1 row affected (0.01 sec)

mysql> INSERT INTO dept VALUES(20, "Chocolate Quality Divison", "Budapest");
ERROR 1062 (23000): Duplicate entry '20' for key 'dept.PRIMARY'
mysql>
mysql> INSERT INTO dept VALUES(23, "Chocolate Quality Divison", "Budapest");
Query OK, 1 row affected (0.01 sec)

mysql> INSERT INTO dept VALUES(24, "Road Safety Division", "Patna");
Query OK, 1 row affected (0.01 sec)

mysql> INSERT INTO dept VALUES(25, "Cyber Security", "San Fransisco");
Query OK, 1 row affected (0.01 sec)

mysql> INSERT INTO dept VALUES(26, "Sales","Antartica");
Query OK, 1 row affected (0.01 sec)

mysql> SELECT * from employee;
+--------+-----------+-----------+---------+
| emp_id | name      | salary    | dept_id |
+--------+-----------+-----------+---------+
|    101 | Raj Kumar |  15000.00 |      23 |
|    102 | Karmarr   | 155000.00 |      24 |
|    103 | Ajumar    | 150500.00 |      25 |
|    104 | Amar      |  25000.00 |      26 |
|    105 | PRaj      | 265000.00 |      20 |
|    106 | Humar     |  45000.00 |       2 |
+--------+-----------+-----------+---------+
6 rows in set (0.00 sec)

mysql> ALTER TABLE employee
    -> ADD email VARCHAR(50);
Query OK, 0 rows affected (0.03 sec)
Records: 0  Duplicates: 0  Warnings: 0

mysql> ALTER TABLE employee
    -> ADD post VARCHAR(50);
Query OK, 0 rows affected (0.03 sec)
Records: 0  Duplicates: 0  Warnings: 0

mysql> INSERT INTO employee(email, post) VALUES("a@a.com","Head") WHERE emp_id=101;
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 'WHERE emp_id=101' at line 1
mysql> INSERT INTO employee(email, post) VALUES("a@a.com","Head") WHERE employee.emp_id=101;
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 'WHERE employee.emp_id=101' at line 1
mysql> UPDATE employee(email, post) VALUES("a@a.com","Head") WHERE employee.emp_id=101;
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 '(email, post) VALUES("a@a.com","Head") WHERE employee.emp_id=101' at line 1
mysql> UPDATE employee
    -> SET email="a@a.com" and post="Head" WHERE emp_id=101;
ERROR 1292 (22007): Truncated incorrect DOUBLE value: 'a@a.com'
mysql> DESC employee;
+---------+---------------+------+-----+---------+-------+
| Field   | Type          | Null | Key | Default | Extra |
+---------+---------------+------+-----+---------+-------+
| emp_id  | int           | NO   | PRI | NULL    |       |
| name    | varchar(70)   | YES  |     | NULL    |       |
| salary  | decimal(10,2) | YES  |     | NULL    |       |
| dept_id | int           | YES  |     | NULL    |       |
| email   | varchar(50)   | YES  |     | NULL    |       |
| post    | varchar(50)   | YES  |     | NULL    |       |
+---------+---------------+------+-----+---------+-------+
6 rows in set (0.02 sec)

mysql> UPDATE employee SET email="a@a.com" and post="Head" WHERE emp_id=101;
ERROR 1292 (22007): Truncated incorrect DOUBLE value: 'a@a.com'
mysql> UPDATE employee SET email="a@a.com" WHERE emp_id=101;
Query OK, 1 row affected (0.01 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql> UPDATE employee SET email="a@an.com" WHERE emp_id=102;
Query OK, 1 row affected (0.01 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql> UPDATE employee SET email="ak@an.com" WHERE emp_id=103;
Query OK, 1 row affected (0.01 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql> UPDATE employee SET email="ak@anh.com" WHERE emp_id=104;
Query OK, 1 row affected (0.01 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql> UPDATE employee SET email="agk@anh.com" WHERE emp_id=105;
Query OK, 1 row affected (0.01 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql> UPDATE employee SET email="agk@ganh.com" WHERE emp_id=106;
Query OK, 1 row affected (0.01 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql> ALTER TABLE employee
    -> ADD CONSTRAINT dept_link
    -> FOREIGN KEY(dept_id) REFERENCES dept(dept_id);
Query OK, 6 rows affected (0.08 sec)
Records: 6  Duplicates: 0  Warnings: 0

mysql> UPDATE employee SET post="Clerk" WHERE emp_id=101;
Query OK, 1 row affected (0.01 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql> UPDATE employee SET post="Boss" WHERE emp_id=102;
Query OK, 1 row affected (0.03 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql> UPDATE employee SET post="Manager" WHERE emp_id=103;
Query OK, 1 row affected (0.03 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql> UPDATE employee SET post="Delivery Head" WHERE emp_id=104;
Query OK, 1 row affected (0.01 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql> UPDATE employee SET post="CTO" WHERE emp_id=105;
Query OK, 1 row affected (0.01 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql> UPDATE employee SET post="Software Guy" WHERE emp_id=106;
Query OK, 1 row affected (0.01 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql> SELECT * from employee;
+--------+-----------+-----------+---------+--------------+---------------+
| emp_id | name      | salary    | dept_id | email        | post          |
+--------+-----------+-----------+---------+--------------+---------------+
|    101 | Raj Kumar |  15000.00 |      23 | a@a.com      | Clerk         |
|    102 | Karmarr   | 155000.00 |      24 | a@an.com     | Boss          |
|    103 | Ajumar    | 150500.00 |      25 | ak@an.com    | Manager       |
|    104 | Amar      |  25000.00 |      26 | ak@anh.com   | Delivery Head |
|    105 | PRaj      | 265000.00 |      20 | agk@anh.com  | CTO           |
|    106 | Humar     |  45000.00 |       2 | agk@ganh.com | Software Guy  |
+--------+-----------+-----------+---------+--------------+---------------+
6 rows in set (0.00 sec)

mysql>

THIS WAS FROM THE SIMPLE. SQL file

CREATE DATABASE company;
USE company;

CREATE TABLE employee(
emp_id INT PRIMARY KEY,
name VARCHAR(70),
salary DECIMAL(10,2),
dept_id INT
);

CREATE TABLE dept(
dept_id INT PRIMARY KEY,
dept_name VARCHAR(30),
location VARCHAR(50)
)

SELECT * from dept;

INSERT INTO employee VALUES(101,"Raj Kumar", 15000.00, 23);
INSERT INTO employee VALUES(102,"Karmarr", 155000.00, 24);
INSERT INTO employee VALUES(103,"Ajumar", 150500.00, 25);
INSERT INTO employee VALUES(104,"Amar", 25000.00, 26);
INSERT INTO employee VALUES(105,"PRaj", 265000.00, 20);
INSERT INTO employee VALUES(106,"Humar", 45000.00, 2);

SELECT * from employee;

Settings

Title : [Optional]

Paste Folder : [Optional]

Syntax : [Optional]

Expiration : [Optional]

Status : [Optional]

Password : [Optional]

Description: [Optional]

Tags: [Optional]

Encrypt Paste (?)

You are currently not logged in, this means you can not edit or delete anything you paste. Sign Up or Login

Settings

Site Languages