Category archives: sql

 

 

 

 

 

 

 

0

MySQL Function & Operators

* Introduction of Mysql functions and operators * Mysql Comparison Functions and Operators * Mysql Logical Operators * Mysql Control Flow Functions * Mysql String Functions * Mysql Mathematical Functions * Mysql Date and Time Functions * Mysql Encryption and Compression Functions * Mysql Bit Functions

 

 

0

w3resource SQL tutorials

In w3resource SQL tutorials, we have covered SQL 2003 Standard in detail. Following is a list of the features we have included in our tutorials : 1. A simple but thorough description. 2. SQL Syntax. 3. Description of the Parameters used in the SQL command. 4. Sample table with data. 5. SQL command. 6. Explanation [...]

 

 

 

 

0

Top 20+ MySQL Best Practices

Database operations often tend to be the main bottleneck for most web applications today. It’s not only the DBA’s (database administrators) that have to worry about these performance issues. We as programmers need to do our part by structuring tables properly, writing optimized queries and better code. Here are some MySQL optimization techniques for programmers.