Administrators can use /scripts/dbedit.asp

Look in local_lib.asp for the connection string (not specified here for security and 
maintenance reasons - you can use the exact constant name); select the database and a table, then use the SQL statement 
line.

Or upload a .sql file

Some tips:

CREATE TABLE Surveys (SurveyID Counter PRIMARY KEY, SurveyName Char(30) NOT NULL);

ALTER TABLE Surveys ADD COLUMN DateEnd DATETIME NOT NULL;
ALTER TABLE members ADD COLUMN SpouseCAID Text(12);
ALTER TABLE members ADD COLUMN MyCount Long;
ALTER TABLE members ADD COLUMN isFlag YesNo;

ALTER TABLE xRefs ALTER COLUMN Comment Text(255);


see http://msdn2.microsoft.com/en-us/library/bb177899.aspx for data types
http://msdn2.microsoft.com/en-us/library/bb245494.aspx for syntax

ALTER TABLE members DROP COLUMN SpouseCAID;

INSERT INTO Surveys (SurveyName, DateEnd) VALUES ('Laws Change Opinion Survey', #2007-08-31#);
 ** NB: must use single quotes
 
DELETE * FROM Events WHERE EventID=35;


## create and cross-link items

DROP TABLE Statuses;
CREATE TABLE Statuses (
StatusID Counter NOT NULL PRIMARY KEY,
Status Text(25)
);
INSERT INTO Statuses (Status) VALUES ('New');
INSERT INTO Statuses (Status) VALUES ('Old'); 

DROP TABLE obs;
CREATE TABLE obs (
obsID Counter NOT NULL PRIMARY KEY,
StatusID Long,
Title Text(25)
);

DROP TABLE obsRef;
CREATE TABLE obsRef (
MyID Counter NOT NULL PRIMARY KEY,
obsID Long,
Title Text(25)
);

INSERT INTO obs (StatusID, Title) 
    SELECT StatusID, 'my title1' FROM Statuses WHERE Status='New';
INSERT INTO obs (StatusID, Title) 
    SELECT StatusID, 'my title2' FROM Statuses WHERE Status='New';
INSERT INTO obs (StatusID, Title) 
    SELECT StatusID, 'my title3' FROM Statuses WHERE Status='New';
INSERT INTO obs (StatusID, Title) 
    SELECT StatusID, 'my title4' FROM Statuses WHERE Status='New';

INSERT INTO obsRef (obsID, Title) 
    SELECT @@IDENTITY, 'my title';

INSERT INTO obs (StatusID, Title) 
    SELECT StatusID, 'my title5' FROM Statuses WHERE Status='New';

	
	
use connection rather than connection string
MySQL: LAST_INSERT_ID() 

ALTER TABLE tablename AUTO_INCREMENT = 10000