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

Mysql µ¼Èë .sqlÎļþÖÐÎÄÂÒÂ룿

 --default-character-set=utf8 ÓëÐÞ¸ÄsqlÎļþ¼ÓÈ룺SET NAMES 'utf8'; 
µ¼Èë½Å±¾Ê±£¬SET NAMES 'xxx' £¬xxxÓ¦¸ÃºÍsql½Å±¾ÎļþµÄʵ¼Ê±àÂëÒ»Ö£¬Èç¹ûÄãÉèÖõÄʱutf-8 £¬ÄÇôÇëÈ·ÈÏÄãµÄsql½Å±¾Îļþʱutf-8±£´æµÄ:
iconv -f UTF-8 xxx.sql
Èç¹ûÏÔʾÕý³££¬ÄÇôÕâÒ»²½¾ÍOKÁË
ÁíÍâ×¢ÒâÄãµÄ½Å±¾ÀÓÐûÓиø¿â±íÉèÖÃÕýÈ·µÄ±àÂë
ÔÚmysql×Ô´øCLI ClientÖУ¬ÔÚ²éѯºÍ¸üÐÂÊý¾Ý֮ǰ£¬ÇëÏÈSET NAMES 'xxx' £¬xxxΪÄãµÄÖն˵ıàÂë


Ïà¹ØÎĵµ£º

solarisÏÂmysqlÊý¾Ý¿â×Ö·û¼¯

solarisÏÂmysql°²×°Íê±ÏºóÖ´ÐÐÈçϲÙ×÷£¬¿ÉÒÔÐÞ¸ÄÊý¾Ý¿â×Ö·û¼¯£¬ÉèÖÃMySQLÔÚSolarisÉϱíÃû²»Çø·Ö´óСд
1.¿½±´ÎļþÈçÏ£º
cp /usr/sfw/share/mysql/my-medium.cnf /etc/my.cnf
°ÑÎļþÖ»¶ÁÊôÐÔÈ¥µô
chmod +w my.cnf
 
2 ÉèÖÃmysqlµÄ×Ö·û¼¯£ºÔÚ/etc/my.cnfÖеÄmysqld¶ÎºÍclient¶Î¼ÓÈë´úÂ룺
 
[client]
de ......

SQL 2008ÖеÄÍÚ¾òÄ£ÐÍ

SQL Server 2008 Áª»ú´ÔÊ飨2009 Äê 7 Ô£©
ÍÚ¾òÄ£ÐÍ£¨Analysis Services - Êý¾ÝÍÚ¾ò£©
±¾½Ú½éÉÜÁËÊý¾ÝÍÚ¾òÄ£Ð͵Ļù±¾Ìåϵ½á¹¹£¬¸ÅÊöÁËÊý¾ÝÍÚ¾òÄ£Ð͵ÄÊôÐÔ£¬²¢ËµÃ÷ÁË´´½¨ºÍ´¦ÀíÍÚ¾òÄ£Ð͵ķ½Ê½¡£
Mining Model Architecture
Defining Mining Models
Mining Model Properties
Mining Model Columns
Processing Min ......

sql serverÊÓͼµÄ×÷Óã¨×ª£©

    ËùνÊÓͼ£¨View£©ÆäʵÊÇÖ´ÐвéѯÓï¾äºóµÃµ½µÄ½á¹û£¬µ«Õâ¸ö²éѯ½á¹û¿ÉÒÔ·ÂÕæ³ÉÊý¾Ý±íÀ´Ê¹Óã¬ËùÒÔÓÐÈËÒ²³ÆËüΪ“ÐéÄâÊý¾Ý±í”£¬ÊÓͼÔÚ²Ù×÷ÉϺÍÊý¾Ý±íûÓÐÊ²Ã´Çø±ð£¬µ«Á½ÕߵIJîÒìÊÇÆä±¾ÖÊÊDz»Í¬µÄ£ºÊý¾Ý±íÊÇʵ¼Ê´æ´¢¼Ç¼µÄµØ·½£¬È»¶øÊÓͼ²¢²»±£´æÈκμǼ£¬Ëü´æ´¢µÄʵ¼ÊÉÏÊDzéѯÓï¾ä£¬ÆäËù³ÊÏÖ³ ......

sql ¶à±í¹ØÁª²éѯ

 create database example
use example
create table major
(
 spno varchar(10) primary key not null,
 spname varchar(20) not null
 )
 create table student
(
 sno varchar(10) primary key not null,
 sname varchar(10) not null,
 ssex varchar(2) not null, ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