Substack Repost — OpenLampTech issue #62

1 min readJan 21

--

CF7 blocks | 7 SQL constraints | WooCommerce customizations | WordPress Certifications. Thank you for reading OpenLampTech!

Receive a free copy of my eBook, “10 MySQL Tips For Everyone”, when you subscribe to the weekly OpenLampTech newsletter.

OpenLampTech has sponsorship opportunities in the weekly newsletter for your brand, product, or service. As a starter publication, collaboration is very budget-friendly. Send a private message for more details and interest.

Joshua Otwell

Written by Joshua Otwell

SQL, PHP, CodeIgniter, and WordPress. Growing through Technical Writing and Blogging. Sign-up for my free developer newsletter here: openlamptech.substack.com

More from Joshua Otwell

SVG of drawn colorful calendar

Joshua Otwell
in
Level Up Coding

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

I constantly look to improve SQL-related skills and knowledge. Having a foundational understanding of MySQL, with moderate to heavy use…

5 min readApr 30, 2021

--

Joshua Otwell
in
codeburst

Edit existing FOREIGN KEY constraints in PostgreSQL with the ALTER TABLE command.

While setting up a test database on my system, I discovered the need to ALTER existing FOREIGN KEY‘s. Here’s what I studied, learned, and…

4 min readFeb 28, 2018

--

Joshua Otwell
in
Level Up Coding

Determine the First and Last Day of a Month with MySQL

Working with date values is part of every developer’s job. It seems like we are always looking for or filtering some data by date or a…

4 min readJan 17, 2022

--

Joshua Otwell
in
An Idea (by Ingenious Piece)

Import CSV file data into MySQL table with phpMyAdmin

In the blog post MySQL CREATE TABLE in PHPMyAdmin — with examples, I covered using phpMyAdmin’s visual interface to complete CREATE TABLE…

5 min readApr 29, 2020

--

See all from Joshua Otwell

Recommended from Medium

Love Sharma
in
Dev Genius

System Design Blueprint: The Ultimate Guide

Developing a robust, scalable, and efficient system can be daunting. However, understanding the key concepts and components can make the…

9 min readApr 20

--

Gabe Araujo, M.Sc.
in
Level Up Coding

🧬 How I Used Python to Make Everyday Tasks Easier

Hey there! As a busy person with a lot on my plate, I’m always looking for ways to make my life easier.

8 min readMay 1

--

Lists

Stories to Help You Grow as a Software Developer

19 stories70 saves

Leadership

30 stories29 saves

How to Run More Meaningful 1:1 Meetings

11 stories35 saves

Stories to Help You Level-Up at Work

19 stories53 saves

The PyCoach
in
Artificial Corner

You’re Using ChatGPT Wrong! Here’s How to Be Ahead of 99% of ChatGPT Users

Master ChatGPT by learning prompt engineering.

7 min readMar 17

--

Bobby
in
Level Up Coding

6 Pythonic Ways to Replace if-else Statements

Avoid if-else the Pythonic Ways

6 min readFeb 27

--

Tate Galbraith
in
Better Programming

6 More Unique Linux Utilities You Forgot About

To the depths of /usr/bin once more

5 min readDec 1, 2022

--

Alexander Nguyen
in
Level Up Coding

Why I Keep Failing Candidates During Google Interviews…

They don’t meet the bar.

4 min readApr 13

--

See more recommendations

Help
Status
Writers
Blog
Careers
Privacy
Terms
About
Text to speech