How to Import a CSV using MySQL Workbench
Are you working on a MySQL database and need to import CSV data?
I’ll show you how to do this in MySQL Workbench in this guide.
17 Sites for SQL Practice
Are you looking for places to practice SQL online? This list contains many different websites that have SQL practice functionality.
81 Best Books for Programmers
If you’re a programmer or software developer, you’ve probably done a lot of reading. And if you’re interested in becoming a better programmer, there are many books you can read to improve your skills.
This page contains a list of the best books for programmers. I’ve looked at different lists on Google, Reddit, Twitter, and other places.
SQL Server ROW_NUMBER SQL Function
In this guide, you’ll learn all about the ROW_NUMBER function in SQL Server.
Dynamic SQL: A Guide for SQL Server, Oracle, MySQL, and PostgreSQL
Dynamic SQL is a handy feature of a database that lets you construct SQL statements in a different way.
MySQL Drop All Tables: How-To With Examples
There may come a time when you need to drop all tables in a MySQL database.
In this article, you’ll learn how to do that easily, both using an SQL command an inside an IDE such as MySQL Workbench.
Let’s see how we can do that.
How to Reset IDENTITY Column Values in SQL Server
Do you want to reset an identity column in your table in SQL Server so the numbers are in order?
And you want to do it without recreating the table?
In this article, I’ll show you how you can do this, and a few things to be aware of.
Let’s take a look.
SQL Rename Table: How To with Examples
Once you create a table in SQL, you may want to rename it. This might happen if you are creating a new table to replace it, or have come up with a better name for it.
In this article, you’ll learn the SQL commands to rename a table in Oracle, SQL Server, MySQL, and PostgreSQL, along with examples of each.
Let’s get into the article.
MySQL Create User and Grant Permissions: How To
If you work with MySQL, there will be a point when you’ll need to create a new user.
This could be for another part of the system or another developer on your team. Or perhaps you want to use a user other than the default “root” account on MySQL.
MySQL Date Data Types and Date Functions
Working with dates is something you’ll do a lot in MySQL.
It helps to understand the different date data types and many of the functions that can be used with them.
In this guide, we’ll look at the MySQL date data types, the date functions, and see some examples of them.
