While I’ve only gotten to Level 16 in Pokémon Go so far, I have taken a decent amount of notes and thrown them at https://krypted.com//pokemon-go-tutorial/. Thanks to the others at JAMF Software for getting me started on documenting this stuff, and if anyone sees anything I missed please feel free to comment!
-
-
Moar About SQL Wildcards
Previously we looked at using wildcards in conjunction with the SQL LIKE operator. Wildcards allow you to search for data in a defined table. Think of them as text globbing for SQL. The wildcards available include the following: [list]: Define a ranges of characters for pattern matching [!charlist]: Matches only a character NOT specified within the brackets %: Require a single character/object in a pattern _: Allow any single character in a pattern In this article, we’ll use the same “Customers” table from our first articles: ID Site Contact Address City Zip Country 1 Krypted Charles Edge my house Minneapolis 55418 US 2 Apple Tim Cook spaceship Cupertino 95014 US 3 Microsoft Satya Nadella…
-
Add New Records To MySQL Databases With The INSERT Statement
Sometimes you need to write a record into a table in a SQL database. The INSERT INTO statement creates new records in a table and can work in one of two ways. The first form does not specify the column names where the data will be inserted, only their values. When doing so, each value needs to be inserted in the columned order they appear, here the table being the name of the table you’re adding a record into and each value would be replaced with the contents of your value (don’t insert the string ‘value’ into each!): INSERT INTO table VALUES (value,value,value,...); If you don’t have every value to…
-
Compound Searches With SQL Using AND && OR
Previously, we looked at the SQL SELECT and WHERE options to obtain output and then constrain what would be displayed in a query. The AND & OR operators are used to add additional logic so you can filter records based on more than one condition. Which is to say to search based on the contents of multiple columns within a single table. AND is used to show information if two different conditions are true and OR is used to show information if either condition is true. Below is a selection from the “Customers” table that showed in our first article an we will use it to run some SQL sorting…