MySQLÊý¾Ý¿â¿¼ÊÔÊÔÌâ¼°´ð°¸

רҵ£ºÒƶ¯Í¨ÐÅ ¿ÆÄ¿£ºMySQLÊý¾Ý¿â Ò»¡¢µ¥ÏîÑ¡ÔñÌâ

1£®ÒÔϾۺϺ¯ÊýÇóÊý¾Ý×ܺ͵ÄÊÇ( ) A£®MAX B£®SUM C£®COUNT D£®AVG ´ð°¸£ºB

2£®¿ÉÒÔÓÃ( )À´ÉùÃ÷Óαê A£®CREATE CURSOR B£®ALTER CURSOR C£®SET CURSOR D£®DECLARE CURSOR ´ð°¸£ºD

3£®SELECTÓï¾äµÄÍêÕûÓï·¨½Ï¸´ÔÓ£¬µ«ÖÁÉÙ°üÀ¨µÄ²¿·ÖÊÇ( ) A£®½öSELECT B£®SELECT£¬FROM C£®SELECT£¬GROUP D£®SELECT£¬INTO ´ð°¸£ºB

4£®SQLÓï¾äÖеÄÌõ¼þÓÃÒÔÏÂÄÄÒ»ÏîÀ´±í´ï( ) A£®THEN B£®WHILE C£®WHERE D£®IF ´ð°¸£ºC

5£®Ê¹ÓÃCREATE TABLEÓï¾äµÄ( )×Ӿ䣬ÔÚ´´½¨»ù±¾±íʱ¿ÉÒÔÆôÓÃÈ«Îı¾ËÑË÷ A£®FULLTEXT B£®ENGINE C£®FROM D£®WHRER ´ð°¸£ºA

6£®ÒÔÏÂÄܹ»É¾³ýÒ»ÁеÄÊÇ( ) A£®alter table emp remove addcolumn B£®alter table emp drop column addcolumn C£®alter table emp delete column addcolumn D£®alter table emp delete addcolumn ´ð°¸£ºB

7£®ÈôÒª³·ÏúÊý¾Ý¿âÖÐÒѾ­´æÔڵıíS£¬¿ÉÓ㨠£©¡£ A£®DELETE TABLE S B£®DELETE S C£®DROP S D£®DROP TABLE S ´ð°¸£ºD

8£®²éÕÒ±í½á¹¹ÓÃÒÔÏÂÄÄÒ»Ïî( ) A£®FIND B£®SELETE C£®ALTER D£®DESC ´ð°¸£ºD

9£®ÒªµÃµ½×îºóÒ»¾äSELECT²éѯµ½µÄ×ÜÐÐÊý£¬¿ÉÒÔʹÓõĺ¯ÊýÊÇ( ) A£®FOUND_ROWS B£®LAST_ROWS C£®ROW_COUNT D£®LAST_INSERT_ID ´ð°¸£ºA

10£®ÔÚÊÓͼÉϲ»ÄÜÍê³ÉµÄ²Ù×÷ÊÇ( ) A£®²éѯ B£®ÔÚÊÓͼÉ϶¨ÒåеÄÊÓͼ C£®¸üÐÂÊÓͼ D£®ÔÚÊÓͼÉ϶¨ÒåÐÂµÄ±í ´ð°¸£ºD

11£®UNIQUEΩһË÷ÒýµÄ×÷ÓÃÊÇ( ) A£®±£Ö¤¸÷ÐÐÔÚ¸ÃË÷ÒýÉϵÄÖµ¶¼²»µÃÖظ´ B£®±£Ö¤¸÷ÐÐÔÚ¸ÃË÷ÒýÉϵÄÖµ²»µÃΪNULL C£®±£Ö¤²Î¼ÓΩһË÷ÒýµÄ¸÷ÁУ¬²»µÃÔٲμÓÆäËûµÄË÷Òý D£®±£Ö¤Î©Ò»Ë÷Òý²»Äܱ»É¾³ý ´ð°¸£ºA

12£®ÓÃÓÚ½«ÊÂÎñ´¦Àíдµ½Êý¾Ý¿âµÄÃüÁîÊÇ( ) A£®insert B£®rollback C£®commit D£®savepoint ´ð°¸£ºC

13£®²éÕÒÌõ¼þΪ£ºÐÕÃû²»ÊÇNULLµÄ¼Ç¼( ) A£®WHERE NAME ! NULL B£®WHERE NAME NOT NULL C£®WHERE NAME IS NOT NULL D£®WHERE NAME!=NULL ´ð°¸£ºC

14£®Ö÷¼üµÄ½¨Á¢ÓÐ( )ÖÖ·½·¨ A£®Ò» B£®ËÄ C£®¶þ D£®Èý ´ð°¸£ºD

15£®ÔÚÊÓͼÉϲ»ÄÜÍê³ÉµÄ²Ù×÷ÊÇ( ) A£®¸üÐÂÊÓͼÊý¾Ý

B£®ÔÚÊÓͼÉ϶¨ÒåеĻù±¾±í C£®ÔÚÊÓͼÉ϶¨ÒåеÄÊÓͼ D£®²éѯ ´ð°¸£ºB

16£®ÔÚSQLÓïÑÔÖУ¬×Ó²éѯÊÇ£¨ £© ¡£ A£®Ñ¡È¡µ¥±íÖÐ×Ö¶Î×Ó¼¯µÄ²éѯÓï¾ä B£® Ñ¡È¡¶à±íÖÐ×Ö¶Î×Ó¼¯µÄ²éѯÓï¾ä C£®·µ»Øµ¥±íÖÐÊý¾Ý×Ó¼¯µÄ²éѯÓïÑÔ D£®Ç¶Èëµ½ÁíÒ»¸ö²éѯÓï¾äÖ®ÖеIJéѯÓï¾ä ´ð°¸£ºD

17£®ÏòÊý¾Ý±íÖвåÈëÒ»Ìõ¼Ç¼ÓÃÒÔÏÂÄÄÒ»Ïî( ) A£®CREATE B£®INSERT C£®SAVE D£®UPDATE ´ð°¸£ºB

18£®ÔÚselectÓï¾äµÄwhere×Ó¾äÖУ¬Ê¹ÓÃÕýÔò±í´ïʽ¹ýÂËÊý¾ÝµÄ¹Ø¼ü×ÖÊÇ( ) A£®like B£®against C£®match D£®regexp ´ð°¸£ºD

19£®SQLÓïÑÔµÄÊý¾Ý²Ù×ÝÓï¾ä°üÀ¨SELECT¡¢INSERT¡¢UPDATE¡¢DELETEµÈ¡£ÆäÖÐ×îÖØÒªµÄ£¬Ò²ÊÇʹÓÃ×îƵ·±µÄÓï¾äÊÇ( )¡£ A£®UPDATE B£®SELECT C£®DELETE D£®INSERT ´ð°¸£ºB

20£® ÒÔÏÂÄÄÖÖ²Ù×÷Äܹ»ÊµÏÖʵÌåÍêÕûÐÔ( ) A£®ÉèÖÃΨһ¼ü B£®ÉèÖÃÍâ¼ü C£®¼õÉÙÊý¾ÝÈßÓà D£®ÉèÖÃÖ÷¼ü ´ð°¸£ºB

21£®SQLÓïÑÔÖУ¬É¾³ýÒ»¸öÊÓͼµÄÃüÁîÊÇ( ) A£®REMOVE B£®CLEAR C£®DELETE D£®DROP ´ð°¸£ºD

22£®ÐÞ¸ÄÊý¾Ý¿â±í½á¹¹ÓÃÒÔÏÂÄÄÒ»Ïî( ) A£®UPDATE B£®CREATE

C£®UPDATED D£®ALTER ´ð°¸£ºD

23£®ÔÚÈ«Îı¾ËÑË÷µÄº¯ÊýÖУ¬ÓÃÓÚÖ¸¶¨±»ËÑË÷µÄÁеÄÊÇ( ) A£®MATCH() B£®AGAINST() C£®FULLTEXT() D£®REGEXP() ´ð°¸£ºA

24£®ÒÔÏÂÓï¾ä´íÎóµÄÊÇ( ) A£®select sal+1 from emp; B£®select sal*10,sal*deptno from emp; C£®²»ÄÜʹÓÃÔËËã·ûºÅ D£®select sal*10,deptno*10 from emp; ´ð°¸£ºC

25£®ÏÂÁÐ( )²»ÊôÓÚÁ¬½ÓÖÖÀà A£®×óÍâÁ¬½Ó B£®ÄÚÁ¬½Ó C£®ÖмäÁ¬½Ó D£®½»²æÁ¬½Ó ´ð°¸£ºC

26£®ÈôÓÃÈçϵÄSQLÓï¾ä´´½¨ÁËÒ»¸ö±íSC£º( ) CREATE TABLE SC £¨S# CHAR£¨6£© NOT NULL£¬C# CHAR£¨3£© NOT NULL£¬SCORE INTEGER£¬NOTE CHAR£¨20£©£©£»ÏòSC±í²åÈëÈçÏÂÐÐʱ£¬£¨ £©ÐпÉÒÔ±»²åÈë ¡£ A£®£¨NULL£¬¡¯103¡¯£¬80£¬¡¯Ñ¡ÐÞ¡¯£© B£®£¨¡¯200823¡¯£¬¡¯101¡¯£¬NULL£¬NULL£© C£®£¨¡¯201132¡¯£¬NULL£¬86£¬¡¯ ¡¯£© D£®£¨¡¯201009¡¯£¬¡¯111¡¯£¬60£¬±ØÐÞ£© ´ð°¸£ºB

27£®É¾³ýÓû§Õ˺ÅÃüÁîÊÇ( ) A£®DROP USER B£®DROP TABLE USER C£®DELETE USER D£®DELETE FROM USER ´ð°¸£ºA

28£®ÒÔÏÂÓï¾ä´íÎóµÄÊÇ( ) A£® alter table emp delete column addcolumn; B£® alter table emp modify column addcolumn char(10); C£®alter table emp change addcolumn addcolumn int; D£® alter table emp add column addcolumn int; ´ð°¸£ºA

29£®×éºÏ¶àÌõSQL²éѯÓï¾äÐγÉ×éºÏ²éѯµÄ²Ù×÷·ûÊÇ( ) A£®SELECT B£®ALL

C£®LINK D£®UNION ´ð°¸£ºD

30£®´´½¨Êý¾Ý¿âʹÓÃÒÔÏÂÄÄÏî( ) A£®create mytest B£®create table mytest C£®database mytest D£®create database mytest ´ð°¸£ºD

31£®ÒÔÏÂÄÄÏîÓÃÀ´·Ö×é( ) A£®ORDER BY B£®ORDERED BY C£®GROUP BY D£®GROUPED BY ´ð°¸£ºD

32£®SQLÊÇÒ»ÖÖ( )ÓïÑÔ¡£ A£® º¯ÊýÐÍ B£®¸ß¼¶Ëã·¨ C£®¹ØϵÊý¾Ý¿â D£® È˹¤ÖÇÄÜ ´ð°¸£ºC

33£®É¾³ýÊý¾Ý±íÓÃÒÔÏÂÄÄÒ»Ïî( ) A£®DROP B£®UPDATE C£®DELETE D£®DELETED ´ð°¸£ºA

34£®ÈôÒªÔÚ»ù±¾±íSÖÐÔö¼ÓÒ»ÁÐCN£¨¿Î³ÌÃû£©£¬¿ÉÓÃ( A£®ADD TABLE S ALTER£¨CN CHAR£¨£¸£©£© B£®ALTER TABLE S ADD£¨CN CHAR£¨£¸£©£© C£®ADD TABLE S£¨CN CHAR£¨£¸£©£© D£®ALTER TABLE S £¨ADD CN CHAR£¨£¸£©£© ´ð°¸£ºB

35£®ÏÂÁеÄSQLÓï¾äÖУ¬( )²»ÊÇÊý¾Ý¶¨ÒåÓï¾ä¡£ A£®CREATE TABLE B£®GRANT C£®CREATE VIEW D£® DROP VIEW ´ð°¸£ºB

36£®ÒÔÏÂɾ³ý¼Ç¼ÕýÈ·µÄ( ) A£®delete from emp where name='dony'; B£®Delete * from emp where name='dony'; C£®Drop from emp where name='dony'; D£®Drop * from emp where name='dony';

) ´ð°¸£ºA

37£®É¾³ý¾­ÏúÉÌ1018µÄÊý¾Ý¼Ç¼µÄ´úÂëΪ( ) from distributors where distri_num=1018 A£®drop table B£®delete * C£®drop column D£®delete ´ð°¸£ºD

38£®°´ÕÕÐÕÃû½µÐòÅÅÁÐ( ) A£®ORDER BY DESC NAME B£®ORDER BY NAME DESC C£®ORDER BY NAME ASC D£®ORDER BY ASC NAME ´ð°¸£ºB

