Ôõô°Ñpowerdesignerµ¼³öµÄsqlÓÃPHPµ¼ÈëMysQLÊý¾Ý¿â
ÎÒÃÇÖªµÀÓÃpowerdesignerµ¼³öµÄsqlÎļþºó׺Ϊ'.sql'£»ÓÃphpmyadminºÜÈÝÒ×µ¼ÈëMysQLÊý¾Ý¿â£¬µ«ÊÇÓÃPHPÔõôµ¼ÈëÊý¾Ý¿âÄØ?
ÎÒÓÃpowerdesignerÉè¼ÆÒ»¸öÊý¾Ý¿âºóµ¼³ösqlÎļþ£¨Ò»¸öͶƱϵͳ£©Îª'vote.sql'£»
ÎļþÄÚÈÝΪ£¨Ò»Ð©sqlÓï¾äºÍ×¢ÊÍ£©£º
/*==============================================================*/
/* DBMS name: MySQL 5.0 */
/* Created on: 2010-4-22 17:11:50 */
/*==============================================================*/
drop table if exists account_charge;
drop table if exists account_cost;
drop table if exists account_info;
drop table if exists charge_way;
drop table if exists user_askanswer;
drop table if exists user_info;
drop table if exists vote_fake;
drop table if exists vote_info;
drop table if exists vote_item;
drop table if exists vote_title;
drop table if exists vote_type;
/*==============================================================*/
/* Table: account_charge */
/*==============================================================*/
create table account_charge
(
chargeid int not null,
chargewayid int not null,
accountid
Ïà¹ØÎĵµ£º
<?php
* xCopy("feiy","feiy2",1):¿½±´feiyϵÄÎļþµ½ feiy2,ÍÆÏúÔ±µÄÒ»Ìì,°üÀ¨×ÓĿ¼
*²ÎÊý˵Ã÷£º
* $destination:Ä¿µÄĿ¼Ãû
......
PHPµÄrealpath(...)
Author:zfive5(zidong)
Email :zfive5@yahoo.com.cn
Òý×Ó£º
×òÌì°ïÈ˸ÄÁËÒ»ÏÂPHP³ÌÐò£¬ÔÚÅäeclipse+php(xdebug)+mysql+apacheºó£¬¾ÍÏÝÈëÒ»²½²½Âþ³¤¶ø·¦Î¶µÄµ÷ÊÔÖУ¬ËäÈ»¹¤¾ßÓÐЩ²»Ì«ºÃÓ㨵«Ò²¶Ôphp»·¾³9ÄêÀ´µÄ½ø²½¸Ðµ½ÐË·Ü£©£¬ ÔÚÕû¸öµ÷ÊÔ¹ý³ÌÖУ¬·¢ÏÖ×Ô¼ºÍêÈ«ÈÃrea ......
×òÌìÉϰàµÄʱºò£¬·¢ÏÖgoogle adµÄ¹ã¸æÉÏÓÐÁËÊÕÈ룬µ«ÊÇϰëÖ®ºó¾ÓÈ»·¢ÏÖad±»“0”ÁË¡£È¥ÍøÉϲéÁËÏà¹Ø×ÊÁÏ£¬·¢ÏÖÁËÎÊÌâ¡£
ÄÇôGoogleÊÇÈçºÎÈ·¶¨AdsenseÓû§×ÔÐеã»÷¹ã¸æµÄÄØ£¿
¼Çס£¬¾ÍÔÚÄãÔø¾×¢²áGoogle AdsenseÓû§µÄʱºò£¬Google¾ÍÖªµÀÄãµÄIPµØÖ·£¬×ÓÍøÒÔ¼°ÄãµçÄÔϵͳµÄÆäËû×ÊÁÏ¡£ÔÚGoogleµÄÊý¾Ý¿âÖÐÒ»Ö±¼ ......
ÓÉMySQLÌṩµÄģʽƥÅäµÄÆäËûÀàÐÍÊÇʹÓÃÀ©Õ¹ÕýÔò±í´ïʽ¡£µ±Äã¶ÔÕâÀàģʽ½øÐÐÆ¥Åä²âÊÔʱ£¬Ê¹ÓÃREGEXPºÍNOT REGEXP²Ù×÷·û(»òRLIKEºÍNOT RLIKE£¬ËüÃÇÊÇͬÒå´Ê)¡£ À©Õ¹ÕýÔò±í´ïʽµÄһЩ×Ö·ûÊÇ£º
“.”Æ¥ÅäÈκε¥¸öµÄ×Ö·û¡£
Ò»¸ö×Ö·ûÀà“[...]”Æ¥ÅäÔÚ·½À¨ºÅÄÚµÄÈκÎ×Ö·û¡£ÀýÈ磬“[abc]”ƥŠ......
PL/SQL-FOR UPDATE Óë FOR UPDATE OFµÄÇø±ð
url:http://hi.baidu.com/1413/blog/item/a521251f7e5993c4a686696b.html
Êý¾Ý¿â oracle for update of ºÍ for updateÇø±ð
select * from TTable1 for update Ëø¶¨±íµÄËùÓÐÐУ¬Ö»ÄܶÁ²»ÄÜд
2 select * from TTable1 wher ......