Category "mysql"

Unable to drop database mysql: ERROR 3664 (HY000)

I have a database in my application named X-Files. I want to drop it. But whenever I run the command drop database X-Files I am getting following error: mysql

Wordpress cannot connect to mysql server

I have run a mysql server in my macbook, where I can access via both mysql command mysql -u root and navicat application. However, when I open the install page

Why I get Unknown column problem with CTE in MySQL

I am getting the next error with a select query. If I get rid off the update clause the error disappears: Error Code: 1054. Unknown column 'CTE.id' in 'where cl

How to join two tables using a comma-separated-list in the join field

I have two tables, categories and movies. In movies table I have a column categories. That column consists of the categories that movie fits in. The categories

MappingException (Hibernate)

"Could not get constructor for org.hibernate.persister.entity.SingleTableEntityPersister " I am not using any maven or such tools and manually add and reference

How to generate the table schema from INFORMATION_SCHEMA in MySQL?

I trying to generate table structure using INFORMATION_SCHEMA in MySQL. I need the same output as SHOW CREATE TABLE Mytablename; My intention is to generat

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=