MySQL Archive
22 Jul 2023
Triggers in MySQL
Triggers are powerful and versatile tools that enable database administrators and developers to automate actions based on specific events or changes in the database. They act as stored programs, invoked automatically when a predefined condition occurs, such as data insertion, deletion, or modification. This blog explores the concept of triggers in MySQL, their benefits, and
10 Jul 2023
Power of MySQL CASE Statement
MySQL stands tall as a popular choice due to its efficiency and versatility. One key feature that sets MySQL apart is the CASE statement, which enables developers to implement conditional logic within their queries. This powerful tool empowers programmers to perform dynamic transformations and make data-driven decisions based on specific conditions. Let’s explore the intricacies
01 Apr 2023
Import large database in MySql
To import the large database in MySql, Below are the changes required in MySql my.ini (Configuration file): Step 1: Stop the MySQL server from your control panel. Step 2: Open the file C:\xampp\mysql\bin\my.ini Search and Change the below lines (setting): innodb_buffer_pool_size=4G innodb_log_file_size=2GB innodb_log_buffer_size=256M innodb_flush_log_at_trx_commit=0 innodb_lock_wait_timeout=500 innodb_strict_mode=0 Step 3: Start the MySQL server from your control
05 Oct 2014
Day 14: Submit form without submit button
Sometime it’s require to submit the form on server without submit button, like on dropdown change. So this can be done with the help of JavaScript. I am taking “tbstudent” table, that we have created on “day12”. Program 41: Submit form through JavaScript <?php $con = mysql_connect(“localhost”,”root”,””); mysql_select_db(“mydb”,$con); if(isset($_REQUEST[‘drpEmp’])) { $selectedId = $_REQUEST[‘drpEmp’]; $query =
20 Sep 2014
Day 13: Form validation client and server side.
Is it better to validate form of our website both client and server side. Both have their own advantages. In client side validation we use JavaScript so it’s faster than the server side validation but sometimes when JavaScript disabled on browser then JavaScript doesn’t work then server side validation will work. Create below mentioned table
07 Sep 2014
Day 12: Handling Multiple Tables In PHP With MySql Join
Note : In this assignment, I am taking the same database (mydb) that we was created in Day9, but create below new tables for this assignment and add some records in all three table i.e. tbcity, tbcourse and tbstudent. create table tbcity (id int primary key auto_increment, name varchar(50)) create table tbcourse(id int primary key
30 Aug 2014
Day 11: Data Manipulation With PHP
We have done database connectivity in Day 9, now we will manipulate data in database (i.e. insert, edit, update and delete) with PHP. To manipulate the data I have created more than 1 PHP files, So take a separate folder (I am taking Day11) to put all those below mentioned files. Note : In this
17 Aug 2014
Day 9: Database connectivity in PHP
Database is used to store information. In PHP we are using MySql as database server. Below are the steps to use MySql server with PHP: Step 1 : Start MySql from your xampp panel. Step 2 : Open “http://localhost/phpmyadmin/” in browser. Step 3 : Create new database in your localhost server (let’s take database name
07 Dec 2013
Get Last Inserted Id
There are many cases where we need AUTO_INCREMENT ID that generated from the previous INSERT operation, we can get that by using mysql_insert_id() function. Like:- $con = mysql_connect(“localhost”, “root”, “”); mysql_select_db(“my_database”,$con); $query = ”insert into emp (name,salary,phone) values (‘amit’,9000,’9847476744’)”; mysql_query($query); echo “Last inserted id is ”. mysql_insert_id(); Some time programmer use “select max(id) from tablename”
17 Nov 2013
Fetch Duplicate Records
following is the query through which we can fetch duplicate records in our table, let’s take a example of emp table:- “SELECT name FROM emp GROUP BY name HAVING COUNT(name) > 1” we will get duplicate names from emp table.