hi,all
when i compile mysql on Solaris 2.6 ,
i just run : ./configure
it allways said :
checking return type of sprintf... configure: error: can not run test program wh
ile cross compiling
anybody help me ?
thanks thanks thanks
wallace
Hello Miguel,
Wednesday, February 07, 2001, 5:52:50 AM, you wrote:
MAS> I have made the following table on Win2000 machine:
C:\mysql\bin>>mysql
MAS> Welcome to the MySQL monitor. Commands end with ; or \g.
MAS> Your MySQL connection id is 3 to server version: 3.23.30-gamma
MAS> Type 'help;'
hi!
I'm going to be building a system that will need to handle a fair bit of
data...
Basically I have tables that will eventually have millions of rows of
data, I believe I need to split them up for 2 reasons, 1, performance
(the tables will be quite active), 2, if a table get's corrupted then
If someone could give me some suggestions, please, I am getting
desperate.
I have a Slackware 7.0 system on which I am trying to install MySQL.
Kernel is 2.2.13
glibc was 2.1.2 upgraded to 2.1.3
compiler is egcs 1.1.2 (i think)
Any binary distribution works perfectly.
MySQL 3.22.23 and 3.22.
Start the deamon First
shell>mysqld-XXX
To find out what X means go to the bin directory below and find out . d
stands for daemon
then key
shell>mysql
Cheers
Donald
- Original Message -
From: "soon chee keong" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, February 06
Hi,
I want to create a database for managing the attendance statements of students under
my supervision. I have mysql running on a debian machine (version 3.22.32-4).
I am unable to create the required tables as I am afraid I need a two dimensional
array which is not available(as I know) in my
Hi,
My website is running on MySql 3.21 and it has so much records that it sometimes
stopped running and
I had to restart the mysqld.
My question is how do I go about benchmarking my site and the mysql server?
TIA
Teddy
Hi,
I want to create a database for managing the attendance statements of students under
my supervision. I have mysql running on a debian machine (version 3.22.32-4).
I am unable to create the required tables as I am afraid I need a two dimensional
array which is not available(as I know) in my
When tried running the mysql server, did it create the socket file? If not,
has security been set that prevents it from being created?
- Original Message -
From: "Alex Tapia" <[EMAIL PROTECTED]>
To: "Rolf Hopkins" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, February 07,
Hi,
I am looking for script or a program which could import multi txt database
files and consolidate them into a single database file. I am interested in
any database format that may be available as the end result.
example.
We have 3 billing servers, each server has its own txt database file.
Look at section 7.19 SELECT Syntax of the manual. The line
[INTO {OUTFILE | DUMPFILE} 'file_name' export_options]
is what you will probably be looking for.
- Original Message -
From: "Phillip M.(Mike) Bishop" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, February 07
Thanks!
At 11:36 AM 2/7/2001, Rolf Hopkins wrote:
>You do not have to compromise. If reliability and speed is what you want,
>then if you find US to produce faster results, set up mysql in the US with
>replication locally. And yes, I agree, don't rely on access for stability.
>
>If you want sta
You do not have to compromise. If reliability and speed is what you want,
then if you find US to produce faster results, set up mysql in the US with
replication locally. And yes, I agree, don't rely on access for stability.
If you want stability, go with mysql on a unix based system. Your loca
Well, I'm looking at reliability more than speed and I'm afraid that MS
Access just won't be up to it.
I'll look for the migrating tools you mentioned, but i feel that any effort
now is better than having to rescue data later on.
Connection in the philippines can't beat acccessing your data on
[EMAIL PROTECTED] writes:
> Hello, I have a table of 26 million rows that I need to query. The table
> is a keywords database with the keyword and a pointer to what page it
> came off of. (pageid|keyword) The problem is that when I use the
> following query is the group by make the query take abou
Ok I have 2000 images in a database that I want to move out of the database and save
the image as a file and place the url to the image in the database. But I can\'t
figure out how to get them out and written to a file to do this.
You Wrote:
Firstly, I\'m not exactly sure of what you are trying
on a related but slightly different example, what would happen if you had a
Primary Key consisting of 2 columns a & b (so the pkey enforces a unique
combination of a & b) and then created an index on one of the columns eg b.
Would the index on b have any effect, or does a primary key on 2 columns
On Tuesday 06 February 2001 13:31, Steve Ruby wrote:
-> "Ung, Seng" wrote:
-> >
-> > hi:
-> > Here is my SQL statement to select a range of number from 0-9
-> >
-> > Is there a short cut to this?
-> >
-> > id like '1%' or id like '2%' or id like '3%' or id like '4%' or id
like '5%
At 11:50 06/02/2001, Peter Zaitsev wrote:
Hi!
I have made the following table on Win2000 machine:
C:\mysql\bin>mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3 to server version: 3.23.30-gamma
Type 'help;' or '\h' for help. Type '\c' to clear the buf
If RPM used:
rpm -ql mysql (or if unsure about the package: rpm -qa | grep -i mysql)
Location:
/var/lib/mysql
There you will find your databases where one directory under mysql
corresponds to one database. Documentation on line and searchable on-line
manual come also handy. Just read
What you will need to consider more is
1. The effort required to migrate across to mysql. There are tools that can
assist but I don't know the URLs. Maybe someone else on the list knows.
2. What will be faster for the majority of users and I'm talking about
overall performance. If having it l
"Only" 272235??? I enter on average about 75,000 to 80,000 records a day
(and some times, I break 100,000 records a day. I do monthly rotations so
it's easy to calculate how big my table gets). Granted, I don't know what
your table structure is but mine is very simple. All I do is run impor
This usually means that the mysql server hasn't been started. Check this
with the ps command.
- Original Message -
From: "Progetto 2000" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, February 06, 2001 15:47
Subject: Support request from Progetto 2000 ID support 4300
> Hi,
Usually means that the mysql server hasn't started. Check this by issuing
the ps command.
- Original Message -
From: "soon chee keong" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, February 06, 2001 21:39
Subject: cant connect to local mysql server
> hi..could someone
Why would you want to? UNIQUE() is an INDEX() the only difference being
that UNIQUE can not have the same value a number of times whereas INDEX you
can.
- Original Message -
From: "Jacob Friis Larsen" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, February 06, 2001 21:38
Subj
I thought this would have been relatively easy.
INSERT into T1 VALUES ...
then
INSERT into T2 VALUES ...
and no, you can't insert into 2 tables with 1 insert statement unless the
mysql team fixed that with the latest version.
- Original Message -
From: "Hardi Gunawan" <[EMAIL PROTECT
Did you log into mysql a root?
ie mysql -uroot mysql
- Original Message -
From: "Webmaster" <[EMAIL PROTECTED]>
To: "MY SQL" <[EMAIL PROTECTED]>
Sent: Tuesday, February 06, 2001 23:25
Subject: running mysql
> Hi,
>
> I am a new user of Linux and mysql and i have installed suse7.0 on m
Don't know about max number but unlimited, I would have thought.
SELECT b1.foo, b2.foo
FROM bar as b1, bar as b2
WHERE ...
Will get you a table join on itself.
- Original Message -
From: "goEbusiness.com Mail Lists" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, February 0
Hey all.
OK. I'm done. It's taken about 2 months to rewrite our VB app using MySQL
as the back-end, rewriting much code from DAO to ADO usng MyODBC and of
course, debugging. We've switched from MS Access 97 DB's (No more DB
Corruption, Compacting and Repairing).
One of the reasons that
I think you are a bit confused with binary and varchar. varchar is used to
store strings such as "the cow jumped over the moon" and binary means that
it is case sensitive.
You are trying to insert a hex value of 0x1, right? I think this is an
illegal value and those two entries are set to NULL.
I have access to MySQL on my host server but do not have root access or even
telnet access. Can I FTP my database tables to my directory and then refer
to those files through my php scripts using MySQL.
-
Before posting, plea
I did check the error logs, all logs, but there is nothing. No cron jobs
either. It's very strange, I did the isamchk on all the tables while mysqld
was shutdown. I don't have a clue what it could be.I've seen that some
people who have had this problem were told to have their file descript
Usually means you haven't started the server. Check by doing a ps command
and also check the manual if you don't know how to start it.
- Original Message -
From: "hocine grine" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, February 07, 2001 1:00
Subject: help me !
> my n
can: yes
should: That's up to you but personally I wouldn't
- Original Message -
From: "Hardy Merrill" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, February 07, 2001 3:31
Subject: --skip-locking on Redhat 6.1 Linux
> Can/should MySQL be started *without* --skip-locking o
Suggestions only:
Did you check the error logs? Is there a cron job running that is killing
the socket file or something?
BTW: Have you applied the latest RH patches?
- Original Message -
From: "Alex Tapia" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, February 07, 2001
Firstly, I'm not exactly sure of what you are trying to do but in any case
check out the blob column type in the mysql manual. Also, you are probably
better off storing the image on disk and only store the URL in the database.
Whichever the case, good examples can usually be found at www.devshed
Hi!
We are using PHP and want to detect if a MySQL server is available or not,
but do so very quickly. Will the MySQL library in PHP use a connection
client timeout? Can this be set under [client] in /etc/my.conf?
Also, what is the connection is a persistent connection, and the server goes
down,
Hi everyone, thanks in advance for any tips whatsoever. I've been
running mysql 3.22(STABLE) on a RedHat Linux 6.2 setup, 512 RAM, pentium
III 700 18 GIG ultrawide scsi. It's been running just fine for a few
months, then all of a sudden it just dies. When I restarted using
safe_mysqld it came u
I am surprised you said that. There are many programming languages that do
not recognise boolean datatypes. To define a boolean variable in these
languages, declare a variable as integer then 0 = false and any other number
= true.
In your case, I suggest you could try changing your Access/ASP d
I haven't had a chance to do so yet.
But, we offer 4 kinds of searches:
'$word%'
'%$word%'
'%$word'
and
'$word'
So some searches still won't use indexes.
-Original Message-
From: Quentin Bennett [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 06, 2001 7:26 PM
To: 'Ryan Hadley'; [EMAI
Hi,
For an indexed column, the index is used if the start of the string is used:
LIKE 'a string of text%' may use an index
LIKE '%any old string%' will not, since the start of the string is unknown.
The index will only be used if the server decides that it will be quicker
than a full table scan
Replication is my next best option... However, at this time replication is
a one-way street, being if the master goes down the slave can not queue up
inserts so when the master comes back up they currently cannot sync back
together.
I believe I could accomplish something like this, using replica
Yes, sockets are much faster.
Best regards,
-Eran
"William R. Mussatto" wrote:
> On Mon, 5 Feb 2001 [EMAIL PROTECTED] wrote:
>
> > Date: Mon, 5 Feb 2001 13:11:51 -0800
> > From: [EMAIL PROTECTED]
> > To: Gus Constan <[EMAIL PROTECTED]>
> > Cc: [EMAIL PROTECTED]
> > Subject: Re: Port 3306
> >
>
Just a side note... you can do JOINs on tables from different databases on the same
mySQL server
eg
SELECT t1.UserName FROM db1.table AS t1, db2.anothertable AS t2 WHERE t1.UserName =
t2.UserName
As for database layout... I would go with what makes the most sense... If having 84
tables in o
thanks for your advice vivek & rafael.
can anyone tell me why someone tried unsubscribing me from this list? Bit
rude I thought, esp with no explanation. I don't mind being told if my
questions are in the wrong place or anything like that.
dan
-Original Message-
From: Vivek Khera [ma
Nope...
It's stated explicitly in the docs that this is a *Bad Idea* (with caps,
even! *grin*). You'll need to look at other options - replication,
possibly, either on to the same machine with your db on a different
drive, or (probably preferable) onto a seperate box.
regards,
P
On Tue, 6 Feb
>
> How do you decide when a table should go into another database. For
> example, I have a database with about 12 tables and growing. I keep
> them in one database because I am doing joins that periodically involve
> all of the tables. Is this the right way to do it?
>
> Richard
Richard, I'
Thanks for the quick response.
The response time is slow... and the mysqld processes are what is hogging up
the system.
We do have indexes on the fields, but from what I understand, when you use a
"LIKE" statement, it rarely uses an index.
-Ryan
-Original Message-
From: Kent Hoover [ma
Woah! 800,000 visits a day!? Wow... try 80,000.
-Original Message-
From: Ryan Hadley [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 06, 2001 5:25 PM
To: [EMAIL PROTECTED]
Subject: Performance issues.
I'm not much of a db admin so I really don't know how to get better
performance
Take your pic - personally, I usually use a tinyint, and assign a 0 or 1
- I suspect the options you describe would work just as well.
regards,
P
On Tue, 6 Feb
2001, John Halladay wrote:
> If I am using MS Access and linking to tables in MySQL through MyODBC, what
> is the equivalent format of
I am trying to setup some sort of loadbalancing and more importantly
fail-over-services for my mysql servers. I would like to have all the data
stored on a RAID interface that will mirror the data and provide the data to
two separate mysql daemons on two separate boxes. That way if one daemon or
Ryan:
If your response time for this query is slow, it is likely that an INDEX
will help
you. (Read about CREATE INDEX in the MySQL manual.
If you don't already have an INDEX on the keyWord column, create one.
If you can induce your customer/users to type more characters, that
would help.
WHERE
Thanks for the responses. Both those comments will no doubt help me
out next time. this time around, pathetically enough, it was bad
line breaks due to the fact I decompressed it on a mac and then
uploaded it.
how embarasskin.
MT
--
I'm not much of a db admin so I really don't know how to get better
performance out of our database... but it seriously needs some speeding up.
We have this huge dictionary... It's 272235 rows. We have to be able to
search through it.
We run about 800,000 visits a day.
Right now we're doing a
If I am using MS Access and linking to tables in MySQL through MyODBC, what
is the equivalent format of a checkbox (Yes/No) in MySQL?
Would it be ENUM('Yes','No') or ENUM('True','False')? All caps TRUE, YES,
etc.?
Thanks ahead of time for your input.
John Halladay
Hi,
mysql -vvv samp_db < create_member.sql
should tell what commands mysql is executing.
Regards
Quentin
-Original Message-
From: Michael Tuminello [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, 7 February 2001 10:05
To: [EMAIL PROTECTED]
Subject: creating tables from the shell
Hey -
Let me add to this. I meant to say: He could create a function that would
do it, and use it in his queries?
Gregg
- Original Message -
From: Gregg Housh <[EMAIL PROTECTED]>
To: Russ Davies <[EMAIL PROTECTED]>; Matt Friedman <[EMAIL PROTECTED]>;
MySQL List <[EMAIL PROTECTED]>
Sent: Tuesd
http://www.mysql.com/doc/A/d/Adding_functions.html
Could this help him out? Creating a User Defined Function?
Gregg
- Original Message -
From: Russ Davies <[EMAIL PROTECTED]>
To: Matt Friedman <[EMAIL PROTECTED]>; MySQL List
<[EMAIL PROTECTED]>
Sent: Tuesday, February 06, 2001 3:42 PM
S
I use True/False fields all the time from MS Access through myODBC. While
I've not used ASP, it would seem that the functionality would be the same.
If this is the case, then True is represented by -1 and False is
represented by 0. Simply use the TINYINT that mySQL provides to store
these two v
I have read that IBM has concluded that Linux is ready for the big time.
That may be true for Linux but I would doubt that the same could be said
for MySQL. For example the missing host.frm has been in threads in the
archive for a long time, I have been
bitten by the beast with no success yet in s
When a True data type is passed in from ASP, the resultant SQL command will
look like this :
INSERT INTO tableName (fieldName) VALUES (True);
Not this :
INSERT INTO tableName (fieldName) VALUES ('True');
So produces an error as the value is not enclosed in quotes, which it would
need to be for an
It's ok for a table to have 2 keys that COULD be the PIKE. only 1 of them
can actually BE the PIKE, the other is a Candidate Key. (CK)
As to whether you should make them both part of the PK, that's a different
question. I usually avoid compound PK's unless there is NO OTHER WAY AROUND
IT.
Cal
ok it looks like your funneling whatever query you have in create_member.sql
into mysql and executing it on the samp_db database. From your filename I'm
assuming that you have a "create table" query within create_member.sql. Is
the table not being created within samp_db?
Try this:
./bin/mysql s
Couldn't you just do:
boolVarsENUM ('True', 'False') DEFAULT 'False'
-or-
boolVarsENUM ('TRUE', 'FALSE') DEFAULT 'FALSE'
unless I'm misunderstanding what you are saying about ASP.
> -Original Message-
> From: Russ Davies [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, Fe
Enum would allow me to have two values such as 'True' and 'False' ?
The problem is when I pass in this SQL statement to mySQL:
INSERT INTO tableName (fieldName) VALUES (True);
-mySQL does not recognise the word True - it would need to be in quotes,
which means changes in the code on the web serv
Hi,
Do you mean that the table has two unique indices, or that the primary index
has two columns?
Either way, it is easy to define this in mysql:
create table foo (
col1 varchar(20) not null,
col2 int not null,
col3 smallint not null,
primary key(col1, col2),
unique second_idx(col1, col3));
Ho
> "RD" == Russ Davies <[EMAIL PROTECTED]> writes:
RD> Thanks for the suggestion, but this would still mean converting the data
RD> type from within ASP (the 'True' type) down to a char ('T') would it not?
then use
ENUM('False','True')
instead. Enum can have any string you want. I person
Try using enum in mysql. That might help you out a bit.
Matt Friedman
Spry New Media
http://www.sprynewmedia.com
Lead Programmer/Partner
email: [EMAIL PROTECTED]
phone: 250 744 3655
fax: 250 370 0436
- Original Message -
From: "Russ Davies" <[EMAIL PROTECTED]>
To: "Oson, Chris M." <[EMA
Hey -
sorry for being too much of a pinhead to figure this out, but the
server is really not giving me too many clues to work with.
I'm trying to execute commands from the shell to create new tables
(I'm walking through the new riders book).
the book says % mysql samp_db < create_member.sql
Terribly simple question, but I'm fairly new at this.
I'm building a database based off a model built in MS Access. The table
that I'm currently working on appears to have two Primary Keys, although I'm
assuming one of them must be secondary. How would I specify this in
creating the table in My
Hi All,
I'm trying to port MySQL 3.22.32 to HPUX 10.20 and am encountering some
problems. I'm on an HPUX 10.20 box with GCC 2.95.2, the configure script
works fine when I build I get:
mysqld.cc: In function `void close_connections()':
mysqld.cc:262: implicit declaration of function `int shutd
I can't do that for 2 reasons :
1] 'True' and 'False' are reserved words in ASP
2] 'True' would then be a variant holding the value 'T' - which would mean I
could not carry out logical comparisons with the two variants, evaluating
things against True or False.
I have to say after all the reccomen
How do I save an images to a unix file that is saved in mysql? I know how to view the
image with PHP and I know how to write a file to unix. I just can't get the data from
mysql into a format that will allow me to read it then write it.
--
Maybe, but you could define a constant..
CONST TRUE "T"
CONST FALSE "F"
INSERT INTO logInfo2 (logID, ipAddress, boolVars) VALUES (null,
'192.192.192.192', TRUE)
-Original Message-
From: Russ Davies [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 06, 2001 11:44 AM
To: Oson, Chris M.;
Thanks for the suggestion, but this would still mean converting the data
type from within ASP (the 'True' type) down to a char ('T') would it not?
It is more sensical than using 1/0 but still involves the same number of
processes?
Russ Davies
- Original Message -
From: "Oson, Chris M.
Can/should MySQL be started *without* --skip-locking on Redhat
6.1 Linux?
TIA.
--
Hardy Merrill
Mission Critical Linux, Inc.
http://www.missioncriticallinux.com
-
Before posting, please check:
http://www.mysql.com/manual.ph
In the process of converting over to 3.23.30-gamma from 3.22
whenever I set the field to a binary field to a value it stores it in
the database as zero.
Does anyone have any suggestions.
I am having a problem with the binary data type... Here is the log to
demonstrate.
---
The answer is no, MySQL does not include a native driver for Delphi.
However, you can use MyODBC or one of the third-party drivers readily
available...
See the MySQL manual: http://www.mysql.com/doc/S/E/SEC521.html
On Tue, 6 Feb 2001, Paulo Serra wrote:
>
> I am a DELPHI developer and I n
Check out REGEXP in the manual.
--
"There cannot be a crisis today. My schedule is already full."
--Henry Kissinger
> -Original Message-
> From: Ung, Seng [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, February 06, 2001 11:03
> To: [EMAIL PROTECTED]
> Subject: Select a range from 0-9
Well, depends how you want to connect.
For example, if you have the mysql odbc driver, you could use odbc to
connect.
However, i personally prefer to use libmysql.dll, with a delphi interface
file.
I can send you the interface file i use if you want (originally written by
bob silva, but i adjusted
Why not try using ENUM?
http://www.mysql.com/doc/E/N/ENUM.html
You could setup your table like this:
CREATE TABLE logInfo2
(
logID INT NOT NULL UNIQUE,
ipAddress VARCHAR(20) NOT NULL DEFAULT 'None',
boolVarsENUM ('T', 'F') DEFAULT 'F'
)
SELECT ipAddress FROM
i just answered my own question:::
shell> mysql -u root mysql
mysql> UPDATE user SET Password=PASSWORD('new_password')
WHERE user='root';
mysql> FLUSH PRIVILEGES;
You can, in MySQL Version 3.22 and above, use the SET PASSWORD statement:
shell> mysql -u root mysql
mysql> SET PASSWO
Try:
select whatever from whatever where field like '[0-9]%'
http://www.mysql.com/doc/P/a/Pattern_matching.html
-Original Message-
From: Ung, Seng [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 06, 2001 9:03 AM
To: [EMAIL PROTECTED]
Subject: Select a range from 0-9 or A-z
hi:
Her
I have a Perl program that gathers data and inserts it into a Mysql
database via DBI (DBD::mysql). The program performs multiple inserts, one
right after the other.
On my OBSD 2.7 box, everything works just fine -- but when I try to run
the same script on my OBSD 2.8 box, it will run through a c
Serveur d'application JBossI got a problem with my connection to a Mysql Database. (
am
programming with JSP, using a JDBC driver...)
The problem is that I got an Error 500 when I am trying to
connect to my database ... Actually, There is a "Bad Handshake"
error ...
I don't know what is it due
Try using this function on your data before inserting into the database.
http://www.php.net/manual/en/function.addslashes.php
If that doesn't work show us what error you are getting.
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Monday, February 05,
"Ung, Seng" wrote:
>
> hi:
> Here is my SQL statement to select a range of number from 0-9
>
> Is there a short cut to this?
>
> id like '1%' or id like '2%' or id like '3%' or id like '4%' or id like '5%' or id
>like '6%' or id like '7%' or id like '8%' or id like '9%' or id like '0%'
see R
I am working with an NT4.0 platform, mySQL 3.23 and using ASP and myODBC to access my
data.
I was hoping to find a BOOLEAN data type within mySQL which would allow me to pass
either 'True' or 'False' in - but it appears there isn't one?
Using 'BOOL' as the column type appears to create a tinyin
I copied and pasted your create table query into mysql and it created the
table without a problem. I'm using 3.32.32.
mysql> describe top
-> ;
+-+---+--+-+-++
| Field | Type | Null | Key | Default | Extra |
+-+--
Redhat comes with mysql already installed as a RPM usually. I had the
same problem until I unstalled the RPM that came with Red Hat. A fix
for this problem if you don't want to uninstall the original can be found
at:http://www.mysql.com/doc/I/n/Installing_many_servers.html
-Original Message-
From: Ung, Seng
Sent: Tuesday, February 06, 2001 9:03 AM
To: [EMAIL PROTECTED]
Subject: Select a range from 0-9 or A-z
hi:
Here is my SQL statement to select a range of number from 0-9
Is there a short cut to this?
id like '1%' or id like '2%' or id like '3%' or i
>Description:
Sometimes, when you get a resync error, you need to skip
a particular update and restart with the next bit.
>How-To-Repeat:
Insert conflicting records and try to re-sync without deleting one.
>Fix:
Apply this patch.
Index: noris.38/sql/mysqlbinlog.cc
Unix sockets are about 30% faster than TCP connections on the local machine
-- at least according to TCX's tests and some of my own.
"William R. Mussatto" <[EMAIL PROTECTED]> wrote:
On Mon, 5 Feb 2001 [EMAIL PROTECTED] wrote:
> Date: Mon, 5 Feb 2001 13:11:51 -0800
> From: [EMAIL PROTECTED]
>
>Description:
I have a perl script which gathers data and then performs multiple inserts
into a mysql database via DBI and DBD::mysql. On a OBSD 2.7 box runing
the same version of mysql, the script works just fine. However, when i run
the exact script on th
woops, my fault :)
I'll subscribe to the MyODBC list and see what I can find there, thanks :)
- Original Message -
From: "Sinisa Milivojevic" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, February 06, 2001 4:03 AM
Subject: Re: MyODBC and SQL_BIT type
Maybe you need to add the -p option so that it asks you for your password
before you can shutdown
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list a
Im new to the list, apologies if this has been asked before.
Im developing a backend for a personal site (www.russd.com) using mySQL.
The site is hosted on NT4 and has myODBC installed, I have some database access
working, but I'm looking for a way to implement boolean types.
Using Access/SQL s
hi:
Here is my SQL statement to select a range of number from 0-9
Is there a short cut to this?
id like '1%' or id like '2%' or id like '3%' or id like '4%' or id like '5%' or id
like '6%' or id like '7%' or id like '8%' or id like '9%' or id like '0%'
thank you
seng
my name is grine hocine ;
please help me ,i have installed mysql and php from
redhat version 7 and when i run the application in the
same machine , i receive this error message "MySQL
connection failed can't connect to local MySQL server
through socket '/var/lib/mysql.sock'(111)
thank you for all
Hi,
the inserts did not change the state after the select finished. The network is
running full duplex but the only problem I ever encountered with the cards was
initalization on fast systems. I fixed this and posted it to the linux kernel
mailing list (search for epic100).
If the problem continue
1 - 100 of 175 matches
Mail list logo
