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 …
Tag: phpmyadmin
I am struggling to remove the last 30 characters from data in a column
I am looking to remove the last 30 characters from a colum within my database. I have created the below which works in the sense it shows me the result and it’s correct but it does not commit or change anything. What am I missing, I am a noob 🙂 I expect the data in the column to remove the
Allowed memory size exhausted when I use “OR”
In my database, I want to filter the data by date : I have multiple checkbox for that. When I check 2018-2019 for example, I want to get every information between ‘2018-09-01’ and ‘2019-08-31’. I …
Selecting an attribute that has max value for another attribute
**** Edit: How do I also consider the case where there is more than one property with the highest value? I’m trying to write an outer query that takes the propertyname with the highest value from an …
Is there any other way to extract the number of exam?
Hello everyone I have a problem that I need help with I’m trying to get number of exam for specified student we have three tables : etudient (N_Appoge,Nom,PRENOM,filiere,….) module (NUM_Module,…
Adding a table in phpMyAdmin,shows a lot of errors
Hello i am still learning and i faced this problem,please how can i fix it ? A symbol name was expected! (near “id” ) At least one column definition was expected. (near “id” ) Unexpected …
Can I bookmark SQL query with bind parameter?
I’m quite new to databases. I’m using phpmyadmin and I’m writing just simple SQL queries. I’m curious if I can bookmark a query with bind parameter so I could set the parameter next time again. I have the following query and I want to set myID every time I run the query without rewriti…
Replace chars in string if it starts or ends with specified char
I have a column in my database with entries that starts or ends with a hyphen. I would like to find these rows and remove/replace the hyphens if it’s the last or first (or both) char in the string. …
I have error “#1363 – There is no NEW row in on DELETE trigger “
I have table “book” and “store_order” have relation I want to make trigger(but it contain error): Answer
MySQL not showing databases created in phpMyAdmin
I’m trying to build a database for my server in phpmyadmin but when I finish building it I can’t access it using PHP and it won’t show when I list the databases in MySQL. But when I create a database in mySql it shows up in phpmyadmin. Also I’m running phpmyadmin version 4.0.3, and the…