Hi.
On Sat, Feb 16, 2002 at 07:47:57AM +0100, [EMAIL PROTECTED] wrote:
> Hi mysql list members,
>
> Meanwhile I am pretty sure that this strange behaviour is a bug. But
> obviously I am blind. Where can mysql bugs be reportet?
http://www.mysql.com/doc/B/u/Bug_reports.html
> The strange behavio
-Mensaje original-
De: Eugenio Ricart [mailto:[EMAIL PROTECTED]]
Enviado el: viernes, 15 de febrero de 2002 7:00
Para: MyODBC Mailing List
Asunto: RE: MySQL + Access + MyODBC + LARGE Tables
Hello,
I work with VB 6.0 ADO 2.5 Access , I am trying work with MySql & and the
Last MyODBC .
Hi.
On Fri, Feb 15, 2002 at 09:05:02PM -0800, [EMAIL PROTECTED] wrote:
> In Re: Selecting records with the highest value no greater than x,
><[EMAIL PROTECTED]> wrote:
> >
> >Hi Brent,
> >
> >I cannot think of a single query doing your job.
IMO, there is one, if I did understand the question co
Hi mysql list members,
Meanwhile I am pretty sure that this strange behaviour is a bug. But
obviously I am blind. Where can mysql bugs be reportet?
The strange behaviour is (I asked about it yestereday):
We use the following statements to setup users and rigts for a mysql
server which is access
I'm stumped -- which isn't saying much because I'm hardly a scientist.
I am struggling to write a query that will tell me how many times a new
volunteer ( defined as a volunteer who has never worked a shift ) did
not show up for his shift (first shift). From my data I would
eventually like to
In Re: Selecting records with the highest value no greater than x,
<[EMAIL PROTECTED]> wrote:
>
>Hi Brent,
>
>I cannot think of a single query doing your job. But it can be done
>with two.
>
>SELECT @maxrating := MAX(RATING) FROM NEWS WHERE RATING <= 4;
>SELECT * FROM NEWS WHERE RATING=@maxrating
At 13:39 15/02/2002 +0100, Roger Baklund wrote:
Hi Roger,
If I am not wrong after the release 3.23.40 was removed from
config-win.h the line below:
#define FN_LOWER_CASE TRUE /* Files are represented in lower case */
The above meant that MySQL independently of the OS, always wrote the
tables w
On Sat, Feb 16, 2002 at 03:21:16AM -, Bjorn Swift wrote:
> Hi all.
>
> The load on my mysqld server is getting higher by the day and I am
> trying to get a better picture of what's going on. I recompiled with
> the debug option and have started a trace log.
>
> Is there any tool available th
I'm having a problem with a MySQL query - when I run it, I get "ERROR 2013:
Lost connection to MySQL server during query"
Here is the query:
SELECT forum_id_fk, COUNT(*) FROM gforum_Post WHERE (
( forum_id_fk = 21 AND post_time > 1008613409 ) OR
( forum_id_fk = 22 AND post_time > 10125
Hi all.
The load on my mysqld server is getting higher by the day and I am trying to
get a better picture of what's going on. I recompiled with the debug option
and have started a trace log.
Is there any tool available that can analyze the trace log and give me an
easy to read output? Or is ther
Hi Brent,
I cannot think of a single query doing your job. But it can be done
with two.
SELECT @maxrating := MAX(RATING) FROM NEWS WHERE RATING <= 4;
SELECT * FROM NEWS WHERE RATING=@maxrating ORDER BY RAND() LIMIT 1;
Anvar.
At 02:36 PM 15/02/2002 -0700, you wrote:
I need some help here. Let'
Hi.
Try to use replace if you have unique key index and both table have the
same structure:
and query like,
replace into tableA
select * from tableB
Kittiphum Worachat,MT.
www.hatyailab.com
-
Before posting, please check:
In Callbacks or External Procedures?, <[EMAIL PROTECTED]> wrote:
>
>Is there _any_ way to do something like Oracle's OCI callback functions?
>
>What I need to do:
>Whenever my MySQL database changes data (inserts, updates, whatever) I need
>to call some of my own code.
>
>Any ideas?
You don't spe
Hi John,
On Sat, 2002-02-16 at 06:52, John D Siirola wrote:
> I am having trouble with Mysqld unexpectedly crashing.
> >How-To-Repeat:
> Unfortunately, I do not know how to consistently cause the
> crash to repeat.
Yeah, that's always a bit tricky; and can make it very hard for the
or you can try...
/usr/local/mysql# ./mysql start
Christopher Thompson wrote:
>Prefix it with the path:
>
>/usr/local/mysql/mysqld start
>or whatever.
>
>On Friday 15 February 2002 3:16 pm, Mark M Jervis Jr. wrote:
>> Hi,
>>I am trying to install run MySQL version 3.23.43-pc-linux-gnu-i686
Wouldn't replace change all the entries in your table row, same effect as update?
I believe the question is how to test which entry in a form has a new value and
replace/update only that value in the table.
If I have a form...
__
|Employee Record Update|
|
Hi Andreas,
On Sat, 2002-02-16 at 08:52, Andreas Frøsting wrote:
> Why does MySQL have this strange behavoir, treating unique indexes
> case-insensitive?
> Can anyone explain MySQL's behaviour and how I do a workaround making
> unique indexes and primary keys case sensitive?
> I've been over the
Hi,
No problem so far with mysql 4.0.x, no crash at all on a production server
with a really high load.
If you want to use mysql 4.0.2, take a look here :
http://www.mysql.com/doc/I/n/Installing_source_tree.html
Best Regards,
Jocelyn Fournier
Presence-PC
- Original Message -
From: "Je
So it's better using 4.0.1 of 4.0.2?
Jean-Francois Dionne
- Original Message -
From: "Jeremy Zawodny" <[EMAIL PROTECTED]>
To: "Jean-Francois Dionne" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, February 15, 2002 8:12 PM
Subject: Re: information on mysql 4.0.2
> On Fri, Feb
On Fri, Feb 15, 2002 at 08:03:19PM -0500, Jean-Francois Dionne wrote:
> I see people speaking about mysql 4.0.2... but where you get it?
> they write some thing about it on web page but 4.0.2 is not in the
> download list...
It's from the MySQL source tree. See this url:
http://www.mysql.com
I see people speaking about mysql 4.0.2... but where you get it? they write
some thing about it on web page but 4.0.2 is not in the download list...
maybe someone can say if mysql 4 is stable? I mean if I can use it without
100 crash in 1 hour :)
Sorry for bad english :)
Jean-Francois Dionne
---
On Tuesday 12 February 2002 09:23 pm, you wrote:
> Sasha,
>
> I compressed it first, 'cause it was nearly 400MB in size. It's on
> the FTP site as mysqld.core.bz2.
Jeremy - in case you are wondering why it is taking me so long to reply -
we've made a mess on our Linux build machine before the
George/Rick, a quick addition.
It is not clear from the question: do you want to have the timestamp updated, or do
you want to leave it be?
RTFM:
6.2.2.2 The DATETIME, DATE, and TIMESTAMP Types
...
The TIMESTAMP column type provides a type that you can use to automatically mark
INSERT or UPDAT
Hi List,
I am new to the MySql C++ API and I am compiling one file it gives me error
saying
Error E2303 ..\..\include\sqlplus\resiter1.hh 56: Type name expected
Error E2275 ..\..\include\sqlplus\resiter1.hh 56: { expected
Error E2275 ..\..\include\sqlplus\resiter1.hh 56: { expected
and many war
SEND-PR: -*- send-pr -*-
SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as
SEND-PR: will all comments (text enclosed in `<' and `>').
SEND-PR:
From: pengzhao
To: [EMAIL PROTECTED]
Subject: Msql-Mysql-modules-1.2219 fails in the test, on Itanium machine
>Description:
Hi there,
I'm having som difficulties trying to figure out MySQL's unique indexes
and primary keys.
Case:
mysql> create table flaf (lala varchar(20) not null, unique(lala));
Query OK, 0 rows affected (0.00 sec)
mysql> insert into flaf VALUES ('hest');
Query OK, 1 row affected (0.00 sec)
my
* Miretsky, Anya
> Select distinct
> biblio.* from biblio left join keyword on
> biblio.p_biblio=keyword.fk_biblio
> where keyword="SOMESTRING";
Try swapping the tables:
Select distinct
biblio.* from keyword left join biblio on
biblio.p_biblio=keyword.fk_biblio
where keyword="SOMESTRING";
The l
Prefix it with the path:
/usr/local/mysql/mysqld start
or whatever.
On Friday 15 February 2002 3:16 pm, Mark M Jervis Jr. wrote:
> Hi,
>I am trying to install run MySQL version 3.23.43-pc-linux-gnu-i686. When
> I try to run it to finish installation and set up users, i get the
> following er
Hi,
I am trying to install run MySQL version 3.23.43-pc-linux-gnu-i686. When
I try to run it to finish installation and set up users, i get the
following error:
/usr/local/mysql# mysql start
su: mysql: command not found
I have also tried running MySQL with the mysqld start, mysqld, and mysql
c
At 13:35 15/02/2002 -0500, Juwon Aikulola wrote:
Hi!
>Hi Gurus,
>I downloaded and installed MySql successfully, on a Windows 2000 O/S. I
>want to locate the "my-example.cnf" file, copy it to my root directory and
>rename it "my.cnf". However, the "my-example.cnf" file I locate is a
>shortcut, p
How about
SELECT * FROM news WHERE rating <= 4
ORDER BY rating DESC, RAND() LIMIT 1;
Michael
On Fri, 15 Feb 2002, Brent Macnaughton wrote:
>
> I need some help here. Let's see if I can clearly describe it.
>
> I have a database containing "news" stories. Each story is assigned a
> "r
Description:
The errors and crashes herein are related to the use of a software
package called Phorums... version 3.2.11... The query that was crashed
on here, is made against the phorums3211 database.
Log errors as follows:
--
020209 13:52:17 Aborted co
I need some help here. Let's see if I can clearly describe it.
I have a database containing "news" stories. Each story is assigned a
"rating" (1 thru 5) indicating its importance. (A story with a rating of 5
is more important than a story with rating of 1.)
Now, lets say that there are ten s
I have a written a Windows client that accesses a MySQL server (Linux)
via the MySQL C API. Stored in the MySQL database are large files
(larger than a Mbyte). The C API makes it very easy for the client to
query and alter the database. However, I have some special needs that
don't appear to be
Hello,
I am having trouble with Mysqld unexpectedly crashing.
I am running mysqld in a situation where there is a nearly constant
load on 6 databases, each with about 20 open connections (mostly
inserts and selects, occasionally a delete). Once every 3-4 days, at
seemingly random points (i.e. i
possibly
-Original Message-
From: Miretsky, Anya [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 15, 2002 2:32 PM
To: 'Rick Emery'
Subject: RE: Left Join problem - Please Help
When I do this without specifying a left join with just :select biblio.*
from biblio,keyword where p_biblio=f
I don't think it's hanging. I think it's going through the process of
determining joint criteria for 11,900 table entries multiplied by 88,000
other table entries, then doing a text search on the result, which is much
slower than an integer search.
I'm posting this back to the mysql list to see
Bonjour Jean-françois,
Le DESC qui utilise l'INDEX est un fonction de MySQL 4.0. Il y a
un bug en la version 4.0.1 (Quelque fois il n'utilise pas l'index
descendre ) mais pour la plus part ça marche bien. En autre il y a un
forum de MySQL en français à:
Liens utils :
Poster un message: [EMA
ADO supports ODBC drivers and all ODBC functionality as well as the newer
ADO/OLEDB interfaces. You should be fine with the ODBC.
Michele Harlass
DBA
AbcEd.com, Inc
-Original Message-
From: Guy Davis [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 13, 2002 1:29 PM
To: [EMAIL PROTE
Hi Darrin,
This is very starnge as I just installed two FreeBSD 4.5 machines
this week and had no problems! I installed on SMP based machines,
with very few changes from the GENERIC kernel. Is this a fresh
install of FreeBSD 4.5? If not can you run a 'make world' and 'make
kernel' again? Did
Only the first TIMESTAMP field gets updated when an updat to a record is
made, so if you want to maintain the time a record was created, and when it
was updated, use two timestamp fields, the first field will be the time
updated, but to do this you must initialize the second timestamp field wit
timestamp is automatically updated
-Original Message-
From: George Labuschagne [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 15, 2002 1:20 PM
To: [EMAIL PROTECTED]
Subject: When does the timestamp field gets updated?
Hi all,
If one uses the timestamp data type for a column inside a
Hi all,
If one uses the timestamp data type for a column inside a table, when
executing an update query on said table on a spesific record, will the
timestamp column be updated as well or will it retain its first value?
Thanks for any info in advance,
George
mysql, query, sql
-
Show us your table structure, some table values and the SELECT statement
that works and the one that doesn't
-Original Message-
From: Miretsky, Anya [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 15, 2002 12:13 PM
To: '[EMAIL PROTECTED]'
Subject: Left Join problem - Please Help
Whene
does your test app connect with root as the user?
-Original Message-
From: Lonnie Cumberland [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 15, 2002 12:12 PM
To: [EMAIL PROTECTED]
Subject: connections to MySQL
Hello All,
I am new to this list and hope that someone could answer this
Whenever I try to issue a query which has a left join for two tables and a
where clause for a column in the second table that is a varchar the query
runs indefinitely. If I change the where clause to search on a numeric type
column the query runs and returns expected values.
Does anyone know what
- Original Message -
From: "Andrew Crum" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, February 15, 2002 12:15 AM
Subject: License Question
> Can I statically link to libmysqlclient? If so, what are the implications?
> Will I have to distribute my application's source? IANAL
Hi Gurus,
I downloaded and installed MySql successfully, on a Windows 2000 O/S. I want
to locate the "my-example.cnf" file, copy it to my root directory and rename
it "my.cnf". However, the "my-example.cnf" file I locate is a shortcut,
pointing to no physical target. As a result, after going th
Hello All,
I am new to this list and hope that someone could answer this
question for me.
I am running on a fresh install of Redhat 7.2 and am trying to
connect to MySQL from a program that I have to test the connections,
but am getting error messages saying that the host in not allowed to
conne
Hello,
I have a problem with mysqld (3.32.46 under Red Hat Linux 7.2,
pIII-800 512K RAM).
It starts and works fine until some time is passed, then it starts
eating my memory and CPU.
I have the following config in my.cnf:
[mysqld]
set-variable = max_connections=200
set-variable = key_buffer=16M
s
Hello all,
I searched the archives and found no similar problems, so here goes...
Using an almost straight out of the manual example, I am unable to
do a fulltext search using "IN BOOLEAN MODE"
using the following SQL statement:
SELECT * FROM parts
WHERE MATCH (description)
AGAINST ("+brake +p
Dear Sir/Madam
I'm fifth year student from Poland. I'm studying at Academy of Minnig and Metalurgy in
Cracow (major Electrical Engineering). At the present I'm writing my master thesis. I
consider how processors with embedded interface TCP/IP can be used in distributed
system data collecting.
Spoiler: Venu's Suggestion about "Dynamic Cursor" is the answer
On Thu, 2002-02-14 at 20:34, Venu wrote:
> > MyODBC, as compiled today, uses mysql_store_result to get records. This
> > is fine for reasonably sized tables. However, if the table has millions
> > of records, writing the resul
Hi,
we're using myodbc2.50.36 with W2k and W98 to connect to our mysql-server
(Linux Kernel 2.2.18 - MySQL Version 3.23.38) in the internet. When we send
or receive larger amounts of data (we're using Visual Foxpro 7.0 as
frontend) we get the "aborted connections"-Message in the mysql errorlog
ve
Hi,
Could you tell me about your TABLE-definition and
version number of your JDBC Driver?
I will check that problem.
"Stancescu, Catalina" wrote:
>
> I have a servlet in which I connect through a mysql driver to the
> database. The servlet has a string that represents the date in the
> f
On Fri, Feb 15, 2002 at 12:16:01PM +0200, Egor Egorov wrote:
> System,
>
> Friday, February 15, 2002, 5:38:51 AM, you wrote:
>
> >> jr> i made the mistake of changing my root password manually in the mysql
> >> jr> database. after doing so, i 'flushed privileges'.
> >>
> >> jr> now i'm unable t
How would you do:
set field='Jim said, "that's crazy."'
you would have to escape the quote somehow. The '\' is the escaper
character.
set field='Jim said, "that\'s crazy."'
That means hat the escape character must also be escaped.
Check the manual for the section on special characters.
Most
Hei
I think we have found a bug in mysql replication.
We have some programs that are working against a master DB and that use
temporary tables. The hole system works without problems until we run a
flush master/slave. Then the replication in the slave DB stops working
because of this.
How t
>Description:
>How-To-Repeat:
>Fix:
>Submitter-Id:
>Originator:root
>Organization:
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis:
>Severity:
>Priority:
>Category: mysql
>Class:
>Release:
Hello everyone
I've read about replication mechanism in MySQL, but I've still got some
reservations regarding transactions.
In the manual thay say that in case of a transaction, all update
instructions are hold in a cache, and on commit they are written to the
binary transaction log. After the u
Bryan,
I apologise, did I mistakenly call you Brent earlier!?
> Indeed. I have a relatively large (few dozen) number
> of tables that are accessed via PHP and a web
> interface. The script pulls information from these
> tables to generate pull-down menus. It would be nice
> if these pull-down men
http://www.google.com/search?q=regex+man+page
> -Original Message-
> From: Joe Polanik [mailto:[EMAIL PROTECTED]]
> Sent: Friday, 15 February 2002 3 12
> To: [EMAIL PROTECTED]
> Subject: Regex man page
>
> According to the online manual the regex man page contributed by Henry
> Spencer i
Hi everybody,
This seems to be a definite defect in MySql. While inserting a String into
a MySql attribute defined as VARCHAR or VARCHAR BINARY, etc., if a '\' is
present in the String, it is simply disregarded, and the remaining part of the
String gets inserted. For inserting a '\', we hav
Joe,
you can find it here:
http://arglist.com/regex/
Peter
On Fri, 15 Feb 2002, Joe Polanik wrote:
> According to the online manual the regex man page contributed by Henry
> Spencer is included in the source distribution of MySQL. I'm hesitant to
> download
> and install a source distributio
Hello,
I'm encountering a serious program fault at using MySQL Win32 client library
LIBMYSQL.DLL.
I found LIBMYSQL.DLL not thread-safe. When 10 threads are launched to run
the following two blocks of C statements, very quickly a program fault
window pops up to LIBMYSQL.DLL.
block #1 --
According to the online manual the regex man page contributed by Henry
Spencer is included in the source distribution of MySQL. I'm hesitant to
download
and install a source distribution just to get a man page. Is it found
anywhere else?
thanks,
Joseph Polanik
---
Michael Hoennig <[EMAIL PROTECTED]> wrote:
>> > But we can NOT connect locally by host:port:
>>
>> >local-system> mysql -h 66.70.34.150 -O 3307 -u xyz00 -p
>> >=> ERROR 1045: Access denied for user: 'xyz00@localhost' (Using
>> > password: YES)
>>
>> > On a mysqld which is accessible onl
Hello,
Well, for my project at work, I've done some small benchmarking
of different table types for relatively small sizes (some tens
or hundreds of thousands rows - small enough so that key buffer size
and other memory factors should not limit performance) and lots of
very simple operations. I
I think there are a couple of bugs here:
First, per the documentation, 6.1.3 Case Sensitivity in Names
(http://www.mysql.com/doc/N/a/Name_case_sensitivity.html), the Windows
mysqld is starting with -O lower_case_table_names=1 by default, so all
filenames should be converted to lowercase automatic
Hi Ireneusz,
> Hi
> I see:
> local-system> mysql -h 66.70.34.150 -O 3307 -u xyz00 -p
> hmm.
> I always use:
> >mysql -u xyz -p -h ... -P 3306
>
> Is the -O option in the right place. Maybe it sould be -P like PORT.
> Isn't??
sorry, typo in my mail. -P of course.
Alles Gute wü
* IvanLatysh
> >> I've got query like this:
>
> >> "select count(ID) from TABLE where (TABLE.A + TABLE.B + TABLE.C +
> >> TABLE.D) > 0"
>
> >> A,B,C,D are decimal values.
>
> >> The problem is, I think, with NULL columns. Often B,C and D don't
> >> have decimal value, but NULL.
> >> I thoug
Hi
I see:
local-system> mysql -h 66.70.34.150 -O 3307 -u xyz00 -p
hmm.
I always use:
>mysql -u xyz -p -h ... -P 3306
Is the -O option in the right place. Maybe it sould be -P like PORT. Isn't
??
Regards.
I. Piasecki - webmaster www.b-c.pl
- Original Message -
From: "
The RENAME syntax is correct, please see the following documentation:
http://www.mysql.com/doc/R/E/RENAME_TABLE.html
-Original Message-
From: SubbaReddy M [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 15, 2002 5:23 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: Suspected
>Description:
When trying to install MySQLi 3.23.47 and 3.23.48 on FreeBSD 4.5, We get the
following errors
during the mysql_install_db.
/usr/local/bin/mysql_install_db
Preparing db table
Preparing host table
Preparing user table
Preparing func table
Preparing tables_priv table
Hi Dimitry,
> > But we can NOT connect locally by host:port:
>
> > local-system> mysql -h 66.70.34.150 -O 3307 -u xyz00 -p
> > => ERROR 1045: Access denied for user: 'xyz00@localhost' (Using
> > password: YES)
>
> > On a mysqld which is accessible only locally the both INSERT
> > statem
Michael Hoennig <[EMAIL PROTECTED]> wrote:
> Hi mysql list members,
> We use the following statements to setup users and rigts for a mysql
> server which is accessible locally and via internet:
> INSERT INTO mysql.user VALUES
> ('%','xyz00',PASSWORD('...'),
> 'N','N','N','N','N','N','N','N','N
>> I've got query like this:
>> "select count(ID) from TABLE where (TABLE.A + TABLE.B + TABLE.C +
>> TABLE.D) > 0"
>> A,B,C,D are decimal values.
>> The problem is, I think, with NULL columns. Often B,C and D don't
>> have decimal value, but NULL.
>> I thought, that this should be counte
Friday, February 15, 2002, 2:23:52 AM, Lars Heidieker wrote:
> Just copy the backup files into the database dir and the database should be
> back.
Are you sure that it's not need to CREATE it first ?
> At 08:22 AM 2/15/2002 -0500, Paul wrote:
>>Hello mysql,
>>
>> I dropped an entire database
Hi mysql list members,
We use the following statements to setup users and rigts for a mysql
server which is accessible locally and via internet:
INSERT INTO mysql.user VALUES
('%','xyz00',PASSWORD('...'),
'N','N','N','N','N','N','N','N','N','N','N','N','N','N');
INSERT INTO mysql.db VALUES
('
Just copy the backup files into the database dir and the database should be
back.
Lars
At 08:22 AM 2/15/2002 -0500, Paul wrote:
>Hello mysql,
>
> I dropped an entire database but I have the frm, myd and myi files
> in a backup.
>
> What are the complete steps to restoring this database?
>
* Przemyslaw Popielarski
> I've got query like this:
>
> "select count(ID) from TABLE where (TABLE.A + TABLE.B + TABLE.C +
> TABLE.D) > 0"
>
> A,B,C,D are decimal values.
>
> There are over 1 records where A is greater than 0,
> about 1000 where B is greater than 0,
> about 500 where C is
Hi,
I've got query like this:
"select count(ID) from TABLE where (TABLE.A + TABLE.B + TABLE.C + TABLE.D) >
0"
A,B,C,D are decimal values.
There are over 1 records where A is greater than 0,
about 1000 where B is greater than 0,
about 500 where C is greater than 0,
and about 300 where D is
Hello mysql,
I dropped an entire database but I have the frm, myd and myi files
in a backup.
What are the complete steps to restoring this database?
Thank you for the help.
--
Best regards,
Paul mailto:[EMAIL PROTECTED]
-
Hi Brumpton,
>From the webserver, try to connect to port 3306 with telnet
Example:
telnet 10.0.0.2 3306
You should see someting like: 3.23.47♥hAJ3\Y+e☻
This means that the right ports are open on the firewall to connect to
Mysql.
>-Original Message-
>From: Victoria Reznichenko [mail
* Joao Verde
> The problem is I cannot search for one specific word because, even
> though the word exists on several records, MySQL never returns any
> rows.
>
> The word I can't look for is "portaria". Any other word works just
> fine. I have tried every word I could think of and it works... exc
Roger,
Friday, February 15, 2002, 1:32:13 PM, you wrote:
RB> * Egor Egorov
>> FL = Fred Lovine
>> FL> CREATE TABLE X1 (x smallint);
>> FL> insert into X1 values(5);
>> FL> RENAME TABLE X1 TO X2;
>>
>> FL> is producing the following error:
>>
>> FL> 7 - Error on rename '.\\X1.MY1' to '.\\X2.MY
Hi,
this has to be a bug. It seems on windows "RENAME TABLE TO " only
works for uppercase table names _after_ an "ALTER TABLE RENAME AS
" _or_ if you first rename the table using lower case letters:
mysql> create table U1 (id int);
Query OK, 0 rows affected (0.04 sec)
mysql> insert into U1 va
Kedryna, Bartosz writes:
> In mysqldump.c there is // in 2 places, older compilers don't like it,
> changing to /* */ fixes the problem.
>
> Bart Kedryna
> Software Engineer
> Online Support
> [EMAIL PROTECTED]
> (215) 386 0100 x1470
> ISI
> 3501 Market Street
> Philadelphia, PA 19104
>
Thank y
Egor,
Yours/this arrived in my InBox whilst I was addressing the original msg - please see
my other reply/ies.
Error still occurs when running as Administrator on WinNT and root under MySQL
- definitely no access/permission issues.
Lower case works (please see earlier reply).
If I/my NT PC can
SubbaReddy M
> I am afraid it's not a bug, rather a syntax error.
> please follow the syntax to rename the table:
>
> mysql> alter table X1 rename as X2;
Why do you say this?
Manual entry:
6.5.5 RENAME TABLE Syntax
RENAME TABLE tbl_name TO new_table_name[, tbl_name2 TO new_table_name2,...]
.
Once tables are CREATEd, the name is listed in SHOW tables using lower case
characters, regardless of the case
used in the CREATE command.
Using upper case table names in RENAME results in the error.
Workaround: Using lower case equivalent table names works, regardless of the case used
in the C
Brent,
> >What Rick said is absolutely correct and you probably are obsessing about
> >something that doesn't matter. But I would venture you are using an
> >auto-number field as the primary key when you could easily change it to a
> >function something similar to: set ID = MAX(ID) + 1.
>
> Kei
* Egor Egorov
> FL = Fred Lovine
> FL> CREATE TABLE X1 (x smallint);
> FL> insert into X1 values(5);
> FL> RENAME TABLE X1 TO X2;
>
> FL> is producing the following error:
>
> FL> 7 - Error on rename '.\\X1.MY1' to '.\\X2.MYI' (Errcode: 13)
>
> FL> The problem seems to be caused by using upper
Okay is not a reply for myself :) is only for add a question... :)
I read that mysql 4 will fix this, but mysql 4 is stable? I mean i'm on
production, i'm not selling mysql :) I mean I have a big projet in test
using mysql.. so if it crash it will be very bad for me... someone had test
mysql 4? s
Someone in the list posted the following links. I went with the second one
and it worked.
NOBBY
> http://www.convert-in.com/acc2sqlp.htm
> http://ultradev.buzzinet.co.uk/mysql/tutorials/converting_data/index.asp
> http://www.winmysql.com/
>
- Original Message -
From: Fabio Amura <[EMAI
Hi!
On a site I'm developing I need to conduct boolean searches. I use a
piece of code I found on:
http://www.evolt.org/article/comment/18/15665/http://www.evolt.org/art
icle/comment/18/15665/
and I've got to say it works really well.
The problem is I cannot search for one specific word becaus
Hi
Currently, I maintain two mysql server, hosted by separate ISPs, and
keep them synchronised using standard MySQL replication.
Server A is master+slave to server B, and likewise server B is master
+slave to server A.
This allows both servers to receive inserts/updates/deletes and
replicate
I am afraid it's not a bug, rather a syntax error.
please follow the syntax to rename the table:
mysql> alter table X1 rename as X2;
Regards,
~ SubbaReddy .M
- Original Message -
From: "SubbaReddy M" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Friday, Februar
Yeah, for me also find error.
--
mysql> create table X1(name varchar(10));
Query OK, 0 rows affected (0.00 sec)
mysql> insert into X1 values(5);
Query OK, 1 row affected (0.01 sec)
mysql> RENAME
System,
Friday, February 15, 2002, 5:38:51 AM, you wrote:
>> jr> i made the mistake of changing my root password manually in the mysql
>> jr> database. after doing so, i 'flushed privileges'.
>>
>> jr> now i'm unable to log on using the root. i've tried to log on using the new
>> jr> password a
1 - 100 of 115 matches
Mail list logo
