- 博客(5)
- 收藏
- 关注
RSS订阅原创 mysql中过滤分组where和having的区别
例子1having的使用例子:where的使用例子:select dept_name ,sex,height from student_test whereheight>150;分析：例子2having例子的使用：select dept_name,sex from student_test having height>150;ERROR 1054(42S22)...
2020-05-03 14:08:27
295
1
原创 MySQL Workbench添加外键到EER时出现selected column address must be indexed and be of a compatible type
1、双击表格，点击Foreign Keys，建立外键时出现Foreign key Name：外键名，即别称，可自定义Referenced Table：从表(外键指向的其它表)Column：外键列Referenced Column：从表的外键列2、双击Referenced Table，然后点击Indexes3、在2处将要Referenced Column打勾即可。即创建了一个索引。...
2020-04-30 15:04:39
3197
原创 安装numpy时出现Try to run this command from the system terminal. Make sure that you use the correct versi
问题描述：在pycharm上安装第三方库numpy出现Try to run this command from the system terminal. Make sure that you use the correct version of ‘pip’ installed for your Python interpreter located at ‘D:python.exe’.错误解决方...
2020-04-23 15:00:12
99399
20
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人