½ô¼±ÇóÖú£ºmysql´´½¨ºÍÓ¦ÓÃÊÓͼµÄÎÊÌâ
´ó¼ÒºÃ£¬ÎÒÔÚÓÃsql´´½¨ÊÓͼµÄʱºò£¬³öÏÖÎÊÌâÁË£¬´úÂëÈçÏ£º
use student_info;
create view results_view as
select r.student_id as ѧºÅ, s.student_name as ÐÕÃû, c.course_name as ¿Î³ÌÃû³Æ, r.result as ³É¼¨
from results r inner join students s on r.student_id=s.student_id
inner join courses c on r.course_id=c.course_id;
select * from results_view
where ¿Î³ÌÃû³Æ='¼ÆËã»úÓ¦Óûù´¡'and ³É¼¨ is not null
order by ³É¼¨ desc limit 3;
ÎÒ±£´æÎª8.9.sql,ÔËÐÐÁËһϣ¬³öÏÖ´íÎóÌáʾ£º
mysql> c:\wamp\www\8.9.sql
show warnings disabled.
show warnings disabled.
error:
unknown command '\8'
->
Õâ¸ö´íÎóÌáʾʲôÒâ˼£¿£¿¶øÇÒ£¬ÎÒûÓа취£¬»Øµ½mysql>µÄÌáʾ·û״̬ÁË¡£¡£¡£
°ÝÍдó¼Ò°ïÎÒ¿´¿´£¬Ð»Ð»~~~~
Ïà¹ØÎÊ´ð£º
×ö¸öÕ¾ÄÚËÑË÷£¬ÏÖÔÚÓÃlike ÕâÑùµÄЧÂÊʵÔÚÌ«µÍÁË£¬Ïë¸Ä³ÉÈ«ÎÄËÑË÷·½Ê½¡£
µ«¿´ÁËÍøÉÏ˵µÄÖÐÎÄÖ§³Ö²»ºÃ£¬ÏëÎÊһϸ÷λÐÖµÜÊÇÈçºÎ½â¾öÕâ¸öÎÊÌâµÄ£¿
µ¥¶À½¨Á¢Ö÷Ìâ±íºÍÄÚÈÝ±í ¼ìË÷Ö÷Ìâ
È»ºó¸ù¾ÝÖ÷Ìâ¼ìË÷Ä ......
ÎÒÔÚ×¢²áÒ³ÃæÐ´ÈëÁËÈçÏ´úÂ룺
<?php
$conn=mysql_connect("localhost","root","614510")or die("Êý¾Ý¿â·þÎñÆ÷Á¬½Ó´íÎó".mysql_error());
& ......
ѯÎÊ mysqlµÄÊý¾Ý¿â ¿âÃû³ÆÈçºÎ¸ü¸Ä
£¨±íÃûÊǺܼòµ¥µÄ£©
³¢ÊÔһϱäͨµÄ·½·¨£º
´´½¨Ò»¸öеÄÊý¾Ý¿âÃû³Æ
±¸·ÝÒªÐ޸ĵÄÊý¾Ý¿â£¬°Ñ±¸·ÝµÄÊý¾Ý»¹Ôµ½Ð½¨µÄÊý¾Ý¿âÖÐ
²»¹ýÕâ¸öʵʱÐÔ²»ºÃ£¬½¨ÒéÔÚÊý¾ ......
±¾ÈËÐÂÊÖ ÏÂÔØÁ˸ömysql ÇëÎÊÈçºÎ°²×°
mysql-5.1.32-linux-i686-glibc23.tar.gz
ÄãÊÇʲôϵͳ£¿
redhatµÄ»°¾ÍÈ¥ÏÂrpm£¬Ö±½Órpm -i xxxx.rpm¾ÍOKÁË
²»¹ý±¾ÈË»¹ÊÇÍÆ¼öʹÓð²×°µÄ°æ±¾
ÒýÓÃ
ÎÒ¿´Á ......
import java.sql.*;
public class A
{
public static void main(String[] args)
{
try
{
Class.forName("com.mysql.jdbc.Driver");
String url="jdbc:mysql://localhost ......