/SQL/Mysql default value

Mysql default value

Mysql modify default value

ALTER TABLE tbl_name ALTER column_name SET DEFAULT new_value;

5

Source: oreilly.com

Mysql default value

CREATE TABLE table_name(
   column_name data_type,
   Column_name data_type DEFAULT ‘value’
);

2

Similar codes

0 vote128 views1 answer
Groupby sort sql hive
SQL
0 vote135 views1 answer
Mssql check if date is greater than today
SQL
3 votes133 views3 answers
Update join
SQL
0 vote196 views1 answer
Sql delete row from table where id
SQL
0 vote125 views4 answers
Sql year
SQL
0 vote131 views1 answer
Sql add calculated column
SQL
4 votes120 views1 answer
Oracle table statistics last analyzed
SQL
20 votes124 views1 answer
Get all table name in sql through php
SQL
2 votes128 views1 answer
Check isolation level in mysql
SQL
10 votes132 views3 answers
Insert into auto increment mysql
SQL

Share