i am creating a friend request system that allow user to send request to each other to add as friends like facebook and i have 2 conditions that if : the us
I wanted to create a table with the name of the table being a date. When I gather stock data for that day, I wanted to store it like this: $date = date('Y-m-d'
I am trying to connect my Servlet to mysql database using data Source . But whenever I run my servlet I end up getting this exception : java.lang.AbstractMetho
I am learning MySQL and tried using a LOAD DATA clause. When I used it as below: LOAD DATA INFILE "text.txt" INTO table mytable; I got the following error:
I want simulate the behaviour of collect_set in SQLAlchemy (using MySQL connector). i.e. group A 1,2,3 would be the same as 2,1,3. I have the following code: r
I have created a website that uses a MySQL database, but when i put it online, it doesn't work anymore. in my class connection.vb that i use for my connection t
this.sampleRepo.find ( { where: { id: In ["1","7","13"] } order: {
The problem Im facing while trying to connect to database for mysql. I have also given the database settings that i have used. Traceback (most recent call las
The in-built Auto-Increment in MySQL doesn't meet my requirement so I'm thinking about making a new one. Here is my requirement: Create an increment serial num
I have a products table and a product_pictures table, where a single product can have many pictures (one to many relationship). I am trying to display all of th
I have a products table and a product_pictures table, where a single product can have many pictures (one to many relationship). I am trying to display all of th
I have a table like create table try ( firstname varchar(4), username varchar(4)) My question is that is there a way to insert the current_user() or user() valu
I was trying to solve problem in Hackerrank SQL Practice section and stuck in Problem 'Weather Observation Problem 20'. To find Median, I though of the followin
I am using NestJS, TypeORM, and MySQL to build a web application. I am using a .env file to pass in some environment variables for connecting to my local datab
I would like to have a SQL formula to match all the words in a query in any order without using multiple 'AND like' statements. For example, the query 'cat dog
I'm migrating a site from Site5 hosting to InMotion Hosting and the importation of the mysql file (via phpMyAdmin) is not working. import of mysql file failed,
I have MySQL installed on an Ubuntu machine. When I run use TWEETDATA command it shows me following error ERROR 1049 (42000): Unknown database 'tweetdata' Bu
I have 2 table model Product { id name skus[] Sku } model Sku { id name price weight productId product Product } Data example: Product t
Let's say I'm migrating a MySQL database to PostgreSQL with pgloader, using the default sample on the official website: load database from mysql://
I like to catch the id of below tag in show.php file once the link is clicked... I have already got the href name in show.php <?php if (isset($_GET['subm