mysql doesn't support subselects.
Jeff Levy
Software Design
Meta-Craft Creations
On Fri, 30 Mar 2001, Ramasamy Palaniappan wrote:
> Sir,
>
> created the following tables as primary and secondary
>
> primary : partycode(primary key),partyname
>
> secondary : partycode(references to primary),comp
I am now using msql and wants to change to mysql. Is there any problem
in install both in the same server?
Regards,
Alan
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.
Sir,
created the following tables as primary and secondary
primary : partycode(primary key),partyname
secondary : partycode(references to primary),companyname
select partycode,companyname from secondary where partycode=(select
partycode from primary where partyname="");
as per mysql - the
I'm interested in stored procedure as well.
I only know that SP are available in the INNOBASE engine, but I'm
looking for access SP from mysql SQL interface.
ciao - Paolo
> -Original Message-
> From: Razvan Veina [mailto:[EMAIL PROTECTED]]
> Sent: venerdì 30 marzo 2001 8.39
> To: [EMAIL
Is there any support for stored procedures in MySQL ? If so, what version of MySQL ?
I have a query I'm sending to the DB...however, instead of having the server
send me the data back, I want to put it into a CSV file for use in an Excel
Spreadsheet. This means either tab-delimited, or separated by commas. Can
someone help?
Thanks,
--
Try printing out $inlist and see if this is correct. Each item must be
separated by commas and it looks like your code may not be doing that.
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Friday, March 30, 2001 11:5
>
> Hi,
>
> my problem is that now the second time the performance of my f740
> goes down every day.
> i solved the prob with increasing maxfiles (no to the max for the
> volume).
> after that the cpu of the filer, which went up from
> 25% peak to 90% peak in 5 days, goes down again.
>
> any i
Why don't use FULLTEXT index ? This select doesn't use normal index so
you have a sort of linear search
Chai-Hup Chen wrote:
> Hi,
> I find in our database, select "% string %" is very slow (>1
> minute). The database size have only 2M rows, any idea how could I get
> faster response? Than
Yep, what do you need ?
Sven Huster wrote:
> Hi there,
>
> i anybody out there running mysql on a netapp filer as data storage?
>
> regards
>
> Sven Huster
> Senior Unix System Administrator
> *BSD, Linux, Solaris
>
>
> -
>
Hallo all,
A table containing some text needs to have some of the letters changed (eg.
letter ä to be replaced with "ä" ).
Is there a way to use a replace function to search for such chararcters in a
text and then replace it with the html tag?
Thanks very much
Roland
Hi everybody, I have run a few test for innobase tables on linux and BSD
1. It seems that 'innobase' table was slower than 'bdb' table for 'insert' command,
which is surprising(or not? o_O)
2. It may be due to that fact that I dont' know much about optimazing the 'innobase'
table. Anybody
I know this question is not related here, but while on the Oracle
Question, could someone tell me how to install Oracle for Linux of the
list :)
Adrian
On Thu, 29 Mar 2001, Freaked Personality wrote:
> Yea oracle has been ported for a while already, been running it for like 6
> months on SuSE
In a message dated 30/03/2001 04:42:44 GMT Daylight Time,
[EMAIL PROTECTED] writes:
<< What doesn't work and where is your delete statement?
>>
This is my full code
$www_domain="select Failed_Signups.EmailAddress.Email from
Failed_Signups.EmailAddress left join www_domain_net.Members on
Fa
Hi,
Been running mysql-3.22.32 / Solaris / Sun / dual-processor:
Mysql.pm 1.2214 + DBI 1.14 + perl 5.004_04
Database with 40 tables.
Biggest table has 2,131,447 rows in it.
No problems for 6 months.
Recently ported to mysql-3.23.35 / Linux 2.2.12-20smp / dual-processor.
Mysql.pm 1.2215 + DBI 1.
Hi,
No. you can't delete based on a join.
Regards
Quentin
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Friday, 30 March 2001 3:35 p.m.
To: [EMAIL PROTECTED]; [EMAIL PROTECTED];
[EMAIL PROTECTED]
Subject: Delete Again?
Hmmm
Well I didn`t manage to get a
What doesn't work and where is your delete statement?
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Friday, March 30, 2001 11:35
Subject: Delete Again?
> Hmmm
>
> Well I didn`t manage to get any of those examples
Hmmm
Well I didn`t manage to get any of those examples to work. This is my select
statement..
"select Failed_Signups.EmailAddress.Email from Failed_Signups.EmailAddress
left join www_domain_net.Members on
Failed_Signups.EmailAddress.Email=www_domain_net.Members.EmailAddress where
www_domain_
reboot your pc in safe mode and install myodbc again.
Quentin Bennett wrote:
>
> Hi,
>
> When trying to install the latest ODBC I get
>
> An error occurred while copying C:\WINDOWS\SYSTEM\ctl3d32.dll. Restart
> Windows and try installing again.
>
> The file mentioned exists, and is not read o
Hi,
When trying to install the latest ODBC I get
An error occurred while copying C:\WINDOWS\SYSTEM\ctl3d32.dll. Restart
Windows and try installing again.
The file mentioned exists, and is not read only. Restarting windows does not
help.There are not other ODBC programs running. Any suggestions?
>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:
What happens if i use INSERT DELAYED and the client sends a lot of
messages, much more that mysql is able to handle?
(like when you log to a sql database, and you got lots of messages)
--
Florin Andrei
-
Before posting, pleas
Q: I have the following table "grades".
++++
| name | score |id |
++++
| John |10 | 1 |
++++
| John | 20 |2 |
++++
| John | 8 |3
Thanks so much. I fixed the problem with OPTIMIZE.
Linda
-Original Message-
From: Jeremy D . Zawodny [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 29, 2001 1:54 PM
To: Guanglin Dong
Cc: '[EMAIL PROTECTED]'
Subject: Re: File size problem!
On Thu, Mar 29, 2001 at 01:46:28PM -0800, Gua
When compiling .36 under OS X release, the following error occurs:
c++ -DMYSQL_SERVER
-DDEFAULT_MYSQL_HOME="\"/usr/local/mysql\""
-DDATADIR="\"/usr/local/mysql/var\""-DSHAREDIR="\"/usr/local/mysql/share/mysql\
""-DHAVE_CONFIG_H -I../bd
Howdy, all.
The following error came up when compiling under OS X release.
c++ -DMYSQL_SERVER
-DDEFAULT_MYSQL_HOME="\"/usr/local/mysql\""
-DDATADIR="\"/usr/local/mysql/var\""
-DSHAREDIR="\"/usr/local/mysql/share/mysql\""
-DHAVE
>From the returned results create a comma delimited list containing unique
identifiers of the returned results and then in your SQL statement, have
DELETE FROM ... WHERE ... NOT IN (comma delimited)
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Frid
Here's how I would do it:
$inlist .= sprintf("\'%s\'",$Array['Email']);
Then after the loop:
$query = "DELETE FROM sometable WHERE email NOT IN (".$inlist.")";
mysql_query($query);
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, March 29, 2001 5:02
Hi,
I`m just trying to figure out the best method to delete my records and
wondered if it was possible to do a DELETE statement to remove any records
that don`t match.
Here is my code so far
$Query="select blah its huge:-)";
$RESULT=mysql_query($Query);
$my_rows=mysql_num_rows($RESULT);
for
I think you want datestamp (or is it timestamp?) for automatic updates.
Chapter 7 of the manual describes all the functions that can be used for
date formatting. All this is in the manual.
- Original Message -
From: "Mike Roberts" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday,
There are a number of ways depending on how the value is stored.
I suspect that they have been stored as strings in which case you can use
left_string, right_string and middle_string to separate the 1 from the rest
of the date. Note that the names, left_string etc., are fake and you
should chec
I created a table with a datetime field. I need info on it! I don't know how
to work these fields.
So far there are about 5 records in the table and I haven't touched the
datetime field.
What I need to know is if that field gets updated automatically when the
record is inserted or updated. And m
Am 00:20 30.03.2001 schrieb Joshua Chamas:
>*This message was transferred with a trial version of CommuniGate(tm) Pro*
>Sven Huster wrote:
> >
> > Hi there,
> >
> > i anybody out there running mysql on a netapp filer as data storage?
> >
>
>Yes, I've done this for a client from a linux server. Wo
On Tue, 27 Mar 2001, Sinisa Milivojevic wrote:
> You also need fl_editor package. You will find a link on mysqlgui
> page.
OK, that indeed got me further. (Is it only me, or does putting a header
file into one package, and the source in another one really sound funky?).
Anyways, I'm down to one
Sven Huster wrote:
>
> Hi there,
>
> i anybody out there running mysql on a netapp filer as data storage?
>
Yes, I've done this for a client from a linux server. Worked
fine as long as there was only one mysql server accessing
the data. The network as 100 Mbs, and the SQL volume was
prett
Hey there,
Im in need of of a win2000 binary with the option --with-raid,
dont have any possibillity to compile it my self... So anyone with win2000 and
the possibillity to download and recompile the source?
/roger
Help,
I am trying to install the Sun Solaris 2.7 Sparc static binary of
MySQLGUI 1.6 for the MySQLGUI the result was:
ld.so.1:./mysqlgui-solaris-2.7-sparc-static-1.6
:fatal:libstdc++.so.2.10.0:open fatal: no such file or directory
1. Trying to install this GUI on a solaris box, ma
All,
desc resource shows asset_tag in all upper case, but:
mysql> UPDATE RESOURCE SET ASSET_TAG = '' WHERE ASSET_TAG IS NULL;
ERROR 1054: Unknown column 'ASSET_TAG' in 'field list'
mysql> update resource set asset_tag = '' where asset_tag is NULL;
Query OK, 0 rows affected (0.01 sec)
T
Hi there,
i anybody out there running mysql on a netapp filer as data storage?
regards
Sven Huster
Senior Unix System Administrator
*BSD, Linux, Solaris
-
Before posting, please check:
http://www.mysql.com/manual.php (th
In the last episode (Mar 29), Guanglin Dong said:
> I have problem about the mysql database file. After I deleted a lot
> of table records, the database data and index file still have the
> same size as that before I deleted a lot of records. Anybody knows
> how to shink the database file size aft
On Thu, Mar 29, 2001 at 01:46:28PM -0800, Guanglin Dong wrote:
> Hi,
>
> I have problem about the mysql database file. After I deleted a lot
> of table records, the database data and index file still have the
> same size as that before I deleted a lot of records. Anybody knows
> how to shink the
Hi,
I have problem about the mysql database file. After I deleted a lot of table
records,
the database data and index file still have the same size as that before I
deleted a lot of records.
Anybody knows how to shink the database file size after I delete a lot of
records?
Thanks in advance.
Lin
Are you inserting them as strings or as dates?
At 02:50 PM 3/29/2001 -0600, gary sanders wrote:
> We have an older system that we have to put up with for another
> year, their "fix" for y2k was, like several others, to place a number one
> before the date "ex 1000329 or 1010329 which is
On Thu, Mar 29, 2001 at 02:09:02PM -0500, Thalis A. Kalfigopoulos wrote:
> Hello,
>
> A question about the -O option you can pass on command line to
> safe_mysqld. If for example I give -O record_buffer=64M does that
> mean that I'll get: exactly 64M, at the most 64M or at least 64M?
At most. Y
I am a newbie to the MySQL world and am having some difficulties with it. I
am running a Win2K network (Win2K Pro, Win2K Adv. Server) using TCP/IP. I
loaded MySQL on both a server and a workstation. I was able to get the
server going (mysqld-nt --install, net start mysql), and was able to log
i
We have an older system that we have to put up with for another year,
their "fix" for y2k was, like several others, to place a number one before
the date "ex 1000329 or 1010329 which is interpreted as Mar. 29, 2000 or
Mar.29, 2001. Is there a way to delete the "1" at the beginning when
Hi !
I notice a bug with MySQL 3.23.36 with REPLACE DELAYED which crash my MyISAM
tables.
The problem was present in MySQL 3.23.34, but not in 3.23.33 nor 3.23.35.
The bug occurs randomly and makes MySQL restart...
With REPLACE instead of REPLACE DELAYED, there seems to be no problem.
Here is
> MySQL doesn't use a table index when doing a string search like %string%,
> but it MAY use the index when doing something string%. Is there a way you
> can change your search to do a "string starts with" instead of a "string
> contains" ? This should help with MySQL using the index that you wa
Hello,
I'm attempting to compile MySQL 3.23.36 on a Linux system (heavily modified i386
RedHat 7.0 base with 2.4.2 kernel and gcc 2.95.3) but get the following error message
some ways down:
Making all in client
make[2]: Entering directory `/home/jandrews/mysql-3.23.36/client'
c++ -DUNDEF_THR
Hello,
A question about the -O option you can pass on command line to safe_mysqld.
If for example I give -O record_buffer=64M does that mean that I'll get:
exactly 64M,
at the most 64M
or at least 64M?
Also I have a batchfile with about 150 queries (all plain selects) which I feed into
mysql.
I have MySQL server on NT 4.0 SP6a
I connect to the db through this asp script :
strConnection = "driver={MySQL};server=xxx.xxx.xxx.xxx;uid=" + UID +
";database=" + DBName + ";password=" + Passwd + ";port=;";
adoDataConn = Server.CreateObject("ADODB.Connection");
adoDataConn.Open(strConnectio
MySQL doesn't use a table index when doing a string search like %string%,
but it MAY use the index when doing something string%. Is there a way you
can change your search to do a "string starts with" instead of a "string
contains" ? This should help with MySQL using the index that you want it t
On 3/29/01 3:37 AM, "Darius Ivanauskas" <[EMAIL PROTECTED]> wrote:
> Hello,
>
> Does anybody know, how to insert large amount of data
> (ex.: large binary files) into BLOB columns?
>
> Thanks,
> Darius Ivanauskas
>
> P.S. Please reply to me.
>
>
The general algorithm is:
Open binary file
C
Hey all.
I asked a question on the list before, but didn't really get any replies so
I'd like to take another shot and give some more specifics.
I'm using MySQL running Win2K Prof with 128 MB RAM, 7200 DMA100 IDE drive,
etc.
I'm connecting to the MySQL server through MyODBC from a Visual Basic
Yep, I did this too when I was first starting out.
Something you put into mysql.user is syntactically incorrect.
The server does a sanity check on it's permissions, and if they are screwy,
kills itself to save your data. (very big of it, yes?)
The quickest way out of this mess is to delete the my
Hi !
I notice a bug with MySQL 3.23.36 with REPLACE DELAYED which crash my MyISAM
tables.
The problem was present in MySQL 3.23.34, but not in 3.23.33 nor 3.23.35.
The bug occurs randomly and makes MySQL restart...
With REPLACE instead of REPLACE DELAYED, there seems to be no problem.
Here is
On 3/29/01 7:29 AM, "Tim Bauer" <[EMAIL PROTECTED]> wrote:
> Dear Friends,
>
> Sorry for the stupid question, but are any of the distributions
> available out there for the newly released Mac OS X.
>
> I see two on MySQL download pages:
>
> MacOS X Server (PowerPC) [apple-rhapsody5.5-powerpc]
Hi,
I find in our database, select "% string %" is very slow (>1
minute). The database size have only 2M rows, any idea how could I get
faster response? Thanks a lot.
CREATE TABLE Books (
isbn char(10) NOT NULL default '',
Title char(255) NOT NULL default '',
KEY isbn (isbn),
KEY Tit
On Thu, 29 Mar 2001 [EMAIL PROTECTED] wrote:
> Hi,
>
> I have two database`s with one table in each. (MySQL)
>
> Is there a way that I can select data from one table and then match it with
> the data in another and discard the results so all I am left with is the
> original data from the fi
in PHP (I wouldn't try to do this in SQL) use this psuedo code:
$lcvA = 1;
while (you can still fetch rows){
$color = ($lcvA%2)=0 ? "RED" : "GREEN";
echo "";
.
.
.
$lcvA++;
}
HTH,
Cal
http://www.calevans.com
-Original Message-
From: Mike Roberts [mailto:[EMAIL PROTECT
Hi Sander!
On Thu, Mar 29, 2001 at 02:11:02PM +0200, Sander Pilon wrote:
> I'm getting a whole lot of mysql++ link problems on freebsd :/
>
> Used gcc 2.95.3, latest mysql++
>
> The program links fine under linux & win32.
>
> Any idea's?
>
> [...]
What version of FreeBSD are you currently u
I would check to see what chron is doing every 10 minutes.
Ivan Lamouret wrote:
>
> >Description:
>
> safe_myqld keeps restarting the server until it eventually dies (number of running
>process 0).
> This is true when the server is ran as a daemon and from the shell !!
> using --skip-grant-ta
try
delete ... limit n;
where n is a reasonable (small) amount. repeat until 0 rows affected :)
- Original Message -
From: "Basil Hussain" <[EMAIL PROTECTED]>
To: "MySQL List" <[EMAIL PROTECTED]>
Sent: Thursday, March 29, 2001 7:10 PM
Subject: Question about low priority deletes
> Hi,
>
[EMAIL PROTECTED] wrote:
>
> I have to put in my table a new type of data:
> IP and NETADDRES
> how can I do?
> what is (for you) the best way to do it?
>
> I think I'll make 4 INTEGER ( an IP is made by 4 number eg. 121.33.122.133)
>
> But then I have to get the little Net to which belong an I
This should do do it..
<%?php
$cellBGN="#FF";
while($row=mysql_fetch_array($p_result)) {
list($var1,$var2,$varN,$varN+1,...)=$row;
($cellBG==$cellBGN ? $cellBG="#CC" : $cellBG="#FF");
printf("\n\t%s\n\n",$cellBG,$varN);
}
?>
-
Johnny Withe
Hi!
> "John" == John Cartwright <[EMAIL PROTECTED]> writes:
John> Hello All,
John> I see a -t or a --timeout= option listed for mysqladmin, but I can't
John> seem to get mysqladmin to recognize it. Is this an oversight in
John> documentation or a case of my misunderstanding?
John> My obje
Hi,
I have two database`s with one table in each. (MySQL)
Is there a way that I can select data from one table and then match it with
the data in another and discard the results so all I am left with is the
original data from the first table which never matched up.
Database1
EmailAddress
I'm using PHP and Mysql.
I was wondering how you can spit out information out of a
database onto a table, but have every second row of the
table a different backround color.
-
Before posting, please check:
http://www.mysql.c
Hi,
There's something I'm not sure about with DELETE LOW_PRIORITY. It says in
the manual that:
"If you specify the keyword LOW_PRIORITY, execution of the DELETE is delayed
until no other clients are reading from the table."
What exactly does it mean by "no other clients are reading"? Does it me
I've never try it but maybe you shold try OBDC connection.
There (in SO) is an OBDC database creation possibility.
Malmo
Malmo> If I only got 20$ for evryone who's too lazy to configure his own comp.
Bill Gates> "Why not?"
On Thu, 29 Mar 200
Hi!
> "Cal" == Cal Evans <[EMAIL PROTECTED]> writes:
Cal> Gotta ask. Is this a problem or just a really bad idea? Part of me can see
Cal> why this is barfing. ON the same line you rename a table twice. If it's
Cal> threading these requests then one thread might not be finished with the
Ca
Hi!
> "Peter" == Peter Zaitsev <[EMAIL PROTECTED]> writes:
Peter> Hello mysql,
Peter> Resently I've found a problem when I was trying to upgrade from
Peter> 3.23.32 to 3.23.36, well I had a same problem then tried to upgrade
Peter> to 3.23.33 so decided to wait a bit, but now i think
Hi.
You may want to read the appropriate section in the manual about MySQL
running on Linux.
The short answer is: Linux shows threads as processes and displays
incorrect information. The 30MB are used by _all_ MySQL threads (of
one daemon) together, although they are displayed for each of them.
Hi.
On Thu, Mar 29, 2001 at 04:43:53PM +0100, [EMAIL PROTECTED] wrote:
> Hello All,
> I have to memory problems with mysql.
> 1: When a client makes a "SELECT * FROM mytable1" request to the server ,
> mysqld allocates memory to handle it and on subsequent queries to the same
>
Thanks a lot, but I've make a mistake (supposing tha t I've done something
I didn't ;-) -inserting -lfleditor switch). Sorry for it.
Malmo
Malmo> If I only got 20$ for evryone who's too lazy to configure his ow
>Description:
safe_myqld keeps restarting the server until it eventually dies (number of running
process 0).
This is true when the server is ran as a daemon and from the shell !!
using --skip-grant-table does not help
just leaving safe-mysqld running (without any query or even connecti
PID USER PRI NI SIZE RSS SHARE LC STAT %CPU %MEM TIME
671 root 90 31292 30M 15960S 0.0 3.0
0:11
Above is a SMALL snip of data from the TOP program in linux. If I am reading this
correctly than each child is sharing 1.5M or RAM
and u
Hello!
As I tried to get the latest mysql version through CVS I encountered the
following error:
mb@:~ > cvs
-d:pserver:[EMAIL PROTECTED]:/cvsroot/mysql login
(Logging in to [EMAIL PROTECTED])
CVS password:
mb@:~ > cvs -z3
-d:pserver:[EMAIL PROTECTED]:/cvsroot/mysql co
mysql-4.0
cvs serv
Hi
At 18:53 29/03/2001 +0200, [EMAIL PROTECTED] wrote:
>I saw a visual tool for use mysql in simplest way:
>under KDE in a window:
>it let do a query in simple way and see the result in a window...
>I mead there are program that let use Mysql in KDE ?
>Thank you in advance, Mario.
It is includ
I saw a visual tool for use mysql in simplest way:
under KDE in a window:
it let do a query in simple way and see the result in a window...
I mead there are program that let use Mysql in KDE ?
Thank you in advance, Mario.
P.S. where cah I find it?
--
I have to put in my table a new type of data:
IP and NETADDRES
how can I do?
what is (for you) the best way to do it?
I think I'll make 4 INTEGER ( an IP is made by 4 number eg. 121.33.122.133)
But then I have to get the little Net to which belong an IP
I mean:
if in my database there is:
121.33
Greg,
Yes, both mysql user and mysql group were added.
Dave
> From [EMAIL PROTECTED] Thu Mar 29 10:35:34 2001
> Received: from otto.nawcad.navy.mil (otto-internal.nawcad.navy.mil [192.58.199.212])
> by tecnet1.jcte.jcs.mil (8.9.3/8.9.3) with ESMTP id KAA00879
> for <[EMAIL PROTECTE
Hello All,
I have to memory problems with mysql.
1: When a client makes a "SELECT * FROM mytable1" request to the server ,
mysqld allocates memory to handle it and on subsequent queries to the same
table no more memory is allocated.However, if a subsequent query such
as
Dear Friends,
Sorry for the stupid question, but are any of the distributions
available out there for the newly released Mac OS X.
I see two on MySQL download pages:
MacOS X Server (PowerPC) [apple-rhapsody5.5-powerpc]
3.23.27 - MacOS X (PowerPC) [beta-apple-darwin1.2-powerpc]
Will either of t
-Original Message-
From: Jonas Norrman [mailto:[EMAIL PROTECTED]]
Sent: 15 March 2001 23:18
To: Val Baker, Paris
Cc: '[EMAIL PROTECTED]'
Subject: conversion
Hi,
> "Val" == Val Baker, Paris <[EMAIL PROTECTED]> writes:
Val> I have been told you offer a service to convert ASP scripts
Hi,
I have been trying to get Mysql up and running on my Solaris 8 box and I'm having a
few problems.
- I downloaded the binary distribution Sun Solaris (Sparc) [Sun Solaris 2.7]
- Using the instructions from the online Documentation I was able to install
MYSQL into /usr/local/mysql witho
> Yann Larrivée wrote:
>
> Thanks for the answer but it is a bit more complexe, i actually
> creates these sample table for the example. Here is an attachement of
> the structure dump.
>
> Hummm you got me to think more about my database structure withc is
> really good. The idea you bourght u
Hi,
I had a running system (suse Linux 7.1, php 4, mysql 3.22.32 and apache
1.3.12).
but the mysql daemon is running in root.
10 minutes before i tried to add a new user in the table user of the db
mysql. but i got no results.
so, i tried again.
-nothing!
then i killed the mysql daemon.
and no
Hi,
I had a running system (suse Linux 7.1, php 4, mysql 3.22.32 and apache
1.3.12).
but the mysql daemon is running in root.
10 minutes before i tried to add a new user in the table user of the db mysql.
but i got no results.
so, i tried again.
-nothing!
then i killed the mysql daemon.
and no
Antonio gulli wrote:
> Any help is appreciated
>
> Welcome to the MySQL monitor. Commands end with ; or \g.
> Your MySQL connection id is 158 to server version: 3.23.36-log
>
> myisamchk -V
> myisamchk Ver 1.45 for pc-linux-gnu at i686
>
> a) Trying a recovery.
>
> myisamchk -r -q -Osort_k
Ian Moss wrote:
>
> Hi,
>
> I'm receiving the following error message when doing a not very complicated
> join between 2 tables.
>
> ERROR 1030: Got error 134 from table handler
>
> I've had a look through the manual but can't find any mention.
>
> Any help would be very much appreciated.
>
I installed MySql using the AIX 4.3.3 binary version and ran into the
following problem. Please help me to locate the libz.a library. Thank
you!
> scripts/mysql_install_db
Could not load program ./bin/my_print_defaults:
Dependent module libz.a(shr.o) could not
I started this question yesterday. Since I can not get a compiled version of mysql to
run on Sparc
Solaris 2.6. I thought I would try and recompile mysql myself. This also failed
miserably with the "cross
compile" error. My question is this .. Has anyone gotten mysql to run on a sparc
system
Dont forget to check into Progress too..
www.progress.com
-j
-Original Message-
From: M. Verheijen [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 29, 2001 7:37 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Betr.: information
Hi,
If you need those things, mabye postgres is mo
I am not sure how the conversion is done, but if it dumps the data,
renames the old file,
loads the new file, and deletes the dump and old file, it would need
freespace twice the
size of the current table and index.
Hang wrote:
>
> Thanks!
>
> So, is there any way to calculate the approximate
If you are running RH Linux, you should find the RPM on the CD.
Chris Becker wrote:
>
> Is the zlib on CPAN? like module Compress::Zlib ?
>
> Many Thanks Gerald!
>
> ChrisB
> MCSE MCDBA
>
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
> Behalf Of Gerald
Hi!
For the [EMAIL PROTECTED] mailing list we only accept full
repeatable bug reports as defined in the MySQL manual.
A complete bug report is done in the following manner:
1) First check the reference manual and the mail archive !
We try very hard to keep the manual up to date so most ques
Hi,
I'm receiving the following error message when doing a not very complicated
join between 2 tables.
ERROR 1030: Got error 134 from table handler
I've had a look through the manual but can't find any mention.
Any help would be very much appreciated.
Cheers
Ian Moss
-
Hi
You can find that information in the Changes History in the MySQL
Manual.
Bye,
Benjamin.
On Thu, Mar 29, 2001 at 11:41:39AM +0100, [EMAIL PROTECTED] wrote:
> Hi
>
> When did the option log-slow-queries become available.
>
> It works on my 3.23.33 setup, but not on a 3.22.32
[...]
I've been reading the list and documentation, but haven't found
confirmation/denial of the following issues:
(Currently using ver 3.23.33 intel binary RPM from mysql.com)
1) Is it possible to have multiple instances of mysql updating the
_same_ binary log(same machine)? If so, this would allow a
1 - 100 of 130 matches
Mail list logo