39£®¿ÉÒÔÔÚ´´½¨±íʱÓÃ( )À´´´½¨Î¨Ò»Ë÷Òý£¬Ò²¿ÉÒÔÓÃ( A£®Create table£¬Create index B£®ÉèÖÃÖ÷¼üÔ¼Êø£¬ÉèÖÃΨһԼÊø C£®ÉèÖÃÖ÷¼üÔ¼Êø£¬Create index D£®ÒÔÉ϶¼¿ÉÒÔ ´ð°¸£ºC

40£®ÔÚSELECTÓï¾äÖУ¬Ê¹Óùؼü×Ö( )¿ÉÒÔ°ÑÖظ´ÐÐÆÁ±Î A£®TOP B£®ALL C£®UNION D£®DISTINCT ´ð°¸£ºD

41£®ÒÔϾۺϺ¯ÊýÇóƽ¾ùÊýµÄÊÇ( ) A£®COUNT B£®MAX C£®AVG D£®SUM ´ð°¸£ºC

42£®·µ»Øµ±Ç°ÈÕÆڵĺ¯ÊýÊÇ( ) A£®curtime() B£®adddate() C£®curnow() D£®curdate() ´ð°¸£ºD

43£®ÓÃÀ´²åÈëÊý¾ÝµÄÃüÁîÊÇ( )£¬ÓÃÓÚ¸üеÄÃüÁîÊÇ( A£®INSERT£¬UPDATE B£®CREATE£¬INSERT INTO C£®DELETE£¬UPDATE D£®UPDATE,INSERT ´ð°¸£ºA

44£®SELECT COUNT(SAL) FROM EMP GROUP BY DEPTNO;Òâ˼ÊÇ( )À´´´½¨Î¨Ò»Ë÷Òý ) )

A£®Çóÿ¸ö²¿ÃÅÖеŤ×Ê B£®Çóÿ¸ö²¿ÃÅÖй¤×ʵĴóС C£®Çóÿ¸ö²¿ÃÅÖй¤×ʵÄ×ÛºÏ D£®Çóÿ¸ö²¿ÃÅÖй¤×ʵĸöÊý ´ð°¸£ºD

45£®ÒÔϱí´ï½µÐòÅÅÐòµÄÊÇ( ) A£®ASC B£®ESC C£®DESC D£®DSC ´ð°¸£ºC

46£®ÒÔÏÂÄÄÏî²»ÊôÓÚÊý¾ÝÄ£ÐÍ( ) A£®¹ØϵģÐÍ B£®Íø×´Ä£ÐÍ C£®²ã´ÎÄ£ÐÍ D£®ÍøÂçÄ£ÐÍ ´ð°¸£ºA

47£®ÓÐÈý¸ö±í£¬ËüÃǵļǼÐÐÊý·Ö±ðÊÇ10ÐС¢2ÐкÍ6ÐУ¬Èý¸ö±í½øÐн»²æÁ¬½Óºó£¬½á¹û¼¯Öй²ÓÐ( )ÐÐÊý¾Ý A£®18 B£®26 C£®²»È·¶¨ D£®120 ´ð°¸£ºD

48£®´ÓGROUP BY·Ö×éµÄ½á¹û¼¯ÖÐÔÙ´ÎÓÃÌõ¼þ±í´ïʽ½øÐÐɸѡµÄ×Ó¾äÊÇ( ) A£®FROM B£®ORDER BY C£®HAVING D£®WHERE ´ð°¸£ºC

49£®ÎªÊý¾Ý±í´´½¨Ë÷ÒýµÄÄ¿µÄÊÇ( ) A£®Ìá¸ß²éѯµÄ¼ìË÷ÐÔÄÜ B£®¹éÀà C£®´´½¨Î¨Ò»Ë÷Òý D£®´´½¨Ö÷¼ü ´ð°¸£ºA

50£®Èç¹ûÒª»Ø¹öÒ»¸öÊÂÎñ£¬ÔòҪʹÓÃ( )Óï¾ä¡£ A£®commit transaction B£® begin transaction C£® revoke D£®rollback transaction ´ð°¸£ºD

51£®²éÕÒÊý¾Ý±íÖеļǼÓÃÒÔÏÂÄÄÒ»Ïî( ) A£®ALTRE

B£®UPDATE C£®SELECT D£®DELETE ´ð°¸£ºC

52£®ÔÚMySQLÖУ¬½¨Á¢Êý¾Ý¿âÓÃ( ) A£®CREATE TABLEÃüÁî B£®CREATE TRIGGERÃüÁî C£®CREATE INDEXÃüÁî D£®CREATE DATABASEÃüÁî ´ð°¸£ºD

53£®MySQLÖУ¬Ô¤ÉèµÄ¡¢ÓµÓÐ×î¸ßȨÏÞ³¬¼¶Óû§µÄÓû§ÃûΪ( ) A£®test B£®Administrator C£®DA D£®root ´ð°¸£ºD

54£®ÒÔϲåÈë¼Ç¼ÕýÈ·µÄ( ) A£®insert into emp(ename,hiredate,sal) values (value1,value2,value3); B£®insert into emp (ename,sal)values(value1,value2,value3); C£®insert into emp (ename)values(value1,value2,value3); D£®insert into emp (ename,hiredate,sal)values(value1,value2); ´ð°¸£ºA

55£®ÔÚSQLÓïÑÔÖеÄÊÓͼVIEWÊÇÊý¾Ý¿âµÄ( ) A£®Íâģʽ B£®´æ´¢Ä£Ê½ C£®Ä£Ê½ D£® ÄÚģʽ ´ð°¸£ºA

56£®ÒÔÏÂÄÄÏîÓÃÀ´ÅÅÐò( ) A£®ORDERED BY B£®ORDER BY C£®GROUP BY D£®GROUPED BY ´ð°¸£ºB

57£®ÒÔϾۺϺ¯ÊýÇó¸öÊýµÄÊÇ( ) A£®AVG B£®SUM C£®MAX D£®COUNT ´ð°¸£ºD

58£®ÔÚselectÓï¾äÖУ¬ÊµÏÖÑ¡Ôñ²Ù×÷µÄ×Ó¾äÊÇ( ) A£®select B£®group by C£®where

D£®from ´ð°¸£ºC

59£®²éÕÒÊý¾Ý¿âÖÐËùÓеÄÊý¾Ý±íÓÃÒÔÏÂÄÄÒ»Ïî( ) A£®SHOW DATABASE B£®SHOW TABLES C£®SHOW DATABASES D£®SHOW TABLE ´ð°¸£ºB

60£®´¥·¢Æ÷²»ÊÇÏìÓ¦ÒÔÏÂÄÄÒ»Óï¾ä¶ø×Ô¶¯Ö´ÐеÄMysqlÓï¾ä A£®select B£®insert C£®delete D£®update ´ð°¸£ºA

61£®( )±íʾһ¸öеÄÊÂÎñ´¦Àí¿éµÄ¿ªÊ¼ A£®START TRANSACTION B£®BEGIN TRANSACTION C£®BEGIN COMMIT D£®START COMMIT ´ð°¸£ºA

62£®ÒÔÏÂÓï¾ä²»ÕýÈ·µÄÊÇ( ) A£®select * from emp; B£®select ename,hiredate,sal from emp; C£®select * from emp order deptno; D£®select * from where deptno=1 and sal<300; ´ð°¸£ºC

63£®delete from employeeÓï¾äµÄ×÷ÓÃÊÇ( ) A£®É¾³ýµ±Ç°Êý¾Ý¿âÖÐÕû¸öemployee±í£¬°üÀ¨±í½á¹¹ B£®É¾³ýµ±Ç°Êý¾Ý¿âÖÐemployee±íÄÚµÄËùÓÐÐÐ C£®ÓÉÓÚûÓÐwhere×Ӿ䣬Òò´Ë²»É¾³ýÈκÎÊý¾Ý D£®É¾³ýµ±Ç°Êý¾Ý¿âÖÐemployee±íÄڵĵ±Ç°ÐÐ ´ð°¸£ºB

64£®°´Õհ༶½øÐзÖ×é( ) A£®ORDER BY CLASSES B£®DORDER CLASSES C£®GROUP BY CLASSES D£®GROUP CLASSES ´ð°¸£ºC

65£®¸ñʽ»¯ÈÕÆڵĺ¯ÊýÊÇ( ) A£®DATEDIFF() B£®DATE_FORMAT() C£®DAY() D£®CURDATE() ´ð°¸£ºB

66£®ÀýÈçÊý¾Ý¿âÖÐÓÐA±í£¬°üÀ¨Ñ§Éú£¬Ñ§¿Æ£¬³É¼¨ £¬ÐòºÅËĸö×ֶΠ, Êý¾Ý¿â½á¹¹Îª ѧÉú ѧ¿Æ ³É¼¨ ÐòºÅ ÕÅÈý ÓïÎÄ 60 1 ÕÅÈý Êýѧ 100 2 ÀîËÄ ÓïÎÄ 70 3 ÀîËÄ Êýѧ 80 4 ÀîËÄ Ó¢Óï 80 5

ÉÏÊöÄÄÒ»ÁпÉ×÷ΪÖ÷¼üÁÐ( ) A£®ÐòºÅ B£®³É¼¨ C£®Ñ§¿Æ D£®Ñ§Éú ´ð°¸£ºA

67£®Ñ§Éú¹Øϵģʽ S£¨ S£££¬Sname£¬Sex£¬Age£©£¬SµÄÊôÐÔ·Ö±ð±íʾѧÉúµÄѧºÅ¡¢ÐÕÃû¡¢ÐÔ±ð¡¢ÄêÁä¡£ÒªÔÚ±íSÖÐɾ³ýÒ»¸öÊôÐÔ¡°ÄêÁ䡱£¬¿ÉÑ¡ÓõÄSQLÓï¾äÊÇ£¨ £©¡£ A£® UPDATE S Age B£®DELETE Age from S C£®ALTER TABLE S ¡®Age¡¯ D£® ALTER TABLE S DROP Age ´ð°¸£ºD

68£®ÒÔÏÂÄÄÏîÓÃÓÚ×óÁ¬½Ó( ) A£®JOIN B£®RIGHT JOIN C£®LEFT JOIN D£®INNER JOIN ´ð°¸£ºC

69£®Ò»ÕűíµÄÖ÷¼ü¸öÊýΪ( ) A£®ÖÁ¶à3¸ö B£®Ã»ÓÐÏÞÖÆ C£®ÖÁ¶à1¸ö D£®ÖÁ¶à2¸ö ´ð°¸£ºC

70£®SQLÓïÑÔÊÇ( )µÄÓïÑÔ£¬ÇáÒ×ѧϰ ¡£ A£®µ¼º½Ê½ B£®¹ý³Ì»¯ C£®¸ñʽ»¯ D£®·Ç¹ý³Ì»¯ ´ð°¸£ºD

71£®ÔÚÕýÔò±í´ïʽÖУ¬Æ¥ÅäÈÎÒâÒ»¸ö×Ö·ûµÄ·ûºÅÊÇ( ) A£®. B£®* C£®? D£®- ´ð°¸£ºA

72£®Ìõ¼þ¡°BETWEEN 20 AND 30¡±±íʾÄêÁäÔÚ20µ½30Ö®¼ä£¬ÇÒ( ) A£®°üÀ¨20Ëê²»°üÀ¨30Ëê B£®²»°üÀ¨20Ëê°üÀ¨30Ëê C£®²»°üÀ¨20ËêºÍ30Ëê D£®°üÀ¨20ËêºÍ30Ëê ´ð°¸£ºD

73£®ÒÔϱíʾ¿É±ä³¤¶È×Ö·û´®µÄÊý¾ÝÀàÐÍÊÇ( ) A£®TEXT B£®CHAR C£®VARCHAR D£®EMUM ´ð°¸£ºC

74£®ÒÔÏÂ˵·¨´íÎóµÄÊÇ( ) A£®SELECT max(sal),deptno,job FROM EMP group by sal; B£®SELECT max(sal),deptno,job FROM EMP group by deptno; C£®SELECT max(sal),deptno,job FROM EMP; D£®SELECT max(sal),deptno,job FROM EMP group by job; ´ð°¸£ºC

75£®ÒÔÏÂÆ¥Åä'1 ton'ºÍ'2 ton'¼°'3 ton'µÄÕýÔò±í´ïʽÊÇ( ) A£®'123 ton' B£®'1,2,3 ton' C£®'[123] ton' D£®'1|2|3 ton' ´ð°¸£ºC

76£®Æ´½Ó×ֶεĺ¯ÊýÊÇ( ) A£®SUBSTRING() B£®TRIM() C£®SUM£¨£© D£®CONCAT() ´ð°¸£ºD

77£®ÒÔÏÂɾ³ý±íÕýÈ·µÄ( ) A£®Delete * from emp B£®Drop database emp C£®Drop * from emp D£®delete database emp ´ð°¸£ºB

78£®ÏÂÁÐ˵·¨´íÎóµÄÊÇ( ) A£®GROUP BY ×Ó¾äÓÃÀ´·Ö×é WHERE ×Ó¾äµÄÊä³ö B£®WHERE ×Ó¾äÓÃÀ´É¸Ñ¡ FROM ×Ó¾äÖÐÖ¸¶¨µÄ²Ù×÷Ëù²úÉúµÄÐС£ C£®¾ÛºÏº¯ÊýÐèÒªºÍgroup by Ò»ÆðʹÓà D£®HAVING ×Ó¾äÓÃÀ´´ÓFROMµÄ½á¹ûÖÐɸѡÐÐ ´ð°¸£ºD

79£®Ìõ¼þÄêÁäBETWEEN 15 AND 35±íʾÄêÁäÔÚ15ÖÁ35Ö®¼ä£¬ÇÒ( A£®²»°üÀ¨15ËêºÍ35Ëê

) B£®°üÀ¨15Ë굫²»°üÀ¨35Ëê C£®°üÀ¨15ËêºÍ35Ëê D£®°üÀ¨35Ë굫²»°üÀ¨15Ëê ´ð°¸£ºC

