|
05-15-2005, 12:34 PM
|
#1 |
|
Junior Member
Join Date: May 2005
Posts: 1
|
Deleting rows of records in Navicat
I am new working in Navicat and SQL - How do I delete rows that are in a Navicat database? Thanks.
|
|
|
|
05-16-2005, 03:13 AM
|
#2 |
|
Member
Join Date: Feb 2005
Location: ANtwerp - Belgium
Posts: 34
|
Re: Deleting rows of records in Navicat
In your navicat, select a database and then go to "query".
Start a new query. This gives you a screen in which you can edit your SQL statements. Create a SELECT statement to see which rows are displayed. That way, you know for sure which rows you will delete. If the SELECT statement gives you the rows you really want to delete, change the "SELECT * " into "DELETE" and run the query. |
|
|
|
 |
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | Search this Thread |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Erasing duplicate records automatically | nadsab | Navicat Support | 1 | 02-25-2005 08:41 AM |
| Navicat (Windows) version 6.1.10 is now released | NavicatGuy | Announcements | 0 | 01-11-2005 11:55 PM |
| Navicat (Windows) version 6.1.9 is now released | NavicatGuy | Announcements | 0 | 12-17-2004 04:19 AM |
| How to SSH Tunnel to your Navicat Software | Administrator | Articles | 0 | 11-03-2004 02:36 PM |
| Import Access, Excel and data of other formats to MySQL by Navicat | NavicatGuy | Articles | 0 | 08-17-2004 01:08 AM |
