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