I just downloaded the latest version of MySQL Workbench and going to start the server crashes, Any solution?

I want to align a column in my table. In this case 'Title' mysql> SELECT Titel, KuenstlerName from Bild; +--------------------------+---------------+ | Title | Artist| +------------------------...

MySQL version - 8.0.23 on RDS I am replicating my local database to AWS RDS MySQL instance. But I am getting this error: 2021-11-11T22:43:09.091947Z 378 [ERROR] [MY-010584] [Repl] Slave I/O for cha...

I'm using Laravel's schema builder with mysql to make a unique column. But when I use the unique method it is case insensitive. I need it to be case sensitive. How can I do that? Schema: Schema:...

I'm doing a simple UPDATE with mysql2 : UPDATE table1 SET table1.value1 = ?, table1.value2 = ? WHERE user_id = ( SELECT user_id FROM user WHERE company_id = ? ) table1 is related to th...

I have multiple data insert operations in my application and when i use bulkCreate then it works for me but I have an issue that when some required field like name which is not null in the datab...

SELECT N, CASE WHEN P IS NULL THEN 'Root' WHEN(SELECT COUNT(*) FROM BST WHERE P = b.N) > 0 THEN 'Inner' ELSE 'Leaf' END FROM bst b ORDER BY N;` Can anyone please explain this solution of hack...

My website is going down every morning ! i have contacted hosting people they said "The reason of suspension here is because the hosting service have exceeded the database limit of 1GB ,As part of ...

So as the title says, how can I know if a field of a Model is a foreign key in Laravel ? Supose I have a FK column called show_type_id and a model named Event and I want to know if there is a funct...

Unable to connect to db using IntelliJ on mac m1. Installed MySQL using Homebrew, I am able to access MySQL via terminal, I don't know what I am doing wrong. I have tried reinstalling, changing the...

I have a BLOB image that is stored when the user submits an advert form, they have the choice of uploading one image. The image is stored in the database with the other information. Every time my ...

I have three tables and I want to sum all the result columns of each table and return these values from the function I define to do all the process. Is it possible to return those three float summa...

I have this code: $rows = array(); $res = mysql_query($someQuery); if(!mysql_errno()) while($row = mysql_fetch_assoc($res)) $rows[] = $row; $someQuery is an arbitrary query that I write in to...

Full error log: 2019-09-20 08:35:37.860 INFO 1 --- [nio-8081-exec-1] o.a.c.c.C.[Tomcat-1].[localhost].[/] : Initializing Spring DispatcherServlet 'dispatcherServlet' 2019-09-20 08:47:29.726...

I would like to ask for help :) Two INSERT statements are issued simultaneously by 2 users into a doctrine-generated many-to-many table: INSERT INTO my_table (col1, col2) VALUES (2271885, 16678); &...

I am new in both php and mysql. I want to create a dynamic table that will have all fields from table in mysql database. I am trying to get all column names in an array but fail to do. I am trying ...

I am using active records to access the database. However, an additional feature requires me to use standard SQL query. Is it possible to use both active records and standard SQL query in the same ...

An associate has created a schema that uses an ENUM() column for the primary key on a lookup table. The table turns a product code "FB" into it's name "Foo Bar". This primary key is then used as a...

Re: the error "You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column" The two options to fix this are disabling safe mode through the gui (Edit>Pref...

When using the PHPMyAdmin Designer tool I can not see relations (lines that connect each foreign key relation). The foreign key attributes get a different icon than the other attributes, however th...

after I changed data directory of docker (i.e /etc/docker/daemon.json), I get the following error while I'm trying to run mysql image 2022-07-13T10:31:27.580551Z 0 [System] [MY-013169] [Server] /us...

Is there a way to use pool.getConnection() taken from the mysqljs/mysql lib with the async/ await syntax? The idea is to have a method which returns one connection which can be passed around among...

I run a web application on a shared LiteSpeed server with Mariadb version 10.3.22. I do have access to a terminal. Cron is set up to perform a daily mysqldump, but I now get the error message: my...

I'm trying to find the preference settings to have the output clear every time my statement or set of statements are executed. I would prefer this option instead of right clicking and clearing the ...

I hope someone can help me. I was using MySQL Workbench on Windows 7 for years, but now I got a new machine on Windows 10, I installed MySQL Workbench but when I try to connect to a database I alwa...