best database backup

#726
Raw
Author
Anonymous
Created
April 7, 2023, 8:08 p.m.
Expires
Never
Size
493 bytes
Hits
74
Syntax
SQL
Private
✗ No 
CREATE DATABASE myDB;
CREATE USER ‘myUser’@’%’ IDENTIFIED BY ‘myPassword’; 
GRANT ALL PRIVILEGES ON myDB.* TO 'myUser'@'%';

CREATE TABLE if not exists `notes` (
	`id` INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
	`name` TEXT,
	`description` TEXT,
	`comments` TEXT,
	`url` VARCHAR(2048),
	`date` DATETIME DEFAULT NOW()
) ENGINE=InnoDB;

INSERT INTO notes (name, description, url) 
VALUES ("#dailybuild", "best channel on IRC", "dailybuild.org")

select * from notes