I'm writing an application that retrieves data from a table in a MySQL database and displays it in a JTable. Whenever an insert/update/delete operation is made
I have two entities that I'm trying to apply a OneToMany / ManyToOne relationship to (one Game has many GameContent). Game /** * @ORM\OneToMany(targetEntity=
I don't speak English, sorry. I have this message to my DBeaver Can you help me to fix the problem ? Network error Motif: Network unavailable: javax.net.ssl.SS
I rebooted a digital ocean box and now I can't start mysql. When I run start command i get : Redirecting to /bin/systemctl restart mysql.service Job for mysql
I know information schema is read only but I ran into a problem. I've imported mysql database. Information_schema db also got copied. Its 'views' table has a de
We are currently using binary replication from our master to slave. Is it possible to enable the GTID on the slave only? (this is required from some other appli
I am working on a QA forum using PHP and MYSQL. Now, I am creating an ask a question page like StackOverflow. In the input box when I enter a value then I get m
I'm learning about PHP and MySQL. I have a lab that I'm working on where I have created a database (using the terminal in Ubuntu through a Virtual Machine) and
I have created the following PHP in order to check if some username already exists inside a database. If it exists and the username+password is correct, I had
Trying to insert data into MySQL database with PHP. I don't want to refresh the page. The data isn't inserted when I press the Send Message button, but the data
After adding the WITH ROLLUP in the GROUP BY statement the ranges reordered. How can this be fixed? Here is the code SUM(product.product_id = 1
SELECT d.millid, d.bookno, d.partyname, d.count, d.counttype, d.orderqty, d.dispqty, d.pending from ( SELECT b.millid, b.count, b.counttype, b.bookno,
Struggling to understand why my query is taking ~8-12s to complete when my table has millions of rows. I can force it to use a specific index, and depending on
The below code always return the below wired object {"_U": 0, "_V": 0, "_W": null, "_X": null} as response. Here is my code getData = () => { f
I have a json object which has list of products under a bill. I want to write a mysql function for it which reads the data from the json and iterates over it on
Hi anyone have idea for finding MySQL row like below code, but this one not working. I have column value "1205_15_09" and I want to find this row using this con
The problem: Importing a 2GB dump file into MySQL 5.6 always crashes with ERROR 2013. There are several answers on StackOverflow about how to deal with this, b
I have a complex MySQL SELECT statement with a LOT of CTE frontloading. Note it works just fine, but it seems MySQL is doing something strange with the SELECT I
I have a tv_shows table where i'm trying to store the start and end datetime of each tv show. this is my migration: Schema::create('tv_shows', function (Bluepri
I have a shema database in file type XSD this file contains descriptions of all tables. My question is how I can use this file to create a database in MySQL. i