After installing MySQL, how to activate the federation engine?

我有mysql5.1.44:mysql>showengines;+------------+---------+|Engine|Support|+------------+---------+|ndbcluster...

From [MySQLdiscussion group] 2023-10-18 08:51:44 0  2  638

MySQL - LIMIT & IN/ALL/ANY/SOME subquery is not currently supported in this version of MySQL

This is the php code I am using $Last_Video=$db->fetch_all('SELECTVID,thumbFROMvideoWHEREVIDIN(SELECTVIDFRO...

From [MySQLdiscussion group] 2023-10-16 22:44:50 0  2  573

MySQL - Trigger to update the same table after insert operation

Here's what I'm trying to do: When there is a new INSERT into table ACCOUNTS, I need to update the row in ACCO...

From [MySQLdiscussion group] 2023-10-16 20:01:46 0  2  693

How to update JSON data type column in MySQL 5.7.10?

I recently started using MySQL5.7.10 and I really like the native JSON data type. But I have a problem while u...

From [MySQLdiscussion group] 2023-10-16 19:03:34 0  2  737

MySQL Error 150: Troubleshooting foreign key constraints when creating table

I'm trying to create a table in MySQL with 2 foreign keys that reference primary keys in 2 other tables, but I...

From [MySQLdiscussion group] 2023-10-16 16:59:12 0  1  761

An effective way to protect PHP code without encryption

First of all, I'm not looking for miracles... I know how PHP works, and there's no real way to hide my code fr...

From [MySQLdiscussion group] 2023-10-16 13:38:10 0  2  673

Please report to developers: PDO::__construct(): Server-sent charset (255) not recognized by client

I'm trying to connect to a MySQL database from a Symfony3 application. But when trying to create a MySQL schem...

From [MySQLdiscussion group] 2023-10-16 10:02:44 0  2  684

MySql Error: The table in a stored function/trigger cannot be updated because it is already used by a statement that calls this stored function/trigger

I'm running a MySQL query. However, when adding a new row from the form input, I get this error: Error:Can'tup...

From [MySQLdiscussion group] 2023-10-15 23:34:43 0  2  669

Using SQLAlchemy's grouping and counting functions

I want the "group by and count" command in sqlalchemy. How can I do this?

From [MySQLdiscussion group] 2023-10-15 13:54:57 0  2  565

Embracing UTF-8 from start to finish

I'm setting up a new server and want full UTF-8 support in my web application. I've tried this in the past on ...

From [MySQLdiscussion group] 2023-10-15 12:36:31 0  2  848

PHP: Import .SQL data files and manage maximum execution time

I'm trying to import a large .sql data file using phpMyAdmin in XAMPP. However, this takes a lot of time and I...

From [MySQLdiscussion group] 2023-10-15 08:34:47 0  1  707

MySQL InnoDB does not free disk space after deleting data rows from table

I have a MySQL table using the InnoDB storage engine; it contains approximately 2M rows of data. When I delete...

From [MySQLdiscussion group] 2023-10-15 00:02:19 0  2  708

Syntax errors caused by using reserved words as table names or column names in MySQL

I'm trying to execute a simple MySQL query like this: INSERTINTOuser_details(username,location,key)VALUES('Tim...

From [MySQLdiscussion group] 2023-10-14 22:05:30 0  1  646

MySQL: Syntax error caused by using reserved words as table or column names

I'm trying to execute a simple MySQL query like this: INSERTINTOuser_details(username,location,key)VALUES('Tim...

From [MySQLdiscussion group] 2023-10-14 20:35:57 0  1  617

Disabled form inputs will not appear in requests

I have some disabled inputs in my form and I want to send them to the server, but Chrome excludes them from th...

From [MySQLdiscussion group] 2023-10-14 18:01:00 0  2  696