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

MySQL³£ÓÃÓï¾ä

/*²éѯÊý¾Ý¿â*/
show databases;
/*´´½¨Êý¾Ý¿â*/
create database dengheping;
/*ʹÓÃÊý¾Ý¿â*/
use dengheping;
/*´´½¨±í*/
create table user(id int primary key auto_increment,name char(255));
/*²éѯ±í*/
show tables;
/*ÏÔʾ±í½á¹¹*/
desc user;
/*²åÈë×Ö¶Î*/
alter table user add password varchar(64);
/*ÐÞ¸Ä×Ö¶Î*/
alter table user modify password varchar(64) not null;
/*ɾ³ý×Ö¶Î*/
alter table user drop password;
ÉèÖñàÂë
 alter database mybbs default character set 'gbk';


Ïà¹ØÎĵµ£º

hibernateµ÷ÓÃmysqlÖд洢¹ý³Ì

Ò»£® ½¨±íÓë³õʼ»¯Êý¾Ý
  ÔÚmysqlµÄtestÊý¾Ý¿âÖн¨Á¢Ò»ÕÅÐÂ±í£ºtbl_user,½¨±íÓï¾äÈçÏ£º
  DROP TABLE IF EXISTS `user`;
CREATE TABLE `tbl_user` (
   `userid` varchar(50) NOT NULL,
   `name` varchar(50) default '',
   `blog` varchar(50) default '',
   ......

MySQLÐÔÄÜÓÅ»¯


MySQLÐÔÄÜÓÅ»¯µÄ×î¼Ñ20+Ìõ¾­Ñé
½ñÌ죬Êý¾Ý¿âµÄ²Ù×÷Ô½À´Ô½³ÉΪÕû¸öÓ¦ÓõÄÐÔÄÜÆ¿¾±ÁË£¬Õâµã¶ÔÓÚWebÓ¦ÓÃÓÈÆäÃ÷ÏÔ¡£¹ØÓÚÊý¾Ý¿âµÄÐÔÄÜ£¬Õâ²¢²»Ö»ÊÇDBA²ÅÐèÒªµ£ÐĵÄÊ£¬¶øÕâ¸üÊÇÎÒÃdzÌÐòÔ±ÐèҪȥ¹Ø×¢µÄÊÂÇé¡£µ±ÎÒÃÇÈ¥Éè¼ÆÊý¾Ý¿â±í½á¹¹£¬¶Ô²Ù×÷Êý¾Ý¿âʱ£¨ÓÈÆäÊDzé±íʱµÄSQLÓï¾ä£©£¬ÎÒÃǶ¼ÐèҪעÒâÊý¾Ý²Ù×÷µÄÐÔÄÜ¡£ÕâÀÎÒÃDz»» ......

MySQL cmdÃüÁî

Á¬½Ó£ºmysql -hÖ÷»úµØÖ· -uÓû§Ãû £­pÓû§ÃÜÂë £¨×¢:uÓëroot¿ÉÒÔ²»Óüӿոñ£¬ÆäËüÒ²Ò»Ñù£©
¶Ï¿ª£ºexit £¨»Ø³µ£©
´´½¨ÊÚȨ£ºgrant select on Êý¾Ý¿â.* to Óû§Ãû@µÇ¼Ö÷»ú identified by \"ÃÜÂë\"
ÐÞ¸ÄÃÜÂ룺mysqladmin -uÓû§Ãû -p¾ÉÃÜÂë password ÐÂÃÜÂë
ɾ³ýÊÚȨ: revoke select,insert,update,delete om *.* from ......

MysqlÖÐTimestampµÄʹÓÃ

Timestamp·­Òë¹ýÀ´Ò²½Ð“ʱ¼ä´Á”£¬¿ÉÒÔ°üº¬“Äê-ÔÂ-ÈÕ-ʱ-·Ö-Ãë-ºÁÃ딣¬ÊÇjava.util.DateϵÄÒ»¸ö×ÓÀà¡£Èç¹ûÏëʵÏÖÏòMysqlÖвåÈë´øÓÐʱ·ÖÃëµÄʱ¼ä£¬ÔÚ±í½á¹¹ÀïÐèÒªÖ¸¶¨×Ö¶ÎÀàÐÍΪDateTime£¬Java³ÌÐòÀïÔÚ»ñȡϵͳʱ¼äºóÐèҪת»»ÎªÊ±·ÖÃëµÄ¸ñʽ£¬ÔÙת»»ÎªTimestamp¼´¿É£¬ÈçÏÂËùʾ£º
Date dt = new Dat ......

ÈÃMySQLÖ§³ÖInnoDB

ÔÚmysqlÖÐÊäÈëSHOW variables like "have_%"²é¿´£¬ÏÔʾÈçÏ£º
mysql> SHOW variables like "have_%";
  
+-----------------------+----------+
| Variable_name         | Value    |
+-----------------------+----------+
| have_archive     ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