I'm trying to upload this sql file that's 225MB to phpmyadmin with MAMP. However, I keep getting this error Script timeout passed, if you want to finish import, please resubmit the same file and import will resume. I've changed the…
Script below creates a simple database and table. In windows environment, you can use it with wamp server's ( https://sourceforge.net/projects/wampserver/ ) phpmyadmin sql console: delimiter $$ create database testtimes $$ use testtimes $$ create table mytime ( hour bigint not…
Using MySQL, I have the following table called subscriptions shown below name, renewal_date, national_id --------------------------------------- ted, 1/2/2010, A1111R ben, 1/3/2010, A145E1 bob, 8/4/2009, A11C11 kate, 2/2/2010, A111E1 ted, 12/2/2011, A1111R bob, 12/2/2014, A11C11 ben, 12/2/2016, A145E1 etc.. The table has…
I'm trying to update a particular url in wordpress post_content table. I have over 5000 differents urls to update for a single same one. So in clear I have 5000 urls that all starts with : domain.com/params.php?.... AND always ends…
Good day, I have a woocommerce eshop in which I do not use variants ... all products are simple. But for partner shops I need to create XML with variable products. I have products that are not published are "hidden"…
Here my MySQL query (work in phpMyAdmin) : SELECT waktu_kerusakan, workcenter, COUNT(workcenter) AS jumlah_repair FROM repair WHERE year(waktu_kerusakan)='2019' GROUP BY workcenter , month(waktu_kerusakan) BETWEEN 1 and 6 Order By jumlah_repair Desc then, i try in Laravel Syntax like this below…
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 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…
So I have database with amount and created_at field on it and I want to the total amount per month of the current year and or every year. $sql = 'SELECT SUM(amount) as "Amount",MONTHNAME(created_at) as "Month" FROM transactions WHERE YEAR(created_at)…
This is my first time creating a sql procedure, and i need some help. What i am trying to do is to create a procedure that returns true or false if the user has correctly inputed his email and password…