Skip to content

WebCheatSheet

The easy way to know

  • PHP
  • HTML
  • JavaScript
  • SQL
  • ASP
  • MS Access Functions

Category: SQL

SQL

Get size of all databases and tables in MySQL

adminOctober 16, 2023

Code first: This simple SQL query will return the size of all databases of your MySQL Server, listing the largest…

SQL

Insufficient access rights error when doing backup

adminJuly 28, 2023

All of sudden SQL Server Management studio gives me the following error message when I’m trying to browse for the…

SQL

How to transfer logins and passwords between instances of SQL Server

adminJuly 28, 2023

To transfer logins and passwords between different versions of SQL Server, follow these steps: Run the following script on the…

SQL

Fix: Cannot load from mysql.proc. The table is probably corrupted

adminJanuary 4, 2023

After upgrading MySQL from version 5.0 to 5.5 I started getting the following message trying to edit table structure in…

SQL

How to Back Up and Restore a MySQL Database

adminDecember 7, 2022

If you’re storing anything in MySQL databases that you do not want to lose, it is very important to make regular…

SQL

Structured Query Language (SQL)

adminNovember 25, 2022

Structured Query Language (SQL) SQL is a computer language aimed at accessing, manipulating, and querying data stored in relational databases.…

SQL

Determine MYSQL Version From the Command Line

adminNovember 25, 2022

Determining MySQL version is not very difficult but the command line is a quick trick and its useful. Once you…

SQL

Microsoft Access Specifications and Limitations

adminOctober 30, 2022

Just as any application, MS Access has specifications and limitations that should be remembered. The following tables specify the maximum…

Recent Posts

  • Get size of all databases and tables in MySQL
  • Insufficient access rights error when doing backup
  • How to transfer logins and passwords between instances of SQL Server
  • How to be a better PHP developer
  • How to create a dump of MySQL database in one click

Recent Comments

No comments to show.

Archives

  • October 2023
  • July 2023
  • June 2023
  • May 2023
  • April 2023
  • March 2023
  • February 2023
  • January 2023
  • December 2022
  • November 2022
  • October 2022
  • September 2022
  • August 2022

Categories

  • ASP
  • HTML
  • Interactive SQL Tutorial
  • JavaScript
  • MS Access Functions
  • PHP
  • SQL
  • Uncategorized
Copyright © 2025 WebCheatSheetFresh News by Ascendoor | Powered by WordPress.