Home / Questions / 73211
Accepted
CesarG
Asked: 2020-05-26 11:05:40 +0800 CST 2020-05-26 11:05:40 +0800 CST

The Default/expression field in MySQL(Worbench) What is it for?

  • 772

I am making a database in MySQL with MySQL Worbench and I am wondering how it can help me in my database.

What is the default/expression field used for when creating a table?

mysql

1 Answers

  1. Best Answer

    The default/expression attribute sets the default value for the column when it is not provided in an insert.

    For example given the following table:

    CREATE TABLE persona
(nombre char(50),
apellidos char(50),
direccion char(50) default 'desconocida',
pais char(50) default 'España');

    Yes we do an insert

    INSERT INTO persona (nombre, apellidos)
VALUES ( 'Pedro', 'Picapiedra');

    It will generate the following record:

    nombre   | apellido   | direccion   | país
---------------------------------------------
Pedro    | Picapiedra | desconocida | España
    • 1