nothing at all i'm afraid..
i think this requires a little shouting ...
PLEASE GET ME UNSUBSCRIBED OFF THIS LIST
thanks
anna
- Original Message -
From: "Brian McDonough" [EMAIL PROTECTED]
To: "anna soobrattee" [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Wednesday, March 21, 2001
Jean-Luc Fontaine wrote:
On Thursday 22 March 2001 16:46, Johan Vanroose wrote:
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Replication does not continue after removal/replace of network
cable.
Description:
Configuration.
Two servers (PCs) running mysql, both
I can't unsubscribe either -
I do not receive an auth code from this page
http://lists.mysql.com/php/unsubscribe.php
after I've entered my email address, so I cannot unsubscribe myself.
If someone can fix this page, then perhaps, people will stop sending
"unsubscribe me" emails to this
Jack Ince writes:
Why is the table of columns off by 1 ?
The registration seems to bypass the privileges column.
Thanks
~~~jci~~~
Sorry, but your question is hard to understand.
Regards,
Sinisa
__ _ _ ___ == MySQL AB
/*/\*\/\*\
Hello All of you ,
can you please tell me how to configure WEBLOGIC server with MYSQL database
. It is giving findByPrimaryKey error on my CMPs
Thanks in adcance
Neelesh
- Original Message -
From: "Michael Widenius" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: "Arne Claassen" [EMAIL
Hi peeps,
I've got a table which is basically a log of traffic on one of my websites
- I have a seperate table per month, all of which are MERGED for queries
which need access to more than a month's worth of data.
select count(distinct cookie) as c,dayofmonth(event_time) as d from
Greetings !
I am using Windows2K and have php in it. I want to install MySQL also in my
computer. How can I do this? I am using IIS.
Looking forward to hearing from you.
Warm Regards,
Deependra B. Tandukar
-
Before posting,
[EMAIL PROTECTED] writes:
Description:
The documentation says that I can do:
select * from table order by rand() limit 10
as an example, however it fails and there is no error message.
I *can* do:
select * from table order by rand()
which works fine. It just seems that adding the
In a message dated 26/03/2001 12:14:36 GMT Daylight Time,
[EMAIL PROTECTED] writes:
I can't unsubscribe either -
I do not receive an auth code from this page
http://lists.mysql.com/php/unsubscribe.php
after I've entered my email address, so I cannot unsubscribe myself.
If someone can
BAUMEISTER Alexandre writes:
Heikki,
If I run Mysql without having any client connected nor doing any
"mysqladmin xxx" command, the is no Warning messages. Only :
010326 11:43:29 mysqld started
Innobase: Started
/usr/local/mysql/libexec/mysqld: ready for connections
On Monday 26 March 2001 12:19, Johan Vanroose wrote:
Jean-Luc Fontaine wrote:
On Thursday 22 March 2001 16:46, Johan Vanroose wrote:
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Replication does not continue after removal/replace of network
cable.
Description:
Hi Peter,
On Mon, Mar 26, 2001 at 12:20:14PM +0100, Peter Skipworth wrote:
I've got a table which is basically a log of traffic on one of my websites
- I have a seperate table per month, all of which are MERGED for queries
which need access to more than a month's worth of data.
select
Hi,
I have to import Datas From FileMaker Pro to MySQL .
Unfortunately, the FileMaker web site is speaking about plugins to export databases,
but the access page gives error 500 (!).
Then, I try this mailling list, and there is my question :
is there any defined tool to import datas into
I tried before writing you and wasn't able to. Maybe someone else can figure
out how but it looks like default will only take a constant as a parameter.
Cal
http://www.calevans.com
-Original Message-
From: Michael Blood [mailto:[EMAIL PROTECTED]]
Sent: Sunday, March 25, 2001 11:48 PM
It doesn't currently. Currently, you can't use subselects.
Cal
http://www.calevans.com
-Original Message-
From: Michael Blood [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 26, 2001 5:12 AM
To: MYSQL
Subject: Another MSSQl to mysql question.
does any one know how mysql can handle an
Hi,
the database I would like to managed is constitued by one table.
This table is made of 3 columns, with no primary key
mysql CREATE TABLE test (
id1 int(8) unsigned,
id2 int(4) unsigned,
id3 int(4) unsigned
);
mysql CREATE INDEX
Hi,
For our benchmarks, we use for the MySQL Server a Sun Enterprise 3500 with 4
UltraSPARC processors, 6 Go of RAM, 3 disks of 40 Go...
MySQL runs under Solaris 7.
-Message d'origine-
De: Jeremy D . Zawodny [mailto:[EMAIL PROTECTED]]
Date: vendredi 23 mars 2001 19:11
: Pascal
Thanks, I tried the latter, but it didn't work. I'll try you're suggestion.
curtis
- Original Message -
From: "Quentin Bennett" [EMAIL PROTECTED]
To: "'Curtis Maurand'" [EMAIL PROTECTED]; "MySQL List"
[EMAIL PROTECTED]
Sent: Monday, March 19, 2001 11:44 PM
Subject: RE: [OT] SQL syntax
Is mySQL able to perform nested selects?
If so can anyone provide me with an example
If not can you provide an alternate solution
Thanks
Philip
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
Bonjour,
SM Seems like Innobase has introduced some timeout ( I do not see how) on
SM the sleeping connections.
I've been trying a few other things.
When I run Mysql with Innobase, if no client connects, no "Warning
signal 14" messages in the error log.
Then I run a client
Hi,
I have to import Datas From FileMaker Pro to MySQL .
Unfortunately, the FileMaker web site is speaking about plugins to export
databases, but the access page gives error 500 (!).
Plug-ins? You don't need any plug-ins to export data to MySQL. The only
plug-in for Filemaker I've ever
[EMAIL PROTECTED] wrote:
The biggest reason to avoid Microsoft products when I choose platforms
and tools for projects is missing freedom. I never know why but maybe I
really like MSSQL but I have some reason to drop NT - I can't do this.
MSSQL runs only on
NT. In own projects I always
Hi!
I found the bug: memory was written over in the function which
estimates the number of rows in ha_innobase.cc.
The bug is fixed in version 3.23.36, which may be out today.
You can also fix the bug by editing ha_innobase.cc, about line 2460.
The last argument in the two calls to
If you mean:
Select * from table where tableID in (Select tableID from table2);
Then no, MySQL does not support them. They mythical version 4.0 might. :)
Cal
http://www.calevans.com
-Original Message-
From: Philip Traynor [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 26, 2001 7:06
Sinisa,
Is there a published list of features for 4.0?
Cal
http://www.calevans.com
-Original Message-
From: Sinisa Milivojevic [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 26, 2001 8:06 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: nested selects
Is there any spesification for
Installing Mysql Server Clients Myodbc.
I mean if i try to install binaries in my own installation script
what else i need to do?
What registry keys required.
Which dll's need to be copy to Windows , Windows/System etc
Regards
Yusuf Incekara
Avukatpro Limited
Can anyone tell me what this means and how to fix it? I ran the below
query to simple add another index and this is what i got. Thank you.
mysql alter table message add index subject2 (subject(10));
ERROR 1034: 126 for record at pos 176850808
- Dan
At 7:59 -0800 26/3/01, Ashish Shah wrote:
What is the string that you would use to set "AST"
time zone file ?
Use GMT+4 for AST. This file has no daylight component and will hold
a static 4 hour difference as you want.
# zdump GMT
GMT Mon Mar 26 16:18:17 2001 GMT
# zdump GMT+4
GMT+4 Mon Mar
Hi All!
I'm new in the mailing list just want to know about the data transfer from
Approach97 to MySQL.
In my company we are running Approach97 for fullfil our database need but
now my boss want to make this database online.
I'v heard a lot about MySQL ( Speed / Stability etc. ) but want to
On Mon, 26 Mar 2001, Maros Klempa wrote:
Hi,
I have two servers with MySQL 3.23.24-beta. One as master and one as slave.
Replication between this two servers work fine. Now I want store pictures
to table. On master server I use command
INSERT INTO PICTURES (ID, PICT) VALUES (1, LOAD_FILE(
Hi!
Who knows any good ISP giving root access to Mysql?
Get free email and a permanent address at http://www.netaddress.com/?N=1
-
Before posting, please
Well, I wanted to limit the size of the index so it wouldn't take up a
lot of space. The message table is about 500mb right now and is going to
get a lot bigger. Well not limiting the size of the index get rid of the
error?
Original Message
On 3/26/01, 11:35:19 AM, "LIBASOV IOANNIS"
Just a follow up- I got replication working, the error was (as usual)
simple... in the MySQL Replication HOWTO, it says 'Add the following to
my.cnf on the slave(s): I of course (:P) put them at the end of the file,
they must go under [mysqld].
But hey, it works!
Thanks
-Original
On Mon, 26 Mar 2001, Daniel Adams wrote:
Well, I wanted to limit the size of the index so it wouldn't take up a
lot of space. The message table is about 500mb right now and is going to
get a lot bigger. Well not limiting the size of the index get rid of the
error?
Actually you should
Hi,
I downloaded the mysql-3.23.35a-win-src.zip.
I can't find in the documentation if:
- BDB is include or not
- How can I configure or install: the information seems for the unix env.
Please, can you help me?
James,
Gotta say that this is a bad reason to choose one product vs.
another... because it lacks a GUI to build queries? Undertanding SQL
is all well and good, but I can tell you that I would give anything to
have a query builder that works like the one for MS SQL server. You may
enjoy
On 26 Mar 2001, at 19:48, Daniel Mercury wrote:
Who knows any good ISP giving root access to Mysql?
Best I know of is iserver.com.
http://www.iserver.com/support/virtual/mysql/install.html
Peter
---
"Reality is that which, when you stop believing in it, doesn't go
Cal,
satire 1
I would love to see this list split into 2 lists. MySQL-Newbies and
MySQL-non-newbies. Non-newbies would be either an invitation-only list or
you have to pass a test to get in. (The test would contain questions that
are all in the manual, we don't care if you know, we care if
We are going to buy a cobalt req i4 server as a dedicated hosting
server. It has MySQL software and a control panel. Do you know if this
control panel can manage the MySQL or not (For creating and removing DBs
and tables not more)?
Prior versions of Cobalt's control panel don't--they also don't
I am wondering how most users generate reports from mysql that they can print
on a laser printer (e.g. invoices)? HTML is fine if the report is only 1 page
long. I guess some people user something like Crystal Reports via ODBC, but I
wonder what most people do???
I use StarOffice.
From this feature list, it sounds like you are creating methods
(multi-deletes, updates from joins) that will take the place of
transactions. Is this the direction that MySQL is heading? Do you believe
that these methods will be preferred over traditional rollback/commit
transactions with BDB
Wenn Sie am diesem List posten, bitten Sie nur English schreiben. Auch, ist dieses
List nur fur MySQL Fragen.
-Original Message-
From: Job-Mobil [mailto:[EMAIL PROTECTED]]
Sent: None
To: [EMAIL PROTECTED]
Subject: Feuere Deinen Boss !
Warum immer wieder für andere arbeiten,
wenn Sie
Hi,
In my case, some of tables are created according to people's name, e.g.
when user adds new name: firstname lastname
it should create table in background = firstname_lastname
But problem occurs when user name contains ', e.g. firstname's lastname, I
had it encoded first,
l.
-Original Message-
From: john lin [mailto:[EMAIL PROTECTED]]
Sent: Sunday, March 25, 2001 2:56 PM
To: [EMAIL PROTECTED]
Subject: inserting into mysql database in linux using C
I am a senior in Polytechnic University working on my
senior project. I have chosen MySQL to be
[EMAIL PROTECTED] writes:
I am wondering how most users generate reports from mysql that they
can print on a laser printer (e.g. invoices)? [...] I guess some people
user something like Crystal Reports via ODBC, but I wonder what most
people do???
Use Crystal Reports :-)? Depends on (a)
Jack, Mysql,
Well, my thought is that I can only compile zlib as a static library. I
can't compile it shared. I think this why the binary distribution of mysql
doesn't work is because it is looking for shared resources of
libz.a. I could go through the pain of compiling this, but the AIX
This list should be open to ALL questions, newbie and non-newbie. If we
start filtering, or slamming, then folks will be hesitant to ask questions.
We should encourage the learning process, not discourage. And where better
to learn than from this list?
just my 2 one-hundreths of a dollar
ive gotten along pretty well with mysql and online docs. but now i
am stumped and hoping for a little kick in the right direction.
i have a column in a table which is the primary key and is an int.
how do i make it also be auto_increment? the table already has some
data in it, so i suspect
The problem many of us have is not the questions. If I didn't want to
answer questions when I have free time, I wouldn't be subscribed to this
list. The problem most of us have is with the people who flat out refuse to
read the manual or try to find answers on their own. IMHO part of the
This is my first post to this list and I am a newbie at MySQL. If my
question is a FAQ, please direct me to the FAQ board. The book I have,
MySQL and mSQL by O'Reilly, says almost nothing about error codes...
I'm using MySQL with WinNT4.0. I've got it up and running, however I
can't drop tables
as luck might have it, i have solved my own problem. thanks for
the help people have already given me.
what i needed to do (it seems?) is use SET INSERT_ID *before* doing
the ALTER TABLE, like this:
mysql set insert_id=7;
Query OK, 0 rows affected (0.00 sec)
mysql alter table fixtures
try
alter table fixtures change id id int auto_increment
Notice that the two references to "id" are intentional!
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, March 26, 2001 2:44 PM
Subject: using ALTER TABLE to make existing column AUTO_INCREMENT ??
I have an index file that has an error in it and so I can't add a new
index and i can't seem to run myisamchk on it for some reason. In there
a way that i can have it recreate the index file thus getting rid of the
errors?
- Dan
Hi,
I entered netstat and saw among other conections
this one:
tcp4 0 0 deepthroat.3179 web.mysql.com.auth TIME_WAIT
Deepthroat is my bsd machine. it's a pure webserver.
Why is my machine making a connection to mysql.com?(and why auth)
On Sunday 25 March 2001 18:57, Voytek Lapinski wrote:
On Sunday 25 March 2001 16:27, you wrote:
Found the problem with your signal 11 with strange traces from inside
LinuxThreads. This was a hard concurrency bug - the problem was that a
memory reference passed to pthread_create was getting
Hello everyone,
I have a few questions that I hope some of you might be able to answer.
Is there a MAX_SIZE on a select statements and when does MySQL lose
performance when the statement becomes very large?
When using the 'IN' clause, how does MySQL parse the data? Does it do an
inline
Shankar Unni wrote:
[EMAIL PROTECTED] writes:
I am wondering how most users generate reports from mysql that they
can print on a laser printer (e.g. invoices)? [...] I guess some people
user something like Crystal Reports via ODBC, but I wonder what most
people do???
Use Crystal
I am brand new to MySQL, attempted to find help in documentation and
archives, but to no avail.
I have installed MySQL on a Windows NT platform and configured a root user
and another user that will act as a client with read/write permissions to
one, and only one, database.
A new database
In MySQL, you can create tables that have relationships but you can't create
what a lot of people call "Foreign Key relationships". In reality you CAN
create Foreign key (FK) relationships between tables, you just can't create
constraints that enforce them automatically.
Example time:
Let's say
On 26 Mar 2001, at 17:54, Curtis Maurand wrote:
I would give you root access to your database, but not to Mysql as a
whole unless you want a dedicated server. Too dangerous.
I have used iserver.com for about the last 4 years. I can start
mysql,create databases etc. I find the entire
I compiled all the required files and it seemed to work Ok.
I just have one question. How do I start the mySQL GUI?
Any help you can provide would be greatly appreciated.
Thank, Jason
-
Before posting, please check:
I am running version 3.23.33 of mysql on Windows ME. Everything was working
fine for a while and I recently started getting this error (from a php web
page) when doing a select on a table:
MySQL Error: 1030(Got error 127 from table handler)
I get this through both the web application and
Note that foreign keys in SQL are not used to join tables, but are used
mostly for checking referential integrity (foreign key constraints). If you
want to get results from multiple tables from a SELECT statement, you do
this by joining tables:
SELECT * from table1,table2 where table1.id =
Hi,
I'm using ADO with the MyODBC driver.
I have a table that I'm querying that has 'datetime' columns. If these
columns are null or 0 - "-00-00 00:00:00", I have problems reading from
the ADO recordset.
I have other columns - char, varchar, integer etc that are null and don't
have this
can anybody help?
I get this error
Parse error: parse error in mypath to file\Default.php on line 18
I am just learning right now so if you could help me with what I did wrong
her I'd apreciate it.
Thanx Petra
[EMAIL PROTECTED]
can anybody help?
I get this error
Parse error: parse error in mypath to file\Default.php on line 18
I am just learning right now so if you could help me with what I did wrong
her I'd apreciate it.
Thanx Petra
[EMAIL PROTECTED]
Note the difference:
mysql explain select * from syslogs_main where
host='openview.cc.umr.edu' and msg like '%IPACCESS%';
+--+--+---++-+---+---++
| table| type | possible_keys | key| key_len | ref | rows
| Extra
Quite simple, you can't. Please read the manuals more thoroughly. You
can't just read a general book on SQL by itself without reading the manual
for your particular flavour of SQL. Each type of database may have added
extra features or have removed some from the standard SQL.
- Original
Petra,
You have a close '}' with no open '{'. Maybe you should move the If
statement to the next line, then it won't be commented out.
len.
-Original Message-
From: Petra [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, 27 March 2001 13:21
To: [EMAIL PROTECTED]
Subject: parse error
Surely you jest.
Start it (MySQL) from DOS?
Which file name do I type into the DOS box command line to start it.
I have not yet installed any of the GUI's I heard about because until I
overcame the MyODBC problem I wasn't sure I would get it installed.
Can I assume one of the GUI's will start
Please include the original message so that others may know what the
original problem was.
Surely you jest.
No, I'm not. Please read the fine manual.
Start it (MySQL) from DOS?
There is still a lot of decent DOS software still floating about and some
are faster than their Windoze counter
Hello.
Sorry about the delay, but I was side-tracked by a server crash at the
end of last week.
The EXPLAIN for the 3.23 MySQL is at least as good as for 3.22, (in
fact, it is better). As one fact, 996*1*1264=1258944 rows are less
than 986*1*1470=1449420 rows, but at least in the same magnitude
Hello,
We have dual PIII Xeon 700MB memory box for mysql database running Solaris8
x86 + mu3.
After upgrading from 3.23.33 to 3.23.35 *average* speed downed ~ 50% -60%.
Output from "sar" command shows heavy stress of I/O system.
I use word "average", because we have more than 30 databases with
Hi,
could anyone of you please take a look at this message:
'MySQL said: Got error 127 from table handler'
This occurs when trying to access a specific table, like 'select * from
someTab', but it works when appending ' limit 0, X'.
Of what type is this error?
Any comments highly appreciated.
Hello.
On Sun, Mar 25, 2001 at 01:17:12AM -, [EMAIL PROTECTED] wrote:
-Original Message-
From: Benjamin Pflugmann [mailto:[EMAIL PROTECTED]]
[...]
Here's from the real one :
mysql show index from proc;
75 matches
Mail list logo