MYSQL-SQL COMMANDS STARTING A NEW TOUR TO LEARN A BACK-END LANGUAGE STRUCTURED QUERY LANGUAGE

Server version: 8.0.31 MySQL Community Server - GPL

Copyright (c) 2000, 2022, Oracle and/or its affiliates.

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> show databases;

+--------------------+

| Database           |

+--------------------+

| admin              |

| count              |

| departemp          |

| diedb              |

| emp                |

| employee           |

| information_schema |

| mysql              |

| performance_schema |

| school             |

| school1            |

| sys                |

+--------------------+

12 rows in set (0.02 sec)


mysql> create database TEACHER;

Query OK, 1 row affected (0.02 sec)


mysql> USE TEACHER;

Database changed

mysql> SHOW TABLES;

Empty set (0.02 sec)

mysql> CREATE TABLE TEACHERS (ID INT PRIMARY KEY,NAME CHAR(40),DEBT CHAR(40),HIREDATE DATE,CATEGORY CHAR(20),GENDER CHAR(5),SALARY BIGINT);

Query OK, 0 rows affected (0.03 sec)


mysql> DESC TEACHERS;

+----------+----------+------+-----+---------+-------+

| Field    | Type     | Null | Key | Default | Extra |

+----------+----------+------+-----+---------+-------+

| ID       | int      | NO   | PRI | NULL    |       |

| NAME     | char(40) | YES  |     | NULL    |       |

| DEBT     | char(40) | YES  |     | NULL    |       |

| HIREDATE | date     | YES  |     | NULL    |       |

| CATEGORY | char(20) | YES  |     | NULL    |       |

| GENDER   | char(5)  | YES  |     | NULL    |       |

| SALARY   | bigint   | YES  |     | NULL    |       |

+----------+----------+------+-----+---------+-------+

7 rows in set (0.02 sec)


mysql> INSERT INTO TEACHERS VALUES(1,"TANYA","SST","1994-03-17","TGT","F",25000);

Query OK, 1 row affected (0.02 sec)


mysql> INSERT INTO TEACHERS VALUES(2,"SOURABH","ART","1990-02-12","PRT","M",20000),

    -> INSERT INTO TEACHERS VALUES(3,"NANDITA","ENG","1980-05-16","PGT","F",30000);

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 'INSERT INTO TEACHERS VALUES(3,"NANDITA","ENG","1980-05-16","PGT","F",30000)' at line 2

mysql> INSERT INTO TEACHERS VALUES(2,"SOURABH","ART","1990-02-12","PRT","M",20000);

Query OK, 1 row affected (0.01 sec)


mysql> INSERT INTO TEACHERS VALUES(3,"NANDITA","ENG","1980-05-16","PGT","F",30000);

Query OK, 1 row affected (0.01 sec)


mysql> INSERT INTO TEACHERS VALUES(4,"JAMES","ENG","1989-10-16","PGT","M",25000);

Query OK, 1 row affected (0.01 sec)


mysql> INSERT INTO TEACHERS VALUES(5,"JASPREET","HINDI","1990-08-01","TGT","F",22000);

Query OK, 1 row affected (0.01 sec)


mysql> INSERT INTO TEACHERS VALUES(6,"DISHA","MATHS","1980-03-17","PRT","F",21000);

Query OK, 1 row affected (0.01 sec)


mysql> INSERT INTO TEACHERS VALUES(7,"SONALI","MATHS","1980-11-17","TGT","F",24500);

Query OK, 1 row affected (0.01 sec)


mysql> SELECT*FROM TEACHERS;

+----+----------+-------+------------+----------+--------+--------+

| ID | NAME     | DEBT  | HIREDATE   | CATEGORY | GENDER | SALARY |

+----+----------+-------+------------+----------+--------+--------+

|  1 | TANYA    | SST   | 1994-03-17 | TGT      | F      |  25000 |

|  2 | SOURABH  | ART   | 1990-02-12 | PRT      | M      |  20000 |

