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!
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]
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?
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
relevance0 ORDER BY relevance DESC
I didn't
-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 get
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:
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 (detailannonce)
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
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
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
the
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
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 gone! Where
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-valid
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
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
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
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
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
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
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
#define
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
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
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
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
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 other ways
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.
Please let
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 news.
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
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
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.
This depends
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 gumby.err reports:
--
020206 14:38:35 mysqld started
/usr/local/libexec/mysqld: File './gumby-bin.1' not found (Errcode: 13)
020206 14:38:36
[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 large
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
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
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
When I try to connect to the mysql server (mysql -u root -p table),
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 table),
C I get an error about
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
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, do
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 queries
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
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.
=20
This
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 database' lines in it, so I couldn't
simply load it back into MySQL. I had to add one line at the
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...sigh.
--Cindy
-
Before posting, please
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't know why
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 query on
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
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
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
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?
fulltext
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 database
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 using
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
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 this. Should
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
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 field in
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 have a column of amounts
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 way
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
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
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
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
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 indexes
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
everywhere,
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 loop but I see
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 matched.
Actually, as
Just a comment:
Doing so it's possible to insert a line between $query.. statements.
(comments ecc) Its very simple to write it with copy+paste and I prefer
this.
Thanks.
PS. I'll check the string limit and I let you know. I think it has to be the
64KB.
I think only Visual Basic has this
(MySQL 4.0.1-alpha-Max-log, your Linux binary)
The following works fine (just a slight variation of what is in the manual):
CREATE TABLE t1 (
id INT UNSIGNED NOT NULL AUTO_INCREMENT,
PRIMARY KEY (id)
) TYPE=InnoDB;
CREATE TABLE t2 (
id INT UNSIGNED NOT NULL AUTO_INCREMENT,
At 16:17 -0800 2/6/02, Richard Reina wrote:
I am trying to trim both leading and trailing whitespace from a TEXT
column in my SELECT query. I found the TRIM() command in the
manual, however, I can't get it to act upon a column name instead of
an actual string. Can anyone help?
If you just
Demirchyan,
Thursday, February 07, 2002, 8:39:05 PM, you wrote:
DOA There used to be a section in mysql documentation, which explained about all the
DOA entries in my.ini file. Do you know what happened to it?
DOA There is a part about my.cnf but that's not what I want. There was more.
Hi Prabhu,
Select cols from tbl where datecolumn date_add(datevar, interval 1 day);
A look at Date and time functions of the manual would do good.
But you originally asked about sys_date (is it not sysdate pseudocolumn).
Regards,
Anvar
At 04:49 PM 07/02/2002 +0530, you wrote:
i am asking
Yesterday, from Nathan:
Since PHP ignores whitespace, I think this is also acceptable:
PHP doesn't ignore whitespace in a quote. But your code is of course
correct.
$query = CREATE TABLE query
tabledef for col a,
tabledef for col b,
lots more table defs,
.
welcome to line
1 - 100 of 116 matches
Mail list logo
