RE: transaction support
Hi Chris, My apologies, I didn't correctly explain what I was looking for. I mean more of a solution to creating a client program. I'm thinking of php-gtk but not sure how well this works under windows, especially for printing reports. Thanks, Bryan On Sat, 17 Jan 2004, Chris Nolan wrote: Hmm...have you looked at Rekall? www.total-rekall.co.uk Also, you might want to check out OpenOffice.org's database interface features Regards, Chris -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ISP and users
Hello, I run an ISP where our web customers have access to the MySQL server. When they want a database, they request it through me and I add it. I was just curious if this is the common way it is done, or if there is a safe way they can add their own? Thanks, Bryan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: transaction support
I wanted to thank everyone for their responses and information regarding this. I apologize, I thought I had already replied. Anyhow, I proved my point to our software guy, enough that he is willing to look into it further. Although I have a feeling he isn't going to want to do it (but at least he sees what MySQL can do) so I'll probably be trying to do it myself. So if anyone knows of a way to get a full interface under windows (that can print nice invoices) and has a direct brain-input for learning, let me know :) Thanks again, Bryan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
transaction support
Hi, I'm trying to get a software designer to write us some software using MySQL as the database server (he currently requires MS SQL). It is all windows based software (written in VB). So far his arguments against it are this (not my words): -No explicit transactional support -MySQL is still buggy -MyODBC is buggy and not used in production environments -Only way to connect using ODBC is third party drivers that cost over half as much as MS SQL This is just for our current software, the new software he is bidding on says he would use .NET so that supposedely causes other problems. Now, I know there are a few discrepancies there but I just don't know enough to argue it. I * need* to use MySQL as the server because of cost reasons. I *WANT* to use MySQL because I don't care for MS choose not to run their products. If you can give me any information to help me argue this I would really appreciate it. Thanks, Bryan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: transaction support
On Mon, 5 Jan 2004, Craig Vincent wrote: Although this doesn't answer your initial request...why are you wanting to 'argue' with this guy over the database to use. If he won't code for the application to use MySQL (which isn't all that hard in VB regardless of what he says) then get another coder...as simple as that. There's a plethora of coding contractor sites out there any of which probably have a good base of coders with the skills you need capable of coding your software using VB and MySQL. Craig (and others) It's a good question and implied by Daniel as well. I should have stated the reason in the beginning. The coder is not only an old employee but a good friend as well, and basically writes the software in exchange for discounts on computer parts. While he is set on M$ stuff, he has always been open to MySQL to a point. The problem is he is perfectly comfortable with M$ products and just doesn't see the need to look at MySQL. Here is the explanation I just received when asking for the difference between transaction support: - MySQL uses single-action implicit and explicit transactions, but they do not automatically roll back on failure. SQL Server user single action implicit and batch explicit transactions as well as supporting transaction nesting (transactions inside of parent transactions) and on failure the entire batch and any parent / peer transactions are rolled back. EXAMPLE (bank transfer): [SqlServer] 1: BEGIN TRANSACTION 2: WITHDRAW $50 from account 32146. 3: DEPOSIT $50 into account 12345. 4: LOG transfer (date/time/teller/etc...) for auditing. 5: COMMIT TRANSACTION if this failed at step 3 due to an error, every change would be undone including the withdrawal and everything would be ok. The transaction could be retried later. [MySQL] 1: START TRANSACTION 2: WITHDRAW $50 from account 32146. 3: DEPOSIT $50 into account 12345. 4: LOG transfer (date/time/teller/etc...) for auditing. 5: COMMIT TRANSACTION if this failed at step 3 the transaction would be hung and even if rolled back by server admin the money would still be gone from account 32146 --- Is this actually correct, or is it correct but there is a different way to do this with MySQL? Thanks, Bryan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Invoicing (paper)
Hello, I think this is fairly on-topic, but does anyone know of or use a [free] invoice program that uses MySQL? I need to setup something for my Dad that is quick and easy to use. Doesn't need to have all that much, just simple things, as I would probably modify it down to what it needs to be. Thanks, Bryan - 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: What is needed for ODBC?
Thank you! I suppose I should have tried it first, I was just assuming there was something more to be done. Works great! Thanks, Bryan On Fri, 21 Feb 2003, KH Chiu wrote: |All you need to do is set up a MySQL user that allow the Windows box to |access the MySQL database. | |Regards, | |KH - 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: decimal type
Hello, I'm creating a table where one column will be prices. How is this type supposed to work? I tried it, loaded the data, and it cuts it off at the decimal when I run a query. How can I get this to store correctly? Thanks, Bryan - 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: decimal type
My Apologies, table name is pricelist with 2 colums: create table pricelist (product varchar(45), cost dec); then load data infile /home/omni/OmniPrice.csv into table pricelist fields terminated by ','; the datafile looks like this Jaton Modem,15.5 Teac Floppy,7.5 Celeron 1.7,54.5 Logitech KB,11 but a query returns this: mysql select * from pricelist; +-+--+ | product | cost | +-+--+ | Jaton Modem | 15 | | Teac Floppy |7 | | Celeron 1.7 | 54 | | Logitech KB | 11 | +-+--+ 4 rows in set (0.00 sec) I read the docs on the decimal type, but I dont quite understand it. Thanks, Bryan On Fri, 21 Feb 2003, gerald_clark wrote: |Show us. |We have no idea how you defined your tables, |loaded your data, or structured your query. | |Bryan Koschmann - GKT wrote: | - 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 needed for ODBC?
Hello, I hope it is okay to ask this here. I have a MySQL server running on Slackware 8, and I would like to access it from a Windows box using Excel (for now). I'm downloading the ODBC driver for windows, but is there anything I need to do on the MySQL server side? I'm a bit confused about that. Thanks in advance! Bryan - 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
hints for converting to mysql
Hello, Does anyone have any pointers or links to how-tos for converting from a microsoft sql server to mysql? I know it's much more complicated than simply converting, but I was just looking for pointers. Basically we have an accounting system that was written for us by an employee. Hes a Microsoft guy, I'm a Linux guy. He wrote it all in VB and accesses the database via ADO. I would like to start using a mysql server on our linux box, and he is willing to help re-write the software. Initially he said he couldn't use MySQL because he needed transactional support but MySQL max takes care of that AFAIK. Other than that it is a fairly basic system. So if anyone has done this before or has any tips/hints/etc I would love to hear the info! Thanks, Bryan - 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
padding field with zeros
Hi, Does MySQL provide for any way to pad a field? I have accounts numbers that vary from 3-5 digits, and would like them 8 digits padded by zeros (479 becomes 0479, 17234 becomes 00017234, etc). I know I could probably write a script to fix that before entering the data into the database, but I just wanted to know. Or maybe there is a way to pad it while doing the query select? Thanks, Bryan - 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
OT? mysql_init error w/ perl
Hello, I'm sorry for posting this here. I tried the msql-mysql-modules list but mine was the only message posted within the past few days, so I doubt I'll be getting any help :) I am getting the following error while trying to run a perl script to access some information. DBD::mysql seems to have installed properly. The script is very simple, just to query for a COUNT in a small table. Can anyone tell me how to fix this? Thanks in advance, Bryan /usr/bin/perl: error while loading shared libraries: /usr/lib/perl5/site_perl/i386-linux/auto/DBD/mysql/mysql.so: undefined symbol: mysql_init - 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: Creating new users
On Wed, 18 Sep 2002, Shravan Durvasula wrote: |Hi all, |I have MySQL server installed in Solaris 2.8. |1. How can i change the existing password for a user? |2. How can i delete an existing user? |3. How can i create a new user and associate a |password for that new user? I believe the documentation (below the tutorial portion) tells exactly how to do all of this. I am new to MySQL, and use this all the time. Well, trying to use it less and less :) http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Database_Administration.html#User_Account_Management (watch the wrap) Bryan - 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
ODBC ADO and microsoft
Hi, We have an accounting program that was writting in visual basic and runs on microsoft sql. I was told it uses ADO by the programmer (please note, I'm not all up on this subject as I should be). I'm wondering if it would be possible to connect to it somehow from a mysql client and do some simple queries? Or am I going about this the wrong way? I haven't gotten him convinced yet to convert/port it to MySQL just yet, as he says MySQL isn't proven well enough yet *sigh* Yeah I know :) I believe he mumbled something about problems with transactional support and ADO. Any help would be great! Thanks! Bryan - 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
Looking for opinion
Hello, I'm new to this list, and actually rather new to MySQL. I am still in the process of learning, but I wanted an opinion on something... I was curious what you would all think of creating a rather simple checkbook register using mysql? From my (rather limited) knowledge, it would seem fairly easy to do, and have the ability to create graphs, web access, whatever. Does this seem stupid to anyone? Has it already been done (can't find anything)? I would appreciate any input on this. Thanks in advance! Bryan - 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