Hi.
AFAIK, there was a speed problem with 3.23.35 reported regarding
UPDATE. You probably want to downgrade to 3.23.33 until 3.23.36 is out
(should happen in the next days) and then see if the problem is gone,
else re-report.
Bye,
On Tue, Mar 27, 2001 at 11:41:13AM +0400, [EMAIL PROTECTED] wrot
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;
> +---++-+--+-+
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,
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
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
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
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
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
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 M
On 3/26/01 2:54 PM, "Curtis Maurand" <[EMAIL PROTECTED]> 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.
>
> Curits
>
>
> On 26 Mar 2001, Daniel Mercury wrote:
>
>> Hi!
>>
>> Who knows any good ISP g
Hi!
I store image files in a MySql table, and can upload, store and retrieve
these binary files without problems. I also store some audio files (they
happen to be in .wav format). I'm having difficulty dragging these audio
files out in a way that IE and Netscape can recognize.
This doesn't
This is probably a really stupid error, but I'm unable to run myisamchk:
[root@cssrvr1 mail2db.bad]# ls
category.MYD groupcounter.MYD list.MYD message.MYD threadrequest.MYD
category.MYI groupcounter.MYI list.MYI message.MYI threadrequest.MYI
category.frm groupcounter.frm list.frm mess
O.K. I use MySQL version 3.23 (RedHat 7.0 release) and have a question about
this query:
1.) [...] LIKE '%pattern'
2.) [...] LIKE 'pattern%'
The first query does not use an index while the second does. Is there any
explenation for this?
Thanks.
--
Bolek,
URL: http://www.bolek.com
URL: h
Has anyone found the lastest mySQL for SUN SOLARIS 7 Intel version? I know there's a
SPARC binary for 3.23 but what about an Intel binary?
Technology Consultant
310-426-5619 (h) / 888-431-7571 (p)
http://www.access1.net/esteban1
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
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]
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 pro
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 = table2
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 throug
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:
http://
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
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
Keneth wrote:
>
> "When I try to dump sql database it gives me some errors 1.Error 1045
> mysqldump --opt database > backup-accp.sql mysqldump: Got error: 1045:
> Access denied for user: 'accp@localhost' (Using pass word: NO) "
>
> can you help?
>
try:
mysqldump --opt database -u -p > backup
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 (export
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???
>
> U
hi there o wise ones
i know i should RTFM, but i am, its right here infront of me. maybe its
cause i cant start working with sql till i get home from slavin for the
man or whatever, but id really like to get it operational. if its
possible to get some help id really appreciate it.
thanks
qu
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 sear
Hi...please help
Cannot get the version of MySQL compiled..When running a configure it stops at :
'checking return type of sprintf... configure: error: cannot run test program while
cross compiling
checking whether gcc accepts -g... (cached) yes
checking for c++... (cached) c++
checking w
-Original Message-
From: GERARDO GALLARDO [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 26, 2001 3:57 PM
To: [EMAIL PROTECTED]
Subject: STUPID QUESTION
I'm new to MySQL and SQL in general. I have been searching and searching
but I can't find an answer to a question which I know is si
I'm new to MySQL and SQL in general. I have been searching and searching but I can't
find an answer to a question which I know is simple. I have read a book called Teach
Yourself MySQL in 21 days. It talkes about defining relationships between tables but
it never actually shows you how you w
Well, subject says it pretty much all - I'm trying to build mysqlgui
1.7.4 on NetBSD 1.5/i386, and get linker warnings:
single.o: In function `EditorEngine::LoadSQL(char const *)':
/usr/cvs/pkgsrc/databases/mysqlgui.work/work.i386/mysqlgui-1.7.4/FL/wstrings.h:23:
undefined
reference to `wStrin
Hello
I hv downloaded the Berkeley DB patch. Still I need the detail
instructions to use table type= bdb in MySQL database.
I am unable to change the variables like have_bdb,default-table-type=bdb
and so on...
Basically i need to find out whether MySQL supports rollback & commit
transactions ef
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 g
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)
Mys
On Monday 26 March 2001 08:16, Johan Vanroose wrote:
> Jean-Luc Fontaine wrote:
>
> > 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 PROTECT
> Cal Evans writes:
> > Sinisa,
> >
> > Is there a published list of features for 4.0?
> >
> > Cal
> > http://www.calevans.com
> >
>
>
> It is not complete yet.
>
> But, new .frm files, multi deletes and updates from joins, UNION's and
> many others.
And are there any dates, even tentativ
I am looking for MySQL users to beta test the following free database
hosting service:
http://superid.dyndns.org:8080/freesql/index.php
I've done a fair amount of testing myself, but I need a few more people to
work the rest of the bugs out. I'd be grateful if people would do the
following
Hi all,
Here's my environment:
Solaris 8
Mysql 3.23.33
Driver mm.mysql-2.0.2-bin.jar
I installed Mysql use root. In my servlet program I did not use input
parameter for user/password.
I run my servlet program, I got the following message
java.sql.SQLException: General error: Access denied fo
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
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
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
I'm not sure you can auto_increment a field after the fact. In any case, it
looks like your problem is that you have duplicate data in the field you are
trying to auto_increment. Spin through the table and make sure that all
rows are unique on that field. THEN try to auto_increment it. (Which st
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 a
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
learni
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 that
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?
-Original Message-
From: Oson, C
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
free
[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
You need to have quotes around test in the insert statement. So it would
be as follows:
sprintf (query, "INSERT INTO tablename (userid) VALUES(\"%s\")", test");
res=mysql_query(connection, query);
Oviously query needs declaration here, but the SQL has to be quoted
exactly the same as if you were
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 MyS
Maybe you just gave a snippet, but I don't see where you established the
connection to the database, thereby giving the variable "connection" a
value. It appears to be undefined. Therefore, the mysql_query() would
fail.
-Original Message-
From: john lin [mailto:[EMAIL PROTECTED]]
Sent:
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, java.net.URLEnco
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 DM
>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 o
On Mon, Mar 26, 2001 at 09:02:59AM -0800, Bryan Coon wrote:
>
> 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 g
Okay, I ran "myisamchk -c message.MYI" and got back:
myisamchk: error: 22 when opening MyISAM-table 'message.MYI'
perror says error 22 is "Error code 22: Invalid argument"
Is there a way I can regenerate the index file? I can still open mysql
and do queries on the table so it does not appear
> 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.
>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 do
Cal,
>>
>> 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
> "LL" == Linsen Limsico <[EMAIL PROTECTED]> writes:
LL> Does anyone know how to get the .htaccess file to check the
LL> database if the password exists, then the .htpasswd if the
LL> password doesn't exist in the database?
If you use my version, then yes, you can. Just specify
AuthMySQLAut
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
a
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
>>
mysql> show databases;
+---+
| Database |
+---+
| directory |
| mysql |
| phpBB |
| testdb |
| trial |
+---+
5 rows in set (0.00 sec)
mysql> use testdb;
ERROR 1049: Unknown database 'testdb'
Keeps happening to me too.
It was working the day before :
Reffer documentation about mysql version and table type where you can do
that.
- Original Message -
From: "Daniel Adams" <[EMAIL PROTECTED]>
To: "LIBASOV IOANNIS" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, March 26, 2001 7:54 PM
Subject: Re: alter table error
Well, I wante
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?
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 sho
I use the utility from www.edatanew.com
Not perfect, but it does something.
- Original Message -
From: "Michael Palm" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, March 26, 2001 6:54 PM
Subject: Best way to generate laser-printed reports from mysql
> I am wondering how mos
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 Message-
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, 1
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 c
It's better like this:
alter table message add index subject2 (subject);
- Original Message -
From: "Daniel Adams" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, March 26, 2001 7:19 PM
Subject: alter table error
Can anyone tell me what this means and how to fix it? I ran the
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_
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 k
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
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
Thanks heaps...as long as I can use distinct(count..)), i'm happy going
back to .33 :)
Cheers!
P
On Mon, 26 Mar 2001, Fred van Engen wrote:
> Hi Peter,
>
> On Mon, Mar 26, 2001 at 04:30:43PM +0100, Peter Skipworth wrote:
> > Eeps...I'm running 3.23.35..I gather you'd suggest down-grading to .
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 Si
Hi All,
What is the string that you would use to set "AST"
time zone file ?
Atlantic Standard Time doesn't have a daylight
component, and I couldn't
get anyone at sun to give me the string that would
represent it. They
only have entries for North America in Solaris up to
2.6.
Thanks
=
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???
Hi Peter,
On Mon, Mar 26, 2001 at 04:30:43PM +0100, Peter Skipworth wrote:
> Eeps...I'm running 3.23.35..I gather you'd suggest down-grading to .33 ?
>
Or wait for 3.23.36. I would expect that they release it soon because
the MySQL team advised not to use the previous two versions. I just
hope
Eeps...I'm running 3.23.35..I gather you'd suggest down-grading to .33 ?
I realise how the MERGE tables work...I INSERT into the sub-tables and
select from both the MERGED table and the sub-tables. By the way, do you
happen to know when support for "select distinct(count...))" was added ? I
know
On Monday 26 March 2001 17:16, Johan Vanroose wrote:
> > This mailing list provides plenty of great support, and I take this
> > opportunity to thank the MySQL people once more (and they deserve much
> > more than that).
>
> I'm not sure how to interprete your statement. It looks like you are
> d
Jean-Luc Fontaine wrote:
> 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/
can you give us the command you are getting the error with? Looks like a
syntax error to me. (Which reminds me, when are you guys going to put a
spellchecker in the MySQL client?) :)
Cal
http://www.calevans.com
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent:
Hi,
I have downloaded Mysql (HPUX11 version) and installed it on
mydeslktop HP9000. Itis up and running and I ran the
scripts/mysql_install_db script. I can log on as root but I am having
trouble creating another user. I will plead ignorance here as I confess the
reason I loaded mysql is to l
Hi Peter,
On Mon, Mar 26, 2001 at 03:04:29PM +0100, Peter Skipworth wrote:
> Ouch!! Watch this!! I queried the 'sub' table (Feb's data), tried querying
> the MERGE table (which errored, with mysqld restarting itself in some
> fashion), queried the SAME sub table, and most of my data had
> disappe
Cal Evans writes:
> Sinisa,
>
> Is there a published list of features for 4.0?
>
> Cal
> http://www.calevans.com
>
It is not complete yet.
But, new .frm files, multi deletes and updates from joins, UNION's and
many others.
Regards,
Sinisa
__ _ _ ___
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
Ca
Cal Evans writes:
> 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
>
Actually, they will be in 4.1.
And the above query does not need
Ouch!! Watch this!! I queried the 'sub' table (Feb's data), tried querying
the MERGE table (which errored, with mysqld restarting itself in some
fashion), queried the SAME sub table, and most of my data had
disappeared! I've run 'check table...' and it doesnt show any errors...
mysql> select cou
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
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 dict_index_c
<[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 alw
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
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 whi
Hey there..
First of all, sorry if this has been discussed before, I tried traversing
the archives but nothing could be found. This problem might be extremly
simple, but anyhow.. :)
The Problem:
I have a php script/Perlscript (should be possible in both :), which needs
to find the next "availabl
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)
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 syn
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
1 - 100 of 125 matches
Mail list logo
