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

Understanding Least and Greatest in MySQL

Language: SQL, Expertise: Intermediate: Explore the least and greatest functions in MySQL.

Recompile a Stored Procedure

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

Quickly Monitor Log Space in SQL Server

Language: Java, Expertise: Beginner: Learn how to easily monitor free space in your database log files.

Using DBCC SHRINKDATABASE

Language: SQL, Expertise: Intermediate: See how to easily shrink the size of the data and log files in a database.

Find Error Log Location

Language: SQL, Expertise: Intermediate: Learn an easy way to find where your error logs are being stored.

SQL Injection Tips, Part 3

Language: SQL, Expertise: Intermediate: SQL injection is probably the most common hacking technique out there. Learn more about hacking techniques to keep your data secure.

Understanding What Grants a User Has in MySQL

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

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.

Using Find_in_Set in MySQL

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

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.

Using AUTO_INCREMENT in MySQL

Language: SQL, Expertise: Intermediate - Learn how to set AUTO_INCREMENT values when they need to start from a number of your choice or as per some other criteria.

SQL Injection Tips, Part 2

Language: SQL, Expertise: Intermediate: Learn more about how to avoid issues with SQL injection.

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.

SQL Injection Tips, Part 1

Language: SQL, Expertise: Intermediate: Learn more about how to avoid SQL injection issues.

Finding the Current User in MySQL

Language: SQL, Expertise: Intermediate - Learn how MySQL provides a mechanism to find the current user.

Read All SQL Server Log Files

Language: SQL, Expertise: Intermediate - Learn a script that allows you to read through all SQL Server Log files.

Employing DROP USER in MySQL

Language: SQL, Expertise: Intermediate - Learn to how to properly use the drop user command in MySQL.

Using COMPRESS in MySQL

Language: SQL, Expertise: Intermediate: See how to easily encrypt text in MySQL with the compress method.

Understanding INSERT IGNORE in MySQL

Language: SQL, Expertise: Intermediate: MySQL supports something named IGNORE along with INSERT, which captures the error as a WARNING. See it in action.

Using the STRING_AGG SQL Server 2017 Function

Language: SQL, Expertise: Beginner: Learn how to perform grouped string concatenation.

Using REPEAT in MySQL

Language: SQL, Expertise: Intermediate: See how to repeat a particular string a defined number of times.

Understanding UNCOMPRESSED_LENGTH in MySQL

Language: SQL, Expertise: Intermediate: Learn how to get the compressed text results to be the exact length of the original text.

SQL Statistic Tests to Look Into

Language: SQL, Expertise: Beginner: Check out these six tests if you want to explore statistics in SQL.

How to Set hibernate.format_sql in a Spring Boot Application

Language: Java, Expertise: Intermediate: See how to format the SQL statements for a Spring Boot application.

All Computer Programming Related Books

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