Chapter 7 data filtering
Combine WHERE clause
WHERE vend_id = 1003 AND prod_price <=10;
WHERE vend_id = 1003 OR prod_price <=10;
SELECT prod_price,prod_name, ...
Posted by gckmac on Sun, 23 Feb 2020 13:32:22 +0100
Introduction to Alpine Linux
1.Alpine Linux is a lightweight Linux distribution. It is different from the usual Linux distribution (centos, Ubuntu), Alpine uses musl libc and
BusyBox reduces system size and runtime resource consumption.
2.Alpine Linux provides its own package management tool ...
Posted by lanjoky on Sun, 23 Feb 2020 05:29:38 +0100
In daily projects, we often use if to judge, but in multi-level projects, you will find that the code is cumbersome
Now there are four products, namely mobile phones, computers, televisions and game consoles. Of course, the prices of each product are different
To see such a r ...
Posted by Daniel0 on Sun, 23 Feb 2020 11:01:48 +0100
Create foreign keys
Common mathematical functions of MySQL
Common string functions of MySQL
Date functions commonly used in MySQL
Other common functions
INSERT [I ...
Posted by juancuca on Sun, 23 Feb 2020 08:59:29 +0100
4, DDL data definition
4.1 create database
4.2 query database
4.3 modify database
4.4 delete database
4.5 create table
4.6 zoning table
4.7 modification table
5, DML data operation
5.1 data import
5.2 data export
5.3 clear data in the table (Truncate)
6.1 basic query ...
Posted by PyroX on Sun, 23 Feb 2020 09:38:46 +0100