Recent content by jscott

I found a post which mentions "phpMyAdmin" as a visual tool for working with mysql. However, as is evidenced by the name, it needs php. Is there a similar tool which might use perl, or even java for this? Thanks Jean

I am currently using a perl generated html page to gather data and insert it into a mysql database. I want to know what I need to do to have any error messages generated by the database (ie, duplicate entry) output to the browser. thank you in advance Jean

I am trying to select values from one table and load them into another. This is the code I have mysql> insert into tblTemp2(abFirst, abLast, abID_temp) values( -> select abFirst, abLast, concat(substring(abFirst, 1, 1), substring(abLast, 1, 1), abstractorID)from abstractor where...

Thanks, I think that is the only way. I didn't want to have to do this every time I add new rows. I was hoping to make it automatic so to speak. When a new person is added through the site I am working on I want this field to generate itself....I want to make it an unique key field. I guess I...

I tried the following two with the same syntax error insert into abstractor(abID) values (select concat (substring(abstractor.abFirst, 1, 1), substring(abstractor.abLast, 1, 1), abstractor.abstractorID)); insert into abstractor(abID) values (concat (substring(abstractor.abFirst, 1, 1)...

Hi, I have been working on this isnert for a while, with several differant varieties of the same code with no result except error. I have tried-insert into abstractor(abID) select (select (concat(substring(abstractor.abFirst, 1, 1), substring(abstractor.abLast, 1, 1), abstractor.abstractorID))...

I certainly do appreciate the input. I am printing your responses as I type so I can refer back and give it a whirl using your suggestions. I will let you know how it turns out. Jean