80£®´´½¨ÊÓͼµÄÃüÁîÊÇ( ) A£®alter view B£®alter table C£®create table D£®create view ´ð°¸£ºD

81£®´æ´¢¹ý³ÌÊÇÒ»×éÔ¤Ïȶ¨Òå²¢( )µÄTransact-SQLÓï¾ä A£®±£´æ B£®±àд C£®±àÒë D£®½âÊÍ ´ð°¸£ºC

82£®·µ»Ø×Ö·û´®³¤¶ÈµÄº¯ÊýÊÇ( ) A£®len() B£®length() C£®left() D£®long() ´ð°¸£ºB

83£®´ÓÊý¾Ý±íÖвéÕҼǼÓÃÒÔÏÂÄÄÒ»Ïî( ) A£®UPDATE B£®FIND C£®SELECT D£®CREATE ´ð°¸£ºC 84£®SQLÓïÑÔ¼¯Êý¾Ý²éѯ¡¢Êý¾Ý²Ù×Ý¡¢Êý¾Ý¶¨ÒåºÍÊý¾Ý¿ØÖƹ¦ÄÜÓÚÒ»Ì壬ÆäÖУ¬CREATE¡¢DROP¡¢ALTERÓï¾äÊÇʵÏÖÄÄÖÖ¹¦ÄÜ( ) A£®Êý¾Ý²Ù×Ý B£®Êý¾Ý¿ØÖÆ C£®Êý¾Ý¶¨Òå D£®Êý¾Ý²éѯ ´ð°¸£ºC

85£®ÒÔÏÂÄÄÏî²»ÊôÓÚDML²Ù×÷( ) A£®insert B£®update C£®delete D£®create ´ð°¸£ºD

86£®°´ÕÕÐÕÃûÉýÐòÐòÅÅÁÐ( ) A£®ORDER BY NAME ASC B£®ORDER BY ASC NAME

C£®ORDER BY NAME DESC D£®ORDER BY DESC NAME ´ð°¸£ºA

87£®ÓйØϵS£¨S£££¬SNAME£¬SAGE£©£¬C£¨C£££¬CNAME£©£¬SC£¨S£££¬C£££¬GRADE£©¡£ÆäÖÐS££ÊÇѧÉúºÅ£¬SNAMEÊÇѧÉúÐÕÃû£¬SAGEÊÇѧÉúÄêÁ䣬 C££Êǿγ̺ţ¬CNAMEÊǿγÌÃû³Æ¡£Òª²éѯѡÐÞ¡°ACCESS¡±¿ÎµÄÄêÁ䲻СÓÚ20µÄÈ«ÌåѧÉúÐÕÃûµÄSQLÓï¾äÊÇSELECT SNAME FROM S£¬C£¬SC WHERE×Ӿ䡣ÕâÀïµÄWHERE×Ó¾äµÄÄÚÈÝÊÇ£¨ £©¡£ A£®SAGE>=20 and CNAME=¡¯ ACCESS¡¯ B£®S.S# = SC.S# and C.C# = SC.C# and SAGE in>=20 and CNAME in ¡®ACCESS¡¯ C£®SAGE in>=20 and CNAME in ¡®ACCESS¡¯ D£®S.S# = SC.S# and C.C# = SC.C# and SAGE>=20 and CNAME=¡®ACCESS¡¯ ´ð°¸£ºD

88£®ÒÔÏÂÄÄÏîÊôÓÚDDL²Ù×÷( ) A£®update B£®create C£® insert D£®delete ´ð°¸£ºB

89£®²éÕÒÌõ¼þΪ£ºÐÕÃûΪNULLµÄ¼Ç¼( ) A£®WHERE NAME NULL B£®\\WHERE NAME IS NULL C£®WHERE NAME=NULL D£®\\WHERE NAME ==NULL ´ð°¸£ºB

90£®Ìõ¼þ¡°IN(20,30,40)¡±±íʾ( ) A£®ÄêÁäÔÚ20µ½40Ö®¼ä B£®ÄêÁäÔÚ20µ½30Ö®¼ä C£®ÄêÁäÊÇ20»ò30»ò40 D£®ÄêÁäÔÚ30µ½40Ö®¼ä ´ð°¸£ºC

91£®ÕýÔò±í´ïʽµÄתÒå·ûÊÇ( ) A£®\\\\ B£®\\ C£®; D£®$$ ´ð°¸£ºA

92£®¸üÐÂÊý¾Ý±íÖеļǼÓÃÒÔÏÂÄÄÒ»Ïî( ) A£®DELETE B£®ALTRE C£®UPDATE D£®SELECT ´ð°¸£ºC

93£®¹ØϵÊý¾Ý¿âÖУ¬Ö÷¼üÊÇ( ) A£®´´½¨Î¨Ò»µÄË÷Òý£¬ÔÊÐí¿ÕÖµ

B£®Ö»ÔÊÐíÒÔ±íÖеÚÒ»×ֶν¨Á¢ C£®ÔÊÐíÓжà¸öÖ÷¼üµÄ D£®Îª±êʶ±íÖÐΨһµÄʵÌå ´ð°¸£ºD

94£®Ê¹ÓÃSELECTÓï¾äËæ»úµØ´Ó±íÖÐÌô³öÖ¸¶¨ÊýÁ¿µÄÐУ¬¿ÉÒÔʹÓõķ½·¨ÊÇ( ) A£®ÔÚLIMIT×Ó¾äÖÐʹÓÃRAND()º¯ÊýÖ¸¶¨ÐÐÊý£¬²¢ÓÃORDER BY×Ӿ䶨ÒåÒ»¸öÅÅÐò¹æÔò B£®Ö»ÒªÊ¹ÓÃLIMIT×Ӿ䶨ÒåÖ¸¶¨µÄÐÐÊý¼´¿É£¬²»Ê¹ÓÃORDER BY×Ó¾ä C£®Ö»ÒªÔÚORDER BY×Ó¾äÖÐʹÓÃRAND()º¯Êý£¬²»Ê¹ÓÃLIMIT×Ó¾ä D£®ÔÚORDER BY×Ó¾äÖÐʹÓÃRAND()º¯Êý£¬²¢ÓÃLIMIT×Ӿ䶨ÒåÐÐÊý ´ð°¸£ºD

95£®½øÈëÒª²Ù×÷µÄÊý¾Ý¿âTESTÓÃÒÔÏÂÄÄÒ»Ïî( ) A£®IN TEST B£®SHOW TEST C£®USER TEST D£®USE TEST ´ð°¸£ºD

96£®ÀýÈçÊý¾Ý¿âÖÐÓÐA±í£¬°üÀ¨Ñ§Éú£¬Ñ§¿Æ£¬³É¼¨Èý¸ö×ֶΠ, Êý¾Ý¿â½á¹¹Îª ѧÉú ѧ¿Æ ³É¼¨ ÕÅÈý ÓïÎÄ 80 ÕÅÈý Êýѧ 100 ÀîËÄ ÓïÎÄ 70 ÀîËÄ Êýѧ 80 ÀîËÄ Ó¢Óï 80

ÈçºÎͳ¼Æÿ¸öѧ¿ÆµÄ×î¸ß·Ö( ) A£®select ѧÉú,max(³É¼¨) from A group by ѧÉú; B£®select ѧÉú,max(³É¼¨) from A group byѧ¿Æ; C£®select ѧÉú,max(³É¼¨) from A order byѧÉú; D£®select ѧÉú,max(³É¼¨) from A group by ³É¼¨; ´ð°¸£ºB

97£®ÏÂÁÐÄÄЩÓï¾ä¶ÔÖ÷¼üµÄ˵Ã÷ÕýÈ·( ) A£®Ö÷¼ü¿ÉÖظ´ B£®Ö÷¼ü²»Î¨Ò» C£®ÔÚÊý¾Ý±íÖеÄΨһË÷Òý D£®Ö÷¼üÓÃforeign keyÐÞÊÎ ´ð°¸£ºC

98£®Êý¾Ý¿â·þÎñÆ÷¡¢Êý¾Ý¿âºÍ±íµÄ¹Øϵ£¬ÕýÈ·µÄ˵·¨ÊÇ( ) A£®Ò»¸öÊý¾Ý¿â·þÎñÆ÷Ö»ÄܹÜÀíÒ»¸öÊý¾Ý¿â£¬Ò»¸öÊý¾Ý¿âÖ»ÄÜ°üº¬Ò»¸ö±í B£®Ò»¸öÊý¾Ý¿â·þÎñÆ÷¿ÉÒÔ¹ÜÀí¶à¸öÊý¾Ý¿â£¬Ò»¸öÊý¾Ý¿â¿ÉÒÔ°üº¬¶à¸ö±í C£®Ò»¸öÊý¾Ý¿â·þÎñÆ÷Ö»ÄܹÜÀíÒ»¸öÊý¾Ý¿â£¬Ò»¸öÊý¾Ý¿â¿ÉÒÔ°üº¬¶à¸ö±í D£®Ò»¸öÊý¾Ý¿â·þÎñÆ÷¿ÉÒÔ¹ÜÀí¶à¸öÊý¾Ý¿â£¬Ò»¸öÊý¾Ý¿âÖ»ÄÜ°üº¬Ò»¸ö±í ´ð°¸£ºB

99£®ÀýÈçÊý¾Ý¿âÖÐÓÐA±í£¬°üÀ¨Ñ§Éú£¬Ñ§¿Æ£¬³É¼¨Èý¸ö×ֶΠ, Êý¾Ý¿â½á¹¹Îª ѧÉú ѧ¿Æ ³É¼¨ ÕÅÈý ÓïÎÄ 60

ÕÅÈý Êýѧ 100 ÀîËÄ ÓïÎÄ 70 ÀîËÄ Êýѧ 80 ÀîËÄ Ó¢Óï 80

ÈçºÎͳ¼Æ×î¸ß·Ö>80µÄѧ¿Æ( ) A£®SELECT MAX(³É¼¨) FROM A GROUP BYѧ¿Æ HAVING MAX(³É¼¨)>80; B£®SELECTѧ¿Æ FROM A GROUP BYѧ¿Æ HAVING³É¼¨>80; C£®SELECTѧ¿Æ FROM A GROUP BYѧ¿Æ HAVING MAX(³É¼¨)>80; D£®SELECTѧ¿Æ FROM A GROUP BYѧ¿Æ WHERE MAX(³É¼¨)>80; ´ð°¸£ºC

100£®Í³¼Æÿ¸ö²¿ÃÅÖÐÈËÊý( ) A£®SELECT SUM(ID) FROM EMP GROUP BY DEPTNO; B£®SELECT SUM(ID) FROM EMP ORDER BY DEPTNO; C£®SELECT COUNT(ID) FROM EMP ORDER BY DEPTNO; D£®SELECT COUNT(ID) FROM EMP GROUP BY DEPTNO; ´ð°¸£ºD

101£®DECIMALÊÇ( )Êý¾ÝÀàÐÍ A£®¿É±ä¾«¶È¸¡µãÖµ B£®ÕûÊýÖµ C£®Ë«¾«¶È¸¡µãÖµ D£®µ¥¾«¶È¸¡µãÖµ ´ð°¸£ºA

102£®ÊÓͼÊÇÒ»ÖÖ³£ÓõÄÊý¾Ý¶ÔÏó£¬ËüÊÇÌṩ( )ºÍ( )Êý¾ÝµÄÁíÒ»ÖÖ;¾¶£¬¿ÉÒÔ¼ò»¯Êý¾Ý¿â²Ù×÷ A£®²åÈ룬¸üРB£®²é¿´£¬¼ìË÷ C£®²é¿´£¬´æ·Å D£®¼ìË÷£¬²åÈë ´ð°¸£ºC

103£®É¾³ýÊý¾Ý±íÖеÄÒ»Ìõ¼Ç¼ÓÃÒÔÏÂÄÄÒ»Ïî( ) A£®DELETED B£®DELETE C£®DROP D£®UPDATE ´ð°¸£ºB

¶þ¡¢¶àÏîÑ¡ÔñÌâ

1£®´¥·¢Æ÷ÊÇÏìÓ¦ÒÔÏÂÈÎÒâÓï¾ä¶ø×Ô¶¯Ö´ÐеÄÒ»Ìõ»òÒ»×éMYSQLÓï¾ä( ) A£®UPDATE B£®INSERT C£®SELECT D£®DELETE ´ð°¸£ºB,A,D

2£®¶ÔÓÚɾ³ý²Ù×÷ÒÔÏÂ˵·¨ÕýÈ·µÄÊÇ£¨£© A£®drop database Êý¾Ý¿âÃû£º ɾ³ýÊý¾Ý¿â

B£®delete from ±íÃû£» ɾ³ý±íÖÐËùÓмǼÌõ C£®delete from ±íÃû where ×Ö¶ÎÃû=Öµ£»É¾³ý·ûºÏÌõ¼þµÄ¼Ç¼Ìõ D£®drop table ±íÃû£»É¾³ý±í ´ð°¸£ºB,C,D,A

