/sourceview.aspx?source_id=6332
=
David L. Corsaut
[EMAIL PROTECTED]
mobile: 206.790.0969
__
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com
Ryan Henderson
Computer Programmer
Multimedia Centre, Faculty of Arts, University
to correctly
identify the purpose, but hopefully this information will guide you in
the right direction.
Thanks,
Ryan Yagatich
On Sun, 2003-06-22 at 12:40, Namor Taror wrote:
I just created a table with some char columns (I am using Control Center).
Every time I save the table (during
field won't be displayed in the output.
I think that will work,
Ryan
__
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
-disconnect || die Failed to disconnect\n;
pls help me .
Thanx
chandana
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
--
,_,
\ Ryan
mysql or flush the
privilages.
Not sure if that will even work but it might work for a temp fix.
Ryan
--- Rudy Metzger [EMAIL PROTECTED] wrote:
Dear all,
Is there a way to start mysqld in a way, that say only a superuser can
connect. I would need this e.g. for restoring a backup, because I do
checkno (checkno),
KEY mirr_isdeleted (mirr_isdeleted),
KEY socialsec (socialsec),
KEY webm_entityid (webm_entityid)
) TYPE=MyISAM;
Which Scenario in your opinion, is better and why?
-Ryan.
On Tuesday 17 June 2003 03:35 am, George Chelidze wrote:
Hello,
I have two RH boxes with mysql on them and replication is enabled from
box 1 to box 2 and from box 2 to box 1. The amount of data on each of
them is round 400-500MB. Now I have to replace one of them with new box.
As both boxes
above are not mysql issues but php issues. This email
was sent to the mysql lists.
Steve
Thanks,
Ryan Yagatich
--
,_,
\ Ryan Yagatich [EMAIL PROTECTED] \
/ Pantek Incorporated (877) LINUX-FIX /
\ http
. For example, say your username is 'ryan'
SELECT games.cGameName
FROM games
LEFT JOIN usersGamesLink ON (usersGamesLink.iGameID=games.iGameID)
LEFT JOIN users ON (users.iUserID=usersGamesLink.iUserID)
WHERE users.cUsername='ryan';
There are more ways to adjust that query based on your intentions, so
all about what data you are
retrieving and what you want to do with it. In short, yes 2 program
functions are more efficient than 2 sql queries iff the amount of
resources required for the database to process outweigh that of the
application.
Thanks,
Ryan Yagatich
On Mon, 2003-06-16 at 16:32
. :)
If, OTOH, the query actually does take 3 secs to run, start by running
'explain select * ...', which will tell you how the query is being processed.
More info in optimizing queries can be found at
http://www.mysql.com/doc/en/Query_Speed.html .
Ryan
--
MySQL General Mailing List
For list archives
snip
Here is the query I'd like to run (which fails - but is exactly what I need
for a query):
select sum(count(host)) from TABLE_HOST where path_a='' group by host
/snip
well I think this one fails because count only ever returns one number
(correct?). So I would think sum would take in a
,member,relationship where member.name='Joe Bar'
and relationship.group_id=group.id and relationship.member_id=member.id;
Ryan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Couldn't something like this work?
SELECT id,foo,bar FROM tbl ORDER BY id DESC LIMIT 1
Thanks,
Ryan Yagatich
,_,
\ Ryan Yagatich [EMAIL PROTECTED] \
/ Pantek Incorporated (877) LINUX-FIX /
\ http
I believe the package you are looking for is
zlib-devel
The latest version from redhat is available at
http://updates.redhat.com/8.0/en/os/i386/zlib-devel-1.1.4-8.8x.i386.rpm
Thanks,
Ryan Yagatich
,_,
\ Ryan Yagatich
Short answer is mysql does not do sub-selects (i.e., a select inside of a
select). The join part is not this issue.
Wouldn't this depend on the version... I thought the newest versions, 4.x+,
supported sub-selects.
Ryan
__
Do you Yahoo!?
Yahoo! Calendar - Free
After running:
./configure --prefix=/usr/local/mysql
I get the error:
checking for termcap functions library... configure: error: No curses/termcap library
found
What specific library am I missing? Thanks in advance for your help!
--
MySQL General Mailing List
For list archives:
Nevermind, found it
libtermcap-devel
-Original Message-
From: Cassily, Ryan
Sent: Thursday, May 29, 2003 5:14 PM
To: MySQL (E-mail)
Subject: configure question
After running:
./configure --prefix=/usr/local/mysql
I get the error:
checking for termcap functions library... configure
I made the mistake of copying the MYI, MYD, and frm files of a table while the mysql
server was running. Unfortunately the table is now reporting the following error:
./mysqlshow: Cannot list columns in db: rt2, table: Keywords: Incorrect information in
file: 'Table.frm'
What is the easiest
index 2
- Fixing index 3
- Fixing index 4
./mysqlshow: Cannot list columns in db: rt2, table: Keywords: Incorrect
information in file: 'Table.frm'
-Original Message-
From: Joe Stump [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 28, 2003 2:03 PM
To: Cassily, Ryan; MySQL (E-mail)
Subject: RE
.
Please help, thanx
Ryan
__
Do you Yahoo!?
Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop!
http://platinum.yahoo.com
-
Before posting, please check:
http
On Wednesday 19 March 2003 12:31 pm, Tab Alleman wrote:
I am using the following command, following the only example I could
find in the documentation (mysql prompt shown for clarity):
mysql mysql u:/db backup 20030318/cm_central.sql;
Run this from a command line, not the mysql client.
Ryan
to
get
this right now before it gets bigger.
Andrew
Well you're gonna need to describe things a little better. Saying you need help
with a query with out posting it or the table descriptions isn't going to do
anyone any good.
Ryan
__
Do you Yahoo
mysqld.log, so maybe its in there.
HTH,
Ryan
__
Do you Yahoo!?
Yahoo! Tax Center - forms, calculators, tips, more
http://taxes.yahoo.com/
-
Before posting, please check:
http
correct me.
Thanx,
Ryan
__
Do you Yahoo!?
Yahoo! Tax Center - forms, calculators, tips, more
http://taxes.yahoo.com/
-
Before posting, please check:
http://www.mysql.com/manual.php
if I'm wrong... I've never done a binary install. I've
only installed MySQL at the time of my RH8.0 install.
HTH HIR(hope i'm right),
Ryan
__
Do you Yahoo!?
Yahoo! Tax Center - forms, calculators, tips, more
http://taxes.yahoo.com
). There are ways to get around doing sub-selects but I
don't what they are.
Please someone correct me if I'm wrong
HTH,
Ryan
__
Do you Yahoo!?
Yahoo! Tax Center - forms, calculators, tips, more
http://taxes.yahoo.com
the existing
systems in the market are using this 2 type of database?
OSSuite, for one, is ERP using MySQL.
http://www.ossute.org
Sorry for the on-topic advertisement. :)
Ryan
-
Before posting, please check:
http
*
IdNum FName LName
1 Ryan McDougall
This is my code so far, be prepared to laugh as this is pretty bad code I'm
sure (I just don't want to be held liable for any injuries from falling out of
your chairs :-P ):
html
headtitleMy PHP test file/title/head
body
?php
that isn't there please let me know and I will post whatever information
is needed to fix it.
TIA,
Ryan
__
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
Hey everyone,
Thank you all for your quick responses and the problem was that I did not have
mysql support installed for php... installed the required rpm and did a httpd
restart and it wrks now!!
Thanx again,
Ryan
__
Do you Yahoo!?
Yahoo! Mail
EST 2003
[root@sql2 /root]#
Can anyone help?
Thanks!
- Ryan
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e
() |
+-+
| 2003-01-14 17:41:20 |
+-+
1 row in set (0.00 sec)
mysql quit
Bye
[root@sql2 /root]# date
Tue Jan 14 12:41:32 EST 2003
[root@sql2 /root]#
Can anyone help?
Thanks!
- Ryan
-
Before posting, please check
you GRANT the user whatever privs you wantt hem to have, I think the
only one they NEED to have is CREATE and then user will get to create any DB
as long as it starts with their username, like userDB2.
And please if anyone sees that I have messed up any thing in this please
correct me.
HTH,
Ryan
I understand the SQL statement in MySQL to be SELECT sum(column name) FROM table;
but I would like to get a SUM of multiple columns. Is this possible??
Thanks,
Ryan
-
Before posting, please check:
http://www.mysql.com
--- Adolfo Bello [EMAIL PROTECTED] wrote:
As far as I know and how I understand it, the relationships are basically
all
in your head... You just have to coordinate it in your queries and other
functions
This is not true. Fot type innodb tables, you can define REFERENCES
using ON DELETE
Taking a blind stab, how about..
SELECT a.name, minimum(0,COUNT(b.id)) as votes FROM poll_options as a LEFT
JOIN poll_votes as b on a.id=b.oid
WHERE b.pid='poll_id' GROUP BY b.oid
Ryan Fox
- Original Message -
From: Blaster [EMAIL PROTECTED]
However! Here comes the problem, if no vote
--- Octavian Rasnita [EMAIL PROTECTED] wrote:
Hi all,
Is MySQL able (like MS Access) to define permanent relations between tables?
For example, I want to define a master - child relation between 2 tables so
when deleting some entries from the master table to automaticly delete the
entries
* FROM Students WHERE concat(LastName, , , FirstName) LIKE 'Smith,
J%';
Ryan Fox
sql, query, sausage
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list
- Original Message -
From: Octavian Rasnita [EMAIL PROTECTED]
mysql create table aaa(id int not null unsigned, name text);
Can you tell me why doesn't it work?
You want:
create table aaa(id int unsigned not null, name text);
Your way doesn't work as 'unsigned' is a modification of
, Homolog_PID)
);
This would make your example query:
select count(*) from NewSequence s left join NewSequence_Homolog h on s.id =
h.id;
And this would run much quicker, as instead of searching through 50
character indexes for each table, it would only have to look at 11 digit
indexes. Much quicker.
Ryan
.
Hope that helps and sorry if it was too elementary, I had a REAL hard time
getting this and this was the way I finally got it.
L8R,
Ryan
--- [EMAIL PROTECTED] wrote:
I wish to attempt to clarify one of my earlier questions:
Most things I've read say to establish a mysql user -I take
... ERRO 1064: You have an error in
you SQL syntax near 'usre%.* To user@% IDENTIFIED BY password at line 2
Any help would be appreciated.
TIA,
Ryan
--- Paul DuBois [EMAIL PROTECTED] wrote:
At 9:25 -0800 12/8/02, Ryan McDougall wrote:
Hi thanx for the details... Ok I know I am thick
on this and stupidity, but my
brain just will not wrap itself around this issue.
Thanx for all the help so far,
Ryan McDougall
--- Stefan Hinz, iConnect (Berlin) [EMAIL PROTECTED] wrote:
Dear Ryan,
have a look at the manual:
http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Database_Adm
Hey everyone,
Ok if I issue this command:
mysql grant select,insert,update,delete,create,drop
- on *.* to someusr@% identified by 'passwrd';
I already know that this statement creates the user someusr w/ password=passwrd
and it can connect from anywhere. What I don't know: Can this user now
=5;
or, as left joins:
select a.name, b.name, c.name from yourtable as c left join yourtable as a
on a.uid=c.rootid left join yourtable as b on b.uid=c.parentid where uid=5;
Ryan
sql to the hizzo
query to the hizza
-
Before
of the BLOB data-type and it will
still accept it.
Perhaps MySQL should output an error or at least a warning to know the
string is too long.
Thanks much,
-Ryan Hatch
-
Before posting, please check:
http://www.mysql.com
The environment info was copied from the mysqlbug command by our external
hosting company who truncated the lines therefore the last couple of
characters from each line is not there however it was a Solaris 2.8 binary
download of 4.0.5beta so you would have all of the info anyway.
Description:
The MySQL Manual states the following in the LOAD DATA INFILE section :-
If a filename with no leading components is given, the server looks for the file in
the database directory of the current database.
-Original Message-
From: John Connolly [mailto:[EMAIL PROTECTED]]
Sent: 28
Hi everyone,
Please pardon my extreme case of the NEWBs on this but I need some help please.
Ok I just purchased a book to hopefully clear things up for me, but to no
avail. So this is my dilemma: I want to know about MySQL administration,
specifically the user management portion of the admining.
know what this means ?
Thanks,
Michael Ryan
BBCi at http://www.bbc.co.uk/
This e-mail (and any attachments) is confidential and may contain
personal views which are not the views of the BBC unless specifically
stated.
If you have received it in error, please delete it from your system, do
...
Ryan
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED
the data to a second location,
but it is not necessary.
SQL
Ryan
Another way we could increase load times
would be to use 4 scripts to load data from 4 tables at once. We have the
bandwith to handle that and the MySQL box seems to be handling request
just
fine at 11,000 inserts its still
- Original Message -
From: Damien Buttler [EMAIL PROTECTED]
I hope someone can help. I have written a PHP script which adds a row to
a
MySQL table. The columns are all of type 'char'. The script works fine
when only numerical values are passed, but when I try to pass values a-z
A-Z
Ryan
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL
insert. Is this
a 4.0.2alpha feature and is fixed in later versions or is the way it was meant
to work in which case the documentation might need a little re-wording.
Regards,
Michael Ryan
__
Do You Yahoo!?
Everything you'll ever need on one web page
of the functions enabled...
As far as MySql, it also is pretty straight forward... I had no problems
doing this last night :)
--
Ryan Frank
A system admin's life is a sorry one. The only advantage he has
over Emergency Room doctors is that malpractice suits are rare. On
the other hand, ER doctors never
I will begining to install mysql on my server in a few days. I have never
done this before. Is there anything i need to know, any problems mysql has
with 2000 server? Any help is appreciated.
Ryan
-
Before posting, please
grant for every user?
Adam
-Original Message-
From: Lucas Saud [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 27, 2002 9:45 AM
To: Adam Ryan
Cc: [EMAIL PROTECTED]
Subject: RE: Allowing a whole class C to access mysql server?
Importance: High
hi,
How can I get this to allow access
PROTECTED]]
Sent: Sunday, August 25, 2002 6:58 PM
To: Adam Ryan
Cc: [EMAIL PROTECTED]
Subject: Re: Allowing a whole class C to access mysql server?
GRANT SELECT ON db.* TO user@'192.168.1.0/255.255.255.0'
should do the trick: you just specify the IP you want to allow and the
netmask to apply
Hi,
I am trying to have a whole class C access the mysql server on the
network. The class C needs to access many different database names. So
adding an entry for each Ip address wouldn't work. Does anyone know how
I can go about this?
Thanks,
Adam
search in 4.0.2 are great tho, thanks to whoever!
SQL AND QUERY .. rock out filter!
-ryan
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive
this helps,
Ryan Fox
[EMAIL PROTECTED]
On Thu, 2002-07-18 at 11:44, Richard Fox wrote:
The mysqld.log file says:
020717 13:05:05 mysqld started
020717 13:05:05 /usr/local/libexec/mysqld: Can't find file:
'./mysql/host.frm' (errno: 13)
020717 13:05:05 mysqld ended
But I do see
relavent:
/* Define as the base type of the last arg to accept */
#define SOCKET_SIZE_TYPE int
/* Last argument to get/setsockopt */
/* #undef SOCKOPT_OPTLEN_TYPE */
Any suggestions?
Ryan
-
Before posting, please check:
http
%2540FreeBSD.csie.NCTU.edu.tw%26rnum%3D5
(geedang thats one long url)
-ryan
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e
or
something very similar.
Please advise.
I appreciate everyone's time and help... much thanks in advance.
Regards,
-Ryan Hatch
Database Administrator
HiTech Enterprises, Inc.
825 Ontario Road
Green Bay, WI 54311
(920) 465-4600
Hi,
We have two major concerns with the full-text search in MySQL. They appear
to be simple problems that can be fixed. We are about to use MySQL in a big
way, and we would like to license it, however these problems are a major
obstacle that must be fixed (or at least understood).
1) Using the
Thanks Philip, I spent some time looking for that list, but obviously
didn't look hard enuf.
Ryan
2) Why would these sample words have no match?
Cannot match against when, most, like, goes Why are these
words not in the index? The file contains 1 million title records
and all
select count(*) from myTable where sal 1000;
Ryan Sander
Web Developer
[EMAIL PROTECTED]
http://cantonrep.com
--
From: [EMAIL PROTECTED]
Sent: Thursday, May 30, 2002 2:24 PM
To: [EMAIL PROTECTED]
Subject: count...I think
Hey guys,
I have a very simple
please let us know the SQL query you are trying, and a DESCRIBE TABLENAME so we can
see how your table(s) are laid out. also, please tell us what you actually changed
in your my.cnf file
by the way, before you can do transactions, you must set the AUTOCOMMIT variable to
0
-Ryan Hatch
( ' ), it will
screw up your SQL statement. make sure you run all your variables through a filter
to check for single quotes. either backslash them out ( \ ) or prevent your users
from using them.
-Ryan Hatch
Sven Bentlage wrote:
Hi everyone!
Are there any limitations on update queries, like on how many
yes, you needed to use the PASSWORD( ) function
mysqladmin -h hostname -u user password 'new password'
-Ryan Hatch
Miretsky, Anya wrote:
I tried to create a password for the root user in a new installation of
MySQL by typing
% mysql -u root mysql
Then typing and update statement like
you're not making much sense to me
in your first post... you wanted make sure every IP you have is unique, correct?
Do an ALTER TABLE with UNIQUE(octet1, octet2, octet3, octet4).
or am I not understanding your question?
Regards,
-Ryan Hatch
* remember me? yesterday #php on DALNet, G3X7
are you familiar with the different MySQL table types?
they are:
MyISAM
BDB
Gemini
InnoDB
but InnoDB is the most robust, supports row-level locking, ACID transactions (no dirty
reads), and foreign key restraints... read up on it here: http://www.innodb.com
but InnoDB does
I have been receiving this same error message every time I post.
?? anybody?
Todd Cary wrote:
I am receiving this message from MySQL:
+++
Sorry. Your message could not be delivered to:
w3d3demo (Mailbox or Conference is full.)
+++
What am I missing?
Todd
--
Dr. Todd Cary
Ariste Software
,
-Ryan Hatch
---
Steve Buehler wrote:
What makes you think that it is an imposter site? They both have the
same IP address, they are both the same site.
# nslookup mysql.org
Name:mysql.org
Address: 64.28.67.70
# nslookup mysql.com
Name
I think you have to use a forward slash in your path instead of a backslash.
C:/ as opposed to C:\
even in windows operating environments I believe you need to use /.
-Original Message-
From: ali hafiz [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 09, 2002 2:23 PM
To: [EMAIL
bd...
Two things here:
1.) Mysql.org is an IMPOSTER's site. www.MySQL.com is the real site.
and
2.) You haven't given us the warning / error message you received.
-Ryan Hatch
[EMAIL PROTECTED] wrote:
I just created a database and tried to LOAD 1 line of data from a text file.
I have
tested this.
The information can be found in section 2.6.2.7 of the html documents that
come with the download.
-Original Message-
From: Matthew Walker [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 09, 2002 3:24 PM
To: Bob Ryan; ali hafiz; [EMAIL PROTECTED]; [EMAIL PROTECTED];
[EMAIL
, etc. that you guys could
provide.
Much thanks!
-Ryan Hatch
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail
;
++
| least(count(*),30) |
++
| 30 |
++
1 row in set (0.00 sec)
mysql select count(*) from ct;
+--+
| count(*) |
+--+
| 43 |
+--+
1 row in set (0.00 sec)
Cheers,
Ryan Fox, Geek email: [EMAIL PROTECTED
efficiently) use the
index to return the number of rows.
Cheers,
Ryan Fox, Geek email: [EMAIL PROTECTED]
BackWatcher, Inc. web: http://backwatcher.com
-
Before posting, please check:
http://www.mysql.com/manual.php
know if this could/should work? (Don't have a
mysql server here to test this w/ at the moment, so your input would be
appreciated.)
If I'm way off on this, I'd really appreciate any pointers in the right
direction..
Thanks!
Ryan
So I do:
SELECT * FROM table1 WHERE datum BETWEEN ('-00-00' + INTERVAL 1 DAY)
AND '2002-03-10';
MySQL returns an empty result set, but it shouldn't (the table contains
dates year 2000 and up.
MySQL refers to the date -00-00 as null. Null+1 is null. Why don't you
rewrite the query as
by MySQL-bench-3.23.48-1
Thanks in advance,
Ryan
_
Send and receive Hotmail on your mobile device: http://mobile.msn.com
-
Before posting, please check:
http
Yes.
Dumb question. You did install the OS X developer tools, yes?
I just compiled 3.23.47 from source this morning on 10.1.2 with not a
problem at all.
--
John McCauley
CTGi
Oakton, VA
703-352-0590
http://www.ctgusa.com
From: Ryan Walker [EMAIL PROTECTED]
Date: Tue, 29 Jan 2002 18:40:12
-352-0590
http://www.ctgusa.com
From: Ryan Walker [EMAIL PROTECTED]
Date: Wed, 30 Jan 2002 00:21:44 -0800
To: [EMAIL PROTECTED]
Subject: Re: MySQL compile error, mysql-3.23.47, Mac OS X 10.1.2
Yes.
Dumb question. You did install the OS X developer tools, yes?
I just compiled 3.23.47 from
suggestions?
Ryan
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
be A Bad Thing.
I wouldn't be terribly opposed to having an option to be set to allow this,
but it shouldn't be on by default, and most MySQL users who can read the
manual and find the option to do this should already know why this is a bad
thing and not want to use it.
Ryan
is mysqld-max, and the argument to the
command is --standalone.
Ryan
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e
I'm running ok on my Dual PII machine, if this helps anyone.
Redhat 7.1, 2.4.2-SGI_XFS kernel, MySQL 3.23.43.
[root@willyjr /root]# uptime
1:07pm up 95 days, 4:08, 1 user, load average: 0.08, 0.04, 0.01
[root@willyjr /root]# cat /etc/redhat-release
Red Hat Linux release 7.1 (Seawolf)
Check out select into outfile.
http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#SEL
ECT
Ryan
- Original Message -
From: Cindy Yu [EMAIL PROTECTED]
I am new to mysql. I know, in Oracle, when you spool file, then spool off,
this will create a file on your server
would be greatly appreciated! Thanks.
--
Ryan
[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e
, i can send the
.err file.
How-To-Repeat:
from /usr/local/mysql bin/safe_mysql
Fix:
Submitter-Id: submitter ID
Originator:ryan reynolds
Organization:
MySQL support: [none | licence | email support | extended email support ]
Synopsis: RH7.2 GCC2.95.3 CRASHES AFTER
, a better solution is to change the user's
password to a random string, then e-mail the user their new password.
Hope this helps,
Ryan Fox
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http
search a numeric field, which of course is faster.
Ryan
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail
- Original Message -
From: Colin Hill [EMAIL PROTECTED]
So, is there a way to retrieve the version information directly from the
server using some pseudo SQL query?
show variables like 'version';
Ryan Fox
-
Before
than MySQL easily.
Hope this helps,
Ryan Fox
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED
.
ROUND(X,D)
Returns the argument X, rounded to a number with D decimals. If D is 0, the
result will have no decimal point or fractional part:
Also, From the mailing list:
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
Ryan Fox
- Original Message -
From
Hmmm. That's a pretty generic statement. There are lots of different ways
to get information from a database. Need more info.
Ryan Sander
Web Developer
[EMAIL PROTECTED]
http://www.cantonrep.com
--
From: sunil nair
Sent: Wednesday, November 28, 2001 8:20 AM
201 - 300 of 367 matches
Mail list logo