The storage location of my.cnf file on macOS

I'm trying to follow this tutorial to enable remote access to MySQL. The question is, where should my.cnf file...

From [MySQLdiscussion group] 2023-08-21 16:58:58 0  2  565

How to use variables to execute SQL statements in Python

I have the following Python code: cursor.execute("INSERTINTOtableVALUESvar1,var2,var3,") where var1 ...

From [MySQLdiscussion group] 2023-08-21 16:40:37 0  2  468

How to implement pivot table output in MySQL

If I have a MySQL table like this: company_nameactionpagecount ----------------------------------CompanyAPRINT...

From [MySQLdiscussion group] 2023-08-21 16:06:24 0  2  550

How to solve the problem of application stopping?

I'm developing an application and every time I run it I get the following message: Sorry, MyApp has stopped ru...

From [MySQLdiscussion group] 2023-08-21 15:17:55 0  2  494

SQL query to select only rows with maximum column value

I have a document table (simplified version here): idrevcontent11...21...12...13... How do I select one row pe...

From [MySQLdiscussion group] 2023-08-21 14:17:15 0  2  400

"Unable to install mysql-python, error: mysql_config not found"

This is the error I encountered (mysite)zjm1126@zjm1126-G41MT-S2:~/zjm_test/mysite$pipinstallmysql-python is d...

From [MySQLdiscussion group] 2023-08-21 13:30:26 0  2  610

The columns in the SELECT statement are not in the GROUP BY clause and contain non-aggregated columns....Incompatible with sql_mode=only_full_group_by

I'm using MySQL5.7.13 with WAMP server on my Windows PC My problem is while executing this query SELECT*FROM`t...

From [MySQLdiscussion group] 2023-08-21 13:21:31 0  2  635

Title rewritten to: WARNING: mysqli_connect(): (HY000/1045): Access denied for user 'username'@'localhost' (using password: yes)

Warning: mysqli_connect(): (HY000/1045): Access denied for user 'username'@'localhost' (using password: yes) i...

From [MySQLdiscussion group] 2023-08-21 12:59:10 0  2  494

Title rewritten as: "The parameters of the foreach() function are invalid"

It's common for me to deal with data that can be either an array or an empty variable, and feed that data to s...

From [MySQLdiscussion group] 2023-08-21 12:03:34 0  2  547

Why after RIGHT JOIN, rows in table 2 that do not match table 1 are excluded?

I need to join two tables: `our_sample` and `tls207_pers_appln`, which come from PATSTAT. `our_sample` has 4 c...

From [MySQLdiscussion group] 2023-08-20 21:18:55 0  1  425

The title is rewritten as: Successfully solved - the problem of unable to update mySQL column names using the mysql command line

I can't change the column names in the mysql database I created. I tried the following commands but none of th...

From [MySQLdiscussion group] 2023-08-20 21:03:11 0  1  557

How to force Postgres to use a specified index?

How do I force Postgres to use an index when it insists on performing a sequential scan?

From [MySQLdiscussion group] 2023-08-20 20:42:25 0  1  684

C# MySQL connection issue: Unable to connect to the specified MySQL host

When I executed the following code, I faced the above error - MySqlConnectionmysqlConn=newMySqlConnection(&quo...

From [MySQLdiscussion group] 2023-08-20 19:50:26 0  1  530

Easy way to calculate median in MySQL

What is the simplest (and hopefully not too slow) way to calculate the median using MySQL? I've used AVG(x) to...

From [MySQLdiscussion group] 2023-08-20 18:05:23 0  2  637

Get the maximum value record in each grouped SQL result

How to get the row containing the maximum value for each grouping? I've seen a few overly complicated variatio...

From [MySQLdiscussion group] 2023-08-20 18:10:21 0  2  522