> -Original Message-
> From: Emily Heureux [mailto:[EMAIL PROTECTED]
> Sent: Thursday, June 12, 2008 8:25 PM
> To: mysql@lists.mysql.com
> Subject: natural sort via substrings
>
> Hi, I am attempting to do a "natural sort" from within mysql, if
> possible. So, for example, jane2 would come
> -Original Message-
> From: Adam de Zoete [mailto:[EMAIL PROTECTED] On Behalf Of
> Adam de Zoete
> Sent: Thursday, May 15, 2008 6:24 AM
> To: mysql@lists.mysql.com
> Subject: Floor Decimal Math
>
> Hi,
>
> I'm running mysql 4.1.20 (Mac OS 10.4.11) and wondering why this ain't
> returning t
> From: Critters [mailto:[EMAIL PROTECTED]
> Sent: Monday, September 24, 2007 5:24 AM
> To: MySQL General
> Subject: Problem with characters
>
> I have a new setup with mySql version 4.1 and myODBC version 3.51
> running on Windows 2k3 standard
>
> In the database we have something like "And this i
I've found the following resources to be very helpful when dealing with
character set issues:
http://www.cs.tut.fi/~jkorpela/chars.html
http://www.joelonsoftware.com/articles/Unicode.html
HTH, HAND
JT
> -Original Message-
> From: Critters [mailto:[EMAIL PROTECTED]
> Sent: Monday, Septem
>> From: John Kopanas [EMAIL PROTECTED]
>> Subject: Returning All Rows That Repeat
>>
>> I want to be able to return all rows that have one or more other rows
>> with the same customer_number and job_number.
>>
>> So for instance. If their are two jobs in my jobs table with a
>> customer_number =
> -Original Message-
> From: Hiep Nguyen [mailto:[EMAIL PROTECTED]
> Sent: Friday, July 06, 2007 12:15 PM
> To: Dirk Bremer
> Cc: David T. Ashley; mysql@lists.mysql.com
> Subject: RE: zipcode to timezone
>
> now, why do they do this??? it doesn't make any sense at all to have
> multiple tim
> -Original Message-
> From: Hiep Nguyen [mailto:[EMAIL PROTECTED]
> Sent: Friday, July 06, 2007 10:51 AM
> To: David T. Ashley
> Cc: mysql@lists.mysql.com
> Subject: Re: zipcode to timezone
>
> i don't think there is any state got 2 timezones, i could be wrong.
Yeah, you are.
http://worl
> -Original Message-
> From: John Kebbel [mailto:[EMAIL PROTECTED]
> Sent: Thursday, May 03, 2007 7:34 AM
> To: MySQL
> Subject: Less | More
>
> Is there a mysql command line equivalent to | less or | more to make it
> easier to scan rows one screen at a time?
I have the command:
page
Way offoptic now
How do you pronounce "gift"? :^)
$ egrep '^gif' /usr/share/dict/words
gift
gift's
gifted
gifting
gifts
To heck with the spec, all precedent in English says hard G.
Next they'll tell us to pronounce "jpeg" as "gay-peg".
-Original Message-
From: Gerald L. Clark [ma
Sounds more like a PHP error than a MySQL error.
-Original Message-
From: John [mailto:[EMAIL PROTECTED]
Sent: Monday, December 04, 2006 12:53 AM
To: mysql@lists.mysql.com
Subject: Error. Need help (Bad arguments.)
I get this error:
Warning: implode(): Bad arguments. in
/home/b/cl/
When I need to do so, I use mysqldump -d to dump the schemas to files, then use
"diff" on the files. It's pretty good at highlighting the differences.
-Original Message-
From: Steve Buehler [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 28, 2006 3:06 PM
To: mysql
Subject: comparin
Will L. wrote:
> Nabble hates spam as much as you do. We are currently monitoring this
> user and we will take necessary action just like a mailing list owner
> will do.
If you hated spam as much as I did, you would have terminated this user,
based on the egregious and well-documented abuse of th
> On Wed, 2006-02-22 at 16:49 -0600, Ariel Sánchez Mora wrote:
> > So far i've been able to store ip addresses as strings like
> you would
> > type them in DOS, for ex, '192.168.0.1'. This serves me
> great since my
> > application uses IP addresses as strings in all cases. I've done
> > queries
The online documentation would be a good place to start.
http://dev.mysql.com/doc/refman/4.1/en/upgrade.html
> -Original Message-
> From: Jon Miller [mailto:[EMAIL PROTECTED]
> Sent: Sunday, January 01, 2006 7:44 PM
> To: mysql@lists.mysql.com
> Subject: need to upgrade
>
> I need to u
You should read
http://dev.mysql.com/doc/refman/4.1/en/insert.html
and maybe
http://dev.mysql.com/doc/refman/4.1/en/replace.html
> -Original Message-
> From: steve [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, December 28, 2005 8:57 AM
> To: mysql@lists.mysql.com
> Subject: update or inse
There is no such thing as Debian 2.8--see
http://www.us.debian.org/releases/.
> -Original Message-
> From: John Galatti [mailto:[EMAIL PROTECTED]
> Sent: Thursday, December 22, 2005 8:53 AM
> To: mysqlList
> Subject: INSTALLING MYSQL 5.0 ON LINUX DEBIAN 2.8
>
> All
> I am trying to buil
$input = "This is the \n input";# value from user
$saved = "This is the input"; # value in database
$recovered = "This is \n the \n input"; # retrieved from db, != $input
-Original Message-
From: Vladimir B. Tsarkov [mailto:[EMAIL PROTECTED]
Sent: Sun 9/11/2005 2:15 PM
To: mysql@l
Amen. Translating user input into HTML is great until you need to read
the data *out*, and someone decides the output should be formatted as
RTF or PDF or text. Best to store it as you got it, IMO.
> -Original Message-
> From: Alan Williamson [mailto:[EMAIL PROTECTED]
> Sent: Friday, Se
The DuBois book is a good start: http://www.kitebird.com/mysql-book/
> -Original Message-
> From: Jay Paulson [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, September 06, 2005 10:56 AM
> To: mysql@lists.mysql.com
> Subject: Newbie needs info!
>
> Hi everyone,
>
> Long time reader, first ti
Funny you should bring up this subject, as it was recently rehashed
(more like re-re-re-re-hashed!) on perlmonks.org in this discussion
thread:
http://perlmonks.org/?node_id=481652
The conclusion of the discussion(s) is that there are valid reasons to
use single and double quotes in various circu
>From 'perldoc perldata':
Variable substitution inside strings is limited to scalar
variables, arrays, and array or hash slices. (In other
words, names beginning with $ or @, followed by an optional
bracketed expression as a subscript.)
You can check this from the command line:
% perl
Did you try that link? When I follow it, I get a search results page
saying <>. Too
bad it doesn't actually show the search results
> -Original Message-
> From: Michael Monashev [mailto:[EMAIL PROTECTED]
> Sent: Thursday, July 21, 2005 5:45 PM
> To: Ryan Stille; mysql@lists.mysql.c
/system-variables.html
>
> http://dev.mysql.com/doc/mysql/en/flush.html
>
>
>
>
>
>
>
>
>
> "John Trammell" <[EMAIL PROTECTED]> wrote:
>
> > Is it possible for mysqld to reload its configuration files without
&g
Is it possible for mysqld to reload its configuration files without
doing an explicit stop/start? I've searched the online documentation
plus my copy of the DuBois book to no avail.
The fact that the Debian init scripts don't do a proper config reload
(just the GRANT tables) does not give me lots
How about "adddate(20050101, INTERVAL 7*23 DAY)" for getting a date in
week 23?
> -Original Message-
> From: Eric Jensen [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, July 13, 2005 4:29 PM
> To: mysql@lists.mysql.com
> Subject: Re: Getting first and last day o
Playing around with the date/time functions, I came up with:
select subdate(now(), INTERVAL weekday(now()) DAY);
select adddate(now(), INTERVAL 6-weekday(now()) DAY);
So once you have a date in the desired week, it's easy to calculate the
first/last days in that calendar week.
> -Original Me
If you run the select "SELECT NOW() + 1*RAND();" a few times, you'll
see that not all values are valid timestamps, e.g.:
mysql> SELECT NOW() + 1*RAND();
+--+
| NOW() + 1*RAND() |
+--+
| 20050713112881 |
+--+
1 row in set
[EMAIL PROTECTED]
> Sent: Wednesday, June 29, 2005 10:27 AM
> To: John Trammell
> Cc: mysql@lists.mysql.com
> Subject: Re: Underscore functions as a wildcard ?
>
> This is not a bug. Mysql uses _ as the single-character
> wildcard, and % as
> the multi-character wildcar
I recall seeing this "feature" discussed on Bugtraq a few weeks ago.
IIRC there are updated MySQL versions that fix this bug. What version
of MySQL are you running?
> -Original Message-
> From: Jeroen Bosch [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, June 29, 2005 6:59 AM
> To: mysql@l
#!perl
use strict;
use warnings;
sub foo {
warn "wantarray() in foo() is: ", wantarray(), "\n";
my @r = 3 .. 8;
return @r;
}
my @x = foo() or warn "in ... or warn() #1\n";
warn "[EMAIL PROTECTED]: @x\n";
my $x = foo() or warn "in ... or warn() #2\n";
warn "\$x: $x\n";
> -Origi
Is the mysqld daemon running? (It should be.) What does the command
ps aux | grep mysqld
say?
> -Original Message-
> From: Mark Sargent [mailto:[EMAIL PROTECTED]
> Sent: Friday, March 11, 2005 8:52 AM
> To: mysql@lists.mysql.com
> Subject: error 2002:
>
> Hi All,
>
> I get the f
The print string you show is:
"prepare: $insert_sql: $DBI::errstr"
but your error message is
Unable to execute query: DBI::db=HASH(0x8647df0)->errstr
I think your problem is with a print line like:
print "Unable to execute query: $dbh->errstr"
and Perl is interpolating $dbh, but n
> I'd like users to be able to enter the first
> few characters of a contact's name to do a search, and I'd
> like the option of doing inexact matches or phonetic matches.
MySQL does have the SOUNDEX function; see the docs for details...
SELECT * FROM people WHERE SOUNDEX(lastname) = SOUNDEX(
Gerals Preston wrote:
[snip]
> my $sth = $dbh->prepare( $sql ) or die $dbh->errstr if $dbh->err;
[snip]
Regardless of other problems you may be having, I think you're not
doing what you want to do here. How about instead:
my $sth = $dbh->prepare($sql);
$sth || die "Error preparing sth from '$sql
Did you follow the procedure in
http://dev.mysql.com/doc/mysql/en/quick-install.html
?
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, February 23, 2005 1:29 PM
> To: mysql@lists.mysql.com
> Subject: Difficulty starting mysql
>
> Hello,
>
Depends a lot on your server setup and table engine choices. See
http://dev.mysql.com/doc/mysql/en/table-size.html
etc.
> -Original Message-
> From: news [mailto:[EMAIL PROTECTED] On Behalf Of Raph
> Sent: Friday, February 18, 2005 10:08 AM
> To: mysql@lists.mysql.com
> Subject:
You can specify a wildcard in the host IP, eg.
grant select on mydb.* to 'someuser'@'192.168.2.%' ...
which you can use to get around your DHCP issue until host lookups are
fixed.
> -Original Message-
> From: Ian Meyer [mailto:[EMAIL PROTECTED]
> Sent: Thursday, February 17, 2005 11:4
In my version of MySQL (4.1.9), your sample code generates an error:
mysql> select decode(encode("foo"));
ERROR 1064 (42000): You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right
syntax to use near '))' at line 1
Apparently encode()/de
I'd do something like 'mysqldump -d foo'; the -d option only dumps the
table defs.
> -Original Message-
> From: Dan Stromberg [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, February 02, 2005 12:31 PM
> To: mysql@lists.mysql.com
> Cc: [EMAIL PROTECTED]
> Subject: Pulling a database schema ou
39 matches
Mail list logo