ÂÌÉ«°æ±¾mysql³õʼ»¯´´½¨Óû§µÄÎÊÌâ
´ò¿ªºÚ´°¿Ú£¬Ìáʾ£º
Welcom to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 8
Server version:5.1.37-community MySQL Community Server <GPL>
Type 'help;' or '\h' for helt. Type '\c' to clear the current input statement.
mysql>
Õâ¸ö״̬ÎÒÊÇÒѾµÇ½ÁËô£¿Óû§ÃûÃÜÂëÊǶàÉÙ°¡¡£¡£¡£¡£ÎÒÏë´´½¨¸öÐÂÓû§£ºaaa,ÃÜÂëÊÇ123456£¬¸ÃÔõô×ö£¿
ÒѾµÇ¼ÁË¡£
grant all on *.* to 'aaa'@'%' identified by '123456';
°´ÕÕ1¥д·¨³ö±¨´íÌáʾÒô
ÏÔʾ£º
ERROR 1045 <28000>:Access denied for user ''@'localhost' <using password: NO>
mysql>
ÒªÊǶÔÃüÁî²»ÊìϤµÄ»°ÕÒ¸ö´°¿Ú³ÌÐòÁ¬ÉÏÈ¥£¬ÓÃÊó±êн¨Ò»¸öÄãÐèÒªµÄÓû§
ÄÇÂ鷳˸ø¸öºÃÓõĴ°¿Ú³ÌÐò°É¡£¡£¡£
»»³ÉÕâÌõÊÔÊÔ£º
grant all on *.* to 'aaa'@'localhsot' identified by '123456';
{{
Ïà¹ØÎÊ´ð£º
Ҫת³ÉÒ»ÑùµÄЧ¹û£¬ÓÃpowerdesignerÔõôת£¿ÄÜתÂð£¿
create table publishers (
publisherID int identity,
publisherName varchar (30) NOT NULL,
constraint pk_publishers primary key (publisherID)
)& ......
ÎÒ°²×°µÄÕâ¸öÈí¼þVertrigoServ£¬ÔÚwindows7ÖÐÔËÐУ¬Í¼±ê¼ÓºÅΪÀ¶É«£¬±¨MySQLµÄ´íÎó£¬Çë½Ì¸÷λ¸ßÊÖ¸ÃÔõÑù¸ü¸Ä¡£Ð»Ð»¸÷λ£¡
mysql ·þÎñÊÇ·ñÆðÀ´ÁË£¿
ûÓУ¬±¨µÄÊǶ˿ڴíÎó£¬ÔÚÅäÖÃÎļþµ±ÖиÄÁË£¬Ò²²»ÐÐ
¿ÉÒÔÓÃÈ ......
´ó¼Ò°ïÎÒ¿´Ï°ɣ¬±¾À´Êý¾Ý¿âûÓж«Î÷£¬ÄÜÏÔʾûÓж«Î÷µÄÐÅÏ¢£¬µ«ÊÇÎÒÌí¼ÓÁËÒ»ÌõÄÚÈݺó£¬×ÖûÁË£¬µ«ÊÇͼƬҲÎÞ·¨ÏÔʾ£¬ºì²æ²æÒ²Ã»ÓУ¬Ôõô»ØÊ°¡£¿
PHP code:
<?php
$str="select * from product wh ......
String SQL="insert into ѧÉúÐÅÏ¢±í values(StudentNumber,StudentName,StudentAge)";ÆäÖÐStudentNumber,StudentName,StudentAge¶¼ÊDZäÁ¿¡£ÕâÑùд²»¶Ô¡¡µ½µ×¸Ãզд°¡
Íò·Ö¸Ðл£¡
String SQL=&q ......
½ñÌìÀÏ´ó²¼ÖøöÈÎÎñ£¬ÒªÎÒÔÚÎÒÃǵIJúÆ·Öа²×°Ò»¸öMYSQLÊý¾Ý¿â£¬ÒªÇóÊÇÈí¼þÕ¼Óÿռ䲻Äܳ¬¹ý5M¡£
ÔÚÍøÉÏÕÒÁ˺þÃҲûÓÐÕÒµ½¹ØÓÚǶÈëʽϵͳÖÐMySQLÊý¾Ý¿âµÄ×ÊÁÏ£¬ÓеÄÒ²Ö»ÊǼòµ¥Ìáһϡ£
ÏÖÌØÏò¸÷λÇë½ÌÒÔÏÂÎÊÌ⣺
......