Re: When to create a new database

2015-10-10 Thread Ron Piggott
I would lean towards keeping it all together because of the speed decrease between connecting to different databases. What I would tend to do is put some type of prefix that would keep the sets of tables together --- like lib_sports lib_rules lib_statistical lib_definitions data_players

Re: Relational query question

2015-09-29 Thread Ron Piggott
On 29/09/15 13:01, Richard Reina wrote: If I have three simple tables: mysql> select * from customer; +++ | ID | NAME | +++ | 1 | Joey | | 2 | Mike | | 3 | Kellie | +++ 3 rows in set (0.00 sec) mysql> select * from fruit; ++-+ | ID |

Re: question?

2015-01-08 Thread Ron Piggott
The only way I could see this work would be to write forms to a temporary text file array. Then using a cron job to update the database. On Thu, January 8, 2015 10:01 am, bruce wrote: hey. within php (or any other language) is there a way to create the mysql sql, and execute the sql, where

Aggregate

2012-08-31 Thread Ron Piggott
, `inappropriate_content_flag_moderator_review_date` datetime NOT NULL, `views` bigint(250) NOT NULL, PRIMARY KEY (`reference`) I appreciate any help you are able to give me. Ron Piggott www.TheVerseOfTheDay.info