Skip to content

Latest commit

 

History

History
35 lines (25 loc) · 526 Bytes

File metadata and controls

35 lines (25 loc) · 526 Bytes

Doc

Personal Class

  1. /src/class/GenerateMySQLQuery.js
var run = new GenerateMySQLQuery(this.module.tableField);
run.generateQuery();

MySQL Validation

Primary Column

  • AUTO_INCREMENT Column must be Primary Column
  • May Primary Column Query
    ....
    PRIMARY KEY (`id`,`user`,`other`)

CURRENT_TIMESTAMP

....
`date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,

UNIQUE KEY

UNIQUE KEY `err` (`err`),
UNIQUE KEY `person` (`ip`,`date`)