Hi.
I know that for fulltext index are some limitations as:
All parameters to the MATCH() function must be columns from the same table that
is part of the same FULLTEXT index, unless the MATCH() is IN BOOLEAN MODE.
But "A boolean full-text search can also work even without a FULLTEXT index,
alth
For this query
mysql> EXPLAIN
-> SELECT COUNT(accesslog.document_id) AS item_count,
-> data_table.stringAS item
->
->FROM pot_accesslog accesslog,
-> pot_visitors visitors,
-> pot_documents data_table
OK. but what about this :
(AND i don't have a fulltext field !)
Here's my table:
(lac CHAR (3),
ano CHAR (7),
bno CHAR (18),
cty CHAR (4),
dat CHAR (8),
tim CHAR (6),
dur CHAR (8),
ccu CHAR (8),
loc CHAR (20),
ccl CHAR (12),
isdn CHAR
does anybody know what this means? My binlogs are full of them.
thanks,
- Mark
sql
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To r
Perl scripts
mysql_convert_table_format
mysql_explain_log
mysql_find_rows
mysql_fix_extensions
mysql_fix_privilege_tables
mysql_setpermission
mysql_tableinfo
mysql_zap
mysqld_multi
mysqlaccess
mysqldumpslow
At 23:10 -0500 2/26/03, Jianping Zhu wrote:
Thanks for response.
what will happen if commnet size is more that 2000?
Use whichever one of the TEXT column types can hold as much as you
want to allow as your maximum comment size. The MySQL manual indicates
the maximum length for TINYTEXT, TEXT, MEDI
i would like to use rowid in my query does
mySQL support this ..if s how do i give in query
please help...
__
Do you Yahoo!?
Yahoo! Tax Center - forms, calculators, tips, more
http://taxes.yahoo.com/
Thanks for response.
what will happen if commnet size is more that 2000?
J.P.
On Wed, 26 Feb 2003, Paul DuBois wrote:
> At 21:32 -0500 2/26/03, Jianping Zhu wrote:
> >I have a guest book which have three fields.
> >user name
> >email
> >comments
> >
> >I want to mysql to store the information, b
Hello MySQL Gurus,
I'm using MySQL 3.23.49-log on Debian Linux 2.4.18-bf2.4.
I am using replication over ssh tunnels, and one of the slaves is apparently
in need of performance tuning.
After reviewing the status and variable settings (detailed below) and the
MySQL online manual, I decided tha
Dear Daniel,
Thanks for taking an interest in spam fighting. I have passed this
information on to our list manager. He will do what he can to deal with
this problem.
In the future, please keep several things in mind:
- we do not tolerate name calling based on religeon, race, sexual
preference
At 16:52 -0500 2/26/03, 1LT John W. Holmes wrote:
> I have a need to find out how long each of the queries executed
against a mysql server are taking.
Why can't there just be a function that returns this? I mean, it's already
printed to the screen when you're running from the command line. Hopefu
At 21:32 -0500 2/26/03, Jianping Zhu wrote:
I have a guest book which have three fields.
user name
email
comments
I want to mysql to store the information, but commnet maybe very long, is
there a better way to handle it instead of set a varchar(2000) or more for
a field comment in the table?
VARCHA
At 18:30 -0800 2/26/03, Admin-Stress wrote:
I have a table with this structure :
username VARCHAR(32)
address VARCHAR(128)
datereg DATETIME // date of registration
classINT
How is the sql query for username who are their datereg was 30 days
ago and class = 1?
WHERE class = 1 AN
I have a guest book which have three fields.
user name
email
comments
I want to mysql to store the information, but commnet maybe very long, is
there a better way to handle it instead of set a varchar(2000) or more for
a field comment in the table?
Thanks
---
I have a table with this structure :
username VARCHAR(32)
address VARCHAR(128)
datereg DATETIME // date of registration
classINT
How is the sql query for username who are their datereg was 30 days ago and class = 1?
thanks
__
D
--- [EMAIL PROTECTED] wrote:
> Your message cannot be posted because it appears to
> be either spam or
> simply off topic to our filter. To bypass the filter
> you must include
> one of the following words in your message:
>
> sql,query,queries,smallint
>
> If you just reply to this message, and
Stefan Hinz wrote:
Ami, Joseph,
Stefan, viele danke
Apparently, this is a socket problem. You have no Unix socket on your
Windows MySQL server through which to connect. Try to use TCP/IP, by
connecting with the host specified, where host is something else but
127.0.0.1 or localhost; like this:
At 20:24 -0500 2/26/03, Jianping Zhu wrote:
Where should i put sql script in order to use "source mysqlscript" to
create tables in database test?
It's easiest if you invoke mysql in the same directory where the
script is located.
Thanks
Where should i put sql script in order to use "source mysqlscript" to
create tables in database test?
Thanks
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
>Release: mysql-3.23.55-max (Official MySQL-max binary)
>Environment:
System: Darwin iMaxSales-Hancock.local. 6.4 Darwin Kernel Version 6.4:
Wed Jan 29 18:50:42 PST 2003; root:xnu/xnu-344.26.obj~1/RELEASE_PPC
Power Macintosh powerpc
We have tables with mixed case names "MLSDat
SQL. Query.
Every time I post to the MySQL lists ([EMAIL PROTECTED] and
[EMAIL PROTECTED]) I get a sign-up verification message claiming to
be coming from a yahoo groups list.
I checked out the source and found it is the same faggot who is spamming
with various get-rich-quick schemes:
bash-2.
Hello,
I¹m trying to filter a column of phone numbers that contains spaces,
parenthesis, dashes, and possibly letters using sql with the following
query. Am I going down the right path with the following sql statement or
should I be doing something totally different? I¹m trying to say use the
cont
Thanks for the response..it was helpful.
The information I was missing was that numeric values appear in MYSQL_ROW
arrays as null-terminated strings, not as binary data.
Travis
On 2003.02.26 00:58 Bernhard Döbler wrote:
> Hi Travis,
>
> so far I see, you cannot simply interpret 'length' as th
>Description:
Got undefined symbol 'errno' in libmysql
>How-To-Repeat:
>Fix:
diff -r -d -u mysql-4.1.old/include/mysys_err.h mysql-4.1/include/mysys_err.h
--- mysql-4.1.old/include/mysys_err.h 2003-02-25 19:01:11.0 -0500
+++ mysql-4.1/include/mysys_err.h 2003-02-25
Hello,
[EMAIL PROTECTED] wrote:
Description:
Hello,
I am working with mysql/InnoDb 4.0.11 under Windows 2000.
I have the following table:
Time: 0.20 secs.
Explain:
table type possible_keys keykey_len ref rows Extra
GIROS range PRI
I assume the RAND() function can be used in in an insert:
INSERT INTO target (MyRandVal, OtherColumns)
VALUES (RAND() * (MaxVal - MinVal) + MinVal, OtherData)
OR
INSERT INTO target (MyRandVal, OtherColumns)
SELECT RAND() * (MaxVal - MinVal) + MinVal, OtherData
FROM ...
HTH,
Tore.
Hi all,
It seems that MS Access can't find out how to "convert" the mysql Time Type
in a table.
Lets say i got 3 colums in a table like this:
create table test (id int(4)auto_increment,dato date,tid time, primary key
(id));
insert into test values ('',curdate(),curtime());
insert into test valu
> I have a need to find out how long each of the queries executed
> against a mysql server are taking.
Why can't there just be a function that returns this? I mean, it's already
printed to the screen when you're running from the command line. Hopefully
I've missed something and it's already there,
I'm trying to setup binary logging to eventually get replication
between two servers. However, any updates that I do to the
database are never written to the binary log.
I'd appreciate any pointers to what I may have misconfigured. Here
are some details about what I've tried so far:
Version: 3.
Since mysql_setpermission doesn't work on 4.2 | > I have written a
program to replace It.
I think with some modifications to the admin section or linux stile
paths it could be easily adapted to any opperating system.
I started creating menu-mysql in 1997 when I first started using MySQL.
Not all th
Are you also going to install MySQL on the laptop? PHPMyAdmin runs over the
web, so you just need to be able to pull up the PHPMyAdmin website on the
laptop in order to use it. There shouldn't be any installation required.
If you want to use a GUI to connect to the remote MySQL server, then use
My
>> Does anyone know where I can read more on how to redirect incoming
>> email (via Sendmail) into MySQL for a given email address?
>> I understand that I can use "<[EMAIL PROTECTED]> | /path/mysql ..." in the
>> /etc/aliases file to do this, but I would like to see if anyone has
>> had success wit
> Or is there another product that can manage a MySQL database from either
> a Windows or Linux laptop/desktop.
I'm sure there are many products that do this. My favorite is mysqltool.
We switched from phpmyadmin to mysqltool a couple years ago when mysqltool
offered features not available in p
> I am trying to find a means to create a column that self-populates with
> unique random 32bit integers in MySQL.
>
> Do I need to do this in code, or is there a column spec/extra that I can
> use to populate a column with random numbers on an insert? Ideally, the
> database itself would manage th
Daniel -
This might be a long shot, but since I've actually run into this problem
before, here goes:
Check your partitions. I had a server on which this very thing happened, and
it turned out there were overlapping partitions. This was all fine and dandy
until data was written to those overl
Hi,
I would like to know if is there a way to delete constraints
without dropping and recreating a table. If there isn't, I would
like to know when do you plan to implement this important feature.
Thanks in advance,
sql,query
I've been researching the possibilities of upgrading from MySQL 3.23 to 4.0
and have read opinions supporting why I should stay with what I have,
upgrade, or move to another DB altogether. I thought it would be in my
best interests to ask this list the same question.
I'm not interested in migrat
On 26-Feb-2003 John Hoskins wrote:
>
> Probably a simple query but, I need to find select a field with data that
> exists in one table but does not exist in a field in another table.
>
> example:
>
> table1.name table2.name
> ---
> bob
On 26-Feb-2003 Andrew Maynes wrote:
> problably a silly question but if I am updating a table in a MySQL DB with a
> table structure like this:
>
> TABLE xxx
> ItemSKU
> ItemName
> ItemDescription
> PostCode
> Category
> CityID
> CTelephone
> ItemID
> Cfax
> Cemail
> Caddre
You could try changing the priority of your inserts using INSERT LOW PRIORITY
See: http://www.mysql.com/doc/en/INSERT.html
This will give the selects priority over the inserts, as the table becomes
free, the insert will happen.
Also, look at this:
http://www.mysql.com/doc/en/Insert_speed.html
I have a MySQL database I will be launching soon which has a search engine
database accesable over DBI/mod_perl/Apace. It has about 2M records, and is
a 4GB table with 1GB index.
Every day I insert 76k records all at once and delete about another 76k.
While these inserts are happening, the select
Hi.
On Wed 2003-02-26 at 18:36:07 +0100, [EMAIL PROTECTED] wrote:
[...]
> As Mark has already stated, this is a typo - it should have read "GAMMA"
> instead. Sorry for the confusion.
Would you mind to elaborate a bit on the current state of the 4.0
cycle? Since Monty suggested in the 4.0.8 releas
Probably a simple query but, I need to find select a field with data that
exists in one table but does not exist in a field in another table.
example:
table1.name table2.name
---
bob john
susan
Hi,
You have a terrible problem. If your competitors can copy your database it is the
fault of your ISP. The ISP should not give them access to your files. This is
possible. If your ISP will not do this get another ISP in another country that will do
this.
If your competitors are users of your
http://james.apache.org
-Original Message-
From: Jeff Neuffer Jr. [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 26, 2003 11:20 AM
To: [EMAIL PROTECTED]
Subject: Using MySQL to store email
Does anyone know where I can read more on how to redirect incoming email
(via Sendmail) int
Hi,
I'd like to know when the final MySQL 4.1 is expected to be released.
I know it's in alpha state now, so I guess it's not recomendable for
production yet..
What about 4.0?
Can it be already used for production?
Another thing..
I'm about to make a kind of yahoogroups in PHP. It's for a Unive
I have a need to find out how long each of the queries executed
against a mysql server are taking.
I found this post, which indicates that this information can be found
in the general query log:
http://www.phpbuilder.com/mail/php-general/2002122/0876.php
The manual note about it says the binary
First, which MYSQL, the program or the company.
Assuming you mean a mysql database I think you will need to run it through
a program which will parse it and load it into the database tables.
> Does anyone know where I can read more on how to redirect incoming email
> (via Sendmail) into MySQL for
I your customers have root access to their machine, then there is no
security, nor can there be.
Dyego Souza do Carmo wrote:
MM> You should use the filesystem security your operating system provides to
MM> prevent common users from copying the database files. The directory that
MM> the database
Does anyone know where I can read more on how to redirect incoming email
(via Sendmail) into MySQL for a given email address?
I understand that I can use "<[EMAIL PROTECTED]> | /path/mysql ..." in the
/etc/aliases file to do this, but I would like to see if anyone has had
success with this. I also
MM> You should use the filesystem security your operating system provides to
MM> prevent common users from copying the database files. The directory that
MM> the database files resides in only needs to allow access by the user
MM> that the MySQL server is running as. If you do this, only users wh
Hello, list,
I am trying to find a means to create a column that self-populates with
unique random 32bit integers in MySQL.
Do I need to do this in code, or is there a column spec/extra that I can
use to populate a column with random numbers on an insert? Ideally, the
database itself would man
Respondendo,
quarta-feira, 26 de fevereiro de 2003, 14:46:45, Mensagem Original:
JT> Why does a user on your system have access to rename the database? Your
JT> database files should be readable only by the user that your database is
JT> running as.
I work with notary officers on "brazil" ... and
Hi everybody
I sent a couple of mail recently, asking some help for some strange
behaviour with select and updates.
I hope many of you have read it...the problem was that making a
SELECT something FROM table WHERE 'Where_Clause'
gave some results, >0.
the query:
UPDATE table SET something WHE
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Wed, 26 Feb 2003, Mark Matthews wrote:
> Ken Menzel wrote:
>
> > How come there is not a source download for 4.0.11??? The source
> > download is still 4.0.10! Did some one miss the source tar ball?
>>
> The source release will be 4.0.11a, w
Description:
Hello,
I am working with mysql/InnoDb 4.0.11 under Windows 2000.
I have the following table:
CREATE TABLE `giros` (
`Doc` varchar(10) NOT NULL default '',
`Tipo` char(1) NOT NULL default '',
`NRe` varchar(5) NOT NULL default '',
`FoP` char(2) N
If the databases are owned by mysql.mysql, how can this happen?
You don't allow users to become the mysql user, do you?
Dyego Souza do Carmo wrote:
I'm using MySQL-Pro+InnoDB 4.0.11 and i have a BIG problem...
My users is "hacking the database" because the MySQL system tables are
stored in .MYD fo
Dyego,
did you compile MySQL yourself and are using a debug version of mysqld?
The assertion is a DBUG_ASSERT which is only present in the debug version.
It fails because an earlier version of MySQL internally assigned a UNIQUE
key as the primary key of the table, but InnoDB was not aware of it.
Dyego Souza do Carmo wrote:
Tanks
Tanks very much
uh, we have war already??
(sorry couldn't resist)
--
Manuel Kiessling
sql,query,innodb,mysql
-
Before posting, please check:
http://www.mysql.com/manual.php
Hi,
The problem is not with MySQL. The problem is with the users having access to the
database files. Lock up the directory that the files are stored in so that only user
MySQL and the administrator (root) can access them. Also, revoke the privileges of any
user, other than MySQL and the admini
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Dyego Souza do Carmo wrote:
I'm using MySQL-Pro+InnoDB 4.0.11 and i have a BIG problem...
My users is "hacking the database" because the MySQL system tables are
stored in .MYD format and to "hack database" is simple , only rename
the database and "copy"
你好：
对不起，打扰您了!
由于我们公司重新制定了一个下调的空间和域名价格，如下：
A型、120元一年
支持功能：纯HTML页面＋ASP脚本以及JS脚本
数据库：.ACCESS
B型、
功能：HTML+ASP+CGI/PHP(任选一种)
数据库：MYSQL、ACCESS
空间：150M
价格：200元/年
C型、功 能：ASP＋CGI＋PHP
数据库：MYSQL＋ACCESS
problably a silly question but if I am updating a table in a MySQL DB with a
table structure like this:
TABLE xxx
ItemSKU
ItemName
ItemDescription
PostCode
Category
CityID
CTelephone
ItemID
Cfax
Cemail
Caddress
CTown
Cwww
PRIMARY KEY (ItemID)
and the update query is t
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wed, 26 Feb 2003, Salada, Duncan wrote:
>
> This is a new beta development release, adding new features and fixing
> recently discovered bugs.
>
>
> Has the release gone backward to beta?
As Mark has already stated, this is a typo - it should ha
I need to install a mysql client only on a solaris2.8 machine, the mysql
server is on another machine.
I could not make the compile work using the source download. I got an
error in make.
Can someone point me to a binary client download somewhere? Or give me
a hint of the following compile error.
I'm using MySQL-PRO 4.0.11 and I have a error on
SELEC/DROP/ALTER/INSERT one specific table:
Version: '4.0.11-gamma-debug-log' socket: '/tmp/mysql.sock' port: 3306
InnoDB: Error: table ./webescriba/webtest has no primary key in InnoDB
InnoDB: data dictionary, but has one in MySQL!
InnoDB: If y
>Description:
While trying to install the binary mysql-3.23.xx-dec-osf5.1-alphaev67.tar, I
keep getting bad system calls while running scripts/mysql_install_db. References are
made to check the log file in ./data, but there is no such log file. Is it stored
somewhere else?
>How-To-Rep
I am new to MySQL ( Converting from MS SQL )
Any how I currently have a productions server running Mac OS 10.2.4
MySQL 3.23 and the latest version of PHP.
I was wondering when to start working with the 4.xx version of MySQL?
When should I start developing for it when should I upgrade the server?
Thanks for the help everyone, I'm gonna try the longtext approach and see
how that works for me.
-Original Message-
From: "Tore Bostrup" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Date: Wed, 26 Feb 2003 12:06:34 -0500
Subject: Re: Column Type help
> The only two considerations I can thin
I'm using MySQL-Pro+InnoDB 4.0.11 and i have a BIG problem...
My users is "hacking the database" because the MySQL system tables are
stored in .MYD format and to "hack database" is simple , only rename
the database and "copy" the blank database... restart MySQL and the
permissions is FULL FOR ALL
On Wednesday 26 February 2003 10:19, Kirill Peskov (WEB-EU) wrote:
> Looks like we've mixed up two threads into one ;-)
>
> As I understood from various forums and maillists, versions 4.x are
> still in development state.
Yup, 4.0.X is gamma.
> The newest production version is 3.23.55,
> am
On Tuesday 25 February 2003 18:06, Nicolás Morales wrote:
> I'm just starting to use MySQL for Linux. I installed it yesterday and
> it worked, but after restarting the computer it doesn't work anymore.
> When I type mysql at the linux prompt it says:"ERROR 2002: Can't connect
> to local MySQL se
On Wednesday 26 February 2003 07:05, Paul Larue wrote:
> Hi All, I'm quite a novice with Mysql and more than a newbee with Linux but
> I managed to install Red Hat on an x86 and installed MySQl too. Now I need
> to have InnoDB support. I installed MySQl on my notebook too (winxp) and
> edited my.c
On Wednesday 26 February 2003 13:01, geeta varu wrote:
> when i'm trying run a query which is having some
> 27k records always i get error
> OutOfMemoryError...
> any reasons..
Look at the following chapter of the manual:
http://www.mysql.com/doc/en/Out_of_memory.html
--
For technical
On Wednesday 26 February 2003 02:40, Robert Mark Bram wrote:
> mysql>LOAD DATA LOCAL
> ->INFILE
> "/Rob/architecturalScreens/prototype/v1/database/insertPart.dat"
> ->INTO TABLE part;
> Query OK, 496 rows affected (0.08 sec)
> Records: 496 Deleted: 0 Skipped: 0 Warnings: 149
On Wednesday 26 February 2003 12:36, David Martin-Roche (ECE) wrote:
> I had a problem with mySQL 3.23.55 running on Solaris and on Linux (this
> problem doesn't occur in NT). When I'm creating the tables in the database,
> the next error is always provoked:
>
> ERROR 1005 at line 54: Can't create
The only two considerations I can think of to choose one type of TEXT column
over another would be:
1: The added storage required by a LONGTEXT over a TINYTEXT is only 3 bytes
per row. Compared to the anticipated average size of the data, this would
be neglibible.
2: If you want to impose somewha
I understand now about index names, thanks.
I just found out that my host doesn't support InnoDB tables, so it's a
non-issue. I can't use them. I'll have to implement all the rules and checks
manually.
Thanks much for your help.
- Sheryl
- Original Message -
From: "Tore Bostrup" <[
I need help with a query. I have a 'royalties' table that looks like this:
AuthorIDProgramIDRoyalty
--
Author1 Program1 0.15
Author2 Program1 0.10
Author3 Program2 0.25
Author4 Program3 0.05
Author5 Program3
Does the last binary version available of MySQL
(4.0xx) support UNICODE?
Thanks.
___
Yahoo! Móviles
Personaliza tu móvil con tu logo y melodía favorito
en http://moviles.yahoo.es
Do MySQL 3.23 bynary distribution of Windows XP
support EUC_JP character set?
I have tried to change it with the
--default-character-set but it don´t work. (It works
ok with SJIS or UJIS).
How I configure MySQL to work with EUC_JP (the same
charset as PHP)?
Thanks.
I'm actually doing the same thing. I settled on using TEXT, which allows
you to store a little over 65,000 bytes. Any resume longer than 65,000
characters really needs to be made shorter since that works out to
probably about 20 pages.
As an aside, I don't know which version of MySQL you are us
It is usually called a self-join, and it is a very useful technique. You
have to do this when you need to obtain or access two separate subsets from
a single table and somehow use those in a join. In this case, you want the
groupids a specific member belongs to (set one) as well as all members
be
I have just installed MySQL 4.0 (from Marc Liyanage at www.entropy.ch) on my
Mac. The mysql process is running. However, when ever I try mysql or
mysql 'options' I receive this error:
dyld: mysql Undefined symbols:
mysql undefined reference to _BC expected to be defined in
/usr/lib/libSystem.B
4: The index name allows you to for instance delete an index, specify it in
a hint, etc. But for the most part, a developer won't care what the name of
an index is.
5: AFAIK, the InnoDB tables support some of the more "professional" RDBMS
features, such as Transactions and Foreign Keys. I do not
Hey there, I'm kinda new to using mysql to its full potential and I was
wondering something. I want to store resume information, but I just want
the user to cut and paste the resume in the "Resume" field and then store
all that in one column in the table. Which table type should I use for
this? Lo
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Ken Menzel wrote:
Hi,
How come there is not a source download for 4.0.11??? The source
download is still 4.0.10! Did some one miss the source tar ball?
Thanks,
Ken
The source release will be 4.0.11a, with patches for compilation on
HP/UX (as it state
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Salada, Duncan wrote:
>
> This is a new beta development release, adding new features and fixing
> recently discovered bugs.
>
>
> Has the release gone backward to beta?
>
> Duncan
No, the release has a 'typo'. The release is 4.0.11 GAMMA.
-Mark
I've never seen opening a table twice and then doing a join back with
itself. Am I wording this correctly? Is that how to describe what you're
doing?
Thanks for posting this to the full list.
- Sheryl
- Original Message -
From: "Don Read" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
On Tue, 25 Feb 2003 [EMAIL PROTECTED] wrote:
> I wanted to created a searh engine for our site with indexed content of
> the pages being stored in MYSQL full text index. I wanted to know how
> fulltext index scales if I have about 200,000 pages indexed. Is it wise
> to use MYSQL for this or go wit
David,
http://www.innodb.com/ibman.html#InnoDB_foreign_keys:
"Starting from 4.0.5 the InnoDB parser is aware of possible option
lower_case_table_names you give in my.cnf."
Upgrade to 4.0.11!
Heikki
Innobase Oy
sql query
...
Subject: Can't create FOREIGN KEY restraints on InnoDb ta
Clive,
I'm not sure offhand if Delphi 6 supports MySQL through the DB Express
drivers (Kylix 3 does). If so, you can go that route. Otherwise:
You can get libaries such as the one from Core Lab:
http://crlab.com/mydac/
or you can use ODBC drivers which you can find here:
http://www.mysql.c
Hi,
How come there is not a source download for 4.0.11??? The source
download is still 4.0.10! Did some one miss the source tar ball?
Thanks,
Ken
- Original Message -
From: "Lenz Grimmer" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wed
Tore,
Thanks very much for taking the time to respond! I'm not insulted by
"basic". Some things I knew, but my questions were basic.
> 1: There is no difference: KEY is a synonym for INDEX.
So these two statements are equivalent:
KEY [index_name] (index_col_name,...)
INDEX [index_name] (index_
This is a new beta development release, adding new features and fixing
recently discovered bugs.
Has the release gone backward to beta?
Duncan
---
Duncan Salada
Titan Systems Corporation
301-925-3222 x375
-Original Message-
From: Lenz Grimm
Hi!
I am new to this list and to the magical world of mysql so please
accept some, maybe, stupid questions from an amateur.
I am trying to install the Bundle::DBD::mysql module on my machine
(Mandrake Linux). I get an error message stating that it can't find
mysql.h and errmsg.h and they are no
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
MySQL 4.0.11, a new version of the popular Open Source Database, has been
released. It is now available in source and binary form for a number of
platforms from our download pages at http://www.mysql.com/downloads/ and
mirror sites.
Note that not
Hi!
I am trying to create a DLL that will hide embedded mySQL functions for use
with VB. I am using mysqlserver.lib. I am able to compile and execute the
following code. This has to be done in C because VB is too slow :-(
If mysql_server_init function is run in the DLL from Visual Basic. I get
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
geeta varu wrote:
when i'm trying run a query which is having some
27k records always i get error
OutOfMemoryError...
any reasons..
What client are you using? JDBC? If so, you need to give more memory to
your JVM with the '-xMX' flag, because the JDBC
Hello:
I'm not able to successfully complete make on mysql, I think I'm using mysql
version 3.23. I'm using gnu's complier and make, I'm not using the Compaq C++
compilier. Thank you very much.
Tru64 v5.1a
CC=GCC
CXX=GCC
gcc version 2.97
GNU Make version 3.79.1
my_error.c: In function `my_erro
1 - 100 of 125 matches
Mail list logo
