MySql must know and be able to read notes

Chapter 7 data filtering Combine WHERE clause AND operator SELECT prod_price,prod_name FROM products WHERE vend_id = 1003 AND prod_price <=10; OR operator SELECT prod_price,prod_name FROM products WHERE vend_id = 1003 OR prod_price <=10; Calculator counts SELECT prod_price,prod_name, ...

Posted by gckmac on Sun, 23 Feb 2020 13:32:22 +0100

Docker's Custom Mirror Upload Aliyun

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

How to write multiple if judgments gracefully

Preface In daily projects, we often use if to judge, but in multi-level projects, you will find that the code is cumbersome demand Now there are four products, namely mobile phones, computers, televisions and game consoles. Of course, the prices of each product are different if judgement To see such a r ...

Posted by Daniel0 on Sun, 23 Feb 2020 11:01:48 +0100

MySQL basic: MySQL data operation

Catalog Add record Update record Delete record Query record WHERE condition GROUP BY multi-table query Create foreign keys Joint query Common mathematical functions of MySQL Common string functions of MySQL Date functions commonly used in MySQL Other common functions Add record # grammar INSERT [I ...

Posted by juancuca on Sun, 23 Feb 2020 08:59:29 +0100

Basic operation of Hive

Article directory 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) Six, query 6.1 basic query ...

Posted by PyroX on Sun, 23 Feb 2020 09:38:46 +0100