ProgrammingThis forum is for all programming questions.
The question does not have to be directly related to Linux and any language is fair game.
Notices
Welcome to LinuxQuestions.org, a friendly and active Linux Community.
You are currently viewing LQ as a guest. By joining our community you will have the ability to post topics, receive our newsletter, use the advanced search, subscribe to threads and access many other special features. Registration is quick, simple and absolutely free. Join our community today!
Note that registered members see fewer ads, and ContentLink is completely disabled once you log in.
If you have any problems with the registration process or your account login, please contact us. If you need to reset your password, click here.
Having a problem logging in? Please visit this page to clear all LQ-related cookies.
Get a virtual cloud desktop with the Linux distro that you want in less than five minutes with Shells! With over 10 pre-installed distros to choose from, the worry-free installation life is here! Whether you are a digital nomad or just looking for flexibility, Shells can put your Linux machine on the device that you want to use.
Exclusive for LQ members, get up to 45% off per month. Click here for more info.
I see. I will attempt this fix. Does Postgre react the same to PHP programming? Are there any decent books on learning it? Is it worth migrating my current data over to it? Or should I look for another database solution that would within my current skill level, which is what........-2? LOL
-mac
(Don't worry about the rants....I get on them quite frequently over other things)
Honestly, that's what I started trying to be. Like I said before, I backed into this deal...I wasn't looking for anythin along this line but I had been out of work for months. I worked for a short time for a salesman who actually hurt my longstanding reputation.
This company, feeling somewhat responsible for some of what happened, offered me a job as a grease monkey. I took it for lack of anything else. Anyway, they had an access database they were trying to use as a tracking program, but it was becoming corrupt and wondered what they could do. I suggested Linux, some kind of sql database with a web-based front end.
They knew there would be a learning curve, and they were willing to endure it. I needed a project to force me to learn something new. I'm 36, lost my 12 year career due to the economic downturn, I have 3 children and a wife who can't work due to medical problems for which she needs surgery, but which I cannot pay for because I don't have insurance.
I went from making 50,000 as a network engineer/consultant to 20,000. I built a 7 million dollar private college in Orlando, FL and can't find a job that will enable me to keep my house!-------Sorry.....now I'm the one on the rant!...In answer to your question, yes, they would be in need of a 'real' database consultant however, I would be doing you a dis-service by trying to hook you two up. These people are cheap, they don't pay bills on time, there are definitive problems within the organization that make me question the viability of their future....In essence, I feel I only prolonged my demise instead of curtailing it.
You are free to contact them if you like, though! LOL
In mine, I was only linking to the one table in the beginning of the query, not to both. So, if I wanted to go further and pull a field from a third table, I would have to add it to the beginning of the statement and make the call to it later in the query, thus:
update job, Products, customer set job.model = Products.model where job.model=Products.prodid and customer.custid=job.custid;
Yes, in MySql syntax like that and
in postgres, the same would be
update job set model = Products.model from Products,customer where job.model=Products.prodid and customer.custid=job.custid;
Across two databases. I don't know an easy way. What I would do, is I could export the tables from one database, import them to an other and then do the needed operations when all the data is available under the same database.
LinuxQuestions.org is looking for people interested in writing
Editorials, Articles, Reviews, and more. If you'd like to contribute
content, let us know.