My Sql practice set 1

 create database xyz;

use xyz;


create table info(

id int primary key,

name varchar(20),

salary int not null

);

insert into info

(id,name,salary)

values

(1, "adam", 25000),

(2, "Bob", 30000),

(3, "Casey", 40000);


select * from info;


output



Comments

Post a Comment

Popular posts from this blog

Mysql practice random

 create database stud1; create database stud2; create database college; create database newcollege; create database if not exists college; drop database stud2; drop database if exists stud1; use college; create table student ( id int primary key, name varchar(50), age int not null ); insert into student values(1, "Debadatta", 18); insert into student values(2, "Jyoti", 18); insert into student values(3, "Aditya", 50); insert into student values(4, "Arabinda", 75); select * from student; show databases; show tables; use newcollege; create table rollnum( rollno int primary key, name varchar(50) ); select * from rollnum;  insert into rollnum   (rollno, name)  values  (101, "Sunil"),  (102, "Arjun"),  (103, "pritam");    select * from rollnum;
Read more

AMAZON HOME PAGE CLONE PROJECT

Image
HTML <! DOCTYPE html > < html lang = "en" > < head >     < meta charset = "UTF-8" >     < meta name = "viewport" content = "width=device-width, initial-scale=1.0" >     < title > Amazon </ title >     < link rel = "stylesheet" href = "https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.4.2/css/all.min.css" integrity = "sha512-z3gLpd7yknf1YoNbCzqRKc4qyor8gaKU1qmn+CShxbuBusANI9QpRohGBreCFkKxLhei6S9CQXFEbbKuqLg0DA==" crossorigin = "anonymous" referrerpolicy = "no-referrer" />     < link rel = "stylesheet" href = "STLE.CSS" > </ head > < body >     < header >         < div class = "navbar border" >             < div class = "nav-logo border" >                 < div class = "logo" ></ div >             ...
Read more

CSS TRANSFORM PROPERTY

HTML <! DOCTYPE html > < html lang = "en" > < head >     < meta charset = "UTF-8" >     < meta name = "viewport" content = "width=device-width, initial-scale=1.0" >     < title > Document </ title >     < link rel = "stylesheet" href = "STLE.CSS" > </ head > < body >     < div ></ div > </ body > </ html >   CSS div {     height : 100px ;     width : 100px ;     background-color : aqua ;     border : 2px solid gold ;     position : absolute ;     top : 60px ;     left : 50px ;     transform : rotate ( 45deg );     transform : scale ( 0.5 , 1 );     } div:hover {     background-color : red ;     color : aliceblue ;     font-size : 20px ;     translate : 20px ;     transform : skew ( 45deg ); } d...
Read more