Query which table a given value is in

I need some help. In my database I have several tables containing product details, each product has a unique I...

From [MySQLdiscussion group] 2023-08-10 14:56:55 0  1  477

Rewrite the title: SQL statement using WHERE clause of CASE statement

I was struggling with how to get p.oldversionref as output when writing the second statement when I need p.voi...

From [MySQLdiscussion group] 2023-08-10 14:13:39 0  1  500

How to implement numeric value length limit in Laravel 10?

Is this the correct way to validate a numeric value in a tinyint(4) field? This is the command I'm currently u...

From [MySQLdiscussion group] 2023-08-09 14:49:31 0  1  781

What does the number 6 in the MySQL DATETIME field mean?

I can't find it in DATETIME, but usually I define it as DATETIME without precision specifier. When running Hib...

From [MySQLdiscussion group] 2023-08-09 14:34:58 0  2  678

MySQL: Two tables joined using primary key and foreign key, how to get all records even if the foreign key is not populated yet

I hope to find a solution I have one table with primary key stock stkid(pk),name second table (share) price,qu...

From [MySQLdiscussion group] 2023-08-09 14:15:07 0  1  506

In MySQL database, how to copy one database to another database

A test environment database and a development environment database; the test environment database has been mod...

From [MySQLdiscussion group] 2023-08-10 10:34:20 0  0  568

Compare dates in SQL to rows from the same period last year.

I have a database that contains order dates, product codes, and customers, like this example: Index Code Cu...

From [MySQLdiscussion group] 2023-08-02 22:49:52 0  1  791

Troubleshooting: Error 111 - Unable to connect to MySQL server

I have a MySQL server installed on a Linux host with the IP address 192.168.1.100, but when I try to connect t...

From [MySQLdiscussion group] 2023-08-02 20:16:12 0  2  892

Insert data into one table by referencing columns from another table in SQL

I have created two tables, one is animation_companies (animation companies) and the other is cartoon_character...

From [MySQLdiscussion group] 2023-08-02 16:27:21 0  1  606

Django's LIKE operation.

I'm trying to send a query through Django's Python, and I'm also trying to prevent any SQL injection attacks. ...

From [MySQLdiscussion group] 2023-08-02 15:55:17 0  1  553

In PHP, an unexpected variable $sql caused an exception error.

I thought I had the complete code written and no errors, but why does it keep showing errors like this? I trie...

From [MySQLdiscussion group] 2023-08-02 14:50:45 0  1  516

Get the SQL query results for the second repeated column.

IamfacingachallengewhilerunningaSQLquery:Thereare2tables:SampleTable01Ext.InitialIDDescription1111start111112s...

From [MySQLdiscussion group] 2023-08-02 12:42:13 0  1  545

Use join in update query instead of columns when updating rows

Before update (original example table): Document ID meta key value 1ibanIBAN1234561bankaccountACCT9876542ibanI...

From [MySQLdiscussion group] 2023-08-02 12:32:01 0  1  620

Use a SQL query to retrieve the unique identifier for a specific subject and a specified score.

You need to write a SQL query to obtain the unique ID of a student whose math score is 80 points, English scor...

From [MySQLdiscussion group] 2023-08-02 12:03:01 0  1  592

Mariadb troubleshooting using UNION's CREATE TABLE SELECT

I'm working on a PHP script that contains six UNION SELECTs, and within the script this command runs just fine...

From [MySQLdiscussion group] 2023-08-02 11:25:48 0  1  635