Independent Science + Technology

Author: Joshua Otwell

CodeIgniter 4 Query Builder union() and unionAll() methods

Post date December 8, 2022
Post author By Joshua Otwell
Post categories In codeigniter, mysql, php, programming, web-development

INTERSECT and EXCEPT commands in MySQL

Post date November 2, 2022
Post author By Joshua Otwell
Post categories In data, database, mysql, programming, technical-writing

Create CodeIgniter 4 Models With Command Line Generators

Post date October 30, 2022
Post author By Joshua Otwell
Post categories In codeigniter, mysql, php, programming, web-development

MySQL Metadata Queries — Find all tables in a Schema

Post date September 8, 2022
Post author By Joshua Otwell
Post categories In database, mysql, programming, sql, technical-writing

7 PHP String Functions You Should Know and How To Use Them

Post date July 20, 2022
Post author By Joshua Otwell
Post categories In data, php, programming, technical-writing, web-development

MySQL SELECT and WHERE Clause Column Existence

Post date June 30, 2022
Post author By Joshua Otwell
Post categories In database, mysql, programming, sql, web-development

Find All Table’s Current AUTO_INCREMENT Value

Post date June 23, 2022
Post author By Joshua Otwell
Post categories In database, mysql, programming, sql, technical-writing

MySQL WHERE Clause Equality Comparison Operator

Post date June 16, 2022
Post author By Joshua Otwell
Post categories In database, mysql, programming, sql, web-development

Multiple WHERE Clause Conditionals Using the MySQL AND Logical Operator

Post date May 12, 2022
Post author By Joshua Otwell
Post categories In database, mysql, programming, sql, web-development

MySQL Workbench GUI — Create Table

Post date April 15, 2022
Post author By Joshua Otwell
Post categories In database, mysql, programming, sql, technical-writing

CodeIgniter 4 Query Builder join() Method Explained

Post date April 12, 2022
Post author By Joshua Otwell
Post categories In codeigniter, mysql, php, programming, web-development

MySQL String Concatenation with CONCAT()

Post date March 18, 2022
Post author By Joshua Otwell
Post categories In database, mysql, programming, sql, technical-writing

Counting with countAll() and countAllResults() in CodeIgniter 4

Post date February 18, 2022
Post author By Joshua Otwell
Post categories In codeigniter, mysql, php, programming, web-development

Fill in missing Date ranges using MySQL

Post date January 20, 2022
Post author By Joshua Otwell
Post categories In database, mysql, programming, sql, technical-writing

Determine the First and Last Day of a Month with MySQL

Post date January 17, 2022
Post author By Joshua Otwell
Post categories In data, database, mysql, sql, technical-writing

Export Query Results to CSV with MySQL Workbench

Post date December 28, 2021
Post author By Joshua Otwell
Post categories In data, database, mysql, sql, technical-writing

CodeIgniter 4 Query Builder set() function with update()

Post date December 23, 2021
Post author By Joshua Otwell
Post categories In codeigniter, mysql, php, programming, web-development

Use MySQL to Generate MySQL for Admin Tasks

Post date November 24, 2021
Post author By Joshua Otwell
Post categories In database, mysql, programming, sql, technical-writing

Enable File Attachment with CodeIgniter 4 form helper

Post date October 28, 2021
Post author By Joshua Otwell
Post categories In codeigniter, php, programming, technical-writing, web-development

MySQL Table DDL file with phpMyAdmin

Post date October 14, 2021
Post author By Joshua Otwell
Post categories In database, mysql, phpmyadmin, programming, technical-writing

CodeIgniter 4 CRUD Series with MySQL: Delete

Post date September 23, 2021
Post author By Joshua Otwell
Post categories In codeigniter, mysql, php, programming, web-development

CodeIgniter 4 CRUD Series with MySQL: Update

Post date September 16, 2021
Post author By Joshua Otwell
Post categories In codeigniter, mysql, php, programming, technical-writing

CodeIgniter 4 CRUD Series with MySQL: Read

Post date September 9, 2021
Post author By Joshua Otwell
Post categories In codeigniter, mysql, php, programming, technical-writing

CodeIgniter 4 CRUD Series with MySQL: Create

Post date September 1, 2021
Post author By Joshua Otwell
Post categories In codeigniter, mysql, php, technical-writing, web-development

SQL Joins — A Simple Guide

Post date August 19, 2021
Post author By Joshua Otwell
Post categories In database, oracle, programming, sql, technical-writing

How to use the LEAD() Window Function and discover gaps in Dates

Post date August 5, 2021
Post author By Joshua Otwell
Post categories In database, oracle, programming, sql, technical-writing

Two SQL Queries to find rows present in one table but not another.

Post date July 30, 2021
Post author By Joshua Otwell
Post categories In database, oracle, programming, sql, technical-writing

How to re-order a comma-separated list in Oracle SQL

Post date July 22, 2021
Post author By Joshua Otwell
Post categories In database, oracle, programming, sql, technical-writing

RECURSIVE CTE Fun with SUBSTRING() in MySQL

Post date July 15, 2021
Post author By Joshua Otwell
Post categories In database, mysql, programming, sql, technical-writing

How ORDER BY is restricted in GROUP BY queries

Post date July 2, 2021
Post author By Joshua Otwell
Post categories In database, oracle-database, programming, sql, technical-writing

How to Rename an SQL Table

Post date June 24, 2021
Post author By Joshua Otwell
Post categories In database, oracle, programming, sql, technical-writing

Dynamic RPAD() Function using a CASE Expression — Oracle SQL Example — Digital Owl’s Prose

Post date June 16, 2021
Post author By Joshua Otwell
Post categories In database, oracle, programming, sql, technical-writing

Import CSV file with Oracle SQL Developer

Post date May 27, 2021
Post author By Joshua Otwell
Post categories In database, oracle-database, programming, sql, technical-writing

How to find the first and last day of a month with Oracle SQL Date Functions

Post date April 30, 2021
Post author By Joshua Otwell
Post categories In database, oracle, programming, sql, technical-writing

MySQL Count Weekday Occurrences

Post date April 15, 2021
Post author By Joshua Otwell
Post categories In database, mysql, programming, sql, technical-writing

Nothing left to load.