3£®ÏÂÃæÕýÈ·µÄ˵·¨ÊÇ( ) A£®¹Ø¼ü×ÖÖ»ÄÜÓɵ¥¸öµÄÊôÐÔ×é³É B£®ÔÚÒ»¸ö¹ØϵÖУ¬¹Ø¼ü×ÖµÄÖµ²»ÄÜΪ¿Õ C£®Ò»¸ö¹ØϵÖеÄËùÓкòÑ¡¹Ø¼ü×Ö¾ù¿ÉÒÔ±»Ö¸¶¨ÎªÖ÷¹Ø¼ü×Ö D£®¹Ø¼ü×ÖÊǹØϵÖÐÄܹ»ÓÃÀ´Î©Ò»±êʶԪ×éµÄÊôÐÔ ´ð°¸£ºD,B,C

4£® ÒÔÏÂ˵·¨ÕýÈ·µÄÊÇ( ) A£® ×Ö·ûÐͼȿÉÓõ¥ÒýºÅÒ²¿ÉÓÃË«ÒýºÅ½«´®ÖµÀ¨ÆðÀ´ B£®×Ö·ûÐ͵Ä87398143²»²ÎÓë¼ÆËãµÄ C£®87398143 ²»ÄÜÉùÃ÷ΪÊýÖµÐÍ D£® ÊýÖµÐ͵Ä87398143½«²ÎÓë¼ÆË㠴𰸣ºA,D,B

5£®¹ØÓÚÖ÷¼üÏÂÁÐ˵·¨ÕýÈ·µÄÊÇ£¨£© A£®¿ÉÒÔÊDZíÖеÄÒ»¸ö×ֶΣ¬ B£®ÊÇÈ·¶¨Êý¾Ý¿âÖеıíµÄ¼Ç¼µÄΨһ±êʶ×ֶΣ¬ C£®¸Ã×ֶβ»¿ÉΪ¿ÕÒ²²»¿ÉÒÔÖظ´ D£®¿ÉÒÔÊDZíÖеĶà¸ö×Ö¶Î×é³ÉµÄ¡£ ´ð°¸£ºB,A,D,C

6£®mySQLÖ§³ÖÄÄЩÂß¼­ÔËËã·û

A£®&& B£®|| C£®NOT D£®AND ´ð°¸£ºD,C

7£®ÒÔϲ»ÊôÓÚ¸¡µãÐ͵ÄÊÇ£¨£© A£®smallint B£®mediumint C£®float D£®int ´ð°¸£ºA,B,D

8£®ÏÂÁÐÕýÈ·µÄÃüÁîÊÇ( ) A£®show tables; B£®show columns; C£®show columns from customers; D£®show databases; ´ð°¸£ºD,A,C

9£®ÕýÔò±í´ïʽÖУ¬Öظ´Ôª×Ö·û¡°*¡±±íʾ( ) A£®ÎÞÆ¥Åä

B£®Ö»Æ¥Åä1¸ö C£®0¸öÆ¥Åä D£®¶à¸öÆ¥Åä ´ð°¸£ºC,D

10£®ÏÂÃæ¶Ô union µÄÃèÊöÕýÈ·µÄÊÇ( ) A£®union Ö»Á¬½Ó½á¹û¼¯ÍêÈ«Ò»ÑùµÄ²éѯÓï¾ä B£®union ¿ÉÒÔÁ¬½Ó½á¹û¼¯ÖÐÊý¾ÝÀàÐ͸öÊýÏàͬµÄ¶à¸ö½á¹û¼¯ C£®union ÊÇɸѡ¹Ø¼ü´Ê£¬¶Ô½á¹û¼¯ÔÙ½øÐвÙ×÷ D£®ÈκβéѯÓï¾ä¶¼¿ÉÒÔÓà union À´Á¬½Ó ´ð°¸£ºD,A,C

11£®ÏÂÁÐÄÄÒ»¸öÂß¼­ÔËËã·ûµÄÓÅÏȼ¶ÅÅÁв»ÕýÈ·( ) A£®AND/NOT/OR B£®NOT/AND/OR C£®OR/NOT /AND D£®OR/AND/NOT ´ð°¸£ºA,C,D

12£® ¶Ôij¸öÊý¾Ý¿â½øÐÐɸѡºó , ( )¡£ A£® B£©¿ÉÒÔÑ¡³ö·ûºÏijЩÌõ¼þ×éºÏµÄ¼Ç¼ B£®D£©²»ÄÜÑ¡Ôñ³ö·ûºÏÌõ¼þ×éºÏµÄ¼Ç¼ C£®A£©¿ÉÒÔÑ¡³ö·ûºÏijЩÌõ¼þµÄ¼Ç¼ D£®C£©Ö»ÄÜÑ¡Ôñ³ö·ûºÏijһÌõ¼þµÄ¼Ç¼ ´ð°¸£ºC,A

13£®ÏÂÁÐÓï¾ä´íÎóµÄÊÇ( ) A£®select * from orders where ordername is not null; B£®select * from orders where ordername<>null; C£®select * from orders where ordername is null; D£®select * from orders where ordername not is null; ´ð°¸£ºD,B

14£®ÔÚÏÂÁйØÓÚ¹ØϵµÄÐðÊöÖУ¬ÕýÈ·µÄÊÇ( ) A£®C£©ÐÐÔÚ±íÖеÄ˳ÐòÎ޹ؽôÒª B£® A£©±íÖÐÈÎÒâÁ½ÐеÄÖµ²»ÄÜÏàͬ C£® D£©ÁÐÔÚ±íÖеÄ˳ÐòÎ޹ؽôÒª D£®B£©±íÖÐÈÎÒâÁ½ÁеÄÖµ²»ÄÜÏàͬ ´ð°¸£ºB,A,C

15£®ÏÂÃæϵͳÖÐÊôÓÚ¹ØϵÊý¾Ý¿â¹ÜÀíϵͳµÄÊÇ( ) A£® B£©MS_SQL SERVER B£®A£©Oracle C£® C£©IMS D£® D£©DB2 ´ð°¸£ºB,A,C

16£®ÏÂÁÐÊÇMYSQL±È½ÏÔËËã·ûµÄÊÇ( )

A£®!= B£®<> C£®== D£®>= ´ð°¸£ºD,B,A

17£®Excel ÖÐÓйØÊý¾Ý¿âÄÚÈÝ , ÃèÊöÕýÈ·µÄÓÐ( )¡£ A£®Ã¿Ò»¸ö Excel Êý¾Ý¿â¶ÔÓ¦Ò»¸ö¹¤×÷²¾Îļþ B£®Ò»ÁÐΪһ¸ö×ֶΠ, ÃèÊöʵÌå¶ÔÏóµÄÊôÐÔ C£®Excel Êý¾Ý¿âÊôÓÚ¡°¹ØϵÊý¾ÝÄ£ÐÍ¡±, ÓÖ³ÆΪ¹ØϵÐÍÊý¾Ý¿â D£®Ò»ÐÐΪһ¸ö¼Ç¼ , ÃèÊöij¸öʵÌå¶ÔÏó ´ð°¸£ºD,B,C

18£®ÏÂÃæ¹ØÓÚʹÓÃUPDATEÓï¾ä£¬ÕýÈ·µÄÊÇ( ) A£®±»¶¨ÒåΪNOT NULLµÄÁв»¿ÉÒÔ±»¸üÐÂΪNULL B£®²»ÄÜÔÚÒ»¸ö×Ó²éѯÖиüÐÂÒ»¸ö±í£¬Í¬Ê±´Óͬһ¸ö±íÖÐÑ¡Ôñ C£®²»ÄÜ°ÑORDER BY»òLIMITÓë¶à±íÓï·¨µÄUPDATEÓï¾äͬʱʹÓà D£®Èç¹û°ÑÒ»ÁÐÉèÖÃΪÆ䵱ǰº¬ÓеÄÖµ£¬Ôò¸ÃÁв»»á¸üР´ð°¸£ºD,C,B

19£® ¹ØÓÚExcel Êý¾Ý¿âÓ¦ÓõÄÃèÊöÕýÈ·µÄÓÐ( )¡£ A£®ÊÇÒ»¸öÊý¾ÝÇåµ¥ B£®ÊÇ°´Ò»¶¨×éÖ¯·½Ê½´æ´¢ÔÚÒ»ÆðµÄÏà¹ØÊý¾ÝµÄ¼¯ºÏ C£®ÊÇÒ»¸öÊý×é D£®ÊdzÌÐò»¯µÄµç×Ó±í¸ñ ´ð°¸£ºB,A

20£®¹ØÓÚDELETEºÍTRUNCATE TABLEµÄ˵·¨£¬ÕýÈ·µÄÊÇ( ) A£®Á½Õ߶¼¿ÉÒÔɾ³ýÖ¸¶¨ÌõÄ¿µÄ¼Ç¼ B£®Ç°Õß¿ÉÒÔɾ³ýÖ¸¶¨ÌõÄ¿µÄ¼Ç¼£¬ºóÕß²»ÄÜ C£®Á½Õ߶¼·´»Ø±»É¾³ý¼Ç¼µÄÊýÄ¿ D£®Ç°Õß·µ»Ø±»É¾³ý¼Ç¼ÊýÄ¿£¬ºóÕß²»·µ»Ø ´ð°¸£ºB,D

21£®¹ØÓÚÓα꣬ÏÂÁÐ˵·¨ÕýÈ·µÄÊÇ( ) A£®ÉùÃ÷ºó±ØÐë´ò¿ªÓαêÒÔ¹©Ê¹Óà B£®½áÊøÓαêʹÓÃʱ£¬±ØÐë±ÕÓαê C£®Ê¹ÓÃÓαêÇ°±ØÐëÉùÃ÷Ëü D£®ÓαêÖ»ÄÜÓÃÓÚ´æ´¢¹ý³ÌºÍº¯Êý ´ð°¸£ºD,C,A,B

22£®ÏÂÁÐ˵·¨ÕýÈ·µÄÊÇ( ) A£®ÔÚMySQLÖУ¬²»ÔÊÐíÓпձí´æÔÚ£¬¼´Ò»ÕÅÊý¾Ý±íÖв»ÔÊÐíûÓÐ×ֶΡ£ B£®ÔÚMySQLÖУ¬¶ÔÓÚ´æ·ÅÔÚ·þÎñÆ÷ÉϵÄÊý¾Ý¿â£¬Óû§¿ÉÒÔͨ¹ýÈκοͻ§¶Ë½øÐзÃÎÊ¡£ C£®Êý¾Ý±íµÄ½á¹¹Öаüº¬×Ö¶ÎÃû¡¢ÀàÐÍ¡¢³¤¶È¡¢¼Ç¼¡£ D£®×Ö·ûÐÍÊý¾ÝÆä³£Á¿±êÖ¾Êǵ¥ÒýºÅºÍË«ÒýºÅ£¬ÇÒÁ½ÖÖ·ûºÅ¿ÉÒÔ»ìÓᣠ´ð°¸£ºB,A

23£®ÏÂÃæÊý¾Ý¿âÃû³ÆºÏ·¨µÄÊÇ( ) A£®db1/student B£®db1.student

C£®db1_student D£®db1&student ´ð°¸£ºD,C

24£®ÏÂÃæÓï¾äÖУ¬±íʾ¹ýÂÇÌõ¼þÊÇvend_id=1002»òvend_id=1003µÄÊÇ( ) A£®select * from products where vend_id=1002 or vend_id=1003 B£®select * from products where vend_id in (1002,1003); C£®select * from products where vend_id not in (1004,1005); D£®select * from products where vend_id=1002 and vend_id=1003 ´ð°¸£ºB,A

25£®ÏÂÁÐÄÄЩÁÐÀàÐÍÊÇÊýÖµÐ͵ÄÊý¾Ý( )¡£ A£®DOUBLE B£®INT C£®SET D£®FLOAT ´ð°¸£ºB,A,D

26£®ÒÔÏ·ñ¶¨Óï¾ä´îÅäÕýÈ·µÄÊÇ£¨£© A£®not in B£®in not C£®not between and D£®is not null ´ð°¸£ºC,A,D

27£®ÏÂÃæ¼ìË÷½á¹ûÒ»¶¨²»ÊÇÒ»ÐеÄÃüÁîÊÇ( ) A£®select distinct * from orders ; B£®select * from orders limit 1,2; C£®select top 1 * from orders; D£®select * from orders limit 1; ´ð°¸£ºC,A,B

28£®ÒÔÏÂÄÄЩÊÇmySQLÊý¾ÝÀàÐÍ£¨£© A£®BIGINT B£®TINYINT C£®INTEGER D£®INT ´ð°¸£ºD,C,A,B

29£®¹ØÓÚgroup by ÒÔÏÂÓï¾äÕýÈ·µÄÊÇ( ) A£®SELECT store_name FROM Store_Information GROUP BY store_name B£® SELECT SUM(sales) FROM Store_Information GROUP BY sales C£®SELECT store_name, price SUM(sales) FROM Store_Information GROUP BY store_name£¬price D£®SELECT store_name, SUM(sales) FROM Store_Information GROUP BY store_name ´ð°¸£ºD,C,B

30£® ÔÚÊý¾Ý¿âϵͳÖУ¬ÓÐÄļ¸ÖÖÊý¾ÝÄ£ÐÍ£¿( )

A£® D£©ÊµÌåÁªÏµÄ£ÐÍ B£® C£©¹ØϵģÐÍ C£® A£©Íø×´Ä£ÐÍ D£® B£©²ã´ÎÄ£ÐÍ ´ð°¸£ºC,D,B

31£® ¹ØÓÚCREATEÓï¾äÏÂÁÐ˵·¨ÕýÈ·µÄÊÇ£¨£©

