I am beginner in web dev and trying to create a project using Mysql, Node.js with Express. Facing this TypeError issue while using Sequalize. Can someone please
The node js code operates as follows; fnGetLogEvents() calls AWS GetLogEventsCommand to get the events of the log stream putCloudwatchLog is called to convert e
I'm upgrading my Laravel app to use MySQL 8.0.23 from 8.0.20, and I see an issue with WHERE clauses that produce unexpected results. SELECT * FROM guilds W
These are all optional fields, so will I have to write multiple queries with conditions or is there any way to handle this using Laravel? What will be the query
I have this (MySQL) database, sorted by increasing timestamp: Timestamp RateSingle RateDouble RoomId 2022-01-01 100 150 1
I need help to fill random_data (between 0.750 to 0.775) for particular member_id with date and time stamp with 15 min increment start from particular date, Let
During attempt to create HibernateSession application fails with exception: Caused by: java.sql.SQLException: Unknown initial character set index '255' re
I have Maven project with Hibernate/Spring/MySQL. I have basic entity and I want Hibernate to create tables automatically, but Hibernate doesn't create any tabl
I tried out Docker with UFW and i read a lot of this. My goal was to connect to an mariadb database on the host machine from an docker image. Host (running u
I am working on a nestjs project. My project gets data from Kafka's topic and writes the data to the database (mysql). If I read hundreds of messages from Kafka
my connection: $con = new mysqli('localhost', 'root', '', 'test'); it does not work with that either: $con = new mysqli('localhost', 'root', '', 'test'
I'm developing a new website with PHP & MySQL. The website is for an online eBook library that grant access to its books based on paid subscription plans.
I want to build a poll where the answers are not assignable to the voters. But I need to keep track of who already voted. So I have two different MySQL tables,
I use mongodb and mysql together with Laravel. Fields table in mysql database can have more options in mysql database. fields table in mysql: id, name options
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