Sql Len Function

SQL LEN Function

The LEN function returns the length of the value in a text field. Employees Table employeeID employeeName age 1000 John Smith 40 1001 Fred White 27 1002 Jane Scott 53 …

Mysql Datediff Function


The MySQL DATEDIFF function returns the difference in time between two dates. Syntax Example Results

Sql Truncate Table Statement

SQL TRUNCATE Table Statement

The SQL TRUNCATE statement can be used to delete rows from a table without deleting the table itself. Syntax

Mysql Now Function

MySQL NOW Function

The MySQL NOW function is used to display the current date and time. The equivalent function in Microsoft SQL Server is GETDATE. Syntax Example Results

Sql Where Clause

SQL Where Clause

The WHERE clause is used to filter records, generally in combination with the SELECT statement. The WHERE clause is used to request only those records that fulfill a specified query. …

Scroll to Top