Category: DB

How to Create a database in MySQL

A database is a container that holds all your tables. A table is a container for a subset of your data. A table holds...

Quickly Exploring MySQL in 7 commands

In this article, we’ll be quickly exploring MySQL. The DBMS doesn’t contain any user databases as you’ll shortly observe. Follow the steps below for...

What is the history of MySQL with 3 layers ?

MySQL history SQL stands for Structured Query Language but was initially conceptualized as SEQUEL Structured English Query Language. The name was changed from SEQUEL to...

What’s the difference between a Relational vs Non-Relational database?

In this article we are going to understand between Relational vs Non-Relational database Evolution of Storage Technologies There is a plethora of terms and jargon that...
[tds_leads title_text=”SUBSCRIBE TODAY” btn_horiz_align=”content-horiz-center” pp_checkbox=”yes” pp_msg=”SSUyMGhhdmUlMjByZWFkJTIwYW5kJTIwYWNjZXB0ZWQlMjB0aGUlMjAlM0NhJTIwaHJlZiUzRCUyMiUyMyUyMiUzRVRlcm1zJTIwb2YlMjBVc2UlM0MlMkZhJTNFJTIwYW5kJTIwJTNDYSUyMGhyZWYlM0QlMjIlMjMlMjIlM0VQcml2YWN5JTIwUG9saWN5JTNDJTJGYSUzRSUyMG9mJTIwdGhlJTIwd2Vic2l0ZSUyMGFuZCUyMGNvbXBhbnku” f_title_font_family=”901″ f_msg_font_family=”901″ f_input_font_family=”901″ f_btn_font_family=”901″ f_pp_font_family=”901″ msg_composer=”error” display=”column” input_placeholder=”Email Address” msg_succ_radius=”0″ msg_err_radius=”0″ f_title_font_size=”eyJhbGwiOiIyMiIsImxhbmRzY2FwZSI6IjE4IiwicG9ydHJhaXQiOiIxNiJ9″ f_title_font_line_height=”1.4″ f_title_font_transform=”” f_title_font_weight=”600″ f_title_font_spacing=”1″ tdc_css=”eyJhbGwiOnsibWFyZ2luLWJvdHRvbSI6IjIwIiwiYm9yZGVyLXRvcC13aWR0aCI6IjEiLCJib3JkZXItcmlnaHQtd2lkdGgiOiIxIiwiYm9yZGVyLWJvdHRvbS13aWR0aCI6IjEiLCJib3JkZXItbGVmdC13aWR0aCI6IjEiLCJwYWRkaW5nLXRvcCI6IjQwIiwicGFkZGluZy1yaWdodCI6IjMwIiwicGFkZGluZy1ib3R0b20iOiI0MCIsInBhZGRpbmctbGVmdCI6IjMwIiwiYm9yZGVyLWNvbG9yIjoidmFyKC0ta2F0dG1hci10ZXh0LWFjY2VudCkiLCJiYWNrZ3JvdW5kLWNvbG9yIjoidmFyKC0ta2F0dG1hci1hY2NlbnQpIiwiZGlzcGxheSI6IiJ9LCJsYW5kc2NhcGUiOnsiZGlzcGxheSI6IiJ9LCJsYW5kc2NhcGVfbWF4X3dpZHRoIjoxMTQwLCJsYW5kc2NhcGVfbWluX3dpZHRoIjoxMDE5LCJwb3J0cmFpdCI6eyJwYWRkaW5nLXRvcCI6IjI1IiwicGFkZGluZy1yaWdodCI6IjE1IiwicGFkZGluZy1ib3R0b20iOiIyNSIsInBhZGRpbmctbGVmdCI6IjE1IiwiZGlzcGxheSI6IiJ9LCJwb3J0cmFpdF9tYXhfd2lkdGgiOjEwMTgsInBvcnRyYWl0X21pbl93aWR0aCI6NzY4fQ==” title_color=”var(–kattmar-text)” msg_succ_color=”var(–accent-color)” msg_succ_bg=”var(–kattmar-secondary)” msg_pos=”form” msg_space=”10px 0 0 0″ msg_padd=”5px 10px” msg_err_bg=”#ff7c7c” msg_error_color=”var(–accent-color)” f_msg_font_transform=”uppercase” f_msg_font_spacing=”1″ f_msg_font_weight=”600″ f_msg_font_size=”10″ f_msg_font_line_height=”1.2″ gap=”20″ f_btn_font_size=”eyJhbGwiOiIxNiIsImxhbmRzY2FwZSI6IjE0IiwicG9ydHJhaXQiOiIxMiJ9″ f_btn_font_weight=”400″ f_btn_font_transform=”uppercase” f_btn_font_spacing=”2″ btn_color=”var(–accent-color)” btn_bg=”var(–kattmar-secondary)” btn_bg_h=”var(–kattmar-primary)” btn_color_h=”var(–accent-color)” pp_check_square=”var(–kattmar-secondary)” pp_check_border_color=”var(–kattmar-primary)” pp_check_border_color_c=”var(–kattmar-secondary)” pp_check_bg=”var(–accent-color)” pp_check_bg_c=”var(–accent-color)” pp_check_color=”var(–kattmar-text-accent)” pp_check_color_a=”var(–kattmar-primary)” pp_check_color_a_h=”var(–kattmar-secondary)” f_pp_font_size=”12″ f_pp_font_line_height=”1.4″ input_color=”var(–kattmar-text)” input_place_color=”var(–kattmar-text-accent)” input_bg_f=”var(–accent-color)” input_bg=”var(–accent-color)” input_border_color=”var(–kattmar-text-accent)” input_border_color_f=”var(–kattmar-secondary)” f_input_font_size=”14″ f_input_font_line_height=”1.4″ input_border=”1px” input_padd=”10px 15px” btn_padd=”eyJhbGwiOiIxMHB4IiwibGFuZHNjYXBlIjoiMTBweCAxMHB4IDhweCJ9″]

What are Triggers?

EXPLAIN plan in SQL

How to use TRUNCATE for MYSQL