Home > Database > Mysql Tutorial > body text

How to change the field to not null in mysql

青灯夜游
Release: 2022-06-21 15:48:55
Original
8201 people have browsed it

In mysql, you can modify the field to not null by adding a non-null constraint to the field using the ALTER TABLE statement. The syntax is "ALTER TABLE data table name CHANGE COLUMN field name field name data type NOT NULL;". The ALTER TABLE statement is used to modify the structure of the original table, and "NOT NULL" is the keyword to set a non-null constraint; after adding a non-null constraint to a field, its value cannot be null, otherwise the database system will report an error.

How to change the field to not null in mysql

The operating environment of this tutorial: windows7 system, mysql8 version, Dell G3 computer.

In mysql, if you want to change a field to not null, you can add a non-null constraint to the field.

Non-null constraint (NOT NULL) means that the value of the field cannot be empty. For fields that use non-null constraints, if the user does not specify a value when adding data, the database system will report an error.

There are two statements to add non-null constraints to fields:

  • CREATE TABLE statement

  • ALTER TABLE statement

But the CREATE TABLE statement is set when creating the table and does not meet the requirements; therefore, the ALTER TABLE statement is used here. Syntax:

ALTER TABLE 数据表名 
CHANGE COLUMN 字段名
字段名 数据类型 NOT NULL;
Copy after login

Example: Modify the id field in the tb_students_score table to not null.

Let’s take a look at the table structure first:

DESC tb_students_score;
Copy after login

How to change the field to not null in mysql

Add a non-null constraint to the id field

ALTER TABLE tb_students_score
CHANGE COLUMN id
id int(11) NOT NULL;
Copy after login

How to change the field to not null in mysql

Looking at the table structure:

How to change the field to not null in mysql

[Related recommendations: mysql video tutorial]

The above is the detailed content of How to change the field to not null in mysql. For more information, please follow other related articles on the PHP Chinese website!

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template