I am having a trouble with using GROUP_CONCAT in MySQL My tables g0 as follows: ID Age Sex ------------- 1 16 Male 2 18 Female 3 16 Male 4 18 Female 5 16 Male But I need the table to look like ...

I am just a beginner in MySQL, I need to know how much data can be stored in MySQL. I am developing a web crawler, can I store all the data in MySQL, or do I need to use another Database? Which is ...

I'm currently using MySQL Workbench to write very complex SQL Queries. To compare between different approaches, I need to know how many records have been returned by my query very quickly. So, is ...

I have a field id defined as below. It's varbinary(16) in database, when i am inserting a new record through JPA, i got "com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for colum...

I've built my app so far using node-mysql. I just set up a securely accessible mysql database using AWS RDS service and have tested an SSL connection successfully with the mysql command line client...

I downloaded a Google Sheets workbook as a CSV file and tried to import it as a table in my MySQL Workbench, but I keep getting this error... Unhandled exception: 'ascii' codec can't decode byte 0x...

I'm using the JPA CriteriaBuilder to select entities of type MyEntity from a MySQL db as follows: String regExp = "(abc|def)" CriteriaBuilder cb = em.getCriteriaBuilder(); CriteriaQuery query = cb...

I have to connect to my MYSQL server via remote connection from my pc, The connection works. But its too slow. From my reasearch I heard adding a line, skip name resolve is going to speed it u...

I have a war file that uses the MySQL database in the backend. I have deployed my war file in a docker container and I am able to ping this from my browser. I want to connect my app with the MySQL ...

I was using phpmyadmin (Version information: 4.0.10deb1) on php 7.0.7 & nginx 1.4.6 . When I was trying to import a csv file to one of tables, I saw the max size allowed indicated on the phpmya...

I have a django app that uses MySQL as the database backend. It's been running for a few days now, and I'm up to ID 5000 in some tables already. I'm concerned about what will happen when I overfl...

I want to use run below mysql script using with pymysql. START TRANSACTION; BEGIN; insert into ~~~ COMMIT; my python source code is connection = pymysql.connect(~~~~~~~) with connection.curs...

Here's a simplified example of what I'm talking about: Table: students exam_results _____________ ____________________________________ | id | name | | id | student_id | score | date | |----+------...

In my database I have a users table, joined via a many-to-many table to schools. A school has many jobs. I'm trying to return all the schools and their jobs for a specific user. This is my code so ...

A MySQL database running on Debian (version 5.5.41-0+wheezy1-log). A table hotels with a column name VARCHAR(128) and engine is InnoDB. CREATE TABLE `hotels` ( `id` int(11) unsigned NOT NULL AUT...

I have created a Laravel project and I added few table with Migrate. It was working fine. The tables already had data. Now I require another table and I tried to add it with this command: php arti...

I'm doing a union on two queries, and I want to add a where clause to the result, but the where clause is added only to the first query. how can I fix that? $notifications = DB::table('notificati...

I have been trying to run MySQL workbench on my macOS Catalina 10.15.2 for a long time now. I have been using MySQL from the CLI. But recently when I tried to switch to the workbench, there h...

I'm using Django for a small project and I want to make a table with one row to add the description of the project in it. I only need one row and nothing more since it's one description for the who...

I was following the official docker labs hands-on tutorial for multi-container apps tutorials. While running the below command on MacBook Pro M1 terminal docker run -d ` --network todo-app --netwo...

This error happened when I granted all privileges to a new root account I just created. Steps to produce the problem: CREATE USER 'root'@'localhost'; GRANT ALL PRIVILEGES ON *.* TO 'root'@'localh...

We have a fairly complex data model and are using Hibernate and Spring Data JPA on top of MySQL. We have a base class that all domain objects extend to minimize boiler plate code. I would like to b...

Every time I run a test all my database tables (except for the migrations table) are being deleted and I have to run the migrations again. For instance, if I have the following tables: migrations ...

I have a large set of numbers, basically 1001 .. 150000 for a database using MySQL There are a ton of gaps in the IDs on the database, so not all IDs exist. It can go from 100000 - 10500, then the ...

Hi I have three models model User { user_id Int @id @default(autoincrement()) email String @unique name String? User_Account User_Account[] } model Account { account_id Int @id @default (auto...