I need some help with the query below - I am trying to pull information regarding price and multiply with the quantity & insert the sum into the table. So far I have, update passenger_baggage SET passenger_baggage.total_baggage_cost=passenger_baggage.passenger_baggage_quantity*baggage_type.baggage_type_cost FROM passenger_baggage INNER…
I am trying to empty the database of any data, while keeping the relationships and tables as they are I have no idea if my thinking is right or wrong
I've data like below: ID Task Time 1 X started T1 2 X ended T2 3 X started T3 [wrong entry in data] 4 X started T4 5 X ended T5 6 Y started T6 [wrong entry in data] 7…
I have the following SQL query: SELECT `NeighbourhoodName`, count(NAME) as `Number of Parks`, sum(CASE WHEN `parks`.`Advisories` = 'Y' THEN 1 ELSE 0 END) as Advisories, FROM parks GROUP BY `NeighbourhoodName`; In the second line of the code, I create a…
How do I run it for all rows of a given product id and shop id: One table: ps_product_shop id_product price id_shop 1 1 1 1 25 3 2 2 1 2 50 3 THX For one line: UPDATE ps_product_shop…
I have a MySQLdump generated by PHPMyAdmin, and I need to import it into a Postgresql database, but I dont know if it's even possible. I've seen people recommending pgloader but seens a little confusing on how to do it.…
I have a database of polymorphic structure: a "base" type table and two "derived" types: CREATE TABLE ContactMethod( id integer PRIMARY KEY person_id integer priority integer allow_solicitation boolean FOREIGN KEY(person_id) REFERENCES People(id) ) CREATE TABLE PhoneNumbers( contact_method_id integer PRIMARY KEY…
I have this query ` CREATE TABLE Commitment_fees (user_id INT PRIMARY KEY AUTO_INCREMENT, amount INT, success INT, date DATE); ALTER TABLE Commitment_fees AUTO_INCREMENT=1000; INSERT INTO Commitment_fees (amount, success, date) VALUES (1000, 1, '2021-01-01'), (1010, 0, '2021-01-01'), (200, 1, '2021-01-01'), (201,…
This query works fine: $query = "SELECT * from hired WHERE username = 'kaas' and dvd = 'dvd 2'"; But then I change it to this query: $query = "SELECT * from hired WHERE username = " . $_SESSION['name'] .…
I want a list of user_id which shouldn't have zero status. Lets say, I have task table with user id, status. I'm trying to write a query to fetch user ids which have status = 1 only but not 2.…