A£®create table ±íÃû(×Ö¶ÎÃû1 ×Ö¶ÎÀàÐÍ,×Ö¶ÎÃû2 ×Ö¶ÎÀàÐÍ,.....) B£® create tables ±íÃû(×Ö¶ÎÀàÐÍ,×Ö¶ÎÃû1 ×Ö¶ÎÀàÐÍ,×Ö¶ÎÃû2.....) C£®create tables ±íÃû(×Ö¶ÎÃû1 ×Ö¶ÎÀàÐÍ,×Ö¶ÎÃû2 ×Ö¶ÎÀàÐÍ,.....) D£® create table ±íÃû(×Ö¶ÎÀàÐÍ,×Ö¶ÎÃû1 ×Ö¶ÎÀàÐÍ,×Ö¶ÎÃû2.....) ´ð°¸£ºA,D

32£®ÒÔÏÂ˵·¨ÕýÈ·µÄÊÇ( ) A£®Ò»¸ö·þÎñÆ÷Ö»ÄÜÓÐÒ»¸öÊý¾Ý¿â B£®Ò»¸ö·þÎñÆ÷¿ÉÒÔÓжà¸öÊý¾Ý¿â C£®Ò»¸öÊý¾Ý¿âÖ»Äܽ¨Á¢Ò»ÕÅÊý¾Ý±í D£®Ò»¸öÊý¾Ý¿â¿ÉÒÔ½¨Á¢¶àÕÅÊý¾Ý±í ´ð°¸£ºB,D

33£®ÏÂÁÐ˵·¨ÕýÈ·µÄÊÇ( ) A£®Ò»ÕÅÊý¾Ý±íÒ»µ©½¨Á¢Íê³É£¬ÊDz»ÄÜÐ޸ĵġ£ B£®ÔÚMySQLÖУ¬Óû§ÔÚµ¥»úÉϲÙ×÷µÄÊý¾Ý¾Í´æ·ÅÔÚµ¥»úÖС£ C£®ÔÚMySQLÖУ¬¿ÉÒÔ½¨Á¢¶à¸öÊý¾Ý¿â£¬µ«Ò²¿ÉÒÔͨ¹ýÏÞ¶¨£¬Ê¹Óû§Ö»Äܽ¨Á¢Ò»¸öÊý¾Ý¿â¡£ D£®Òª½¨Á¢Ò»ÕÅÊý¾Ý±í£¬±ØÐëÏȽ¨Êý¾Ý±íµÄ½á¹¹¡£ ´ð°¸£ºC,B,D 34£®¡°show databases like ¡®student%¡¯¡±ÃüÁî¿ÉÒÔÏÔʾ³öÒÔÏÂÊý¾Ý¿â( ) A£®student_my B£®studenty C£®mystudent D£®student ´ð°¸£ºD,A,B

35£®ÏÂÃæµÄÑ¡ÏîÊǹØϵÊý¾Ý¿â»ù±¾ÌØÕ÷µÄÊÇ£¨ £©¡£ A£®ÓëÁеĴÎÐòÎÞ¹Ø B£®²»Í¬µÄÁÐÓ¦Óв»Í¬µÄÊý¾ÝÀàÐÍ C£®²»Í¬µÄÁÐÓ¦Óв»Í¬µÄÁÐÃû D£®ÓëÐеĴÎÐòÎÞ¹Ø ´ð°¸£ºC,D,A

36£®ÔÚmysqlÌáʾ·ûÏ£¬ÊäÈë____ÃüÁ¿ÉÒԲ鿴ÓÉmysql×Ô¼º½âÊ͵ÄÃüÁî( ) A£®\\? B£®? C£®help D£®\\h ´ð°¸£ºC,D,B

37£®ÏÂÁÐÄÄЩÊý¾ÝÊÇ×Ö·ûÐÍÊý¾Ý¡£( ) A£®Öйú B£®¡°1+2¡± C£®¡±can¡¯t¡± D£®¡±ÕÅÈý£­ÀîËÄ¡± ´ð°¸£ºB,D,C

38£®¹ØÓÚÓï¾älimit 5,5£¬Ëµ·¨ÕýÈ·µÄÊÇ A£®±íʾ¼ìË÷³öµÚ5ÐпªÊ¼µÄ5Ìõ¼Ç¼ B£®±íʾ¼ìË÷³öÐÐ6¿ªÊ¼µÄ5Ìõ¼Ç¼ C£®±íʾ¼ìË÷³öµÚ6ÐпªÊ¼µÄ5Ìõ¼Ç¼ D£®±íʾ¼ìË÷³öÐÐ5¿ªÊ¼µÄ5Ìõ¼Ç¼ ´ð°¸£ºC,D

39£®SQLÓïÑÔ¼¯¼¸¸ö¹¦ÄÜÄ£¿éΪһÌ壬ÆäÖаüÀ¨£¨ £© A£®C. DCL B£® B. DML C£® D. DNL D£®A. DDL ´ð°¸£ºD,B,A

40£®ÏÂÁÐ˵·¨ÕýÈ·µÄÊÇ£¨£©

A£®alter table user drop column sex; B£®alter table user add sex varchar(20); C£®alter table user drop sex; D£®alter table user modify id int primary key; ´ð°¸£ºD,B,A,C

41£®ÊÓͼһ°ã²»ÓÃÓÚÏÂÁÐÄÄЩÓï¾ä( ) A£®DELETE B£®SELECT C£®INSERT D£®UPDATE ´ð°¸£ºC,D,A

42£®ÔÚËãÊõÔËËã·û¡¢±È½ÏÔËËã·û¡¢Âß¼­ÔËËã·û£¬ÕâÈýÖÖ·ûºÅÖУ¬ËüÃǵÄÓÅÏȼ¶ÅÅÁв»ÕýÈ·µÄÊÇ( ) A£®ËãÊõ/Âß¼­/±È½Ï B£®±È½Ï/Âß¼­/ËãÊõ C£®±È½Ï/ËãÊõ/Âß¼­ D£®ËãÊõ/±È½Ï/Âß¼­ ´ð°¸£ºA,C,B

43£®¶Ôͬһ´æ´¢¹ý³ÌÁ¬ÐøÁ½´ÎÖ´ÐÐÃüÁîDROP PROCEDURE IF EXISTS£¬½«»á( ) A£®µÚÒ»´ÎÖ´ÐÐɾ³ý´æ´¢¹ý³Ì£¬µÚ¶þ´Î²úÉúÒ»¸ö´íÎó B£®µÚÒ»´ÎÖ´ÐÐɾ³ý´æ´¢¹ý³Ì£¬µÚ¶þ´ÎÎÞÌáʾ C£®´æ´¢¹ý³Ì²»Äܱ»É¾³ý D£®×îÖÕɾ³ý´æ´¢¹ý³Ì ´ð°¸£ºB,D

44£®¹ØÓÚ¼ìË÷½á¹ûÅÅÐò£¬ÕýÈ·µÄÊÇ( ) A£®¹Ø¼ü×ÖDESC±íʾ½µÐò£¬ASC±íʾÉýÐò B£®Èç¹ûÖ¸¶¨¶àÁÐÅÅÐò£¬Ö»ÄÜÔÚ×îºóÒ»ÁÐʹÓÃÉýÐò»ò½µÐò¹Ø¼ü×Ö C£®Èç¹ûÖ¸¶¨¶àÁÐÅÅÐò£¬¿ÉÒÔÔÚÈÎÒâÁÐʹÓÃÉýÐò»ò½µÐò¹Ø¼ü×Ö D£®¹Ø¼ü×ÖASC±íʾ½µÐò£¬DESC±íʾÉýÐò ´ð°¸£ºA,C

45£®ÒÔÏÂÓï¾ä´íÎóµÄÊÇ£¨£© ; SELECT rank, AVG(salary) FROM people HAVING AVG(salary) > 1000 GROUP BY rank; A£®SELECT rank, AVG(salary) FROM people GROUP BY rank HAVING AVG(salary) > 1000 B£®SELECT rank, AVG(salary) FROM people HAVING AVG(salary) > 1000 GROUP BY rank; C£®SELECT AVG(salary) FROM people GROUP BY rank HAVING AVG(salary) > 1000; D£®SELECT rank, AVG(salary) FROM people GROUP BY rank WHERE AVG(salary) > 1000; ´ð°¸£ºD,B

46£®´´½¨Êý¾Ý±íʱ£¬ÏÂÁÐÄÄЩÁÐÀàÐ͵Ŀí¶ÈÊÇ¿ÉÒÔÊ¡ÂԵġ£ ( ) A£®DATE B£®INT C£®CHAR D£®TEXT ´ð°¸£ºB,D,A

47£®¹ØÓÚÖ÷¼üÏÂÁÐ˵·¨ÕýÈ·µÄÊÇ£¨£©

A£®Ö÷¼üµÄÖµ¶ÔÓû§¶øÑÔÊÇûÓÐʲôÒâÒå B£®Ö÷¼üµÄÖ÷Òª×÷ÓÃÊǽ«¼Ç¼ºÍ´æ·ÅÔÚÆäËû±íÖеÄÊý¾Ý½øÐйØÁª¡£ C£®Ò»¸öÖ÷¼üÊÇΨһʶ±ðÒ»¸ö±íµÄÿһ¼Ç¼£¬ D£®Ö÷¼üÊDz»Í¬±íÖи÷¼Ç¼֮¼äµÄ¼òµ¥Ö¸Õë¡£ ´ð°¸£ºC,B,D,A

48£®ÄúÐèÒªÏÔʾ´Ó2009Äê1ÔÂ1ÈÕµ½2009Äê12ÔÂ31ÈÕ¹ÍÓ¶µÄËùÓÐÖ°Ô±µÄÐÕÃûºÍ¹ÍÓ¶ÈÕÆÚ¡£Ö°Ô±ÐÅÏ¢±ítblEmployees°üº¬ÁÐNameºÍÁÐHireDate£¬ÏÂÃæÄÄЩÓï¾äÄÜÍê³É¸Ã¹¦ÄÜ ( ) A£®SELECT Name, HireDate FROM tblEmployees B£®SELECT Name, HireDate FROM tblEmployees WHERE HireDate =¡¯2009-01-01¡¯ OR ¡®2009-12-31¡¯ C£®SELECT Name, HireDate FROM tblEmployees WHERE HireDate BETWEEN ¡¯2008-12-31¡¯ AND ¡®2010-01-01¡¯ D£®SELECT Name, HireDate FROM tblEmployees WHERE substring(HireDate,1,4)=2009; ´ð°¸£ºC,D

49£®ÒÔÏÂÄÄÏîÊÇÊÂÎñÌØÐÔ( ) A£®¶ÀÁ¢ÐÔ B£® ³Ö¾ÃÐÔ C£®Ô­×ÓÐÔ

D£® Ò»ÖÂÐÔ ´ð°¸£ºC,D,A,B

50£®¶ÔÓÚÏÔʾ²Ù×÷ÒÔÏÂ˵·¨ÕýÈ·µÄÊÇ£¨£© A£®show database£»ÏÔʾËùÓÐÊý¾Ý¿â B£®show table£»ÏÔʾËùÓбí C£®show tables£»ÏÔʾËùÓбí D£®show databases£»ÏÔʾËùÓÐÊý¾Ý¿â ´ð°¸£ºD,B

51£®Óï¾äselect * from products where prod_name like '%se%'½á¹û¼¯°üÀ¨( ) A£®¼ìË÷products±íÖÐprod_name×Ö¶ÎÒÔ'se'½áβµÄÊý¾Ý B£®¼ìË÷products±íÖÐprod_name×Ö¶ÎÒÔ'se'¿ª¹ØµÄÊý¾Ý C£®¼ìË÷products±íÖÐprod_name×ֶΰüº¬'se'µÄÊý¾Ý D£®¼ìË÷products±íÖÐprod_name×ֶβ»°üº¬'se'µÄÊý¾Ý ´ð°¸£ºC,B,A

52£®ÔÚmysqlÌáʾ·ûÏ¿ÉÒÔÊäÈëÒ»¸öSQLÓï¾ä£¬²¢ÒÔ( )½áβ£¬È»ºó°´»Ø³µÖ´ÐиÃÓï¾ä( )

A£®¡°\\G¡± B£®¡°¡£¡± C£®¡°\\g¡± D£®¡°;¡± ´ð°¸£ºD,C,A

53£®¹ØÓÚinsertÓï¾äÏÂÁÐ˵·¨ÕýÈ·µÄÊÇ£¨£© A£®insert into ±íÃûvalues(×Ö¶ÎÃû1¶ÔÓ¦µÄÖµ); B£®insert into ±íÃû values(×Ö¶ÎÃû1¶ÔÓ¦µÄÖµ£¬×Ö¶ÎÃû2¶ÔÓ¦Öµ); C£®insert into ±íÃû(×Ö¶ÎÃû1) value (×Ö¶ÎÃû1¶ÔÓ¦µÄÖµ); D£® insert into ±íÃû(×Ö¶ÎÃû1£¬×Ö¶ÎÃû2) values(×Ö¶ÎÃû1¶ÔÓ¦µÄÖµ£¬×Ö¶ÎÃû2¶ÔÓ¦Öµ); ´ð°¸£ºD,B

54£® 23 ¹ØϵÊý¾ÝÄ£ÐÍÄÄЩÓŵ㣿( ) A£®A£©½á¹¹¼òµ¥ B£® C£©Óбê×¼ÓïÑÔ C£® B£©ÊÊÓÃÓÚ¼¯ºÏ²Ù×÷ D£® D£©¿É±íʾ¸´ÔÓµÄÓïÒå ´ð°¸£ºA,C,B

