![]() So, let’s create a geeks table within the geeks database as shown below: CREATE TABLE geeks(id int, name varchar(20)) To add a table into the database we use the below command: Syntax:- CREATE TABLE table_name (Attribute_name datatype.) Use the below command to use the geeks database: use geeks How to use SQLMAP to test a website for SQL Injection vulnerability.SQL general functions | NVL, NVL2, DECODE, COALESCE, NULLIF, LNNVL and NANVL.SQL | Join (Cartesian Join & Self Join).Difference between Where and Having Clause in SQL.Difference between DELETE, DROP and TRUNCATE.How to find Nth highest salary from a table.SQL | Join (Inner, Left, Right and Full Joins).SQL | DDL, DQL, DML, DCL and TCL Commands.ISRO CS Syllabus for Scientist/Engineer Exam.ISRO CS Original Papers and Official Keys.GATE CS Original Papers and Official Keys.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |