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日