Category archives: sql

MYSQL TIMESTAMP

subhbwn
68 days ago

Function
mysql
timestamp

PreviousNext

Detail discussion of MySQL timestamp. Will help you to understand MySQL TimeTamp efficiently.

Tweet Share

SQL select with distinct on multiple columns

subhbwn
137 days ago

SQL select with distinct on multiple column
SQL tutorial

PreviousNext

Multiple fields may also be added with DISTINCT clause. DISTINCT will eliminate those rows where all the selected fields are identical.

Tweet Share

Sql cross join

subhbwn
137 days ago

Sql cross join
SQL tutorial

PreviousNext

The SQL CROSS JOIN produces a result set which is the number of rows in the first table multiplied by the number of rows in the second table, if no WHERE clause is used along with CROSS JOIN. This kind of result is called as Cartesian Product.

Tweet Share

Sql natural join

subhbwn
137 days ago

sql natural join
SQL tutorial

PreviousNext

A NATURAL JOIN compares all columns of two tables which have the same column-name and the resulting joined table contains those columns once which are same in name in both of the tables.

Tweet Share

Sql full outer join

subhbwn
137 days ago

full outer join
SQL tutorial

PreviousNext

The FULL OUTER JOIN will return all rows, as long as there’s matching data in one of the tables. It includes all the rows from both the participating tables and does not select either the LEFT or RIGHT table from the JOIN key word.

Tweet Share

MySQL Function & Operators

subhbwn
324 days ago

PreviousNext

* 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

Tweet Share

MySQL Tutorials

subhbwn
328 days ago

MySQL Tutorials

PreviousNext

After reading this largest third party online MySQL tutorial by w3resource, you will be able to install, manage and develop PHP-MySQL web applications by your own.

Tweet Share

w3resource SQL tutorials

subhbwn
328 days ago

SQL tutorials
w3resource

PreviousNext

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 [...]

Tweet Share

Insert HINDI Font from ASP.NET web page to SQL Server database

learndo
346 days ago

asp.net
hindi font
insert
sql server

PreviousNext

We are In many sites to save HINDI data in SQL data base. But is too difficult to insert HINDI font in data base.

Tweet Share

Best Way to Write SQL Query

iFadey
454 days ago

clause
database
mssql
mysql
oracle
query
sql

PreviousNext

You will learn how to write complex SQL queries by dividing the problem (result you want to acheive) and in which order you must think and write SQL clauses to simply your task. This tutorial will not explain working of SQL clauses. I assume you understand working of all SQL clauses.

Tweet Share

Microsoft Windows Azure Developer

Samanth
469 days ago

microsoft windows developer
windows azure developer
windows azure development

PreviousNext

Windows azure development kit and download windows azure tools for microsoft visual studio are required for getting started with windows azure development download it here http://msdn.microsoft.com/en-us/windowsazure/default.aspx

Tweet Share

Top 20+ MySQL Best Practices

yadiros
577 days ago

mysql
sql
tutorials

PreviousNext

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.

Tweet Share

Stored Procedure Lesson

idhyr
583 days ago

sql
Stored Procedure
tutorial

PreviousNext

Are you writing Stored Procedures if not please take a look at this post. Stored procedures can help to improve web application performance and reduce database access traffic. In this post I want to explain how to create and call the stored procedures from database server.

Tweet Share

How to Convert a column of the table into Comma separated string

yadiros
616 days ago

sql
sql server
tutorial

PreviousNext

There are many ways to do this in SQL Server,Here i will show you the one of the way to Convert a column of the table into Comma separated string using FOR XML PATH in query.

Tweet Share

10 Essential SQL Tips for Developers

yadiros
623 days ago

Developers
mysql
oracle
sql server

PreviousNext

SQL is yet another essential language for developers wishing to create data-driven websites. However, many developers are unfamiliar with various aspects of SQL; so in this article, we’ll analyze ten essential tips.

Tweet Share