Posts

Showing posts with the label My SQL

My SQL | Short Notes | Class 12 | CS | Computer Science

                MY SQL ____________________   #DATABASE To create database Create database xyz:   #USE COMMAND To use database Use xyz: #COMMAND TO DISPLAY EXISTING DATA •   Show databases: •   Show Tables:   # USE OF TABLE COMMAND To create table Create table abc(slno int, stdnm varchar(30), fathernm varchar(30), class char(3), sec char(1), marks int):   #USE OF DESC To describe the table desc abc:   #USE OF INSERT To insert value inside table insert into abc values(1, "aditya","alok","XI", "A",330):   insert into abc values(2,"abhay","aman","XII","B",410):   #USE OF   *  as ALL To show the full table Select* from abc:   #USE OF SELECT   To show any selected of coulmn Select stdnm, marks from abc:   #USE OF UPDATE To update any data in table update abc set marks=390 where slno=2:   #USE OF PRIMARY KEY To set a primary key c