, 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
wrote:
Hi to all,
For many days, I am struggling with the problem of
Friday, April 5, 2013 11:26 AM
Subject: Re: MySQL on RHEL4
On 2013-04-05, Nitin Mehta 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.
e 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: A
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 u
. 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
To: mysql@lists.mysql.com
Sent: Sunday, September 23, 2012 7:51 AM
Subject: Mysql cluster
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 = '')
INNER JOIN produ
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"
To: Nitin Mehta
Cc: "mysql@lists.mysql.com"
Sent: Thursday, May 3, 2012 3:17 PM
Subje
u find a suitable one.
Hope that helps!
Regards,
____
From: "Brown, Charles"
To: Nitin Mehta
Cc: "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 main
log on master and use
"replicate-do-table" 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, Charle
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 s
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 to
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
To: win.a
Cc: "mysql@lists.mysql.com"
Sent: Wed, September 8, 2010 3:57:40 PM
Subject: Re: mysql
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
name (of database in your case).
Hope that helps.
Regards,
Nitin
From: Manasi Save
To: "mysql@lists.mysql.com"
Sent: Sat, September 4, 2010 12:06:27 PM
Subject: mysqldump error 1064 for database Use command
Hi All,
I have 10 mysql databases all
ible to achieve this within MySQL conf itself.
Thanks in advance!
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.
Rega
Hope that helps!
Regards,
Nitin
From: Machiel Richards
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 to determine the si
Thanks, Prabhat! You're very right, but did you read the questions I asked?
From: Prabhat Kumar
To: Nitin Mehta
Cc: mysql@lists.mysql.com
Sent: Tue, May 11, 2010 11:54:22 AM
Subject: Re: starting multiple instances with mysqld_multi
Hi,
You ca
hich I'm
not aware of?
If you have resolved these issues, please let me know.
Best Regards,
Nitin
e SQL 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
To: mysql@lists.mysql.com
Sent: Tue, May 4, 2010 3:49:35 AM
Subject: mysql transaction log
Please help me to under
Is mysql the owner of the directories?
- Original Message
From: Manasi Save
To: Johan De Meersman
Cc: Waynn Lue ; mysql
Sent: Wed, November 25, 2009 8:12:25 PM
Subject: Re: question regarding mysql database location
Dear Johan,
Need your help again in understanding How mysql reads
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:
>
>
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 'd
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]>; "
ow 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
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,
>
>
> Thoughts?
>
> thanks
>
> alan
>
> --
> Alan Williamson, City Planner
>
> w: http://www.BLOG-CITY.com/
> e: [EMAIL PROTECTED]
> b: http://alan.blog-city.com/
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysq
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)
&
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 proble
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: Fri
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 "
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 h
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: <
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 f
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
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: <[EMA
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: <[EMA
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: "electro
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: F
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"
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: Tu
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(S
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
Subje
x27;,
signpass varchar(12) NOT NULL default '',
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:
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
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: tabl
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:
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) w
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 -
Fro
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
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
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
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: &
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
I'm using it with PHP, but what I'm looking for is, the query syntax, not
the language feature.
Thanx anyway
- Original Message -
From: "robert_rowe" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, January 07, 2004 9:04 PM
Subject: Re: How to find if the value returned is nu
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 >val
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
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 P
- 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
>
>
>
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
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&quo
right now, u r trying to connect t omyql with uer abc, not creating it.
to create user abc
grant 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
--
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 fi
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
>
>
>
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
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, Decem
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.
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
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 SQ
dia, it says,
Insert vol 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
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 Quest
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, Novembe
a.
For more info, have a look 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
>
> ---
start.html
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 j
pe 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
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 foll
yes, syntax is bit diff.
INSERT into table1(column list) select a, b, c, d from table2 where
);
Enjoy
Nitin
- Original Message -
From: "Lay Hoon Tan" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, November 04, 2003 11:36 AM
Subject: Inserting values
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: Wedne
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 PROT
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]>
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_na
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 Spång Arthursson" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, October 2
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
lationship 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
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
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
of course, the syntax is:
insert into db3.table2 (column list) select 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 PROTE
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 versi
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'
yntax like:
INSERT INTO host
VALUES('localhost','database_name','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','
Y','Y');
Enjoy
Nitin
- Original Message ---
version, which doesn't support union and for other functions you want to
perform on some rows selected from multiple tables.
Enjoy
Nitin
- Original Message -
From: "Susan Ator" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, October 16, 2003 7:39
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
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 PROTECT
1 - 100 of 123 matches
Mail list logo
