SQL My Notes

(under construction)

Topic	Notes
Database (Create & Drop)	This is normally done via a Control Center or some Database Management tool provide by the DB vendor. SQL Example: create database SAMPLE; drop database SAMPLE;
Connect to a Database	SQL Example connect to SAMPLE; connect to SAMPLE user USERNAME; - allows user & password access.
Create a Table	SQL Example (DB2) Warning: Be careful with the field type: DATE. Some DB's don't support it. create table TEST ( "USERID" character (8) not null, "FIRST" character (15), "LAST" character(20), primary key (USERID) ); create table Sample (charTest char(10), charYYYYMMDD char(8), intTest integer, numTest numeric(6,2), smintTest smallint, varTest varchar(1023) )
Drop a Table	SQL Example drop table TEST;
Insert a row	SQL Example insert into TEST (USERID, FIRST, LAST) values ('THOMASMA','Michael', 'Thomas');
Delete a row	SQL Example delete from TEST where USERID like 'THOMASMA';
Select	SQL Example select * from TEST; select * from TEST where ( USERID = 'THOMASMA')
Operators	Operators % - wildcard for any number of characters ? - wildcard for one character. like "%test%" //like = having matching characters. like "test%" like "%test"

Creating a Database	create database SampleDb I'm sure that there are plenty additional parameters. In my environment .75 Mb was allocated to the database and .49MB to Michael_log.
Dropping a Database	drop database Michael
GUI Tool Query Analyzer	GUI Tool for SQL command access. Query Analyzer - This is the client tool used to execute SQL commands. Connecting to a Database - this is done by selecting the drop down list in the upper right corner.
Date	Date (field type) Looks like MS SQL does not support the field: DATE . I'm not the authority, just my experience.