Skip to content

Tag: phpmyadmin

Update every 5 minutes a value

I am using a MySql DataBase and I want to know if there are any methods to modify a value of a column every x minutes/hours/days. For example, I want to execute the following query every 5 minutes, UPDATE table SET x=0;. Could I set an event or something like this from the PHPMyAdmin interface? Answer I&#8217…

SQL entries in French/English and Japanese

I have an old SQL4 database and I’m trying to re-upload it to our newly created database on Phpmyadmin. The characters in the tables are latin and japanese. I tried to change those specific columns but the result is still broken characters for the columns I need to display in Japanese. Here is a screens…

Script timeout passed error on MAMP phpmyadmin

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 php.ini file in MAMP like so: I’ve also changed the se…

Select sum if and having count

I have 3 tables table artist with artist_id, name; table album with album_id, artist_id, name; table songs with song_id, artist_id, album_id, (few more things but I don’t think they are necessary for this problem); I want to select a table with the name of the artist, number of albums with equal or more…