List of constraints in the database

How to get list of all constraints from MySQL database?

From [MySQLdiscussion group] 2023-08-22 15:07:48 0  1  488

Is it possible to concatenate multiple MySQL rows into one field?

Using MySQL, I can do something like this: SELECThobbiesFROMpeoples_hobbiesWHEREperson_id=5; My output: shoppi...

From [MySQLdiscussion group] 2023-08-22 14:02:48 0  2  497

How to add delete button in PHP form to delete a row from MySQL table

I have output the results of a MySQL table into an HTML table. In the last column I want to add a delete optio...

From [MySQLdiscussion group] 2023-08-22 12:47:47 0  2  509

MySQL Pivot Table Query: Using Dynamic Columns for Data Analysis

I'm using the following table to store product data: mysql>SELECT*FROMproduct;+---------------+--------...

From [MySQLdiscussion group] 2023-08-22 11:54:19 0  2  617

Create a column for cumulative sum in MySQL

I have a table that looks like this: idcount1100250310 I want to add a new column called cumulative_sum, so th...

From [MySQLdiscussion group] 2023-08-22 11:26:08 0  2  514

How to generate the output of a pivot table in MySQL?

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

From [MySQLdiscussion group] 2023-08-22 10:54:31 0  2  475

How to prevent SQL injection attacks in PHP?

If user input is inserted into a SQL query without modification, the application becomes vulnerable to SQL inj...

From [MySQLdiscussion group] 2023-08-22 10:23:01 0  2  558

SQL query to select only rows with maximum value

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

From [MySQLdiscussion group] 2023-08-22 10:03:28 0  2  509

Get a single result from database using mysqli

I'm trying to use mySQLi for the first time. I've done this in the case of a loop. The results of the loop sho...

From [MySQLdiscussion group] 2023-08-21 22:42:04 0  2  441

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

I'm trying to execute the following simple MySQL query: INSERTINTOuser_details(username,location,key)VALUES('T...

From [MySQLdiscussion group] 2023-08-21 20:17:23 0  1  455

Grab the first n records in each grouped result

The following is the simplest possible example, but any solution should be able to scale to the required n top...

From [MySQLdiscussion group] 2023-08-21 19:55:22 0  2  447

How to use PHP's password_hash function for password hashing and verification

Lately I've been trying to implement my own security on a login script I found on the internet. While trying t...

From [MySQLdiscussion group] 2023-08-21 18:37:28 0  2  602

Rewrite the title as: How to convert existing callback API to Promise form?

I want to use promises to handle it, but the format of my callback API is as follows: 1.DOM loading or other o...

From [MySQLdiscussion group] 2023-08-21 18:34:55 0  2  421

How to solve "subquery returns more than 1 row" error

I have a query that returns multiple rows, and another query where I want to set the condition to be any one o...

From [MySQLdiscussion group] 2023-08-21 17:36:57 0  2  525

How to resolve "Class 'MySQLi' not found" fatal error

I'm working on a tutorial and came across this error: Fatal error: Class 'MySQLi' not found at line 8 (long UR...

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