Schwartz
Percona Inc: Services and Support for MySQL
http://www.percona.com/
--
The Logos has come to bear
http://logos.13gems.com/
--
-
Johnny Withers
601.209.4985
joh...@pixelated.net
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=joh...@pixelated.net
--
-
Johnny Withers
601.209.4985
joh...@pixelated.net
?unsub=joh...@pixelated.net
--
-
Johnny Withers
601.209.4985
joh...@pixelated.net
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
.
Regards,
Sebastiaan
--
-
Johnny Withers
601.209.4985
joh...@pixelated.net
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=joh...@pixelated.net
--
-
Johnny Withers
601.209.4985
joh...@pixelated.net
this:
SELECT people.*,
SUM(IF(cars.id IS NULL,0,1)) AS car_count,
SUM(IF(pets.id IS NULL,0,1)) AS pet_count,
SUM ( IF ( pets.date_bought NOW() - INTERVAL 7 DAYS, 1, 0 ) AS
new_pet_count
Yes?
--
-
Johnny Withers
601.209.4985
joh...@pixelated.net
--
-
Johnny Withers
601.209.4985
joh...@pixelated.net
...@pixelated.net
--
-
Johnny Withers
601.209.4985
joh...@pixelated.net
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
25 22:18:20 chenj-desktop /etc/init.d/mysql[11094]: Check that mysqld is
running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
Aug 25 22:18:20 chenj-desktop /etc/init.d/mysql[11094]:
Does this message tell me any thing about the problem? Thanks.
Best,
Jia
Johnny Withers wrote
I'm at work now, this is the cmd I used:
chcon -R -u system_u -r object_r -t mysql_db_t /data
(my data lives in /data/mysqlXX -- were XX is the server version)
On Wed, Aug 26, 2009 at 8:02 AM, Johnny Withers joh...@pixelated.netwrote:
Yes, error 13, permission denied. Check selinux setup. I
?unsub=joh...@pixelated.net
--
-
Johnny Withers
601.209.4985
joh...@pixelated.net
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
.
Maybe?
On Fri, Aug 21, 2009 at 10:13 AM, Jerry Schwartz jschwa...@the-infoshop.com
wrote:
-Original Message-
From: Ananda Kumar [mailto:anan...@gmail.com]
Sent: Friday, August 21, 2009 2:55 AM
To: Johnny Withers
Cc: MySQL
Subject: Re: alternate in mysql
Hi Johnny,
Thanks
index? I'm guessing not as I'm
doing OR's
Thanks
Simon
--
-
Johnny Withers
601.209.4985
joh...@pixelated.net
)), chr(10))) from tmp;
/sr/db/ora/ora.ora
/sr/db/ora/ora.ora
where chr(10) ..represents NEW LINE in oracle
How do i do the same in mysql.
Thanks for all you help.
regards
anandkl
--
-
Johnny Withers
601.209.4985
joh...@pixelated.net
://www.databasedevelopmentforum.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=joh...@pixelated.net
--
-
Johnny Withers
601.209.4985
joh...@pixelated.net
turned back on
Any suggestions as to how I might clean this up
Thanks.
Miles
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=joh...@pixelated.net
--
-
Johnny Withers
: http://lists.mysql.com/mysql?unsub=joh...@pixelated.net
--
-
Johnny Withers
601.209.4985
joh...@pixelated.net
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
6
--
---
This is a signature.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=joh...@pixelated.net
--
-
Johnny Withers
601.209.4985
joh...@pixelated.net
to achieve this in mysql.
Looking for your help.
Thanks,
Manoj
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=joh...@pixelated.net
--
-
Johnny Withers
601.209.4985
joh
of the queries that are currently running along with
their PID# and state. Find the query your want to stop, and run the
following command
KILL #; (where # is --
Eric Bergen
eric.ber...@gmail.com
http://www.ebergen.net
--
-
Johnny Withers
601.209.4985
joh
://lists.mysql.com/mysql?unsub=joh...@pixelated.net
--
-
Johnny Withers
601.209.4985
joh...@pixelated.net
Maybe I'm wrong :)
On Tuesday, July 21, 2009, John Daisley john.dais...@mypostoffice.co.uk wrote:
On Tue, 2009-07-21 at 19:42 +0200, Morten Primdahl wrote:
On Jul 21, 2009, at 3:27 PM, Johnny Withers wrote:
MySQL is unable to use your index when you use IN and/or OR on yoru
column
records
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=joh...@pixelated.net
--
-
Johnny Withers
601.209.4985
joh...@pixelated.net
...@pixelated.net
--
-
Johnny Withers
601.209.4985
joh...@pixelated.net
-07-14 00:36 mysql
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=joh...@pixelated.net
--
-
Johnny Withers
601.209.4985
joh...@pixelated.net
-755-25273851
MSN:tianjing...@hotmail.com msn%3atianjing...@hotmail.com
msn%3atianjing...@hotmail.com msn%253atianjing...@hotmail.com
--
-
Johnny Withers
601.209.4985
joh...@pixelated.net
|
++-+-+--+---+--+-+--++-+
2009/7/13 Johnny Withers joh...@pixelated.net
Can you show the CREATE TABLE for your REF_SEQ table?
The explain output says using where which means that MySQL will have to
post-filter
|
++-+-+---+-+-+-+--+--+-+
in this sql,the index is on REF_ID and START_POSITION, the rows in the
output is more less than that index_POS on START_POSITION and index_ref on
REF_ID.
2009/7/13 Johnny Withers
the error. Please help me!
MySQL version = 5.0.32-Debian_7etch8-log
TIA,
Ralph
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=joh...@pixelated.net
--
-
Johnny Withers
- Release Date: 06/19/09 06:53:00
--
-
Johnny Withers
601.209.4985
joh...@pixelated.net
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
radi for example)
Any ideas?
Thanks in advance!
Matt
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=joh...@pixelated.net
--
-
Johnny Withers
601.209.4985
joh
/mysql?unsub=joh...@pixelated.net
--
-
Johnny Withers
601.209.4985
joh...@pixelated.net
--
-
Johnny Withers
601.209.4985
joh...@pixelated.net
in mysql
server. Is there anybody using on productions.
Thanks,
Prajapati
Krishna Chandra Prajapati
Email-id: prajapat...@gmail.com
--
-
Johnny Withers
601.209.4985
joh...@pixelated.net
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
then export (SELECT INTO OUTFILE) from A's data
and import (LOAD DATA) into B's data?
Has anyone done something like this before? Did you have problems?
--
-
Johnny Withers
601.209.4985
joh...@pixelated.net
?
--
-
Johnny Withers
601.209.4985
joh...@pixelated.net
---
Why not create a view and just concatenate on an identifier? This way the
data can be kept in the same forms.
Or, if you do want to have it as one table, you can use a select insert
statement to move from one to another
Yes, Triggers... I so rarely use them I forget they exist.
On Tue, May 5, 2009 at 10:22 AM, Thomas Pundt mli...@rp-online.de wrote:
Johnny Withers schrieb:
Well, I think an update after insert is the only way. Other than
perpopulating another table with possibe crc values then usinga join
?
Best regards
Thunder
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=joh...@pixelated.net
--
-
Johnny Withers
601.209.4985
joh...@pixelated.net
...@pixelated.net
--
-
Johnny Withers
601.209.4985
joh...@pixelated.net
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
--
-
Johnny Withers
601.209.4985
joh...@pixelated.net
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
is a major factor concern here given our huge data sets
involved. Does joining across databases impose any speed/performance
hits vs. just joining across tables within a single database?
http://daevid.com
--
-
Johnny Withers
601.209.4985
joh...@pixelated.net
, Wm Mussatto mussa...@csz.com wrote:
On Wed, March 18, 2009 06:29, Johnny Withers wrote:
Everytime we make a schema change in development we save an SQL script
into
a directory named in MMDD format. The scripts are named in
MMDD_NNN_DESCRIPTION.SQL format, where NNN is the sequence
, yes it can use an index merge, but... efficiency is
another question. I've seen table scans outperform a two-way index
merge by orders of magnitude.
These appeared to be high selectivity indexes, but perhaps I assumed
too much. :)
--
-
Johnny Withers
first, if a row
is found.. just return the matching customer_id from the customer table..
but I wanted to see if maybe i'm going about this the wrong way before I
engineer some way around this.
Thanks in advance,
-
Johnny Withers
601.209.4985
joh...@pixelated.net
23:59:59'
That works on both servers, but I really don't want to have to put the time
in there (unless that's the way you are supposed to do this).
I've though about using DATE_FORMAT... not sure about that either.
-
Johnny Withers
601.209.4985
joh...@pixelated.net
.
--
-
Johnny Withers
601.209.4985
[EMAIL PROTECTED]
this?
--
-
Johnny Withers
601.209.4985
[EMAIL PROTECTED]
that AWE support is
becoming obsolete)?
Is this going to even work on a 32bit system, or should i just move to
64bit?
Any help, thoughts or comments is appreciated. Feel free to ask any
questions i may have left unanswered.
Thanks in advance.
-
Johnny Withers
.
-
Johnny Withers
[EMAIL PROTECTED]
p. 601.932.0211
c. 601.209.4985
-Original Message-
From: Jonas Askås [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 30, 2003 2:52 AM
To: [EMAIL PROTECTED]
Subject: Storage issue
Hi,
I'm wondering how well MySQL compress data
rows
for other user id's in hh_images).
Could someone give me some direction here?
-
Johnny Withers
[EMAIL PROTECTED]
p. 601.853.0211
c. 601.209.4985
-
Before posting, please check:
http
select version()\G
*** 1. row ***
version(): 3.23.49-max-nt
1 row in set (0.00 sec)
-
Johnny Withers
[EMAIL PROTECTED]
p. 601.853.0211
c. 601.209.4985
-
Before
The user might need the FILE permission, I'm not sure.
Also might need the LOCK TABLES permission.
http://www.mysql.com/doc/G/R/GRANT.html
-
Johnny Withers
[EMAIL PROTECTED]
p. 601.853.0211
c. 601.209.4985
-Original Message-
From: Jay Blanchard [mailto:[EMAIL
If the file is actually there...
make sure the first line actually points to the perl
binary.
-
Johnny Withers
[EMAIL PROTECTED]
p. 601.853.0211
c. 601.209.4985
-Original Message-
From: Page Works Web Solutions [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 01
You should try MySQL Front
http://anse.de/mysqlfront/
-
Johnny Withers
[EMAIL PROTECTED]
p. 601.853.0211
c. 601.209.4985
-Original Message-
From: Ioakim Spyros [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 16, 2002 10:20 AM
To: [EMAIL PROTECTED]
Subject
address?
-
Johnny Withers
[EMAIL PROTECTED]
p. 601.853.0211
c. 601.209.4985
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive
port and socket to listen on?
Should I remove the [mysqld] section from the file and start the servers
from the command line using command line options and just leave the
innodb/mysql-client options in my.cnf ?
Any help ?
-
Johnny Withers
[EMAIL PROTECTED]
p. 601.853.0211
c
joins all these tables together to make the
mail message when the user wishes to read/reply to it.
Hope this helps.
-
Johnny Withers
[EMAIL PROTECTED]
p. 601.853.0211
c. 601.209.4985
-Original Message-
From: Haryana [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 03
| | ||
++--+--+-+-++
Server version: 3.23.49a-Max
(mysql,query,table,sql,thisisnotspam)
-
Johnny Withers
[EMAIL PROTECTED]
p. 601.853.0211
c. 601.209.4985
-
Before posting
***
player: Johnny Withers
game: 2
points: 200
ppg: 100
team_name: Mindbender's Fake Team
*** 2. row ***
player: No Team Asso
game: 1
points: 1
ppg: 1
team_name: Mindbender's Fake Team
Table desc
.
-
Johnny Withers
[EMAIL PROTECTED]
p. 601.853.0211
c. 601.209.4985
-Original Message-
From: Julio [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 26, 2002 10:33 AM
To: [EMAIL PROTECTED]
Subject: help | i'm new
hi. i'm a dumb newbie. excuse my ignorance.
i'm
;
+---+---+---+
| first | last | total |
+---+---+---+
| 20973 | 62915 | 41943 |
+---+---+---+
-
Johnny Withers
[EMAIL PROTECTED]
p. 601.853.0211
c. 601.209.4985
-Original Message-
From: Sean O'Donnell [mailto:[EMAIL PROTECTED]]
Sent
website is named www.homebrew.com, you might want to add the
grant to 'homebrew'@'www.homebrew.com', or the ip address if your site.
Hope this helps.
-
Johnny Withers
[EMAIL PROTECTED]
p. 601.853.0211
c. 601.209.4985
-Original Message-
From: Søren Neigaard [mailto
);
}
}
$leadin=;
mysql_free_result($sub_result);
}
}
}
}
}
}
-
Johnny Withers
[EMAIL PROTECTED
!
-
Johnny Withers
[EMAIL PROTECTED]
p. 601.853.0211
c. 601.209.4985
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e
.
-
Johnny Withers
[EMAIL PROTECTED]
p. 601.853.0211
c. 601.209.4985
-Original Message-
From: Brett Burgess [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 07, 2002 11:25 AM
To: [EMAIL PROTECTED]
Subject: Re: long query on php
Here is how I do it:
$query = some query ;
$query
INSERT into the table
then SELECT last_insert_id()
or when using php
query(INSERT QUERY)
$last_id=mysql_insert_id()
OR
INSERT
SELECT MAX(id) FROM tablename
assuming id is the auto incremnt field.
-
Johnny Withers
[EMAIL PROTECTED]
p. 601.853.0211
c. 601.209.4985
InnoDB tables will
speed up access time due to ROW level locking.
-My 2c
-
Johnny Withers
[EMAIL PROTECTED]
p. 601.853.0211
c. 601.209.4985
-Original Message-
From: BD [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 25, 2002 9:42 AM
To: [EMAIL PROTECTED]
Subject: Re
versions.
And running background processes. If the suse system is running
X in the background, then it will be slower also.
Cheers.
-
Johnny Withers
[EMAIL PROTECTED]
p. 601.853.0211
c. 601.209.4985
-Original Message-
From: Jatin Nansi [mailto:[EMAIL PROTECTED]]
Sent
them with success.
That could be the problem.
Down grade to 2.4.9 or .8, patch up the security holes, if any in
that kernel, and give that a test run.
-
Johnny Withers
[EMAIL PROTECTED]
p. 601.853.0211
c. 601.209.4985
-Original Message-
From: Joshua J.Kugler
opinion,
I have been wrong before.
-
Johnny Withers
[EMAIL PROTECTED]
p. 601.853.0211
c. 601.209.4985
-Original Message-
From: Johnny Withers [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 11, 2002 11:40 AM
To: 'MySQL'
Subject: RE: Problem with MySQL and SMP?
Could
I would imagine floor() would be defined in math_iso.h..
Since floor() is a math function..
along with ceiling() (sp?)
You need math_iso.h..
Maybe it wasn't in the tar?
Can't imagine why it wouldn't be.
-
Johnny Withers
[EMAIL PROTECTED]
p. 601.853.0211
c. 601.209.4985
-
Johnny Withers
[EMAIL PROTECTED]
p. 601.853.0211
c. 601.209.4985
-Original Message-
From: Dennis [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 09, 2002 10:52 AM
To: [EMAIL PROTECTED]
Subject: Re: 2 GB limit reached
At 11:26 PM 01/08/2002, you wrote:
On Tue, Jan 08, 2002 at 08
.web_account)
ORDER BY tmp01.count_wa DESC;
DROP table tmp01;
This is probably not the best solution to your problem.
-
Johnny Withers
[EMAIL PROTECTED]
p. 601.853.0211
c. 601.209.4985
-Original Message-
From: Girish Nath [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 14
every
//single php block. The php connection is closed at the
//end of your php script if you do not call mysql_close()
//before then.
//Also, $intLink is not required if you only make one
//connection to the database at a time.
-
Johnny Withers
[EMAIL PROTECTED]
p. 601.853.0211
.
-
Johnny Withers
[EMAIL PROTECTED]
p. 601.853.0211
c. 601.209.4985
-Original Message-
From: Peter M. Perchansky [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 13, 2001 2:55 PM
To: [EMAIL PROTECTED]
Subject: Can mySQL log files be located on another server?
Greetings:
http
.
-
Johnny Withers
[EMAIL PROTECTED]
p. 601.853.0211
c. 601.209.4985
-Original Message-
From: anandakkumar araskumar [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 29, 2001 6:37 AM
To: [EMAIL PROTECTED]
Subject: please help me
Hi all
Iam new to php and iam learning that from
Really... you could also search it with some sort
of search function in your browser..
-
Johnny Withers
[EMAIL PROTECTED]
p. 601.853.0211
c. 601.209.4985
-Original Message-
From: Etienne Marcotte [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 28, 2001 12:16
(comma seperated values) and using
LOAD DATA
statements to get the data into mySQL.
-doesnthaveareallycooldotsig
-
Johnny Withers
[EMAIL PROTECTED]
p. 601.853.0211
c. 601.209.4985
-Original Message-
From: Craig Newlander [mailto:[EMAIL PROTECTED]]
Sent: Wednesday
Why not just:
SELECT MAX(id) AS max_id FROM yourtable;
Then run another select to get the record?
Or, if you want the last record:
SELECT * FROM yourtable ORDER BY id DESC LIMIT 1;
maybe.
-
Johnny Withers
[EMAIL PROTECTED]
p. 601.853.0211
c. 601.209.4985
-Original
.
(Filter : MySQL,database,SQL,etc)
-
Johnny Withers
[EMAIL PROTECTED]
p. 601.853.0211
c. 601.209.4985
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Adams, Bill TQO
Sent: Thursday, August 30, 2001 1:11 PM
To: Sergei Golubchik
Cc: Johnny
x.xx.xxx 2.4.8 #3 SMP Tue Aug 14 09:47:47 CDT 2001 i686
unknown
-
Johnny Withers
[EMAIL PROTECTED]
p. 601.853.0211
c. 601.209.4985
-
Before posting, please check:
http://www.mysql.com/manual.php
mysql desc zipcodes;
+---+--+--+-+-++
| Field | Type | Null | Key | Default | Extra |
+---+--+--+-+-++
| id| int(10) unsigned | | PRI | NULL|
You have old style passwords in your mysql.user table..
you need to add --old-protocol to the start line in the startup
script in /etc/rc.d/init.d
then you should update the passwords to the new style..
-
Johnny Withers
[EMAIL PROTECTED]
p. 601.853.0211
c. 601.209.4985
At boot time you can pass a flag to lilo to force
a certian amount of ram..
i think it's something like this:
lilo: linux mem=256
307,000 rows in mysql is easy, mysql can handle
a lot more rows than that.
You shouldn't have any trouble with this amount of data.
-
Johnny
make your file with valid sql in it..
then run:
mysql -u user -p password --database database file.sql
-
Johnny Withers
[EMAIL PROTECTED]
p. 601.853.0211
c. 601.209.4985
-Original Message-
From: KAMRY [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 31, 2001 1:07 PM
: $sqlbr.mysql_errno(). : .mysql_error();
}
//in your html
if(!$err) {
//display html stuff
} else {
printf(%s,$errMsg);
}
-
Johnny Withers
[EMAIL PROTECTED]
p. 601.853.0211
c. 601.209.4985
-Original Message-
From: Chris Bolt [mailto:[EMAIL PROTECTED
.
Cheers.
-
Johnny Withers
[EMAIL PROTECTED]
p. 601.853.0211
c. 601.209.4985
-Original Message-
From: oltra jean-michel [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 30, 2001 10:03 AM
To: Philippe Louis Houze
Cc: [EMAIL PROTECTED]
Subject: Re: Password security
On Sun
ISM tables are "old" structure for mySQL tables
they are called ISAM tables..
MYI tables are the new structures for mySQL tables
they are called MyISAM
This new structure offers better backup/restore
features along with better data sanity checking.
Not to mention, they are faster.
As for
|
++--+++-++-+---+-+
| 1 | Mindbender | Johnny Withers | 3/20/2001 | 1426.85 | 0 | 1
|| 2 | 1 |
| 2 | Mindbender | Johnny Withers | 3/21/2001 | 1538.13 | 0 | 1
|| 2 | 1
mediabankmaster.publicdocs;
ERROR 1142: select command denied to user: '[EMAIL PROTECTED]' for table
'publicdocs'
-
Johnny Withers
[EMAIL PROTECTED]
p. 601.853.0211
c. 601.954.9133
-
Before posting, please check:
http
. last_insert_id() returns the last insert
ID of that connection ID, so you will get the correct values.
-
Johnny Withers
[EMAIL PROTECTED]
p. 601.853.0211
c. 601.954.9133
-Original Message-
From: Josh Burroughs [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 06, 2001 6:18 PM
suppler on suppliersiclink to get list of suppliers in that
sic area
Thanks for the help.
-
Johnny Withers
[EMAIL PROTECTED]
p. 601.853.0211
c. 601.954.9133
-
Before posting, please check:
http
commands (neither from the client
or from an external MySQL program). However,
I can simply bring mySQL down and rm -rf the 'planhouse-broke' dir and restart MySQL.
Seems to me there is something wrong though.
-
Johnny Withers
[EMAIL PROTECTED]
p. 601.853.0211
c. 601.954.9133
Equipment, to Golf to Golf
Equipment..
hope this helps..
-
Johnny Withers
[EMAIL PROTECTED]
p. 601.853.0211
c. 601.954.9133
-Original Message-
From: Isaac Force [mailto:[EMAIL PROTECTED]]
Sent: Sunday, March 04, 2001 5:03 PM
To: [EMAIL PROTECTED]
Subject: Recursive
Because
TINYINT has a MAX VALUES of 127
pre the mysql docs:
TINYINT[(M)] [UNSIGNED] [ZEROFILL]
A very small integer. The signed range is -128 to 127. The unsigned range is 0 to 255.
if you unsign the column, you can get to 255
I would use something larger, because you will have more than 255
Yes, it really is 255.
need something bigger?
try:
TINYBLOB
MEDIUMBLOB
LONGBLOB
etc..
LONGBLOB will hold L+4 bytes, where L 2^32
2^32 is large enough for most things.
-
Johnny Withers
[EMAIL PROTECTED]
p. 601.853.0211
c. 601.954.9133
-Original Message-
From
is a column in a table in a database.
mysqlselect ' chrishallgren';
This works because mysql RETURNS a column with the
value ' chrishallgren' in it.
maybe that helps.
-
Johnny Withers
[EMAIL PROTECTED]
p. 601.853.0211
c. 601.954.9133
-Original Message
ql_errno()." :
".mysql_error();
}
---somehwere in html file
if(!$err) {
//display results and info here
} else {
printf("%s\n",$errMsg);
}
- -
Johnny Withers
[EMAIL PROTECTED]
p. 601.853.0211
c. 601.954.9133
- -Original Message-
From: Keith
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
base64 encode the encrypted text before storing it..
easily done in php
base64_encode(string);
- -
Johnny Withers
[EMAIL PROTECTED]
p. 601.853.0211
c. 601.954.9133
- -Original Message-
From: Chris [mailto:[EMAIL
.
- -
Johnny Withers
[EMAIL PROTECTED]
p. 601.853.0211
c. 601.954.9133
- -Original Message-
From: Quickling [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 22, 2001 5:54 PM
To: [EMAIL PROTECTED]
Subject: Re: Keeping MySQL from listening to ports to connections
Sorry, this post
101 - 200 of 203 matches
Mail list logo