|  3 | NANDITA  | ENG   | 1980-05-16 | PGT      | F      |  30000 |

|  4 | JAMES    | ENG   | 1989-10-16 | PGT      | M      |  25000 |

|  5 | JASPREET | HINDI | 1990-08-01 | TGT      | F      |  22000 |

|  6 | DISHA    | MATHS | 1980-03-17 | PRT      | F      |  21000 |

|  7 | SONALI   | MATHS | 1980-11-17 | TGT      | F      |  24500 |

+----+----------+-------+------------+----------+--------+--------+

7 rows in set (0.00 sec)


mysql> SELECT * FROM TEACHERS WHERE CATEGORY="PGT";

+----+---------+------+------------+----------+--------+--------+

| ID | NAME    | DEBT | HIREDATE   | CATEGORY | GENDER | SALARY |

+----+---------+------+------------+----------+--------+--------+

|  3 | NANDITA | ENG  | 1980-05-16 | PGT      | F      |  30000 |

|  4 | JAMES   | ENG  | 1989-10-16 | PGT      | M      |  25000 |

+----+---------+------+------------+----------+--------+--------+

2 rows in set (0.01 sec)


mysql> SELECT NAME FROM TEACHERS WHERE (GENDER="F",DEBT="HINDI");

ERROR 1241 (21000): Operand should contain 1 column(s)

mysql> SELECT NAME FROM TEACHERS WHERE (GENDER="F" AND DEBT="HINDI");

+----------+

| NAME     |

+----------+

| JASPREET |

+----------+

1 row in set (0.00 sec)


mysql> SELECT NAME,DEBT,HIREDATE FROM TEACHERS;

+----------+-------+------------+

| NAME     | DEBT  | HIREDATE   |

+----------+-------+------------+

| TANYA    | SST   | 1994-03-17 |

| SOURABH  | ART   | 1990-02-12 |

| NANDITA  | ENG   | 1980-05-16 |

| JAMES    | ENG   | 1989-10-16 |

| JASPREET | HINDI | 1990-08-01 |

| DISHA    | MATHS | 1980-03-17 |

| SONALI   | MATHS | 1980-11-17 |

+----------+-------+------------+

7 rows in set (0.00 sec)


mysql> COUNT WHERE DEBT="ENG";

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 'COUNT WHERE DEBT="ENG"' at line 1

mysql> COUNT() WHERE DEBT="ENG";

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 'COUNT() WHERE DEBT="ENG"' at line 1

mysql> COUNT() DEBT="ENG";

+------+------------+

| DEBT | HIREDATE   |

+------+------------+

| SST  | 1994-03-17 |

| ENG  | 1980-05-16 |

+------+------------+

2 rows in set (0.04 sec)


mysql> SELECT * FROM TEACHERS WHERE NAME LIKE("J%");

+----+----------+-------+------------+----------+--------+--------+

| ID | NAME     | DEBT  | HIREDATE   | CATEGORY | GENDER | SALARY |

+----+----------+-------+------------+----------+--------+--------+

|  4 | JAMES    | ENG   | 1989-10-16 | PGT      | M      |  25000 |

|  5 | JASPREET | HINDI | 1990-08-01 | TGT      | F      |  22000 |

+----+----------+-------+------------+----------+--------+--------+

2 rows in set (0.01 sec)


mysql> SELECT MONTHNAME (HIREDATE) FROM TEACHERS WHERE CATEGORY="TGT";

+----------------------+

| MONTHNAME (HIREDATE) |

+----------------------+

| March                |

| August               |

| November             |

+----------------------+

3 rows in set (0.01 sec)


mysql> SELECT*FROM TEACHERS;

+----+----------+-------+------------+----------+--------+--------+

| ID | NAME     | DEBT  | HIREDATE   | CATEGORY | GENDER | SALARY |

+----+----------+-------+------------+----------+--------+--------+

