mysqlÐÞ¸ÄÃÜÂë(°üÀ¨ÃÜÂëÍü¼ÇµÄÇé¿ö)
ÐÞ¸ÄrootÃÜÂëµÄʱºò°´ÕÕÍøÉϵÄ˵µÄ¾ÓȻɵɵµÄÖ´ÐÐÁËupdate user set password="asdf" where user="root"£»Ö´ÐÐÖ®ºó·¢ÏÖÃÜÂë´íÁË£¬½øÈ¥²»ÁË£¬ÓÚÊÇÕÛÌÚÁË°ëÌ죬·¢ÏÖmysqlµÄÃÜÂëÊǼÓÃܵIJ»ÊÇÃ÷ÎÄ´æ´¢µÄ£¬ËùÒԸĵÄʱºòÐèÒªÕâÑùset password=password("asdf")¡£´íÎóÒѾ·¢ÉúÁË£¬ÓÚÊǾͰ´ÕÕÏÂÃæµÄ·½Ê½È¥Ð޸ĴíÎóµÄmysqlÃÜÂë¡£
ÐÞ¸Ä/etc/my.cnfÔÚskip-slave-startºóÃæÔö¼ÓÒ»ÐÐskip-grant-tables
Ôٵǽ½øÈ¥£¬ÖØÐÂÐÞ¸ÄÃÜÂ룬¸Ä»ØÔÀ´µÄÅäÖþÍokÁË¡£
Ïà¹ØÎĵµ£º
<!--
/* 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:"\@ËÎÌå" ......
iMarine http://iMarine.blog.163.com
×¢Ã÷£º±¾Îĵµ²Î¿¼Jena 2.5Îĵµ£¬Ê¹ÓÃJena 2.5 APIºÍMySQL 5.0.4-beta-ntÊý¾Ý¿â¡£MySQLÇý¶¯°üʹÓõÄÊÇmysql-connector-java-3.1.10-bin.jar¡£
1 JenaµÄÊý¾Ý¿â½Ó¿Ú
JenaÌṩÁ˽«RDFÊý¾Ý´æÈë¹ØϵÊý¾Ý¿âµÄ½Ó¿Ú£¬Model¡¢Resource¡¢QueryµÈ½Ó¿Ú¿ÉÒÔÓÃÓÚ·ÃÎʺÍά»¤Êý¾Ý¿âÀïµÄRDFÊý ......
Ö÷ÒªµÄ³ÌÐò£º
package greeds.jdbc.sample;
import greeds.jdbc.util.JDBCUtil;
import java.io.*;
import java.sql.*;
public class MySQLBlobSample {
public static void main(String[] args) throws Exception {
// дÈëÊý¾Ý¿â
/*
*
* Connection ......
ÎÊÌâÊÇÕâÑùµÄ£ºÔÚ²åÈëÒ»ÐÐÊý¾ÝÇ°¾ÍÏëÒªÖªµÀ½«Òª²úÉúµÄid¡£±ÈÈç˵ÏëÓÃÀ´ÃüÃûÉÏ´«µÄÎļþ¡£Èç¹û²»ÊÂÏÈ»ñµÃid¾Í²»ÖªµÀÎļþÃû£¬¾Íû·¨ÔÚ²åÈëʱ°ÑÎļþ·¾¶±£´æµ½Êý¾Ý¿âÀïÁË¡£Èç¹û²»ÐèÒªÊÂÏÈ»ñµÃid£¬´ó¿ÉÒÔÔÚ²åÈëºóµ÷ÓÃmysql_insert_id()»òÕßÖ´ÐÐselect last_insert_id()£¬¾Í²»±ØÍùÏ¿´ÁË¡£ÎªÁËÕÕ¹ËÐÔ¼±µÄͬѧ£¬Ïȸø´ð°¸£º
$resul ......
MySQL ´¥·¢Æ÷¼òµ¥ÊµÀý
1¡¢Óï·¨£º
CREATE TRIGGER <´¥·¢Æ÷Ãû³Æ> --´¥·¢Æ÷±ØÐëÓÐÃû×Ö£¬×î¶à64¸ö×Ö·û£¬¿ÉÄܺóÃæ»á¸½Óзָô·û.ËüºÍMySQLÖÐÆäËû¶ÔÏóµÄÃüÃû·½Ê½»ù±¾ÏàÏó.
{ BEFORE | AFTER } --´¥·¢Æ÷ÓÐÖ´ÐеÄʱ¼äÉèÖ㺿ÉÒÔÉèÖÃΪʼþ·¢ÉúÇ°»òºó¡£
{ INSERT | UPDATE | DELETE } --ͬÑùÒ²ÄÜÉ趨´¥· ......