I have a database of bids on auctions that I keep separate from the auction
information. The problem comes when I attempt to generate a list of
auctions with highest bid information. I set the database for bids like this:
ANum, varchar(20), the auction number
Bidders, int(4), number of bidder
Hi all,
Iam doing a bilingual site in english and other in
Arabic.
I know that MySQL doesn't support unicode..and in
which format i have to store into the database...
can any one explain
Vasan S
__
Do You Yahoo!?
Make international calls
Dear Sir,
Can you please tell me how to access data from a MySql database using a Bash Shell
Script i.e. how to connect to a MySql database and retrive records and to disconnect
from database.
I shall be very thankful to you.
Yours Truly,
Date |Thu, 16 Aug 2001 08:57:15 -0400
>From |Paul Carter <[EMAIL PROTECTED]>
Hello!
PC> Greetings Grigory,
PC> Thanks for your fast response.
PC> I tried both:
PC> service mysqld start, and
PC> /etc/init.d mysql start (mysqld is not a directory)
No. As i say /etc/init.d/mysql start
or /etc/ini
On 15 Aug 2001 14:07:08 -0700, Philippe Paravicini wrote:
> Dear Philippe:
>
> mySQL.org is a not for profit organization dedicated to promoting
> and further enhancing the mySQL database engine. Like all open
> source projects we welcome community input to help enhance the
> product.
FYI
htt
Hi,
I'm using JDBC/MySQL and the MM.MySQL driver to build JSP pages.the application is
deployed in tomcat.I am using connection pooling package in my application.i am able
to create a pool when the first user logs in.kindly advice how i can close or destroy
the connections when the server
if you don't want the user to input trash, don't give him the opportunity.
on your form, put three two character input fields. label the fields month,
day and year, or what ever is the most common order that your user will
input a date. put '-' or whatever, between the fields - just to make th
> MySQL Error: 1036 (Table 'tblHSBOYArticle_basic' is read only)
> Session halted.
go to the mysql monitor and:
use database;
describe blHSBOYArticle_basic;
-
Before posting, please check:
http://www.mysql.com/manual.php (t
Please, define "supply". You want to hire me at some wildly
outrageous rate, or ... =[8]-)
On Thu, Aug 16, 2001 at 10:29:31PM -0400, jay downs wrote:
> we at IOWNA Software Company would be happy to supply those outrageous fees if
> anyone is interested.
>
> Jay Downs
> Owner
> IOWNA So
Post a couple of lines from your data file. Does .csv insist on all
values single quoted?
On Thu, Aug 16, 2001 at 09:03:36PM -0700, Yeong CN wrote:
> Hi.
> This is the script I write to upload a .csv file into my online mysql database :
>
> $sql_query="LOAD DATA LOCAL INFILE '$textfile' INTO
On Fri, Aug 17, 2001 at 10:51:17AM +0800, Denny wrote:
>
> I am new to linux and i currently trying to install mysql on my redhat 7.1.
> I always got this error message at the end of the make "Internal error:
> Segmentation fault.".
>
> I wonder if anyone would tell me what's going on?
>
> My m
On Thu, Aug 16, 2001 at 09:47:30AM +0100, David Herring wrote:
>
> Good morning,
>
> Does anyone have any details on the how the MySQL searchable
> documentation is produced. Is the content held in MySQL with PHP to
> produce the frontend pages - and is this something that can be
> applied gener
Hi.
I'm a student from China. I have a problem of MYSQL under Linux.
I just installed mysql under RedHat Linux 7.0 and I copyed the
files of a database created by mysql under win2000 to /var/lib/mysql/database_name.
But when I use the database through PHP, I found the tables are re
Hi.
This is the script I write to upload a .csv file into my online mysql database :
$sql_query="LOAD DATA LOCAL INFILE '$textfile' INTO TABLE purchase FIELDS TERMINATED
BY ','
(purchase_order,job_no,username,model,quantity,due_date,sent_date,courier_service,remark)";
$sql_query=($sql_query);
Does any know how to fix this database replication problem.
Last Lines from Err File
010815 21:38:55 Slave thread exiting, replication stopped in log
'salem-bin.013' at position 6867
010815 21:38:55 Error running query, slave aborted. Fix the problem, and
re-start the slave thread with
Marten Mickos wrote:
>
> Our customers have asked us to comment on the writing by Lorne Cooper
> in NuSphere's latest newsletter. I will respond to the three primary
> issues raised in the newsletter: (1) The June 2000 agreement between
> Progress and MySQL AB; (2) the mysql.org website; and (
Jeremy Zawodny writes:
> On Thu, Aug 16, 2001 at 06:00:16PM -0700, Jeremy Zawodny wrote:
> >
> > Does anyone have the latest 3.23.41 I could grab a copy of?
>
> I managed to fetch it from ftp.mysql.com. A copy is now available here
> as well:
>
> http://jeremy.zawodny.com/mysql/mysql-max-3.23
Hi,
I am new to linux and i currently trying to install mysql on my redhat 7.1.
I always got this error message at the end of the make "Internal error:
Segmentation fault.".
I wonder if anyone would tell me what's going on?
My machine is running on cyrix P133 with 32MB ram.
Thanks,
Denny
---
we at IOWNA Software Company would be happy to supply those outrageous fees if
anyone is interested.
Jay Downs
Owner
IOWNA Software Company
[EMAIL PROTECTED] wrote:
> >
> > In my previous job supporting MSSQL at hospitals all across North America,
> > Europe and Australia, Critical Incident sup
Hi,
Try :
http://ftp.sunet.se/pub/unix/databases/relational/mysql/Downloads/MySQL-Max-
3.23/
http://ftp.sunet.se/pub/unix/databases/relational/mysql/Downloads/MySQL-Max-
3.23/mysql-max-3.23.41-pc-linux-gnu-i686.tar.gz
Jocelyn Fournier
Presence-PC
- Original Message -
From: "Jeremy Za
On Thu, Aug 16, 2001 at 06:00:16PM -0700, Jeremy Zawodny wrote:
>
> Does anyone have the latest 3.23.41 I could grab a copy of?
I managed to fetch it from ftp.mysql.com. A copy is now available here
as well:
http://jeremy.zawodny.com/mysql/mysql-max-3.23.41-pc-linux-gnu-i686.tar.gz
Thanks,
The link here:
http://www.mysql.com/downloads/mysql-max-3.23.html
points here:
http://www.mysql.com/Downloads/MySQL-Max-3.23/mysql-max-3.23.41-pc-linux-gnu-i686.tar.gz
But that URL 404s.
Does anyone have the latest 3.23.41 I could grab a copy of?
Thanks,
Jeremy
--
Jeremy D. Zawodny, <
- Original Message -
From: Garrick S. Louie
To: MySQL List
Sent: Wednesday, August 08, 2001 2:30 PM
Subject: Reportwriters for mySQL
I was wondering what GUI reportwriters worked with mySQL. I wanted to use a
windows-based software for reporting and I know that Reportsmith and Crys
On Thu, 16 Aug 2001 16:43:22 -0700 (PDT), "Eric J. Schwertfeger" <[EMAIL PROTECTED]>
wrote:
>>The interesting part is, if I run the program with autocommit on, it
>>works fine. Unfortunately, transactions are essential. I found that the
>>program works if I turn autocommit on but wrap the criti
Perhaps I wasn't clear enough... MSSQL is a reference to Microsoft SQL
Server, NOT MySQL. MySQL support is far superior to M$'s offerings... And
I've only had experience with free MySQL support as compared to Pay Per
Incident M$ Support... I'm sure the paid MySQL support is an order of
magnitude b
I've got a part of a complex system that isn't behaving as expected. I've
got one perl program running with autocommit off that creates entries in a
table and commits the changes. At some point, the rows have their state
field changed from 'active' to 'closed', and these changes are then
commit
>
> In my previous job supporting MSSQL at hospitals all across North America,
> Europe and Australia, Critical Incident support from M$, ranged from 36
> hours to 4 days for a resolution. Often we solved it ourselves long before
> we had an answer from M$... Sad really... MySQL support is far su
Dear Colleagues,
I am very new in MySQL and I just started a project of creating our church
member database on Sun server with MySQL. Would someone please help me
configuring MySQL for Korean language ? I also would like to get some
detail information of how to interface client PCs to the serve
Hi all,
I installed the port of mysql3.23.36 on a FreeBSD machine
I have done it before and it worked just fine, however this time everything
was installed fine but the mysqladmin executable is no where on the system!
Can I just get it out of the tar file and move it into /usr/local/bin? I
will
Our customers have asked us to comment on the writing by Lorne Cooper in
NuSphere's latest newsletter. I will respond to the three primary issues
raised in the newsletter: (1) The June 2000 agreement between Progress and
MySQL AB; (2) the mysql.org website; and (3) Gemini. For those of you
in
Keith:
You want to RENAME tables where applicable, and ALTER the respective columns
to the desired case. Both are done through queries. The MySQL Manual has
detailed info on using these commands.
Gerald Jensen
- Original Message -
From: "Keith Spiller" <[EMAIL PROTECTED]>
To: "Php-db" <
In case you are with php:
Maybe you have magic quotes on, which puts slashes to critical
characters automatically. Check the manual and find out. You just
strip them off when retrieving the data. There is no fix, as this
is a feature. You'll have to care for slashes yourself otherwise.
There are
On Thu, 16 Aug 2001, Theo Richel wrote:
> Is it possible to store html in Mysql-fields? Where can I find more
> info in this?
Did you need MySQL to treat the HTML in some special way? I'm confused as
to why you're asking this question.
I would think that you can just use the TEXT data type to s
Theo:
Yes ... MySQL doesn't really care much what the data is you are storing.
The best source for info is the MySQL manual (link below) ... you probably
want top look at storing data in either TEXT or BLOB fields.
Gerald Jensen
- Original Message -
From: "Theo Richel" <[EMAIL PROTECTE
On Thu, 16 Aug 2001 14:11:59 -0500, Tim Thorburn
([EMAIL PROTECTED]) wrote:
>Hi,
>
>I'm attempting to store jpg images into a MySQL DB using PHP. I've
>found a
>few sample scripts that should do this for me, however, they don't
>seem to
>be working. Could someone take a look at this and see if y
To the original poster: Is this a loaded question just to see what kind of
response you might get?
The application that requires a database server was not mentioned as far as
I can tell, but that will influence your decision on what backend to choose.
If you need every feature set under the sun
In the last episode (Aug 16), Tuc said:
> Having an issue trying to get the latest MYSQLs to compile on
> BSDI 4.0.1, with the default 2.7.2.1 GCC compiler. It appears there
> is an "-fno-exceptions" in the Makefile, that the version of GCC that
> ships with BSDI 4.0.1 doesn't grok. We are
Buy a good book (PHP 4 Bible)!! read some tutorials!! And CHECK the
manual.. found at www.php.net what else did you think people created if
for.. http://www.php.net/manual/en/ref.strings.php gives you all string
manipulation fun stuff you want.
ucfirst() is the solution.
And last but not leas
> Why does [EMAIL PROTECTED] get changed to fname\[EMAIL PROTECTED] when storing
>the data into a database column formated as a VARCHAR? I'm not sure why a back slash
>gets added to the data.
> Also, how would I fix this issue?
> Please send responses to [EMAIL PROTECTED]
> Thanks for your he
It's a bad habbit to crosspost!!
strtolower()
stroupper()
sql mysql
Bye,
B.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To requ
All,
I'm hitting some stumbling blocks getting replication working, and so I decided
to join the list for support.
Here is what I'm trying to do:
GRANT FILE on dbname.tablename to user@"%" IDENTIFIED BY 'passwd';
Here is the error I get:
ERROR 1144: Illegal GRANT/REVOKE command. Please consult
> http://openacs.org/philosophy/why-not-mysql.html";
>
> This article is a year and a half old, quite a lot of its points,
> while valid at the time , simply are not relevant anymore.
I'd like to point out that one of the authors of that paper
E-mailed me saying that they recognise there have b
-Opps: I meant to say I would like to convert to Proper Case, rather than lower case
or UPPER CASE.
I'm reading data from a mysql table that is entirely in uppercase letters. I'd very
much like to convert them
to Proper Case. After searching a while, I found that there is are php commands to
Is it possible to store html in Mysql-fields? Where can I find more info in
this?
Thanks
Theo Richel
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the li
On Thursday 16 August 2001 12:42, Martin Bassie wrote:
> This is a multi-part message in MIME format.
>
> --part3b7c1428c5479
> Content-Type: text/plain; charset=us-ascii
> Content-Transfer-Encoding: 7bit
>
> Hi,
>
> We're working on system where credit card numbers need to be stored in
Hi,
I'm attempting to store jpg images into a MySQL DB using PHP. I've found a
few sample scripts that should do this for me, however, they don't seem to
be working. Could someone take a look at this and see if you notice any
problems?
Thanks
-Tim
This file has the following Database ID: $
At 12:56 PM 8/16/2001, Andrew Schmidt wrote:
>Actually if you have a unique key on 'id' selecting max(id) is extremely
>fast. mysql uses the unique key to find the answer.
>
>I had a table with 137 million records each record ~ 156 bytes (including
>size of keys).
>
>there was a unique key on ses
Warning
Could not process message with given Content-Type:
multipart/mixed; boundary="part3b7c1428c5479"
Hello,
I'm reading data from a mysql table that is entirely in uppercase letters. I'd very
much like to convert them
to lowercase. After searching a while, I found that there is are php commands to
convert text strings between
upper and lower case, but I was unable to find anything that can c
In my previous job supporting MSSQL at hospitals all across North America,
Europe and Australia, Critical Incident support from M$, ranged from 36
hours to 4 days for a resolution. Often we solved it ourselves long before
we had an answer from M$... Sad really... MySQL support is far superior, but
When doing what?
mysql wrote:
> Hi !
>
> I get:
>
> "@HOSTNAME@: command not found"
>
> Does anyone know how to solve that ? I didn't find anything on the net or on the
>mysql.com homepage.
>
> Thanks.
> Jan-Hendrik
>
> -
Hi
I am using mysql 3.23.30 under SuSE Linux 7.1. I tried to
make my table names case insensitive by setting lower_case_table_names=1
but this had no effect.
Even if the variable is set and a database as well as all tables are
created new in lower case a select with an upper case name for a ta
Don't forget to include the intermediate software to cache connections
since it takes so long to make an oracle connection.
On Thu, 16 Aug 2001, Robinson, Mike wrote:
> Date: Thu, 16 Aug 2001 11:03:21 -0400
> From: Robinson, Mike <[EMAIL PROTECTED]>
> To: "'Boget, Chris'" <[EMAIL PROTECTED]>,
>
Hi,
Having an issue trying to get the latest MYSQLs to compile on
BSDI 4.0.1, with the default 2.7.2.1 GCC compiler. It appears there is an
"-fno-exceptions" in the Makefile, that the version of GCC that ships with
BSDI 4.0.1 doesn't grok. We are only building clients for 8 4.0.1 syste
Hey all,
I'm fighting to get ColdFusion 4.5.1 SP2 to talk to a mySQL DB on Solaris 7
using unixODBC/myODBC.
anyone here tried this?
I've gotten to the point where I can see the myODBC mySQL Driver in the
CFIDE/adminstrator ODBC screen. I've added various entries to the
CFHOME/odbc/odbc.ini, CFHO
trying to setup an optimized system to comparison test MS SQL Server
and mySQL. Database has a single 350M table with about a dozen columns.
Initial comparison between the two engines is being done w/o index help.
OS is WinNT, hardware is 1ghz processor and single hd with 512M RAM.
We just happe
No offense but I've seen people on the list throwing replication around like
MySQL has replication end of story. There's alot more to replication than just
a master and a slave. What MySQL has is simple unidirectional replication. If
you want advanced or bidirectional replication you'll have to b
whoops, right you are,
but if the average reader is like me, they'll read the main
article , a comment or two , and bug out. The article itself
is quite definately dated
-Original Message-
From: Ravi Raman [mailto:[EMAIL PROTECTED]]
Sent: 16 August 2001 10:08
To: Sean O'Donnell; [EMAIL
good point. the only real way to duplicate auto increment logic is to
create a new table with 1 row and 1 field. and lock, select, and update that
row.
thanks,
-- Andrew
- Original Message -
From: "Johnny Withers" <[EMAIL PROTECTED]>
To: "'Andrew Schmidt'" <[EMAIL PROTECTED]>
Sent: Thu
hi.
scroll down a bit. the _comments_, to which i was referring, go all the way
up to July 2001, which seems fairly relevant to me.
and while the article is definitely dated, transaction support in mysql is
still not-quite-stable, it still lacks subqueries, stored procedures,
triggers and foreig
Does any know how to fix this database replication problem.
Last Lines from Err File
010815 21:38:55 Slave thread exiting, replication stopped in log
'salem-bin.013' at position 6867
010815 21:38:55 Error running query, slave aborted. Fix the problem, and
re-start the slave thread with "mysqlad
Actually if you have a unique key on 'id' selecting max(id) is extremely
fast. mysql uses the unique key to find the answer.
I had a table with 137 million records each record ~ 156 bytes (including
size of keys).
there was a unique key on sess_id and took about 0.05 seconds to select the
max(s
Uh oh... Please NO. I want the standard _FAST_ auto_increment, not this.
"select max(id) from table x" is terribly inefficient. And the table
is locked during this operation... That's just not acceptable for me.
Anyway, thanks for the response. It was the second one.
Leos
On Thu, 16 Aug 2001, An
>Description:
When trying to set up database replication servers I get the following errors
in the error log :
010816 16:09:12 Slave: Failed reading log event, reconnecting to retry, log 'FIRST'
position 0
010816 16:09:12 Slave: reconnected to master
'[EMAIL PROTECTED]:3306',replicat
On Thu, 16 Aug 2001, mysql wrote:
> "@HOSTNAME@: command not found"
>
> Does anyone know how to solve that ? I didn't find anything on the net
> or on the mysql.com homepage.
You're getting that from support-files/mysql.server, yes?
I've gotten that message too and was puzzled by it. I just rep
> The mySQL
> security model is also not sufficiently developed for any system that
> involves money. "
FUD. My company stores everything including encripted credit card details &
authorisation codes in a MyISAM database. while some careful work is required
to get table locking right & your
"a page with _a lot_ of interesting comments from both sides of the
commercial-RDBMS vs. mysql-postgres is here:
http://openacs.org/philosophy/why-not-mysql.html";
This article is a year and a half old, quite a lot of its points,
while valid at the time , simply are not relevant anymore.
The i
Hi!
Thanks Philippe for forwarding this to us:
> "P" == Philippe Paravicini <[EMAIL PROTECTED]> writes:
P> mySql.org's position (whomever they are)
P> ***
P> Dear Philippe:
P> mySQL.org is a not for profit organization dedicated to promoting
P> and further enhancing the mySQL database eng
...I am somewhat disappointed that you
chose the dolphin for your logo because of the good nature of this animal.
...dolphins seem to have murderous urges unrelated to the need for food.
Theo, are you still irritated that the rest of us got our 'So Long and
Thanks For All The Fish' fishbowls a
Mike Westmacott writes:
> Hi,
>
> I'm a researcher at the University of Southampton, and at some point I will
> need to develop a multidimensional database. Initially I was just going to
> write a very simple SQL server, and then I thought that it might be worth
> trying to write something for My
Hi,
I noticed an annoying behaviour with MySQL 4.0.0.
I have 11 tables with a lot of rows (about 1 Million and more) which are constantly
updated by a php script.
It seems after a shutdown of mysql (mysqladmin -uroot -p shutdown) and a restart, some
tables are corrupted (and not the same, it ra
Urgh...I've been fortunate enough to avoid things like this myself
until recently, when some of my PHP/MySQL/Apache stuff is getting
tossed out in favor of Cold Fusion/MS-SQL Server/MS-IIS. Anyway, my
2c:
At 8:35 AM -0500 8/16/01, Boget, Chris wrote:
>Good morning.
>Recently, we presented MyS
My case sensitivity problem seems to have become even stranger. Basically,
one case for the table ("Employee") works to return data for certain rows,
and the other ("employee") works for other rows. This is unfortunately now
breaking my program.
Probably the easiest way to explain this is to sh
Sinisa,
there is no separate Windows distribution of -Max :). From the
-Max page:
Note: The MySQL 3.23.38 (and newer) distribution for Windows includes both
the normal MySQL and MySQL-Max binaries.
Regards,
Heikki
Sinisa writes:
.
Bruce Scharlau writes:
> Hi all,
>
> I'm t
Hello
I get the following error message when i complie the source version of
mysql3.23.41.
checking character sets... configure: error: No number was found in
./sql/share/charsets/Index for the latin1 character set. This is a bug in
the MySQL distribution. Please report this message to
[EMAIL P
Chris Boget wrote:
>MySQL - as I said at our meeting, we would not be comfortable with this
>as an enterprise strength solution. MySQL is unsupported freeware
No it isn't, both MySQL AB (and NuSphere?) provide "commercial-grade"
support. Given that the top level of MySQL AB support involves dire
Bruce Scharlau writes:
> Hi all,
>
> I'm trying to work out which distribution of mysql supports BDB or InnoDB
> tables.
> I've downloaded 3.23.40 and checked 'show variables' asnd it says these
> tables are not supported.
> I know the docs say they should be available in the distro, but it see
Hi
I am just starting to write my first client with MYSQL 3.23.39 under RH
Linux 7.1 and I had the following code.
The code compiles fine but the call to mysql_query( ) fails with following
error
I used the exact same query at the MYSQL prompt and it worked fine
Could anyone please tell me whe
auto increment is really just a nice way of doing the following (really nice
way actually):
lock table x
select max(id) + 1 from table x
insert into table x values (newid)
unlock table x
this is under the assumption table x as 1 field called id which has a
primary key on it. and newid is the id
On Thu, Aug 16, 2001 at 08:35:40AM -0500, Boget, Chris wrote:
> Recently, we presented MySQL as a database option for a website that
> we might be working on. We've used it as our database in the past and
> we plan on using it in the future as possible.
> With that said, I confess I don't have as
Hi !
I get:
"@HOSTNAME@: command not found"
Does anyone know how to solve that ? I didn't find anything on the net or on the
mysql.com homepage.
Thanks.
Jan-Hendrik
-
Before posting, please check:
http://www.mysql.com/man
Look at the source for the mysql client, and see how they do it.
O'SULLIVAN JOHN wrote:
>
> Hi all,
> I am very new to MYSQL and I am running 3.23 on RedHat Linux 7.1.
> I have just set up a simple database.
> I was not prompted for a password,and was just allowed to set it
> up and access it.I
I suppose there will always be that facet out there
that think spending $46zillion dollars on Oracle
is ok because saying 'we use Oracle' is just plain sexy
and the option includes, you know, a free t-shirt and
hat.
Im sure there are specific valid reasons for not using
MySQL. None of them were e
lol. how "industrial strength" does this website need to be?
if it's anything less than an online banking/creditcard processing site,
you'll probably be okay.
i know go2net, xoom, and realnetworks (among other large sites) all use
mysql. admittedly, they also use oracle or db2 in the mix as well,
I have followed the installation instructions in your manual and the var directory is
not being created where it says it should. I found it under /var/lib/mysql.
>How-To-Repeat:
This is the history of the steps I have followed:
158 rm -r -f mysql/
159 rm -r -f mysql-3.23.41/
;; I ha
MySQL is unsupported freeware and lacks enterprise management
functionality. It has a small limited feature set compared to ORACLE, DB/2
and is lacking the functionality...
Chris,
The guy who wrote this has pointy hair, doesn't he? Tell him that MySQL is
'freeware' just as Linux is 'freeware'.
Boget, Chris wrote:
> --Begin Quote--
>
> MySQL - as I said at our meeting, we would not be comfortable with this
> as an enterprise strength solution. MySQL is unsupported freeware and
> lacks enterprise management functionality. It has a small limited feature
> set compared to ORACLE, DB/2
>
> MySQL - as I said at our meeting, we would not be comfortable
> with this
> as an enterprise strength solution. MySQL is unsupported freeware and
> lacks enterprise management functionality.
True, if you ask me.
> It has a small limited feature
> set compared to ORACLE, DB/2
True. No
Hi,
I'm a researcher at the University of Southampton, and at some point I will
need to develop a multidimensional database. Initially I was just going to
write a very simple SQL server, and then I thought that it might be worth
trying to write something for MySQL.
Sadly due to our Draconian IPR
Oops,
I forgot the 'd':
it is mysqld-max.exe or mysqld-max-nt.exe
Heikki
-Original Message-
From: Heikki Tuuri <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: Thursday, August 16, 2001 5:35 PM
Subject: Re:BDB and InnoDB in windows nt versions
>Hi!
>You should run
On Thursday 16 August 2001 10:52, Fabian Groene wrote:
(snip)
> My problem is quite simple indeed and only refers to the SQL query:
>
>
> There is a table with quite a lot of columns. But only two of them are
> really important for my query: One field is a date field and the other one
> is a gro
Hi!
You should run mysql-max.exe or mysql-max-nt.exe.
Those contain BDB and InnoDB.
Regards,
Heikki
http://www.innodb.com
..
Hi all,
I'm trying to work out which distribution of mysql supports BDB or InnoDB
tables.
I've downloaded 3.23.40 and checked 'show variables' asnd it says these
Boget, Chris writes:
> Good morning.
> Recently, we presented MySQL as a database option for a website that
> we might be working on. We've used it as our database in the past and
> we plan on using it in the future as possible.
> With that said, I confess I don't have as intimate a knowledge of
Hi all,
I'm trying to work out which distribution of mysql supports BDB or InnoDB
tables.
I've downloaded 3.23.40 and checked 'show variables' asnd it says these
tables are not supported.
I know the docs say they should be available in the distro, but it seems
not in this version. So, who can
It seems certainly possible to automate 2 mysql servers
in circular replication, each being master/slave to the
other, provided your code is written in such a way to
circumvent the auto_increment issue. Generating unique ids
on a machine basis and using those values instead of an
autoincrement wou
Dear Sirs
Hello, i have questions on mysql i create a table and i create an index key
in it i want to know how can i know in mysql if the date that i import it
into the table are fully indexd.
please reply.
best regards.
nabil jaber.
_
> > Consider sending queries to your middleware and having it respond in
> > XML for a great way to do better-than-SQL responses in some cases
> > (such as making 'group by' return every result, grouped into XML
> > sub-sections by the relevant field).
>
> Unless you care about performance.
We'v
Good morning.
Recently, we presented MySQL as a database option for a website that
we might be working on. We've used it as our database in the past and
we plan on using it in the future as possible.
With that said, I confess I don't have as intimate a knowledge of mySQL
to address some of the th
Hi Neal
All that replication douse is use the master database logs to update an
identical database (slave). All you should need to do is make shore both
databases are the same. Make changes to both the my.cnf file and restart the
mysqld...
Hope this helps
Simon
-Original Message-
From:
hi,
I'm new to this list, but not so new to using MySQL and have a question
about locking. (This is my first foray into datalocking with MySQL.)
I'd like to lock a table (a row in that table would be better) for read
and write access to prevent mishaps from occurring during data
manipulation.
A
1 - 100 of 126 matches
Mail list logo
