Hi,
myisamchk shows me the following warning message on some of my tables :
myisamchk -a searchjoinhardwarefr2.MYI
Checking MyISAM file: searchjoinhardwarefr2.MYI
Data records: 264494 Deleted blocks:1288
- check file-size
- check key delete-chain
- check record delete-chain
- check index
When I execute "DELETE FROM VALID_CACHE;" where VALID_CACHE is
the name of a table I get "0 rows affected" even if multiple rows are deleted..
I am expecting the return value to be the number of rows which were removed.
I await your response (please respond by email).
Hi
i have 3.23.32 version of mysql. i wants to export the database from
\mysql\bin\
please tell.
thanks in advance
Manish Mehta
CORE Solucomm Limited
423 B, Hamilton Court,
DLF City, Phase IV,
Gurgaon,
India - 122 001.
Tel: +91-124-6392896 / 897 / 035
Fax:+91-124-6392036
E-mail: [EMAIL PROTECTE
I've just bumped into the same problem - a RedHat 6.1 server that ran
for 2 years with MySQL-3.22.27-1.i386 rpm's from the mysql site, and the
server just died and is having identical behaviour to that describe -
hangs on creating tables, mysqladmin stalls.. Any help would be much
appreciated
Hi!
Why dont u try this,
if(mysql_num_rows($var1)>0)
{
mysql_free_result($var1);
delete;
}
else
{
echo("record doesnot exists");
}
cheers,
Jayasimhan A
- Original Message -
From: Palafox, Alfredo <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, January 23, 2002 1
Heres an example scenario, say I have two tables
table1
-> id
| name
|
| table2
|_> id
address
zip
I inner join table1 and table2 on id. I want to delete all the records in
table1 which have a zip of '90210'. I could create a script, run a select
Hi Oleg,
There is some sort of thread problem with freebsd but it usuually is
not that bad. How did you compile MySQL? I would recommend using the
ports version of Mysql (cd /usr/ports/databases/mysql-3.23-server) .
Look at the makefile if you are still havbing threads problems you can
try com
Hi Anton,
Try this:
select State,City,Ifnull(Suburb,'') from tbl
Order By State,City,Ifnull(Suburb,char(255));
Anvar.
At 01:42 PM 23/01/2002 +0200, you wrote:
>database,sql,query,table
>
>
>
>Hallo All
>
>I have a select statement for 3 fields (State, City, Suburb) then I
>ORDER BY State,City,
Hi there,
yesterday my mysql server (running under irix) has gone away
and took one table with it
so i tried to recover the data with isamchk -o table_name
unfortunalty during the recoveryprocess half of the data
will be thrown away - is there any way to avoid this?
bevore recovery: datafile: 4
>Description:
Installation: The rpm displays the message:
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
This is done with:
/usr/bin/mysqladmin -u root -p password 'new-password'
/usr/bin/mysqladmin -u root -h angmar -p password 'new-password'
However, there is no mysqladmin in the
thanks to all respondents! one more thing, i have 2 foreign keys in the
bridge table, but not a primary key. is a primary key in the bridge
necessary for this type of join to work? thanks again.
Begin forwarded message:
> From: Roger Karnouk <[EMAIL PROTECTED]>
> Date: Wed Jan 23, 2002 03:25:
Hi,
Please help me to use SQL (with mysql prompt) command to replace any digit
in column.
Example:
Old value 123466
New value 123456
How to replace old value at fifth digit (6) to 5?
Thank you,
SF
---
But I am installing all the apps from the RPM's that came from Redhat.com
and Mysql.com and with the Redhat CD. Now shouldn't these all work
together?
Jim Lucas
bend.com
- Original Message -
From: "Trond Eivind Glomsrød" <[EMAIL PROTECTED]>
To: "Jim Lucas [jimmysql]" <[EMAIL PROTECTED]>
Title: ³×À̹ö ¸ÞÀÏ
¹ÚÂù¹Î (naracom2002) ´Ô²² º¸³»½Å ¸ÞÀÏ
ÀÌ ´ÙÀ½°ú °°Àº ÀÌÀ¯·Î Àü¼Û ½ÇÆÐÇß½À´Ï´Ù.
¼ö½ÅÀÚÀÇ ¸ÞÀÏ º¸°ü ¿ë·®ÀÌ °¡µæÂ÷ ÀÖ½À´Ï´Ù. ³ªÁß¿¡ ´Ù½Ã ½ÃµµÇϽʽÿÀ.
-
> From: Oleg Prokopyev <[EMAIL PROTECTED]>
>
> > freebsd 4.4 stable mysql3.23.47
[deletia]
BTW - I tried to send the threads explanation to
your account, but I got a bounce-back with "spam host
denied" message... (!?)
Russ.
---
From: Oleg Prokopyev <[EMAIL PROTECTED]>
> freebsd 4.4 stable mysql3.23.47
>
> when i start it - it works -
> but after 10-15 minutes cpu usage became about 100%
> and mysqld do not responds to any query
Yes. It's caused by a problem in the FreeBSD threads
library, and this problem has been ar
Thanks. I did try that but Visual C++ 6 (wonderful tool though it isn't)
kept on complaining about my iostreams being redefined. I tried searching
for where this was happening (an #include would have done it,
not being the way standard C++ is meant to be written) and found some but
eliminat
create table magazine
(Mag_id int primary key,
Name char(30));
create table customer
(cust_id int primary key,
name char(30));
create table bridge
(cust_id int not null,
mag_id int not null,
primary key(mag_id,cust_id));
insert into customer values (10,'John'),(24,'Luke'),(43,'Tony'),(25,'Ma
* mike vogel
> i understand that creating a M:N relationship in mysql involves 3
> tables, one of which being a bridge, but how do i join the first and
> third tables by way of a bridge?
The same way you do a M:1 'bridge', but one single table is the M-part of
both 'bridges'.
> example: a tab
How to check disk space been used for all of the tables of a specific
mysql account?
Thanks in advance for all answer!
Alex
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mys
Thanks, David.
He is of course correct if you need to look up the name of the
subscriber. If you already know the subscriber's ID, you can modify the
query to look more like mine.
In any case, try to avoid large joins. :)
At 03:08 PM 1/23/2002 -0800, David Turner wrote:
>Sorry not real fami
Sorry not real familar with MYSQL syntax yet but I think you'll
be able to translate.
select
m.magazinename
from
s,m,b
where
s.name = 'fred'
and
s.id=b.subscriberid
and
m.id=b.magazineid
;
On Wed, Jan 23, 2002 at 03:59:11PM -0700, Christopher Thompson wrote:
> At 02:51 PM 1/23/200
At 02:45 PM 1/23/2002 -0800, Eric Mayers wrote:
>I'm designing a system that will parse and store log files in a
>MySQL-Max-2.23 database (the log table will be innodb). I have a
>requirement that as the database fills towards maximum capacity that it
>writes over the oldest records rather than d
At 02:51 PM 1/23/2002 -0800, you wrote:
>i understand that creating a M:N relationship in mysql involves 3 tables,
>one of which being a bridge, but how do i join the first and third tables
>by way of a bridge?
>
> example: a table of subscribers and a table of magazines with a bridge
> in th
i understand that creating a M:N relationship in mysql involves 3
tables, one of which being a bridge, but how do i join the first and
third tables by way of a bridge?
example: a table of subscribers and a table of magazines with a bridge
in the middle. how do i select just the magazines fr
I'm designing a system that will parse and store log files in a
MySQL-Max-2.23 database (the log table will be innodb). I have a
requirement that as the database fills towards maximum capacity that it
writes over the oldest records rather than dropping new records.
I'd like to know if this is
On 23 Jan 2002, at 14:20, Jeremy Zawodny wrote:
> I think that what you want is really:
>
> http://www.mysql.com/doc/U/p/Update_log.html
Why do you say that? As I understand it, the update log records only
queries that change the databases. At the moment I'd like to see the
connections an
thanks a simple but effective explination.
-Original Message-
From: Christopher Thompson [mailto:[EMAIL PROTECTED]]
Sent: 23 January 2002 22:29
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: Can Anyone explain / help with auto_increment fields.
At 10:23 PM 1/23/2002 +, you w
At 10:23 PM 1/23/2002 +, you wrote:
>Hi,
>
>I have a blank table for some testing.
>
>1 of the fields (the primary key) is an auto_increment and not null.
>
>how and what do I insert into this field to start off the recordsets. also
>once I have set the records going say to 1, what do I then i
Hejsan
1. Kan man köra MySQL i DOS eller måste man ha Windows installerat ???
2. Finns det något Windows baserat redskap som man kan redigera i databasens
tabeller och/eller lägga till/ta bort tabeller, spalter och kolumner ???
Tack på förhand.
MvH. Jimmy
--
Hi,
I have a blank table for some testing.
1 of the fields (the primary key) is an auto_increment and not null.
how and what do I insert into this field to start off the recordsets. also
once I have set the records going say to 1, what do I then insert if
anything into this field for the next r
On Wed, Jan 23, 2002 at 10:16:28AM -0500, Keith C. Ivey wrote:
> On 22 Jan 2002, at 17:02, Jeremy Zawodny wrote:
> > On Tue, Jan 22, 2002 at 09:55:14AM -0500, Keith C. Ivey wrote:
> > >
> > > As far as I can tell from the documentation, the --log option is
> > > supposed to turn on logging to the
Hi,
I installed MySQL version 3.23.47. It starts up and stop when i
use the following command
/etc/rc.d/init.d/mysql start
/etc/rc.d/init.d/mysql stop
Bu I attem to start /usr/sbin/mysqld server and edit the user table and
update the password and user, it gives me following Fatal error
[r
At 13:22 -0800 1/23/02, mike vogel wrote:
> i want to select the column names from one table into the rows of
>another. is this possible? thanks in advance!
Using nothing but SQL, no. Using SQL within a program, yes.
>
>-kp
---
i want to select the column names from one table into the rows of
another. is this possible? thanks in advance!
-kp
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
For various reasons, I need a C++ API to MySQL for use in Windows (and
possibly Linux as well). I know I can find one or two in the
downloads/contrib section but I'm looking for suggestions.
I'm quite happy with the way the C API is set up. But
On Wed, Jan 23, 2002 at 11:00:21AM -, annazaraah wrote:
> hi there,
>
> so can anyone help me with a reg expression that will find a match if it
> begins with "m" and is directly followed by a number, which is then followed
> by either a number or a letter or a space character..
Hmm. Someth
Hi!
I was using MySQL and Visual FoxPro but I don't know if exists an API to do it
with. I had working with MyODBC and I have no problem at all. With VFP I use to
work with both Remote Views and SQL Pass Throu.
Bye.
:- )
__
José Angel Blanco Linares
Depto S
Is there any api that i can use mySql whith Visual FoxPro ?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this t
hello
i got the following problem
freebsd 4.4 stable mysql3.23.47
when i start it - it works -
but after 10-15 minutes cpu usage became about 100%
and mysqld do not responds to any query
any idea?
--
Regards,
Oleg Prokopyev
OAP4-RIPE
---
"Jim Lucas [jimmysql]" <[EMAIL PROTECTED]> writes:
> When I tried installing MySQL 4.0.1 it said that I had conflicts.
>
> It listed the file libmysqlclient.so.10 as being needed by 5 different
> progs.
>
> [root@office2 RPMS]# rpm -Uvh MySQL-shared-4.0.1-2.i386.rpm
> error: failed dependencies
When I tried installing MySQL 4.0.1 it said that I had conflicts.
It listed the file libmysqlclient.so.10 as being needed by 5 different
progs.
[root@office2 RPMS]# rpm -Uvh MySQL-shared-4.0.1-2.i386.rpm
error: failed dependencies:
libmysqlclient.so.10 is needed by mod_auth_mysql-1.11-
Hi Egor, thank you very much for the help.
> Of course you can do rm -f /var/lib/mysql/mysql.sock as root while mysqld
> is not running and try to start MySQL again. The server is intended to run
> as "mysql" user.
I am sorry but there isn't any file mysql.sock in the folder /var/lib/mysql.
In
To find out what an error mean, you can do #perror :
[root@indigest /root]# perror 127
Error code 127: Unknown error 127
127 = Record-file is crashed
(http://www.mysql.com/doc/p/e/perror.html)
So, at least one table from your query is crashed: forums or posts.
To recover the table, take a look
>Description:
During installation it is impossible to run the myqsl_install_db script. It
just keeps hanging after execution. It prepares the priviledge-tables fine,
but when it tries to open the mysql-server for installing them it hangs,
just after the "Installing tables" prompt. I have tried to
Hi Alfredo,
This looks like PHP - and we're on a MySQL list. Are you aware of the PHP lists -
specifically PHP-DB?
Comments below:
> I'm new to mysql database design, I have a PHP script to DELETE records but
> before that I need to be sure that the record exists.
>
> My script goes like this:
OK I have to admit I have an exam tomorrow. - Modern OS's!
I would appreciate your thoughts.
There are several questions I would love your educated help with. I
have read documentation on the internet but some of it is very old and
I'm not sure how trustworthy it is. (I'm mostly an NT user)
1
Sounds good. Thanks for the info, Heikki.
--Walt
-Original Message-
From: Heikki Tuuri [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 23, 2002 11:13 AM
To: [EMAIL PROTECTED]
Subject: Re: Benchmarking MyISAM, InnoDB, and Oracle: a problem with
InnoDB
Walt,
this is probably a perfo
Hi,
I'm new to mysql database design, I have a PHP script to DELETE records but
before that I need to be sure that the record exists.
My script goes like this:
line 6 $var1 = " select * from table.field where id_record = '$record' ";
line 7 if( $var2 = mysql_fetch_array($var1) )
line 8 {
lin
* Cindy Yu, January 23, 2002 7:18 PM
> When I use this on Sun saloris, it does work.
ok... I guess you mean solaris, and maybe you even mean it does NOT work?
> mysql> use mysql
> Database changed
> mysql> tee /usr/local/var/ub_store
> it shows syntax error with tee.
What do you mean "it shows
On Wed, 2002-01-23 at 07:42, Egor Egorov wrote:
> Panos,
>
> Tuesday, January 22, 2002, 5:42:20 PM, you wrote:
>
> PM> I have some problems loading files into blobs when the file
> PM> resides on a network filesystem e.g. SAMBA. I use mysqld
> PM> 3.23.43-nt.
>
> PM> e.g.
>
> PM> UPDATE Readi
On Tue, Jan 22, 2002 at 10:19:46AM +0100, Roger Baklund wrote:
>
> Just to make it clear: this is the primary key, and all four parts
> of the index are needed to identify the row. Most of the time I use
> the three first parts, sometimes I use all four parts, and sometimes
> I use only the first
Not sure if this is a tough one or an easy one. Take a shot at it - maybe
you can solve it.
I have a production server running 3.23.36-log, and I just set up a
development box about a week ago. The development box was intended for
testing out new versions of things, so we had MySQL 3.23.42 on the
Try using "LIKE" instead of "=":
$sth = $dbh->prepare("SELECT * FROM Years WHERE Date LIKE '2002-%'");
$sth->execute();
On Wed, 2002-01-23 at 17:09, Jason Whitlow wrote:
>
> I am trying to do a select statement but am having problems with the "%" in
> my string.
>
> I am trying to
>
> $sth
Hi Roger,
When I use this on Sun saloris, it does work.
mysql> use mysql
Database changed
mysql> tee /usr/local/var/ub_store
it shows syntax error with tee.
Can you tell me how to do it on Sun saloris? Thanks!
Cindy
>>> "Roger Baklund" <[EMAIL PROTECTED]> 01/11 11:25 AM >>>
* Cindy Yu
> I
55 matches
Mail list logo
