May 25
HeidiSQL is an easy-to-use interface and a “working-horse” for web-developers using the popular MySQL-Database. It allows you to manage and browse your databases and tables from an intuitive Windows® interface.
Sep 03
Adminer (formerly phpMinAdmin) is a full-featured MySQL management tool written in PHP. Conversely to phpMyAdmin, it consist of a single file ready to deploy to the target server
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
Jul 10
<?
$query = mysql_query("SELECT name FROM Table");
while ($item = mysql_fetch_object($query)) {
echo $item->name;
echo "<br>";
}
?>
$query = mysql_query("SELECT name FROM Table");
while ($item = mysql_fetch_object($query)) {
echo $item->name;
echo "<br>";
}
?>
Jul 10
<?
header('Content-Type: text/html; charset=utf-8');
?>
header('Content-Type: text/html; charset=utf-8');
?>
<?
mysql_select_db("DataBase");
mysql_query("SET NAMES UTF8");
?>
Recent Comments