MysqlÊýѧº¯Êý½âÎö
ËùÓеÄÊýѧº¯ÊýÔÚÒ»¸ö³ö´íµÄÇé¿öÏ·µ»ØNULL¡£
-
µ¥Ä¿¼õ¡£¸Ä±ä²ÎÊýµÄ·ûºÅ¡£
mysql> select - 2;
×¢Ò⣬Èç¹ûÕâ¸ö²Ù×÷·ûÓëÒ»¸öBIGINTʹÓ㬷µ»ØÖµÊÇÒ»¸öBIGINT£¡ÕâÒâζ×ÅÄãÓ¦¸Ã±ÜÃâÔÚÕûÊýÉÏʹÓÃ-£¬ÄÇ¿ÉÄÜÓÐÖµ-2^63£¡
ABS(X)
·µ»ØXµÄ¾ø¶ÔÖµ¡£
mysql> select ABS(2);
-> 2
mysql> select ABS(-32);
-> 32
¸Ã¹¦ÄÜ¿É°²È«ÓÃÓÚBIGINTÖµ¡£
SIGN(X)
·µ»Ø²ÎÊýµÄ·ûºÅ£¬Îª-1¡¢0»ò1£¬È¡¾öÓÚXÊÇ·ñÊǸºÊý¡¢Áã»òÕýÊý¡£
mysql> select SIGN(-32);
-> -1
mysql> select SIGN(0);
-> 0
mysql> select SIGN(234);
-> 1
MOD(N,M)
¡¡
%
Ä£ (ÀàËÆCÖеÄ%²Ù×÷·û)¡£·µ»ØN±»M³ýµÄÓàÊý¡£
mysql> select MOD(234, 10);
-> 4
mysql> select 253 % 7;
-> 1
mysql> select MOD(29,9);
-> 2
Õâ¸öº¯Êý¿É°²È«ÓÃÓÚBIGINTÖµ¡£
FLOOR(X)
·µ»Ø²»´óÓÚXµÄ×î´óÕûÊýÖµ¡£
mysql> select FLOOR(1.23);
-> 1
mysql> select FLOOR(-1.23);
-> -2
×¢Òâ·µ»ØÖµ±»±ä»»ÎªÒ»¸öBIGINT£¡
CEILING(X)
·µ»Ø²»Ð¡ÓÚXµÄ×îСÕûÊýÖµ¡£
mysql> select CEILING(1.23);
-> 2
mysql> select CEILING(-1.23);
-> -1
×¢Òâ·µ»ØÖµ±»±ä»»ÎªÒ»¸öBIGINT£¡
ROUND(X)
·µ»Ø²ÎÊýXµÄËÄÉáÎåÈëµÄÒ»¸öÕûÊý¡£
mysql> select ROUND(-1.23);
-> -1
mysql> select ROUND(-1.58);
-> -2
mysql> select ROUND(1.58);
-> 2
×¢Òâ·µ»ØÖµ±»±ä»»ÎªÒ»¸öBIGINT!
ROUND(X,D)
·µ»Ø²ÎÊýXµÄËÄÉáÎåÈëµÄÓÐDΪСÊýµÄÒ»¸öÊý×Ö¡£Èç¹ûDΪ0£¬½á¹û½«Ã»ÓÐСÊýµã»òСÊý²¿·Ö¡£
mysql> select ROUND(1.298, 1);
-> 1.3
mysql> select ROUND(1.298, 0);
-> 1
×¢Òâ·µ»ØÖµ±»±ä»»ÎªÒ»¸öBIGINT!
EXP(X)
·µ»ØÖµe£¨×ÔÈ»¶ÔÊýµÄµ×£©µÄX´Î·½¡£
mysql> select EXP(2);
-> 7.389056
mysql> select EXP(-2);
-> 0.
Ïà¹ØÎĵµ£º
#
-*- encoding: gb2312 -*-
import
os, sys, string
import
MySQLdb
#
Á¬½ÓÊý¾Ý¿â
try
:
conn
=
MySQLdb.connect(host
=
'
localhost
'
,user
=
'
root
'
,passwd
=
'
xxxx
'
,db
=
'
test1
'
)
except
Exception, e:
print
e
sys.exit()
......
<?php
/* vim: set expandtab tabstop=4 shiftwidth=4 foldmethod=marker: */
//===========================================
// ³ÌÐò£º mysql-Based Session Class
// ¹¦ÄÜ£º »ùÓÚmysql´æ´¢µÄ Session ¹¦ÄÜÀà
// ×÷Õß: yejr
// ÍøÕ¾: http://imysql.cn
// ʱ¼ä: 2007- ......
Linux ±àÒë°²×° MYSQL 5.1 Óë Innodb
±àÒëmysql5
´úÂë:
./configure \
--prefix=/usr/local/mysql \
--localstatedir=/usr/local/mysql/data \
--with-unix-socket-path=/usr/local/mysql/tmp/mysql.sock \
--with-extra-charsets=all \
--with-charset=utf8 \
- ......
ÓеÄÓû§£¬³öÓÚʹÓÃmysqlÊý¾Ý¿â¿ª·¢ÆäËû³ÌÐòµÄÐèÒª£¬¿ÉÄÜÏ£ÍûÐÞ¸ÄMysqlÊý¾Ý¿âµÄrootÓû§ÃÜÂ룬
ÏÖ×öÒÔϼòҪ˵Ã÷¡£
ÓÉÓÚOAʹÓõÄMysqlÊý¾Ý¿â±»É趨ΪֻÄÜ´Ó±¾»ú·ÃÎÊ£¬ËùÒÔÆÕͨÓû§²»½¨ÒéÐÞ¸ÄÊý¾Ý¿âÃÜÂ룬
ÐÞ¸ÄÊý¾Ý¿âÃÜÂë²¢²»ÊÇΪÁ˸ÄÉÆϵͳ°²È«ÐÔµÄÄ¿µÄ¡£
windows-¡µ¿ªÊ¼—¡µÔËÐУ¬ÊäÈëcmd½øÈëÃüÁîÐÐģʽ£¬²¢Ê¹Ó ......
<!--
/* Font Definitions */
@font-face
{font-family:ËÎÌå;
panose-1:2 1 6 0 3 1 1 1 1 1;
mso-font-alt:SimSun;
mso-font-charset:134;
mso-generic-font-family:auto;
mso-font-pitch:variable;
mso-font-signature:3 135135232 16 0 262145 0;}
@font-face
{font-family:"\@ËÎÌå" ......