|  1 | TANYA    | SST   | 1994-03-17 | TGT      | F      |  25000 |

|  2 | SOURABH  | ART   | 1990-02-12 | PRT      | M      |  20000 |

|  3 | NANDITA  | ENG   | 1980-05-16 | PGT      | F      |  30000 |

|  4 | JAMES    | ENG   | 1989-10-16 | PGT      | M      |  25000 |

|  5 | JASPREET | HINDI | 1990-08-01 | TGT      | F      |  22000 |

|  6 | DISHA    | MATHS | 1980-03-17 | PRT      | F      |  21000 |

|  7 | SONALI   | MATHS | 1980-11-17 | TGT      | F      |  24500 |

+----+----------+-------+------------+----------+--------+--------+

7 rows in set (0.00 sec)


mysql> SELECT COUNT()FROM TEACHERS WHERE DEBT="ENG";

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 ')FROM TEACHERS WHERE DEBT="ENG"' at line 1

mysql> SELECT COUNT("DEBT")FROM TEACHERS WHERE DEBT="ENG";

+---------------+

| COUNT("DEBT") |

+---------------+

|             2 |

+---------------+

1 row in set (0.01 sec)


mysql> SELECT COUNT("ENG")FROM TEACHERS WHERE DEBT="ENG";

+--------------+

| COUNT("ENG") |

+--------------+

|            2 |

+--------------+

1 row in set (0.00 sec)


mysql> SELECT COUNT("ENG")FROM TEACHERS WHERE DEBT="ENG";

Comments

Post a Comment

Popular posts from this blog

how to make career in photography on blog

 first of all you should know that making career in field of content writing requires lot of patients and consistency  Choose a niche - First, determine what kind of photography you want to focus on. This could be anything from landscape to portrait photography. Narrowing your focus will make it easier for you to create content and target a specific audience. Choose a blogging platform - There are several blogging platforms available, but WordPress is the most popular and user-friendly. It offers a range of templates and plugins, making it easy to customize your blog to your liking. Choose a domain name - Your domain name is the web address that people will use to find your blog. It should be short, catchy, and relevant to your niche. You can use domain registration sites like GoDaddy or Namecheap to register your domain name. Choose a hosting service - A hosting service is where your blog will be stored online. Look for a hosting service that offers good uptime, fast loading ...
Read more..

HOW to focus on your goals in year 2023 is skill that will make a fish out of water

Image
If you have a mindset of always being a unique man in the room then you have a way out follow some these rules and you will get a eye- Setting goals is the first step in achieving success, but staying focused on those goals is what separates successful people from those who fall short. Many people struggle with focus, especially when they are faced with distractions, setbacks, or competing priorities. However, by adopting some effective strategies, you can maintain your focus and achieve your goals. Set clear and specific goals To focus on your goals, you first need to have a clear and specific idea of what you want to achieve. Vague or general goals are difficult to focus on because they lack clarity and direction. Therefore, when setting goals, be specific and define what you want to achieve, how you will measure success, and when you want to achieve it. Create a SHORT plan of action Once you have set your goals, it's essential to develop a plan of action to achieve them. A plan ...
Read more..

#python handwritten notes for beginners

Here I am gonna tell you day1 python guide for you read the steps and enjoy Install Python: To start programming in Python, you need to first install the Python interpreter on your computer. You can download the latest version of Python from the official Python website. Learn the basic syntax: Python is a simple and easy-to-learn programming language. Start with the basics of the syntax such as variables, data types, operators, control structures, functions, and classes. Use an IDE: Integrated Development Environment (IDE) is a software application that provides a comprehensive environment to write, test, and debug your Python code. Popular IDEs for Python include PyCharm, Spyder, and Visual Studio Code. Write your first program: Once you have installed Python and an IDE, it's time to write your first Python program. Start with a simple "Hello World" program to get started. Practice coding: The best way to become proficient in Python is by practicing coding. Start with si...
Read more..