hi all,
i'm testing mysql 3.23.32 on windows and i need to use Turkish character
set in sorting or using string functions such as upper etc. do you know
where i can find latin5 files for windows?
thnx.
-
Before posting, please
Hi all,
I use replication on MySQL. One of my ideas is to generate HTML pages
using PHP.
Will I have any troubles using PHP and connecting simultaneously to both
servers?
Thanks in advance for any comments.
Mariusz Brzezinski
WBK SA
tel. +48 61 856 53 57
mobile +48 501 623 123
Hi,
Jeremy Wilson:
> I tested replication recently and found it extremely lacking. Even the
> most minor of errors causes the daemon to stop replicating, effectively
> rendering the ability useless to me, as I use mysql for authentication.
>
What errors are you talking about? Errors like duplic
Hi,
I have two tables city and country
+---+-+--+-+-++
| Field | Type| Null | Key | Default | Extra |
+---+-+--+-+-++
| id| int(5) | | PRI | 0 | aut
Please search the documents before posting (if you already haven't)
http://www.mysql.com/doc/R/e/Regexp.html
-- Atle
On Thu, 8 Feb 2001, wangzhw wrote:
> hi:
>whether mysql is supported by regular expressison? if it is supported,how to
>express it by select query.
> thank y
You might want to look at
http://www.mysql.com/doc/R/e/Replication_Implementation.html
The docs are *really* handy usually :)
--Atle
On Fri, 1 Jan 1999, neeraj_m wrote:
> Sir,
>
> How can I do data replication using MySQL? I am having data on my
> local server, say, people are coming to my
Hello,
Is it possible to interconnect two different Database Servers like Mysql
on Linux and MS-SQL 6.5 on Windows NT.
I am mean to say,Can we access & both work on the data in above Database
Servers simultaneously.
Thanks in advance.
From,
Sangeeta.
([EMAIL PROTECTED]
Sir,
How can I do data replication using MySQL? I am having data on my local server, say,
people are coming to my firm and giving there specifications. On pressing the submit
button, this data should go to the database server, which is on Intranet. Now I want
to develop an application, in whic
look in the scripts directory and use one of the db_install (or install_db) scripts.
It is failing because you do not have a mysql database defined...
On Wed, Feb 07, 2001 at 10:56:04PM -0500, root wrote:
> Hello,
>
> I am a Linux-Mandrake installer of MySQL and have read no less
> than 4 comple
hi:
whether mysql is supported by regular expressison? if it is supported,how to
express it by select query.
thank you!
Hello,
I am a Linux-Mandrake installer of MySQL and have read no less
than 4 complete
installation guides:
-2 of included with the binary each different,
-1 online tutorial and
-1 from a published book)
and none of them work completely
I have unzipped, installed and tested.
-MySQL server s
You forgot step 3a,
Step 3a: Before asking, read the manual and the list archive :)
- Original Message -
From: "Cal Evans" <[EMAIL PROTECTED]>
To: "Miguel Garcia-Oria" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, February 08, 2001 10:05
Subject: RE: help for a begginner!
>
> > CREATE TABLE Salespersons
[...]
> > rank INTEGER NOT NULL DEFAULT 1 CHECK (rank IN (1,2,3)),
> > salary DECIMAL(7, 2) NOT NULL DEFAULT 1000.00 CHECK (salary >=1000.00));
As someone else pointed out, the syntax requires a comma in front of
CHECK:
CREATE TABLE Salespersons (
SELECT * FROM table_name;
This is explained in the manual, unless you want to use a GUI, then someone
else on the list may be able to help you.
- Original Message -
From: "Marc Bragg" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, February 08, 2001 10:26
Subject: table data
what is the simplest command to view data from a table?
-
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 <[
In the last episode (Feb 07), Brian Reichert said:
> I apologize if this has been discussed already, but I quick poke
> at the archives didn't reveal anything.
>
> We have a table that iamchk says is fine. We are trying to get an
> SQL dump of this table. But, we keep getting out-of-memory erro
Does anybody know the *proper* way to use 'ignore' in
load data infile? The manual is no help, and when I use:
Load Data Infile (Path to file/file.txt) ...ignore or whatever I tried,
I get an error mentioning duplicates (Might be the result of primary key)
The point is, I want to create a table
Greetings Miguel,
Step 1:
Identify all the information you want to track. Since you already have a
form, you probably have done that already.
Step 2:
Create your database. I recommend that if you are as new to this as you
sound that you install webmin www.webmin.com or phpMyAdmin
http://www.phpw
I may have misunderstood but I would have thought the query would be like
CREATE TABLE Salespersons
(empid INTEGER NOT NULL PRIMARY KEY,
ename CHAR(15) NOT NULL,
rank INTEGER NOT NULL DEFAULT 1,
salary DECIMAL(7, 2) NOT NULL DEFAULT 1000.00,
CHECK (rank IN (1,2,3)),
CHECK (salary >= 1000.00
Hi,
You are a bit on the wrong track - a join is a purely temporary thing, and
it would be an error for it to modify the database.
Perhaps what you are thinking of is a 'View', where the results of a select
appear like a table to the user. MySQL doesn't support them (yet).
Your command was tryi
I want to SELECT on one term & have the SELECT return as quickly as possible on the
first TRUE instance.
Ideally I'd like it to after the first matching case stop looking for other matches (
for speed ) and return 1. If there's no matches at all I want it to return 0.
This works OK but return
--skip-locking is on by default? I gotta check that but, yes, if I were you
I would try without the skip locking option. You would then also be able to
do a myisamchk without bringing down the server.
- Original Message -
From: "Hardy Merrill" <[EMAIL PROTECTED]>
To: "Rolf Hopkins" <[EM
Alright, you've got me worried.
I have been using telnet to access mysql. Could that have something
to do with the problems I have been having with the server? (The root
password was erased, but there was no other evidence of a breakin.)
On 8 Feb 2001, at 7:56, Quentin Bennett wrote:
> Hi,
>
I am trying to copy data from one database to another using output from
mysqldump version 8.11 distributed with 3.23.28-gamma. The problem is that
part way through importing the data into the target database, mysql just
hangs. When I show the process list, there is only one query, and it's stuck
i
hi there. i've just joined the list. I took a look through the archives
and I think I've got the whole concept of JOIN wrong, but here goes.
Here's the task: I've got three tables, each with the same number of
records (8077, fwiw). they have 149, 149, and 80 columns.
There are a few columns th
mike thomas wrote:
>
> Hi all
>
> I am running mysql on linux (redhat 6.2) using a regular 18Gb
> EIDI hard drive. Does anyone know how much (ball park figure) a
> SCSI hard drive would speed up selects and inserts?
This is a how long is a piece of string question .
EIDE disks have nearly
Title said it all.
How can I set up an asp page to allow me to insert a BLOB into MySQL?
Are there any file type/size restrictions to a large BLOB that could cause database
problems?
Any help would be greatly apreciated.
-Waldo B.
Hello,
My name is Miguel and I am a MD from Spain. Since 1999 I am running a
website www.acidez.net addressed to patients with heartburn. Now, I would
like to create a database, to store the data patients give me. My idea is to
do a survey about this disconfort t try to improve the knoledge about
In the last episode (Feb 07), SF said:
> I did, and that's where I don't understand why this is happening.
> The furthest I was able to get in the manual and/or any of the
> archives from MySQL is:
>
> (straight out of the manual)
> CREATE [TEMPORARY] TABLE [IF NOT EXISTS] tbl_name [(create_defi
One thing to keep in mind is IDE tends to eat up processor power where as off board
scsi doesn't.
Greg Cope wrote:
> mike thomas wrote:
> >
> > Hi all
> >
> > I am running mysql on linux (redhat 6.2) using a regular 18Gb
> > EIDI hard drive. Does anyone know how much (ball park figure) a
> > SC
Hi,
But the problem is that mysql is not accepting the syntax, not that it will
do nothing with it.
Quentin
-Original Message-
From: Dan Nelson [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 8 February 2001 12:40
To: SF
Cc: [EMAIL PROTECTED]
Subject: Re: CHECK variable incorrect?
In the l
Greg,
Well, I'm doing like "%stuff%" selects on a single column table
with 20 million records, so any speed gain would be great. Would
I be correct in saying that a select of this type will always do
a table scan?
I think I'll go with SCSI and increase the RAM so I can use a
heap table.
Thanks
Use mysqldump -q ...
This will prevent buffering of the table content in RAM.
regards,
P
On Wed, 7 Feb
2001, Brian Reichert wrote:
> I apologize if this has been discussed already, but I quick poke
> at the archives didn't reveal anything.
>
> We have a table that iamchk says is fine. We ar
Hello,
I tried to send this using the 'scripts/mysqlbug' script but sendmail
barfed
>Description: configure problem finding size of char type on Sparc 20
>How-To-Repeat: I was doing a fully-standard configure script run
>Fix: unsure at this stage
>Submitter-Id: Craig Dewick "[EMAIL PROT
Jeremy,
My queries are disk bound (I think) from watching the Redhat
system monitor when running a query.
Mike
> -Original Message-
> From: Jeremy D. Zawodny [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, February 07, 2001 4:07 PM
> To: mike thomas
> Cc: Mysql@Lists. Mysql. Com; [EMAIL P
On Wed, Feb 07, 2001 at 06:24:58PM -0800, mike thomas wrote:
> Hi all
>
> I am running mysql on linux (redhat 6.2) using a regular 18Gb EIDI
> hard drive. Does anyone know how much (ball park figure) a SCSI hard
> drive would speed up selects and inserts?
That depends. Are your queryes CPU or di
Brian Reichert wrote:
>
> On Wed, Feb 07, 2001 at 05:00:12PM -0500, Brian Reichert wrote:
> > When I try to do a mysqldump on the localhost, I get an out-of-memory
> > error:
> >
> > # mysqldump -uroot -proot customer audit_trail_271
> > mysqldump: Out of memory (Needed 8164 bytes)
> > mysq
Hi all
I am running mysql on linux (redhat 6.2) using a regular 18Gb
EIDI hard drive. Does anyone know how much (ball park figure) a
SCSI hard drive would speed up selects and inserts?
Thanks everyone!
Michael Thomas
abcXyz.com
[EMAIL PROTECTED]
---
On Wed, Feb 07, 2001 at 05:00:12PM -0500, Brian Reichert wrote:
> When I try to do a mysqldump on the localhost, I get an out-of-memory
> error:
>
> # mysqldump -uroot -proot customer audit_trail_271
> mysqldump: Out of memory (Needed 8164 bytes)
> mysqldump: Got error: 2008: MySQL client r
Hi!
> "Peter" == Peter Zaitsev <[EMAIL PROTECTED]> writes:
Peter> Hello mysql,
Peter> mysql 3.23.32 + BDB 3.2.3h
mysql> select * from layers_la00.g03last_hit;
Peter> +++-+++
Peter> | updated| counter_id | stat_id |
I think the -q option (quick, do not buffer output, but write it
directly to stdout)
is what you need.
Cheers,
Kent
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
In the last episode (Feb 07), Cal Evans said:
> Does the post office offer this info? There used to be a service (Melissa)
> that had Lat. and Long. for the center of each zip code. You could use that
> to computer "all addresses in a 50 mile radius". but from what I understand,
> it's gone now.
>>Two things:
>>
>>1) Read the manual to see the correct syntax for the CREATE TABLE.
I did, and that's where I don't understand why this is happening. The
furthest I was able to get in the manual and/or any of the archives from
MySQL is:
(straight out of the manual)
CREATE [TEMPORARY] TABLE [
Two things:
1) Read the manual to see the correct syntax for the CREATE TABLE.
2) Constraints don't actually do anything in MySQL. Again, read the
manual.
-Tilghman
--
"There cannot be a crisis today. My schedule is already full."
--Henry Kissinger
> -Original Message-
> Fro
mysql (the monitor) seems not to read the option character-sets-dir out of
any configuration files (at least not /etc/my.cnf on Linux resp. c:my.ini
and windows/my.ini on Windows) if it is started with option -p or
with --password, i.e. if it shows a password prompt
everything works fine if mysq
I apologize if this has been discussed already, but I quick poke
at the archives didn't reveal anything.
We have a table that iamchk says is fine. We are trying to get an
SQL dump of this table. But, we keep getting out-of-memory errors.
I've tried several things, all to no avail, and I'm looki
Couldn't find it on usps.com, but a quick search of google turned
up the following url: http://www.tpsnet.com/html/zipmenu.html
--
"There cannot be a crisis today. My schedule is already full."
--Henry Kissinger
> -Original Message-
> From: Cal Evans [mailto:[EMAIL PROTECTED]]
> S
This gives me a seg fault, I know I have the correct user/pw, but I can't get the
thing to run past "First", any ideas why the connect is not working properly?
#include
#include
#include
void main()
{
string dbname = "test2";
string hostname = "localhost";
string uname = "mike";
Hi,
Depending on you environment, rdate might work. On solaris, it can sync 2
clocks, on Digital UNIX, it gets the 'average' of clocks it can find.
Regards
Quentin
-Original Message-
From: Leonardo Dias [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 8 February 2001 09:27
To: [EMAIL PROTECT
When I try to run the following command:
CREATE TABLE Salespersons
(empid INTEGER NOT NULL PRIMARY KEY,
ename CHAR(15) NOT NULL,
rank INTEGER NOT NULL DEFAULT 1 CHECK (rank IN (1,2,3)),
salary DECIMAL(7, 2) NOT NULL DEFAULT 1000.00 CHECK (salary >=1000.00));
gives me the following error:
Yo
Does the post office offer this info? There used to be a service (Melissa)
that had Lat. and Long. for the center of each zip code. You could use that
to computer "all addresses in a 50 mile radius". but from what I understand,
it's gone now. I would love to find something where I could make the
> three digits, dash, four digits). I want to compare the second
> set of three digits to each other, something like
>
> WHERE Interviewee.homephone[4-6] = Interviewer.homephone[4-6]
>
> Similarly for zip codes, I want to compare the first three characters
> of a char[10] (zip plus 4], essen
Can I implement some sort of exception handling when using the mySQL
client library? I'm running an application and when I issue a query with
an error in it, I catch the error and print output, but the software
throws a general exception. Should this code be in a
try
{
}
catch
{}
routine? If so,
I think 12 tables is not a large number by any means.
If they _logically_ form one database, I'd not bother about the number.
Only if performance problems pop up, and are positively recognized as being caused
by too many files in the database directory, I'd start looking for a solution.
Which need
Check out SUBSTRING in the manual.
On the zip codes, you're better off not trying to do any
comparisons in SQL -- the way they work is extremely
complicated. I would suggest that you purchase distance
measurements between two arbitrary zip codes from the
Postal Service, if you intend to be accur
The problem I'd like to report is when there's an insert with now() in a
datetime field.
The problem is that, when both servers doesn't have their clocks
synchronized, the value of the now() in the Master will be different
from that in the Slave.
I've tried it with MySQL 3.23.32 in both servers.
Hi!
Last night, one of tables broke. For some reason, I cannot access the table
anymore, trying to do so gives me this error message:
ERROR 1016: Can't open file: 'DownloadCounter.MYD'. (errno: 145)
DownloadCounter is the table that is broken.
How can something like this happen? Is it more p
> "TT" == The Tilghman <[EMAIL PROTECTED]> writes:
TT> You're trying to use a Telnet client with a MySQL server. Instead,
TT> use a MySQL client with a MySQL server and a Telnet client with a
TT> Telnet server. Mixing protocols doesn't really work for anybody.
well, you can use the telnet
i agree .. the mysql server _should_ accept telnet sessions. Maybe in a
future release ? it'd really be very handy
- Original Message -
From: "Quentin Bennett" <[EMAIL PROTECTED]>
To: "'@ndYD'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, February 07, 2001 7:56 PM
Subject: RE
When we increase the number of connections our 3.22.25 server 'hangs':
mysql> show status;
No connection. Trying to reconnect...
ERROR 1129: Host 'xxx is blocked because of many connection er
rors. Unblock with 'mysqladmin flush-hosts'
ERROR: Can't connect to the server
This happens when we inc
Maybe we're doing something really wrong in the way we do each look up.
We have one table with all the defintions on it's own row.
Then we have built off of that table another table that is only the distinct
words, no definitions.
This is because if a word has 10 definitions, it makes it hard to
How can I get the log-bin initial position?
Like: trevas-bin.001
trevas-bin.002
I want to know in which position trevas-bin.002 began.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
I have a select I'd like to do...I have 2 kinds of people -- those
needing interviews, and those doing interviews. Among other things,
each person has their home address/phone in the tables. I want to
generate lists of interviewers in close geographical proximity to the
interviewees. I can do
'varchar(16) binary' works in 3.22 and tinyblob works in 3.23.
by work I mean I can insert hexidecimal numbers into the field.
I am basically treating it as an integer field. I can store 16 byte
numbers in the field and in the case of varchar(16) binary on mysql 3.22
I could store a 32 character
You're trying to use a Telnet client with a MySQL server. Instead,
use a MySQL client with a MySQL server and a Telnet client with a
Telnet server. Mixing protocols doesn't really work for anybody.
-Tilghman
--
"There cannot be a crisis today. My schedule is already full."
--Henry Kissi
Rolf Hopkins [[EMAIL PROTECTED]] wrote:
> Firstly, I'm curious as to why you need --skip-locking in the first place.
I'm not sure that I do - I just thought that if I instead
used --enable-locking that this problem of update logs
getting confused with flush-logs might(?) go away. But I
haven't b
This works... however it does not fix my problem.
I did a little more research...
Instead of varchar(M) BINARY I can do a tinyblob.
This allows me to do the inserts and selects that I previously
mentioned.
Also the documentation says that you can consider blob as a varchar
binary.
So My qu
At 14:31 07/02/2001, Agus Setiono wrote:
Hi!
On Windows you should use libmysql.lib instead. You find it at
/lib/opt directory.
Regards,
Miguel
>I installed MySQL 3.23.32 binary distribution for Windows.
>I can't find libmysql.a in the lib directory. Where is it? Can anybody
>send me one?
>
>-
Hi,
You don't connect to mysql server using telnet, you use the mysql command
line client 'mysql'.
Regards
Quentin
-Original Message-
From: @ndYD [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 8 February 2001 07:13
To: [EMAIL PROTECTED]
Subject: problems running mySQL via Telnet
Hello,
It's gives me correct result (integer value 11) on my FreeBSD 3.5, FreeBSD
4.2 and Debian Linux 2.2 Machine
- Original Message -
From: "Carsten H. Pedersen" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; "MySQL mailinglist" <[EMAIL PROTECTED]>
Sent: Thursday, February 08, 2001 1:15 AM
Subje
Yes, you can but you probably need a real good reason to. As Tilghman
pointed out a PK is a unique key. If you have another unique key (a
candidate key) then you need revisit your datamodel and make sure you have a
good reason. Candidate keys to exist in the real world but they are rare.
Cal
htt
How to start a replication from without stoping master?
-
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
Firstly, I'm curious as to why you need --skip-locking in the first place.
Now that I know what you are trying to achieve, I can honestly say I'm not
sure. I'd have to read the manual for more detail on how flush-logs
interact with table locking etc.
I presume your daemon, that's accessing the
Working anymore? You mean that it used to work? Now I'm confused!!
The quote from the manual is correct. Using BINARY means that 'A' < 'a' not
'A' = 'a' which is the case without the keyword BINARY.
What is it you are trying to achieve by inserting 0x1 into a CHAR field?
- Original Messa
Hello,
server version: 3.22.34-shareware-debug
OS: Windows 98
I tried to access the mySQL- server via the Win-Telnet Client.
If the connection is established, the following mysterious string appears:
(
3.22.34-shareware-debugk7qS,~Z),
After that, I entered some characters.
Then
Is there a more detailed description of the MyISAM file format than in the
MySQL manual?
---
Mark Cogan[EMAIL PROTECTED] +1-520-881-8101
ArtToday www.arttoday.com
I guess my command of the english language isn't too
great.
I never realized that this quote from the manual:
"You're allowed to do it (for example, ABS is an
allowed column name), but whitespace is not allowed
between a function name and the `(' when using
functions whose names are also column
> In a SELECT I have to convert a string into a number.
>
> I used to use something like 'string'+0, where 'string' is a string
> rapresentation of an integer.
>
> Now I noticed that in many cases it returns a rounded floating point!!!
>
> For example:
>
> mysql> select '11'+0;
> +
At 07:14 07/02/2001, CT Chang wrote:
Hi!
Notice that the command mysqld-nt --install only install the
service on the SCM and for start it you do:
net start mysql
Also you need to know that in the next boot the service is
started automatic.
Regards,
Miguel
>Hi there,
>
>I have just upgraded my
010207 12:47:42 Error reading packet from server: Contratulations! You have hit the
magic number and can win sweepstakes if you report the bug (0).
I got the magic number, but I prefer a solution instead my prize!
I have a lot of "COOL BUGS".
I'am a MYSQL FAN.
-
No. A primary key is a unique key, by definition.
--
"There cannot be a crisis today. My schedule is already full."
--Henry Kissinger
> -Original Message-
> From: Jacob Friis Larsen [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, February 07, 2001 09:58
> To: [EMAIL PROTECTED]
> Su
I installed MySQL 3.23.32 binary distribution for Windows.
I can't find libmysql.a in the lib directory. Where is it? Can anybody send me one?
---
~Agus~
Get your small business started at Lycos Small Business at
http://www.lycos.com/business/mail.html
On Wed, 7 Feb 2001, CT Chang wrote:
> Date: Wed, 7 Feb 2001 17:14:28 +0800
> From: CT Chang <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Subject: Mysql in Win2K
>
> Hi there,
>
> I have just upgraded my Win98SE to Win2K and ever since, I could not =
> start Mysqld or Mysqld-nt (with or without
Web Depressed wrote:
> Hi Bob,
> Many thanks for that. I was hoping (through absolute
> naiveity) not to have to go and calculate the number
> of days with the specified range. Unless, of course
> I could have mysql do this for me.
Question: why are you using reserved words for your column na
Hi
okie heres a snippet of my php code:
the code below takes a file uploaded from the web with $file as declared filename on
the form.
if ($file_size>0) { //check whether the file is not empty
$data = addslashes(fread(fopen($file, "r"), filesize($file))); //read the file and
add neccessary quote
Run the winmysqladmin.exe in the bin directory. Then do the right click
"install service", right click "start service".
I had to do this the first time. Thereafter it does it on install.
[EMAIL PROTECTED]
National Aeronautics and Space Administration
-- S c i e n c e @ N A S A -
Cool, I like this info. (especially key_buffer_size stuff)
However, I was running my numbers against what you said would be good. And this is
what I came up with...
The Key_reads/Key_read_request = 0.002 (much less than you suggest so that is good...
I think)
However this one worries me a b
Is there an idea in having a PRIMARY KEY and UNIQUE key for the same table
column ?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To re
I ran rpm -Uhv MySql*3.23.32-1.i386.rpm against the sever, the client and the
shared rpms.
It ran without error and created the appropriate files on the 10 gig
/var/lib/mysql.
I moved the contents of mysql to /dbshare and created a symbolic link in /var/lib
called mysql which pointed to /dbshare.I
clay bond wrote:
>
> I just installed mysql 3.23.32 on my server and it
> went without a hitch. I ran mysql_install_db, changed
> the root password, started the server. I used GRANT
> statements to create another user, then connected
> as that user to the mysql client--no problem at all,
> ran qu
Here you go...
http://www.zeos.dn.ua/eng/index.html
Paulo Serra wrote:
> I am a DELPHI developer and I need to know if exists
> a MySQL driver for DELPHI.
>
> Does MySQL have a driver for DELPHI???
>
>If it does, please send me it...
>
>My e-mails: [EMAIL PROTECTED]
>
It's a bug either in your processor or in your distribution
libraries. Your SELECT returns correctly on my Linux and FreeBSD
servers.
-Tilghman
--
"There cannot be a crisis today. My schedule is already full."
--Henry Kissinger
> -Original Message-
> From: Federico Giannici [mai
Good Morning,
Recently, on an otherwise functioning system, I began getting the following
message
ERROR 1130: Host '' is not allowed to connect to this MySQL server
I am running both the client and server from Solaris 7 machines. MySQL
version is 3.22.32
This started happening about two
Tom,
Read about the MERGE TABLE type, which might satisfy your needs. It
allows
you do partitioning, and to index across partitions, but it does have
some
limitations.
Cheers,
Kent
-
Before posting, please check:
http://www
On Wed, 7 Feb 2001, Carsten H. Pedersen wrote:
> ...but in this case, it means that PHP is trying
> to connect not through TCP/IP as other remote
> machines, but rather through a UNIX socket located
> on the machine as you have described above.
>
> It probably means that
> 1) PHP expects to f
On 07.02.2001 10:30:15 russ wrote:
> Many thanks to all for the help on this issue.
> I've come to the conclusion the simplest way for me to implement this is to
use
> the ENUM type with two possible values 'True' and 'False'.
> I will convert the VB BOOLEAN type to a string before I enter it.
>
> I just installed mysql 3.23.32 on my server and it
> went without a hitch. I ran mysql_install_db, changed
> the root password, started the server. I used GRANT
> statements to create another user, then connected
> as that user to the mysql client--no problem at all,
> ran queries, etc.
>
> But
On 06.02.2001 14:38:59 Jacob Friis Larsen wrote:
> Is there any idea in using both a INDEX() and UNIQUE() index on the same
> table field ?
Yes, you can add both to a field - not that it makes much sense IMHO, but yes,
it's possible...
Rolf, I'm invoking safe_mysqld with --skip-locking and
--log-update=update_log, among other options. If I run
mysqladmin flush-logs while database updates are occurring,
the update logs sometimes get confused - the scheme I have
is basically
mysqladmin flush-logs
mv name_of_old_update_log
> Binary is an option on the varchar type
> I pulled the following quote from the mysql website.
>
> It just does not seem to be working anymore.
A guess:
It seems to me that the problem is not in
your colmn definition, but the silent type
conversions MySQL performs. In the log you
show below, y
1 - 100 of 130 matches
Mail list logo
