thanks kumar..
now its working
i have another doubt
i created an user with limited privilege on particular schema.
schema name: test
*mysql create user 'test'@'%' identified by 'test';
mysql grant select,insert,update,delete,create,drop on test.* to 'test'@
'%';*
after that i login with
a. INFORMATION_SCHEMA is the information database ie metadata, the place
that stores information about all the other databases that the MySQL server
maintains. Inside INFORMATION_SCHEMA there are several read-only tables.
They are actually views, not base tables, so there are no files associated
Hello Carlos,
I am no doubt very new to MySQL and have been studying the on line
manual however I find it a bit complex and don't understand what it's
suggesting I do in this case. I created a database called 'staff' and
then in that database I created one simple table:
mysql show tables;
hi Kumar
thanks for your info..
another doubt.. which storage engine is best for transaction..
in my server. the default engine is myisam. now i changed one of my schema
to innoDB. is that correct.
now i want to create another schema in different location. how to create
that? because current
You can use :
*ALTER TABLE it ADD COLUMN title varchar(25), phone number integer (6);*
it will add new column after last.
but you can also specify the particular column after you want to add.
like.
*ALTER TABLE it ADD COLUMN title varchar(25), phone number integer (6) AFTER
pusername; *
A. For transaction *innoDB* is best.
B. *ALTER TABLE table_name ENGINE = InnoDB;
* but* *if you tons of tables so better export all tables in file and
replace all occurs of *myisam* with *InnoDB *the import it.
and enable InnoDB engine.
http://www.linux.com/archive/articles/46370
C. 1. Stop
thanks kumar.
Storage
in datadir contain only one location.is it possible to have multiple
location to store datafiles.if yes, how?
what is the different between storage engine and tablespace in mysql?
account creation
*create user 'test'@'%' identified by 'test';
grant usage on test.* to
Hi!
prabhat kumar wrote:
You can use :
*ALTER TABLE it ADD COLUMN title varchar(25), phone number integer (6);*
it will add new column after last.
but you can also specify the particular column after you want to add.
like.
*ALTER TABLE it ADD COLUMN title varchar(25), phone
1 doubt
the front end application is lab ticketing system. so user will create many
ticket. iam expecting per day 200k ticket user will create. so which storage
engine is best to use. innodb or myisam..?
Best Regards
Faizal S
GSM : 9840118673
Blog: http://oradbapro.blogspot.com
On Thu, Oct 1,
a. at Linux level you can make soft link to database dir to particular
database ie schema. I don't is it possible at mysql level?
b. There is no relation between storage engine and table space.
Yes, Innodb uses tablespace you can read more on both.
c.
innodb.
Since, If there are many modifications of the data, it's said that InnoDB
works faster because it uses row locking instead of table locking, like
MyISAM. However, if there are mainly SELECT statements, a MyISAM table might
be faster.
On Thu, Oct 1, 2009 at 2:33 PM, F.A.I.Z.A.L
Thanks Joerg. You are very correct.
On Thu, Oct 1, 2009 at 2:40 PM, Joerg Bruehe joerg.bru...@sun.com wrote:
Hi!
prabhat kumar wrote:
You can use :
*ALTER TABLE it ADD COLUMN title varchar(25), phone number integer (6);*
it will add new column after last.
but you can also
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 transaction but no self
managed backup and restoration..
now how can i choose
hi kumar
what is the purpose of 'Grant usage ' command
Best Regards
Faizal S
GSM : 9840118673
Blog: http://oradbapro.blogspot.com
On Thu, Oct 1, 2009 at 3:06 PM, F.A.I.Z.A.L sac.fai...@gmail.com wrote:
user will create more number of tickets per day. so INSERT, UPDATE, SELECT
will use
Hi all,
Given the Social and Political reality in my country (Madagascar),
I am obliged to look for a relocation.
This is my public profile:
http://www.linkedin.com/in/mihaminarakotomandimby
Would you be aware of a position I could fit in?
Thank you.
--
Architecte Informatique chez
Hello
I have to upgrade many mysql databases from mysql 4 and 4.1 to 5.4 with a
large size 2.7 TB
All tables use the MyISAM engine.
I have to make that update on live system with minimal down time possible.
The official method takes too much time. But I’ve read that we can use ‘*dump
and
Hello everyone,
I wanted to take a minute and extend an invitation to anyone who has
interest in writing about MySQL or other open source database servers.
July brought the first issue of Open Source Database Magazine and it was a
resounding success. Our download count has skyrocketed. I was
Using mysqldump and loading directly into 5.4 *might* work, but you should
never do any of this on your production system without testing.
Get another box, start with 4.1 and do the upgrade on a test server -- even
test your queries as there a few incompatible changes between 4 and 5. One you
Hi;
I'm new to join statements. Here's my python syntax:
cursor.execute('select * from %s left join products on
%s.Item=products.Item (left join categories on
products.Category=categories.ID);' % (client, client))
I believe it's clear how I want to nest, but I don't know how to repair my
Joins aren't nested like that, unless you use a subquery. I think you just
need to remove the parens around the second join.
For better help:
1. show the real SQL -- echo the statement. Most people here don't like
looking at app code because your variables could contain anything.
2. Give the
On Thu, Oct 1, 2009 at 4:03 PM, Gavin Towey gto...@ffn.com wrote:
Joins aren't nested like that, unless you use a subquery. I think you just
need to remove the parens around the second join.
I tried that and no go :(
For better help:
1. show the real SQL -- echo the statement. Most
Victor,
Thank you for the information, that was helpful.
At least part of the problem is the variables you are replacing in that string,
which we can't see.
The statement should be something like:
select * from ben_franklin_planners c join products p on c.Item=p.Item join
categories cat on
Well, your syntax is *exactly* what I had (with a few cosmetic changes).
I've been over the MySQL manual on joins with no luck. I'll read over your
resources tonight. Any other ideas would be appreciated.
Thanks,
V
On Thu, Oct 1, 2009 at 4:49 PM, Gavin Towey gto...@ffn.com wrote:
Victor,
Victor,
Just noticed, the join condition from client to productions should be changed:
select * from ben_franklin_planners c join products p on c.Item=p.ID join
categories cat on p.Category=cat.ID
If you're still getting syntax errors you need to check your variables. Try
assigning the
24 matches
Mail list logo