How to configure mysql remote php external network link database

$con = mysql_connect("47.107.159.50:3306","root","root"); After using phpstudy t...

From [MySQLdiscussion group] 2019-01-12 11:09:47 0  3  1310

How to SELECT to remove all columns of a certain column in MySQL?

Because there are dozens of columns in the table, is there any simple way to SELECT to remove all columns of a...

From [MySQLdiscussion group] 2017-06-30 09:53:03 0  1  1308

mysql 如何模糊查询?

mysql模糊查询，一般都是 like "%搜索内容%" ，这样子只能查出严格遵循搜索内容顺序的字符，例如要查找含有‘程序员’的字段，那么只能 like '%程序员%' ，而只有包含这...

From [MySQLdiscussion group] 2017-03-04 14:18:32 0  2  1306

mysql deletes an empty database and reports error Table storage engine for 'proc' doe

I just deleted an empty table and got the error "Table storage engine for 'proc' doesn't have this option...

From [MySQLdiscussion group] 2021-01-13 16:07:51 0  1  1306

Teacher, why don't you talk about adding multiple data at once?

Teacher, why don’t you talk about adding multiple data at once?

From [MySQLdiscussion group] 2018-12-17 22:17:40 0  1  1302

At 8 minutes and 23 seconds, a problem occurred on my own. Thanks

insert into my_set values('football, billiards, tennis'); after entering, what appears is not the 98 of the vi...

From [MySQLdiscussion group] 2019-10-17 20:05:48 0  2  1301

Many operations can be implemented directly in excel. Why do you need to write such a complicated mysql language? What are its advantages?

Many operations can be implemented directly in excel. Why do you need to write such a complicated mysql langua...

From [MySQLdiscussion group] 2019-05-20 21:01:20 0  1  1297

When placing orders in the mall, do you design one table or two tables?

When placing orders in the mall, do you design one table or two tables? For example: Should we design wp_order...

From [MySQLdiscussion group] 2020-08-21 09:28:09 0  0  1296

Under the local area network, how to configure the phpstudy environment of computer A so that multiple computers can access the msql database of computer A

Under the local area network, how to configure the phpstudy environment of computer A so that multiple compute...

From [MySQLdiscussion group] 2018-07-04 18:45:17 0  2  1296

phpstudy v8 gets an error when opening the database, but phpstudy 2018 does not

The website built by phpstudy v8, the website membership registration card is in the process of registration. ...

From [MySQLdiscussion group] 2021-02-28 12:55:20 0  1  1295

Access denied for user 'root'@'localhost' (using password: yes) - No permission?

I keep getting this error. I'm using mySQLWorkbench and I found that root's schema permissions are empty. Ther...

From [MySQLdiscussion group] 2023-10-09 19:39:30 0  2  1293

Unlock issues

If a process adds a lock to the table, and later the process does not unlock it normally for some reason. . So...

From [MySQLdiscussion group] 2021-07-12 17:48:56 0  2  1292

How to determine whether the database libraries and tables exist?

For example, how to determine whether the database libraries and tables exist?

From [MySQLdiscussion group] 2017-08-08 10:47:41 0  2  1292

mysql无法删除字段（错误1091），但是对该字段设置主键后就可删除，为什么？

我为表student添加了字段xx，再想删除时，提示error 1091。可是，为什么会出现这个错误？ 我在网上找到了这个办法：给xx字段添加主键，然后果然删除了。可是，主键不是不能删除的吗？这怎么又可以删除了？这个办....

From [MySQLdiscussion group] 2017-04-17 16:22:49 0  1  1292

After phpstudy is installed, the database is very slow to open. What is the reason?

After phpstudy is installed, the database is very slow to open. What is the reason?

From [MySQLdiscussion group] 2017-11-17 12:52:44 0  1  1291