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

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

Array in function Javascript

  const ranger = [ "Troy" , "Jake" , "Noah" ] const rangerd = [ "Tylor" , "Chase" , "Koda" ] // ranger.push(rangerd) // const allranger = ranger.concat(rangerd) // console.log(allranger); // console.log(Array.isArray("Debadatta")); // console.log(Array.from("Debadatta")); // console.log(Array.isArray({name:"Debadatta"}));// Intresting let score1 = 100 let score2 = 200 let score3 = 300 console . log ( Array . of ( score1 , score2 , score3 ));
Read more

Comparison in Javascript

  //There are many types of simple comparison where we shuld only focus for limited time //ex-Equal,Greaterthan,Lessthan etc // console.log("2">1); // console.log("02">1); // console.log(null > 0); // console.log(null == 0); // console.log(null >= 0); //Avoid this type of comparison as much as possible // === it compares the datatypes also console . log ( "2" === 2 ); //False because of different datatypes //Summary //Primitive //7 tytpes-String,Number,Boolean,Null,undefined,Symbol,BigInt //Reference (Non Primitive) //Array, Objects, Function, //+++++++++++++++++++++++++++++++++ //Memory //Stack(Primitive), Heap(Non-Primitive)
Read more