無料サンプル

SP-293 ' ); In MySQL, you can insert data into a table using the `INSERT INTO` statement. However, the way you are using it is not correct. You should provide the column names and corresponding values for the columns. Here is an example of how to insert a record into the `users` table: ```sql INSERT INTO users (username, password, email) VALUES ('john_doe', '123456', 'john@example.com'); ``` This would insert a record with the username 'john_doe', password '123456', and email 'john@example.com' into the `users` table. To design a user table that you can query, first you need to create a table ```users``` in the database. Here is the SQL to create the table: ```sql CREATE TABLE users ( id int PRIMARY KEY AUTO_INCREMENT, username varchar(40) NOT NULL, password varchar(40) NOT NULL, email varchar(40) NOT NULL ); ``` After you have created the table, you can insert data into it using the `INSERT INTO` statement, here is the SQL: ```sql INSERT INTO users (username, password, email) VALUES ('john_doe', '123456', 'john@example.com'); INSERT INTO users (username, password, email) VALUES ('bill', '6723', 'bill@example.com'); INSERT INTO users (username, password, email) VALUES ('donald', '1230s', 'donald@example.com'); INSERT INTO users (username, password, email) VALUES ('richard', '910she', 'richard@example.com'); INSERT INTO users (username, password, __) VALUES ('someone', '2120', 'someone@example.com'); INSERT INTO users (username, password, email) VALUES ('lee', '1122', 'lee@example.com'); INSERT INTO users (username, password, email) VALUES ('Tim', '6547', 'tim@example.com'); INSERT INTO users (username, password, email) VALUES ('david', '2310', 'david@example.com'); INSERT INTO users (username, password, email) VALUES ('suyun', '23ui', 'suyun@example.com'); INSERT INTO users (username, password, email) VALUES ('casey', '3328', 'casey@example.com'); INSERT INTO users (username, password, email) VALUES ('cjdc', 'exp', 'forkl '); ``` > Insert the above data into the table (Make a query to search for all users) ```sql SELECT * FROM users; ```

2013年5月1日118 分