In this tutorial I am sharing the code how to delete duplicate entries from MySQL database based on a field_name.
Below SQL script creating table in a MYSQL database:
CREATE TABLE IF NOT EXISTS `product` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`item_code` varchar(255) NOT NULL,
`cat_id` int [...]
Tag: MySQL
MySQL the most popular Open Source SQL database management system, is developed, distributed, and supported by MySQL AB(now acquired by Oracle).MySQL is a multi-threaded, multi-user SQL database management system and MySQL is written in C and C++ and its SQL parser is written in yacc.
Question 1: What are the technical features of MySQL?
[...]
XAMPP server is the most popular PHP development environment. XAMPP server stands for cross-platform, Apache, MySQL, PHP and Perl. It is a simple and lightweight solution that allows you to create a local web server.
1. Downloading XAMPP Server
First download the installer file for the latest version of XAMPP Server, and save the file to [...]
WampServer is a local server package for Windows web development environment. It allows you to create dynamic web applications with Apache2, PHP and a MySQL database. PhpMyAdmin allows you to manage easily your databases. download link : WampServer
1. Downloading WampServer
First download the installer .exe file for the latest version of [...]
LAMP (Linux, Apache, MySQL, PHP) is an open source Web development platform that uses Linux, Apache as the Web server, MySQL as the relational database management system and PHP as the object-oriented scripting language.
Linux: Linux is a operating system assembled under the model of free and open source software development.
Apache: [...]