|
Erstellt von uwais edris
vor mehr als 6 Jahre
|
|
What does SQL stand for?
What are the uses of a SQL?
The different data types whcih are often used in a SQL.
How SQL works?
For each field in the table, you need to speicfy a data type. Some common SQL data types are shown behind.
CREATE TABLE students (studentID INTEGER PRIMARY KEY, forename TEXT, surname TEXT, date_of_birth DATE, year_group INTEGER)
Once you've created an empty table you'll need to add records to it. You use INSERT INFO command. If you are inserting a complete record you don't need to speicfy the field but if it is incomplete you do.
To update a reocrd you can use UPDATE-SET-WHERE.