indexes on it which
improved speed a lot but these queries are still very slow. You can most
certainly laugh to yourselves on this one... jsut trying to get some
opinions on what I should do with this.
Thanks-
Matt
SELECT content.row_id AS row_id, content.app_id AS app_id, s1.data AS
niche, s2
AND L.LINK_APPROVED='Yes')
GROUP BY C.CAT_ID
ORDER BY CAT_NAME
Hope that helps.
Matt
- Original Message -
From: Trevor Sather
Sent: Thursday, October 23, 2003 6:49 PM
Subject: Syntax for SQL Query - used to work with Access
Hi
This query used to work with an Access database:
SELECT *, (SELECT
Thanks everyone for your input, I'll try the ramdisk idea, I read about
someone else who tried that and had some success. Beyond, that I'm gonna
take the long route and redesign the database to be a bit more
conventional.
Thanks!
Matt
On Thu, 2003-10-23 at 20:28, Peter Buri wrote:
Hello
Have you tried:
GRANT INSERT, DELETE, UPDATE, SELECT ON *.* TO user@'%'
IDENTIFIED BY 'password';
FLUSH PRIVILEGES;
On Thu, 2003-10-23 at 21:03, Nathaniel Mallet wrote:
I was having the same problems trying to get a user added to a new DB, so
here's are the commands I used:
GRANT INSERT,
() or whatever to check
the mtime.
Matt
- Original Message -
From: mos
Sent: Wednesday, October 22, 2003 1:44 PM
Subject: Re: Mysql Performance Question
At 12:32 PM 10/21/2003, you wrote:
Thanks a lot guys.
Haydies:
Just out of wondering, are you using PHP and if so do you use
Any ideas what packages install this library? I used the RPM to try and
install MySQL-client on my redhat machine, but the libmysqlclient did
not show up in /usr/lib - so I am wondering which RPM I need to get this
file?
Thanks,
Matt
--
MySQL General Mailing List
For list archives: http
Thanks everyone! I installed MySQL-shared-X and it worked!
On Tue, 2003-10-21 at 15:48, Kelley Lingerfelt wrote:
the mysql-devel rpm installs it.
Kelley
Matt Babineau wrote:
Any ideas what packages install this library? I used the RPM to try and
install MySQL-client on my redhat
shed some light on my situation? I have attached my cnf file
thanks-
Matt
# Example mysql config file for large systems.
#
# This is for large system with memory = 512M where the system runs mainly
# MySQL.
#
# You can copy this file to
# /etc/my.cnf to set global options,
# mysql-data-dir/my.cnf
it...
Or am I stuck waiting for myisamchk to finish?
myisamchk --force --fast --update-state -O key_buffer=128M -O
sort_buffer=128M -O read_buffer=4M -O write_buffer=4M table
Any help appreciated...
-Matt-
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
=16M
[myisamchk]
set-variable = key_buffer=256M
set-variable = sort_buffer=384M
set-variable = read_buffer=16M
set-variable = write_buffer=16M
[mysqlhotcopy]
interactive-timeout
Hope that helps.
Matt
- Original Message -
From: Rainer Sip
Sent: Tuesday, October 21, 2003 9:48 AM
Hi Dan,
If you manually modify the mysql database without using GRANT, then you
need to FLUSH PRIVILEGES afterwards to get MySQL to reload the
permissions. Of course, restarting the server has the same effect. Using
GRANT takes care of everything automatically, though.
Hope that helps.
Matt
.)
Otherwise, maybe the table is corrupted? What does CHECK TABLE
dspam_token_data say?
Finally, you said the IN () list is very long -- how long is that?
More than a million characters?
Matt
- Original Message -
From: Joakim Ryden
Sent: Friday, October 17, 2003 10:48 PM
Subject: Failed
Hi Jim,
As far as I know: eye-sam my-eye-sam. At least that's how I pronounce
them. :-)
Matt
- Original Message -
From: Jim Mathews
Sent: Saturday, October 18, 2003 3:44 PM
Subject: Pronunciation of ISAM table name
I have a very basic newbie question that, despite
multiple
then be very fast because it doesn't need to go to the data
file -- as EXPLAIN will show with Using index.
Hope that helps.
Matt
- Original Message -
From: Ganbold
Sent: Friday, October 17, 2003 4:14 AM
Subject: Re: How to speed up query?
Egor,
Result of explain:
mysql explain select sum
As I understand it mysql is a single process multi-threaded application. I have
heard of some thread schedulers that allow for a certain granularity of
determining where to run a particular thread / process. I think this is the
purpose behind Sun's processor groups.
Is there such a thing for
with bind-address, you can still connect locally via
Unix sockets (or named-pipes on NT), as with skip-networking. Not 100%
sure on that though.
Hope that helps.
Matt
- Original Message -
From: Dan Jones
To: MySQL Mailing List [EMAIL PROTECTED]
Sent: Thursday, October 16, 2003 8:15 PM
queries on one line.
I wonder what the catch is.
I have gotten the embedded application running, instead of pipes. And I
evidently lose the ability to submitt multiple sql statements. I wonder how
I can obtain that capability back.
Matt Young
--
MySQL General Mailing List
For list archives
failover to the
active node)? This looks important because the bin-log filenames, as well
as the GRANT table, seem to use whatever the system returns from
hostname(), which is 'cluster0' or 'cluster1' depending on where it's
running.
Any input appreciated... Thanks in advance...
-Matt-
--
MySQL
things...),
then it's not hung. Just sit and wait. :-)
Matt
- Original Message -
From: D. R. Hansen
Sent: Wednesday, October 15, 2003 3:39 PM
Subject: ALTER TABLE z ADD INDEX... Speed: Follow up to LEFT JOIN
question
What amount of time is reasonable to expect for indexing an FK int
I have both the standard and source mysql, and I am attempting a link with a
simple program that calles mysql_server_init and mysql_server_end.
I have tried various library call outs to find these two calls in both the
standard and source mysql directories.
I have not located these in any of
?
What happens after you run ANALYZE TABLE? It doesn't appear that you've
done so since your index cardinality is NULL.
Matt
- Original Message -
From: Peter Rabbitson
Sent: Sunday, October 12, 2003 10:42 PM
Subject: Re: unexpected index behaviour...
G you guys are very helpful
://www.mysql.com/doc/en/SHOW_VARIABLES.html
It also says that when you specify a file, all words are used. AFAIK,
the stopword file is parsed using the same word boundaries as the
indexer/searcher. I just put each word on its own line.
Hope that helps.
Matt
- Original Message -
From
Hi Randy,
Unique keys are not disabled with DISABLE KEYS -- so the unique
constraint isn't violated. From
http://www.mysql.com/doc/en/ALTER_TABLE.html
ALTER TABLE ... DISABLE KEYS makes MySQL to stop updating *non-unique*
indexes for MyISAM table.
Matt
- Original Message -
From
I am running mysql through a pipe with flags
-s -n -R -r
which works fine except a pipe read hangs when there is no data for a query. I
tried many things, nothing works.
Running on Linux with version 3.23,53
Thanks
Matt Young
--
MySQL General Mailing List
For list archives: http
but similiar capability
announced by IBM for DB2.
Matt Young
[EMAIL PROTECTED]
Saratoga, CA
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
The manual says:
For example, if the library is installed in `/usr/local/mysql/lib', use
-L/usr/local/mysql/lib -lmysqlclient -lz on the link command.
But I found no z library?
Matt Young
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
Emilio-
I ran into this problem just yesterday using some PHP code. The problem was in
control logic. I executed the insert within an if statement, but failed to see
that there was another mysql_query statement outside the if block. This caused
the same insert to happen again.
Basically, in
to be hit for reads.
BTW, I don't really know what memory mapped means... Surely this doesn't
mean data is kept in memory *by MySQL*?? A big compressed table would
take all your memory! Hmm.
Matt
- Original Message -
From: Gabriel Ricard
Sent: Thursday, October 09, 2003 7:09 PM
Subject
'.
Hope that helps.
Matt
- Original Message -
From: heath boutwell
Sent: Wednesday, October 08, 2003 3:15 PM
Subject: Innodb won't recognize index when optimizing query
The query optimizer will not recognize an index on an innodb table.
tranfer_logs is an innodb
table, auth_user
(SELECT * FROM table ORDER BY RAND() LIMIT 20) tbl_alias
ORDER BY col1
Matt
- Original Message -
From: Stuart M. Robinson
Sent: Tuesday, October 07, 2003 6:00 PM
Subject: Re: MySQL: Ordering Random Records
Folks,
Urgh, you know that feeling when you've burnt lots of cycles trying to
come
that IN is shorter and easier to parse than so many
ORs.
Matt
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
for Repair by
sorting (and I assume not for with keycache), maybe that is fairly CPU
intensive to sort the indexes -- and only writing an index chunk every
few seconds (I think).
Anyway, hope that helps.
Matt
- Original Message -
From: Ware Adams
Sent: Friday, October 03, 2003 7:49 PM
Subject
Hi Willem,
I don't *think* MySQL optimizes BETWEEN like that to use an index.
Have you tried this?:
SELECT * FROM ipcountry WHERE ip1 = 123456789 AND ip2 = 123456789;
Matt
- Original Message -
From: Willem Bison
Sent: Saturday, October 04, 2003 6:08 PM
Subject: ip range lookup
I
now the query isn't finishing executing and its killing my cpu...
any idea how to rebuild the index on a table?
or how to get out of this mess?
:-)
Thanks,
Matt
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
now the query isn't finishing executing and its killing my cpu...
any idea how to rebuild the index on a table?
or how to get out of this mess?
:-)
Thanks,
Matt
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
row_id as widget so I also want to
pull those out of the table too. I hope this makes some sense...
Thanks,
Matt
On Fri, 2003-10-03 at 20:14, Jeremy Zawodny wrote:
On Fri, Oct 03, 2003 at 04:23:56PM -0400, Matt Babineau wrote:
now the query isn't finishing executing and its killing my cpu
which is too long!
Any ideas?
Thanks,
Matt
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Yeah mysql is reading the config file, because I have set other options
like query_cache_size...so I'm not sure :-(
On Thu, 2003-10-02 at 18:09, Jeremy Zawodny wrote:
On Thu, Oct 02, 2003 at 02:02:34PM -0400, Matt Babineau wrote:
Hey All--
I have MySQL 4.0.14 running on Redhat Linux
arent' the same).
I've used NFS for database sharing before... in a production
environment. I've since switched to builtin mysql replication... and
prefer it 100x's more. It's easy to setup will do exactly what you
want.
Matt
On Wed, 2003-10-01 at 10:05, Eric Dickner wrote:
Hello All,
I want
index (type) from the query as there's nothing
in your example that would allow an index on type to be used anyway.
Thanks for any help anyone can give me - this is driving me nuts!
Yeah, see if indexing mid helps.
Funny little riddles in your sig BTW. :-D
Matt
--
MySQL General Mailing
Hi,
4.1.0 was released before 4.0.14 so it wouldn't have the new
functionality in it. It should be in 4.1.1 but hasn't been added to the
change-log yet.
Matt
- Original Message -
From: Director General: NEFACOMP
Sent: Monday, September 29, 2003 4:51 AM
Subject: Re: insert into x
= countries.countryid AND datein '$now' AND dateout
'$now' ORDER BY positionid ASC;
Basically I need to be able to produce a list of all the players that
appear in the first query ($teamqry) EXCEPT those that appear in the
second ($squadqry).
Help!?!?!??!
Thanks very much,
Matt
--
MySQL
Bang on, Emery. Works a treat. Thanks very much.
Matt
Director General: NEFACOMP wrote:
Using the Query of the players already selected build a list like :
$player_list=player1, player2, player3, ...;
and then use that list to not return selected ones
SELECT player_id FROM
types. I WANT IT CHAR!!! :-)
Well, now you know what I think... Destroy the silent CHAR - VARCHAR
change please! (VARCHAR(3) - CHAR is OK.)
Matt
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
the optimizer. STRAIGHT JOIN can be used in extreme cases where the
optimizer doesn't read the tables in the best order even though you've
listed them that way.
Matt
- Original Message -
From: Dan Nelson
Sent: Friday, September 26, 2003 8:11 PM
Subject: Re: Can someone explain the difference
Hi Daniel,
Yes, query_cache_type is 1 by default if you don't set it. :-) It's not
used by default, however, because query_cache_size is 0. You need to set
query_cache_size to 16M, 32M, etc.
Hope that helps.
Matt
- Original Message -
From: Daniel Kasak
Sent: Thursday, September 25
Uscript
Some months ago I developed a lightweight middle layer between MySql and the
web. The purpose was experimentation with web programming without the
complexity of a standard middleware layer. I will describe the system to you,
and make the source available if anyone wants to experiment
in a shared pool...
Matt
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
\binmysql
-OR-
C:\C:\mysql\bin\mysql
(Sorry if you already know how to do that. ;-))
And then when mysql quits, the window won't close but will stay there
and you can see what the error message is. Tell us what that error is.
Hope that helps.
Matt
- Original Message -
From: Charlie
. :-) e.g.
phone1SUF SMALLINT(n) UNSIGNED ZEROFILL NOT NULL
where n is the number of leading 0s to prepend if needed to make the
display n digits long. With this method, you *don't need* the leading 0s
in your PHP variable. So just
...SET phone1SUF = $tr_p1SUF...
Hope that helps.
Matt
Hi Randy,
4.1.1 hasn't been released yet unfortunately. The devs have said that
they've started release testing or whatever it's called. I think they
said it will hopefully be released in 4-6 weeks. :-)
Matt
- Original Message -
From: Randy Chrismon
Sent: Thursday, September 18, 2003
all of my transactions - managerid,
playerid, dateofpurchase, dateofsale
I need to select all players in the players table except those that
occur in the transactions table which match the 'managerid'.
I'm stuck! Any help would be greatfully received!
Matt
--
MySQL General Mailing List
Hi Tom,
Sounds odd... Do other queries that behave normally use GROUP BY or
DISTINCT? What are your configuration variables? e.g. SHOW VARIABLES or
mysqladmin variables. Is sort_buffer_size set to some huge value?
Matt
- Original Message -
From: [EMAIL PROTECTED]
Sent: Friday
a matching row or not. If there is a matching row, EXPLAIN will output
the usual columns of information.
Matt
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi,
myphp looks like it's pretty slow going by the times reported in the
examples. :-/ Probably something to do with all that PHP junk loaded
into MySQL. :-)
And no, I don't think you can do any stored procs with it; only apply
PHP functions etc. to database values.
Matt
- Original
would.
Matt
- Original Message -
From: electroteque
Sent: Wednesday, September 17, 2003 8:38 PM
Subject: Re: Lock tables in myisam
rollback works on myisam ? this is mysql4 anyway, sweet i'll give it a
try.
On Fri, 2003-09-19 at 08:01, Jeremy Zawodny wrote:
On Thu, Sep 18, 2003
in your WHERE clause to explicitly
group terms the way you want them evaluated.
Yeah, like
WHERE (cat_id=1 OR cat_id=2) AND ...
However, I just replied to say that it would be easier and cleaner
looking to use IN:
WHERE cat_id IN (1, 2) AND ...
:-)
Matt
--
MySQL General Mailing List
For list
Yep, verified here with .15-nt on Win2k. :-/
I'm sending this to the Bugs and General lists because I'm assuming it
affects all platforms; or is it only Windows?
Matt
- Original Message -
From: Fredrick Bartlett
Sent: Tuesday, September 16, 2003 7:40 PM
Subject: Re: (4.0.14) Corrupt
Hi Randy,
See here: http://www.mysql.com/doc/en/Gone_away.html
Maybe one of the queries in import_cash.sql is longer than
max_allowed_packet?
- Original Message -
From: Randy Chrismon
Sent: Monday, September 15, 2003 4:50 PM
Subject: LOAD Fails on Lost Connection
I've tried this
table that was
cached by the OS (as MySQL itself doesn't cache any data file contents)
will be forced out (again FIFO), causing it to be read from the hard
drive when you access it next time.
So yeah, I would think it's some kind of disk I/O slowdown.
Matt
--
MySQL General Mailing List
. Maybe your app does this and
mysqldump isn't.
Just some thoughts. :-) Hope that helps.
Matt
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
for reading. And thanks all your full-text work Sergei!
Matt
P.S. Is there a document somewhere that has information about the
internals of full-text search or MySQL in general? I noticed this bk
commit - mysqldoc tree (1.790) message on the Internals list the other
day:
http://lists.mysql.com
FT_MIN_WORD_LENGTH,
cannot be moved to runtime-configurable params? Obviously, changing
either setting would require a rebuild of the FT index(es), but then,
so
does FT_MIN_WORD_LENGTH...
I just wish ft_min_word_len would be 3 by *default*, so we wouldn't have
to change it. :-D
Matt
TIA
--
Shane
- Original Message -
From: Jeremy Zawodny
Sent: Monday, September 08, 2003 11:33 PM
Subject: Re: --skip-locking and 'enable locking' in my.cnf
On Mon, Sep 08, 2003 at 10:42:33PM -0500, Paul DuBois wrote:
See:
http://www.mysql.com/doc/en/System.html
Note the part about Linux.
Hi Donald,
Is the script possibly sending a query larger than max_allowed_packet
(1MB default)? Have you read http://www.mysql.com/doc/en/Gone_away.html
?
Matt
- Original Message -
From: Donald Tyler [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Tuesday, September
. :-( I think a full scan may be done on table2. This is
very bad if table2 has a lot of rows.
Matt
- Original Message -
From: Victoria Reznichenko [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, September 09, 2003 3:48 AM
Subject: Re: MySQL full text search multiple tables
Steve
to the command line client first.
BTW, The author of probably the best book ever written on MySQL frequently
responds to e-mails on this list. Some well intended advice, get his book
(MySQL Second Edition).
Regards, Matt
=-Original Message-
=Hi,
=
=I am using
another
LOCK TABLES, or when the connection to the server is closed.
BTW, you can't do INSERTs when the table(s) are locked with a READ lock.
;-) Need a WRITE lock for that.
Hope that helps.
Matt
- Original Message -
From: Steven Wu
Sent: Friday, September 05, 2003 4:57 PM
Subject
of ; at the end of
the EXPLAIN query to make the output more legible.
Matt
- Original Message -
From: Kevin Fries
Sent: Friday, September 05, 2003 11:09 AM
Subject: RE: Query hung up in Copying to tmp table
Matt,
Thanks for your response. It's going to take a bit for me to get the
actual
(rows and MB).
Matt
- Original Message -
From: Kevin Fries
Sent: Wednesday, September 03, 2003 6:51 PM
Subject: Query hung up in Copying to tmp table
I'm having a problem where a complex SELECT query begins eating up
lots
of CPU and never returns. In show processlist, it
reports
%' and not MATCH(...) AGAINST(...)?
Matt
- Original Message -
From: Mark [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, September 03, 2003 6:35 PM
Subject: Re: keeping a fulltext index in memory
Any chance you OS swapped out part of your key_buffer? See if any
of
mysqld's memory
idea to have shell access for
backup/restore. Else you'll have to ask the host to do it. A pain, if
they'll even do it. :-)
Matt
- Original Message -
From: Matthew K. Gold
Sent: Thursday, September 04, 2003 6:32 PM
Subject: web hosting/PHP MyAdmin
Hi,
I need to move my site to a host
Hi Mark,
How about just giving the user(s) only the SELECT privilege temporarily?
Matt
- Original Message -
From: Mark Swanson
Sent: Monday, September 01, 2003 7:33 PM
Subject: [q] can I start MySQL in READONLY mode?
Hello,
I have a situation where I'd like to do some debugging
you add indexes, we will need the output of
SHOW CREATE TABLE your_table;
for your table(s). Also need examples of queries that you're running.
Matt
- Original Message -
From: James Kelty
Sent: Tuesday, September 02, 2003 2:23 PM
Subject: Re: Many Read and Writes...
Ahhh! Ok, yeah
Hi Marty,
Yes, a query like this:
SELECT t1.* FROM table1 t1
LEFT JOIN table2 t2 ON (t2.id=t1.id)
WHERE t2.id IS NULL
This assumes that table2.id is defined as NOT NULL.
See also: http://www.mysql.com/doc/en/JOIN.html
Hope that helps.
Matt
- Original Message -
From: Martin Moss
affiliate_id='a280' AND afs.stat_date BETWEEN '2003-01-01' AND
'2003-09-31'
GROUP BY afs.stat_date
Hope that helps.
Matt
- Original Message -
From: Mike Morton [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, September 02, 2003 6:27 PM
Subject: Query not returning 0 count records
`,
-- Drop the PRIMARY KEY with 2 id columns
DROP PRIMARY KEY,
-- And re-add it with just one column
ADD PRIMARY KEY (id);
Hope that helps.
Matt
- Original Message -
From: Benjamin KRIEF
Sent: Sunday, August 31, 2003 7:40 PM
Subject: spaces in index name
hi all ,
i'm trying to improve
Roger
and Dan had already replied before me. :-)
matt : does mysql locks the table during the whole alter table
execution?
Yes, with a read lock on non-Windows systems. So the table can still be
read from but UPDATE/INSERT/DELETE queries will wait (and they will
block subsequent reads if they're
Hi,
- Original Message -
From: Eternal Designs, Inc
Sent: Saturday, August 30, 2003 9:46 PM
Subject: Re: Newbie Table question
To copy table A to table B(non-existent) use this command:
CREATE TABLE B SELECT * FROM A;
Note. If your two tables are from different databases the syntax
workaround. :-)
Hope that helps.
Matt
- Original Message -
From: Jay Paulson
Sent: Thursday, August 28, 2003 2:57 PM
Subject: Random Selects
Hello-
I'm trying to get random information out of my table and the query I'm
using keeps returning the same row every time. In the table I have 3
Hi Jesse,
- Original Message -
From: Jesse Sheidlower
Sent: Monday, August 25, 2003 8:26 AM
Subject: Explanation of multiple-column indexes
After some discussion in a separate thread, I've been trying
to get a better understanding of the workings of multiple-column
indexes, and think
') DEFAULT 'N' NOT NULL,
add Lock_tables_priv enum('N','Y') DEFAULT 'N' NOT NULL;
FLUSH PRIVILEGES;
(Everything seems to work except my guestbooks after the reinstall).
Not sure about that not working. :-/
Matt
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
supposed to have more
resources for faster development. Maybe some of these things will come
sooner than expected. That's what I'm hoping anyway.
Matt
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
. But UDF makes it sound like a separate thing that has to be loaded
with CREATE FUNCTION. But UDFs won't work with your MySQL binaries, will
they, since they're complied statically?
Looking forward to any comments from the developers and other users.
Thanks in advance!
Matt
--
MySQL General
connection available. It seems that an address is only
needed to connect to a separate MySQL box.
See also the first 2 paragraphs here in the manual:
http://www.mysql.com/doc/en/Can_not_connect_to_server.html
Hope that helps.
Matt
--
MySQL General Mailing List
For list archives: http
? If not, then why am I seeing
it that way? ;-) Any comments?
Matt
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
-Sent: Saturday, July 19, 2003 6:19 AM
-To: Matt Davies
-Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
-Subject: Re: Crash on mysql_real_connect on FreeBSD 4.7
-
-
-On Fri, 18 Jul 2003 14:22:13 -0600
-Matt Davies [EMAIL PROTECTED] wrote:
-
-
- Hey all,
-
- Have a very peculiar
Hey all,
Have a very peculiar problem. First off -
OS: FreeBSD 4.7
MySQL version: Ver 12.20 Distrib 4.0.13, for unknown-freebsd4.7 (i386)
(I have also compiled 3.23.53)
The problem:
I have written a class that connects to and disconnects from the database.
Everything works fine when I
?
Thanks
Matt Brei
Thanks,
I found it but I wasn't sure if it could be changed between my INSERT
and the SELECT LAST..() by another instance of my application.
I'll suck-it-and-see !
Matt
[EMAIL PROTECTED] wrote:
The good ol' LAST_INSERT_ID() function is what you probably need.
Check it
out in manual
come
along and insert a new entry between my SELECT and INSERT.
Because 'id' is the only guaranteed unique column, I cannot think of a
way to do a SELECT after an INSERT to get back the 'id' of the last
thing inserted.
Can anyone help ?
Matt
--
MySQL General Mailing List
For list archives
expected to see the
entire decimal stored correctly in the table.
-- Matt Solnit [EMAIL PROTECTED]
and end_date 2003-01-31
Sorry, I guess you're gonna have to be more specific. I could probably
sit here for 30 minutes reading your email over and over to
understand... but I would rather you be more clear on what you want.
But then again, I need another cup of coffee in me yet...
Matt
Well... if you were given a start date of 2003-01-01 and end date of
2003-01-31...
select *
from table_name
where start_date between 2003-01-01 and 2003-01-31
or end_date between 2003-01-01 and 2003-01-31
No?
Matt.
On Wed, 2003-04-02 at 16:32, Sarah Heffron wrote:
How would I do
I'm not sure if you can do it globally... but here is what I do:
select passwd
from blerg
where login = Matt
and binary login = Matt;
I do it twice b/c the binary operation is quite slow and doing the
normal equate first speeds it up significantly.
Doesn't exactly answer your question
, then I don't know, and would be
interested in the real answer.
Matt.
On Mon, 2003-03-31 at 13:21, Mike Doanh Tran wrote:
Hi,
Is there a way in mysql to get the
record's last updated date?
Thanks,
Mike
--
MySQL General Mailing List
For list archives: http://lists.mysql.com
on this to myodbc list in a day or so.
Thanks
~Wynne
-Original Message-
From: Adam Douglas [mailto:[EMAIL PROTECTED]
Sent: Monday, March 31, 2003 5:09 AM
To: 'Brei, Matt'; [EMAIL PROTECTED]
Subject: RE: Crystal Reports and MySQL
Sounds to me that you have some permission problems. I use
.
Matt
. I suspect it may use a temp table?
I've no experience of that either.
Thanks for any help.
--
Matt Johnson
__
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.com
MySQL connection id is 1 to server version: 4.0.10-gamma-embedded
mysql SHOW PROCESSLIST;
Empty set (0.00 sec)
mysql KILL 1;
ERROR 1094: Unknown thread id: 1
---
My contact information:
---
Matt Solnit [EMAIL PROTECTED
401 - 500 of 661 matches
Mail list logo