55£®¶Ôij¸öÊý¾Ý¿âʹÓüǼµ¥ , ¿ÉÒÔ½øÐеļǼ²Ù×÷ÓÐ( )

A£®É¾³ý B£®Ð½¨ C£®»¹Ô­ D£®²åÈë ´ð°¸£ºB,A,C

56£®¹ØÓÚselectÓï¾äÏÂÁÐ˵·¨ÕýÈ·µÄÊÇ£¨£© A£® select (name) from table person: ËùÓмǼµÄname×ֶεÄÖµ B£®select (name) from person where age=12 or name=\ or »òÕß

C£® select (name) from table person where age=12; ²éÕÒage=12µÄ¼Ç¼µÄÄǸö×ֶεÄÖµ D£® select (name£¬age) from person where age=12 and name=\²¢ÇÒ ´ð°¸£ºB,D

57£®ÔÚ×Ö·û´®±È½ÏÖУ¬ÏÂÁÐÄÄЩÊDz»ÕýÈ·µÄ( ) A£®ËùÓбêµã·ûºÅ±ÈÊý×Ö´ó B£®ËùÓÐÊý×Ö¶¼±Èºº×Ö´ó C£®ËùÓÐÓ¢ÎıÈÊý×ÖС D£®ËùÓÐÓ¢ÎÄ×Öĸ¶¼±Èºº×ÖС ´ð°¸£ºB,C,A

58£®Êý¾Ý¿âÐÅÏ¢µÄÔËÐа²È«²ÉÈ¡µÄÖ÷´ëÊ©ÓÐ( )¡£ A£®±¸·ÝÓë»Ö¸´ B£®Ó¦¼± C£®·çÏÕ·ÖÎö D£®Éó¼Æ¸ú×Ù ´ð°¸£ºC,D,A,B Èý¡¢Ìî¿ÕÌâ

1£®select 9/3;µÄ½á¹ûΪ_____¡£ ´ð°¸£º3.0000

2£®²¹È«Óï¾ä:select vend_id,count(*) as num_prods from products group by ____; ´ð°¸£ºvend_id

3£®ÓÃSELECT½øÐÐÄ£ºý²éѯʱ£¬¿ÉÒÔʹÓÃÆ¥Åä·û£¬µ«ÒªÔÚÌõ¼þÖµÖÐʹÓÃ____»ò%µÈͨÅä·ûÀ´ÅäºÏ²éѯ¡£ ´ð°¸£º- 4£®µ±Ëù²éѯµÄ±í²»ÔÚµ±Ç°Êý¾Ý¿âʱ£¬¿ÉÓÃ___________________________¸ñʽÀ´Ö¸³ö±í»òÊÓͼ¶ÔÏó

´ð°¸£ºÊý¾Ý¿â.ËùÓÐÕßÃû³Æ.¶ÔÏóÃû³Æ 5£®Óï¾äSELECT ¡°1+2¡±£»µÄÏÔʾ½á¹ûÊÇ£ß£ß£ß£ß ´ð°¸£º¡°1+2¡±

6£®Èç¹ûMySQL·þÎñÃûΪMySQL5£¬ÔòÔÚWindowsµÄÃüÁî´°¿ÚÖУ¬Æô¶¯MySQL·þÎñµÄÖ¸ÁîÊÇ____

´ð°¸£ºnet start mysql5

7£®MySQLÊÇÒ»Ö֣ߣߣߣߣߣߣ¨¶àÓû§¡¢µ¥Óû§£©µÄÊý¾Ý¿â¹ÜÀíϵͳ ´ð°¸£º¶àÓû§

8£®select ¡®2.5a¡¯+3;µÄ½á¹ûΪ_____¡£ ´ð°¸£º5.5

9£®select (NULL<=>NULL) is NULL;µÄ½á¹ûΪ_____¡£ ´ð°¸£º0

10£®´´½¨Êý¾Ý±íµÄÃüÁîÓï¾äÊÇ£ß£ß£ß£ß£ß£ß£ß£ß£ß ´ð°¸£ºcreate table

11£®____Óï¾ä¿ÉÒÔÐ޸ıíÖи÷ÁеÄÏȺó˳Ðò ´ð°¸£ºALTER TABLE

12£®µ±Ä³×Ö¶ÎҪʹÓÃAUTO£ßINCREMENTµÄÊôÐÔʱ£¬¸Ã×ֶαØÐëÊǣߣߣߣßÀàÐ͵ÄÊý¾Ý¡£ ´ð°¸£ºINT

13£®µ±Ä³×Ö¶ÎҪʹÓÃAUTO£ßINCREMENTµÄÊôÐÔʱ£¬³ýÁ˸Ã×ֶαØÐëÊÇÖ¸¶¨µÄÀàÐÍÍ⣬¸Ã×ֶλ¹±ØÐëÊǣߣߣߣß

´ð°¸£º¹Ø¼ü×ֶλòË÷Òý×Ö¶Î

14£®ÔÚSELECTÓï¾äµÄFROM×Ó¾äÖÐ×î¶à¿ÉÒÔÖ¸¶¨_______¸ö±í»òÊÓͼ ´ð°¸£º256

15£®ODBCÊÇÒ»ÖÖ____________ ´ð°¸£º¿ª·ÅʽÊý¾Ý¿âÁ¬½Ó

16£®ÔÚSELECTÓï¾äµÄFROM×Ó¾äÖпÉÒÔÖ¸¶¨¶à¸ö±í»òÊÓͼ£¬Ï໥֮¼äÒªÓÃ________·Ö¸ô ´ð°¸£º¶ººÅ

17£®Table 'a1' already existsÕâ¸ö´íÎóÐÅÏ¢µÄº¬ÒåÊÇ£ß£ß£ß£ß£ß ´ð°¸£º±ía1ÒѾ­´æÔÚ

18£®¶ÔÒ»¸ö³¬¹ý200¸öºº×ÖµÄÄÚÈÝ£¬Ó¦ÓÃÒ»¸ö£ß£ß£ß£ßÐ͵Ä×Ö¶ÎÀ´´æ·Å ´ð°¸£ºtext

19£®ÔÚINSERT´¥·¢Æ÷ÖУ¬¿ÉÒÔÒýÓÃÒ»¸öÃûΪ____µÄÐéÄâ±í£¬·ÃÎʱ»²åÈëµÄÐÐ ´ð°¸£ºNEW

20£®Óï¾äSELECT ¡°ÕÅÈý\\nÀîËÄ¡±µÄÏÔʾ½á¹ûÊǣߣߣߣߣß

´ð°¸£º¡±ÕÅÈý\\nÀîËÄ¡±

21£®smallintÊý¾ÝÀàÐÍÕ¼ÓõÄ×Ö½ÚÊý·Ö±ðΪ ´ð°¸£º1

22£®ÔÚDELETE´¥·¢Æ÷ÖУ¬¿ÉÒÔÒýÓÃÒ»¸öÃûΪ____µÄÐéÄâ±í£¬·ÃÎʱ»É¾³ýµÄÐÐ ´ð°¸£ºOLD

23£®²ì¿´µ±Ç°Êý¾Ý¿âÖбíÃûÓï¾äÊÇ_____¡£ ´ð°¸£ºshow tables

24£®É¾³ý±íÃüÁîÊÇ£º___________________________________________¡£ ´ð°¸£ºdrop table

25£®select 'Abc'='abc';µÄ½á¹ûΪ_____¡£ ´ð°¸£º 1

26£®select -2.0*4.0;µÄ½á¹ûΪ_____¡£ ´ð°¸£º-8.00

27£®tinyintÊý¾ÝÀàÐÍÕ¼ÓõÄ×Ö½ÚÊýΪ___ ´ð°¸£º2

28£®²¹È«Óï¾ä£ºselect vend_id,count(*) from products where prod_price>=10 group by vend_id ____ count(*)>=2; ´ð°¸£ºhaving

29£®¼ÆËã×ֶεÄÀۼӺ͵ĺ¯ÊýÊÇ£º_______ ´ð°¸£ºsum()

30£®ÓÃSELECT½øÐÐÄ£ºý²éѯʱ£¬¿ÉÒÔʹÓÃ________Æ¥Åä·û ´ð°¸£ºlike ËÄ¡¢ÅжÏÌâ

1£®( )Ö÷¼ü±»Ç¿Öƶ¨Òå³ÉNOT NULLºÍUNIQUE¡£ ´ð°¸£ºY

2£®( )selectÓï¾äµÄ¹ýÂËÌõ¼þ¼È¿ÉÒÔ·ÅÔÚwhere×Ó¾äÖУ¬Ò²¿ÉÒÔ·ÅÔÚfrom×Ó¾äÖС£ ´ð°¸£ºN

3£®( )Âß¼­ÖµµÄ¡°Õ桱ºÍ¡°¼Ù¡±¿ÉÒÔÓÃÂß¼­³£Á¿TRUEºÍFALSE±íʾ¡£ ´ð°¸£ºY

4£®( )Èç¹ûÔÚÅÅÐòºÍ·Ö×éµÄ¶ÔÏóÉϽ¨Á¢ÁËË÷Òý£¬¿ÉÒÔ¼«´óµØÌá¸ßËٶȡ£ ´ð°¸£ºY

5£®( )½¨Á¢Ë÷ÒýµÄÄ¿µÄÔÚÓÚ¼Ó¿ì²éѯËÙ¶ÈÒÔ¼°Ô¼ÊøÊäÈëµÄÊý¾Ý¡£ ´ð°¸£ºY

6£®( )UPDATEÓï¾ä¿ÉÒÔÓÐWHERE×Ó¾äºÍLIMIT×Ӿ䡣 ´ð°¸£ºY

7£®( )x between y and zµÈͬÓÚx>y && x

8£®( )MySQLÊý¾Ý¿â¹ÜÀíϵͳֻÄÜÔÚWindows²Ù×÷ϵͳÏÂÔËÐС£ ´ð°¸£ºN

9£®( )¶ÔÓÚ×Ö·û´®ÐÍÊý¾Ý£¬¿Õ×Ö·û´®¡¯¡¯¾ÍÊÇNULL£¬¶ÔÓÚÊýÖµÐÍÊý¾Ý0¾ÍÊÇNULL¡£ ´ð°¸£ºN

10£®( )LTRIM¡¢RTRIM¡¢TRIMº¯Êý¼ÈÄÜÈ¥³ý°ë½Ç¿Õ¸ñ£¬ÓÖÄÜÈ¥³ýÈ«½Ç¿Õ¸ñ¡£ ´ð°¸£ºN

11£®( )NULLºÍNull¶¼´ú±í¿ÕÖµ¡£

´ð°¸£ºY

12£®( )¹ØϵÐÍÊý¾Ý¿â¹ÜÀíϵͳ¼ò³ÆΪRDBMS¡£ ´ð°¸£ºY

13£®( )ÓÃunionÉÏÏÂÁ¬½ÓµÄ¸÷¸öselect¶¼¿ÉÒÔ´øÓÐ×Ô¼ºµÄorder by×Ӿ䡣 ´ð°¸£ºN

14£®( )ALTER TABLEÓï¾ä¿ÉÒÔÐ޸ıíÖи÷ÁеÄÏȺó˳Ðò¡£ ´ð°¸£ºY

15£®( )!=ºÍ<>¶¼´ú±í²»µÈÓÚ¡£

´ð°¸£ºY

16£®( )Ëù´´½¨µÄÊý¾Ý¿âºÍ±íµÄÃû×Ö£¬¶¼¿ÉÒÔʹÓÃÖÐÎÄ¡£ ´ð°¸£ºY

17£®( )SELECTÓï¾äµÄORDER BY×Ӿ䶨ÒåµÄÅÅÐò±í´ïʽËù²ÎÕÕµÄÁÐÉõÖÁ¿ÉÒÔ²»³öÏÖÔÚÊä³öÁбíÖС£ ´ð°¸£ºY

18£®( )ÔÚC/SģʽÖУ¬¿Í»§¶Ë²»ÄܺͷþÎñÆ÷¶Ë°²×°ÔÚͬһ̨»úÆ÷ÉÏ¡£ ´ð°¸£ºN

19£®( )UPDATEÓï¾äÐ޸ĵÄÊDZíÖÐÊý¾ÝÐÐÖеÄÊý¾Ý£¬Ò²¿ÉÒÔÐ޸ıíµÄ½á¹¹¡£ ´ð°¸£ºN

20£®( )create table Óï¾äÖÐÓж¨ÒåÖ÷¼üµÄÑ¡Ïî¡£ ´ð°¸£ºY

21£®( )½á¹¹»¯²éѯÓïÑÔÖ»Éæ¼°²éѯÊý¾ÝµÄÓï¾ä£¬²¢²»°üÀ¨Ð޸ĺÍɾ³ýÊý¾ÝµÄÓï¾ä¡£ ´ð°¸£ºN

22£®( )Ò»¾ädeleteÓï¾äÄÜɾ³ý¶àÐС£

´ð°¸£ºY

23£®( )×Ö·û´®¡°2008-8-15¡±ºÍÕûÊý20080815¶¼¿ÉÒÔ´ú±í2008Äê8ÔÂ15ÈÕ¡£ ´ð°¸£ºY

