Question: MySQL &PHP



Share on Google+Share on Google+

1 Answer(s)      8 years ago
Posted in : WebSevices
View Answers

May 13, 2009 at 9:58 AM

Hi Friend,

To remove duplicate rows from the table,you can use either of the two approaches in the script. Here we are going to remove rows have same id i.e 1.

CREATE TABLE backup_table AS
RENAME TABLE backup_table TO users;



In the First approach, we have written three manual steps to create the new backup table with unique entries then we will remove the older table and at last we will rename the backup table with the same name of the older table that we have deleted. Here users is older table name.

In Second Approach, we have added unique index for id.



Related Tutorials/Questions & Answers:
php mysql
php mysql  automatically insert a value in the month field at the last date of current month in mysql database
php mysql
php mysql  automatically insert a value in the month field at the last date of current month in mysql database
why php and mysql - PHP
why php and mysql  I noticed in most of the application that developer always use mysql with PHP. Why they do so,, as there are money other database are too available
Upgrading a PHP/MYSQL application?
Upgrading a PHP/MYSQL application?  Upgrading a PHP/MYSQL application
secure php mysql connection
secure php mysql connection  secure php mysql connection script
MySql PHP Connection String - PHP
MySql PHP Connection String  i need a MySql PHP Connection String, is it possible to do pooling in between
enum php mysql
enum php mysql  How to use mysql enum in php
php form post to mysql
php form post to mysql  How to post data into mysql database from the PHP post data form
ide php mysql
ide php mysql  what is ide for php and mysql   Hi, You can use Eclipse to develop your PHP project. The easist way is to download the Eclipse having PHP support from eclipse download site. The Eclipse PHP plugin
Mysql-Php code
Mysql-Php code  I want to mysql script for query data from two tables in the mysql database trough php code. Can you help me   Hi Friend, Please visit the following link: Php Mysql Thanks   Hi Friend
PHP MySQL query
PHP MySQL query  I have 11 tables and have to do the CRUD operations keeping userid as a reference key
php inserting date into mysql
php inserting date into mysql  php inserting date into mysql   Here is a php code that inserts date into mysql database. In the given code, data is a database table. <?php table $query_manual = "INSERT INTO data
PHP mysql database backup script - PHP
PHP mysql database backup script  How can i get the database backup using PHP mysql database
PHP MYSQL Interview Questions
PHP MYSQL Interview Questions  What kind of questions can be asked in an PHP, MYSQL interview? Can anyone post the PHP interviews questions with well explained answers?   PHP, MYSQL Interview Questions Please tell me
drop down php mysql - PHP
drop down php mysql  PHP Script required to show the similar drop down item in each menu without refreshing the page. Is it possible if yes how
Import MYSQL file in PHP - PHP
Import MYSQL file in PHP  i wanted to import the mysql file in PHP5 on button click. is it possible to do it? Is there any possibility of data security
connection of php to MySQL.
connection of php to MySQL.  I have a query on connection of php to MySQL. Website's serverspace by godaddy and provides phpmyadmin(interface of MySQL) for Database I have a page admin.php <?php if (isset($_POST
login page php mysql example
login page php mysql example  How to create a login page for user in PHP Mysql? Please provide me a complete tutorial. Thanks in Advance
php mysql fetch array example
php mysql fetch array example  How to fetch data from mysql and store it into an array in PHP? Please post an example. Thanks in Advance
php mysql web application tutorial
php mysql web application tutorial  How to create a simple php mysql web application? Please post an example or tutorial
MySQL &PHP - WebSevices
MySQL &PHP  Hello, I have write a script to read from a file and than store the values to a mysql. My problem is when I am storing this values in mysql the 1st column is taking 0 value and after this it is storing
what is the mysql in the database using php
what is the mysql in the database using php  what is the mysql in the database using php  Please visit the following link: PHP Database
what is the mysql in the database using php
what is the mysql in the database using php  what is the mysql in the database using php  Please visit the following link: PHP Database
MySQL &PHP - WebSevices
MySQL &PHP  Hello, How can I remove duplicate rows from table using php&mysql. If any one having a script for this it will be more helpfull for reference. Thanks in Advance Warm Regards Mujtaba  Hi Friend
return all rows mysql php
return all rows mysql php  How to find or return results that are not available in another table .. using join method in PHP and MYSql.   SELECT * FROM Declined LEFT JOIN Request ON Declined.RequestID
Charset problem upon publishing PHP + MySQL website
Charset problem upon publishing PHP + MySQL website  Charset problem upon publishing PHP + MySQL website
how to post data in mysql php form
how to post data in mysql php form  how to post data in mysql php form
Mysql PHP Select
Mysql PHP Select       Mysql PHP is used to execute the select statement using mysql_query.... Understand with Example The Tutorial illustrate an example from 'Mysql PHP Select
PHP MySQL Introduction
PHP/MYSQL INTRODUCTION TUTORIAL Part - 1 : Introduction  The combination of both PHP and MySQL are used to develop or create dynamic and interactive website.  MySQL is supported, distributed and developed by MySQL AB. 
PHP MySQL on Centos 5.x
PHP MySQL on Centos 5.x This Tutorial show you how to install MySQL support... MySQL support into your php application. In this tutorial I will show you how you can install MySQL support and install using MySQL database from your php
PHP Chat Systems A MySQL Driven
PHP Chat Systems A MySQL Driven Chat Script Tutorial This article will show you how to create a simple chat script using PHP and MySQL database...; <?php $link=mysql_connect("localhost","root","
Java Spring Hibernate Struts Training 6 SaaS Software Solutions Every Business Owner Should Consider WebServices Study Material What is the use of MySQL, MS SQL in Web Hosting paradigm? What do you understand by Domain Parking? What is difference between UNIX Hosting and Window Hosting? Expalin the Web Hosting Bandwidth/Space/Transfer What do you understand by Virtual Hosting? How to Upload Site Online? How to register domain name for my Company? How to track how many hits my website gets? create plugins to detect suspicious ajax chrome extension what timing attack {practically}??? any one can help me in my Ph.d thesis Accessing your site How to develope web service with exachanging xml message between computers using SOAP How to Convert SOAP Web service to REST Web service In Java ? add a new wcf service code to TFS and make it available to create an MSI. of its How we can integrate ASP .net website to payment gateway using SOAP xml request and response using wsdl. input fields to reject all inconsistent characters in webconfig Search operation in JSP page Where can I find reviews of IT solutions company in India to choose from? help regarding creation of last year project Select Box question Web Services Tutorials What is SOA and Webservices? PHP webdesign Pinting restful webservice request on UI. MaxClients apache httpd.conf max connections Large File reading through Axis2 Web service reg tutorial What is Web Development? Get GMT from IP WEB SERVICES Create a Web Service in Java using Apache Axis2 and Eclipse with Oracle database driven local host sharing on same network compute Internet and Web related questions for Web Master. web technology What is webservices? wifi problem wifi problem Overriding jaxb binding at client side? How to connect one application to some othe application through Rest json Database with dotnet while playing youtube in iphone appliation, coming black screen in iphone project? programming questions Web Analytics Java Runtime Exception: 0x4F4F:524A 0x4120:5445 0x4348:0D0A Restful webservice


Advertisement null