I have database in UTF-8 (utf8_general_ci) enconding in phpMyAdmin. I export it as CSV file to another computer where MySQL Workbench is installed. The encoding problem is only with cyrillic characters when I import it to the MySQL Workbench. It…
Error Code: 1175. You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column. To disable safe mode, toggle the option in Preferences -> SQL Editor and reconnect I tried…
I've created a column of usernames but the ids for each row is linked to another table. If a user is deleted, I'd like to change the username to 'Deleted'. So I'd like to allow for unique values except for…
How to delete duplicate data in mySql on new version? SchoolId StudentName 101 Majid Bhuiyan 101 Majid Bhuiyan 102 Arif 103 Tamim Rahman 104 Sourov Doggesh I expect it mySql code. How to delete only one row in that duplicate…
I have no idea why I am having such trouble with this but I can't get this to work properly. I am trying to create a stored procedure that updates a booking datetime for a bookingid of my choice. I…
I have made a new AWS RDS MySQL instance and I want to import some existing .sql data generated from an existing database using MySQL Workbench's export tool. I connected to the database using the "admin" master user, then started…
I'm looking for guidance on how to apply IFNULL to an outer query in my mySQL Query. The query checks for new timecards submitted the previous day and kicks off a procedure that writes the results to a file server.…
I'm using mysql 8, I need to create a calculated field named status in the supplier table. When creating this field, it shows an error. where am i going wrong? Could it be a syntax error? create table tbqualificacao( idqualificacao…
I have an MYSQL 8 table in which the full name of the same person (LN FN MI) is listed two different ways (two different records). Record#1 is MCCAULEY KELLY JO and Record#2 is MC CAULEY KELLY JO. There should…
I am trying to export a database which is protected by a SSH key and a private network, meaning I can't login to the host itself to run mysqldump locally and somehow the ssh -i "key" doesn't work for me…