How to list data in a section by ID using while loop in PHP?

I have a mysql table with these columns: series_id, series_color, product_name In the output I want to list the data by sections, one section per series_id like this: A12SeriesProduct-Milk-Tea-sugar-waterB12SeriesProduct-Water-Banana -Cofee-Tea

P粉505917590 2023-11-17 20:03:03 0 1 290

Using triggers and constraints to limit the number of records in MySQL

I have a table called BFFs that stores user IDs and best friends' user IDs, and I want to limit the table to 3 best friends for each different user. I mean if the table structure is: BFFs(userID,userID) the records are: (3286,1212)(3286,4545)(3286,7878) In this case if the user with ID 3286 should n...

P粉807397973 2023-11-14 13:35:02 0 4 434

Resolving django.db.utils.NotSupportedError error in Django

I'm getting an error when running a project in Django. The problem is unfortunately I upgraded my pip, MySQL client and Django version and this is the error when running pythonmanage.pyrunserver incheck_database_version_supportedraiseNotSupportedError(django.db.utils.NotSupportedError:MariaDB10.3orl...

P粉939473759 2023-11-14 11:59:20 0 1 246

Retrieve MySql rows with the same column value

Let us consider the following table - IDScore19521003884100573 I am a complete SQL noob, but how to return a score containing ID2 and 4? So it should return 100 since it appears in both ID2 and 4

P粉464088437 2023-11-10 21:53:39 0 2 331

How to publish SQLite database data to an online MySQL database in Flutter?

How to sync offline SQLite to MySQL online database in Flutter? Any suggestions?

P粉590428357 2023-11-10 12:36:40 0 2 247

Root user is denied access to MySQL

I recently installed MySQL on x86_64 Access denied for "localhost" (using password: no) With or without sudo, I know there are answers to this on stack and other forums but none of them seem to help me, I've tried reinstalling the MySQL server but this Didn't help either

P粉208469050 2023-11-09 11:00:45 0 1 204

Fix issue in Laravel-8 trying to read property "id" on null

I get this error when running phpartisanmigrate:fresh --seed This command will create a table in the MySQL database and populate the database details DB_DATABASE into the .env file. parent::boot();static::creating(function($model){$user=Auth::user();model->created_by=$user->id?$user->id

P粉194919082 2023-11-08 14:07:01 0 2 155

sqlalchemy.exc.ArgumentError: list argument must contain only tuples or dictionaries

I've been trying to use sqlalchemy to dump data into a mysql database. When I try to do this, it gives the error sqlalchemy.exc.ArgumentError: List arguments must contain only tuples or dictionaries. The following code is used for insertion. definsert_data(db,table,rows):db.execute(f"INSERTINTO...

P粉080643975 2023-11-07 21:06:02 0 1 286

Composite full-text index in MySQL

I want the system to allow searching user messages by specific users. Suppose I have the following table createtablemessages(user_idint,messagenvarchar(500)); If I want to search all messages from user 1 that contain the word "foo", what index should I use here. Simple, non-unique index on...

P粉868586032 2023-11-07 18:44:49 0 2 185

Prevent MySQL from reading when updating

I have two simple queries, one to read the table and one to update the table. How to lock the read of a select query while the update query is running. Now in MySQLInnoDB, I noticed that writes/updates are locked by default, but reads/selects get the old data before the transaction. I tried using a ...

P粉190883225 2023-11-07 18:05:53 0 1 203

Is full count query really that slow on a large MySQL InnoDB table?

We have a large table with millions of entries. Full counting is very slow, see code below. Is this common for MySQLInnoDB tables? Isn't there a way to speed up this process? Even with query caching, it's still "slow". I'd also like to know why the count of the "communication" ta...

P粉291886842 2023-11-07 15:52:43 0 2 236

MySQL syntax for updating specific key/value pairs in JSON array

I have a table in a MySQL5.7.12 database with a JSON column. The data in the column has the following structure (the json array may contain multiple json objects): [{"ste":"I","tpe":"PS"},{"ste":"I","tpe": "PB"}]I want t...

P粉386318086 2023-11-06 14:50:43 0 1 269

The title is rewritten as: "Flutter mysql1 received out-of-order packets"

I'm having some issues setting up a connection to my VPS using flutter's mysql1 library. When I execute the query, I encounter this error UnhandledException: Error1156(08S01): Gotpacketsoutoforder. MySQL server version: 8.0.28 This is the service I use to establish a connection to the database. vars...

P粉333395496 2023-11-05 22:34:25 0 1 217

Get column names and data for CSV export (MYSQL) using PHP

I need a way to export a MYSQL database to CSV via PHP, but I also need to select the column names. So far I have the following, which does everything I need except getting the column names. echo"ExportStarting\n";$SQL=("SELECT*FROMINF_TimeEntriesWHEREExportedISNULL");$result=mys...

P粉579008412 2023-11-04 21:59:58 0 2 279

Rewrite the title as: Passing array of integers to MySQL stored procedure

I want to create a stored procedure which receives an array of integers and some other inputs like: CREATEPROCEDUREtest(field1varchar(4),field2varchar(4),arrayvarchar(255)) In the stored procedure I want to use it like this: ...WHEREsome_fieldIN( array)... The problem is that this way I only get the...

P粉275883973 2023-11-03 10:46:21 0 2 179

Insert conversion using MySQL

I'm trying to insert a value into a table in MySQL but can't get it to work. I'm using the following query: INSERTintoarticulovalues(32,'Sala',CAST('$10,000.45999'ASDECIMAL(10,5)),40.2399,200.2399,3,'kid3');MySQL shows the following error: 1row(s)affected,1warning (s):1292TruncatedincorrectDE

P粉189606269 2023-11-02 19:47:58 0 2 286

MySQL: How to use CASE with ORDER BY clause

I have a stored procedure that has to return a table after filtering rows based on input. Two of the inputs are sort_column and sort_dir. The query must ORDERBY sort_column in the sort_dir direction (ASC or DESC). I tried the following query without success. The query below has been simplified to in...

P粉463291248 2023-11-01 17:44:15 0 1 171

Title rewritten to: Issue with rendering BLOB image

Hi I have saved jpg image in BLOB format in mysql. I'm having trouble rendering an image to my view page using PHP. When I use header('Content-type:image/jpeg') it gives a message on my page because the image cannot be displayed because it contains an error. When I print without the header functiona...

P粉814160988 2023-10-31 08:54:55 0 2 240

Mariadb 10 Mysql Workbench does not support maintenance

The same error occurs with maintenance task calls such as server status, client connections, etc. The server version you are trying to connect to is 10.0, which is not supported by Workbench. Is there a quick hack that would allow using these in MariaDB 10.04 or 10.06

P粉403804844 2023-10-31 00:00:10 0 1 207

Find the object corresponding to the key value in MySQL JSON: How to implement it

I'm trying to find a way to search a JSON object and get a specific key, but search for another key. Here is a sample schema: CREATETABLE`fields`(`id`int(10)unsignedNOTNULLAUTO_INCREMENT,`label`varchar(64)COLLATEutf8mb4_unicode_ciNOTNULL,`options`jsonDEFAULTNULL,PRIMARYKEY(`id`))EN

P粉037215587 2023-10-30 13:42:27 0 1 331