MySQL

I have set up a MySQL database and created a login table using MySQL WorkbenchI am using a MySQL 8

I have a batch with many jobs almost over 9,000 and the first of them consumed by workers always get 1205 "Lock wait timeout exceeded" errorsI have submitted an issue on GitHub but it was closed so I'm asking for help here

Hello may I ask if it is possible to make a MYSQL table to read only? In which I had a table for student records which is to be updated whenever a user/student registers which saves details from the MYSQL database which is non-modifiable due to being read onlyIf so, how to make such a table in MYSQL

How do I add the date and next in a AS column? for example: enter image description here

Note: I realise this could be seen as a duplicate but i have looked at the other responses and they didn't fix the problem for me

I have a MySQL database and I try to search in a tale using created_at and updated_at fields which are timestamp fields using this query

I would like to know how to write sql query for search string that has special characters

Does anyone know if we can get a list of custom session variables for the current session in the latest version of MySQL?

I have a table called mh_countryHere is one row from phpmyadmin

I am sure it's just a typo, but how to write the following query correctly in PHPMyAdmin?

When I try to use mysqlconnector in python, nothing happens, the terminal freezes and nothing happens infinitely

I have a table with 2 columns :

shell is:

how can I fetch and display data 2 days ahead of set date from the column 'departure' from table 'products'

I have a program where I am trying to match users based on some parametersI am having an issue with trying to filter a selection of data from my database based on two parameters

Want to improve this question? Add details and clarify the problem by editing this post

In our web app (Java/JDBC), we use MySQL and we need it to store individual payment billsEach bill must have a unique bill number

I am unable to unpivot this tableI keep getting an error that two tables don't exist

I have flutter app where user input data and that data is stored on mysqlEverything works perfect on my PHP, HTML on web

Can anyone help me with solution for below query resultI am getting different row count with version 8

I have database1 in which I have table11 and table12

The main table is CAR table that looks like this:

For instance, if I have a python function that creates a my_sql engine using sqlalchemy and ingests data into a table, I would just create a python operator and connect it to that callable

I recently added a new instance of Maria DBIt in some cases the new database server gives different results from older versions of Maria DB