SQL Create Table
The SQL Create Table is used to create new table in the database.
Create Table Syntax :
The syntax of the Create Table is −
In creating a basic table involves, define the naming of the table (table-name) and its columns (column 1, column 2 ..... column) and the datatype of each column (column 1 datatype ...... column 2 data Type).
CREATE TABLE table-name ( column1 datatype, column2 datatype, column3 datatype, . . . columnN datatype );
Create Table Example :
The following code block is an example, which creates a table name Customer that contains the following column names (CustomerID, CustomerName, Age, Address, Customer List), where CustomerID is a primary key and not NULL.
CREATE TABLE Customer( CustomerID INT NOT NULL, CustomerName VARCHAR (20) NOT NULL, Age INT NOT NULL, Address CHAR (25) , CustomerSalary DECIMAL (18, 2), PRIMARY KEY (ID) );
The empty "Customer" table will now look like this:
CustomerID | CustomerName | Age | Address | CustomerSalary |
---|---|---|---|---|
Visit :
Discussion
pHqghUme
555
pHqghUme
555
pHqghUme
555
pHqghUme
-1 OR 2+788-788-1=0+0+0+1 --
pHqghUme
-1 OR 3+788-788-1=0+0+0+1 --
pHqghUme
-1 OR 3*2<(0+5+788-788) --
pHqghUme
-1 OR 3*2>(0+5+788-788) --
pHqghUme
-1 OR 2+138-138-1=0+0+0+1
pHqghUme
-1 OR 3+138-138-1=0+0+0+1
pHqghUme
-1 OR 3*2<(0+5+138-138)
pHqghUme
-1 OR 3*2>(0+5+138-138)
pHqghUme
-1' OR 2+143-143-1=0+0+0+1 --
pHqghUme
-1' OR 3+143-143-1=0+0+0+1 --
pHqghUme
-1' OR 3*2<(0+5+143-143) --
pHqghUme
-1' OR 3*2>(0+5+143-143) --
pHqghUme
-1' OR 2+866-866-1=0+0+0+1 or 'J8sIZs1y'='
pHqghUme
-1' OR 3+866-866-1=0+0+0+1 or 'J8sIZs1y'='
pHqghUme
-1' OR 3*2<(0+5+866-866) or 'J8sIZs1y'='
pHqghUme
-1' OR 3*2>(0+5+866-866) or 'J8sIZs1y'='
pHqghUme
-1" OR 2+256-256-1=0+0+0+1 --
pHqghUme
-1" OR 3+256-256-1=0+0+0+1 --
pHqghUme
-1" OR 3*2<(0+5+256-256) --
pHqghUme
-1" OR 3*2>(0+5+256-256) --
pHqghUme
if(now()=sysdate(),sleep(15),0)
pHqghUme
0'XOR(if(now()=sysdate(),sleep(15),0))XOR'Z
pHqghUme
0"XOR(if(now()=sysdate(),sleep(15),0))XOR"Z
pHqghUme
(select(0)from(select(sleep(15)))v)/*'+(select(0)from(select(sleep(15)))v)+'"+(select(0)from(select(sleep(15)))v)+"*/
pHqghUme
-1; waitfor delay '0:0:15' --
pHqghUme
-1); waitfor delay '0:0:15' --
pHqghUme
1 waitfor delay '0:0:15' --
pHqghUme
J2mnKQ5a'; waitfor delay '0:0:15' --
pHqghUme
-5 OR 73=(SELECT 73 FROM PG_SLEEP(15))--
pHqghUme
-5) OR 976=(SELECT 976 FROM PG_SLEEP(15))--
pHqghUme
-1)) OR 67=(SELECT 67 FROM PG_SLEEP(15))--
pHqghUme
RSDWFuLV' OR 177=(SELECT 177 FROM PG_SLEEP(15))--
pHqghUme
W3cudZyP') OR 732=(SELECT 732 FROM PG_SLEEP(15))--
pHqghUme
UbL3iV2F')) OR 205=(SELECT 205 FROM PG_SLEEP(15))--
pHqghUme
555*DBMS_PIPE.RECEIVE_MESSAGE(CHR(99)||CHR(99)||CHR(99),15)
pHqghUme
555'||DBMS_PIPE.RECEIVE_MESSAGE(CHR(98)||CHR(98)||CHR(98),15)||'
pHqghUme
1'"
pHqghUme
pHqghUme
@@Iz8x5
pHqghUme
555
pHqghUme
555
pHqghUme
555