Creating MySQL Databases & Tables (with added tips)
This is a post on creating databases/tables in MySQL on both Windows and Linux, with added tips to help with general usage.
This is a post on creating databases/tables in MySQL on both Windows and Linux, with added tips to help with general usage.
In my previous post, I created a Link Server to another SQL Server instance This time, it’s a link to a Postgres database!
There are many reasons why you’d need to delete old data from a table within a database, some of which include;
This post is a quick run-through of using a PowerShell script to count rows within many CSV files, with a quick check of the data afterwards.
Sp_whatnow? sp_who, sp_who2 and sp_whoisactive are stored procedures that allow you to view current users, sessions, and processes within a SQL Server instance.
This is a follow-on post from Configuring MAMP (with WordPress) and is a guide on how to copy a website onto MAMP.