Im trying to match both userIngredient.i_id and recipe_ingredient.i_id and match and compare all values of recipe_ingredient.i_id, the query I tried only displays all matching i_id's without the non matching i_id's, heres the data- recipe_ingredients table: +---------+------+ | post_id | i_id…
I'm selecting posts from a 'posts' table in a MySQL database, but I want one of the columns returned to be a comment count from a comments table using the rows selected post id. My DB is relational so the…
Here my MySQL query (work in phpMyAdmin) : SELECT workcenter, (SUM(w1+w2 +w3 +w4)/ (COUNT(DISTINCT(teknisi))*40*4) )*100 AS total FROM `team` GROUP by workcenter ORDER BY total then, i try in Laravel Sintax like this below (not work) : $sql = Team::groupBy('workcenter')->select('workcenter',…
I am using vagrant with virtualbox. I get this error when inserting data to database. Things I have tried to fix the error: Clear all caches, routes and config Made sure my env file is configured (I already tried to…
I've created a few migrations already using Alembic, it's a really interesting tool. Using it on a new DB would be straightforward enough, however our usecase is to apply these migrations to existing DB's, not only to bring them "up…
I'm currently a newbie on Mysql and I've been handed a task to actually remove 200,000 plus data through phpmyadmin. I've actually screen through all the data and extracted the user ids from it, just to know that it does…
I'm using WordPress + Woocommerce for one project. The problem is that the CSV file from the client has over 650k records for products and I have to upload all these products to woocommerce store. Wordpress using 2 tables (wp_posts,…
Step 1) mysql5 & phpmyadmin Image the following mysql-phpmyadmin configuration: version: '3.6' services: db: image: mysql:5.7.24 # image: mysql:8.0.18 # image: mariadb:10.4.8 # command: --default-authentication-plugin=mysql_native_password restart: always volumes: - ./mysql5:/var/lib/mysql # - ./mysql8:/var/lib/mysql # - ./mariadb:/var/lib/mysql environment: - MYSQL_ROOT_PASSWORD=test -…
I have a website where subtitles are translated and where it is possible to save translated subtitles to mysql database. In the database I have a table consisting of 2 significant columns: "name" and "langugage" When a user who save…
I have the following SQL: SELECT members.id, FLOOR(DATEDIFF('2019-10-25', crew_cv.dob) / 365.25) as age FROM members JOIN crew_cv ON members.id=crew_cv.user_id WHERE members.active=1 AND age>20 AND age<30 ORDER BY crew_cv.last_name, crew_cv.first_name LIMIT 0,30 And I get the following error in phpMySQL: #1054…