Search
 
SCRIPT & CODE EXAMPLE
 

SQL

sql commands

Some of The Most Important SQL Commands
SELECT - extracts data from a database
UPDATE - updates data in a database
DELETE - deletes data from a database
INSERT INTO - inserts new data into a database
CREATE DATABASE - creates a new database
ALTER DATABASE - modifies a database
CREATE TABLE - creates a new table
ALTER TABLE - modifies a table
DROP TABLE - deletes a table
CREATE INDEX - creates an index (search key)
DROP INDEX - deletes an index
Comment

sql basic commands

du 
/list users and their attributes

conninfo
/connection info

l
/list databases their owners and other attributes
Comment

PREVIOUS NEXT
Code Example
Sql :: postgresql create user roles 
Sql :: sqlite get columns for table 
Sql :: sqlcmd 
Sql :: how to update rows from a table when certain conditions are met in mysql 
Sql :: mysql trim characters 
Sql :: sql server synonym 
Sql :: Remove duplicate old value in mysql 
Sql :: advantages of stored procedures sql 
Sql :: mysql shell set time_zone 
Sql :: how to modify alter user root@localhost identified with mysql_native_password by properly 
Sql :: sql not operator 
Sql :: creating database with - 
Sql :: sql queries practice 
Sql :: can sqldatareader be null 
Sql :: select row with latest date mysql 
Sql :: primary key with prefix sql 
Sql :: sql transaction 
Sql :: inner join vs outer join 
Sql :: get last date join sql 
Sql :: enable mysql query log 
Sql :: select from table and insert into table in sql 
Sql :: 18446744073709551615 mariadb left join order by 
Sql :: sql online code 
Sql :: oracle sql date winter time 
Sql :: how to order result of subquery in select 
Sql :: oracle 11g default profile values 
Sql :: how to get n result in sql 
Sql :: plus or add balance in postgresql sql 
Sql :: mysql zerofill 
Sql :: oracle params value 
ADD CONTENT
Topic
Content
Source link
Name
8+7 =