rom the subquery (ie. the query as a whole returns 'tbl_name', not it's
contents). Where am I going wrong?
I am using version 4.1.0-alpha-standard
Shawn
--
Shawn McGinn <[EMAIL PROTECTED]>
UNB
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
, not it's contents). Where am I
going wrong?
I am using version 4.1.0-alpha-standard
Shawn
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
to me directly (through my email) relating to
this issue.
Thanks,
Shawn Zernik
Internetwork Consutling
www.internetworkconsulting.net
--- Sample Output ---
mysql> use hsss;
Database changed
mysql> SELECT statistics.*
-> FROM profiles, answers, statistics
-> WH
On 3/24/03 10:37 AM, "R. Hannes Niedner" <[EMAIL PROTECTED]> wrote:
> On 3/24/03 7:41 AM, "Shawn P. Garbett" <[EMAIL PROTECTED]> wrote:
> > How can one allow a user to change their mysql password securily?
> >
> > If I do a grant update on
How can one allow a user to change their mysql password securily?
If I do a grant update on the user table, then a user could change anyone's
password. I just want a user to be able to change their password. Is this
possible?
Shawn
--
MySQL General Mailing List
For list archives:
_static.c. recompile MySQL, and
rebuild the indexes!
TIA,
--
Shawn <[EMAIL PROTECTED]>
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list a
I'm attempting to install MySQL 3.23.55 from source on a Red Hat Linux 7.3
machine. I have recently built and installed GCC 3.2.2 and GNU make 3.80
successfully. Following the steps given on mysql.com for a source
installation, I can go through the install up to and including
"./configure --prefi
omplaining.
What we have tried, none of them work except wiping
the disk and reinstalling everything.
I`d appreciate any suggestions to fix this problem.
Shawn
__
Post your free ad now! http://personal
We have an application software which uses MSSQL 7.0
or 2000 server on Windows. Now we want to use the
MSSQL as a master, and MYSQL on UNIX as a slave. How
can we configure Windows MSSQL and UNIX MYSQL both
sides to implement replication?
Any idea? Thanks in advance.
Shawn
I am using BSDI 4.3, and downloaded MySql source code
3.23.53.
After untarring it, it passed ./configure
--prefix=/usr/local/mysql. But when I run make,
finally it says
make: don't know how to make mi_test_all. Stop
*** Error code 1
Your help will be appreciated
Shawn Xu
MySQL,
I am using BSDI 4.3, and downloaded MySql source code
3.23.53.
After untarring it, it passed ./configure
--prefix=/usr/local/mysql. But when I run make,
finally it says
make: don't know how to make mi_test_all. Stop
*** Error code 1
Your help will be appreciated
Sha
for example.
>
> You have written the following:
>
> Why cannot I post questions to this list since I
> joined a month ago? Why?
>
> It says it cannot include attachment, but definately
> I
> didn't include attachment when I tried to post.
>
> Shawn
>
>
_
I am using BSDI 4.3, and downloaded MySql source code
3.23.53.
After untarring it, it passed ./configure
--prefix=/usr/local/mysql. But when I run make,
finally it says
make: don't know how to make mi_test_all. Stop
*** Error code 1
Your help will be appreciated
Sha
If I have 4,000,000 records, and I just want to make sure that the last 100
records do not contain a certain value, ... how can I efficiently 'count'
the number of times in the LAST 100 records that a specific condition exists?
As an example,
mysql> select COUNT(*) from Log WHERE LogIP="10.0
But timestamp type will change on every update. I only want the default
value to be the current time/date when the row is inserted and then not
change.
>From: Georg Richter <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: [EMAIL PROTECTED], "Shawn Poulson" <
e MySQL
docs.
Any ideas?
---
Shawn Poulson
[EMAIL PROTECTED]
_
MSN Photos is the easiest way to share and print your photos:
http://photos.msn.com/support/worldwide.aspx
---
host). So, the
question still stands, is there a way to read the data sources remotely?
I am able to do it fine if I turn off all security, but as I mentioned, there seems to
be no way to pass the user name and password, let alone the host.
TIA,
Shawn
- Original Message -
From: &q
cs mention nothing about it using the call remotely, but I
can't believe that I am the first to have an issue with it... Any pointers would be
greatly appreciated?
TIA,
Shawn
-
Before posting, please check:
http://w
The RAND() syntax does not appear to be working for me.
What version mySQL is required?
At 04:43 PM 1/29/2002 +0200, Michael Widenius wrote:
>Hi!
>
> > "Ulf" == Ulf Harnhammar <[EMAIL PROTECTED]> writes:
>
>Ulf> On Sun, 27 Jan 2002, Michael Widenius wrote:
> >> One way to do this is to d
You need a where clause at the end to tell it which row to update.
[EMAIL PROTECTED] wrote:
>. mysqladmin version
>mysqladmin Ver 8.21 Distrib 3.23.42, for apple-darwin1.4 on powerpc
>Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
>This software comes with ABSOLUTELY NO WAR
Check in the slave's master.info file
In the first line you'll see a filename for the master's binary log an
in the second line you'll see the position.
Look at the file on the master server and compare the byte -size to the
position.
I wrote a little perl script/netsaint plugin that takes care
you can create my.cnf file with the contents
[mysqld]
socket=/var/lib/mysql/mysql.sock
and put it in path. In case you need to know where the my.cnf file should
be put, execute:
mysqld --help | grep my.cnf
or with your command line mysql binary do
mysql -uusername -p -S=/tmp/mysql.sock
--
/usr/local/bin/mysql -hhostname -uusername -ppassword -e "flush logs;"
Guy Davis wrote:
>Just wondering if any Linux users of MySQL out there had written a
>logrotate configuration file for dealing with MySQL binary logs on a
>replication Master.
>
>I want to rotate these logs (6.5 GB now) as so
to think so, too... but this problem is keeping us from storing
anything larger than 2MB in a column that's supposed to be able to store
16MB worth of data. If we can't make this work, then we'll be forced to
abandon MySQL, and I would really hate to do that!
cheers,
--
sha
none of them even come near being out of
memory or disk space. We even checked safe_mysqld to see if it calls limit
or ulimit... which it doesn't. I'm totally stumped.
Thanks,
--
shawn allen | [EMAIL PROTECTED]
-
Befo
the amount of memory you allocate for MySQL (in my.cnf)
will determine how large of a file you can insert into your table (BLOB
columns can contain 65535 bytes, MEDIUMBLOBs ~16MB, and LONGBLOBs ~4GB).
I've had difficulty ("out of memory" errors, corrupted tables, NULL values)
inserti
ATA() (which doesn't seem to
solve the problem anyway).
I'd appreciate any insight anyone may have into this issue.
--
shawn allen | [EMAIL PROTECTED]
| 415 577 3961
| aim: shawnpallen
-
B
ore you add it to
> your cart.
Shawn Gordon
President
theKompany.com
> -- Forwarded Message --
> Subject: RE: ERD
> Date: Fri, 30 Nov 2001 14:09:50 -0600
> From: "john" <[EMAIL PROTECTED]>
> To: "Peter Harvey" <[EMAIL PROTECTED]>
(using the appropriate
options, of course) . . .
--
------
Shawn Ouderkirk
Senior Engineer and Systems Administrator
SCI Systems, Inc.
Fountain, CO
[EMAIL PROTECTED]
(719) 382-2289
--
Cease dependence on inspection to
achieve quality. Eli
is it generally recommended / a good idea to have more than one PRI index
in the same table? i've never seen that before until today while trying
to track down bugs in someone else's system and noticed a table with 2 PRI
indexes. will this cause any problems?
ti
you would do: "SHOW FIELDS FROM CONFIG LIKE 'CKEY'".
hope this helps.
~shawn
On Mon, 13 Aug 2001, Matthew Marcus wrote:
>
> Hello,
>
> Having trawled through the documentation for a while I'm none the wiser -
> is there any way of retrieving the data typ
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Freakin' Spam filter!!!
- -- Forwarded Message --
Subject: Re: Fwd: Re: Embedding MySQL in an application
Date: 9 Aug 2001 14:07:44 -
From: [EMAIL PROTECTED]
To: "Shawn P. Garbett" <[EMAIL PROTECTED]>
Y
itch ploy on the part
of MS.
The MySQL folks have told me that this has been done and will be fully
supported as part of the next release. Problem is I have to demonstrate it
NOW, or I may end up stuck with MSDE since it exists NOW. MySQL is my
preferred option and I'd love to stick with i
I have been told it is possible to embed MySQL in an application such that
the user never knows a database is running underneath the app. Where can I
find more information about doing this?
--
Shawn P. Garbett <[EMAIL PROTECTED]>
See http://www.garbett.org/public-key for my P
t have a
better solution or three. =)
~shawn
On Sat, 4 Aug 2001, RCA Webmaster wrote:
>
> I have just subscribed to this list, so forgive me if my question has been
> answered many times before but I was not sure where else to find this
> information.
>
> I am new to mysql and am
a date column...
~shawn
On Thu, 2 Aug 2001, Augusto Cesar Castoldi wrote:
> HelpHi.
>
> I have a colun in my table for the birthday.: "DD/MM/". It's varchar.
>
> In PHP, I can get the month of date, bu substr($date, 3, 2). (MM)
>
> Can I do a select wi
cord, printing the
value of the "address" field.
i hope that example was clear enough, i'm not the best at explaining
things sometimes. if you need more information on mysql and php, you can
find it at the following url:
http://www.php.net/manual/en/ref.mysql.php
hope
from http://www.mysql.com/doc/M/i/Miscellaneous_functions.html:
DECODE(crypt_str,pass_str)
Descrypts the encrypted string crypt_str using pass_str as the password.
crypt_str should be a string returned from ENCODE().
hope this helps.
~shawn
On Wed, 1 Aug 2001, saraswathy saras wrote:
>
samchk so i'm not sure exactly what i need
to do to repair this table, since it said it should be fixed.
i also still have no clue why this search suddenly stopped working. =/
frustrated,
~shawn
On Mon, 30 Jul 2001, Werner Stuerenburg wrote:
> What about issueing first drop index,
think of doing since
nothing else has changed that should be causing the searches to no longer
function properly.
any help would be appreciated.
~shawn
-
Before posting, please check:
http://www.mysql.com/manual.php (the
for MySQL 3.23.37 If you need
3.23.38, email me privately... I modified a copy of it to install 3.23.38
instead and I think I still have the .pkg for it around somewhere...
- Shawn
-------
Shawn D. Hogan
President, Digital Point Solutions
http://www.digitalpoint.com
(858)
Does this seem to weird to anyone?
mysql> SELECT count('') FROM emailarchive where match (sendername) against
('shawn') group by '';
+---+
| count('') |
+---+
| 13286 |
+---+
1 row in set (3.29 sec)
mysql> SELECT cou
where listnum = 1 and match
(emailbody) against ('shawn') group by'';
Empty set (7.19 sec)
The above query should return a total of 22,778.
mysql> SELECT count('') FROM emailarchive where listnum = 1 and match
(emailbody) against ('mysql') group by&
I'm looking for an online message forum or mailing list that deals with
Perl/mySQL. Most of the sites I've found are outdated and unused.
Any pointers greatly appreciated.
Thanks!!!
--
Shawn Cummings
bostonwebspace.com
$9 webhosting/mySQ
ail
><[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
--
Shawn Cummings
bostonwebspace.com
$9 webhosting/mySQL/Perl/PHP
-
Before posting, please check:
http://www.mys
run make make install.
When I try to do that, it says nothing to make. Any help would be greatly
appreciated.
TIA
Sincerely,
Shawn M. Campbell
LBMC I.S. Specialist
A+; MCP
V - (615) 309-2223
F - (615) 309-2523
-
Before posting
eak.
>How-To-Repeat:
Easy way:
mysql mysql
select * from users order by rand() limit 10
On my database machine using the latest stable binray release it fails.
>Fix:
None known
>Submitter-Id:
>Originator:Shawn Wallace
>Organization:
Justweb Inc.
>MySQL support: [none | li
Everythng that I find seems to be a
little advanced for what I am needing. All I want to do is select a value
(sales,marketing,finance,etc from a table row) all I seem to find is how to
return all data for that row in a formated order. How should I request
this.
Shawn
House
Hi All,
Does anyone have any ideas on this one? Could I maybe try to install a
newer version of whatever package installs libstdc++? Anyone know what
package installs this file?
Thanks for the help,
Shawn
- Original Message -
From: Shawn Heeley <[EMAIL PROTECTED]>
To: &
what version I currently have?
Thanks all for the help,
Shawn
- Original Message -
From: Bill Swanson <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; Shawn Heeley <[EMAIL PROTECTED]>
Sent: Wednesday, February 28, 2001 8:05 AM
Subject: Re: Problem compiling mysql on FreeBSD
Hi folks,
This appears to be a common problem that I can't seem to find a solution.
No matter which approach I take to trying to install mysql-server, the end
result is the same. It doesn't work. I apologize for the long message.
Thanks for the help.
System Specs
FreeBSD www.machine.com 4.0-RELE
examined all the readme's and didn't
see any reference to this functionality.
Thanks,
Shawn
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list
Hi,
I just wanted to confirm that MySQL is supported on RedHat 7. I saw
references to RedHat 5.x and 6.x on the website but no references to RedHat
7.
Thanks,
shawn
-
Before posting, please check:
http://www.mysql.com
I want to query out the field names where the "Default" is NULL ... so I
can populate an HTML page for input...
SHOW FIELDS FROM tblNAME;
This shows the fieldnames, and the properties -- but how can I just get a
list of the fieldnames where the Default is NULL -- or how can I get this
list
501 - 554 of 554 matches
Mail list logo
