im new here, hope to grow into this community. I am currently learning php and i am making a program to upload a file. i found a tutorial with some code that ma
I'm a PHP/MySQL developer trying to move over to other technologies like .NET Core. I'm not sure if I like the idea of switching to SQL Server over MySQL (due t
I am using jwt to create token, but when i login via postman I get the error "Error: secretOrPrivateKey must have a value" from my console. I have attached my l
I am receiving the error: ImportError: No module named MySQLdb whenever I try to run my local dev server and it is driving me crazy. I have tried everything I c
I'm developing an API using NestJS & TypeORM to fetch data from a MySQL DB. Currently I'm trying to get all the instances of an entity (HearingTonalTestPage
I have a use case where we need to use both MySQL and MongoDB in a distributed transaction i.e. if either of MySQL or MongoDB fails, both MySQL and MongoDB must
I am new to laravel and I am having an issue with DB problem. I have disabled 'only_full_group_by' sql_mode by editing /etc/mysql/my.cnf file. And I checked sq
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