create table tInventoryPlan2设置字段默认值

To create a table tInventoryPlan2 with default values for fields, you can use the following SQL query:

CREATE TABLE tInventoryPlan2 (
  id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
  product_name VARCHAR(50) DEFAULT 'Unknown',
  quantity INT DEFAULT 0,
  price DECIMAL(10, 2) DEFAULT 0.00
);

In this example, the product_name field has a default value of 'Unknown', the quantity field has a default value of 0, and the price field has a default value of 0.00. These values will be used if no value is specified for these fields during an INSERT operation. The id field is set to NOT NULL and AUTO_INCREMENT to ensure each record has a unique identifier