Re: Data and strucuture importing from MSAccess to MySQL
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 Prakash On Sat, 29 Jan 2005 11:14:29 -0600, Tim Hayes [EMAIL PROTECTED] wrote: Suggest you download MYdbPAL from www.it-map.com . It is FREE, will do the complete import of structure and data for you (in next to no time) and you can carry on using it for modeling and database development. There is a great write-up this week at : http://blogs.ittoolbox.com/database/solutions/archives/002944.asp Tim Hayes -Original Message- From: Paun [mailto:[EMAIL PROTECTED] Sent: 29 January 2005 04:44 To: mysql@lists.mysql.com Subject: Data and strucuture importing from MSAccess to MySQL Which way is easier to import data and structure of database from MSAccess to MySQL. I know that there is several commercial softvare tools, but is there some open source tool or other way in MySQL itself? -- Sent via the WebMail system at regiononepdc.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
no duplicate entries..
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 -- Linux? If y a moins bien,mais c'est plus cher --Not by harsh http://www.cse.iitb.ac.in/~harsh -- On Mon, 21 Jul 2003, Adam Carmichael wrote: Worked like a charm! Thank you very much Sergei! :) Adam - Original Message - From: Sergei Golubchik [EMAIL PROTECTED] To: Adam Carmichael [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Sunday, July 20, 2003 10:04 PM Subject: Re: MySQL compiletime errors with --with-debug=full Hi! On Jul 20, Adam Carmichael wrote: Hello, I am trying to report a bug, and I would like to compile mysql with debugging enabled to provide further information, but I receive compile errors. I would like to resolve the compile errors before I report the possible bug I have discovered. I am running FreeBSD 4.8, and I attempt to compile mysql-4.0.13 with the following configure command: ./configure --with-vio --with-openssl --with-debug=full (the initial bug I wanted to report is related to openssl so compiling with the ssl and vio options is essential). I then try running 'make' but I get a lot of undefined reference errors - so I have piped the STDOUT and STDERR to a file available for download at: http://www.no1.com.au/~adamc/makeoutput.txt hoping that someone with more C/C++ knowledge than myself can offer some insight. Are you sure you compiled mysys/ with -DSAFE_MUTEX ? safe_mutex* symbols are defined in mysys/thr_mutex.c Regards, Sergei -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany ___/ www.mysql.com -- 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]
Re: MySQL Password
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 Jul 2003, Deependra b. Tandukar wrote: Thanks for your quick response dear harsh. I have the root privilege and forgot the MySQL password. Is there anyway to clear the password, or retrieve it? DT At 11:13 AM 7/2/2003, harsh wrote: 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 -- On Wed, 2 Jul 2003, Deependra b. Tandukar wrote: Dear all, I am running RedHat 7.2 with MySQL, Apache and PHP. I forgot MySQL password, how can it be retrieved? Looking forward to hearing from you all. Regards, DT -- 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] --- Deependra b. Tandukar International Centre for Integrated Mountain Development (ICIMOD) http://www.icimod.org -- http://www.prempanda.net http://www.mtnforum.org/apmn http://www.hkh-friend.net/ http://www.pardyp.org http://www.southasianfloods.org/ http://www.icimod-gis.net/web/index.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Password
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, Deependra b. Tandukar wrote: access denied... DT At 11:56 AM 7/2/2003, harsh wrote: 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 Jul 2003, Deependra b. Tandukar wrote: Thanks for your quick response dear harsh. I have the root privilege and forgot the MySQL password. Is there anyway to clear the password, or retrieve it? DT At 11:13 AM 7/2/2003, harsh wrote: 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 --- --- On Wed, 2 Jul 2003, Deependra b. Tandukar wrote: Dear all, I am running RedHat 7.2 with MySQL, Apache and PHP. I forgot MySQL password, how can it be retrieved? Looking forward to hearing from you all. Regards, DT -- 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] --- Deependra b. Tandukar International Centre for Integrated Mountain Development (ICIMOD) http://www.icimod.org -- http://www.prempanda.net http://www.mtnforum.org/apmn http://www.hkh-friend.net/ http://www.pardyp.org http://www.southasianfloods.org/ http://www.icimod-gis.net/web/index.html --- Deependra b. Tandukar International Centre for Integrated Mountain Development (ICIMOD) http://www.icimod.org -- http://www.prempanda.net http://www.mtnforum.org/apmn http://www.hkh-friend.net/ http://www.pardyp.org http://www.southasianfloods.org/ http://www.icimod-gis.net/web/index.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Password
Well its not your fault,its actually confusing the documentation says run the mysqld command with the skip-grant-tables option but there is no such command available (atleast in my box) i found the command hidden in /usr/libexec/mysqld but that 2 gives error. safe_mysqld is indeed the command 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 made a litttle mistake (havent done it recently ). try the --skip-grant-tables option for safe_mysqld like this safe_mysqld --skip-grant-tables That should be doing it. Best regards Nils Valentin Tokyo/japan 2003年 7月 2日 水曜日 17:02、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, Deependra b. Tandukar wrote: access denied... DT At 11:56 AM 7/2/2003, harsh wrote: 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 Jul 2003, Deependra b. Tandukar wrote: Thanks for your quick response dear harsh. I have the root privilege and forgot the MySQL password. Is there anyway to clear the password, or retrieve it? DT At 11:13 AM 7/2/2003, harsh wrote: 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 --- --- On Wed, 2 Jul 2003, Deependra b. Tandukar wrote: Dear all, I am running RedHat 7.2 with MySQL, Apache and PHP. I forgot MySQL password, how can it be retrieved? Looking forward to hearing from you all. Regards, DT -- 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] --- Deependra b. Tandukar International Centre for Integrated Mountain Development (ICIMOD) http://www.icimod.org -- http://www.prempanda.net http://www.mtnforum.org/apmn http://www.hkh-friend.net/ http://www.pardyp.org http://www.southasianfloods.org/ http://www.icimod-gis.net/web/index.html --- Deependra b. Tandukar International Centre for Integrated Mountain Development (ICIMOD) http://www.icimod.org -- http://www.prempanda.net http://www.mtnforum.org/apmn http://www.hkh-friend.net/ http://www.pardyp.org http://www.southasianfloods.org/ http://www.icimod-gis.net/web/index.html -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- 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]
Re: Newbie SELECT problem
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 SELECT DISTINCT sessionID, userID, date, time FROM sti_tracking WHERE userID = 999 What I want is to have only records with the userID of 99 and where the sessionID is distinct (meaning only on of each session id). Neither sessionID nor userID are keys or unique. Obviously this isn't working. Can someone suggest how this should be done? Tim Winters Creative Development Manager Sampling Technologies Incorporated 1600 Bedford Highway, Suite 212 Bedford, Nova Scotia B4A 1E8 www.samplingtechnologies.com [EMAIL PROTECTED] [EMAIL PROTECTED] Office: 902 450 5500 Cell: 902 430 8498 Fax:: 902 484 7115 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Newbie SELECT problem
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:http://lists.mysql.com/[EMAIL PROTECTED]
Re: The file /usr/local/mysql/libexec/mysqld doesn't exist or is not executable
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] wrote: Hi, I got the following message when trying to start the mysql instance: $ mysqld_safe [1] 22717 $ The file /usr/local/mysql/libexec/mysqld doesn't exist or is not executable Please do a cd to the mysql installation directory and restart this script from there as follows: ./bin/mysqld_safe. --- Can anyone help me to resolve this? It is emergency. Regards, song -- 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]
A quick help
Two databases data1 data2 data1 has table1 and data2 has table2 both the tables have uid field common I want to list out common uid's from table1 annd table2 Tried many commands as i understood from documentations but somewhere i m always wrong. thanks regards -- 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]
Re: MySQL Password
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 -- On Wed, 2 Jul 2003, Deependra b. Tandukar wrote: Dear all, I am running RedHat 7.2 with MySQL, Apache and PHP. I forgot MySQL password, how can it be retrieved? Looking forward to hearing from you all. Regards, DT -- 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]
The quote ' problem...
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://lists.mysql.com/[EMAIL PROTECTED]
select and delete
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..:) -- 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]
Re: select and delete
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 name='harsh'; DELETE from data where name='harsh'; -- harsh http://www.cse.iitb.ac.in/~harsh -- -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ -- 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]
mysql ARRAY's
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 -- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Just a doubt.....
Hi, I made a table with a primary key,and all the columns i declared char got converted into varchar. plz someone throw a light on it as i had seen somewhere that using primary key increase search speed and using varchars decrease so im in confusion. :( -- 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
i want to write a web-based chat application in Perl which runs on Unix server with mySQL as backend. The application needs to continouly interact with database hence instead of opening a DBI connection in each perl page, I wish to keep a live open connection with database. Is it possible ? 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 !!! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
what is the sql query ?
I have a table1 in mySQL with the following recordset : +++-+ | siteno | deptid | agentid | +++-+ | 0 | 27 | 35 | | 0 | 25 | 30 | | 0 | 19 | 30 | | 0 | 19 | 26 | | 0 | 20 | 26 | | 0 | 19 | 27 | +++-+ Now I want to retrieve the distinct agentid's belonging to deptid 19 along with their respective counts of how many departments do they belong to. Once again I repeat, I want to retrieve the agentids and their count of departments where the minimum condition to be satisfied is that agent must at least belong to deptid 19. Thus the resultset which I want to generate must look like this : ++-+ | count | agentid | ++-+ | 2 | 30 | | 2 | 26 | | 1 | 27 | ++-+ 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 send mails in your own language !!! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php