Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ͨ¹ýSAS fastload Mysql table µ½ Teradata

/*clear fastload tables*/
%let gdw_dir =( user="XXXXX" password="XXXXX" database="XXXXX" tdpid="XXXXX");
proc sql;
connect to teradata as TD &gdw_dir;
execute (drop table STG_MYSQL_lkp_verticals)
by TD;
execute (commit) by TD;
disconnect from TD;
quit;
proc sql;
connect to teradata as TD &gdw_dir;
execute (drop table append_err1)
by TD;
execute (commit) by TD;
disconnect from TD;
quit;
proc sql;
connect to teradata as TD &gdw_dir;
execute (drop table append_err2)
by TD;
execute (commit) by TD;
disconnect from TD;
quit;
proc sql;
connect to teradata as TD &gdw_dir;
execute
(
create table STG_MYSQL_lkp_verticals
(
vertical varchar(10),
category_id integer,
category_name varchar(70),
short_name varchar(70)
)primary index(vertical,category_id)
)
by TD;
execute (commit) by TD;
disconnect from TD;
quit;
/*create source data table*/
libname bu_data mysql user='XXXXX' password='XXXXX' database='XXXXX' server='XXXXX' port=XXXX;
proc sql;
create table work.lkp_verticals as
select vertical, category_id, category_name, short_name
from bu_data.lkp_verticals
;
quit;
libname TDPET teradata databASe=XXXXX user="XXXXX" pASsword="XXXXX" TDPID="XXXXX";
proc append data=work.lkp_verticals base=TDPET.STG_MYSQL_lkp_verticals
(bulkload=yes bl_log=append_err);
run;


Ïà¹ØÎĵµ£º

MySQL´æ´¢ÒýÇæ

MySQLÓжàÖÖ´æ´¢ÒýÇæ£º
MyISAM¡¢InnoDB¡¢MERGE¡¢MEMORY(HEAP)¡¢BDB(BerkeleyDB)¡¢EXAMPLE¡¢FEDERATED¡¢ARCHIVE¡¢CSV¡¢BLACKHOLE¡£
MySQLÖ§³ÖÊý¸ö´æ´¢ÒýÇæ×÷Ϊ¶Ô²»Í¬±íµÄÀàÐ͵Ĵ¦ÀíÆ÷¡£MySQL´æ´¢ÒýÇæ°üÀ¨´¦ÀíÊÂÎñ°²È«±íµÄÒýÇæºÍ´¦Àí·ÇÊÂÎñ°²È«±íµÄÒýÇæ£º
¡ô MyISAM¹ÜÀí·ÇÊÂÎñ±í¡£ËüÌṩ¸ßËÙ´æ´¢ºÍ¼ìË÷£¬ÒÔ¼°È«ÎÄËÑË÷ÄÜÁ¦¡ ......

php mysql_connect Óëmysql_pconnectº¯ÊýÓëʵÀý½Ì³Ì

php½Ì³Ì mysql½Ì³Ì_connect Óëmysql_pconnectº¯ÊýÓëʵÀý½Ì³Ì
mysql_connect
 mysql_connect($this->root,$this->user,$this->pass)
/*
mysql_connect ,µ¥¸ö·´ÎÊÓû§²»»áƵ·±µÄµ÷ÓÃÊý¾Ý¿â½Ì³Ì£¬Ã»±ØÒª±£³ÖÁ¬½Ó£¬¶øÇÒmysqlµÄÁ¬½ÓÊýÒ²ÊÇÓÐÏÞÖÆµÄ£¬ ʹÓà ¼°Ê±·ÃÎÊ±È½ÏÆµ·±£¬Ò²×îºÃʹÓÃmysql_connect£¬ÕâÑùÊ¹Ó ......

mysql 5.0 to mysql 5.1µÄBTREEË÷ÒýÎÊÌâ


ÎÒ±¾»ú²âÊÔÊǰ²×°µÄ mysql 5.1 , µ« centos ·þÎñÆ÷ÉÏÈ·ÊÇʹÓÃµÄ mysql 5.0 , ƽʱû·¢ÏÖ²î±ð, µ«×î½üsql Îļþµ¼Èëµ¼³öʱ·¢ÏÖÁË, Ò»µãСС²î±ð.
Ö÷ÒªÊÇÔÚ´¦Àíµ½Ë÷ÒýÓï¾äʱ³öÏÖÁ˲»¼æÈݵÄÇé¿ö, ±ÈÈçÏÂÃæÓï¾äÊÇÔÚ mysql 5.1 µ¼³öµÄ:
KEY `index_2` (`datatype`,`stime`,`line`,`mcode`) USING BTREE
Èç¹ûÏëµ¼Èëµ½ mysql 5 ......

ÔÚFedora 12Öа²×°Apache2+PHP5+MySQL£¨LAMP£©

1.
ǰÑÔ
ÎÒʹÓõÄÖ÷»úÃûΪserver1.example.com
£¬ip
µØÖ·ÊÇ192.168.0.100
¡£ÕâЩÉèÖÿÉÄÜÓëÄãÏëÒªµÄÓÐËù²»Í¬£¬ËùÒÔÄã±ØÐëÔÚÊʵ±µÄµØ·½ÐÞ¸Äһϡ£
2
°²×°MySQL5
ÓÃÏÂÁÐÃüÁî°²×°MySQL
£º
yum install mysql mysql-server
È»ºóÎÒÃÇΪMySQL
´´½¨ÏµÍ³Æô¶¯Á´½Ó£¨ÕâÑùµÄ»°£¬MySQL
¾Í»áËæ×ÅϵͳÆô¶¯¶øÆô¶¯£©£¬²¢Æô¶¯ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