How do I uninstall a MySQL source installation on Linux ?
Regards Jacob
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request thi
Hi,
try to use phpinfo()... it will list all php configuration and support
modules.
-Original Message-
From: Sameer Maggon [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 23, 2002 4:37 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: Apache + php + MYSQL
Hi,
How do i check
Hi,
How do i check whether PHP has MYsql support built or not
Please help
Sameer
--
you wrote:
On Tuesday 21 May 2002 09:51, Robert Vetter wrote:
> On Tuesday 21 May 2002 10:38, Sameer Maggon wrote:
> in /var/www/html/rcmms/appl.php on line 5
>
> Hello,
>
> 1. make shure the PHP module is
you can try command "ps -ef | grep mysql"
to see if "safe_mysqld" is alive
and also one or more "mysqld" processes are running
to check the socket
type command "netstat -na | grep 3306" see if you can see
the processes are listening to the socket
if the socket if not being listen, you cannot con
In the last episode (May 22), Jeremy Zawodny said:
> On Wed, May 22, 2002 at 03:52:33PM +0800, Patrick Hsieh wrote:
> > Hello Dan Nelson <[EMAIL PROTECTED]>,
> >
> > Is there any lock problem on iSCSI or SAN environment? Say,
> > mutliple mysql server mount the backend iSCSI or SAN storage
> > de
Dear all,
my company is currently using mysql database with php. Now there's this
company which is using LDAP with Oracle and we need to be able to link them
together.
They suggest tht we use LDAP with Mysql. I've tried looking for information
abt using ldap and mysql but invain.
Can you please
Okay so it says that I can't connect through socket
'/var/lib/mysql/mysql.sock'. So I checked and the UNIX socket is located
here: /tmp/mysql.sock. I'm relatively new to Linux. What does this mean?
-Hoa
_
Join the worlds large
On Tue, May 21, 2002 at 08:09:36AM -0400, Nick Stuart wrote:
> Ok, so know you got me interested. What exactly are R-Trees.
http://www.google.com/search?hl=en&q=r-tree
:-)
Jeremy
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 Fax: (408) 349-54
On Wed, May 22, 2002 at 03:52:33PM +0800, Patrick Hsieh wrote:
> Hello Dan Nelson <[EMAIL PROTECTED]>,
>
> Is there any lock problem on iSCSI or SAN environment?
> Say, mutliple mysql server mount the backend iSCSI or SAN storage device.
> Is it safe?
It is safe if you use MySQL's external (file
Hello,
I have the mysql server running. I can't connect to it though. It reads,
"Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock'.
-Hoa
_
MSN Photos is the easiest way to share and print your photo
I apologize for not including that in my original post. Here's my create
table statement:
For albums, artists, tracks:
CREATE TABLE artists (artists VARCHAR(50), id MEDIUMINT NOT NULL
AUTO_INCREMENT PRIMARY KEY)
For albums_artists, artists_tracks, tracks_albums:
CREATE TABLE albums_artists (album
On Thu, May 23, 2002 at 10:10:26AM +0530, Kannan R wrote:
>
> I have come across a wierd error in my replication setup..I run
> mysql 3.23.49 on two servers .one is the master and the other the
> slave..I have jus one DB with jus a single table in it. I 'm getting
> the follwoing error on my slav
This simply can't be correct - if a match produces "0" score (no
relevance), the whole condition part after "AND" in this example could
be reduced to "0" (=FALSE), hence the query *should* produce 0
records:
SELECT ISBN,TITLE FROM tBooks WHERE tBooks.ISBN="1876340436" AND 0;
...and here is a rea
Placed At :
Hi..
I have come across a wierd error in my replication setup..I run mysql 3.23.49 on
two servers .one is the master and the other the slave..I have jus one DB with
jus a single table in it. I 'm getting the follwoing error on my slave
to make it easier for others to help you. you should have posted the
create table statement, insert statement for a small set of data so that
anyone of us could easier reproduce your problem.
btw, are you sure you need 3 links between those 3 tables. please
correct me if i'm wrong. i think 2 link
I had problems with unions that result in large queries too.
I found that MySQL 4 was using Heap tables for Unions.
One can Increase the Heap Table size to help, but
What about alot of conncurrent users running unions?
This could eat up alot of memory.
Is there a switch to stop unions from using
Has anyone built MySQL 4.x from the BitKeeper tree using LinuxThreads
on FreeBSD?
If so, how'd you do it?
Thanks,
Jeremy
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936
I'm trying to compile 75 playlists of 25+ songs each into a database
sortable by date the show was produced, track, album, and artist. I got
advice from someone as to how to layout the table structure, and basically
it was said that I should have a basic structure of 6 tables, one for
artists, one
Anybody has tried installing MySQL on CygWin?
R.B.Roa
Traffic Management Engineer
PhilCom Corporation
Tel. No.(Office) 858-1028
(Home) 858-8889
Mobile No. (63) (919-3085267)
-
Before posting, please check:
http:/
At 18:29 -0400 5/22/02, Jule wrote:
>Hey guys,
>when i delete a row using the query DELETE FROM $table WHERE id = "3" LIMIT 1;
>
>how can i make it that the id column (auto_increment) starts over from 1 and
>build up to however many rows there are without counting 1 2 4 5 6 etc.?
If you're asking
That seems like it should work as well. Just want to make sure that root
doesn't have any privileges over and beyond what a regular added user with
all privileges would have. I wouldn't think so, but sometimes this is
something that's not specifically documented. Thanks!
Jeff
> -Original
I think this is a bug
it seems it is reasonable since UNIX/C does consider back slash a
escape prefix for a sequence, in some case, it is not as nice as you think.
in multi-character set, back slash can be included in one of the
multi-characters.
I fix the problem by writing a VB program and a s
The answer is there ... :
http://www.mysql.com/doc/L/O/LOAD_DATA.html
Gurhan
-Original Message-
From: Wong Zach-CHZ013 [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 22, 2002 8:18 PM
To: Wong Zach-CHZ013; '[EMAIL PROTECTED]'
Subject: RE: Duplicate Record
> -Original Message---
> -Original Message-
> From: Wong Zach-CHZ013
> Sent: Wednesday, May 22, 2002 7:11 PM
> To: [EMAIL PROTECTED]
> Subject: Duplicate Record
>
> Hi
> 1) Suppose, in a file, say testfile.sql,
> it contains a line
> eg:
> LOAD DATA INFILE "mlc_stat_" INTO table mlc FIE
Hi
1) Suppose, in a file, say testfile.sql,
it contains a line
eg:
LOAD DATA INFILE "mlc_stat_" INTO table mlc FIELDS TERMINATED BY '|' ;
And further suppose the record in file mlc_stat_ already exists in the
table mlc.
Does MySQL have the ability to stop inserting this duplicated record
Hi
1) Suppose, in a file, say testfile.sql,
it contains a line
eg:
LOAD DATA INFILE "mlc_stat_" INTO table mlc FIELDS TERMINATED BY '|' ;
And further suppose the record in file mlc_stat_ already exists in the
table mlc.
Does MySQL have the ability to stop inserting this duplicated record
Greetings Friends,
How could cache the whole mysql database in the memory? Which parameters
would help?
Regards.
Ravi Verma
916 705 3261
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
htt
I am adding a web interface to a Windows application I have written
that uses another proprietary database system. To allow for my
customers to use both Linux and WinNT based web servers, I have
settled on MySQL for the web database. I am working on a strategy for
allowing my customers to move the
hello,
i have a table as follows:
Members (
teamID int(6) unsigned default '0',
ID int(11) unsigned NOT NULL auto_increment,
name varchar(30) default NULL,
number smallint(5) unsigned default NULL,
height tinyint(3) unsigned default NUL
"Sergei Golubchik" <[EMAIL PROTECTED]> wrote:
> It looks like a bug. Can you create a test case for this ?
create table tBooks (
isbn char(10) not null primary key,
title varchar(60) not null,
fulltext index (title)
);
insert into tBooks (isbn,title) values
('1876340436','2000 Lonely Planet Cale
How did you try to connect it??? IS your mysql server running? If yes is the
mysql.sock location correct?
Gurhan
-Original Message-
From: Glenn Hancock [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 22, 2002 4:48 PM
To: MySql
Subject: Installing / Running
I have installed MySQL on my
Hi.
Because the backslash is the escaping character and therefore has a
special meaning, you have to escape it itself to get a plain
backslash. I.e.
mysql> insert into table (Field1) values ('\\');
This will insert one backslash. This is documented here:
http://www.mysql.com/doc/m/y/mysql.html
Hi,
You should be able to do it with a tweak.. You can create a user and give
all the priviliges to that user in the user table of mysql database, and
then takeaway the privileges from the user root. Would that work for you?
Gurhan
-Original Message-
From: Jeff Field [mailto:[EMAIL PR
Hi Bruno !!
Nope, the query OK is NOT skipped but the query has not
been executed at all !!
And this is not a bug !!!
The backslash in Your query escapes the following single quote
and the query will not be terminated by ";" .
You should propably escape the backslash instead like this
mysql> in
Yes, there is .. You can use %D (note that it is capital D) instead of %e to
get what you wanna get.
See: http://www.mysql.com/doc/D/a/Date_and_time_functions.html
Gurhan
-Original Message-
From: Lee P Reilly [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 22, 2002 5:51 PM
To: MySQL
Su
MySQL is doing the right thing, \' will mean single-quote character, so you
will have to close it with another one. If you want to enter just a
backslash do '\\' .
See: http://www.mysql.com/doc/S/t/String_syntax.html
Gurhan
-Original Message-
From: Bruno Batarelo [mailto:[EMAIL PROTECTE
At 16:02 22/05/2002 +0800, Patrick Hsieh wrote:
>Hello list,
>
>I am expecting to have 30,000 http clients visting my website at the
>same time. To meet the HA requirement, we use dual firewall, dual
>Layer-4 switch and multiple web servers in the backend. My problem is,
>if we use the user-tracki
At 23:58 +0200 5/22/02, Bruno Batarelo wrote:
>Greetings
>
>I use latest stabile version of MySQL. Please, try to create temp table or
>normal table and from mysql.exe try to insert a backslash symbol into a
>field. Here is an example:
>
>Enter password: **
>Welcome to the MySQL monitor. Comm
Hey guys,
when i delete a row using the query DELETE FROM $table WHERE id = "3" LIMIT 1;
how can i make it that the id column (auto_increment) starts over from 1 and
build up to however many rows there are without counting 1 2 4 5 6 etc.?
any ideas?
Jule
--
|\/\__/\/|
|
I have installed MySQL on my RH Linux 7.3 box. I am trying to use it with
the Apache web server but haven't gotten that far. I downloaded the source
version because I am new to Linux and felt that I would understand better
where everything was as far as the files and source code.
The original
I have had trouble with the script that creates my user access tables.
I am assuming those tables should get created in the ./var/mysql folder.
Its my fault but I removed those tables just to see if they had anything to
do with me not being able to use the mysql database server. I figured it
was
Greetings
I use latest stabile version of MySQL. Please, try to create temp table or
normal table and from mysql.exe try to insert a backslash symbol into a
field. Here is an example:
Enter password: **
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 441
Hi,
I have a quick question concerning date/time functions. If I query
MySQL:
SELECT date_format(date, '%W %M %e %Y') FROM experiments where
expid=3706
It returns: Wednesday May 2 1979
Are there existing methods for determining whether to add "st", "nd" or
"rd" after the %e?
e.g. in thi
I've had a question that I haven't really seen addressed anywhere...
Is it okay to change the default "root" user name to a different name? Any
issues involved by doing so?
The reason I ask is that it seems to me that, because everyone knows that
MySQL installs with the root user, one simple ex
I am keen to here a response to this as well!
TIA
Mike
- Original Message -
From: "Williamson, David" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, May 22, 2002 4:38 PM
Subject: Ibdata1 file thats just too big...
> Hi there,
>
> My Ibdatafile is set too big (the disk is
Chris Knipe wrote:
>Multiple subnets :/
>
>columns like this:
>octet1, octet2, octet3, octet4
>195,196,192,23
>232,196,231,11
>
>This would then be seen as a duplicate
Not if you have a single index spanning all four columns (as opposed to
four indexes, one on each column). With the sin
I ran: nm /usr/local/lib/libmysqlclient.a | grep mysql
and all of the function that are undefined are there.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
are you familiar with the different MySQL table types?
they are:
MyISAM
BDB
Gemini
InnoDB
but InnoDB is the most robust, supports row-level locking, ACID transactions (no dirty
reads), and foreign key restraints... read up on it here: http://www.innodb.com
but InnoDB does multi-versioni
when i try to run phpMyAdmin on an apache server on Windows 2000 I always
get the following message:
Can't connect to MySQL server on 'localhost' (10061)
could anyone please tell me how to configure MySQL to run via tcp/ip on
localhost?
thanks a lot
gunnar
-
Richard,
> I will look at the UNION problem later.
I think MySQL uses a HEAP type temporary table when it calculates the UNION.
HEAP type tables are allocated from the main memory. The message 'Table is
full' tells that MySQL cannot allocate more memory.
Regards,
Heikki
> Best regards,
>
>
And who said you ever get to old to learn :)
Never knew I could do unique indexes like this.. Definitely what I'm
looking for... Thanks guys :)
--
me
- Original Message -
From: "Ryan Hatch" <[EMAIL PROTECTED]>
To: "Chris Knipe" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesda
Hi there,
My Ibdatafile is set too big (the disk is full to the point that nothing is
executing properly) I am wondering is it safe to delete this file and then
in the my.cnf file reset the size to something smaller... - how does the
Ibdata file work in conjunction with mysql...
Will I lose data
I am trying to compile a custom program I wrote some c++ wrapper classes
around the mysql c function. I have the mysqlclient_r lib installed in
/usr/local/lib/
ls -l /usr/local/lib/libmysqlclient_r.a
rw-r--r--1 root root 287356 May 22 13:28
/usr/local/lib/libmysqlclient_r.a
The fi
abw wrote:
> Is it possible to zip up database directories on one server and move
> them to another server, then simply unzip them?
Yes.
> If so, once that is done, does something need to be done to mysql so
> it is aware of the databases? Is there some file that has a list of
> databases th
Hi all,
We need to prevent Dirty Reading.
How can we perform transaction isolation in mySQL? Are the following:
TRANSACTION_SERIALIZABLE, TRANSACTION_REPEATABLE_READ, TRANSACTION_READ_COMMITTED,
TRANSACTION_READ_UNCOMMITTED, TRANSACTION_NONE supported by MySQL? Or has anyone tried
any other
you're not making much sense to me
in your first post... you wanted make sure every IP you have is unique, correct?
Do an ALTER TABLE with "UNIQUE(octet1, octet2, octet3, octet4)".
or am I not understanding your question?
Regards,
-Ryan Hatch
* remember me? yesterday #php on DALNet, G3X7
C
On 22 May 2002, at 14:52, Richard Bolen wrote:
> Is there any way via a SQL query to force case sensitivity to be
> used for a non-binary char field? i.e.: for comparing strings in a
> case sensitive way.
SELECT * FROM users WHERE BINARY password = 'cAsE_MAttErS';
http://www.mysql.com/doc/C/a/
Hi!
> "Heikki" == Heikki Tuuri <[EMAIL PROTECTED]> writes:
Heikki> Andrei,
Heikki> this is probably not a bug in InnoDB. In theory, 4000 random disk seeks
Heikki> would use more time than scanning the whole table of 700 000 rows.
Heikki> The optimizer was tuned .48 (not yet in 4.0.1) to fa
Hi,
I was converting my table from MyISAM to Innodb, but i had a trouble. I had
to kill an alter table command (It was an ADD INDEX in a DATETIME field) but
it didn't stop. So i restarted the mysql but the mysql starts only if i
disable innodb. Did i lost all my innodb tables? Is there an
yes, you needed to use the PASSWORD( ) function
mysqladmin -h hostname -u user password 'new password'
-Ryan Hatch
"Miretsky, Anya" wrote:
> I tried to create a password for the root user in a new installation of
> MySQL by typing
> % mysql -u root mysql
> Then typing and update statement li
Hello,
I think that MAX_SLOW_QUERY_PER_HOURS is useful options for
GRANT ... WITH MAX_QUERIES_PER_HOUR = N1
MAX_UPDATES_PER_HOUR = N2
MAX_CONNECTIONS_PER_HOUR = N3;
statment.
Thank.
Best regards,
Andrew Sitnikov
e-mail :
A colleague who is connecting to mysqld started as "/u/local/mysql/bin/safe_mysqld
--user=mysql --safe-show-database --default-character-set=ujis -O
wait_timeout=$WAITTIMEOUT -O max_connections=$MAXCONNECTIONS &" has encountered the
following problem:
"We could not add data which contains 0xA
Hopefully this is the right list. We have multiple servers going, and one
user just set up a dedicated machine with mysql. He had about 5 databases
going on another server for months with no problem. The new server has a
different version of mysql on it. I copied the database directories over
Hi!
The fact that foreign key definitions do not honor lower_case_table_names=1
is mentioned in the manual. I have added the fix to this on the TODO list
for July 2002.
You have found the right place, this mailing list is the right place to
report bugs in InnoDB.
Best regards,
Heikki Tuuri
Inn
Hi Richard,
Richard Bolen wrote:
>If I understand correctly, you have to define a char field as binary if you want the
>database to treat it as a 'case sensitive' field. Is there any way via a SQL query
>to force case sensitivity to be used for a non-binary char field? i.e.: for
>comparing
Nick,
You're going to be mostly out of luck.
You can ship a MySQL binary with a pre-configured config, and get the java
app to exec the binary, and send a shutdown command when it's finished.
Alternatively you can assist me in developing my Type II driver for MySQL,
then embed libmysq
Multiple subnets :/
columns like this:
octet1, octet2, octet3, octet4
195,196,192,23
232,196,231,11
This would then be seen as a duplicate
Kind Regards,
Chris Knipe
MegaLAN Corporate InterNetworking Services
Tel: +27 21 854 7064
Cell: +27 72 434 7582
- Original Message -
From: "Myk M
Hi,
How should I setup MySQL development environment? We run MySQL from Sun
Solaris. I have a script file to create tables and load data which will
be distributed to all developers. The developer will "own" his set of
data where he is the only one who can modify it.
In Oracle, each user acc
If I understand correctly, you have to define a char field as binary if you want the
database to treat it as a 'case sensitive' field. Is there any way via a SQL query to
force case sensitivity to be used for a non-binary char field? i.e.: for comparing
strings in a case sensitive way. Or is
Chris Knipe wrote:
>I'm currently storing them into varchar(16), although I've been thinking of
>doing it as for smallint columns, but then I can't be 100% certain I won't
>get duplicates.
>
Why not? Just define a UNIQUE index across all four smallint columns,
and MySQL will throw an error
Amy Zediak wrote:
>I'm trying to install Bugzilla and according to the instructions you
>have to make a few changes to MySQL and i'm a little confused. It says
>that you have to add mysqld to init script and then add -0
>max_allowed_packet=1M to the command that starts mysqld. I'm not
>complete
Sorry to jump into the conclusions:) IT wasn't evena sub select and union
is used to join the results of SELECT statements...
Your statement can be written as "SELECT location FROM visiExPr WHERE
(location=1 OR location=0) GROUP BY location;
What version of MySQL are you running? UNION
>Description:
When using MySQL with InnoDB table type, and turning on the
table case-insensitivity flag in the config file
(set-variable = lower_case_table_names=1), MySQL/InnoDB does not
correctly handle the case-insensitivity of the target table name in
the REFERENCES part of the FOREIGN KEY cla
I tried to create a password for the root user in a new installation of
MySQL by typing
% mysql -u root mysql
Then typing and update statement like
> Update user set password = "somepassword" where user="root";
After doing this I typed because I could still get into mysql without a
password % my
Hello,
I think that MAX_SLOW_QUERY_PER_HOURS is useful options for
GRANT ... WITH MAX_QUERIES_PER_HOUR = N1
MAX_UPDATES_PER_HOUR = N2
MAX_CONNECTIONS_PER_HOUR = N3;
statment.
Thank.
Best regards,
Andrew Sitnikov
e-mail :
Hi all,
What's the best way to store a numeric IP address into a table with the
least possible size and overhead on the mysql server?
I'm talking millions of records here With not one single duplicate IP
address (unique index)..
Currently, the database hosts just over 1.2 million unique add
I searched the archive found the issue but not the answer.
Configuration:
I'm running win2000, mysql is loaded and I can manually create databases and
tables per "MySQL" manual (via Amazon). I've loaded samp_db in sub
directory of mysql.
Problem:
mysql> samp_db < create_president.sql;
Result:
The is the proper, documented functionality of the timestamp field. An
exerpt from http://www.mysql.com/doc/D/A/DATETIME.html is below:
The TIMESTAMP column type provides a type that you can use to automatically
mark INSERT or UPDATE operations with the current date and time. If you have
multipl
I tried to create a password for the root user in a new installation of
MySQL by typing
% mysql -u root mysql
Then typing and update statement like
> Update user set password = "somepassword" where user="root";
After doing this I typed because I could still get into mysql without a
password
% my
He is not doing a sub select...he is doing a union. Unions are
implemented in MySQL 4.x
HTH
Sam Masiello
Software Quality Assurance Engineer
Synacor
(716) 853-1362 x289
[EMAIL PROTECTED]
-Original Message-
From: Gurhan Ozen [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 22, 2002 12
I'm trying to install Bugzilla and according to the instructions you
have to make a few changes to MySQL and i'm a little confused. It says
that you have to add mysqld to init script and then add -0
max_allowed_packet=1M to the command that starts mysqld. I'm not
completely sure how to do this
- Original Message -
From: "Dan Harrington" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, May 22, 2002 5:41 PM
Subject: Loading massive data set from CSV
> Greetings everyone,
>
> I have an ASCII CSV or Tab Delimited file that is
> roughly 3.5 gigabytes, and I want to loa
In message <[EMAIL PROTECTED]>, "Dan Harrington" write
s:
> I have an ASCII CSV or Tab Delimited file that is roughly 3.5
> gigabytes, and I want to load it into a mysql database so I can do
> some analysis. First of all, I'm wondering, is there anything I
> should be aware of, or worried about,
Hi,
Perhaps try to remove the brackets ?
SELECT location FROM visiExPr where location=1 UNION SELECT location FROM
visiExPr where location=0;
(I assume you're using MySQL 4.0.x ?)
Regards,
Jocelyn Fournier
- Original Message -
From: "Dan Liu" <[EMAIL PROTECTED]>
To: ">" <<[EMAIL PRO
Hi!
On May 22, Victoria Reznichenko wrote:
> Przemyslaw,
> Wednesday, May 22, 2002, 2:02:52 AM, you wrote:
>
> PP> SELECT ISBN,TITLE FROM tBooks
> PP> WHERE tBooks.ISBN="1876340436"
> PP> AND MATCH (tBooks.TITLE) AGAINST ("britannica")
>
> PP> ++-+
> PP>
Hello,
I'm currently building a free mySQL database service. I have managed to
solve the quota problem with this list. Thanks to all!
Now I have another problem:
If a large number of databases have been created (>1000) it takes some time
to change a database. I do know that I can ommit the prob
Hi,
Could somebody tell me what is wrong with this query?
select location from visiExPr where location=1 union (select location from
demandInfoAd where location=0);
ERROR 1064: You have an error in your SQL syntax near 'union (select location from
demandInfoAd where location=0)' at line 1
Than
Dan,
Wednesday, May 22, 2002, 6:57:49 PM, you wrote:
DL> Could anybody tell me why the following query does not work?
DL> SELECT location FROM visiExPr where location=1 union (SELECT location FROM
visiExPr where location=0);
DL> Thanks!
What exactly doesn't work? Have you got an error or wrong
Greetings everyone,
I have an ASCII CSV or Tab Delimited file that is
roughly 3.5 gigabytes, and I want to load it into a mysql
database so I can do some analysis.
First of all, I'm wondering, is there anything I should be aware of,
or worried about, size-wise?
I know that I can't even look a
It works for me in text columns.. Can you give more insights? your table
structure and exact query you issued?
Gurhan
-Original Message-
From: J) A 2( <[EMAIL PROTECTED]> [mailto:J) A 2( <[EMAIL PROTECTED]>]
Sent: Wednesday, May 22, 2002 12:02 PM
To: [EMAIL PROTECTED]
Subject: about get
Sub-selects are not permitted in MySQL yet..
See: http://www.mysql.com/doc/A/N/ANSI_diff_Sub-selects.html
Gurhan
-Original Message-
From: Dan Liu [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 22, 2002 11:58 AM
To: >
Subject: Union does not work
Hi,
Could anybody tell me why the foll
David,
if the corruption happens again, please run CHECK TABLE and report what you
get to 'hostname'.err. 3.23.52 will also contain diagnostic code which will
help to track the problem.
Best regards,
Heikki
- Original Message -
From: "David Piasecki" <[EMAIL PROTECTED]>
To: "'Heikki Tu
Hi,
Sometime when connecting to mysql I get
mySQL Error Code: (2003)
Can't connect to MySQL server on '127.0.0.1' (10061)
even when the server is up and running.
I think it might happen cause it is very busy.
I there a way to maybe make it wait longer for the client to connect?
Thanx
Konrad
First question: did you set autocommit=0?
--Walt Weaver
Bozeman, Montana
-Original Message-
From: a a [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 22, 2002 9:27 AM
To: [EMAIL PROTECTED]
Subject: transactions on MySQL (innoDB)
Hello
I can't create innoDB tables in db MySQL to do
>Description:
Given a table that has a timestamp field which is either the primary key or
one field in a multi-column primary key, the value in this field is
updated to the current time any time an SQL UPDATE is done, even
when the timestamp field is not intended t
Hi,
I'm running the following query:
Load data infile 'data.txt' into table records fields terminated by ';'
IGNORE 1 LINES
The field-order in my txt file is different than that in my table, can i
rearrange the order of the data being loaded and load blank fields in
between?
Any help will be gr
I have been using .49 for well over 1 month now. Not sure how it was
corrupted but it happened. I followed the instructions with some
variation and was able to recover everything. In my.cnf I added '
set-variable = innodb_force_recovery=4'. I was then able to start the
database, and did a mysqldum
be aware... linux/unix table names are case sensitive. if you're using Win32 MySQL
on your system, the query might work, but on the ISP side, if it's a *NIX system...
you must have the correct capitalization.
moreover, if any of your variables contain a single quote character ( ' ), it will
scre
i want to get really length of text field,but function
length() allways return 8,how can i get it with sql?
thanks.
__
Do You Yahoo!?
LAUNCH - Your Yahoo! Music Experience
http://launch.yahoo.com
--
Hi,
Could anybody tell me why the following query does not work?
SELECT location FROM visiExPr where location=1 union (SELECT location FROM visiExPr
where location=0);
Thanks!
Dan
-
Before posting, please check:
http://www
1 - 100 of 143 matches
Mail list logo
