SQL Bascis

-

1 How to create database

create database sarkarijobwob


//sarkarijobwob// is database name


2 How to get all database names

show databases


3 How to use a database

 use sarkarijobwob


Note: After using use command then only we can create the and edit the table



4 How to show tables

show table


//after using use command//



5: How to get more details of a table

desc user




//user is table name//


6: How to insert data into a table


insert into user (username) values ("vicky")


//user is table name//


7: How to look all the values in a table


select * from user


//user is table name//

 4: How to create table on SQL




Create table users ( id int, usermane text)

Second example

create table users (id int, username text, address_number float)


5 How to read a data base

SELECT * FROM [OrderDetails]


6 : How to delete table 

drop table user

\\"user" is table name//


**How to check engine

use users

show engine

show table status                            ///to check which engine is working on table////


**Types of engines 



**How to use different engines on a table

create table donald(id int) engine=MyISAM

//table name is donald

After entering show 

show table status




**How to change default storage engine

set default_storage_engine=MYISAM

** How to check SQL mode

select @@GLOBAL.SQL_MODE

select @@GLOBAL.SQL_MODE, @@session.SQL_MODE

Comments

Post a Comment

Popular posts from this blog

Java Apni Kak

-
For Loops: package com.company ; import java.util.* ; public class Main { public static void main (String[] args) { //Print sum of n numbers input taken by users, this code will give each step result Scanner sc = new Scanner(System. in ) ; int n = sc.nextInt() ; int sum = 0 ; /* How loops works * sum=0, 0+1, where 1= i * sum=1, 1+2, where 2= i * sum=2, 3+3, where 3(last one)= i * sum=6, 6+4, where 4= i * sum=10, 10+5, where 5= i * i Value reaches to condition * * */ for ( int i = 1 ; i <= n ; i++) { sum = sum+i ; System. out .println(sum) ; } } } public class Main { public static void main (String[] args) { //Print sum of n numbers input taken by users, this code will one result Scanner sc = new Scanner(System. in ) ; int n = sc.nextInt() ; int sum = 0 ; /* How loops works * sum=0, 0+1, where 1= i * sum=1, 1+2, where 2= i * sum=2, 3+3, where 3(la...
Read more

JS

-
  Data Types in JS We assigned data to the variable by using the assignment operator "=". Datatypes in JavaScript are: Number i.e., 11,23,45,6 Strings, i.e., "Hello World." Boolean, i.e., true, false Undefined Null Any of the complex data structures (Array and Objects) Let Block level scope, it works under block { } if call outer side of block the global let value will call console . log ( 'tut3' ) ; // Variables in js // var, let, const var name = 'harry' ; var channel ; var marks = 3454 ; marks = 0 ; channel = 'CodeWithHarry' console . log ( name , channel , marks ) ; // Rules for creating JavaScript Variables /* 1. Cannot start with numbers 2. Can start with letter, numbers, _ or $ 3. Are case sensitive */ var city = 'Delhi' ; console . log ( city ) ; const ownersName = 'Hari Ram' ; // ownersName = 'Harry'; // Cannot do this (error) console . log ( ownersName ) ; const fruit = 'Or...
Read more