In the php toolbox, if I forget the root password, how to reset the root password?

From [MySQLdiscussion group] 2017-08-28 11:37:01 0  1  1198

Write a function that can print m*n character matrix and m*m square character pattern

Write a function that can print m*n character matrix and m*m square character pattern. def print_rectangle(row...

From [MySQLdiscussion group] 2020-04-29 15:05:05 0  0  1197

Error report of sql concat

Choose from the options below and concatenate the "city" and "state" columns, separated by...

From [MySQLdiscussion group] 2021-11-03 19:22:19 0  6  1194

mysql - Why does myisAm not support row locks?

The leaf nodes of myisAm B+ tree index store row identifiers of row data, which can be located to the physical...

From [MySQLdiscussion group] 2017-06-16 09:19:35 0  1  1194

mysql - How to insert into the database after drag and drop reordering?

It is an article pagination, for example, ten pages, and the serial number is 1-10; one page stores a piece of...

From [MySQLdiscussion group] 2017-05-18 10:56:17 0  1  1194

brew 安装 mysql 得到unknown variable 'tmpdir=/tmp'错误

在 macbook 上用 brew 安装 mysql ，运行： {代码...} 此命令后提示： {代码...}

From [MySQLdiscussion group] 2017-04-17 13:34:11 0  3  1193

How to retrieve records sorted by or in sql statement

For example, this related article statement: SELECT * FROM zbp_post WHERE log_Type = '0' AND log_Status = '0' ...

From [MySQLdiscussion group] 2020-07-11 12:00:36 0  1  1191

The database cannot be inserted, please answer, thank you

<?phprequire 'connect.php';$sql="INSERT INTO 'student'('name','course'...

From [MySQLdiscussion group] 2020-05-17 10:58:29 0  1  1190

java - mysql automatically deletes data every other day

How does mysql automatically delete data after the specified time? I am using Java to make a to-do list and us...

From [MySQLdiscussion group] 2017-06-16 09:19:28 0  7  1190

mysql - JavaEE JdbcTemplate 商城列表属性筛选SQL一般怎么写

不知道用户现在什么参数，SQL怎么写，一个一个判断是否为空？ 那 jdbcTemplate.query(sql, rowMapper, ...); 这个里面呢

From [MySQLdiscussion group] 2017-04-17 12:02:35 0  3  1190

中文问题我用的是cmd客户端GBK，为什么都没遇到乱码 ？5.7.15-log MySQL

create database my_database charset=utf8;-- 创建数据库utf8 create table my_student(ID...

From [MySQLdiscussion group] 2017-03-07 14:16:13 0  2  1189

Django queries database

class User(models.Model):username = models.Charfield()class Topic(models.Model):# 发帖人user = models.ForeignKey(...

From [MySQLdiscussion group] 2019-08-17 20:37:31 0  1  1188

php - Login verification issue with TP5

One problem that should be relatively trivial is that when I deal with the front-end and back-end, I need to d...

From [MySQLdiscussion group] 2017-05-25 15:08:19 0  5  1188

如何每天自动优化mysql指定表

现在用的程序是php+mysql，linux服务器，有没有什么办法可以每天在固定时间进行一次mysql表的优化，需要自动优化的原有主要是因为搜索的用户太多了，造成搜索缓存太多，占用空间

From [MySQLdiscussion group] 2017-03-07 10:19:22 0  2  1187

Select select statement condition problem. Please clarify.

Today I found this piece of code $sql = "SELECT * FROM admin_user WHERE md5(concat(id, 'SALT'))='$id' AND...

From [MySQLdiscussion group] 2019-07-12 17:30:04 0  0  1186