[<<][sql][>>][..]
Fri Nov 4 00:35:12 EDT 2011

SQL cheat sheet

# apt-get install mysql-server
# mysql

CREATE database <database>;
SELECT * from <table>;
USE <database>;
CREATE TABLE agent (
     agent_id MEDIUMINT NOT NULL AUTO_INCREMENT,
     agent TEXT NOT NULL,
     PRIMARY KEY (agent_id)
);
INSERT INTO agent (agent) values ('me'), ('my dog');
SELECT COUNT(*) FROM <table>;





[Reply][About]
[<<][sql][>>][..]