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 am new to
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 =
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
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 two
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 Reading SET
* 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 syntax
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 {
line
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
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)
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:
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
To find out what an error mean, you can do #perror errno:
[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
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 this
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
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:
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
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
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. Something
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)
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
-
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
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 general
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
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
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 insert
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
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 and
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
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
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 the
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
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
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
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)
* 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 table
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
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 around
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.
-
Title: ³×À̹ö ¸ÞÀÏ
¹ÚÂù¹Î (naracom2002) ´Ô²² º¸³»½Å ¸ÞÀÏ Processlist Commands in sql/sql_parse.cc:72
ÀÌ ´ÙÀ½°ú °°Àº ÀÌÀ¯·Î Àü¼Û ½ÇÆÐÇß½À´Ï´Ù.
¼ö½ÅÀÚÀÇ ¸ÞÀÏ º¸°ü ¿ë·®ÀÌ °¡µæÂ÷ ÀÖ½À´Ï´Ù. ³ªÁß¿¡ ´Ù½Ã ½ÃµµÇϽʽÿÀ.
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
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:06
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
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:
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,Suburb
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
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
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
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
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,
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
50 matches
Mail list logo