Re: Creating Table Through Union

2009-11-22 Thread Victor Subervi
On Sun, Nov 22, 2009 at 9:29 PM, Gavin Towey wrote: > The form would be like: > > CREATE TABLE products > SELECT b0basics, b0fieldValues, s0prescriptions, > s0prescriptions0doctors, s0prescriptions0patient, pics FROM table1 > UNION > SELECT b0basics, b0fieldValues, s0prescriptions, > s0prescripti

Re: Table size vs Memory requirements?

2009-11-22 Thread Dan Nelson
In the last episode (Nov 22), Ryan Chan said: > Is it common heard from people that if you have large table (assume MyISAM > in my case), you need large memory in order to have the key/index in > memory for performance, otherwise, table scan on disk is slow. > > But how to estimate how much memory

RE: Creating Table Through Union

2009-11-22 Thread Gavin Towey
The form would be like: CREATE TABLE products SELECT b0basics, b0fieldValues, s0prescriptions, s0prescriptions0doctors, s0prescriptions0patient, pics FROM table1 UNION SELECT b0basics, b0fieldValues, s0prescriptions, s0prescriptions0doctors, s0prescriptions0patient, pics FROM table2 Regards, Gavi

Re: Rename Database - Why Would This Not Work?

2009-11-22 Thread Michael Dykman
Safer and much less work: since you have the luxury of stopping the server, stop it, restarting with skip-networking and log in from a local console which should guarantee that you are alone on the system. RENAME TABLE olddb.table1 TO newdb.table1, olddb.table2 TO newdb.table2 put the who

Re: Optimizing Project Requirements - question

2009-11-22 Thread mos
Mikesz, The best way to approach this is to discover how it has been implemented by others. There is no point re-inventing the wheel. I'm sure you can get some ideas from this web site: http://www.databaseanswers.org/data_models/. and the tutorial at http://www.databaseanswers.org/tuto

Creating Table Through Union

2009-11-22 Thread Victor Subervi
Hi; I would like to create a table out of merging the fields in other, previously created tables. I have the following syntax which doesn't work: create table products union (b0basics, b0fieldValues, s0prescriptions, s0prescriptions0doctors, s0prescriptions0patient, pics); Please advise. TIA, Vic

Table size vs Memory requirements?

2009-11-22 Thread Ryan Chan
Hello, Is it common heard from people that if you have large table (assume MyISAM in my case), you need large memory in order to have the key/index in memory for performance, otherwise, table scan on disk is slow. But how to estimate how much memory I need? Consider a simple case, a MyISAM table

Re:Re:Help with SELECT clause

2009-11-22 Thread shjunsin
I'm sorry for missing the key word "not", it should be SELECT * FROM approvals WHERE adminname != 'admin2'and photo_uid not in (select photo_uid from approvals where adminname='admin2'), 在2009-11-22，shjunsin 写道： >Hi\I think you can achieve this using a single query like this: SELECT * FROM

Re:Help with SELECT clause

2009-11-22 Thread shjunsin
Hi\I think you can achieve this using a single query like this: SELECT * FROM approvals WHERE adminname != 'admin2'and photo_uid in (select photo_uid from approvals where adminname='admin2'), of course, maybe it's not the best solution, just for your information.在2009-11-22，"Ashley M. Kirchner"

Re: Rename Database - Why Would This Not Work?

2009-11-22 Thread Rob Wultsch
On Sat, Nov 21, 2009 at 2:43 PM, Robinson, Eric wrote: > > DB engines that have their own data dictionary (Innodb, etc) in > addition to > > what is in the .frm could easily be messed up. > Like I said, there are only MyISAM tables in the database, so would there > be any risks associated with my