Category "mysql"

How can I display the header of columns of all tables within a SCHEMA

I would like to list out all the tables and column headers within a SCHEMA to be displayed in Rows within MySQL, I can't seem to find an answer online and would

MySql syntax error during user creation when there is no apparent error

I'm trying to install Moodle using Ubuntu using the following guide: Step-by-step Installation Guide for Ubuntu I'm currently on step 6 where I have to create

Creating command to backup MySql database in Laravel

I wanted to back up my database. I am using Xampp MySql. The username is root and the password is not set. I run the command using Command Prompt but it shows n

Spring Boot container cannot connect to My SQL container

I have read all questions related the issue and controlled all points. It seems everything is ok with my codes but it doesn't connect anyway. I got CONNECTION R

Exception in thread "main" java.lang.IllegalArgumentException: org.hibernate.hql.internal.ast.QuerySyntaxException getting this Excdption

I am trying a simple program with hibernate but while retrieving data from db i am getting this error. But the insertion is working fine. I have provided the

Undefined Array Key error when uploading image on php

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

.NET Core 2.0 with MySQL: Specified key was too long; max key length is 3072 bytes

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

Error: secretOrPrivateKey must have a value

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

VirtualEnv ImportError: No module named MySQLdb

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

TypeORM: how to load relations with CreateQueryBuilder, without using JOINs?

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

MongoDB and MySQL transaction in a distributed transaction

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

How to disable only_full_group_by option in Laravel

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

Call a Java method using MySQL triggers

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

Symfony / Doctrine: OneToMany insert results in null id

I have two entities that I'm trying to apply a OneToMany / ManyToOne relationship to (one Game has many GameContent). Game /** * @ORM\OneToMany(targetEntity=

Can you help me to fix the connection with my DBeaver?

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

MYSQL 5.7 Percona XtraDBCluster - Cant start MYSQL - Digital Ocean Box

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

Is there any way to edit Information_schema in 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

MySQL enable GTID on Replica MySQL instance

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

Live search query using JS and PHP for QA forum

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

What is my SQL missing?

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