hi Daisley thanks for your answers
Best Regards Faizal S GSM : 9840118673 Blog: http://oradbapro.blogspot.com On Wed, Sep 30, 2009 at 4:20 PM, John Daisley <j...@butterflysystems.co.uk>wrote: > Basic answers under each of your questions below > > > -----Original Message----- > From: F.A.I.Z.A.L <sac.fai...@gmail.com> > Sent: Wednesday, September 30, 2009 11:11 AM > To: John Daisley <j...@butterflysystems.co.uk> > Cc: mysql@lists.mysql.com > Subject: Re: iam new bee to mysql > > Hi > > 1. can you please explain me about mysql 5 architecture and background > process.. > > You need to read the manual for this. Start here > http://dev.mysql.com/doc/refman/5.1/en/features.html > > 2. how to create a schema in mysql > > Create schema schema_name; > Create database schema_name; > > 3. is there anything like tablespace in oracle.. > > Yes and no! Read the manual sections relating to storage engines especially > innodb. http://dev.mysql.com/doc/refman/5.1/en/storage-engines.html > > 4. if yes, how to create tablespace. > > Create tablespace ..... > See the ref manual for the full syntax but make sure you understand how > and when mysql uses tablespace. > http://dev.mysql.com/doc/refman/5.1/en/create-tablespace.html > > 5. how is storage system in mysql. > in oracle, tablespace->segment->extend->block, is there anything > like that in mysql > > Read the manual section on storage engines as it varies by engine > http://dev.mysql.com/doc/refman/5.1/en/storage-engines.html > > 6. how to create user, grant privilege to them > > Grant priv on schema.table to u...@host identified by 'password'; > > Read the manual section on grant > http://dev.mysql.com/doc/refman/5.1/en/grant.html > > thanks in advance.. > > Best Regards > Faizal S > GSM : 9840118673 > Blog: http://oradbapro.blogspot.com > > > On Wed, Sep 30, 2009 at 1:51 PM, John Daisley > <j...@butterflysystems.co.uk>wrote: > > > > [The entire original message is not included] >
