MySQL Forums
Forum List  »  Newbie

Re: LEFTJOIN ???
Posted by: Tony Mole
Date: December 13, 2017 03:04AM

Hi Peter

Many thanks for looking - and I am sort of pleased that my code works, even though not in my application.

I really am a newbie and have little or no experience in PHP or MySQL coding - I have built a PHP based stock program which we use internally at work to check suppliers stock. Daily I dump the database and re-import just under 1,000,000 lines of stock availability and costs. I have created a virtual Ubuntu Server (no GUI) on a spare server I have at home. I am using Ubuntu 14.04.5 LTS / PHP Version 5.5.9-1ubuntu4.22 / mysql Ver 14.14 Distrib 5.5.50. The reason I need these versions is that the application I am using (Xataface) wont work a newer PHP version without major re-coding which I dont have the knowledge or time to update at the moment - although I plan to migrate when I get a chance!

So to summarise, the reason I am using MyISAM rather than InnoDB is because this was what I ended up with after following numerous tutorials on building the server from scratch.

I do have a non-production copy of the server which I use to test changes before applying them on my production system - so if you think there is anything I should try (e.g. removing MyISAM and installing InnoDB) then I am happy to try (using Google) to make changes.

Also to emphasise my lack of knowledge, what you say about "Consider first trying the query in the mysql client. If you still get the problem, the problem is with mysql not phpMyAdmin, so run Check Table and Analyze Table on the two tables" is not something I know how to do - so will look in Google (when I get a chance) to do this.

Thanks again for the pointers and I will report back when I make some progress.

Thanks

Tony

Options: ReplyQuote


Subject
Written By
Posted
December 12, 2017 11:41AM
December 12, 2017 12:04PM
December 12, 2017 03:39PM
December 12, 2017 05:21PM
Re: LEFTJOIN ???
December 13, 2017 03:04AM
December 13, 2017 03:29AM
December 13, 2017 08:38AM
December 13, 2017 08:45AM
December 13, 2017 10:34AM
December 15, 2017 09:57AM
December 16, 2017 04:44AM
December 19, 2017 10:17AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.