Sars' History mysql

mysql:basic

Wed, 01 Jun 2016 10:32:47 +0800

文件 Techotopia: MySQL Essentials Check table exist or not 檢查資料表是否存在 $tbchk = "SHOW TABLES LIKE '$table' "; $tbchkres = mysql_query($tbchk); $tbchkres 回傳 1 代表存在，回傳 0 代表不存在。 Create table from other table's structure

mysql:c_api

Tue, 27 Jan 2009 16:13:39 +0800

MySQL C API Connect MySQL server using C program API under Linux or UNIX Requirements Make sure you have development environment installed such as gcc, mysql development package etc. Following is the list summarize the list of packages to compile program:

mysql:design

Mon, 27 Aug 2007 20:51:38 +0800

WWW SQL Designer 線上畫出 SQL 關係圖。

mysql:inet_aton

Fri, 16 Nov 2007 22:01:44 +0800

INET_ATON 利用 MySQL 內建函式將 IP 轉換成 int，範圍是 0 ~ 4294967295。建立 table CODE: [Copy to clipboard] CREATE TABLE `banned` ( `ip_start` int(10) NOT NULL default '0', `ip_end` int(10) NOT NULL default '0', ) TYPE=MyISAM COMMENT='禁止IP列表';

mysql:injection

Wed, 27 Aug 2008 00:23:37 +0800

GreenSQL 架設一個 SQL Proxy，監測查詢指令，若有疑似 injection 語法就不回傳任何資料。

mysql:myisamchk

Tue, 07 Apr 2009 09:29:59 +0800

MyISAMchk NAME myisamchk - MyISAM table-maintenance utility DESCRIPTION The myisamchk utility gets information about your database tables or checks, repairs, or optimizes them. myisamchk works with MyISAM tables (tables that have .MYD and .MYI files for storing data and indexes).

mysql:optimize

Sun, 12 Nov 2006 15:15:41 +0800

增進 MySQL 或 PHP 的效能 High Performance MySQL Simple Optimization for PHP and MySQL MySQL * MySQL is interpreted from right to left so you should put the most significant limiters as far to the right as possible. * Only select fields you need, instead of selecting * (everything).

mysql:sql_server_2005_driver_for_php

Wed, 03 Sep 2008 22:06:41 +0800

SQL Server 2005 Driver for PHP