I have a table with tier pricing showing the more products purchased the better the price. I have to import this table into another program that only lets me import products with the same sku once. This means I have…
I have a table named sales_data where I have 3 columns (id int, udf varchar(20), date_of_sale datetime). I'm trying to find weekday for the column date_of_sale by adjusting the time to 6 hours, now I have to update the column…
I have a sample table where I have written Case statement. where I'm not able to write the proper syntax. SELECT case when SECTION = 'A' then case WHEN (SECTION ='A' AND ROLE = ROLENUMBER) THEN 'GOOD' ELSE 'BAD' end…
I'm struggling with replacing value in my wordpress database. I want to change status from "sent" to "completed" in statuses that are related to termins from the past. This is sql which finds what I need: SELECT pm1.meta_value AS Status,…
the story: i have 2 tables of students. i need to find for every student in table A whether there is some student in table B that is younger and has the same name. TABLE A (not real table, could…
I want to write a SQL query that will find all the number of records in a table that are associated with the same child records. For example: In the dataset below parents 1001 and 1003 are associated with the…
I want to replace some acquaintance values by keywords to specific value, converting both "google" and "searching google" to "seo" I tried replace but you should specify all the values to replace with and that's not possible. if there is…
I'm trying to make a CRUD app on laravel. server is on docker and localhost is on 0.0.0.0 SQLSTATE[HY000] [2002] No such file or directory (Connection: mysql, SQL: select * from `students`)
My SQL knowledge is a bit more limited than I'd like to admit. What I'm attempting to do is query a single table. In that table I want to return and group items with the same "name" (column), but only…
I have a column CreatedDate and I want to set the below default value in the below format for this column. Default value:- yyyy-mm-dd 00:00:00.000 I have tried multiple solutions like I have used DATETIME datatype, TIMESTAMP but it is…