An application I've been troubleshooting has had major performance issues last week. I spent a few hours on it banging my head against a wall. Finally after doing some research…
Read More
This will be a walk-through on how to create a submit form that checks the database to make sure the username is not taken. If it is taken it will…
Read More
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
This is the first in what will end up being a several part tutorial on creating a Twitter posting program. These tutorials will show how to create the bot using…
Read More
I have a couple of tables I'm joining and only want to return users that a field missing in the joined table. Users id fname lname userMeta id metaKey metaValue…
Read More
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
Basic syntax for using case when statements in SQL. For this example we want the following: If Field1 = 2 and Field2 = 2 then use the date in Field3…
Read More
Simple SQL query to sum an alias column and group by ID. Initial query user needed help with: select dt.member_id, dt.NumberOfMonthsBetween FROM ( select member_id, DATEDIFF(month,date_credentialed,renewal_date) as NumberOfMonthsBetween from member_credential…
Read More
