, the easiest and best way is to make sure the application cleans up
after itself and closes the transactions as soon as it can.
I hope this helps!
Regards,Nitin
On Saturday, April 2, 2016 8:07 PM, geetanjali mehra
<mailtogeetanj...@gmail.com> wrote:
Hi to all,
For many days
Sent: Friday, April 5, 2013 11:26 AM
Subject: Re: MySQL on RHEL4
On 2013-04-05, Nitin Mehta ntn...@yahoo.com wrote:
We're trying to upgrade our existing MySQL 5.1.26 to MySQL 5.1.68 but the
installation gives error:libc.so.6(GLIBC_2.4) is needed by
MySQL-server-community-5.1.68-1.rhel5
for RHEL4 and MySQL 5.1 and 5.5 are supported on
RHEL4 as per this: http://www.mysql.com/support/supportedplatforms/database.html
Any ideas?
Regards,
Nitin
Hi,
There was sort of a bug which was fixed in MySQL 5.5 with replication
heartbeat. Before the replication heartbeat, a new relay log file would be
created after every slave_net_timeout. It doesn't have any negative impact
though.
Hope that helps.
From:
Hi Tim,
It looks like your '.sql backup file' has changed the password for root user
and why it is persisting is perhaps you have data directory outside the install
directory.
How you correct the problem:
Stop the service, start the service with option '--skip-grant-tables', login
with root
get the below
error . What can be the reason and how can i repair it ?
Regards
Mysql_error: Table ./x/y ' is marked as crashed and should be repaired
--
Regards,
/Nitin Mehta/
Hi Aastha,
I'm not 100% sure but you could try defining the full connectstring using:
ndb-connectstring = localhost:1186
See if that helps.
Regards,
From: Aastha aast...@gmail.com
To: mysql@lists.mysql.com
Sent: Sunday, September 23, 2012 7:51 AM
I'm more of an hit and try guy and do good only with a data set available.
Still I think making a little change might do the trick.
SELECT DISTINCT
p.productid,
pd.name
FROM menu_product as p
INNER JOIN menu as m ON (m.menuid = p.menuid AND m.name = 'name obtained from
!
Regards,
From: Brown, Charles cbr...@bmi.com
To: Nitin Mehta ntn...@yahoo.com
Cc: mysql@lists.mysql.com mysql@lists.mysql.com
Sent: Thursday, May 3, 2012 4:24 PM
Subject: master BIN-LOG maintenace
Hi Gurus,
I would like to set BIN-LOG maintenance procedure
Thanks for your kind words, Charles! It comes easily to you when you have
experienced it. I'm glad it worked for you.
From: Brown, Charles cbr...@bmi.com
To: Nitin Mehta ntn...@yahoo.com
Cc: mysql@lists.mysql.com mysql@lists.mysql.com
Sent: Thursday, May 3
I guess, it only makes things even more simple.
You should use replicate-do-table=db1.tb1 and so one in slave's cnf to ensure
that only this particular table gets replicated. However, all the databases on
master will get bin-logged and you may or may not want to do that.
So making it even
on slave. So in one word response to your question, no!
Hope that helps!
Also, please reply to all so the people, helping you, know about the status of
your problem.
Regards,
From: Brown, Charles cbr...@bmi.com
To: Nitin Mehta ntn...@yahoo.com
Sent
Hi Jeff,
threads_connected tells you total number of connections created since server
startup and threads_cached says how many stay alive (connection pooling) even
if there are no clients connected. This means that because the value of
threads_cached was reduced on your server, it is having
I'm not sure but you might try with sql_mode set to ANSI. Otherwise try the
dump
remotely from a Linux box.
Regards,
Nitin
From: Manasi Save manasi.s...@artificialmachines.com
To: win.a win@gmail.com
Cc: mysql@lists.mysql.com mysql@lists.mysql.com
Sent
(of database in your case).
Hope that helps.
Regards,
Nitin
From: Manasi Save manasi.s...@artificialmachines.com
To: mysql@lists.mysql.com mysql@lists.mysql.com
Sent: Sat, September 4, 2010 12:06:27 PM
Subject: mysqldump error 1064 for database Use command
Hi
I believe that will not be logged unless you have enabled log_warnings. Too
many
connections would normally mean that the number is going beyond the configured
limit and denying new sessions is an expected behavior and should not be an
error really.
Regards,
Nitin
Manasi,
Your table structure doesn't show that the column TestID is unique. I believe
what Michael also suggested was that unless this column contains unique values,
you never know which row your procedure is reading.
I hope I'm making myself understood.
Regards,
Nitin
this within MySQL conf itself.
Thanks in advance!
Regards,
Nitin
that helps!
Regards,
Nitin
From: Machiel Richards machi...@rdc.co.za
To: mysql@lists.mysql.com
Sent: Thu, May 20, 2010 1:07:43 PM
Subject: Innodb buffer pool size
Hi Guys
I just have a quick question.
I have done some research into how
Thanks, Prabhat! You're very right, but did you read the questions I asked?
From: Prabhat Kumar aim.prab...@gmail.com
To: Nitin Mehta ntn...@yahoo.com
Cc: mysql@lists.mysql.com
Sent: Tue, May 11, 2010 11:54:22 AM
Subject: Re: starting multiple instances
of?
If you have resolved these issues, please let me know.
Best Regards,
Nitin
file which is very
handy if you need to take up PTR or just want to verify any details.
Hope that helps!
Regards,
Nitin
- Original Message
From: Angelina Paul arshup...@gmail.com
To: mysql@lists.mysql.com
Sent: Tue, May 4, 2010 3:49:35 AM
Subject: mysql transaction log
Please help
Is mysql the owner of the directories?
- Original Message
From: Manasi Save manasi.s...@artificialmachines.com
To: Johan De Meersman vegiv...@tuxera.be
Cc: Waynn Lue waynn...@gmail.com; mysql mysql@lists.mysql.com
Sent: Wed, November 25, 2009 8:12:25 PM
Subject: Re: question regarding
Hi all,
There's a problem. When I try to inert into table with
insert into schedule (owner, desc, sch_for, status) values ('a', 'b', 'c', 'd')
I get error
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL
server version for the right syntax to use near
Solved.
- Original Message -
From: [EMAIL PROTECTED]
To: Nitin [EMAIL PROTECTED]
Sent: Saturday, June 26, 2004 4:33 PM
Subject: Re: insert into text field
look *carefully* at the insert syntax, paying attention to spaces and
the like:
INSERT INTO tbl_name () VALUES
if 2nd and 3rd rows are deleted, an autoincrement field will still assign 10, 11,
12 to the new values, while I want it to assign the values deleted from the table
first.
What will be the best way to implement it?
Thanks in advance
Nitin
First of all, thanks for replying.
but, u didnt get my point. I want to use numeric field only as the key
field, but not the normal auto increment..
- Original Message -
From: Daniel Kasak [EMAIL PROTECTED]
To: Nitin [EMAIL PROTECTED]; MySQL Mailing List
[EMAIL PROTECTED]
Sent
it, if it does (or doesn't) let me know
Regards
Nitin
- Original Message -
From: [EMAIL PROTECTED]
To: Michael Stassen [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Thursday, April 29, 2004 1:15 PM
Subject: Re: SQL SELECT HELP
Hi,
Sorry. My english is not so good. :(
I try to explain.
I
]
b: http://alan.blog-city.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
HTH...
Nitin
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
please include the query, you are using with no success and also specify the
version of your mysql.
Nitin
- Original Message -
From: Ed Reed [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, March 29, 2004 1:27 PM
Subject: Access to MySQL query problem
I'm coverting an Access
Hello buddy,
try installing
MySQL-shared-compat for your platform
HTH
Nitin
- Original Message -
From: Timothy Venn [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, March 29, 2004 7:13 PM
Subject: Libmysqlclient.so.14 on Solaris 2.8 (SPARC)
Hello,
Please can someone tell
which ver of mysql are you using? multiple table update is possible only
with ver starting from 4.0.4.
HTH..
Nitin
- Original Message -
From: Laercio Xisto Braga Cavalcanti [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Friday, March 26, 2004 11:39 PM
Subject
You need to download Dynamic client libraries - (including 3.23.x
libraries) to satisfy these dependencies. This is available on mysql
download page. Choose for your particular version.
And if that helps, read the installation procedure, next time before
installation.
Hope that helps
Nitin
you can very well use those files, though, im not sure, if you can check the
table structure bafore restoring it.
HTH
Nitin
- Original Message -
From: dan [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, March 23, 2004 9:34 PM
Subject: using old frm files
we had a database
mysql doesn't write any files to any directory other than its data
directory, so try:
SELECT * INTO OUTFILE 'Results.txt' FROM Answer;
and then copy it whereever you want.
HTH
Nitin
- Original Message -
From: Rick Duley [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: Geoff Roy [EMAIL
i dont think its possible. you can do it by using time_to_sec() function of
mysql and then sec_to_time after addition
Hope that helps
Nitin
- Original Message -
From: Elly Wisata [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, March 19, 2004 10:08 AM
Subject: Sum for time
Hi
Hi,
- Original Message -
From: Chris Knipe [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, March 20, 2004 12:33 PM
Subject: *very* strange...
Lo everyone,
I'm *baffled* completely I've never seen something like this
before.
: I tried this exact query from PHP,
UPDATE `Table A`,`Table B` SET `Table A`.`text`=concat_ws('', `Table
B`.`B-num`, from ,`Table B`.`date`) WHERE `Table A`.`A-num` = `Table
B`.`A-num`
Hope it works
Nitin
- Original Message -
From: Wouter Coppieters [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, March 13, 2004
UPDATE `Table A`,`Table B` SET `Table A`.`text`=concat_ws('', `Table
B`.`B-num`, from ,`Table B`.`date`) WHERE `Table A`.`A-num` = `Table
B`.`A-num`
Hope it works
Nitin
- Original Message -
From: Wouter Coppieters [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, March 13, 2004
WHERE (nickname = '$nickname') and (password = '$password'), $connection);
remember to place quotes around the value
nickname = $nickname wont work but
nickname = '$nickname' will do
Hope that helps
Nitin
- Original Message -
From: electroteque [EMAIL PROTECTED]
To: Togochog
there must be some problem in concatenation of strings and number variables. If you
can send the lines, we'll be able to suggest the exact change.
Hope that helps
Nitin
- Original Message -
From: CurlyBraces Technologies ( Pvt ) Ltd
To: [EMAIL PROTECTED]
Sent: Tuesday
that's called, cache-hit
- Original Message -
From: Matt W [EMAIL PROTECTED]
To: Mike Mapsnac [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Tuesday, February 24, 2004 5:25 AM
Subject: Re: run query second time
Hi Mike,
- Original Message -
From: Mike Mapsnac
Sent: Monday,
are you using MySql 4.x?
try only
mysql
Hope that helps
Nitin
- Original Message -
From: Davut Topcan [EMAIL PROTECTED]
To: Maria Yndefors [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Tuesday, February 24, 2004 3:37 PM
Subject: Fw: install problem
Hi,
From: Maria Yndefors [EMAIL
Hi all,
I m looking for any function or a work around to fetch numerical data without its sign
(-10 -- 10, 10 -- 10). Any ideas?
Thanx
subqueries are introduced in 4.1 only
- Original Message -
From: Emmanuel Ohannessian [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, January 26, 2004 12:10 PM
Subject: subqurey syntax error
I am getting the error message:
mysql SELECT s1 FROM t1 WHERE s1 IN(SELECT s1
function can b used, but value parameter seems syntactically wrong, check
that.
'#session.month#' to '$month'
which is the language,u r using anyway?
- Original Message -
From: Yves Arsenault [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, January 21, 2004 6:37 PM
Subject:
'',
plancode varchar(20) NOT NULL default '',
reseller varchar(20) NOT NULL default '',
PRIMARY KEY (packno)
) TYPE=MyISAM;
I want to select distinct values of reseller column as individual columns and other
data grouped on these values.
Thanx in advance
Nitin
thanx for reply but not a good idea. Though i did it through PHP script
Nitin
- Original Message -
From: Mechain Marc [EMAIL PROTECTED]
To: Nitin Mehta [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Friday, January 16, 2004 1:38 PM
Subject: RE: is this possible?
To drop all tables, yes
it cannot b related with primary key. i do not hav any idea how u update it,
but it's supported to update any dat in any table with or without PK
- Original Message -
From: Hans van Dalen [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, January 15, 2004 6:20 PM
Subject: table
hello everybody,
i was wondering, if there's a single command to drop all or selected tables from the
database, something like, where i can give the table names (1-2-3) not to be deleted.
Thanx in advance
Nitin
i dont think that, cauz 'Password' field in 'user' table was always 16 char
long and still is. In fact, check for the no. of privs in 'user' table. if
it is 21 or 14, as in 3.23.x it was 14 and in 4.0.17 is 21.
Hope that helps
Nitin
- Original Message -
From: Director General: NEFACOMP
If the data is 10-char in length always, CHAR is better performance-wise.
- Original Message -
From: Hassan Shaikh [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, January 11, 2004 6:34 PM
Subject: Which one is better: CHAR or VARCHAR?
Hi,
I've a column of type VARCHAR(10) where
these are definitely MySQL connection identities. Each with specific
(different) privileges. You can connect to the database directly with these.
- Original Message -
From: Matthew Stuart [EMAIL PROTECTED]
To: MySQL email support [EMAIL PROTECTED]
Sent: Monday, January 12, 2004 6:32 PM
you need not write any scripts, just use MySQL Front to Import/Export dat from M$
Access
zzapper [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED]
Hi Ya,
How to this has always been somewhat fuzzy in my head. I looked around
for tools unsuccessfully . So I thought I'd share my
first download and install Dynamic client libraries
(including 3.23.x libraries) available on same page to satisfy the
dependencies
Enjoy
Nitin
- Original Message -
From: Nikos Gatsis [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, January 08, 2004 6:01 PM
Subject: MySQL 4.1
You can just install MyODBC on the client (running MS Access) then you can
link tables stored anywhere.
have a look at:
http://forums.devshed.com/t56700/s.html
for more info
Hope that helps
Nitin
- Original Message -
From: Matthew McNicol [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent
You dont need Apache to run MySQL. Apache is a web server, which is required
to publish web pages. So the answer is yes.
Enjoy
Nitin
- Original Message -
From: EP [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, January 09, 2004 9:53 AM
Subject: Mysql by itself?
OK, I need
Oh, if that's the case, I'm sorry for false info.
Of course, if server is not accessible, then you cannot connect to it
anyway, directly or through Access.
Sorry again
Nitin
- Original Message -
From: Daniel Kasak [EMAIL PROTECTED]
To: Nitin Mehta [EMAIL PROTECTED]; Matthew McNicol
Hi all,
as the subject of the mail says, is there any function to apply in a query, that finds
out if the value returned from the database is numeric?
thanx for help in advance
Nitin
- Original Message -
From: Mike [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, January 05, 2004 10:53 AM
Subject: Re: Table: NULL (yes or no)
I create two tables. And when I do
desc table_name;
NULL value can be 'Yes' or 'No'. What the difference when NULL value is
'Yes' or
move the data files to another directory (partition) and create symlinks in
original directory
- Original Message -
From: Mike Mapsnac [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, January 03, 2004 7:42 PM
Subject: Delete logs: not enough space on /var/lib/mysql
I don't
you can optionally use MySQL Front to view and edit data in GUI mode
get it free of cost athttp://www.mysqlfront.de/
Enjoy
Nitin
- Original Message -
From: Michael Stassen [EMAIL PROTECTED]
To: Caroline Jen [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Thursday, December 18, 2003
dear buddy,
when u specify permissions on a particular database, you need to give that
database name to connect to db.
user created fine, while connecting, try this:
mysql -u abc -p abc
where last abc is ur database name.
Nitin
- Original Message -
From: ads mysql [EMAIL PROTECTED
did u do a
flush privilege
- Original Message -
From: ads mysql [EMAIL PROTECTED]
To: Nitin [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Tuesday, December 16, 2003 1:00 PM
Subject: Re: How to create mysql user?
O K. I have tried following as advised.
#
[EMAIL PROTECTED] mysql
- Original Message -
From: Nitin [EMAIL PROTECTED]
To: ads mysql [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Tuesday, December 16, 2003 2:01 PM
Subject: Re: How to create mysql user?
did u do a
flush privilege
- Original Message -
From: ads mysql [EMAIL PROTECTED
right now, u r trying to connect t omyql with uer abc, not creating it.
to create user abc
grant privs on dbname.tablename to 'abc' identified by 'abc';
you can view the list of privileges available on myql website at
http://www.mysql.com/doc/en/GRANT.html
Enjoy
Nitin
- Original Message
Look at http://www.mysql.com/downloads/mysql-4.0.html for Dynamic client libraries for
your platform.
Enjoy
Nitin
- Original Message -
From: Franz Edler [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, December 05, 2003 6:25 PM
Subject: Where to find MySQL-shared-compat
no problems that i see.
- Original Message -
From: p shah [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, December 03, 2003 12:23 PM
Subject: Mysql Date column type
Hi,
I have one question regarding date column type in
MYSQL.
Can I use the column type for date as
r u getting this problem while coonecting through MySql Front or directly to
the server?
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, December 03, 2003 3:23 PM
Subject: Client does not support authentication protocol requested by server
Hello
is this declared in php or javascript??
depends on the syntax.
- Original Message -
From: Caroline Jen [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, December 02, 2003 9:38 AM
Subject: Select Records From the Database
I got null after selecting records from a table in
the
now() gives current date and time. use current_date() instead.
hope it helps
Nitin
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, December 02, 2003 9:32 PM
Subject: Date data type issue
Having a problem with a Date data type.
Here's the query
In my opinion MySql front is best and the best thing is further development
of already enriched software started again.
Nitin
- Original Message -
From: Colleen Dick [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Tuesday, December 02, 2003 8:42 PM
Subject: Re
hi all,
I've searched a bit, but didn't find any documentation on how to use unicode in mysql
4.0.14 or 4.0.X. Any ideas or links?
Thanx in advance
Nitin
Subqueries aren't supported in MySql prior to ver 4.1.
- Original Message -
From: Becky OGrady [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, November 15, 2003 12:28 PM
Subject: NEWBIE!! need help with nested select query
Hi-
I have 2 queries that I know work in SQL
2 and press enter
Insert vol 3 and press enter
...
Dont know, what to do. I googled on it, but no specific answer. If you have a solution
or direct me to some helpful info, I'll be very gratefull. It's really important, so
sorry again for querying at wrong place.
Regards
Nitin
Hi all,
I have a project in hand, where I need to accept and show data in Hindi language,
storage doesn't matter. Is that possible with MySQL, if yes, what do I need to
configure? How do I do it, any help or ideas?
Regards
Nitin
it helps
Nitin
- Original Message -
From: fab [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, November 04, 2003 1:58 PM
Subject: minus operation
Hi to all,
My question is rather about sql langage than mysql.
Here it is: i have 2 tables (A and B) with the same structure (4 fields
Enjoy
Nitin
- Original Message -
From: Leo Huang [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, November 04, 2003 6:28 PM
Subject: InnoDB Questions
Hello,
I have a few questions about InnoDB.
I am new to InnoDB, and just converted my MyISAM tables into InnoDB a
few days ago
at:
http://www.mysql.com/doc/en/InnoDB_File_space.html
Enjoy
Nitin
- Original Message -
From: Leo Huang [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, November 04, 2003 8:00 PM
Subject: Re: InnoDB Questions
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Thank you very much
have data more than the size you're specifying, it'll
through error and wont do nothing.
Nitin
- Original Message -
From: Leo Huang [EMAIL PROTECTED]
To: Nitin [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Wednesday, November 05, 2003 5:12 AM
Subject: Re: InnoDB Questions
Hello Nitin
yea, he's right, it may be error log file
Nitin
- Original Message -
From: Chris Nolan [EMAIL PROTECTED]
To: Leo Huang [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Wednesday, November 05, 2003 5:53 AM
Subject: Re: InnoDB Questions
The last one you're referring to - could
yes, syntax is bit diff.
INSERT into table1(column list) select a, b, c, d from table2 where
condition);
Enjoy
Nitin
- Original Message -
From: Lay Hoon Tan [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, November 04, 2003 11:36 AM
Subject: Inserting values via a SELECT
query seems perfect, what error is this giving?
Nitin
- Original Message -
From: Jim Bartram [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, November 04, 2003 10:07 AM
Subject: Adapting a Select statement to MySQL
I've got the following select statement that is defeating me
that will be recognized very well, just check the file ownership after
copying directory and files. all the data directory and files should be
owned by mysql only
Nitin
- Original Message -
From: [EMAIL PROTECTED]
To: MySQL List [EMAIL PROTECTED]
Sent: Wednesday, October 29, 2003 2:23
Easy, use:'select * INTO OUTFILE full path and file name
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY ''
LINES TERMINATED BY \n from user where race='chinese' and
state='US'Nitin- Original Message -
From: Pey Ling [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, October 28, 2003
you can use temporary tables if need to work on the resultset else use two
different queries. I think, that's the only option.
Nitin
- Original Message -
From: Victor Spng Arthursson [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, October 28, 2003 2:59 PM
Subject: Re: alternate
no, it'll save it in the data directory of the database only, reason is
mysql doesn't have permission to write to any other directory.
full path and file name could be just file name like data.txt or full
path of that directory like /var/lib/mysql/db_name/data.txt
Nitin
- Original Message
I accept, that i was wrong, but you need to have a better look too. ALL is
as good as ALL PRIVILEGES.
- Original Message -
From: Patrik Fimml [EMAIL PROTECTED]
To: Nitin [EMAIL PROTECTED]; Victoria Reznichenko
[EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Tuesday, October 28, 2003 6:23 PM
dont really understand it.
Any ideas?
Anyway thanx again for your great help.
Nitin
- Original Message -
From: Brad Teale [EMAIL PROTECTED]
To: 'Dan Greene' [EMAIL PROTECTED]; Nitin
[EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Wednesday, October 29, 2003 1:39 AM
Subject: RE: Ancestry
i dont think there's any privilege called ALL PRIVILEGES. You need to say
just ALL, like:
GRANT ALL ON *.* TO [EMAIL PROTECTED] IDENTIFIED BY
'12345678' WITH GRANT OPTION;
GRANT ALL ON *.* TO newuser@% IDENTIFIED BY '12345678' WITH
GRANT OPTION;
Enjoy
Nitin
- Original Message -
From
you can either erase the previous installation and then install the newer
one or simply upgrade the previous one.
- Original Message -
From: Manjit Patel [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, October 27, 2003 8:02 PM
Subject: Changing rpm installation to binary version
of course, the syntax is:
insert into db3.table2 (column list) select column list from db1.table1
for more information have a look at
http://www.mysql.com/doc/en/INSERT_SELECT.html
Enjoy
Nitin
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, October
u mean, in MySQLFront or other program
- Original Message -
From: Krystan Daxner [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, October 27, 2003 8:46 PM
Subject: Changing table properties
I have a program running with MySQL as the database. I have MySQLFront
running as my
You are using the wrong syntax, try
SELECT table1.* FROM table1 LEFT JOIN table2 ON table1.id=table2.id WHERE
table2.id IS NULL;
The query, you are using produces cross join while you need to implement
left join for your problem.
Enjoy
Nitin
- Original Message -
From: Larry Brown
with any other person in the tree. Though, I can design a simple
database, where everything will have to be done through queries and scripts, but I
want those queries to keep as simple as possible.
Any help will be appreciated, as I'm new to such a problem.
Thanx in advance
Nitin
:
INSERT INTO host
VALUES('localhost','database_name','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','
Y','Y');
Enjoy
Nitin
- Original Message -
From: Rob [EMAIL PROTECTED]
To: 'Gregory Norman' [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Friday, October 17, 2003 2:26 PM
Subject: RE: error
it could better be like
SELECT * FROM list WHERE name in ('$this1', '$this2', '$that1')
Nitin
- Original Message -
From: Colleen Dick [EMAIL PROTECTED]
To: Mike At Spy [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Thursday, October 16, 2003 10:14 AM
Subject: Re: OR in MySQL statement
Mysql-shared-compat
available at
http://www.mysql.com/downloads/mysql-4.0.html
for more information take a look at
http://www.mysql.com/doc/en/Linux-RPM.html
Enjoy
Nitin
- Original Message -
From: Jeremy Zawodny [EMAIL PROTECTED]
To: Randy Chrismon [EMAIL PROTECTED]
Cc: [EMAIL
Dear Mr. Singh,
You need to install Mysql-shared-compat
available at
http://www.mysql.com/downloads/mysql-4.0.html
for more information take a look at
http://www.mysql.com/doc/en/Linux-RPM.html
Enjoy
Nitin
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent
all encryption functions are one way only
Nitin
- Original Message -
From: Manisha Sathe [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, October 16, 2003 6:46 PM
Subject: Re: PASSWORD() function problem
thanks all, it works (i just increase it to 20)
but one more thing, now
1 - 100 of 122 matches
Mail list logo