A collection of 92 articles on programming, technology and life.
DATA TYPE `sql CREATE TYPE gendertype AS ENUM('male, female'); CREATE TABLE USERS ( -- o < char(n) varchar(n) < 10,485,760 username CHAR(10) NOT NULL UNIQUE, email VARCHAR(50) NOT NULL UNIQUE, gender gendertype NOT NULL, interest TEXT[] NOT NULL, -- MAXIMUM 1GB -- TOAST(the ov
Basic Command `sql -- Create Table CREATE TABLE users ( userid BIGINT UNSIGNED PRIMARY KEY AUTOINCREMENT, username CHAR(10) NOT NULL UNIQUE, email VARCHAR(50) NOT NULL, gender ENUM('Male', 'Female'), intersets SET( 'Technology', 'Sports', 'Music',