[SOLVED] CANNOT DELETE...help!!!!
Posted: Sat Jan 31, 2004 5:05 am
why can't i delete my data in mysql???
this is my query:
and then i try to delete via phpmyadmin,and then this error showed up:
this is my table structure:
pls help...
this is my query:
Code: Select all
<?php
$viewall=mysql_query("DELETE komponen,jumlah FROM tempkomponen");
?>Code: Select all
Error
SQL-query :
DELETE komponen,
jumlah FROM tempkomponen
MySQL said:
Not unique table/alias: 'komponen'Code: Select all
CREATE TABLE tempkomponen (
id int(11) NOT NULL auto_increment,
komponen varchar(50) default NULL,
jumlah int(11) default NULL,
PRIMARY KEY (id)
) TYPE=MyISAM;pls help...