Category: MySQL

MySQL Inner outer left right join

Types of JOINs Types Description Inner JOIN This type of JOIN is the most common type. It is used to get the intersected set of data from the tables based on the JOIN condition....

MySQL SHOW GRANTS VARIABLES TABLES DATABASES

SHOW GRANTS FOR SHOW STATUS SHOW VARIABLES SHOW DATABASES SHOW TABLES   SHOW GRANTS FOR This command is used to display user privileges. For that, we need to specify our username and host to...

MySQL Left Join Example

I take the two tables tbl_links and tbl_tags to explain how the Left JOIN works. The tbl_links table has a tag_id column to map a tag with a link data. Similarly, the tbl_tags has...

MySQL Right JOIN Example

MySQL LEFT keyword as RIGHT as shown below. $query = “SELECT students.student_name, students.student_email, users.user_type FROM students RIGHT JOIN users ON (students.student_id = users.user_id)”; By executing this query, then it keeps the right table rows...

MySQL supported Data Types

MySQL supported data types that are huge in number, falls into the three main categories. These are, Numeric Data Type String Data Type Date and Time Data Type Numeric Data Type On creating MySQL...

MySQL Current Date Time Timestamp

Getting current Date/Time/Timestamp. MySQL Date/Time formatting. Date/Time/Timestamp arithmetic operations. Converting MySQL Date/Time/Timezone. Extracting date from MySQL Temporal Data. For performing the above operations, MySQL functions required to specify Date/Time types as DATE, DATETIME, and...

MySQL OrderBy Sorting

MySQL orderby clause is used to order results based on a column. Orderby clause is used in select queries to do sort by specifying the column order (asc, desc). If no order is given,...

MySQL CONCAT Functions

MySQL Concatenation Functions These functions are listed below followed by their detailed description. CONCAT() – This will concatenate given a list of string together, continuously, without any separator. CONCAT_WS() – Unlike MySQL CONCAT(), this function will...

PHP MySQL vs MySQLi Difference

MySQL MySQLi Difference There are too many differences between these PHP database extensions. These differences are based on some factors like performance, library functions, features, benefits, and others. MySQL MySQLi MySQL extension added in...

Show Buttons
Hide Buttons
Social Media Auto Publish Powered By : XYZScripts.com