Aug 27
WinBinder is a new open source extension for PHP, the script programming language. It allows PHP programmers to easily build native Windows applications.
Aug 22
- MySQL Administrator
- MySQL Query Browser
- MySQL Migration Toolkit
http://dev.mysql.com/downloads/gui-tools
- MySQL Workbench (MySQL Workbench is a next-generation visual database design application that can be used to efficiently design, manage and document database schemata.)
Jun 08
Jun 04
mysql_insert_id()
Jun 04
mysql_affected_rows()
Jun 04
function GetLocalUserName : string;
var
Buffer : array[0..255] of char;
Count : DWord;
begin
Count := 256 + 1;
GetUserName(Buffer, Count);
Result := string(Buffer);
end;
var
Buffer : array[0..255] of char;
Count : DWord;
begin
Count := 256 + 1;
GetUserName(Buffer, Count);
Result := string(Buffer);
end;
Jun 02
May 29
#drop trigger
DROP TRIGGER `TRIGGER_NAME`
#auto DateTime, Date, Time
CREATE TRIGGER `TRIGGER_NAME` BEFORE INSERT ON `TABLE_NAME`
FOR EACH ROW SET NEW.DATEFIELD = NOW()
#insert something in another table
CREATE TRIGGER `TRIGGER_NAME` AFTER INSERT ON `TABLE_NAME`
FOR EACH ROW
INSERT INTO another_table SET some_field = NEW.fieldfromparenttable, text_field = 'sometext'
#if statement
CREATE TRIGGER `TRIGGER_NAME` AFTER INSERT ON `TABLE_NAME`
FOR EACH ROW BEGIN
IF NEW.Type = 0 THEN
INSERT INTO another_table SET ParentType = NEW.Type;
END IF;
END
DROP TRIGGER `TRIGGER_NAME`
#auto DateTime, Date, Time
CREATE TRIGGER `TRIGGER_NAME` BEFORE INSERT ON `TABLE_NAME`
FOR EACH ROW SET NEW.DATEFIELD = NOW()
#insert something in another table
CREATE TRIGGER `TRIGGER_NAME` AFTER INSERT ON `TABLE_NAME`
FOR EACH ROW
INSERT INTO another_table SET some_field = NEW.fieldfromparenttable, text_field = 'sometext'
#if statement
CREATE TRIGGER `TRIGGER_NAME` AFTER INSERT ON `TABLE_NAME`
FOR EACH ROW BEGIN
IF NEW.Type = 0 THEN
INSERT INTO another_table SET ParentType = NEW.Type;
END IF;
END
Recent Comments