Skip to content
Advertisement

Tag: mysql

using condition for Group_Concat

I want to find all ids of which group_concat only contains ‘a’. Here is simplified table from mine. ╔════╦══════════════╦ ║ id ║ group_concat ║ ╠════╬══════════════╬ ║ 1 ║ a,b,b ║ ║ 2 ║ a …

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’m not aware about

sql – Add 0 after a numeric value

I have columns in my sql table. I am wondering how can I add zero after numeric values in my columns. So for example: I have values e.g 9, 2, 7, 10. I want to add a zero after these numbers. I want them to be 90, 20, 70, 100. There are some values in the columns that already have

How to use Distinct OR Group by with Inner Join?

have a problem with sql query, simple one but though I’m sitting on it 3d day and cant figure out what is wrong, please help. Table 1: Table 2 Result Desired result – in my reslt I want to display each portfolio ID ONLY ONCE. sql query: Any ideas / solutions are welcomed. Thank you Answer Use row_number(): EDIT: In

Advertisement