SQL stands for Structured Query Language, and it is a very powerful and diverse language used to create and query databases.The loose structure and flexibility of this language make it an ideal candidate for the web, especially since there are more than a handful of database applications available for developers o use for free, such as Microsoft’s SQL Server Express and MySQL.
Creating a Database:-
You can create a database by typing the following SQL query statement into your new empty query tab, and then pressing the Execute button or striking the (F5) key.
create database databasename ;
Tables:-
Data is stored inside SQL tables which are contained within SQL databases. A single database can house hundreds of tables, each playing its own unique role in the database schema. SQL tables are comprised of table rows and columns. Table columns are responsible for storing many different types of data, like numbers, texts, dates, and even files.
How to create a table:-
You can create a table by typing the following SQL query statement:-
create table tablename
(
p_id int,
firstname char(20),
lastname char(20),
address varchar(50),
city char(20)
)
