羊城迷鹿的博客

文章目录寻找大国可回收且低脂的产品寻找用户推荐人从不订购的客户游戏玩法分析I寻找大国OR条件判断select name, population, area from world where area >= 3000000 or population >= 25000000;可回收且低脂的产品AND条件判断，字符串判断select product_id from Products where low_fats = 'Y' and recyclable = 'Y';寻找用户

安装mysql文件包下载mysql-8.0.15-winx64.zip，地址是https://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-8.0.15-winx64.zip写bat文件把文件夹解压缩到D盘（其实解压到哪都行），在目录下新建install.bat和films.sqlinstall.bat内代码的内容为@ECHO ON@echo 设置环境变量@SET sqlpath=%~dp0@setx /M PATH "%sqlpath%bin;%

连接数据库之前需要在命令行运行 net start mysqlimport pymysqldb = pymysql.connect(host = 'localhost', user = 'root', password = '1234', port = 3306)cursor = db.cursor()cursor.execute('SELECT VERSION()')data =...

安装教程见：https://blog.youkuaiyun.com/coffee_fighter/article/details/87632316开启服务net start mysql原来是需要在管理员模式下打开登陆mysqlmysql -uroot -p修改密码ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_pa...