Re: Data and strucuture importing from MSAccess to MySQL

2005-01-29 Thread Harsh Prakash
Paul: For database conversion, take a look @: [http://access2sql.sourceforge.net/] or [http://sourceforge.net/projects/dbconverter/] For database modeling and development, try: [http://www.fabforce.net/dbdesigner4/] and [http://www.gnome.org/projects/dia/] All of these are free utilities. Harsh

no duplicate entries..

2003-07-20 Thread harsh
Hi all, How do i do this ? i have a table with one of the column named uid, Now i want to insert a new row,only if no other row exist with the uid i m trying to insert. I hope its clear. thanks for any reply . harsh

Re: MySQL Password

2003-07-02 Thread harsh
mysqladmin password secret should work if not then mail i'll work out a bit and reply. -- harsh http://www.cse.iitb.ac.in/~harsh -- On Wed, 2

Re: MySQL Password

2003-07-02 Thread harsh
I m sorry ,try the earlier solution posted by someone else i.e to restart mysql server with grant tables disabled.and then reset the password. that;s the only method given in the documentation 2 at mysql.com,though i cdn't get it working. again sorry for misdirections harsh On Wed, 2 Jul 2003

Re: MySQL Password

2003-07-02 Thread harsh
for this,thanks for the help harsh -- harsh http://www.cse.iitb.ac.in/~harsh -- On Wed, 2 Jul 2003, Nils Valentin wrote: Hi harsh, perhaps I

Re: Newbie SELECT problem

2003-07-02 Thread harsh
select sessionID,userID,date,time from sti_tracking where userID=99 group by sessionID; hope that works ,though i didn't clearly got your question,may be some expert suggest better regards harsh On Wed, 2 Jul 2003, Tim Winters wrote: Hello everyone, I have the following select statement

RE: Newbie SELECT problem

2003-07-02 Thread harsh
Table name sti_tracking hitID (primary key) (autonumber) userID sessionID date time pageName this might work select userID,sessionID from sti_tracking where userID=999 group by sessionID; -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Re: The file /usr/local/mysql/libexec/mysqld doesn't exist or is not executable

2003-07-02 Thread harsh
I found that file in /usr/libexec/mysqld hope that helps -- harsh http://www.cse.iitb.ac.in/~harsh -- On Wed, 2 Jul 2003 [EMAIL PROTECTED

A quick help

2003-07-01 Thread harsh
-- harsh http://www.cse.iitb.ac.in/~harsh -- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

Re: MySQL Password

2003-07-01 Thread harsh
You can set password again using root and mysqladmin command.try mysqladmin --help. correct me if i m wrong regards -- harsh http://www.cse.iitb.ac.in/~harsh

The quote ' problem...

2003-06-30 Thread harsh
I have to take a text input from users and store it in table,to avoid ' error i can replace ' with \', is there any other solution as that might slow down the process ? harsh -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

select and delete

2003-06-28 Thread harsh
Hi, I need to perform a query which deletes the selected results from the table, like SELECT * from data where name='harsh' (here i want something to delete it as well) if its possible with single query... thanks for help

Re: select and delete

2003-06-28 Thread harsh
thanks for help..:) It sounds as though you really want something more like this: DELETE FROM data WHERE name='harsh'; That will only result in deletion,I want it to be displayed and simultaneously deleted.more precisely the effect of following two commands in one SELECT from data where

mysql ARRAY's

2003-05-30 Thread harsh
Is there an ARRAY data type in mysql ??? I cdn't find it in documentation,but my java book shows SQL has support for Arrays ..:( Someone help??? regards -- harsh http://www.cse.iitb.ac.in/~harsh

Just a doubt.....

2003-05-28 Thread harsh
. :( -- harsh http://www.cse.iitb.ac.in/~harsh -- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

can i keep a connection to the database open

2001-06-07 Thread Harsh
? If yes, how ? Pls reply to my email id : [EMAIL PROTECTED] Reagrds harsh http://mail.indiainfo.com First you had 10MB of free mail space. Now you can send mails in your own language

what is the sql query ?

2001-06-04 Thread Harsh
| ++-+ PS : The agent no 25 has not come because he does not hv any association with deptid 19. Can anybody pls give me the SQL query to generate the above resultset ? Regards Harsh http://mail.indiainfo.com First you had 10MB of free mail space. Now you can