SQL in MySQL

SQL in MySQL

1. Firstly we have to start MySQL 5.5 Command line client then we need to enter password, created during installation.


After entering password, screen looks like below

2. To create database: Creation of database is necessary, before creating any table. To create a database in sql, follow following syntax.
Syntax: - create database ;
For Example: - create database kr;



3. To Use database: To use a created  database the use query is used in sql statement.
Syntax: - use ;
For Example: - use kr;



4. To show databases: The show database is used to show list of  all the databases in the sql statement.
Syntax: - show database;

5. To create table: To create a table in sql database we have to give table name along with columns names and its attributes into the database, See the syntax and example below.
Syntax: - create table table-name (properties);
For Example: - create table kr (name varchar (30), rollno int (10), address varchar (30));

6. To insert value: To insert value in a table we have to follow below syntax and see the example below.     
Syntax: - insert into (table name) (properties name) values ( values name);
For Example: - insert into kr (name, rollno, address) values (ks, 23, burhanpur);

7. Show tables: Show tables query is used to show the list of tables in selected database in sql.
Syntax: - show tables;


8. Select query: select query is used to show the selected database tables.
Syntax: - select * from (table name);

9. Update: update query is used to update in the selected table.

10. Group by:

11. Like query:


12. Distinct query:


13.Drop query:


Python Programming ↓ 👆
Java Programming ↓ 👆
JAVA EasyExamNotes.com covered following topics in these notes.
JAVA Programs
Principles of Programming Languages ↓ 👆
Principles of Programming Languages
EasyExamNotes.com covered following topics in these notes.

Practicals:
Previous years solved papers:
A list of Video lectures References:
  1. Sebesta,”Concept of programming Language”, Pearson Edu 
  2. Louden, “Programming Languages: Principles & Practices” , Cengage Learning 
  3. Tucker, “Programming Languages: Principles and paradigms “, Tata McGraw –Hill. 
  4. E Horowitz, "Programming Languages", 2nd Edition, Addison Wesley

    Computer Organization and Architecture ↓ 👆

    Computer Organization and Architecture 

    EasyExamNotes.com covered following topics in these notes.

    1. Structure of desktop computers
    2. Logic gates
    3. Register organization
    4. Bus structure
    5. Addressing modes
    6. Register transfer language
    7. Direct mapping numericals
    8. Register in Assembly Language Programming
    9. Arrays in Assembly Language Programming

    References:

    1. William stalling ,“Computer Architecture and Organization” PHI
    2. Morris Mano , “Computer System Organization ”PHI

    Computer Network ↓ 👆
    Computer Network

    EasyExamNotes.com covered following topics in these notes.
    1. Data Link Layer
    2. Framing
    3. Byte count framing method
    4. Flag bytes with byte stuffing framing method
    5. Flag bits with bit stuffing framing method
    6. Physical layer coding violations framing method
    7. Error control in data link layer
    8. Stop and Wait scheme
    9. Sliding Window Protocol
    10. One bit sliding window protocol
    11. A protocol Using Go-Back-N
    12. Selective repeat protocol
    13. Application layer
    References:
    1. Andrew S. Tanenbaum, David J. Wetherall, “Computer Networks” Pearson Education.
    2. Douglas E Comer, “Internetworking with TCP/IP Principles, Protocols, And Architecture",Pearson Education
    3. KavehPahlavan, Prashant Krishnamurthy, “Networking Fundamentals”, Wiley Publication.
    4. Ying-Dar Lin, Ren-Hung Hwang, Fred Baker, “Computer Networks: An Open Source Approach”, McGraw Hill.