Shulou(Shulou.com)06/01 Report--

This article mainly introduces how to set the default value of mysql, which is very detailed and has certain reference value. Friends who are interested must finish reading it!

How to set the default value of mysql: set the default value by building a data table with mysql, and the code is [stuSex varchar (2) default 'male' check (stuSex in ('male', 'female'))].

How to set default values for mysql:

Create table stu (stuId varchar (30) primary key,stuName varchar (50) not null,stuSex varchar (2) default 'male' check (stuSex in ('male', 'female'), stuJg varchar (30), stuDept varchar (40))

Use mysql to build a data table to set the default value:

Int type: default 1; (direct plus value)

Varchar type: default 'aaa' (in single quotation marks)

Another: after testing, in mysql, default should be written before check, otherwise an error will be reported.

The above is all about how to set default values for mysql. Thank you for reading! Hope to share the content to help you, more related knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.