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

Object Explorer Details

Language: SQL, Expertise: Beginner - See how to use the Object Explorer feature in SQL to find a particular stored procedure from a long list of available options.

Locking a User Account in MySQL

Language: SQL, Expertise: Intermediate - MySQL provides a mechanism to alter the user properties, thereby allowing you to lock the user account.

Using Multi Edit Mode

Language: SQL, Expertise: Beginner - When dealing with large lists of information, we, as developers, sometimes need to copy them, then add commas manually. See a neat trick to automatically add the required commas.

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.

Set Up a Database Dialect in Spring Boot

Language: Java, Expertise: Intermediate - Learn how to use the spring.jpa.properties.hibernate.dialect property to set the database dialect in Spring Boot.

Using MICROSECOND in MySQL

Language: SQL, Expertise: Intermediate - Developers often work with time in terms of hours, minutes and seconds. Learn how to break it down to the microsecond level.

3 More Hints for Building Faster SQL Queries

Language: SQL, Expertise: Beginner - Follow these three tips to help improve your SQL query performance.

Finding the Current Quarter in MySQL

Language: SQL, Expertise: Intermediate - Learn how to use MySQL to find the current financial quarter.

Using ENUM to Pre-define Column Values in MySQL

Language: SQL, Expertise: Intermediate - Learn how the values for a particular column can be pre-defined during the table definition. These values will be validated when the records are inserted or updated in the table.

Creating an SQL Query that Generates Dynamic LIKE Statements

Language: SQL, Expertise: Intermediate - See how to construct a query that can generate dynamic LIKE statements in SQL.

Converting UNIX_TIMESTAMP to Readable Format in MySQL

Language: SQL, Expertise: Intermediate - Learn more about a quick and neat way of converting the current time from Unix format to Readable format.

3 Hints for Achieving Faster SQL Queries

Language: SQL, Expertise: Beginner - Follow these three tips to help increase the performance of your SQL queries.

Understanding TOP WITH TIES in SQL

Language: SQL, Expertise: Intermediate - See what the Top with Ties clause actually does in SQL>

Difference Between RANK, DENSE_RANK and ROW_NUMBER SQL Statements

Language: SQL, Expertise: Intermediate - Learn more about how to use three very different SQL statements.

Three Levels of Data Abstraction in SQL

Language: SQL, Expertise: Beginner - Learn more about the levels of data abstraction employed in SQL to hide irrelevant details from users.

Delete Data Safely with SQL

Language: SQL, Expertise: Intermediate - Explore to how to safely delete data in SQL.

Name All of the Normalization Forms in SQL

Language: Java, Expertise: Beginner - Explore a list of the names of all normalization forms in SQL.

Discovering the Reason for Poor Query Performance

Language: SQL, Expertise: Beginner - Explore some of the reasons why your query performance might not by up to expected speeds.

Types of Indexes that Exist in SQL

Language: SQL, Expertise: Beginner - Get an overview of the index types available in SQL.

Getting the Last ID in MySQL

Language: SQL Expertise: Intermediate - Explore how MySQL supports AUTO_INCREMENT column types when many instances require the last value that was inserted to be used in reporting.

Understand the AES Encryption Method

Learn how to understand the AES ENCRYPTION method that is supported by MySQL.

Using the WEEKOFYEAR Function in MySQL

Language: SQL, Expertise: Intermediate - Learn how to use calendar functionality in MySQL to figure out in which week a given date belongs.

T-SQL Performance Tip: Stored Procedure Names

Language: SQL, Expertise: Beginner - See why you should avoid prefixing your Stored Procedure names with sp_.

T-SQL Performance Tip: NOT IN vs NOT EXISTS

Language: SQL, Expertise: Beginner - Learn the difference between using not in and not exists in T-SQL.

Use MySQL for Calculations

Language: SQL, Expertise: Intermediate - See a few different ways to use MySQL to compute the result of a mathematical formula.

All Computer Programming Related Books

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