I have a laravel application A with a mysql database db1 and a table p1 and a diffrent php application B with an equivalent table p2 in its mysql database db2. I want to find best, secure and complete way…
I am using MariaDB and I am trying to create a query that updates the boolean column is_popular of my photos table, called Pics. To find out which photos are "popular", I pick the top 10 from the entire table.…
I have two tables, organization and address. organization table has an address_id column but all the rows have address_id set to NULL. I want to SET address_id in organization table equal to a random id in address table but I…
Probably a very simple solution but I am pretty new to PostgreSQL and I need you help good people. I have a table called countries containing information about different countries and later on I added a column called three_rivers that…
I'm trying to manually update a SQL Server column of type nvarchar(max) with a huge JSON parsed as text. It's a simple, straightforward query: UPDATE Books SET Story = '' WHERE Id = 23 The problem happens when the JSON…
Suppose I have an update query for a table with constraints (Postgres 11). I do not know the constraints so I won't be able to determine whether an update query will fail or not. If an update query failes due…
I have a task table with 1000 rows in my Postgres 12 database. I need to get last 100 rows non-executed, set column executed to 1 and return that selected rows. If I do code below, it updates all 1000…
I would like to update values in one postgres table from values in another postgres table, but I would like to update only values which NEED to be updated - ie if a value is already correct, leave it alone…
I have a table of real estate data with lots of NULLS in address column. I want to replace these nulls based on the unique ID. (I'm following Alex the Analyst tutorial). However when I use this in postgresql, I'm…
I have an inventory system with bins, lots, and transactions. Bin: has many lots Lot: belongs to a bin belongs to many transactions transaction_lot (pivot) - quantity Transaction: belongs to many lots Right now I have an attribute on Transaction…