すべてのカテゴリ

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