Hi There !
I am quite new to this MyODBC topic, though I am used to create Perl
programs connecting to MySQL DBs. Currently I am able to fetch rows from the
DB via MyODBC and show them in a blank document as a table.
Usually this is how I add data into my documents (like invoices, etc.):
I
Hello again all,
Greetings from Scotland.
Can anyone direct me to where I can get some free software which will
convert an MS Access database to My SQL.
Thanks,
James Oliver
-
Before posting, please check:
Hello again all,
Greetings from Scotland.
Can anyone direct me to where I can get some free software which will
convert an MS Access database to My SQL.
Thanks,
James Oliver
-
Before posting, please check:
I Scotland,
It's not the first time i give this adress:
http://www.urbanresearch.com/software/utils/urbsql/
Hope This Help ;)
theOtherOne
- Original Message -
From: oliverjd [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, January 26, 2002 3:34 AM
Subject: Converting MS Access
Jeremy Zawodny writes:
On Fri, Jan 25, 2002 at 03:40:37PM +0200, Sinisa Milivojevic wrote:
Hi!
There is a wide choice.
You can use either admin modules of mysqlgui or mysql module in
MOODSS.
Depends on what exactly you need, and on your taste ...
If you'd rather use
Mike Nelson writes:
Any plans to upgrade the MyODBC driver to support .NET?
I downloaded a copy of MySQL and tested it with a .NET app and received an
error that this version of ODBC wasn't supported. Just wondering if this is
on the development horizon.
Hi!
We are in the planning stage
I have instaled MYSQL on Solaris 2.8 on Intel plataform, and did this
as says the manual, but when try to run it sends a message :
Segmentation fault - core dumped
# bin/safe_mysqld --user=mysql
# Starting mysqld daemon with databases from /usr/local/mysql/data
Segmentation Fault - core dumped
hi!
Jeremy == Jeremy Zawodny [EMAIL PROTECTED] writes:
Jeremy On Fri, Jan 18, 2002 at 12:40:00AM -0800, Simon Kirby wrote:
MySQL appears to be having problems walking backwards on the index when
starting from a known row.
On the web documentation, it looks like this is supposed to
Hi, I am new to this list and was wondering if someone can help me.
I am running very simple SQL through PHP and mySQL to connect to a
database, add data to it, and display this data. This will eventually be
used for a guestbook for my organization, the New York Skyliners Sr. Drum
and Bugle
can anyone recommend a command line shell to admin mysql that will run
under osX? thanks in advance!
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the
At 12:36 -0500 1/26/02, Lisa M. Venezia wrote:
Hi, I am new to this list and was wondering if someone can help me.
I am running very simple SQL through PHP and mySQL to connect to a
database, add data to it, and display this data. This will
eventually be used for a guestbook for my
At 9:42 -0800 1/26/02, mike vogel wrote:
can anyone recommend a command line shell to admin mysql that will
run under osX? thanks in advance!
What does that mean? From the wording of the question (command line shell),
it sounds like you're asking about tcsh, bash, etc., but from admin mysql
At 12:51 PM 1/26/2002 -0800, you wrote:
I Scotland,
It's not the first time i give this adress:
http://www.urbanresearch.com/software/utils/urbsql/
Hope This Help ;)
theOtherOne
It looks like urSQL allows you to view data from various database
formats. Does it handle data conversion as
Okay - that was silly of me. I was checking the return values of the
insert and the select, but I never did one for the connect.
It's failing on the connect - I'm assuming that all I have to do is ask
them what the proper way to connect to their database is.
Thanks for your help!
Lisa
At
At 9:59 -0800 1/26/02, Ed Lazor wrote:
At 12:51 PM 1/26/2002 -0800, you wrote:
I Scotland,
It's not the first time i give this adress:
http://www.urbanresearch.com/software/utils/urbsql/
Hope This Help ;)
theOtherOne
It looks like urSQL allows you to view data from various database
formats.
I am sure Paul would not plug his own book, but I will it would help
to have a practical example to follow, so I recommend the book
MySQL by Paul Dubois, published by New Riders (check Amazon.com or
your local computer book store).
This will help you with error checking. I know it helped me!
Hi,
-Original Message-
From: Mike Nelson [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 25, 2002 11:43 PM
To: [EMAIL PROTECTED]
Subject: MyODBC
Any plans to upgrade the MyODBC driver to support .NET?
I downloaded a copy of MySQL and tested it with a .NET app and received
Hi, guys!
Sorry not to provide you with a complete bug report, but it's indeed
the huge amount of time needed to provide you with a clever bug
report and it's maybe clear enough case.
This bug appeared right after 3.23.43 version, up to this all tests
were passed just fine. Since 3.23.44 and up
Using MySQL 3.23.47, is the best data type for small currency
float(4) ? This is for prices of items in a shopping cart for example
t-shirts.
What is the difference in using float vs decimal? I know I don't need double.
--
Michael
__
||| Michael Collins |||
||| Kuwago Web Services
On Sat, Jan 26, 2002 at 07:53:35PM +, John Murdie wrote:
I'd like to see an explicit statement that it is possible to install
a binary distribution of MySQL in some non-standard place, or not,
as the case might be. If it *is* possible, I'd like to see full
instructions for doing this.
On Sat, Jan 26, 2002 at 08:11:12PM +, Paul Reilly wrote:
Hi MySQLers,
What's the best data type to use for a text field of say 500 words
(~5000 chars)? Can I use VARCHAR(5000) or should I use TEXT or
MEDIUMTEXT?
Also whats the best column type for a binary upload of an image or
Michael Collins wrote:
Using MySQL 3.23.47, is the best data type for small currency float(4) ?
This is for prices of items in a shopping cart for example t-shirts.
What is the difference in using float vs decimal? I know I don't need
double.
Float has accuracy problems at large
Hi,
I apologize for this too basic question.
I installed MySQL using rpm. But I can't fine
mysql.h and mysql_config on my server. Where are they
from?
More Details:
Environment: MySQL server 3.23.46 and client 3.23.47
on RedHat7.2. MySQL database is running.
Objective: To install MySQL
I tried (and got back) this:
[mbase:~] ted% safe_mysqld
touch: /usr/var/mbase.err: No such file or directory
chown: mysql: invalid user name
Starting mysqld daemon with databases from /usr/var
/usr/bin/safe_mysqld: no such file or directory: /usr/var/mbase.err [229]
/usr/bin/safe_mysqld: no
Hi!
Sinisa == Sinisa Milivojevic [EMAIL PROTECTED] writes:
Sinisa Fournier Jocelyn [Presence-PC] writes:
Hi,
Yes it is 4.0.1.
But the first query has also to make a temporary table with 2 million rows,
it's why I don't understand the delta between the query without DISTINCT and
the
You're right Paul thoses product are realy good, thanx for theses
information.
theOtherOne
- Original Message -
From: Paul DuBois [EMAIL PROTECTED]
To: Ed Lazor [EMAIL PROTECTED]; theOtherOne [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Saturday, January 26, 2002 10:10 AM
Subject: Re:
What about converting MySQL data to Oracle ?
Thanks
Mark
-Original Message-
From: theOtherOne [EMAIL PROTECTED]
To: Ed Lazor [EMAIL PROTECTED]; Paul DuBois [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED] [EMAIL PROTECTED]
Date: Saturday, January 26, 2002 2:34 PM
Subject: Re: Converting MS Access
Shankar Unni wrote:
That's right:
Do the following in a temp directory:
jar xvf mm.mysql-2.0.10-you-must-unjar-me.jar
This will create a directory called mm.mysql-2.0.10. Inside that, you'll
find a mm.mysql-2.0.10.jar file, which is what you need to put in your
classpath (you can move
At 14:58 -0700 1/26/02, Mark Stringham wrote:
What about converting MySQL data to Oracle ?
There's something for this somewhere on Oracle's web site.
That's all I know, never used it.
-
Before posting, please check:
Wednesday, January 23, 2002, 9:43:00 PM, you wrote:
How did you install MySQL? Is it the binary distribution from MySQL or
you have compiled the software from the sources?
AT I used the rpm inside the SuSE's distribution.
Download the binary distribution from http://www.mysql.com/.
[database,sql,query,table]
Mark Matthews wrote:
Or download version 2.0.11 released today which fixes that bug (as far as
I can tell):
Absolutely. Quick work, indeed. I've already switched over to 2.0.11 and
it's been smooth.
Thanks for the fantastic support!
--
Shankar.
[database,sql,query,table]
Shankar Unni wrote:
Float has accuracy problems at large ranges. A typical float has a fixed
number of so-called significant digits. For 32-bit IEEE floats, that's
about 6.
Of course, in the interests of fairness, I should note that typical doubles
(64-bit
For currency, it depends on your use of course, but fixed-point is
usually easiest. Where you fix the point depends on the precision
you require.
For display purposes it is easiest to use the smallest currency
unit as an integer (e.g. cents). For conversions, daily interest,
etc, you can do
At 3:10 PM -0800 1/26/02, Shankar Unni wrote:
Of course, in the interests of fairness, I should note that typical doubles
(64-bit IEEE) have about 15 digits of accuracy, which are generally enough,
as long as you never exceed 10**13 dollars (i.e. no US govt budget work
:-)). You only have to
Title: ³×À̹ö ¸ÞÀÏ
¹ÚÂù¹Î (naracom2002) ´Ô²² º¸³»½Å ¸ÞÀÏ InnoDB and SET TRANSACTION ISOLATION LEVEL, etc...
ÀÌ ´ÙÀ½°ú °°Àº ÀÌÀ¯·Î Àü¼Û ½ÇÆÐÇß½À´Ï´Ù.
¼ö½ÅÀÚÀÇ ¸ÞÀÏ º¸°ü ¿ë·®ÀÌ °¡µæÂ÷ ÀÖ½À´Ï´Ù. ³ªÁß¿¡ ´Ù½Ã ½ÃµµÇϽʽÿÀ.
i tried to start mysql thinking it was preinstalled on OS X Server.
is it not installed on OS X Server? apparently all of the usual files are
not there?
any insight?
-
Before posting, please check:
The MySQL documentation (2.6.1 Linux Notes) states that is essential to
run the 'mysqld' process with the highest possible priority on the Linux
2.4 kernel and this can be achieved by adding 'renice -20 $$' to
'safe_mysqld'. Where is the appropriate place in the 'safe_mysqld'
script to place the
I recently moved from Mac OS X Server 1.x (rhapsody) with MySQL 3.23.27 to
Mac OS X 10.1 (darwin) with MySQL 3.23.47. Due to an oversight the only db
backups after the move were in non-gzip'd tarballs that were ftp'd in ASCII
mode -- ugh. Lots of missing and corrupt files.
All tables are ISAM.
In the last episode (Jan 26), Harriet Wheeler said:
I recently moved from Mac OS X Server 1.x (rhapsody) with MySQL 3.23.27 to
Mac OS X 10.1 (darwin) with MySQL 3.23.47. Due to an oversight the only db
backups after the move were in non-gzip'd tarballs that were ftp'd in ASCII
mode -- ugh.
Hello list,
I am planing to design high-available mysql servers which serve as one
single virtual mysql server to application servers. My criteria is:
1. HA(High Availability)
Due to mission critical services, we hope the mysql clusters can provide
high availability to application servers. In
On Sat, Jan 26, 2002 at 07:06:57PM +0200, Michael Widenius wrote:
Jeremy I think that the walking backwards optimizations were introduced
Jeremy in the MySQL 4.0 tree.
That's correct. Simon, could you please download MySQL 4.0.1 and try
if this works better for you.
We shall also add
Hello,
I just took over and restructured an existing web site
running on IIS/PHP/ODBC/MS Access.
The site is up and running now (thanks to your help too..), but now
the customer is speaking of adding MUCH more content to the database,
(~10/50x increase) and to add search capability all over its
42 matches
Mail list logo