DATABASE PROBLEM
HI! there is a problem in mysql database.there r two tables.one table is named as transactions and the other is named as the code.the transactions table has got the 12 fields which r the following 1.clientid int 2.date date 3.isinno text 4.debit int 5.credit int 6.desc text 7.dpid1 text 8.nsdlid int 9. desc1 text 10. desc2 text 11. dpid bigint 12.transno int All these fields r by default NULL the code table has got the 8 fields which r the following 1.rd smallint 2.transno int 3.status tinyint 4.status1 tinyint 5.cdate date 6.clientid int 7. isinno text 8.description text . All these fields r by default NULL I am writing this query but its not giving the recquired results i.e i want it should pick up the all the fields of both the tables without any duplicate enteries. SELECT * from transactions,holdings,code where transactions.clientid=holdings.clientid and transactions.isinno=code.isinno and transactions.isinno=' INE561A01013' and transactions.transno='4509'AND FROM_DAYS(transactions.date) - TO_DAYS(holdings.hdate) group by transactions.credit,code.description Basically the problem with the above query is that its giving the duplicate enteries . plz. solve my problem at the earliest.its very urgent. = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do you Yahoo!? New DSL Internet Access from SBC Yahoo! http://sbc.yahoo.com - 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
Provider reqd. for myODBC
Glory! I'm looking for a Provider for the myODBC Driver to connect my Visual Basic code with my mySQL database. I have in kknowledge one such provider known as MSADSQL..but niether do i know where to find it nor do i know whether it's the right thing or not. T. Edison Jr. __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com - 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
How to Connect two mySQL Tables
Hi, If i have two seperate mySQL Tables in my database, with some information.. and i would like to connect the two tables so as to get Relevant Data picked up from the relevant Table and it's relevant fields. Do we need to use a Foriegn/Primary key for this purpose? If so, how do you use them? I coudln't find a suitable description on using the Foriegn Keys in the mySQL Manual. Thanks, T. Edison Jr. __ Do You Yahoo!? Sign up for SBC Yahoo! Dial - First Month Free http://sbc.yahoo.com - 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
Connectiing mySQL db on Localhost to mySQL DB on Server
Hi, I would like to export Table Data which is on my localhost mySQL Server, to a Table in mySQL on the Internet Web Server. How can i do that? Basically it's just moving mySQL Table Data from localhost to web server on the internet! Is it possible? if so, how? Thanks, T. Edison Jr. __ Do You Yahoo!? Sign up for SBC Yahoo! Dial - First Month Free http://sbc.yahoo.com - 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
Remote Host Connection/Software on Web : Accessing mySQL
Hi, Basically we have created a Software in Visual Basic. Now the software uses mySQL on the internet as Backend. However, our server does not allow Remote Host Connection, which means we cannot access our mySQL Database on the Internet by our Software on a local client. We need the mySQL Database on the Internet because basically everything will be available on a website later through PHP Pages. Now, my problem is how to connect to my mySQL DB on the Internet, via my Software, when my Server Company doesn't allow Remote Host Connection to mySQL. What is suggested to me is to place the Software on the Internet. I have no clue how to do that. Because if i place an .exe file on the net, it will just start downloading instead of running. How then can i accomplish this? The software feeds in Data in the mySQL DB on the internet, and then the PHP pages access the mySQL DB to show data to users on the Website. It's something like that. The software involves a lot of processing, decryption, conversion etc. to convert a .dat data into usable mySQL Tables Data. Hope somebody can help. Thanks, T. Edison Jr. __ Do You Yahoo!? Sign up for SBC Yahoo! Dial - First Month Free http://sbc.yahoo.com - 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
using .dat SQL Data in mySQL DB
Hi, I have a .dat file.. with some data like this : 02001IN00100213200207120020412200204122002041710002002041720020417 02002IN00100213200207220020415200204152002041810002002041820020418 02003IN00100213200207320020416200204162002041910002002041920020419 This data was exported via SQL Server.. using Oracle. I need to use this data in my mySQL Database and work on it through PHP. Can i use phpMyAdmin for this.. or some other method? Thanks, T. Edison Jr. = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ - 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
Excel to MySQL
How do i import MS Excel Data into MySQL Tables?? T. Edison jr. = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy Awards® http://movies.yahoo.com/ - 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
Importing Tables Data into MySQL from Access
Hi, I'm looking to Import complete MS Access Table with Data into a MySQL Database. How can i do that? Especially if i have to do it for a site on the internet... Thanks, T. Edison Jr. __ Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy Awards® http://movies.yahoo.com/ - 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
RE: Importing Tables Data into MySQL from Access
I actually tried this just a few moments ago and it worked! But thanks! T. Edison jr. --- Andrew Hazen [EMAIL PROTECTED] wrote: Print out a documentation of the Access database. Use phpMyAdmin interface to build the same table structures in MySql. Export Access tables as comma separated values files. Use phpMyAdmin to insert text files into each table. Voila! Andrew Hazen -Original Message- From: Thomas Edison Jr. [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 26, 2002 12:52 PM To: [EMAIL PROTECTED] Subject: Importing Tables Data into MySQL from Access Hi, I'm looking to Import complete MS Access Table with Data into a MySQL Database. How can i do that? Especially if i have to do it for a site on the internet... Thanks, T. Edison Jr. __ Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy Awards® http://movies.yahoo.com/ - 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 = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy Awards® http://movies.yahoo.com/ - 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