MYSQL适合JS吗_mysql 学习

1、MySQL 为关系型数据库(Relational Database Management System), 这种所谓的"关系型"可以理解为"表格"的概念, 一个关系型数据库由一个或数个表格组成

2、sql语句：

SELECT * FROM sdb_link

SELECT link_id FROM sdb_link

SELECT * FROM sdb_link where link_name='外贸'  //WHERE 用于选择规定选择的标准

WHERE   操作符 > 、 、>= 、<=、BETWEEN、LIKE

SELECT DISTINCT orderlist FROM sdb_link   //DISTINCT 用于返回唯一不同的值

SELECT * FROM Persons WHERE FirstName='Thomas' AND LastName='Carter'   //AND 条件都符合

SELECT * FROM Persons WHERE firstname='Thomas' OR lastname='Carter'       // OR 只要有一个条件符合

SELECT Company, OrderNumber FROM Orders ORDER BY Company     //ORDER BY 语句用于根据指定的列对结果集进行排序。DESC 倒序   ASC 顺序

INSERT INTO sdb_link VALUES (104, 17, '测试17', 'http://www.baidu.com','',17,true,'','',1)  //INSERT INTO 插入数据

INSERT INTO Persons (Lastname,Address) VALUES('Wilson','Champs-Elysees')

UPDATE Person SET FirstName = 'Fred' WHERE LastName = 'Wilson'      //UPDATE   更新一条数据

CREATE TABLE Persons(Id_P int,LastName varchar(255),FirstName varchar(255),Address varchar(255),City varchar(255))

DELETE FROM Person WHERE LastName = 'Wilson'        //DELETE 删除一条数据

SELECT  * FROM sdb_link LIMIT 5

SELECT  * FROM sdb_link WHERE link_id IN (1,2,5,6)

SELECT column_name(s) FROM table_name WHERE column_name BETWEEN value1 AND value2

SELECT link_id AS ID, link_name AS Name FROM sdb_link      //AS

SELECT sdb_link.link_id,sdb_jpush.id  FROM sdb_link,sdb_jpush     //查询多张表信息

SELECT sdb_link.link_id,sdb_jpush.id  FROM sdb_link,sdb_jpush WHERE sdb_link.link_id=sdb_jpush.id

SELECT sdb_link.link_id,sdb_jpush.id FROM sdb_link INNER JOIN sdb_jpush ON sdb_link.link_id = sdb_jpush.id

SELECT sdb_link.link_id,sdb_jpush.id FROM sdb_link LEFT JOIN sdb_jpush ON sdb_link.link_id = sdb_jpush.id    //LEFT JOIN 关键字会从左表 (table_name1) 那里返回所有的行，即使在右表 (table_name2) 中没有匹配的行

SELECT sdb_link.link_id,sdb_jpush.id FROM sdb_link RIGHT JOIN sdb_jpush ON sdb_link.link_id = sdb_jpush.id    //RIGHT JOIN 关键字会从右表 (table_name1) 那里返回所有的行，即使在左表 (table_name2) 中没有匹配的行

SELECT column_name(s) FROM sdb_link UNION SELECT column_name(s) FROM sdb_jpush   //UNION 内部的 SELECT 语句必须拥有相同数量的列。列也必须拥有相似的数据类型。同时，每条 SELECT 语句中的列的顺序必须相同

SELECT Persons.LastName, Persons.FirstName, Orders.OrderNo FROM Persons FULL JOIN Orders ON Persons.Id_P=Orders.Id_P ORDER BY Persons.LastName    // FULL JOIN  全连接

3、sql  函数