I'm having a hard time trying to find the best way to create a
relationship between two rows in the same table.
I have a database that describes network equipment.
There is a table called devices that contains information about the
device.
There is another table called ports that
Hi,
(better change the message subject if you change, well, the subject)
user will create more number of tickets per day. so INSERT, UPDATE, SELECT
will use highly.
in document says' Myisam will not support transaction but it has self
backup
and restoration method. but in InnoDB good for
what is the purpose of 'Grant usage ' command
http://search.mysql.com/search?site=refman-50q=grant+usagelr=lang_en
Check the documentation, if you have more questions after that, get back to
us.
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Download Database
I am new at database design, and my question relates to the trade-offs
between putting all data in one database or several for mysql. For example,
say I have an application where a users login from their mobile phones and
read/write data to a database. Say there are roughly 10-15 tables in the
Mark Phillips wrote:
I am new at database design, and my question relates to the trade-offs
between putting all data in one database or several for mysql. For example,
say I have an application where a users login from their mobile phones and
read/write data to a database. Say there are roughly
On Sat, Oct 3, 2009 at 2:47 PM, John Meyer john.l.me...@gmail.com wrote:
Mark Phillips wrote:
I am new at database design, and my question relates to the trade-offs
between putting all data in one database or several for mysql. For
example,
say I have an application where a users login from
John,
Thanks. The data is private to each user; there is no sharing of data.
I am not sure what you mean by are the actions related Each user is
reading/writing independently of each other. Would that argue for
separate databases?
Mark
Are the actions of a similar nature (i.e. they're
On Sat, Oct 3, 2009 at 3:06 PM, Martin Gainty mgai...@hotmail.com wrote:
depends on the relationship of the Data Tables and the Users that use them
for instance if I was to setup a table of outgoing calls from 2 distinct
individuals :
Me calls to HarvardMedicalSchool,
On Sat, Oct 3, 2009 at 4:02 PM, John Meyer john.l.me...@gmail.com wrote:
John,
Thanks. The data is private to each user; there is no sharing of data. I
am not sure what you mean by are the actions related Each user is
reading/writing independently of each other. Would that argue for
Mark Phillips wrote:
On Sat, Oct 3, 2009 at 3:06 PM, Martin Gainty mgai...@hotmail.com wrote:
depends on the relationship of the Data Tables and the Users that use them
for instance if I was to setup a table of outgoing calls from 2 distinct
individuals :
Me calls to
10 matches
Mail list logo