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

Renaming a User in MySQL

Language: SQL, Expertise: Intermediate - Learn how to change a user name in MySQL, as requirements may be updated along the development process.

Explore a Few Math Functions in SQL Server

Language: SQL, Expertise: Beginner - See several math functions that can be used in T-SQL.

Setting Up a PROXY User in MySQL

Language: SQL, Expertise: Intermediate - See how to set up a proxy user that has the same permissions as the original user.

Disabling Binary Logs in MySQL

Language: SQL, Expertise: Intermediate - Sometimes there are just too many logs available to sift through efficiently. Learn how to disable the binary logs in MySQL to cut down on the clutter.

Using LOCK_TIMEOUT in SQL

Language: SQL, Expertise: Beginner - See how to specify how long a statement should wait for a lock to be released.

How to Change the Storage Engine in MySQL

Language: SQL, Expertise: Intermediate - Learn how to change the storage engine used in MySQL to improve application performance.

Using NUMERIC_ROUNDABORT in T-SQL

Language: SQL, Expertise: Beginner - Learn how to specify the level of error reporting that has been generated when an expression being rounded has caused loss of precision.

Get All the Tables with a Count of Their Records

Language: SQL, Expertise: Intermediate - Use this query to get all the tables with a count of their records.

Understanding What Grants a User Has in MySQL

Language: SQL, Expertise: Intermediate - Learn how to view what permissions a given user has been granted.

Reseed All Autonumber Fields in All Tables

Language: SQL, Expertise: Beginner - Learn more about a query that will allow you to reseed all auto-numbered fields.

Using the Locate Command in MySQL

Language: MySQL, Expertise: Intermediate - Finding a particular string in a large data set can be extremely tedious. Fortunately, MySQL has a command called locate to help you find what you need.

Get the First Day of the Current Month

Language: SQL, Expertise: Beginner - Learn how to find the first date of the current month.

Adjusting Views to Reduce Visibility of Data in MySQL

Language: MySQL, Expertise: Intermediate - See how to make it so that tables with sensitive information are not viewable by all.

Get All Columns in All Tables of a Specific Data Type

Language: SQL, Expertise: Beginner - See how to find a specific data type across all tables and columns in a database.

How to Use the Show ProcessList in MySQL

Language: SQL, Expertise: Intermediate - Learn how to list all of the processes that hold a valid connection to the database.

Get the Last Day of the Current Month

Language: SQL, Expertise: Beginner - Use this easy query to discover the last day of the current month.

Get Current Precision Level Used by Numbers in SQL Server

Language: SQL, Expertise: Intermediate - See how to get the current precision by executing the following command.

Rebuild All Database Indexes

Language: SQL, Expertise: Intermediate - See how to rebuild all of the indexes in your database with this query.

Get Current Language of SQL Server

Language: SQL, Expertise: Beginner - Learn an easy query to get the current language in SQL Server.

Recompile a Stored Procedure

Language: SQL, Expertise: Intermediate - Learn how to recompile certain stored procedures.

Using Find_in_Set in MySQL

Language: SQL, Expertise: Intermediate - Learn how to search for, or look up, a given string.

RESEED Identity Columns of All Tables

Language: SQL, Expertise: Beginner - See how to loop through all the tables and execute the DBCC CHECKIDENTcommand.

Working with the IIF Statement in T-SQL

Language: SQL, Expertise: Beginner - See how to quickly check for certain conditions.

Using the Insert on Duplicate Key Update in MySQL

Language: SQL, Expertise: Intermediate - Learn more about the insert on duplicate key update and how to use it in MySQL.

Resize Your TempDB in SQL

Language: SQL, Expertise: Intermediate - Learn how to resize the tempdb temporary database in SQL.

All Computer Programming Related Books

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