MySQLµÄÒþ²Ø»»ÐзûµÄ´¦Àí
£¨1£©ÔÚÉè¼ÆÊý¾Ý¿â×ֶεÄʱºò£¬°ÑÐèÒª»ñÈ¡ÊÖ»úºÅµÄ×Ö¶ÎÉèÖÃΪint(11)£¬ÔÒâÊÇҪȡ11λÊýµÄ£¬½á¹û·¢ÏÖËùÓеÄÊÖ»úºÅÂ룬¶¼±ä³ÉÁË2147483647
£¬¶Ùʱ¾õµÃºÜÆæ¹Ö£¬ÒÔΪÊdzÌÐòÓÐÎÊÌ⣬×îºó·¢¾õÊÇÊý¾Ý¿âÉè¼ÆµÄÎÊÌâ¡£ÒòΪÓзûºÅÕûÊýµÄ×î´óֵΪ
2147483647£¬ËùÒÔ×îºó¾ö¶¨°ÑÊý¾Ý¿âµÄ½á¹¹±ä»¯Ï£¬°Ñint(11)±äΪchar(11)²Å¸ã¶¨¡£
£¨2£©Êý¾Ý¿âÖÐÓм¸¸ö×ֶεÄÖµ×ÜÊÇÓл»Ðзû´æÔÚ£¬Í¨¹ýphpmyadmin½øÐÐËÑË÷£¬½Ó×Åͨ¹ýupdate dbName set field = replace(field,"\n","")£¬Ìæ»»ÁË»»Ðзûºó£¬ÔÚ°ÑÊý¾Ýͨ¹ýCVSµ¼³öµÄʱºò£¬Êý¾ÝµÄÖµ»¹ÊÇ»»ÐÐÁË£¬°Ù˼²»µÃÆä½â¡£È»ºóÎÒÔÚ´òËãͨ¹ýsqlµ¼³ö²¿·ÖÊý¾Ý½øÐвâÊÔµÄʱºò£¬½á¹û·¢ÏÖÎÊÌâÁË£¬Òþ²ØµÄ»»ÐзûÊÇ\r£¬ËùÒÔµ±ÄãµÄ×Ö¶ÎÖµµÄ×îºóÒ»¸ö×Ö·ûÊÇ\rʱ£¬±ÈÈçÄãµÄfieldµÄÖµ¿´ÆðÀ´ÊÇ"abc"£¬£¬select * from dbName where field='abc'£¬Äã»á·¢¾õÔõôҲËÑË÷²»µ½£¬±ØÐëҪʹÓÃselect * from dbName where field like 'abc%'£¬²Å¿ÉÒÔÕÒµ½¡£Õâ¸öʱºòÄãÐèÒªÓÃ
update dbName set field = replace(field,"\r","")£¬È»ºóÄã¾Í¿ÉÒÔʹÓÃselect * from dbName where field='abc'ËÑË÷µ½ÏàÓ¦µÄ¼Ç¼ÁË¡£
Ïà¹ØÎĵµ£º
Ò»¡¢Êý×ÖÀàÐÍ
ËùνµÄ“Êý×ÖÀà”£¬¾ÍÊÇÖ¸ DECIMAL ºÍ
NUMERIC£¬ËüÃÇÊÇͬһÖÖÀàÐÍ¡£ËüÑϸñµÄ˵²»ÊÇÒ»ÖÖÊý×ÖÀàÐÍ£¬ÒòΪËûÃÇʵ¼ÊÉÏÊǽ«Êý×ÖÒÔ×Ö·û´®ÐÎʽ±£´æµÄ£»ËûµÄÖµµÄÿһ루°üÀ¨Ð¡Êýµã£©Õ¼Ò»¸ö×ֽڵĴ洢¿Õ¼ä£¬Òò´ËÕâÖÖÀàÐͺķѿռä±È½Ï´ó¡£µ«ÊÇËüµÄÒ»¸öÍ»³öµÄÓŵãÊÇСÊýµÄλÊý¹Ì¶¨£¬ÔÚÔËËãÖв»»á“ʧ ......
import java.io.File;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import jxl.*;
public class ImportExcel {
public static void main(String[] args) {
File importExcel = new File("D:\\test\\test.xls");
try {
// Êý¾Ý¿âÁ¬½Ó
Class.forNa ......
from_unixtime()ÊÇMySQLÀïµÄʱ¼äº¯Êý
dateΪÐèÒª´¦ÀíµÄ²ÎÊý(¸Ã²ÎÊýÊÇUnix ʱ¼ä´Á),¿ÉÒÔÊÇ×Ö¶ÎÃû,Ò²¿ÉÒÔÖ±½ÓÊÇUnix ʱ¼ä´Á×Ö·û´®
ºóÃæµÄ '%Y%m%d' Ö÷ÒªÊǽ«·µ»ØÖµ¸ñʽ»¯
ÀýÈç:
mysql>SELECT from_UNIXTIME( 1249488000, '%Y%m%d' )
->20071120
mysql>SELECT from_UNIXTIME( 1249488000, '%YÄê%mÔ ......
mysql 5.0´æ´¢¹ý³Ìѧϰ×ܽá
mysql´æ´¢¹ý³ÌµÄ´´½¨£¬É¾³ý£¬µ÷Óü°ÆäËû³£ÓÃÃüÁî
mysql 5.0´æ´¢¹ý³Ìѧϰ×ܽá
Ò».´´½¨´æ´¢¹ý³Ì
1.»ù±¾Óï·¨£º
create procedure sp_name()
begin
………
end
2.²ÎÊý´«µÝ
¶þ.µ÷Óô洢¹ý³Ì
1.»ù±¾Óï·¨£ºcall sp_name()
×¢Ò⣺´æ´¢¹ý³ÌÃû³ÆºóÃæ±ØÐë¼ÓÀ¨ºÅ£¬ÄÄŸô洢¹ ......
mastering Phpmyadmin
Beginning Php And Mysql³ÌÐòÉè¼Æ
Beginning PHP and MySQL from Novice to Professional 3rd Edition
Head First PHP MySQL
MySQLÈëÞµä
MySQL Stored Procedure Pr ......