jeudi 7 septembre 2017

Create table with a default random column?

I want to create a table with a default random column. A sample logic would look like this:

CREATE TABLE `test` ( 
    `sno` INT NOT NULL AUTO_INCREMENT,
    `rrd` VARCHAR(20) DEFAULT rand()
) ENGINE = InnoDB;

DATABASE SERVER

Server: 127.0.0.1 via TCP/IP Server type: MariaDB Server version: 10.1.25-MariaDB - mariadb.org binary distribution Protocol version: 10 User: root@localhost Server charset: UTF-8 Unicode (utf8)




Aucun commentaire:

Enregistrer un commentaire