Help with a DELETE query

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi,

In a small part of my database I have two tables as follows:

# ---------- MySQL dump ---------- 
#
# Table structure for table 'WMS_Data'
#
CREATE TABLE WMS_Data (
Data_ID int(11) DEFAULT '' NOT NULL auto_increment,
Booking_ID int(11) DEFAULT '0' NOT NULL ,
Data_Field_1 varchar(100) ,
Data_Field_2 varchar(100) ,
Data_Field_3 varchar(100) ,
Data_Field_4 varchar(100) ,
Data_Field_5 varchar(100) ,
Data_Field_6 varchar(100) ,
Data_Field_7 varchar(100) ,
Data_Field_8 varchar(100) ,
Data_Field_9 varchar(100) ,
Data_Field_10 varchar(100) ,
PRIMARY KEY (Data_ID)
);

#
# Table structure for table 'WMS_Fields'
#
CREATE TABLE WMS_Fields (
Field_ID int(11) DEFAULT '' NOT NULL auto_increment,
Field_Name varchar(40) DEFAULT '' NOT NULL ,
Project_ID int(11) DEFAULT '0' NOT NULL ,
Work_Type_ID int(11) DEFAULT '0' NOT NULL ,
Data_Field varchar(20) ,
PRIMARY KEY (Field_ID)
);

# ----------- Dump ends ----------- 

The purpose of this is for every project created in the database the user
can create various data fields and collect data. The data is stored in table
WMS_Data and the data fields are named in table WMS_Fields. In this table
column Data_Field stores the column name of the corresponding Data_Field in
table WMS_Data. How can i create a query that deletes everything from a
given column in table WMS_Data, if I only have the Field_ID for table
WMS_Fields?

Something like: DELETE FROM WMS_Data D COLUMN WHERE WMS_Fields.Data_Field =
D.Column_Name AND WMS_Fields.Field_ID = '$my_variable';

Please excuse the poor SQL, just trying to explain what I am trying to do!

Thanks for your help




-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux