Scribd Logo
Upload

Welcome to Scribd!

  • 6 views

    Kakde, Om

    Uploaded by

    aniketsarpate786
    The document shows the steps taken to create a database and tables in MySQL. It creates a database called college and then two tables called personal1 and professonal. It inserts sample data into the tables and runs some select queries to view the data.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd

    Kakde, Om

    Uploaded by

    aniketsarpate786
    6 views5 pages
    The document shows the steps taken to create a database and tables in MySQL. It creates a database called college and then two tables called personal1 and professonal. It inserts sample data into the tables and runs some select queries to view the data.

    Original Title

    kakde ,om

    Copyright

    © © All Rights Reserved

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document shows the steps taken to create a database and tables in MySQL. It creates a database called college and then two tables called personal1 and professonal. It inserts sample data into the tables and runs some select queries to view the data.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    6 views5 pages

    Kakde, Om

    Uploaded by

    aniketsarpate786
    The document shows the steps taken to create a database and tables in MySQL. It creates a database called college and then two tables called personal1 and professonal. It inserts sample data into the tables and runs some select queries to view the data.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    of 5

    Enter password: *********

    Welcome to the MySQL monitor. Commands end with ; or \g.

    Your MySQL connection id is 13

    Server version: 8.0.34 MySQL Community Server - GPL

    Copyright (c) 2000, 2023, 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> create database college;

    ERROR 1007 (HY000): Can't create database 'college'; database exists

    mysql> connect college;

    Connection id: 14

    Current database: college

    mysql> create table personal1(deptno int(30),dname varchar(30),city varchar(30));

    Query OK, 0 rows affected, 1 warning (0.01 sec)

    mysql> insert into personal values(1,"account","mumbai"

    mysql> insert into personal1 values(1,"account","mumbai");

    Query OK, 1 row affected (0.01 sec)

    mysql> insert into personal1 values(2,"sales","pune";


    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 '' at line 1

    mysql> insert into personal1 values(2,"sales","pune");

    Query OK, 1 row affected (0.01 sec)

    mysql> select * from personal;

    Empty set (0.00 sec)

    mysql> insert into personal1 values(1,"account","mumbai");

    Query OK, 1 row affected (0.01 sec)

    mysql> insert into personal1 values(2,"sales","pune"

    mysql> insert into personal1 values(1,"account","mumbai");

    Query OK, 1 row affected (0.01 sec)

    mysql> insert into personal1 values(2,"sales","pune");

    Query OK, 1 row affected (0.01 sec)

    mysql> insert into personal1 values(3,"markrting","banglore");

    Query OK, 1 row affected (0.01 sec)

    mysql> insert into personal1 values(6,"design","kolhapur");

    Query OK, 1 row affected (0.01 sec)

    mysql> insert into personal1 values(4,"human resouce","chennai");

    Query OK, 1 row affected (0.00 sec)

    mysql> insert into personal1 values(5,"R & D","nashik");

    Query OK, 1 row affected (0.00 sec)


    mysql> insert into personal1 values(7,"information tech","mumbai");

    Query OK, 1 row affected (0.01 sec)

    mysql> select * from persoal1;

    ERROR 1146 (42S02): Table 'college.persoal1' doesn't exist

    mysql> select * from collage;

    ERROR 1146 (42S02): Table 'college.collage' doesn't exist

    mysql> select * from college;

    ERROR 1146 (42S02): Table 'college.college' doesn't exist

    mysql> select * from personal1;

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

    | deptno | dname | city |

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

    | 1 | account | mumbai |

    | 2 | sales | pune |

    | 1 | account | mumbai |

    | 1 | account | mumbai |

    | 2 | sales | pune |

    | 3 | markrting | banglore |

    | 6 | design | kolhapur |

    | 4 | human resouce | chennai |

    | 5|R&D | nashik |

    | 7 | information tech | mumbai |

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

    10 rows in set (0.00 sec)

    mysql> create table professonal(emp int(10),ename varchar(20),job varchar(10),hiredate date,salary


    numeric(7,2),comm numeric(7,2),deptno int(10));
    Query OK, 0 rows affected, 2 warnings (0.01 sec)

    mysql> insert into professonal values( 102,"prathamesh patil","director","199/06/10",27000,10000,2);

    Query OK, 1 row affected, 1 warning (0.01 sec)

    mysql> insert into professonal values( 106,"priyanka pawar","clark","2003/03/19",14000,2500,3);

    Query OK, 1 row affected, 1 warning (0.01 sec)

    mysql> insert into professonal values( 101,"ashish deshpande","manager","2000/04/10",22000,5000,1);

    Query OK, 1 row affected, 1 warning (0.01 sec)

    mysql> insert into professonal values( 105,"aditya jadhav","engineer","2001/02/15",17000,2600,2);

    Query OK, 1 row affected, 1 warning (0.01 sec)

    mysql> insert into professonal values( 107,"bhakti joshi","engineer","2007/09/27",17000,7000,4);

    Query OK, 1 row affected, 1 warning (0.00 sec)

    mysql> insert into professonal values( 109,"anirudha thipse","sr.clerk","2009/04/30",20000,9000,5);

    Query OK, 1 row affected, 1 warning (0.01 sec)

    mysql> insert into professonal values( 110,"rajesh oak","engineer","2010/08/01",18000,10000,6);

    Query OK, 1 row affected, 1 warning (0.00 sec)

    mysql> select * from professonal;

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

    | emp | ename | job | hiredate | salary | comm | deptno |

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

    | 102 | prathamesh patil | director | 0199-06-10 | 27000.00 | 10000.00 | 2|

    | 106 | priyanka pawar | clark | 2003-03-19 | 14000.00 | 2500.00 | 3|


    | 101 | ashish deshpande | manager | 2000-04-10 | 22000.00 | 5000.00 | 1|

    | 105 | aditya jadhav | engineer | 2001-02-15 | 17000.00 | 2600.00 | 2|

    | 107 | bhakti joshi | engineer | 2007-09-27 | 17000.00 | 7000.00 | 4|

    | 109 | anirudha thipse | sr.clerk | 2009-04-30 | 20000.00 | 9000.00 | 5|

    | 110 | rajesh oak | engineer | 2010-08-01 | 18000.00 | 10000.00 | 6|

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

    7 rows in set (0.00 sec)

    mysql>

    You might also like