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
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
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
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
"Could not get constructor for org.hibernate.persister.entity.SingleTableEntityPersister " I am not using any maven or such tools and manually add and reference
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
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
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
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
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
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
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=