Hi,
I have installed mysql-3.22.22 on Linux RedHat, but
now I have problem because I forget the root password.
How do I solve this problem ?
TIA,
dick#
__
Do You Yahoo!?
Send FREE Valentine eCards with Yahoo! Greetings!
http://greetings.yahoo.com
Hello Odhiambo,
> Please allow me to request for help with the table below.
> mysql> select * from relay_ip;
>
>+-+++-+-+
> | rei_aid | rei_uname | rei_domain | rei_ip | rei_ts
>
Please log on to www.mysql.com and do what I did (look under password)
http://www.mysql.com/doc/R/e/Resetting_permissions.html
You to will come to this page :-)
Simon
-Original Message-
From: dick idod [mailto:[EMAIL PROTECTED]]
Sent: 11 February 2002 08:23
To: [EMAIL PROTECTED]
Subject:
I've a strange problem.
Please help me.
I've installed Mysql ver. 3.23-46 and I've 3 tables of type InnoDB
Until 5 days agò it was ok, but now I received a message: "GOT ERROR 146
WHEN READING TABLE".
and I've found in documentation that is a lock timeout problem.
How can I resolve this problem? a
Hi,
I have a problem with my size of MySQL database (.isd file). Every
month my data replace with the new one, n every my data replaced, the
size of .isd file always more bigger than before. How to make my data
light like the first one I fill tables ?
Thank you,
-M. Amrin-
-
Hello,
I make an fulltext index on a column 'detailannonce' of a table 'apptcv'.
When I made this select :
SELECT apptcv.*, match (detailannonce) against (' jardin ') as relevance
FROM apptcv WHERE match (detailannonce) against ('jardin')>0 HAVING
relevance>0 ORDER BY relevance DESC
I didn't h
-Forwarded Message-
> From: Diana Soares <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Subject: Compile options
> Date: 08 Feb 2002 15:35:57 +
>
> Hi,
>
> Is there a way of knowing with wich options mysql was compiled ?
> Thanx,
>
> --
> Diana Soares
>
> (sql)
>
>
Hi!
I made a head table like this:
##
>create table SECURITIES (
SID varchar(16) not NULL,
NAMEvarchar(255)not NULL,
MARKET varchar(8) not NULL,
TICKER
I saw on the webpage that the alpha release of the mysql database was scheduled to
december/january - you mean this year or previous
year?
/Jon
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
Javier,
Monday, February 11, 2002, 5:48:16 AM, you wrote:
JG> hi i´m starting with linux and i want to install the daemon of mysql...
JG> please help.
JG> i all ready read the documentation and the man pages but i dont
JG> understand ... help
If you want to install MySQL, you should download
Benny,
Sunday, February 10, 2002, 7:31:03 PM, you wrote:
BC> I have backed up my data in server A and copied to /var/lib/mysql/my_db in
BC> server B where my_db is the name of database. I can see my_db in left column
BC> of phpMyAdmin 2.2.3 in my browser, but when I try to browse my data, I g
Nick,
Sunday, February 10, 2002, 12:58:12 PM, you wrote:
NW> Hi all
NW> I've just set up and the latest problem I have getting started is that
NW> 'Access denied for user: apache@localhost' msg.
NW> How can I put that right?
Please, check the following links:
http://www.mysql.com/doc/A/
Philippe,
Monday, February 11, 2002, 12:28:47 PM, you wrote:
P> Hello,
P> I make an fulltext index on a column 'detailannonce' of a table 'apptcv'.
P> When I made this select :
P> SELECT apptcv.*, match (detailannonce) against (' jardin ') as relevance
P> FROM apptcv WHERE match (detailannonc
After I've changed the root (mysql) password the logorotate programe (called
from cron) gives me the following error:
===
errors occured while rotating /var/log/mysql.log
./usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied f
Hello there!
I'm using Apache-Session module and it seems that
everything work properly, but in bin log is this
query:
DO
RELEASE_LOCK("Apache-Session-0c47492fccde576b180ea37fa07de395");
What could be wrong in it?
Please help!
Kosyo
__
Do You Ya
I was working on updating some databases yesterday and when I booted up
my computer this morning I couldn't connect to MySQL, the error message
is "can't connect to local MySQL server through socket /path/mysql.socket."
It was there yesterday and now it's gone! Where did it go (a search of
th
> I was working on updating some databases yesterday and when I booted up
> my computer this morning I couldn't connect to MySQL, the error message
> is "can't connect to local MySQL server through socket
> /path/mysql.socket."
>
> It was there yesterday and now it's gone! Where did it go (a
Carsten H. Pedersen wrote:
>>I was working on updating some databases yesterday and when I booted up
>>my computer this morning I couldn't connect to MySQL, the error message
>>is "can't connect to local MySQL server through socket
>>/path/mysql.socket."
>>
>>It was there yesterday and now it's
Hi,
Can you help on this?
I'm trying to index a table with bigint(20), 8 byte field (under linux),
there are now 650.000.000 rows and takes 8,5Gb space. Free space is 17Gb,
twice and stil cant index it couse runs out of space???
aaa@cab1:~/mysql_tests> sudo ls -l /var/lib/mysql/test2docfp/
Paste your sql exactly as it is and your version of mysql.
Dave
On Tue, Feb 12, 2002 at 10:08:10AM +1000, David Mackay wrote:
> Thanks for your quick response Dave,
> Have tried this, but no bannana...
> I get:
> "You have an error in your SQL syntax near 'abs(id)' at line 1"
>
> Seems a not-val
At 10:08 +1000 2/12/02, David Mackay wrote:
>Thanks for your quick response Dave,
>Have tried this, but no bannana...
>I get:
>"You have an error in your SQL syntax near 'abs(id)' at line 1"
If you can't put an expression in your ORDER BY, that means your version of
MySQL is older than 3.23. The
Hello-
How does one run a client in non-interactive mode? Or, is there a way
to set interactive_timeout at the MySQL server to infinite? We have a
software component connecting to MySQL (using Mark Matthews JDBC driver)
and there may be a long time (> 8 hours) of inactivity.
Any suggestions mu
On Sunday 10 February 2002 01:17 am, you wrote:
> I can't get it to start replicating.
>
> Note, the master (db1.tias.com) is a 3.23 server. The slave is 4.0.2
> (noritake.tias.com).
>
> On the master I get:
>
> mysql> show master status;
> +---++--+
Well,
See the egg on face you get when using old technology.
I'll never use asbestos cutlery again,
and I'll upgrade myMySQL while I'm at it!!!
Thanks Paul, Dave
This brings ORDER to CHAOS!!!
Dave
(SoulScientist)
> -Original Message-
> From: Paul DuBois [mailto:[EMAIL PROTECTED]]
Did you try SQRT(id)? Should rank things the way you want if it's legal
(*_*)
-Original Message-
From: David Mackay [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 11, 2002 7:08 PM
To: 'David Turner'; David Mackay
Cc: '[EMAIL PROTECTED]'
Subject: RE: ORDER BY an ABSolute value
Thanks
If you set the interactive_timeout to infinite then no clients will get
disconnected until the server is restarted. I know the perl DBI allows for a
client to implement ping ($dbh->ping) ... this will reset the timeout for
that particular client, allow the client to check for connectivity, without
This would fail dramatically. The squareroot of a negative number is not
a real number.
Matthew Walker
Ecommerce Project Manager
Mountain Top Herbs
-Original Message-
From: Keith A. Calaman [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 11, 2002 5:24 PM
To: David Mackay; 'David Turn
dear friends..
i'm doing a simple script that use mysql_fetch_array() and it give me the
following error.
Warning: Supplied argument is not a valid MySQL result resource in
/apache/htdocs/html/intranet.domus.cl/base.php on line 10
Warning: Supplied argument is not a valid MySQL result resource
dear friends..
i'm doing a simple script that use mysql_fetch_array() and it give me the
following error.
Warning: Supplied argument is not a valid MySQL result resource in
/apache/htdocs/html/intranet.domus.cl/base.php on line 10
Warning: Supplied argument is not a valid MySQL result res
020206 15:11:47 mysqld started
/usr/pkg/libexec/mysqld: ready for connections
020207 1:02:00 Error in accept: Too many open files
020207 1:06:19 Error in accept: Too many open files
020207 1:10:37 Error in accept: Too many open files
020207 1:14:56 Error in accept: Too many open files
020
Hai ,
is there any support of sys_date in mysql which is strong feature in oracle
8.x . i am using MYSQL 3.23 server version .
With Warm Regards
[EMAIL PROTECTED]
JIN INformation Systems(P) Ltd
Voice : 5275300/5097603/5097604/5281822 ext 218
www.jinis.com
With Warm Regards
[EMAIL PROTECTED]
I have a site using PHP & Mysql. About a month ago to now one of the tables
gets corrupted with the message Got Error 127... I fix it and everything
works OK, except every time I loose 1 record.
Today I could obtain mysql.err from the machine and I could see whenever an
error is produced by date,
On Wed, Feb 06, 2002 at 08:04:23PM +0200, Sinisa Milivojevic wrote:
> Albert Chin writes:
> > On Wed, Feb 06, 2002 at 07:17:13PM +0200, Sinisa Milivojevic wrote:
> > Yes, SIZEOF_INT is 4:
> > $ grep SIZEOF_INT config.h
> > #define SIZEOF_INT 4
> > $ grep SIZEOF_INT include/my_config.h
> >
Ok, its not in count(distinct()). It always happends if temptables are used,
but only if the server
runs some minutes/hours/days :(
-Ursprüngliche Nachricht-
Von: Maverick [mailto:[EMAIL PROTECTED]]
Gesendet: Donnerstag, 7. Februar 2002 16:48
An: [EMAIL PROTECTED]
Betreff: bug in count(di
Whether or not the default table type is changed to InnoDB, in the
spirit of the original poster's question, and what I think Sinisa is
trying to get you to admit, transaction support is no longer one of the
issues to consider when comparing MySQL to PostgreSQL. MySQL supports
transactions *now*
Amendment to that last post
I don't think the daemon is starting properly, because I can't run a
mysqladmin version - I just get a hung cursor.
Does anyone know if there's something that would be stopping mysqld from
loading with the --skip-grant-tables option? When I do a ps I can see th
Hello, I have two tables in my database as such:
CREATE TABLE `skill_names` (
`id` bigint(20) NOT NULL auto_increment,
`name` varchar(30) NOT NULL default '',
PRIMARY KEY (`id`)
);
CREATE TABLE `skills` (
`skills_id` int(11) NOT NULL auto_increment,
`member_id` int(11) NOT NULL defaul
Hi.
You have to install DBI::DBD module.
Then in perl
use Mysql;
$dbh = Mysql->connect(undef,"database","username",'password');
$sql = "select blah from blah";
$sth = $dbh->query($sql);
@arr = $sth->fetchrow;
for example if the result is more than one line you have to loop it
Ofcoz there is ot
Albert Chin writes:
>
> $ grep SIZEOF_LONG config.h
> #define SIZEOF_LONG 8
> #define SIZEOF_LONG_LONG 8
>
> $ grep SIZEOF_LONG incldue/my_config.h
> #define SIZEOF_LONG 8
> #define SIZEOF_LONG_LONG 8
>
> --
> albert chin ([EMAIL PROTECTED])
>
If SIZEOF_INT is 4, then it could be our bug.
P
At 20:54 -0500 02/04/2002, I whispered:
>Hi all,
>
> A couple of weeks back you may remember that I was asking
>about setting up a new client on our server that ran around 35GB in
>bandwidth per month mostly from MySQL queries. Well, we have put
>them on our server and have good and bad
Hi ,
I am already using MySQL 3.23.26, which is available by Redhat LINUX 7.1
If I would like to update to newer version I found the following
What is MySQL-MAX.
RedHat packages (rpm)
MySQL 3.23.47 Server (i386) (1.4M)
where as ordinary MySQL
RedHat packages (rpm)
MySQL 3.23.47 Server (i386)
Work-around? LIKE should work just fine...
mysql> select * from fruits where fruit_name like '%banana%';
On Thu, 7 Feb 2002, Rutledge, Aaron wrote:
> I am trying to query the database for records that have the same
> sequence of starting characters--such as banana1 and banana2 and have a
> re
Sinisa Milivojevic <[EMAIL PROTECTED]> writes:
> Trond Eivind Glomsrød writes:
> > Sinisa Milivojevic <[EMAIL PROTECTED]> writes:
> >
> > There is a slight difference between advanced, non-standardized
> > tuning/backup/load-balancing like that and core SQL functionality not
> > being present.
>
Greetings:
I recently upgraded my MySQL server on a Linux box. When I try to start the server,
it says started, then immediately it stops.
The log file reports:
--
020206 14:38:35 mysqld started
/usr/local/libexec/mysqld: File './gumby-bin.1' not found (Errcode: 13)
020206 14:38:36 Could not
[redirecting to mysql list because of general interest]
Yoram Naim wrote:
> Can some one send me a code sample (C , CPP )
> How can I copy file data to MYSQL BLOB field
> but not in one piece .
Is this even possible? If so, I'm sure that the JDBC driver could use such
a feature to stream lar
Nick,
> I don't think ...
> Am I talking rubbish?
An admission and then an invitation??? Boy you must some masochist!
You asked a question, it was answered (and there's usually more than one way to skin
the proverbial cat); and
then you appear to argue.
"Thinking" is not as good as "testing":
I am in a windows 2000 environment. My level of experience is very low so
please be explicit. I am reviewing mySQL as a solution for multiple web
applications and CDROM applications.
I am trying to start the server for the first time using the command:
c:\mysql\bin>mysqld-max --standalone
Here i
I am trying to query the database for records that have the same
sequence of starting characters--such as banana1 and banana2 and have a
result set returned that contains everything that starts with banana.
Any way to do this? I think I would use LIKE in other types of
databases, but I was wonder
hello again,
still learning ...
i'm experiencing some unusual behaviors from the daemon. it stops
immediately.
[localhost:/usr/local/mysql] root# sudo ./bin/safe_mysqld --user=mysql &
[localhost:/usr/local/mysql] root# Starting mysqld daemon with databases
from /usr/local/mysql/data
020205 1
hello,
i tried to connect my MySQL-Server with a short java application. The
application can't connect to the server, obviously the server is running on
localhost:3306. I append the SourceCode (roughly the same:
http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:mss:80228:200107:popciohjmlbbolpak
) and th
Has anyone made a suggestion or thought about ways to distribute
databases which focus on fulltext indexes?
fulltext indexes do a good job of indexing a moderate amount of data,
but when you get a lot of data to be indexed, the queries slow down
significantly.
I have an example table, with about
Since PHP ignores whitespace, I think this is also acceptable:
$query = "CREATE TABLE query
tabledef for col a,
tabledef for col b,
lots more table defs,
.
welcome to line 400";
I have been using this technique and have not had any problems with it. If you echo
$query, it's all
on
Hi all
How can I take info from one table and print it into a txt file.
the table is (NAME)
and all the names in it I want to print out to a file name virtusertable.
Thanx
Christo
sql,query
-
Before posting, please c
>When I try to connect to the mysql server (mysql -u root -p ),
>I get an error about /tmp/mysql.sock.
>
>Anyway, what is the problem here? Do I have to take it down and start
>it up again? I'm pretty sure the problem is that the file has been
>deleted, probably a cron job, but I can't remember
I am using the following versions of mysql on suse linux 7.2:
frontend: mysql Ver 11.15 Distrib 3.23.47, for pc-linux-gnu (i686)
server: version 3.23.47
If I try to use the GRANT command I get
#mysql -u root mysql
mysql> GRANT ALL ON *.* TO root@localhost
-
Ye, that did the trick. I was able to get the daemon restarted using the
--skip-grant-tables & option, however now I can't connect to the
monitor. Typing in /usr/bin/mysql I just get a hung cursor. Same if I try
using /usr/bin/mysql -h hostname mysql
Anyone know why I can't get the monitor
jeremy,
Tuesday, February 05, 2002, 6:40:29 PM, you wrote:
jr> hello,
jr> i made the mistake of changing my root password manually in the mysql
jr> database. after doing so, i 'flushed privileges'.
jr> now i'm unable to log on using the root. i've tried to log on using the new
jr> password a
Cindy,
Tuesday, February 05, 2002, 11:58:45 PM, you wrote:
C> Sorry, I know this is documented somewhere, because I've seen it,
C> but I can't find it now, nor remember exactly what it said.
C> When I try to connect to the mysql server (mysql -u root -p ),
C> I get an error about /tmp/mysql.so
michael.s,
Wednesday, February 06, 2002, 12:22:15 PM, you wrote:
msÉ> Hi,
msÉ> I just installed mysql in my Solaris (Sparc) box, but
msÉ> when I run mysql ( mysqld running ), I get the following
msÉ> err, ld.so.1: bin/mysql: fatal: libncurses.so.5: open
msÉ> failed: No such file or dire
On Monday 11 February 2002 12:55 pm, Jeremy Zawodny wrote:
> The slave hit a duplicate key error and died. ?The IO thread appears
> to still be running, but the SQL thread is not. ?When I try to do a
> "SLAVE START" on the slave, the command never returns to the "mysql> "
> prompt.
Jeremy:
First
On Sunday 10 February 2002 06:06 pm, Jeremy Zawodny wrote:
> One question:
>
> ? Can you explain the relay log a bit. ?Does it shrink eventually? ?I
> ? see it growing and growing, so I don't know if the space is
> ? recycled, or if I need to do something to periodically flush the
> ? executed qu
MySQL doesn't support LIKE does it? I got an error when I tried. =20
-Original Message-
From: Nathan [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 07, 2002 1:04 PM
To: Rutledge, Aaron
Subject: Re: LIKE work around??
Um... keep using LIKE? Just a thought... :-)
- Original M
Trond Eivind Glomsr=F8d writes:
> Sinisa Milivojevic <[EMAIL PROTECTED]> writes:
>=20
> There is a slight difference between advanced, non-standardized
> tuning/backup/load-balancing like that and core SQL functionality not=
> being present.
>=20
> --=20
> Trond Eivind Glomsr=F8d
> Red Hat, Inc.
Heh. I keep getting answers, after all this time. See below for how I
solved it.
Background:
I had a 1.5 gig flatfile, consisting of all the data from two databases.
I had neglected to put 'use ' lines in it, so I couldn't
simply load it back into MySQL. I had to add one line at the beginning,
a
"Rutledge, Aaron" writes:
>MySQL doesn't support LIKE does it? I got an error when I tried.
I use it all the time. Maybe post the error message you got.
RLIKE on the other hand
--Cindy
-
Before posting, please check:
At 4:22 +0800 2/7/02, yue cheng wrote:
>Hi,
>
>Now I am puzzled by the filepath,Load_file, I install
>MySQL in Windows98, the file which i want to insert to
>table is c:\P1.bmp
>
>when I run load_file in mysql command line,it succeeds
>mysql> insert into blobtable (load_file("/P1.bmp"))
>but i don
There is no limit on the size of strings in PHP. Follow this link for more
info:
http://www.php.net/manual/en/language.types.string.php
Brett
Original Message Follows
From: "savaidis" <[EMAIL PROTECTED]>
To: "'Johnny Withers'" <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]>
Subject: RE: long
Think of the binary log as just a long binary data stream, which simply
happens to be in a series of files. Each slave has a position in that
binary stream, which is expressed as a filename and file position.
Each slave has (potentially) a different position in the stream, and
therefore a differ
Hello,
I am new to MySql. I have MySql installed in my Linux PC. How do I connect
to MySql using Perl script and assign the result of a query to an array?
Where could I find a sample code? Thank you.
Andy
_
Get your FREE dow
First off, you trying to insert the image into the database or just its
path?
-Original Message-
From: yue cheng [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 06, 2002 2:23 PM
To: [EMAIL PROTECTED]
Subject: Load_File issue
Hi,
Now I am puzzled by the filepath,Load_file, I inst
I second the question. It could also reduce the size of the
fulltext index and the time taken to update it.
-steve
> On Thursday 07 February 2002 20:53, Brian wrote:
> > Has anyone made a suggestion or thought about ways to distribute
> > databases which focus on fulltext indexes?
> >
> > ful
Hi Bob,
> Hi, I currently have a very large MS SQL7 database that I need to put on the
> web. My plan is to use PHP and MySQL to accomplish this. Currently I have a
> Visual Basic front end on the MS SQL7 Server. I would like to have my VB
> program write The MS SQL7 server data to a MYSql databa
Hi!
>From http://www.innodb.com/ibman.html :
MySQL/InnoDB-3.23.44, November 2, 2001
You can define foreign key constraints on InnoDB tables. An example: FOREIGN
KEY (col1) REFERENCES table2(col2).
You can create > 4 GB data files in those file systems that allow it.
Thus > 4 G files
MYSQL
sql,query
is anybody know when suppost to be support to views ?
|\_.._/|
| o o |
(=T=)
^'-^-'^.
'. ; .'
| | | | |
((_((|))_))
Best Regards from the Cat
Noam Cassif([EMAIL PROTECTED])
Raz Systems LTD
http://www.raz.co.il
--
I have a column of amounts that was getting adding in a loop but I see
there's a sum() function to do this. Should have known. But I can't
make it work. Can someone give me a simple query syntax using php?
TIA
Floyd
--
--
On Thu, 7 Feb 2002 19:54:51 -0600, you wrote:
>At 19:53 -0500 2/7/02, Floyd Baker wrote:
>>I have a column of amounts that was getting adding in a loop but I see
>>there's a sum() function to do this. Should have known. But I can't
>>make it work. Can someone give me a simple query syntax usi
I would like to authenticate my IntrAnet users against our Microsoft Active
Directory database. Has someone done this before?
How would I connect MySQL to the AD?
Thanks
-Allen
---
[This E-mail has been scanned for viruses and is clean]
---
hi,
I have two tables as :
please concentrate on domain_id and INDEX
Create table ls_domain
( domain_id INT(4) UNSIGNED AUTO_INCREMENT ,
domain_addr VARCHAR(80),
domain_name CHAR(50) UNIQUE KEY,
domain_port INT(6) UNSIGNED,
domain_ip VARCHAR(15),
created_by VARCHAR(40),
created_date
Noam,
Wednesday, February 06, 2002, 11:37:13 AM, you wrote:
NC> MYSQL
NC> sql,query
NC> is anybody know when suppost to be support to views ?
It will be sopported in MySQL around Version 4.1
See at: http://www.mysql.com/doc/A/N/ANSI_diff_Views.html
NC> Noam Cassif([EMAIL PROTECTED])
NC> Raz Sy
Hi,
I just installed mysql in my Solaris (Sparc) box, but when I run mysql
( mysqld running ), I get the following err,
ld.so.1: bin/mysql: fatal: libncurses.so.5: open failed: No such file
or directory
Killed
Any help will be appreciated!
---
On Thu, 7 Feb 2002 21:07:44 -0600, you wrote:
>At 21:28 -0500 2/7/02, Floyd Baker wrote:
>>On Thu, 7 Feb 2002 19:54:51 -0600, you wrote:
>>
>>>At 19:53 -0500 2/7/02, Floyd Baker wrote:
I have a column of amounts that was getting adding in a loop but I see
there's a sum() function to do th
Hi,
An int datatype takes 4 bytes and a bigint 8 bytes. . Since there is an index
created with bigint it will take an additional 8 bytes for the data and
some more
bytes for the pointer to the table rows. Thus a bare minimum
of 20+ bytes is consumed corresponding to a row of data. A billion recor
Hi Again,
I have honed this question pretty well I think (MySQL 3.23.37):
I am using large-my.cnf as my my.cnf file. It is for servers with 512
MB of RAM from what I read. On our server that has 512MB of RAM I
notice in top the following:
10244 mysql 16 0 147M 147M 1684 S
Dear list,
I have a telephone database which has "Name" as one of the fields/columns.
This field contains single name e.g Robert, double names e.g Robert
Downing and more than double names. I want to make a SELECT query using a
form whose input name is "Name" i.e '$Name' against the "Name" fie
Hi,
I have some text file (10MB per day) might be keep for a year. I have
been keep it in compress format (using WinZip). When I need to see detail
I have been open it and find something I want to see. If I decide to store
these text file in to BLOB field of MySQL. How do you thing
Umm, I take it you haven't read the documentation? MySQL fully supports
LIKE. Can you tell us the error you are getting? Along with the full query?
j- k-
On Thursday 07 February 2002 11:11, Rutledge, Aaron wrote:
> MySQL doesn't support LIKE does it? I got an error when I tried.
--
On Thu, 7 Feb 2002 22:09:18 -0600, you wrote:
>At 22:58 -0500 2/7/02, Floyd Baker wrote:
>>On Thu, 7 Feb 2002 21:07:44 -0600, you wrote:
>>
>>>At 21:28 -0500 2/7/02, Floyd Baker wrote:
On Thu, 7 Feb 2002 19:54:51 -0600, you wrote:
>At 19:53 -0500 2/7/02, Floyd Baker wrote:
>>I ha
> in Mysql, under sql, we have the function PASSWORD('mypasswd') where we
> can encrpt
> 'mypasswd' into a 16 character scrambled word.
> which function in sql is used to decrypt the same and get back the
> original mypasswd.
There is no such feature. PASSWORD like other hash passwords are one w
MySQL folks,
I am planning on using MySQL replication to mirror a database at
various far-flung locations. I'm anticipating that there might be a
handful of slaves, but they will only come on every few months. In
that scenario, the last slave will have a lot of catching up to do if
all slaves are
i have what is basically a personal ad database.
in one table, i have a list of advertisers. in another table i have a list
of reviews. (there's a third table with stuff like their name, address,
etc). i want to get a list of advertisers and the number of reviews all in
one query. i can do
On Sunday 10 February 2002 01:17 am, you wrote:
> I can't get it to start replicating.
>
> Note, the master (db1.tias.com) is a 3.23 server. The slave is 4.0.2
> (noritake.tias.com).
>
> On the master I get:
>
> mysql> show master status;
> +---++--+
On Thu, 2002-02-07 at 15:40, Tod Harter wrote:
[snip]
> Wouldn't be too tough to write a little query routing system if you are using
> perl. Use DBD::Proxy on the web server side, and just hack the perl proxy
> server so it routes the query to several places and returns a single result
> set.
Hello again,
In reply to all the suggestions made, here it goes one more mail. I hope it
will be helpful.
(André, isto vai em ingles que é para o pessoal perceber ;)
Suggestion 1:
>Float aren't really searchable in Mysql. You may need to do some casting,
>not sure how to do it on top but i re
Hi. I have been awayv for a while. I see that 3.23 is still listed as the
current distribution version. When might one expect that 4.X will be released
as a production version?
MySQL, versions
-
Before posting, please c
On Mon, Feb 11, 2002 at 04:48:10PM -0600, David Felio wrote:
> Whoops, originally sent this to just Heikki.
>
> On Monday, February 11, 2002, at 12:12 PM, Heikki Tuuri wrote:
>
>> for InnoDB 'dynamic rows', that is, rows where you define char columns as
>> VARCHAR, are faster because tables and
Hi there,
I have installed MySQL 3.23.37-sun-solaris2.7-sparc.
Some times the server starts and when i try to connect it using my
password it hangs. It doesn't allow me in. Neither does it say anything
about the password or about the connection.
How do i solve this.
This is the second time it is
Also, I have to ask the question:
Why is it that Altavista can index terabytes overnight and return
a fulltext boolean for the WHOLE WEB
within a second, and Mysql takes so long?
On Friday 08 February 2002 11:50, Steve Rapaport wrote:
> I second the question. It could also reduce the size
On Wed, Feb 06, 2002 at 06:49:02PM +0200, Sinisa Milivojevic wrote:
> Trond Eivind Glomsrød writes:
> > "Vernon A Webb" <[EMAIL PROTECTED]> writes:
> >
> > > Anyone know the difference between MySQL and PostgreSQL?
> >
> > PostgreSQL has a lot of features MySQL don't have yet (transactions
> >
At 22:58 -0500 2/7/02, Floyd Baker wrote:
>On Thu, 7 Feb 2002 21:07:44 -0600, you wrote:
>
>>At 21:28 -0500 2/7/02, Floyd Baker wrote:
>>>On Thu, 7 Feb 2002 19:54:51 -0600, you wrote:
>>>
At 19:53 -0500 2/7/02, Floyd Baker wrote:
>I have a column of amounts that was getting adding in a loo
> input is >SELECT dog_name FROM hold_tbl WHERE dog_name RLIKE "^sam[0123456789]*"
> ORDER BY dog_name<
>
> (and then printing out each of the matches made)
> Sam
> Sam4
> Sam5
> Sammie6
> Sammy7
> Sampson2
> Samson
> Samuel
>
> As I understand it, only the first three should have match
1 - 100 of 124 matches
Mail list logo