24£®( )INSERTÓï¾äËù²åÈëµÄÊý¾ÝÐÐÊý¾Ý¿ÉÒÔÀ´×ÔÁíÍâÒ»¸öSELECTÓï¾äµÄ½á¹û¼¯¡£ ´ð°¸£ºY

25£®( )ËùÓÐTIMESTAMPÁÐÔÚ²åÈëNULLֵʱ£¬×Ô¶¯Ìî³äΪµ±Ç°ÈÕÆÚºÍʱ¼ä¡£ ´ð°¸£ºY

26£®( )´øÓÐGROUP BY×Ó¾äµÄSELECTÓï¾ä£¬½á¹û¼¯ÖÐÿһ¸ö×éÖ»ÓÃÒ»ÐÐÊý¾ÝÀ´±íʾ¡£ ´ð°¸£ºY 27£®( )UNIONÖÐALL¹Ø¼ü×ÖµÄ×÷ÓÃÊÇÔÚ½á¹û¼¯ÖÐËùÓÐÐÐÈ«²¿Áгö£¬²»¹ÜÊÇ·ñÓÐÖظ´ÐС£ ´ð°¸£ºY

28£®( )ΪÁËÈÃMySQL½ÏºÃµØÖ§³ÖÖÐÎÄ£¬ÔÚ°²×°MySQLʱ£¬Ó¦¸Ã½«Êý¾Ý¿â·þÎñÆ÷µÄȱʡ×Ö·û¼¯É趨Ϊgb2312¡£ ´ð°¸£ºN

29£®( )Ö»Äܽ«±íÖеÄÒ»¸öÁж¨ÒåΪÖ÷¼ü£¬²»Äܽ«¶à¸öÁж¨ÒåΪ¸´ºÏµÄÖ÷¼ü¡£ ´ð°¸£ºN

30£®( )µ±Ò»¸ö±íÖÐËùÓÐÐж¼±»deleteÓï¾äɾ³ýºó£¬¸Ã±íҲͬʱ±»É¾³ýÁË¡£ ´ð°¸£ºN Îå¡¢¼ò´ðÌâ

1£®Ê²Ã´ÊÇÊý¾Ý¿â¾µÏñ£¿ËüÓÐʲôÓÃ;£¿ ´ð°¸£º ´ð£º

Êý¾Ý¿â¾µÏñ¼´¸ù¾ÝDBAµÄÒªÇó£¬×Ô¶¯°ÑÕû¸öÊý¾Ý¿â»òÕßÆäÖеIJ¿·Ö¹Ø¼üÊý¾Ý¸´ÖƵ½ÁíÒ»¸ö´ÅÅÌÉÏ¡£Ã¿µ±Ö÷Êý¾Ý¿â¸üÐÂʱ£¬DBMS×Ô¶¯°Ñ¸üкóµÄÊý¾Ý¸´ÖƹýÈ¥£¬¼´DBMS×Ô¶¯±£Ö¤¾µÏñÊý¾ÝÓëÖ÷Êý¾ÝµÄÒ»ÖÂÐÔ¡£ Êý¾Ý¿â¾µÏñµÄÓÃ;ÓУº

Ò»ÊÇÓÃÓÚÊý¾Ý¿â»Ö¸´¡£µ±³öÏÖ½éÖʹÊÕÏʱ£¬¿ÉÓɾµÏñ´ÅÅ̼ÌÐøÌṩʹÓã¬Í¬Ê±DBMS×Ô¶¯ÀûÓþµÏñ´ÅÅÌÊý¾Ý½øÐÐÊý¾Ý¿âµÄ»Ö¸´£¬²»ÐèÒª¹Ø±ÕϵͳºÍÖØ×°Êý¾Ý¿â¸±±¾¡£ ¶þÊÇÌá¸ßÊý¾Ý¿âµÄ¿ÉÓÃÐÔ¡£ÔÚûÓгöÏÖ¹ÊÕÏʱ£¬µ±Ò»¸öÓû§¶Ôij¸öÊý¾Ý¼ÓÅÅËüËø½øÐÐÐÞ¸Äʱ£¬ÆäËûÓû§¿ÉÒÔ¶Á¾µÏñÊý¾Ý¿âÉϵÄÊý¾Ý£¬¶ø²»±ØµÈ´ý¸ÃÓû§ÊÍ·ÅËø¡£

2£®ÎªÊ²Ã´ÊÂÎñ·ÇÕý³£½áÊøʱ»áÓ°ÏìÊý¾Ý¿âÊý¾ÝµÄÕýÈ·ÐÔ

´ð°¸£º´ð£º

ÊÂÎñÖ´ÐеĽá¹û±ØÐëÊÇʹÊý¾Ý¿â´ÓÒ»¸öÒ»ÖÂÐÔ״̬±äµ½ÁíÒ»¸öÒ»ÖÂÐÔ״̬¡£Èç¹ûÊý¾Ý¿âϵͳÔËÐÐÖз¢Éú¹ÊÕÏ£¬ÓÐЩÊÂÎñÉÐδÍê³É¾Í±»ÆÈÖжϣ¬ÕâЩδÍê³ÉÊÂÎñ¶ÔÊý¾Ý¿âËù×öµÄÐÞ¸ÄÓÐÒ»²¿·ÖÒÑдÈëÎïÀíÊý¾Ý¿â£¬ÕâʱÊý¾Ý¿â¾Í´¦ÓÚÒ»ÖÖ²»ÕýÈ·µÄ״̬£¬»òÕß˵ÊDz»Ò»ÖµÄ״̬¡£

3£®Ê²Ã´ÊÇÎïÀíÉè¼Æ£º

´ð°¸£º¶ÔÒ»¸ö¸ø¶¨µÄÂß¼­Êý¾ÝÄ£ÐÍÑ¡È¡Ò»¸ö×îÊʺÏÓ¦Óû·¾³µÄÎïÀí½á¹¹µÄ¹ý³Ì£¬³ÆΪÊý¾Ý¿âµÄÎïÀíÉè¼Æ¡£ÎïÀí½á¹¹£¬Ö÷ÒªÖ¸Êý¾Ý¿âÔÚÎïÀíÉ豸ÉϵĴ洢½á¹¹ºÍ´æÈ¡·½·¨¡£ 4£®Ê²Ã´ÊÇÈÕÖ¾Îļþ£¿ÎªÊ²Ã´ÒªÉèÁ¢ÈÕÖ¾Îļþ£¿

´ð°¸£º ´ð£º

£¨1£©ÈÕÖ¾ÎļþÊÇÓÃÀ´¼Ç¼ÊÂÎñ¶ÔÊý¾Ý¿âµÄ¸üвÙ×÷µÄÎļþ¡£

£¨2£©ÉèÁ¢ÈÕÖ¾ÎļþµÄÄ¿µÄÊÇ£º ½øÐÐÊÂÎñ¹ÊÕϻָ´£»½øÐÐϵͳ¹ÊÕϻָ´£»Ð­Öúºó±¸¸±±¾½øÐнéÖʹÊÕϻָ´¡£

5£®ÔÚÊý¾Ý¿âϵͳÉú´æÆÚÖУ¬Éú´æÆÚµÄ×Ü¿ªÏú¿É·ÖΪ¼¸Ï

´ð°¸£º¹æ»®¿ªÏú¡¢Éè¼Æ¿ªÏú¡¢ÊµÏÖÓë²âÊÔ¿ªÏú¡¢²Ù×÷¿ªÏú¡¢Î¬»¤¿ªÏú¡£

6£®Êý¾Ý¿âÖÐΪʲôҪÓлָ´×Óϵͳ£¿ËüµÄ¹¦ÄÜÊÇʲô£¿

´ð°¸£º ´ð£º

ÒòΪ¼ÆËã»úϵͳÖÐÓ²¼þµÄ¹ÊÕÏ¡¢Èí¼þµÄ´íÎó¡¢²Ù×÷Ô±µÄʧÎóÒÔ¼°¶ñÒâµÄÆÆ»µÊDz»¿É±ÜÃâµÄ£¬ÕâЩ¹ÊÕÏÇáÔòÔì³ÉÔËÐÐÊÂÎñ·ÇÕý³£Öжϣ¬Ó°ÏìÊý¾Ý¿âÖÐÊý¾ÝµÄÕýÈ·ÐÔ£¬ÖØÔòÆÆ»µÊý¾Ý¿â£¬Ê¹Êý¾Ý¿âÖÐÈ«²¿»ò²¿·ÖÊý¾Ý¶ªÊ§£¬Òò´Ë±ØÐëÒªÓлָ´×Óϵͳ¡£ »Ö¸´×ÓϵͳµÄ¹¦ÄÜÊÇ£º°ÑÊý¾Ý¿â´Ó´íÎó״̬»Ö¸´µ½Ä³Ò»ÒÑÖªµÄÕýȷ״̬£¨Òà³ÆΪһÖÂ״̬»òÍêÕû״̬£©¡£

7£®Êý¾Ý¿âÔËÐÐÖпÉÄܲúÉúµÄ¹ÊÕÏÓÐÄļ¸ÀࣿÄÄЩ¹ÊÕÏÓ°ÏìÊÂÎñµÄÕý³£Ö´ÐУ¿ÄÄЩ¹ÊÕÏÆÆ»µÊý¾Ý¿âÊý¾Ý£¿

´ð°¸£º´ð£ºÊý¾Ý¿âϵͳÖпÉÄÜ·¢Éú¸÷ÖÖ¸÷ÑùµÄ¹ÊÕÏ£¬´óÖ¿ÉÒÔ·ÖÒÔϼ¸Àࣺ £¨1£©ÊÂÎñÄÚ²¿µÄ¹ÊÕÏ£» £¨2£©ÏµÍ³¹ÊÕÏ£» £¨3£©½éÖʹÊÕÏ£» £¨4£©¼ÆËã»ú²¡¶¾¡£ ÊÂÎñ¹ÊÕÏ¡¢ÏµÍ³¹ÊÕϺͽéÖʹÊÕÏÓ°ÏìÊÂÎñµÄÕý³£Ö´ÐУ»½éÖʹÊÕϺͼÆËã»ú²¡¶¾ÆÆ»µÊý¾Ý¿âÊý¾Ý¡£

8£® µÇ¼ÇÈÕÖ¾ÎļþʱΪʲô±ØÐëÏÈдÈÕÖ¾Îļþ£¬ºóдÊý¾Ý¿â£¿

´ð°¸£º ´ð£º

°Ñ¶ÔÊý¾ÝµÄÐÞ¸Äдµ½Êý¾Ý¿âÖкͰѱíʾÕâ¸öÐ޸ĵÄÈÕÖ¾¼Ç¼дµ½ÈÕÖ¾ÎļþÖÐÊÇÁ½¸ö²»Í¬µÄ²Ù×÷¡£ÓпÉÄÜÔÚÕâÁ½¸ö²Ù×÷Ö®¼ä·¢Éú¹ÊÕÏ£¬¼´ÕâÁ½¸öд²Ù×÷Ö»Íê³ÉÁËÒ»¸ö¡£ Èç¹ûÏÈдÁËÊý¾Ý¿âÐ޸ģ¬¶øÔÚÔËÐмǼÖÐûÓеǼÇÕâ¸öÐ޸ģ¬ÔòÒÔºó¾ÍÎÞ·¨»Ö¸´Õâ¸öÐÞ¸ÄÁË¡£Èç¹ûÏÈдÈÕÖ¾£¬µ«Ã»ÓÐÐÞ¸ÄÊý¾Ý¿â£¬ÔÚ»Ö¸´Ê±Ö»²»¹ýÊǶàÖ´ÐÐÒ»´ÎUNDO²Ù×÷£¬²¢²»»áÓ°ÏìÊý¾Ý¿âµÄÕýÈ·ÐÔ¡£ËùÒÔÒ»¶¨ÒªÏÈдÈÕÖ¾Îļþ£¬¼´Ê×ÏÈ°ÑÈÕÖ¾¼Ç¼дµ½ÈÕÖ¾ÎļþÖУ¬È»ºóдÊý¾Ý¿âµÄÐ޸ġ£

9£®Êý¾Ý¿âת´¢µÄÒâÒåÊÇʲô£¿ ´ð°¸£º ´ð£º

Êý¾Ýת´¢ÊÇÊý¾Ý¿â»Ö¸´ÖвÉÓõĻù±¾¼¼Êõ¡£Ëùνת´¢¼´DBA¶¨Æڵؽ«Êý¾Ý¿â¸´ÖƵ½´Å´ø»òÁíÒ»¸ö´ÅÅÌÉϱ£´æÆðÀ´µÄ¹ý³Ì¡£µ±Êý¾Ý¿âÔâµ½ÆÆ»µºó¿ÉÒÔ½«ºó±¸¸±±¾ÖØÐÂ×°È룬½«Êý¾Ý¿â»Ö¸´µ½×ª´¢Ê±µÄ״̬¡£

¾²Ì¬×ª´¢£ºÔÚϵͳÖÐÎÞÔËÐÐÊÂÎñʱ½øÐеÄת´¢²Ù×÷¡£¾²Ì¬×ª´¢¼òµ¥£¬µ«±ØÐëµÈ´ýÕýÔËÐеÄÓû§ÊÂÎñ½áÊø²ÅÄܽøÐС£Í¬Ñù£¬ÐµÄÊÂÎñ±ØÐëµÈ´ýת´¢½áÊø²ÅÄÜÖ´ÐС£ÏÔÈ»£¬Õâ»á½µµÍÊý¾Ý¿âµÄ¿ÉÓÃÐÔ¡£

