473,464 Members | 1,729 Online
Bytes | Software Development & Data Engineering Community
Create Post

Home Posts Topics Members FAQ

How to view dupicate data in mysql

1 New Member
Give the answer breifly
Jan 7 '11 #1
2 1211
code green
1,726 Recognized Expert Top Contributor
use
Expand|Select|Wrap|Line Numbers
  1. GROUP BY `field1` 
  2. HAVING (
  3. COUNT( `field2` ) >1)
Jan 7 '11 #2
AutumnsDecay
170 New Member
edit.

I misread everything on this page.. morning coffee time.
Jan 7 '11 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

2
by: Brett B | last post by:
I just installed mysql on linux. If I open a terminal, su to root, then type "mysql", I am able to connect to the server and run my queries. If I exit out of su so that I am my own id (baisley)...
2
by: Ringo Langly | last post by:
Hi everyone, I have 5 servers, all with identical databases just different data. I have a rather lengthy SQL statement (in a View) to hit one database and pull-in certain data, but I'd like to...
0
by: Tom Wild | last post by:
Hi I am trying to connect to an Access database from a WebPage in VB.Net but when I try to open the connection I get the following error: The Microsoft Jet database engine cannot open the file...
1
by: dimitri | last post by:
i try to copy data from excel into my MySql database which runs on a linux. i use MS Access to access the database. i need to optain the unique id number, and this is where i have some troubles....
2
by: Kynn Jones | last post by:
How can I query mysql to view the catalog? (By the catalog I mean the special internal database that holds the meta-information about all other databases in the system, including descriptions of...
2
by: vanz10 | last post by:
I everyone, i'm a bigenner when talking about php so that is why I'm asking someone who knows the code if how to view the data by using listbox
0
by: rupinder03 | last post by:
I want to create tree view in data grid in vb.net 2005.can anyone tell me hw to create it................its urgent.......plz reply soon..............
1
by: jamal8t2 | last post by:
<?php //$file_dir="/htdocs/upload"; // Connect to database $db_name1="test";// Database name $conn1=mysql_connect("localhost","","") or die("I Couldn't connect"); ...
2
by: D Biegert | last post by:
While in Forms View, a coworker inadvertantly selected Records/Data Entry and it set her form back at record #1 and erased all data from Form View. She still has access to the data in the Datasheet...
1
by: sajinb | last post by:
i have MDB file in a sepearte machine, i am accesing that MDB file from my machine through java program it gives no problem Connection con = DriverManager.getConnection(...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
1
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.