Skip to main content
Database Administrators

Questions tagged [mysql-8.0]

Ask Question

MySQL version 8.0 - please also tag with mysql for search purposes.

725 questions
Newest Active Bountied Unanswered
Filter by
Sorted by
Tagged with
0 votes
0 answers
54 views

Apologies if this is a duplicate question but I was unable to find the correct result but that could be down to the phrasing of my question but here goes. I have a table with BIGINT primary keys. I ...
UrbanwarfareStudios's user avatar
  • 101
0 votes
0 answers
41 views

Are constraints (specifically: foreign key) errors being logged on the server side (MySQL 8.0.39)? The question arose because there was a migration problem and the number of errors exploded on the ...
AndersonCode42's user avatar
  • 1
0 votes
1 answer
46 views

My experience is in Firebird v1 to 3. So, I am apprehensive about using views. I am using MySQL 8.x on a Windows server. The server side is a REST server on IIS. The client is a WebApp running in the ...
Rohit Gupta's user avatar
  • 2,168
0 votes
0 answers
46 views

I am using MySQL 8.0. I have a sales table with only 30,000 rows. I had a problem where the table was frozen and I couldn't alter the values in any of the columns. I attempted to duplicate the data ...
smdhkv's user avatar
  • 1
-1 votes
1 answer
64 views

I recently came across the NKTg Law on Varying Inertia in physics, which describes an object’s movement tendency based on its position (x), velocity (v), and mass (m), with m allowed to change over ...
TheNKTLaw's user avatar
  • 1
0 votes
1 answer
50 views

I'm working on archiving a bunch of tables in an environment where archiving was never done, with some data going back 10 years. I've written a script to perform the work, which loops through the ...
Swechsler's user avatar
  • 191
0 votes
0 answers
46 views

Actually, here the issue is not with like operator. For each deviceid. I have 30 lack records like that I'm sending 100 device IDs. so, this is causing issue for slowness, and it is well indexed. can ...
Aravind's user avatar
  • 11
1 vote
1 answer
90 views

In the project I am working on, there is a Booking table. There are 8 types of Bookings. I have elected to have just one table There are 12 common fields If I store the rest of the fields as columns,...
Rohit Gupta's user avatar
  • 2,168
2 votes
0 answers
35 views

In the project I am working on, there is a Booking table. There are 8 types of Bookings. I have elected to have just one table There are 12 common fields I could store the rest of the fields as ...
Rohit Gupta's user avatar
  • 2,168
0 votes
1 answer
108 views

Background I am using XAMPP, which has MariaDB on my Windows development machine. I cant remove this as I have a number of projects that depend and use this. On my new project on AWS EC2, Windows ...
Rohit Gupta's user avatar
  • 2,168
1 vote
2 answers
158 views

I'm working on upgrading my Google Cloud SQL mysql instance from 8.0 to 8.4. I just upgraded it from 5.7 to 8.0 and now I'm trying to convert my user authentication plugins for my existing users from ...
Kenny Wyland's user avatar
  • 129
3 votes
2 answers
230 views

I have a question, and I've found one similar addressed, which I was going to respond to with my own questions (Live database migration MariaDB 10.5 to MySQL 8.0), however, as that post/question is ...
BEGRAFX's user avatar
  • 31
1 vote
1 answer
68 views

My question is regarding the Explain output. Please refer the below query and its Explain command output Explain update test.table1 t1 join test.table2 t2 on t1.field1=t2.field1 and t1.field2=t2....
jithin giri's user avatar
  • 209
1 vote
0 answers
62 views

How to export stored procedures and triggers from Cloud SQL without hitting production? I'm using Google Cloud SQL (MySQL) and want to automate a nightly/weekly clone of the production database into ...
scr4bble's user avatar
  • 111
1 vote
2 answers
88 views

To replace the content of a test database from a production database mysqldump output the following command was used: cat mysqldump-db-thisdate.sql | mysql -p ... mydb There has never been any issue ...
Déjà vu's user avatar
  • 555

15 30 50 per page
1
2 3 4 5
…
49