すべてのカテゴリ

SQLSQL was developed to use relational database. It is standardized by ISO andJIS and is widely used.You can use SQL (Structured Query Language) to create, manipulate, update,and delete tables. SQL consists of DDL (Data Definition Language),DCL (Data Control Language), and DML (Data Manipulation Language).DCL may be included in DDL.■Define a tableThe table has a two-dimensional structure consisting of rows and columns.It stores the actual data. There can be multiple tables, but the table namesmust be different.（To identify the table）For example, if you define a "Grade" table consisting of "Student_Number","Name", "Language", "Math", and "Class", SQL is as bellows.CREATE TABLE Grade(Student_N

I describe the SQL when you insert, update, and delete the data in a table onthe database.（１）InsertIf you want to insert the data into a table, use "INSERT" in the SQL.The SQL is as follows.INSERT INTO TableName(Item, Item, ・・・)VALUES(Data, Data, ・・・)After the table name, describe all the items of the table you want to register.Be sure to describe the primary key.After "VALUES", describe the data you want to register. Also here, be sure todescribe the data you want to register in the primary key.For example, the SQL for registering a student with student number 11003 inthe "Grade" table is as follows.INSERT INTO Grade(Student_Number, Name, Language, Math, Class)VALUES('11003', 'Sasaki', 85,