ÓÐÁ½¸ö±í£¬Ò»¸öÊÇÉÌÆ·±íalpro
ID int 4 ¶¨ÒåͼÊéidºÅ
lb varchar 20 ¼Ç¼ͼÊéËùÊôÀà±ð
shuliang int 4 ¼Ç¼ͼÊéµÄ¿â´æ
price2 float ¼Ç¼ͼÊéµÄ¼Û¸ñ
Ò»¸öÊÇÏúÊÛ±íxse
proid ¼Ç¼ÏúÊÛͼÊéµÄid
sl ¼Ç¼ÏúÊÛµÄÊýÁ¿
addtime ¼Ç¼ͼÊéÏúÊÛµÄʱ¼ä
Ïë×öÒ»¸öÊÓͼ£¬¾ÍÊǰ´ÉÌÆ·µÄÀà±ð¼ÆËã³öÿ¸öÔÂÿÖÖÀà±ðÉÌÆ·ÏúÊ۵Ľð¶ ......
create table sys_department (
dept_id bigint identity(1,1), //²¿ÃűàºÅ
dept_name varchar(60) not null, //²¿ÃÅÃû³Æ
parent_id bigint not null, //¸¸½Úµãid
isleaf char(1) ......
ÓÐÁ½Õűí
tb1 id name
01 ÕÅÈý
02 ÀîËÄ
tb2 id riqi renwu
01 2010.01.01 aaa
01 2010.02.02 bbb
......
ÇóÓйØMYSQLÊÓÆµ£¬Çë·¢ÖÁtanhualin1985@163.com
°ï¶¥..
ÎÒÒ²ÒªÖªµÀ¡£¡£¡£
ÎÒÓÐЩmysqlµÄѧϰ×ÊÁÏ£¬µ«²»ÊÇÊÓÆµµÄÄãÏÈ¿´¿´£¬²»Ò»¶¨·ÇÒª¿´ÊÓÆµ²ÅÄÜѧ¡£¡£
ûÓÐ °ï¶¥
ÒýÓÃ
ÇóÓйØMYSQLÊÓÆµ£¬Çë·¢ÖÁtanhualin1985@163.com
¹Ø×¢Ò»ÏÂ...
·Ç³£Ð»Ð»
µ½MYSQL°æÌáÎʱȽϺÏÊÊ
ÒýÓÃ
µ½MYSQL°æÌáÎʱȽϺÏÊÊ
].. ......
ÏÖÓÐÒ»ÕÅ»°ÎñÐÅÏ¢±í£¬½¨±íÓï¾äÈçÏ£º
create table VIP_RECKONING
(
N_ID NUMBER(20) not null,
PHONE_NUM VARCHAR2(11),
D_ACCOUNTDATE DATE,
N_MONTHRENT NUMBER(20,2),
N_BASERATE NUMBER(20,2),
N_LONGRATE NUMBER(20,2),
......
ÎÒÊǸöASPÐÂÊÖ£¬£¬ÏÖÔÚ×öÒ»¸öСÏîÄ¿£¬ÐèÒª¼Ó·ÀSQL×¢Èë¹¥»÷¡£
²»ÖªµÀ¸ÃÔõôʵÏÖ£¬Ö÷ÒªÊÇÔõôÑù°Ñ·À×¢ÈëµÄÏà¹Øº¯ÊýºÍÎÒµÄÎļþ½áºÏÆðÀ´ÄØ¡£
Çë´óϺ¶à¶àÖ¸µã
<%
dim sql_leach,sql_leach_0,Sql_DATA
sql_leach = "',and,exec,insert,select,delete,update,count,*,%,chr,mid,master,truncate,char,d ......