I am trying to go deeper with Sequelize and especially using migration. But, I can't imagine that the documentation requires that we use a json file to put database info. So, my question is, "how can this be possible when…
I've been stuck on this SQL query for a day now, so I'm throwing it up here and would appreciate any advice others can give. This is the problem: I want to generate a set of pairs of tags (named…
I am trying to embed a Delete operation in SELECT in postgres. Tried the following command but its not working.. :( select * from tasks where title ilike '% Delete from tasks where title ilike `%Re%` returning ( Select title…
I have a example scenario, where I have a table with 3 columns which are feature_id value product I want to get all the products where feature_id is 1 or 3 and value is "Yes". Following query in sql give…
What I need is to return all records that may overlap each other. -- Create Temp Table CREATE TABLE `abc` ( `id` int(11) NOT NULL, `propertie_id` int(11) NOT NULL, `rooms_id` int(11) NOT NULL, `block_name` varchar(256) NOT NULL, `check_in` date NOT…
While copying the data from a CSV file it's throwing the issue as: SQL Error [23514]: ERROR: new row for relation The location of the CSV file and the table name have been checked. I have tried using different delimiter…
My question is relevant to the concept of searching data. I am developing a project with Laravel. The question is, which is efficient? Get data from the database and search through PHP, Or prepare the SQL command and search inside…
I am trying to update a table column with below query. UPDATE `prayer_times` SET `maghrib_jamat` = `maghrib` + .05; I have two column maghrib_jamat and maghrib. In maghrib values are like 18:42 which is a time value with varchar type.…
I have to extract a list froman database based on the following conditions: "Add below a list that displays the top ten dogs in the show. This is defined as the ten dogs who have the highest average scores, provided…
I am writing a Flexible Search query to get the orders from database and delete them. The condition to get the orders is that : if the order is placed 3 months before the current date, I need those orders…