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

MySQLÈ¡×Ö½Úº¯Êý

±¾ÈË´¿Êô³õѧMySQL£¬ÏÖÏë°ÑÒ»¸öOracleÉϵĴ洢¹ý³Ì¸Äµ½MySQLÉÏ£¬µ«ÊÇÆäÖÐÓÐÒ»¸ösubstrbµÄ×Ö·û´®°´Î»·µ»ØÖµº¯Êý²»ÖªµÀÓ¦¸ÃÔõô×öÁË£¿Ï£Íû¸÷λǰ±²ÃÇÖ¸µãСµÜÎÒһϣ¬²»Ê¤¸Ð¼¤°¢~~~

Àýaaa := 'dsadsa';
  bbb := substrb(aaa,0,lengthb(aaa));
SQL code:
mysql> select SUBSTRING('Quadratically',5,6);
+--------------------------------+
| SUBSTRING('Quadratically',5,6) |
+--------------------------------+
| ratica |
+--------------------------------+
1 row in set (0.06 sec)

mysql>


Â¥Ö÷¿ÉÒԲο¼Ò»ÏÂÓû§ÊÖ²á
12.3. ×Ö·û´®º¯Êý
http://dev.mysql.com/doc/refman/5.1/zh/functions.html#string-functions

ÒýÓÃ
±¾ÈË´¿Êô³õѧMySQL£¬ÏÖÏë°ÑÒ»¸öOracleÉϵĴ洢¹ý³Ì¸Äµ½MySQLÉÏ£¬µ«ÊÇÆäÖÐÓÐÒ»¸ösubstrbµÄ×Ö·û´®°´Î»·µ»ØÖµº¯Êý²»ÖªµÀÓ¦¸ÃÔõô×öÁË£¿Ï£Íû¸÷λǰ±²ÃÇÖ¸µãСµÜÎÒһϣ¬²»Ê¤¸Ð¼¤°¢~~~

Àýaaa := 'dsadsa';
  bbb := substrb(aaa,0,lengthb(aaa));



Õâ¸ösubstrbºÍsubstring¿ÉÒÔÒ»Ñùʹô£¿
SELECT substring('¹«Ë¾',1,lengthb('¹«')-1);
-->¹«
ºÍ
SELECT substrb('¹«Ë¾',1,lengthb('¹«')-1);
Õâ¸ö¾Í²»ÊÇÁ˰É

ÒýÓÃ
SQL codemysql>selectSUBSTRING('Quadratically',5,6);+--------------------------


Ïà¹ØÎÊ´ð£º

apache+PHP+mysqlÔÚwin7ÏÂʹÓÃ

ÈçÌ⣬ÕâÈý¸öÔÚwin7ÏÂʹÓûáÓÐʲô¼æÈÝÐÔÎÊÌâÂð£¿
ÓÉÓÚÎÒ×î½üÔÚʹÓÃwin7£¬¾ÍÀÁµÃ½øxpÁË£¡
×Ô¼ºÓÃwindows 2008ÓÐÒ»Äê¶àÁË£¬Ã»³öÏÖÈκÎÎÊÌâ¡£

win7²âÊÔ°æÒ²Óùý£¬²»»áÓÐʲôÎÊÌâµÄ£¬·ÅÐÄ¡£

µ±È»Äã×î ......

MySqlÎÊÌâ

MySqlÖвåÈ뵱ǰʱ¼äµÄ¸ÃÔõôд°¡£¿
now()

SQL code:

sqlÀïÊÇ£º
getdate()

ÒýÓÃ
now()


ѧϰ

SQL code:
select now();

SQL code:
TODAY()
?

SQL code:
select now();
/* ......

Á¬½ÓMySQLʱUnknown columnÎÊÌ⣬Çó¸ßÊÖ½â´ð

import java.sql.*;

public class A
{
public static void main(String[] args)
{
try
{
Class.forName("com.mysql.jdbc.Driver");
String url="jdbc:mysql://localhost ......

mysql ²éѯÓï¾ä

select id,dtime,zt,optype( Èç¹ûoptype=0½«±¾ÌõÊý¾Ý²åÈëµ½table1±íÖУ¬Èç¹ûoptype=1ÒÔdtimeºÍztΪÌõ¼þÖ´ÐÐÒ»Ìõ²éѯÓï¾ä ) from table
ʵÏÖÕâ¸öÒªÇóµÄÓï·¨Ôõôд
Ò»ÌõSQLÓï¾ä¹À¼Æ¸ã²»¶¨¡£µÈ¥Ϻ÷½·¨£¡

Èç¹ ......

mysql°²×°ÎÊÌâ unpacking of archive failed on¡£¡£

linuxϵͳ Ô­À´×Ô´ømysqlÒѾ­Ð¶ÔØ ÐÂװа汾 °²×°Ê±Ìáʾ unpacking of  archive  failed on file usr/bin/ replace 4acebledle4d:cpio :read ÇëÎÊÊÇʲôÎÊÌâ

ÒýÓÃ
ÎļþÊÇÖ»¶ÁµÄ ¸ü¸ÄϸÃĿ¼ȨÏÞΪ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