My issue with SQL function, is that I often mix SUM / COUNT, or even where I can put a WHERE clause and a GROUP BY, short version, SQL is one of my flaws. Ok, now here's my current issue,…
I have one date column and another date column for the invoice date. Example : While in Excel I can just filter the InvDate column into "before 01-12-20" and filter the DATE column into "Last Month" then it give me…
I've downloaded someones laravel-project and try to run it. There was also a '.sql'-file attached. The '.env' -file was mentioned in the project's .gitignore-file, hence it wasn't included in the repository (which is the best practice, I recon). I copied…
I want to get the first two items of each month for each person. The idea is if the item have the same date, it should return the largest amount instead. I am having trouble writing a simple logical condition…
I have this MYSQL table (simplified version) with some erased ids: +-----+-------+---------+ | id | name | country | +-----+-------+---------+ | 1 | John | England | | 5 | Emily | USA | | 9 | Joe | USA…
Server: MariaDB, version 10.4.17 Query: select something from (select 1, 2 as something) Error in phpMyAdmin: #1064 - Something is wrong in your syntax 'LIMIT 0, 25' Error in MySQL Workbench: You have an error in your SQL syntax; check…
I am working on a website where I work with Advanced custom fields and woocommerce. I have 1800 products which can be created and edited by members (of course each member can only edit their own product). Since each product…
I want to change date only without the timestamp part. I'm trying to change from phpMyAdmin. So it doesn't execute 3 parameters of DATEDIFF. For e.g: post_date 2020-12-16 23:20:48 2020-12-16 23:40:42 Add 4 days post_date 2020-12-20 23:20:48 2020-12-20 23:40:42 OR…
I'm using MariaDB and PHPMyAdmin, but my code is all neutral so happy to switch to Postgres or whatever, but this should be straight forward enough. I haven't designed anything yet, just after best approaches. I have 3 database tables…
Im using phpmyadmin for the first time and I get this error: incorrect table definition. there can be only one auto column and it must be defined as key. What am I doing wrong? This is my code: CREATE TABLE…