Sql
Dave_L
这个作者很懒,什么都没留下…
展开
-
在python中使用mysql数据库demo
mysql数据库版本:mysql Ver 8.0.12 for Win64 on x86_64 (MySQL Community Server - GPL)0.免密登陆mysql -u root -p不输密码直接回车1.创建表DB、用户scraper1CREATE DATABASE DB;创建用户:create user 'scraper1'@'localhost' identified by 'passwd'授予其所有权限:grant all privileges on DB.* to原创 2020-06-25 21:49:56 · 835 阅读 · 0 评论 -
SqlZoo - Mysql 练习记录(更新ing
15SELECT 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...原创 2020-04-25 17:55:22 · 505 阅读 · 0 评论