mysql> create table tb01; ERROR 1146 (42S02): Table 'da01.tb01' doesn't exist
时间: 2024-03-19 11:14:54 浏览: 95
MySql报错Table mysql.plugin doesn’t exist的解决方法
This error occurs because you are trying to create a table without specifying the columns in it. To create a table, you need to specify the table name and the columns with their data types.
Here's an example of how to create a table named tb01 with two columns, id (integer) and name (varchar):
```
mysql> CREATE TABLE tb01 (
-> id INT,
-> name VARCHAR(50)
-> );
```
Once you've created the table, you can start adding data to it using the INSERT INTO statement.
阅读全文