Question : I was playing around with Sakila and I ran across the actor_info view and one of its columns […]
Filtering out duplicate domains from URL column using Postgres full-text search parsers
Question : I have a PostgreSQL database containing pages and links downloaded by a web crawler, with the following tables: […]
How to make a line/string to multiple records
Question : So, I want to create a teacher-degree (1:m) table. I have this example: One professor has 3 degrees. […]
How to store likes to posts in Parse.com database?
Question : In my parse database I have a classed called Post and Like. Should I create a field likes […]
Using sys.diana and sys.pidl to parse PL/SQL
Question : It seems to me that it should be possible to parse existing PL/SQL with the packages sys.diana and […]
SQL SERVER: How to get the stored procedure text EXCLUDING comments?
Question : I need to find all the stored procs that use Transactions, as I want to enable transaction abort […]
Extract/parse info between delimiters
Question : I have a column where there are 10 “fields” separated by the pipe character, looks like this: texthere […]
Why are CASE-expressions in the list documenting operator precedence?
Question : In the list here: https://mariadb.com/kb/en/operator-precedence/ case-expressions are put at the same precedence level as BETWEEN, between the NOT […]
MySQL .frm file format: how to extract column info?
Question : Is there a more up-to-date specification for MySQL’s .frm files than the one on dev.mysql.com? I’m trying to […]
Parsing and binding variables for SELECT .. WHERE column IN ( .. ) queries
Question : I’m looking to make sure that all queries in a php web application have proper use of bind […]