Database

MySQL Info

The basic SQL commands:

Database
CREATE DATABASE MyDatabase;
USE DATABASE MyDatabase;
DROP DATABASE MyDatabase;

Tables
CREATE TABLE MyTable (id int, data VarChar(128));
DROP TABLE MyTable;
ALTER TABLE MyTable ADD MyColumn VarChar(128));
ALTER TABLE MyTable DROP COLUMN MyColumn
CREATE INDEX MyIndex ON MyTable (id);

Select, Insert, Delete, Update
SELECT * FROM MyTable;
INSERT INTO MyTable (id, data) values (1, "MyData");
UPDATE MyTable SET data = "NewData" WHERE id = 1;
DELETE FROM MyTable WHERE id = 1;

Cursor Example

declare @SOHeaderKey int;
declare @FreightTermKey XML_FIELD
declare @CompanyKey XML_FIELD
declare @LocationKey XML_FIELD
declare @BillToKey XML_FIELD

declare 
	cursorFoo Cursor 
for 
	select top 2 SOHeaderKey, FreightTermKey, CompanyKey, LocationKey, BillToKey from SASOHeader order by SOHeaderKey DESC
for 
	Read Only

open cursorFoo

fetch next from cursorFoo into @SOHeaderKey, @FreightTermKey, @CompanyKey, @LocationKey, @BillToKey

if (@@fetch_status = -1) begin
 print 'No rows found'
end;

while (@@fetch_status = 0) begin
	print @SOHeaderKey
	fetch next from cursorFoo into @SOHeaderKey, @FreightTermKey, @CompanyKey, @LocationKey, @BillToKey
end

deallocate 
	cursorFoo