info4PHP.com : PHP, MySQL Hosting , HTML Books, News, Links, Free Script Directory, Codes for PHP, php tutorials mysql tutorials free php hosting, forum discussions, XML ,php manual, tips, software, applications, website, mysql tutorials, documentation, reference, PHP and MySQL hosting
   PHP Scripts   |    Add Script/Link   |    PHP 5 Manual   |    PEAR Manual   |    PHP Functions   |    Forums   |
PHP General

PHP Categories

PHP CMS

MySQL General

HTML General

Latest Computer News

Partners

About 5000 PHP Scripts For You - Our PHP Scripts Directory

Allow SQL Server to Silently Truncate Data

Language: SQL, Expertise: Beginner - See two ways to prevent SQL from throwing this error.

Identifying all the Index(s) Available on a Table in MySQL

Language: SQL, Expertise: Intermediate - Learn a way to increase performance in MySQL.

Transpose Columns into Rows in SQL

Language: SQL, Expertise: Intermediate - Learn a different, albeit complicated, way to transpose columns into rows.

Quickest Way to Copy the Structure of a Table

Language: SQL, Level: Intermediate: - This quick tip demonstrates how to copy a table's data, as well as only the structure of a table.

Secure Your Data in SQL 2016 with Row Level Security (RLS)

Language: SQL, Expertise: Advanced - Learn to implement restrictions on data row access in SQL 2016.

Create a Snapshot of Your Database

Language: SQL, Level: Intermediate: - Use this code to create a snapshot of your current database.

Identify Tables Without an Identity Column

Language: SQL, Level: Beginner: - This query will enable you to list all the tables in your database that don't have an IDENTITY column.

Get the Total Number of Rows for Each Table in Your Database

Language: SQL, Level: Beginner: - Use the following query to get the total number of rows for each table in your database

Knowing the Version and Supported Engines in MySQL

Language: SQL, Level: Intermediate: - These commands are handy to find out the current version and supported engines in the MySQL.

Extract All Numbers from a String in SQL

Language: SQL, Level: Intermediate: - Learn this easy way to extract numbers from a string.

Disable Indexes with SQL

Language: SQL, Level: Intermediate: - Learn how to disable an index, temporarily or otherwise, with this T-SQL Query.

Purging Binary Logs in MySQL

Language: SQL, Expertise: Intermediate - Stay out of trouble regarding reaching maximum disk space by purging old logs in MySQL when they are no longer needed.

The sp rename SQL Stored Procedure

Language: SQL, Level: Intermediate: - See how to use the sp_rename stored procedure if you do not want to drop and recreate the table again.

Understanding Null Values Returned in MySQL

Language: MySQL, Beginner: Intermediate - Learn why the null value often needs special attention in your code to work effectively.

Pass Comma Separated Values as a Parameter to an SQL Stored Procedure

Language: SQL, Expertise: Intermediate - There will be times when you need to pass a list of values as a singular parameter to an SQL Stored Procedure. Problem is: SQL doesn't support this. See how to get around this issue.

Limiting the Rows Returned in MySQL

Language: SQL, Expertise: Intermediate - In MySQL, LIMIT is a feature that helps fetch a certain number of records matching the criteria provided.

Using the SQL FORMAT Function

Language: SQL, Expertise: Intermediate - Learn how to easily format how a field should be displayed.

Using BETWEEN in MySQL Queries

Language: SQL, Expertise: Intermediate - See how to filter a column based on dates and time using BETWEEN.

Create and Schedule an SQL Job

Language: SQL, Expertise: Intermediate - Sometimes you want a certain query, or Stored Procedure to be repeated on a daily, weekly or monthly basis. Learn to create an SQL Job and schedule it.

Making a Column Autoincrement the Value Itself in MySQL

Language: SQL, Expertise: Intermediate - Learn how to make a column auto-increment the value every time a record is inserted in that table.

Check if a Primary Key Exists on a Table

Language: SQL, Expertise: Intermediate - Learn how to check whether a Primary Key is missing, and if so, add it.

Updating a Column with the Current Time Stamp in MySQL

Language: SQL, Expertise: Intermediate Learn how to add the current time from the database when updating a column.

Identifying Unused Tables with T-SQL

Language: SQL, Expertise: Intermediate - Learn how to easily identify unused Tables.

Identify Tables with Large Column Counts

Language: SQL, Expertise: Intermediate - Check out this simple way to identify tables with a large number of columns.

Find Out the Column Name Using the COL_NAME() Function

Language: SQL, Expertise: Intermediate - Use this code snippet to quickly find out a column's name.

All Computer Programming Related Books

2004-2009 info4PHP.com All rights Reserved. Privacy Policy