Aug 06 Love0 MySQL – find in set vs in By Prodjex mySQL, SQL No Comments These are two different commands with different outputs when added to a SQL query. MySQL "in" command for example: select * from assets a left outer join assetInterests ai on…Read More
Jul 31 Love0 Delete Duplicates from mySQL Database Table By Prodjex mySQL, SQL No Comments I was trying to figure out a query to count the IP addresses I had in a table, tell me how many are the same, then delete duplicates only leaving…Read More