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

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.

Understanding sql_mode in MySQL

Language: SQL, Expertise: Intermediate - See how to use sql_mode to set values in MySQL.

Understanding FULLTEXT Searches

Language: SQL, Expertise: Intermediate - In MySQL, there is a provision to search based on natural mode. Follow this example to understand the process in detail.

Connect to a Database in Spring Boot

Language: Java, Expertise: Intermediate - See how to use application.properties to instruct Spring Boot to connect to a database.

Understanding MAX_USER_CONNECTIONS in MySQL

Language: SQL, Expertise: Intermediate - Learn how to restrict the number of connections made from a user to the database.

Using CAST for Explicit Conversion in MySQL

Language: SQL, Expertise: Intermediate - MySQL allows you to explicitly convert a number to a string with the help of CAST function. See an example of how to use this feature.

Using JSON as a Data Type

Language: SQL, Expertise: Intermediate - MySQL is a very robust database that supports JSON as a data type. See how to make this feature work for you.

Types of Engines that Are Supported in MySQL

Language: SQL, Expertise: Intermediate - See how to use the query in the example to display the list of available engines that are supported in MySQL.

Working with Multiple Query Windows

Language: SQL, Expertise: Beginner - Learn the best ways to work with multiple query windows in SQL.

Finding the TAN of a Given Number

Language: SQL, Expertise: Intermediate - MySQL provides numerous mathematical calculations that can be computed with inbuilt functions. Learn how to find the TAN of a number.

Using the SUBSTRING_INDEX in MySQL

Language: SQL, Expertise: Intermediate - See how to extract a part of the given string using the SUBSTRING_Index in MySQL.

Selecting All Columns, Separated with Commas

Language: SQL, Expertise: Beginner - See how to get a nicely comma-separated list of column names.

How to Pass Parameters in @Query

Language: Java, Expertise: Intermediate - Learn how to pass parameters to an SQL query written with @Query via @Param or positional parameters.

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.

All Computer Programming Related Books

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