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 04
mysql_insert_id()
Jun 04
mysql_affected_rows()
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
May 28
May 28
<?
echo ($a == 0 ? "zero" : "not zero");
?>
echo ($a == 0 ? "zero" : "not zero");
?>
May 28
<?php
$PK = "PrimaryID";
$$PK = "100034";
echo $PrimaryID; // 100034
echo $$PK; // 100034
?>
$PK = "PrimaryID";
$$PK = "100034";
echo $PrimaryID; // 100034
echo $$PK; // 100034
?>
May 28
<?
define("VERSION", 2);
echo "Current version is " . VERSION;
?>
define("VERSION", 2);
echo "Current version is " . VERSION;
?>
Recent Comments