Dave_lzw的博客

mysql数据库 版本：mysql Ver 8.0.12 for Win64 on x86_64 (MySQL Community Server - GPL) 0.免密登陆 mysql -u root -p 不输密码直接回车 1.创建表DB、用户scraper1 CREATE DATABASE DB; 创建用户： create user 'scraper1'@'localhost' identified by 'passwd' 授予其所有权限： grant all privileges on DB.* to

15 SELECT name , SUBSTRING( capital , LOCATE(name,capital)+length(name) , length(capital)-LOCATE(name,capital)+length(name) ) as ext FROM world WHERE capital LIKE concat( name , '_%' ) substri...