Warning: mysqli_error() expects **Xiaobai's solution

<?php $conn=mysqli_connect("localhost","root","123456789") or die("Datab...

From [MySQLdiscussion group] 2020-08-26 16:10:59 0  0  1041

javascript - Access denied for user 'root'@'localhost' (using password: YES)

Connect to mysql through the terminal in mac. The connection is successful through the graphical tool Navicat....

From [MySQLdiscussion group] 2017-06-12 09:20:35 0  3  1041

mysql - Query the unique values ​​of a certain field in the database, sorted by time, how to write it?

The article model is as follows class Article(models.Model): {code...} Query: If there are multiple pieces of ...

From [MySQLdiscussion group] 2017-06-20 10:05:37 0  1  1040

mysql - Use PHPEXCEL to import 5000+ items of data from an excel file into the database. The local database is normal, but only 15 items are imported online. No errors are reported. What is the problem?

Use PHPEXCEL to import 5000+ items of data from the excel file into the database. The local database is normal...

From [MySQLdiscussion group] 2017-05-27 17:38:55 0  2  1039

Mysql slow query log content viewing problem

The slow query log is enabled in mysql, but I often see such a query in the log. I don’t know what it means. I...

From [MySQLdiscussion group] 2017-06-28 09:23:21 0  2  1038

现在我在学习MySQL,问问怎么复制粘贴数据库.

大家好,是这么回事: 就是我白天在公司上班,其实大多数时候都很清闲,我就利用这些时间自学坐在那里学MySQL,PHP... 学php 和 js html 的时候还好说,我把文件传到 快盘,回到家同步一下,再复制出来,就可...

From [MySQLdiscussion group] 2017-04-17 14:42:11 0  9  1038

mysql-配置 - Mysql创建数据库时提示Error 1044

使用非root用户登录时创建数据库会提示Error1044，使用root用户登录则能创建数据库。百度了一下似乎是权限问题，我该如何操作将我所登录的用户能创建数据库？ Mysql版本: 5.7.10 MySQL Commu...

From [MySQLdiscussion group] 2017-04-17 15:27:34 0  2  1035

为什么说"B+树索引适用于全键值,键值范围或者最左键前缀查找"? 看高性能 Mysql 的困惑

还以书上例子来说 {代码...} 这个 B+tree 的索引示意图能明白,但是为什么马上在下文就说"B+树索引适用于全键值,键值范围或者最左键前缀查找" 我应该如何去理解,是否和 B+tree 有着不...

From [MySQLdiscussion group] 2017-04-17 12:58:12 0  2  1034

Mysql select 中嵌套带子句

很常见的用例： 我有一张存放文章的表， tag 字段是逗号分隔的数字，在显示列表的时候我想一次性查询出 tag 的字符串SELECT tt.*,u.name,(SELECT group_concat(title) FRO...

From [MySQLdiscussion group] 2016-11-07 14:53:37 0  1  1032

The entity warehouse extends JpaRepository<Entity, Id> and JpaSpecificationExecutor<Entity>, and EntitySpec extends Specification<Entity>

This is my endpoint http://localhost:8080/country/all replies are ok for all countries and when I want to filt...

From [MySQLdiscussion group] 2024-04-06 17:11:03 0  1  1031

Connect phpMyAdmin to MySQL server via SSL

I might be barking up the wrong tree... However, what I have is a MySQL server that only accepts connections f...

From [MySQLdiscussion group] 2023-10-23 08:57:18 0  2  1031

QT compilation of MySQL driver fails repeatedly in Mac environment? how?

Official method. When I execute make compilation, an error occurs. I have used homebrew to install mysql-conne...

From [MySQLdiscussion group] 2017-07-04 13:43:43 0  1  1031

mysql - 关于数据逻辑删除的问题？

我在表中逻辑删除了一条数据，表中存在唯一索引的字段，逻辑删除后，我有要insert一条一样的数据，这样肯定不行，如何解决这个问题？

From [MySQLdiscussion group] 2017-04-17 13:53:20 0  3  1031

Question about not being able to modify field names in MySQL

(www.sf.gg) is China's leading developer technology community. We hope to provide a pure, high-quality technic...

From [MySQLdiscussion group] 2017-06-26 10:49:27 0  1  1030

Try wrapping the CASE/conditional statement inside a MySQL trigger

I have a trigger: CREATETRIGGERMovesAFTERINSERTONRollsFOREACHROWUPDATEPlayersCASEWHENP_Location+NEW.Rolls<1...

From [MySQLdiscussion group] 2023-09-11 20:55:31 0  1  1029