On the windows machine I have Acess2003. I installed the MyODBC to push the
data into the FreeBSD MySQL server. The connection worked like a dream.
Kudos to the MyODBC team.
The table that the connection created included field names that have spaces
in the name. I'm trying to access the data
MySQL only supports one master and many slaves. Later we will add a
voting algorithm to automatically change master if something goes wrong
with the current master. We will also introduce ``agent'' processes to
help do load balancing by sending SELECT queries to different slaves.
Is this true? Has the license for the MySQL client libraries changed from
LGPL to GPL?
Murray Cumming
www.murrayc.com
[EMAIL PROTECTED]
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Alan Cox
Sent: Mittwoch, 10. Dezember 2003 10:22
To: [EMAIL PROTECTED]
Statically linking using C API only you will need mysqlclient.lib
For odbc interface you'll need to make odbc calls in your code and use
myodbc.dll (Install myodbc on the client).
You can mix calls, but why would you. I have found the C API to be the best
solution for us. We statically link
Brian,
I think you are going to need to rename your fields/columns. If you are
unable to rename them in mysql then you will probably need to rename them in
your jet database with Access and re-import them.
Your column names should be literals not wrapped in graves or quotes and
should contain
On Thu, 11 Dec 2003 12:26:48 +0100
[EMAIL PROTECTED] wrote:
Is this true? Has the license for the MySQL client libraries changed from
LGPL to GPL?
yes, it's true.
but no, you can use MySQL 4.x with PHP.
PHP at this moment _*doesn't distribute bundled libmysql*_ (PHP uses it's own license,
Hello
I am having difficulties:
I am working on Mac OSX 10.2.8 with mysql 4.
I needed to change the data directory of MySQL from
its original
place (where the application have to be and not the
databases because
there is not enought room) to an other volume of my
computer.
I made a symlink from
Dear Sir,
I download MySQL 1.4.1 version and ODBC 3.51 Connector.
I have some problem with connectoion name and nonblank password.
MySQL ODBC Drivers Errors: Client does not support autentifications protocol request
by server.consider upgrading MySQL client.
If I can connection without
Hello,
I would like to know how to write directly to MyISAM files, without passing
by SELECT or UPDATE queries.
I believe this info can be found in the files myisam.h and myisammrg.h, but
I am not shure if its safe and
how to do it.
I would very much like to have an example of this code (C
Hi,
I would like to know how to write directly to MyISAM files, without
passing
by SELECT or UPDATE queries.
I believe this info can be found in the files myisam.h and myisammrg.h,
but
I am not shure if its safe and
how to do it.
I guess it will only be safe if you're sure you've got all
- Original Message -
From: [EMAIL PROTECTED]
To: Eric Dickner [EMAIL PROTECTED]
Sent: Thursday, December 11, 2003 5:17 AM
Subject: Re: Invalid Compressed Data Error??
On Wed, Dec 10, 2003 at 09:22:08PM -0500, Eric Dickner wrote:
Hello,
When I try and unzip the linux pc binary
Good question,
I am not shure if I need to.
Here's why I am asking:
I have a table that does not have a primary key and I need to update only
one row.
This complicates my Update Query since I cannot specify a Where clause.
I did had a primary key RowID (AUTO INCREMENT) to be sble to specify a
[snip]
So my first question should be : Is there a way to hide a field ??
[/snip]
SELECT only the information you want. Let's say I have
RowID
Name
Address
City
And I only want Name Address and City
SELECT Name, Address, City FROM table WHERE RowID = 'foo'
UPDATE table SET Name = 'foo' WHERE
Hi,
I am not shure if I need to.
Here's why I am asking:
I have a table that does not have a primary key and I need to update only
one row.
This complicates my Update Query since I cannot specify a Where clause.
Well, as you have figured out, without some kind of unique ID, it's
pretty
Thank you, but I already know the basics of SQL SELECT statements.
What I am trying to say is, if a User writes a SELECT clause, I do not want
him to
see the RowID field. I do not want him to write a long SELECT statement,
especially if my
table has 20 FIELDS or more. (Can you imagine the user
[snip]
Thank you, but I already know the basics of SQL SELECT statements.
What I am trying to say is, if a User writes a SELECT clause, I do not want
him to
see the RowID field. I do not want him to write a long SELECT statement,
especially if my
table has 20 FIELDS or more. (Can you imagine the
Hi,
We have 2 MySQL 4.0.16 with replication enabled (M - S), only InnoDB
tables.
We're getting Error reading packet from server: Client requested master to
start replication from impossible position (server_errno=1236) in the
slave.
The master server had a problem... when it came back (with
Without a unique identifier, the only way you're gonna get to update right is to use
other data in the row to identifiy the record...
so with a table structure of
name
address
state
your users can select anything they want, filtering w/ a where clause.
If you grant them update on the table,
Mark Matthews wrote:
Greg G wrote:
I'm still having trouble figuring this out. Please help!
I compiled MySQL 4.1.1 --with-openssl --with-vio and when I look at the
variables with mysqladmin, has_openssl is set to NO. I've got
OpenSSL 0.9.7c installed. I'm seeing this on both Solaris and
Hello,
Here's an example :
I have a table named Product.
TABLE : PRODUCT
+-+-+-+-+-+
|RowID| Name| Company| Price | Warranty |
| | | | | |
Hi Stéphane,
Here's an example :
I have a table named Product.
TABLE : PRODUCT
+-+-+-+-+-+
|RowID | Name| Company| Price | Warranty |
| | | | |
[snip]
| 4 | PC AR3| SPCom Inc. | 1200.00| 2 year|
| 4 | PC AR3| SPCom Inc. | 1300.00| 3 year|
| 4 | PC AR4| SPCom Inc. | 1400.00| 4 year|
Just wanted to know if it was possible to hide fields for whatever reason.
Judging by your response, the answer is no.
Therefore, I will look at other alternatives.
Thanks,
-Original Message-
From: Jay Blanchard [mailto:[EMAIL PROTECTED]
Sent: 11 décembre, 2003 09:09
To: Stéphane
So if I follow you, you allow your clients to execute direct sql on the database, both
select and update, but _they_ simply don't want to see the row id data?
If that's the case, then too bad for them if they are capable of writing sql, then
they have to handle the result, or omit the field
There's no way to hide a row. However, I can think of a zany solution.
Update your tables using a hash of all the data in the row. That way you
don't need an id field.
Fair warning: this is not a GOOD solution but it does address the problem.
Matt
-Original Message-
From: Stéphane
hi there!
i have two databases on the same server, and one of the tables ('users')
should be the same in both databases. since this is very specific to
this one server, and other servers running similar databases don't need
that functionality, i'm looking for the easiest way to do this, so i
Is there any example of makefile for g++ that links libmysqld? So far I
can link libmysqld only with gcc-based programs, but g++ gives lots of
unresolved symbols (like __pure_virtual etc.).
thanks,
Mirza Hadzic
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
Is anyone aware of international standards for field lengths for commonly
used database fields?
I.e
Firstname
Lastname
Address
City
State
Etc
The basic contact information for a user...?
If anyone knows of a standard, please email me a link or reference to it.
Thanks :)
--
Cheers
Mike
I am trying to compile MySQL on a machine. The OS is linux. I am following
the directions I found on a website. http://www.brtnet.org/linux/lampssl.htm.
The source files are in the directory /usr/local/src/mysql-4.0.16.
When I run the ./configure --prefix=/usr/local/mysql
Kim G. Pedersen [EMAIL PROTECTED] wrote:
I try in my program to make a lock.
I try to prevent another session to read and write from the whole table
I tried both
LOCK TABLES pstockx WRITE
and
LOCK TABLES pstockx READ
but no success.
I put in a breakpoint in my program to be sure
Kim,
I use WRITE locks extensively with MySQL 4 with a large distributed
application.
Your example logs indicate that your test application obtained a READ lock,
which will not block other select requests from accessing the table. Only a
WRITE lock will cause subsequent select requests to be
Hi all!
one simple question: what is virtual IO and MySQL FS options in
configure scripts used for? I mean what can i do with this babes tuned
on?
Best Regards! :)
--
..
* _ _ __ __ ..
* \ \ \ | |
I can just alter table to rename the fields right?
-Original Message-
From: Patrick Sherrill [mailto:[EMAIL PROTECTED]
Sent: Thursday, December 11, 2003 5:27 AM
To: Brian Duke; [EMAIL PROTECTED]
Subject: Re: Field Name whitespace via MyODBC
Brian,
I think you are going to need to
First, is there a separate mailing list for MyODBC issues?
I have Lotus Script code that uses odbc in an attempt to write data
to
a MySQL table. I can't get even the very first record inserted
because
I consistently get the following error:
Field mapping failed due to a missing field,
Description:
I'm using a standard OpenBSD Distribution (Versions 3.3 and 3.4)
I'm running Apache 2.0.48, PHP 4.3 and MySQL 4.0.14 - 4.0.16.
The Problem occurs every time I do many querys at one, for example
when I'm using the Woltlab Burning Board or
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Puny Sen wrote:
Hi All,
I'd like to use the same column to store content from multiple languages
(English, German, French, Japanese).
Here is my understanding of the options available.
In MySQL 4.0:
- UTF-8 is not currently available as a
Alex E.Wintermann [EMAIL PROTECTED] wrote:
MySQL 4.1.0-alpha-max-nt
phpMyAdmin 2.5.4
/* BEGIN DUMP */
CREATE TABLE `sp_tovar_vid` (
`id` int(11) NOT NULL auto_increment,
`id_tovar_vid` int(11) NOT NULL default '0',
`name` varchar(100) NOT NULL default '',
`description` varchar(255)
It's not recommended since it might cause file locking issues internally.
how 'maybe' would that be? (that table almost never get written to, but
when it is written to, the other one should be updated AFAP. both tables
would almost never be written to at the same time)
Why not just set up a
Hi,
I
have a problem and would like a help.
I
copied a mysql datadir to another place (backup of datadir), but when start up
mysql server with datadir it's crash.
See
below, trace of logfile:
031211 13:28:01 mysqld
started031211 13:28:01 InnoDB: Database was not shut down
What if you were to make a 3rd database, containing shared elements, such as your user
table (I presume we're not talking the MySQL system user table) and then have
necessary permissions granted between your other database users to read that table
jointly, as you can query cross
Does anyone know why MySQL would only be allowing users with null
passwords to connect? It's a fresh install of the server after
deinstalling 4.1-ALPHA and installing the production release of 4.0.6.
Conor.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
By default mySQL comes with a set of users that are allowed to login
locally without password. You should create a normal-superuser account,
and delete all others, and use this user to administer the rest of the
data base and use it to create all others accounts that you might need.
To create a
I have already created extra user accounts and none of them can connect
once a password has been set.
-Original Message-
From: Victor Medina [mailto:[EMAIL PROTECTED]
Sent: 11 December 2003 18:45
To: Schrodinger
Cc: 'MySQL General Lists'
Subject: Re: Login Problems
By default mySQL
[snip]
I have already created extra user accounts and none of them can connect
once a password has been set.
[/snip]
Have you FLUSHED the privileges?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi all, specially to Heikki.
Its really amazing that multiple tablespaces are available before 2004,
congratulations to Innodb Oy Inc.
Right now im migrating from 4.1.0 to 4.1.1 but im figuring out if there is a
downgrade in performance in order to use multiple tablespaces, obviously it
At 14:06 +0100 12/11/03, N L wrote:
Hello
I am having difficulties:
I am working on Mac OSX 10.2.8 with mysql 4.
I needed to change the data directory of MySQL from
its original
place (where the application have to be and not the
databases because
there is not enought room) to an other volume of
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Tue, 9 Dec 2003, Mark Needleman wrote:
Is there anyway to still get the Solaris 9 64 bit binary for version
4.1.0 - now that 4.1.1 alpha appears to be out the 4.1.0 binaries don't
seem to be available on the download page
Yes, older 4.1
Hi,
I just recently built myself a dual Opteron system and installed mysql for
AMD64 on it. I previously ran my databases on regular 32 bit systems and
had my UDF working fine. The UDF is written in C. Before I try and install
the UDF on the new system should I recompile it using AMD64 libraries?
In the last episode (Dec 11), Ollie Gallardo said:
I just recently built myself a dual Opteron system and installed
mysql for AMD64 on it. I previously ran my databases on regular 32
bit systems and had my UDF working fine. The UDF is written in C.
Before I try and install the UDF on the new
Thanks Dan. I will get to it then.
Dan Nelson said:
In the last episode (Dec 11), Ollie Gallardo said:
I just recently built myself a dual Opteron system and installed mysql
for AMD64 on it. I previously ran my databases on regular 32 bit
systems and had my UDF working fine. The UDF is written
I agree with Dan.
We looked into this years ago.
We have MANY machines with many tables used this way.
It is easy when you realise that one SQL command can access multiple
databases, using db1.tablea ... db2.tableb syntax.
Stephen
- Original Message -
From: Dan Greene [EMAIL PROTECTED]
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Greg G wrote:
Mark Matthews wrote:
Greg G wrote:
I'm still having trouble figuring this out. Please help!
I compiled MySQL 4.1.1 --with-openssl --with-vio and when I look at the
variables with mysqladmin, has_openssl is set to NO. I've
On Friday, December 5, Robert Citek wrote:
On Wednesday, December 3, 2003, at 06:27 PM, Robert Citek wrote:
How can I calculate the mean/median/mode from a set of data using SQL?
After a bit of googling, I found this link:
http://mysql.progen.com.tr/doc/en/Group_by_functions.html
and a few
Has anyone had any success compiling udf_example.so (and getting it to work)
on sparc solaris 8? I've tried it with the Sun Forte compilers, using the
configure options mentioned in the on-line manual, and also with gcc 2.95.3.
I was able to get it to work easily on Linux using gcc 3.3.1.
--
Mark Matthews wrote:
According to 4.4.10.2 Requirements, have_openssl must be YES prior to
setting up certificates. Is this in error?
Sorry, I missed that small fact.
What does the file include/my_config.h say about #define HAVE_OPENSSL
(it's generated by 'configure').
/* OpenSSL */
Yes I have tried doing that but with no joy.
-Original Message-
From: Jay Blanchard [mailto:[EMAIL PROTECTED]
Sent: 11 December 2003 18:59
To: Schrodinger; Victor Medina
Cc: MySQL General Lists
Subject: RE: Login Problems
[snip]
I have already created extra user accounts and none of
I have removed all localhost user entries and all users should now be
able to connect from any host. But when a user attempts to connect with
a password they get the usual
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password:
YES)
-Original Message-
From: Victor
I'm load a CSV file with five fields into mysql. It loads up fine.
Problem comes in when I try to refresh the data with updates.
I grab this file and convert it to CSV every 12 hours. The data shows
past 24 hours only, so basically I'm trying to make a permanent archive.
I tried creating a
The subject says most of it. I'm moving mysql data from one machine to
another. --quote-names works on tables and columns, but it seems to be
skipping the database names. (`-` is the character throwing the restore
off)
I'm doing this on some older mysql boxes (not by much from
I'm back with another question. I tried to compile my UDF with the gcc on
my Opteron system and I got errors.
Errors:
/usr/lib64/gcc-lib/amd64-mandrake-linux-gnu/3.3.1/../../../../lib64/crt1.o(.text+0x21):
In function `_start':
../sysdeps/x86_64/elf/start.S:92: undefined reference to `main'
Schrodinger wrote:
I have removed all localhost user entries and all users should now be
able to connect from any host. But when a user attempts to connect with
a password they get the usual
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password:
YES)
In an earlier message, you
I can't figure this out. I'm setting privileges for access on a local net to
a user [EMAIL PROTECTED] using grant and all of a sudden mysql is dead. I'm
running 3.23.31 on Mandrake 7.2. I haven't had any problems in years.
Anybody got any thoughts on this? Please reply to [EMAIL PROTECTED]
What in
Mark,
You can find your first missing date in MySQL 4.1.0(alpha) or higher,
using sub-selects, something like this:
SELECT MIN(DATEADD(LOAD_DATE,1)) AS MISSING_DATE
FROM load_cntl AS A
WHERE
DATEDIFF(NOW(), LOAD_DATE) 30
AND LOAD_DATE
(SELECT MAX(LOAD_DATE) FROM load_cntl AS B)
AND
Hello Stephane,
I use myisam for reading.
I now use SQL for updating. When I used myisam for updating, tables
sometimes corrupted, and I was unable to work out why.
Currently I am changing programs to use HANDLER syntax not myisam for
reading. This will:
- Save the need for table locking.
-
Mike Johnson wrote:
From: Robert Citek [mailto:[EMAIL PROTECTED]
Hello all,
How can I calculate the mean/median/mode from a set of data using SQL?
Mean seems to exist as the average (avg):
select name, avg(value) from table group by name
Is there a way to calculate median and mode with a
In the last episode (Dec 11), Ollie Gallardo said:
I'm back with another question. I tried to compile my UDF with the gcc on
my Opteron system and I got errors.
Errors:
/usr/lib64/gcc-lib/amd64-mandrake-linux-gnu/3.3.1/../../../../lib64/crt1.o(.text+0x21):
In function `_start':
66 matches
Mail list logo