¶¯Ì¬×ª´¢£ºÖ¸×ª´¢ÆÚ¼äÔÊÐí¶ÔÊý¾Ý¿â½øÐдæÈ¡»òÐ޸ġ£¶¯Ì¬×ª´¢¿É¿Ë·þ¾²Ì¬×ª´¢µÄȱµã£¬Ëü²»ÓõȴýÕýÔÚÔËÐеÄÓû§ÊÂÎñ½áÊø£¬Ò²²»»áÓ°ÏìÐÂÊÂÎñµÄÔËÐС£µ«ÊÇ£¬×ª´¢½áÊøʱºóÔ®¸±±¾ÉϵÄÊý¾Ý²¢²»Äܱ£Ö¤ÕýÈ·ÓÐЧ¡£ÒòΪת´¢ÆÚ¼äÔËÐеÄÊÂÎñ¿ÉÄÜÐÞ¸ÄÁËijЩÊý¾Ý£¬Ê¹µÃºóÔ®¸±±¾ÉϵÄÊý¾Ý²»ÊÇÊý¾Ý¿âµÄÒ»Ö°汾¡£

Ϊ´Ë£¬±ØÐë°Ñת´¢ÆÚ¼ä¸÷ÊÂÎñ¶ÔÊý¾Ý¿âµÄÐ޸ĻµÇ¼ÇÏÂÀ´£¬½¨Á¢ÈÕÖ¾Îļþ£¨log file£©¡£ÕâÑù£¬ºóÔ®¸±±¾¼ÓÉÏÈÕÖ¾Îļþ¾ÍÄܵõ½Êý¾Ý¿âijһʱ¿ÌµÄÕýȷ״̬¡£ ת´¢»¹¿ÉÒÔ·ÖΪº£Á¿×ª´¢ºÍÔöÁ¿×ª´¢Á½ÖÖ·½Ê½¡£ º£Á¿×ª´¢ÊÇָÿ´Îת´¢È«²¿Êý¾Ý¿â¡£ÔöÁ¿×ª´¢Ôòָÿ´Îֻת´¢ÉÏÒ»´Îת´¢ºó¸üйýµÄÊý¾Ý¡£´Ó»Ö¸´½Ç¶È¿´£¬Ê¹Óú£Á¿×ª´¢µÃµ½µÄºó±¸¸±±¾½øÐлָ´Ò»°ã˵À´¸ü¼òµ¥Ð©¡£µ«Èç¹ûÊý¾Ý¿âºÜ´ó£¬ÊÂÎñ´¦ÀíÓÖÊ®·ÖƵ·±£¬ÔòÔöÁ¿×ª´¢·½Ê½¸üʵÓøüÓÐЧ¡£

10£®ÊÔÊöÊÂÎñµÄ¸ÅÄî¼°ÊÂÎñµÄËĸöÌØÐÔ¡£

´ð°¸£º ´ð£º

ÊÂÎñÊÇÓû§¶¨ÒåµÄÒ»¸öÊý¾Ý¿â²Ù×÷ÐòÁУ¬ÕâЩ²Ù×÷Ҫôȫ×öҪôȫ²»×ö,ÊÇÒ»¸ö²»¿É·Ö¸îµÄ¹¤×÷µ¥Î»¡£

ÊÂÎñ¾ßÓÐËĸöÌØÐÔ£ºÔ­×ÓÐÔ¡¢Ò»ÖÂÐÔ¡¢¸ôÀëÐÔ£©ºÍ³ÖÐøÐÔ¡£

11£®Êý¾Ý¿â»Ö¸´µÄ»ù±¾¼¼ÊõÓÐÄÄЩ£¿

´ð°¸£º ´ð£º

Êý¾Ýת´¢ºÍµÇ¼ÈÕÖ¾ÎļþÊÇÊý¾Ý¿â»Ö¸´µÄ»ù±¾¼¼Êõ¡£ µ±ÏµÍ³ÔËÐйý³ÌÖз¢Éú¹ÊÕÏ£¬ÀûÓÃת´¢µÄÊý¾Ý¿âºó±¸¸±±¾ºÍÈÕÖ¾Îļþ¾Í¿ÉÒÔ½«Êý¾Ý¿â»Ö¸´µ½¹ÊÕÏÇ°µÄij¸öÒ»ÖÂÐÔ״̬¡£

12£®Êý¾Ý¿âÉè¼ÆÖеĹ滮½×¶ÎµÄÖ÷ÒªÈÎÎñ£º

´ð°¸£ºÊǽøÐн¨Á¢Êý¾Ý¿âµÄ±ØÒªÐÔ¼°¿ÉÐÐÐÔ·ÖÎö£¬È·¶¨Êý¾Ý¿âϵͳÔÚ×éÖ¯ÖкÍÐÅϢϵͳÖеĵØ룬ÒÔ¼°¸÷¸öÊý¾Ý¿âÖ®¼äµÄÁªÏµ¡£

Áù¡¢±à³ÌÌâ 1£®±íÃûUser

Name Tel Content Date

ÕÅÈý 13333663366 ´óר±ÏÒµ 2006-10-11 ÕÅÈý 13612312331 ±¾¿Æ±ÏÒµ 2006-10-15 ÕÅËÄ 021-55665566 ÖÐר±ÏÒµ 2006-10-15

(a) ÓÐһмǼ(СÍõ 13254748547 ¸ßÖбÏÒµ 2007-05-06)ÇëÓÃSQLÓï¾äÐÂÔöÖÁ±íÖÐ (b) ÇëÓÃsqlÓï¾ä°ÑÕÅÈýµÄʱ¼ä¸üгÉΪµ±Ç°ÏµÍ³Ê±¼ä (c) Çëд³öɾ³ýÃûΪÕÅËĵÄÈ«²¿¼Ç¼

´ð°¸£º(a) insert into user values('СÍõ','13254748547','¸ßÖбÏÒµ','2007-05-06'); (b) update user set date=time() where name='ÕÅÈý'; (c) delete from user where name='ÕÅËÄ';

2£®µ±Ç°Êý¾Ý¿âÊÇtestdb£¬ÔÚ¸ÃÊý¾Ý¿âÖУ¬ÓÐstudents¡¢scores¡¢courses¡¢majorsËĸö±í£¬Æä½á¹¹¼°Êý¾ÝÈçÏÂËùÁУº

students id

ѧºÅ

int(11) name ÐÕÃû

char(4) sex ÐÔ±ð

char(1) bofd ÉúÈÕ date mid

רҵºÅ tinyint

1 ÕÅÈý ÄÐ 2 ÍõÎä Å® 3 ÀîËÄ Å® 4 ÕÔÁù Å® 5 ÕŽ¨¹ú ÄÐ 6 ÕÔ¾ê Å® scores id ѧºÅ

char(10) term ѧÆÚ

tinyint cid ¿Î³Ì±àºÅ

smallint score ·ÖÊý

numerirc(4,1)

1 1 2 80.0 1 2 2 76.0

1980-12-03 1980-09-22 1981-03-04 1981-05-24 1980-06-02 1980-08-30 1 3 2 1 4 2

2 2 3 3 3 3 5 6 6 6

courses cid

1 2 4 4 4 4 1 1 2 2 3 3 1 2 4 6 2 2 2 3 60.0 65.0 66.0 NULL 81.0 70.0 67.0 50.0 87.0 86.0

¿Î³Ì±àºÅsmallint cname ¿Î³ÌÃû³Æchr(24) 1 µç×ÓÉÌÎñ¸ÅÂÛ 2 cÓïÑÔ³ÌÐòÉè¼Æ 3 MySQLÊý¾Ý¿â 4 php³ÌÐòÉè¼Æ 5 FoxProÊý¾Ý¿â 6 »á¼ÆÔ­Àí majors mid

רҵºÅtinyint mname רҵÃû³Æchr(24) 1 µç×ÓÉÌÎñ 2 ÉÌÎñÓ¢Óï 3 ¼ÆËã»úÓ²¼þ 4 ¼ÆËã»úÈí¼þ 5 ÉçÇø¹ÜÀí 6 ÈÕÓï

²»¿¼ÂÇѧºÅ¡¢¿¼ÊÔ¿ÆÄ¿ºÍѧÆÚ£¬¼ÆËã²¢ÁгöËùÓп¼ÊԳɼ¨ÖУ¬³É¼¨ÎªÓŵķÖÊýµÄÀÛ¼ÓÖµ£¬ºÍ³É¼¨ÎªÁ¼µÄ·ÖÊýµÄƽ¾ùÖµ¡£ÓźÍÁ¼µÄ½çÏßÊÇ90·ÖºÍ80·Ö¡££¨Ê¹ÓÃÒ»¾äÓï¾ä£© ´ð°¸£ºselect Sum(if(score>90,score,0)) AS ³É¼¨ÎªÓŵķÖÊýÀÛ¼Ó, avg(if(score between 80 and 89,score,null)) AS ³É¼¨ÎªÁ¼µÄƽ¾ù³É¼¨

3£®µ±Ç°Êý¾Ý¿âÊÇtestdb£¬ÔÚ¸ÃÊý¾Ý¿âÖУ¬ÓÐstudents¡¢scores¡¢courses¡¢majorsËĸö±í£¬Æä½á¹¹¼°Êý¾ÝÈçÏÂËùÁУº

students id ѧºÅ

int(11) name

ÐÕÃû

char(4) sex ÐÔ±ð

char(1) bofd ÉúÈÕ date mid רҵºÅ tinyint 1 ÕÅÈý ÄÐ 1980-12-03 1 2 ÍõÎä Å® 3 ÀîËÄ Å® 4 ÕÔÁù Å® 5 ÕŽ¨¹ú ÄÐ 6 ÕÔ¾ê

Å®

scores id

ѧºÅ

char(10) term ѧÆÚ

tinyint cid ¿Î³Ì±àºÅ

smallint score

·ÖÊý

numerirc(4,1)

1 1 2 80.0 1 2 2 76.0 2 1 3 60.0 2 2 3 65.0 3 4 1 66.0 3 4 2 NULL 3 4 4 81.0 3 4 6 70.0 5 1 2 67.0 6 1 2 50.0 6 2 2 87.0 6 2 3 86.0

courses cid

¿Î³Ì±àºÅsmallint cname ¿Î³ÌÃû³Æchr(24) 1 µç×ÓÉÌÎñ¸ÅÂÛ 2 cÓïÑÔ³ÌÐòÉè¼Æ 3 MySQLÊý¾Ý¿â

1980-09-22 1981-03-04 1981-05-24 1980-06-02 1980-08-30 3 2 1 4 2

4 php³ÌÐòÉè¼Æ 5 FoxProÊý¾Ý¿â 6 »á¼ÆÔ­Àí majors mid

רҵºÅtinyint mname רҵÃû³Æchr(24) 1 µç×ÓÉÌÎñ 2 ÉÌÎñÓ¢Óï 3 ¼ÆËã»úÓ²¼þ 4 ¼ÆËã»úÈí¼þ 5 ÉçÇø¹ÜÀí 6 ÈÕÓï

½«students±íÖеĽṹ£¨Ö÷¼üºÍË÷Òý£©ºÍÊý¾Ý¸´ÖƵ½Ò»¸öеÄstudents1±íÖС££¨·ÖÁ½¸ö²½ÖèÁ½¾äÓï¾ä£©

´ð°¸£ºcreate table students1 like students; insert into students1 select * from students;

4£®ÏÖÓÐÒ»ÏúÊÛ±í£¬±íÃûÊÇsale£¬ËüµÄ½á¹¹ÈçÏ£º id int (±êʶºÅ) codno char(7) (ÉÌÆ·±àÂë) codname varchar(30) (ÉÌÆ·Ãû³Æ) spec varchar(20) £¨ÉÌÆ·¹æ¸ñ£© price numeric(10,2) £¨¼Û¸ñ£© sellnum int £¨ÏúÊÛÊýÁ¿£©

deptno char(3) £¨ÊÛ³ö·Öµê±àÂ룩 selldate datetime £¨ÏúÊÛʱ¼ä£©

ÒªÇó£ºÐ´³ö²éѯÏúÊÛʱ¼ä¶ÎÔÚ2002-2-15ÈÕµ½2002-4-29Ö®¼ä£¬·Öµê±àÂëÊÇ01µÄËùÓмǼ¡£ ´ð°¸£ºSELECT * FROM sale

WHERE (selldate >= '2002-2-15' AND selldate <='2002-4-29') AND deptno = '01'

5£®±àдһ¸ö·µ»Ø±íproductsÖÐprod_price×Ö¶Îƽ¾ùÖµÇÒÃû³ÆΪproductpricingµÄ´æ´¢¹ý³Ì ´ð°¸£ºCREATE PROCEDURE productpricing() BEGIN

Select avg(prod_price) from products; End;

6£®´´½¨Ò»ÕÅѧÉú±í£¬±íÃûstu£¬°üº¬ÒÔÏÂÐÅÏ¢: ѧºÅ£¬ÐÕÃû(8λ×Ö·û£©£¬ÄêÁ䣬ÐÔ±ð£¨4λ×Ö·û£©£¬¼Òͥסַ£¨50λ×Ö·û£©£¬ÁªÏµµç»°

´ð°¸£ºCreate table stu (ѧºÅ int , ÐÕÃû varchar(8),

ÄêÁä int,

ÐÔ±ð varchar(4),

¼ÒÍ¥µØÖ· varchar(50), ÁªÏµµç»° int );