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

¡¾MySQLÊý¾ÝÀàÐÍ1Ö® ÊýÖµÀàÐÍ¡¿


MySQL»ù±¾ÊýÖµÀàÐÍ´óÖ¿ÉÒԷֳɣº
ÕûÊýÀàÐÍ£ºTINYINT¡¢SAMLLINT¡¢MEDIUMINT¡¢INT¡¢BIGINT--1×Ö½Ú¡¢2¡¢3.¡¢4¡¢8
¸¡µãÊýÀàÐÍ£ºFLOAT(m,d)¡¢DOUBLE(m,d)==REAL-4×Ö½Ú¡¢8
¶¨µãÊýÀàÐÍ£ºDECIMAL(m,d)¡¢NUMERIC-m+2×Ö½Ú¡¢8
λÀàÐÍ£ºBIT(m)-1-8×Ö½Ú
¸÷¸öÀàÐ͵ÄÏêϸ·¶Î§¿ÉÒԲο¼mysqlÎĵµ
 
 
Êý¾ÝÀàÐÍСÀý£º
1.ÕûÊýÀàÐÍ
create table t1
(
  id int,
  id2 int(4)
);
insert t1 select 1,2;
select * from t1;
+------+------+
| id   | id2  |
+------+------+
|    1 |    2 |
+------+------+
alter table t1 modify id int zerofill;
alter table t1 modify id2(4) int zerofill;
select * from t1;
+------------+------------+
| id         | id2        |
+------------+------------+
| 0000000001 | 0002      |
+------------+------------+
insert t1 select 1,11111;
Select * from t1;
+------------+------------+
| id         | id2        |
+------------+------------+
| 0000000001 | 0002 |
| 0000000001 | 11111 |
+------------+------------+
insert t1 select -1,-2;
+-------+------+---------------------------------------------+
| Level | Code | Message                                     |
+-------+------+---------------------------------------------+
| Error | 1264 | Out of range value 


Ïà¹ØÎĵµ£º

MySQL error 2003µÄ½â¾ö¹ý³Ì

MySQL error 2003µÄ½â¾ö¹ý³Ì¸Õ²ÅÂÛ̳³öÏÖ:
error 2003:Can't connect to MySQL server on ..............
 ÎÊÌâ:MYSQLÊý¾Ý¿âûÓÐÆô¶¯~
 ½â¾ö:°Ù¶ÈÁËÒ»ÏÂ,˵µÄ½â¾ö·½·¨¸÷ÖÖ¸÷Ñù,ºÜ¶à.
 1\ÔÚ“ÔËÐДÀïÕÒµ½C:\mysql\bin\mysqld-opt.exe ÔËÐоÍÊÇÁË£¡ÕÒÁË,ûÓÐÕâ¸ö¶«Î÷:(
2 ÔÚDosÏÂ cd \mysql ......

mysql ½¨Á¢Ë÷Òý

¾ÍÏóÐí¶àµÄPHP¿ª·¢ÕßÒ»Ñù£¬ÔÚ¸Õ¿ªÊ¼½¨Á¢¶¯Ì¬ÍøÕ¾µÄʱºò£¬ÎÒ¶¼ÊÇʹÓÃÏà¶Ô¼òµ¥
µÄÊý¾Ý½á¹¹¡£PHPÔÚÁ¬½ÓÊý¾Ý¿â·½ÃæµÄȷʵÊÇÊ®·Ö·½±ã£¨ÒëÕß×¢£ºÓÐЩÈËÈÏΪPHPÔÚÁ¬½Ó²»Í¬Êý¾Ý¿âʱûÓÐÒ»¸öͳһµÄ½Ó¿Ú£¬²»Ì«·½±ã£¬ÆäʵÕâ¿ÉÒÔͨ¹ýһЩÀ©
Õ¹¿âÀ´×öµ½ÕâÒ»µã£©£¬ÄãÎÞÐè¿´´óÁ¿µÄÉè¼ÆÎĵµ¾Í¿ÉÒÔ½¨Á¢ºÍʹÓÃÊý¾Ý¿â£¬ÕâÒ²ÊÇPHP»ñµÃ³É¹¦µÄÖ÷ ......

mysqlÎĵµÑ§Ï°3.6

Ô¶³ÌµÇ¼ -h IPµØÖ·
ctrl + d Í˳ö »ò \q »ò quit
select version(); µ±Ç°°æ±¾
current_dateµ±Ç°ÈÕÆÚ »òcurdate() »ò current_date()
SELECT name, birth, curdate(),(year(curdate())-year(birth)) - (right(curdate(),5)<right(birth,5)) as age from ±í ORDER BY name;
year ÌáÈ¡Ä겿·Ö right(curdate(),5)ÌáÈ¡Ó ......

AmfphpÓëFlex½»»¥:¶ÁÈ¡mysqlÊý¾Ý

·þÎñÆ÷¶Ë´úÂë,amfphpµÄservicesĿ¼Ï½¨Á¢readData.phpÎļþ,´úÂëÈçÏÂ
<?php
    class ReadDB
    {
              function getData()
            &nb ......

Mysql_ÃüÁî¹éÀà 91KGE

.Á¬½Ómysql    mysql -uroot -padmin -hlocalhost
.Á¬½ÓmysqladminÃüÁîÐпͻ§¶Ë³ÌÐò mysqladmin -uroot -padmin -hlocalhost
.Æô¶¯mysql   mysqld
.¹Ø±Õ  mysqladmin -uroot -padmin -hlocalhost shutdown
.ÐÞ¸ÄÃÜÂë
set password for 'root'@'localhost' = password('admin')
update ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