[ILUG] GUI client for MySQL. kind of OT

[Dave Burke]

On Mon, 29 May 2000, It appears adam beecher said.......

> > I've been using Webadmin. Which until now has been great.
> > I'm no SQL chap, so creating and removing Databases is easy with Webadmin.
> > But can someone tell me how to remove data from a database with out dropping
> > the whole table.
> >
> DELETE FROM table; ??? Hmmm, that didn't work, although it did on an older
> version of MySQL. I'll have to look into this...

That _should_ work ok. If it doesn't try "delete from database.table_name"

I'm using 3.22.32 (latest stable) and seems to work ok for me........


mysql> insert into testing values ( 5.00 );
Query OK, 1 row affected (0.00 sec)

mysql> select * from testing
    -> go
+------+
| blah |
+------+
| 5.00 |
+------+
1 row in set (0.00 sec)

mysql> delete from testing	
    -> go
Query OK, 0 rows affected (0.00 sec)

mysql> select * from testing
    -> go
Empty set (0.00 sec)

mysql> status
--------------
/usr/local/mysql//bin/mysql  Ver 9.38 Distrib 3.22.32, for pc-linux-gnu
(i686)