hi!
The application is a password-username-location-type store. The types are web,mysql,
and entries for different computers to I can see all usernames/passwords on certain
computers ....
I would like to make myIsam tables into innodb to provide foreign keys, but I have a
'missing link'
I need to insert 'broken reference' items into another table, to complete the
cycle/circle ....
I need to move items from hash.lokation into location.location .....
mysql> select hash.username as 'hash-username',hash.lokation as 'broken reference',
location.location
-> as 'missing item'
-> from hash left join location on location.location=hash.lokation where
location.location is null;
+---------------+-------------------+--------------+
| hash-username | broken reference | missing item |
+---------------+-------------------+--------------+
| joeofcle | staroffice | NULL |
| eunjin | www | NULL |
| joe | www2 | NULL |
| root | www2 | NULL |
| daz | pop | NULL |
| joeofsa | www.vbulletin.com | NULL |
| spiegel | directvinternet | NULL |
| eunjin | lt.sirfsup | NULL |
| root | rfi-mysql2 | NULL |
| david | sirfsup.com | NULL |
| webuser | rfi-mysql2 | NULL |
.....
CREATE TABLE passwd (
id mediumint not null auto_increment primary key,
FOREIGN KEY category_idx(type) REFERENCES category(type) ON DELETE SET NULL
) TYPE=INNODB
select hash.username as uname, hash.password as pass, hash.lokation as location,
location.location as type, hash.email
from hash,location
where hash.lokation = location.location;
(the foreign key reference is on a third table, the category table, but I can only get
there through
the location table, the one with the nulls)
it would seem to call for some kind of array/loop insert, how can I do that without
using a sub-select?
i can't do a insert into location (location) values ( select ... as above
how can I do this so that the following create table statement will work?
thanks,
joe
--
Joe Speigle | [EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
