select last row

2005-02-14 Thread Mulley, Nikhil
Hi All,
I have a table which is being continuosly updated, I just wanted to know how to 
output only the last row with the select statement.
can anyone please tell me howto.
thanks,
Nikhil

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



RE: Happy Thanksgiving Everyone!

2004-11-24 Thread Mulley, Nikhil
I wish you all a very good and cherishable 'Thanks Giving' to all the people in 
this list and and all the contributors to MySQL all over the World.

Once Again Thanks :)

Warm Regards,
Nikhil.

-Original Message-
From: Scott Hamm [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 24, 2004 10:24 PM
To: 'Mysql ' (E-mail)
Subject: Happy Thanksgiving Everyone!


I wish everyone a good and fateenin' Thanksgiving from United States!

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Syncing of Data

2004-11-19 Thread Mulley, Nikhil
Hi List,
 
I have  a MySQL Data running on one Linux Server in my Intranet , 
I would like to have all the Databases and tables synced to MySQL Server 
running on Windows Server .
 
How to Sync the data , or just copy the table from one machine to another 
machine.
 
Does MySQL have any  * Export * Queries to export the data from the Table ( 
MySQL running on Linux )  into a small file and later using that that file , 
can we load the data from the file into the table in MySQL running on Windows.
 
If yes, can you tell me how please.
 
Thanks,
Nikhil.
 
 


Replication of Data

2004-11-10 Thread Mulley, Nikhil
Hi Chums,
Can any body tell me if the following case is possible ?
Actually , I have Oracle Server , and I want to replicate the  data across 
the other servers, but at the other end ( replicated servers)  , I want to have 
MySQL Database Server too, and 
What all I wanna know is if it is possible to sync the data from Oracle 
Database to MySQL Database Server , If yes Can you tell me the way or the 
instructions to tell me how  ? :)
 
Or Else , Can any body tell me the procedure from migrating the database from 
Oracle to MySQL Server ?
 
 
--NIkhil


BLOB datatype

2004-11-04 Thread Mulley, Nikhil
Hi List,
 
Can any one show me the practical query of creating a table which should contain a 
column with BLOB Datatype.
 
 
--Nikhil.


How can I store Images in the MySQL Database

2004-11-01 Thread Mulley, Nikhil
Hi Lists ,
 
My Query is How Can I store Images in the MySQL Database , and how to Index them , 
can anybosy help me on this please
 
I am starting out a Online Photo Gallery and want to share them , and I want to 
make the search available, Does anybody has already done on this ?
 
Please help me in this.
 
Regards,
Nikhil.


Dumping Select statement output onto a text file

2004-10-28 Thread Mulley, Nikhil
Hi List,
 
How do I dump the data from console to the text file from the output generated by 
SELECT statement ?
 
 
Thanks,
Nikhil.


How many UNIQUE Columns per table

2004-09-16 Thread Mulley, Nikhil
Hi all,
 
I have a query ,
 
Please can someone just tell me the details of restrictions on how many maximum no of 
UNIQUE Columns can be there per table
and how many maximum PRIMARY KEY Columns,HOW many maximumum AUTO_INCREMENT Columns can 
be there per table