¹ÊÓì¦Ã

ÕªÒª£º 1 ´´½¨Êý¾Ý¿â 2 CREATE DATABASE guyu; 3 4 5 ½øÈëÊý¾Ý¿â 6 USE guyu; 7 8 9 ´´½¨±í¸ñÃû:emp 10 CREATE TABLE emp ( 11 empno INT PRIMARY KEY auto_increment, 12 ename VARCHA ÔĶÁÈ«ÎÄ

ÕªÒª£º select * from websites; INSERT INTO `access_log` (`aid`, `site_id`, `count`, `date`) VALUES ('10', '6', '111', '2016-03-09'); 1 SELECT 2 w.`name`, 3 a ÔĶÁÈ«ÎÄ

ÕªÒª£º 1 Date: 2020-08-24 16:07:35 2 */ 3 4 SET FOREIGN_KEY_CHECKS=0; 5 6 -- 7 -- Table structure for websites 8 -- 9 DROP TABLE IF EXISTS `websites`; 10 CRE ÔĶÁÈ«ÎÄ

ÕªÒª£º select * from websites; SELECT * FROM Websites WHERE country='CN' AND alexa > 50; SELECT * FROM Websites WHERE country='USA' OR country='CN'; SELECT * ÔĶÁÈ«ÎÄ

ÕªÒª£º 1 package guyu.day0824; 2 3 import java.net.InetAddress; 4 5 /** 6 * @Author: Fred 7 * @Date: 2020/8/24 09:39 8 */ 9 public class Demo01 { 10 public s ÔĶÁÈ«ÎÄ