Need Sql Query

**learner** · 12-07-08, 07:03

ok i need to know how delete structures inside table like ibwf_users i want to only clear users, in ibwf_theme i want to only delete theme how and what query to put in sql to do that?

**amylee** · 12-07-08, 07:20

what you want to delete the users table in ibwf_users and theme name in ibwf_theme? that makes no sense
delete users is allready in place

**learner** · 12-07-08, 07:25

i mean the users or say like i want delete all topics in ibwf_topics i want to make the sql clean something like this

Code:

--
-- Table structure for table `ibwf_users`
--

CREATE TABLE `ibwf_users` (
��`id` int(100) NOT NULL auto_increment,
��`name` varchar(30) NOT NULL default &#39;&#39;,
��`pass` varchar(60) NOT NULL default &#39;&#39;,
��`birthday` varchar(50) NOT NULL default &#39;&#39;,
��`sex` char(1) NOT NULL default &#39;&#39;,
��`location` varchar(100) NOT NULL default &#39;&#39;,
��`perm` char(1) NOT NULL default &#39;0&#39;,
��`posts` int(100) NOT NULL default &#39;0&#39;,
��`plusses` int(100) NOT NULL default &#39;700&#39;,
��`signature` varchar(100) NOT NULL default &#39;&#39;,
��`avatar` varchar(100) NOT NULL default &#39;&#39;,
��`email` varchar(50) NOT NULL default &#39;&#39;,
��`browserm` varchar(50) NOT NULL default &#39;&#39;,
��`ipadd` varchar(30) NOT NULL default &#39;&#39;,
��`lastact` int(100) NOT NULL default &#39;0&#39;,
��`regdate` int(100) NOT NULL default &#39;0&#39;,
��`chmsgs` int(100) NOT NULL default &#39;0&#39;,
��`chmood` int(100) NOT NULL default &#39;0&#39;,
��`shield` char(1) NOT NULL default &#39;0&#39;,
��`gplus` int(100) NOT NULL default &#39;700&#39;,
��`budmsg` varchar(100) NOT NULL default &#39;&#39;,
��`lastpnreas` varchar(100) NOT NULL default &#39;&#39;,
��`lastplreas` varchar(100) NOT NULL default &#39;&#39;,
��`shouts` int(100) NOT NULL default &#39;0&#39;,
��`pollid` int(100) NOT NULL default &#39;0&#39;,
��`rbcid` varchar(255) NOT NULL default &#39;&#39;,
��`hvia` char(1) NOT NULL default &#39;1&#39;,
��`lastvst` int(100) NOT NULL default &#39;0&#39;,
��`battlep` int(100) NOT NULL default &#39;700&#39;,
��`popmsg` char(1) NOT NULL default &#39;1&#39;,
��`automsgs` char(1) NOT NULL default &#39;1&#39;,
��`validated` char(1) NOT NULL default &#39;0&#39;,
��`theme` varchar(100) NOT NULL default &#39;white_medium.css&#39;,
��`hidden` char(1) NOT NULL default &#39;0&#39;,
��`quiz_score` varchar(20) NOT NULL default &#39;0&#39;,
��`quiz_easy` char(3) NOT NULL default &#39;no&#39;,
��`quiz_medium` char(3) NOT NULL default &#39;no&#39;,
��`quiz_hard` char(3) NOT NULL default &#39;no&#39;,
��`total_score` varchar(10) NOT NULL default &#39;0&#39;,
��PRIMARY KEY��(`id`),
��UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM��DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;

--
-- Dumping data for table `ibwf_users`
--

see? no users its clean now i want to make it new again again put site up and start all over again?

**laro696** · 12-07-08, 11:19

Just empty the tables...

**learner** · 12-07-08, 11:50

but how with command? with hand too much time

**laro696** · 12-07-08, 12:01

but how with command? with hand too much time

[/b]

In phpmyadmin, just select the little blocks next to all the tables that you want to empty, and click empty
5 minutes max

**Anshul** · 12-07-08, 13:16

@mysql_query("truncate table `ibwf_users`;");

**amylee** · 12-07-08, 20:40

truncate is in uppercase

**centiya** · 13-07-08, 04:32

Easy Coding....... Juz Read the clear data codings in ur ownerproc.php

Learner then u can get an idea

**SpiderWap** · 14-07-08, 04:17

Code:

mysql_query("DELETE post FROM users");

Code:

mysql_query("DELETE post FROM users WHERE user=&#39;".$username."&#39;");

Code:

mysql_query("DELETE post, chatp, forump, shoutp, galleryp FROM users WHERE user=&#39;".$username."&#39;");

Wasn't really sure what you wanted, this is just a few examples, but editing with right verables and tables it would work with lava, (I asume your using lave)