= useronline.uname AND
penpals_fav.user_id = $colname
AND penpals.privmsgs_block.something IS NULL
Regards,
Mike Hillyer
www.vbmysql.com
-Original Message-
From: vernon [mailto:[EMAIL PROTECTED]
Sent: Monday, June 23, 2003 8:42 AM
To: [EMAIL PROTECTED]
Subject: SQL query - 3 tables - 3rd one
it more clear?
Regards,
Mike Hillyer
www.vbmysql.com
-Original Message-
From: Efficient E [mailto:[EMAIL PROTECTED]
Sent: Monday, June 23, 2003 8:50 AM
To: Mike Hillyer; [EMAIL PROTECTED]; MySQL-Lista
Subject: RE: varchar restriction
not sure I understand your relpy Mike
do you
Take a look at the REPLACE() function:
http://www.mysql.com/doc/en/String_functions.html#IDX1202
Regards,
Mike Hillyer
www.vbmysql.com
-Original Message-
From: Nick Stuart [mailto:[EMAIL PROTECTED]
Sent: Monday, June 23, 2003 8:58 AM
To: MySQL List
Subject: Replacing text on query
Perhaps you better watch your language and better explain your question
because if I did not answer your question than I do not know what you
are asking.
Regards,
Mike Hillyer
www.vbmysql.com
-Original Message-
From: Andrew [mailto:[EMAIL PROTECTED]
Sent: Monday, June 23, 2003 9:24
the
block information form the block table, or NULL. The try putting the
AND penpals_privmsgs_block.blocked_id IS NULL
line back in?
Regards,
Mike Hillyer
www.vbmysql.com
-Original Message-
From: vernon [mailto:[EMAIL PROTECTED]
Sent: Monday, June 23, 2003 9:26 AM
To: [EMAIL
Then you do need it, but like Paul said, you need MySQL 4.x, or you need
to run two queries, one to retrieve the row you want to update, and one
to do the update.
Regards,
Mike Hillyer
www.vbmysql.com
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Monday
It is definitely possible, see
http://www.mysql.com/doc/en/Multiple_servers.html
Of course, you could save yourself some trouble and just setup a
separate database on the same instance.
Regards,
Mike Hillyer
www.vbmysql.com
-Original Message-
From: electroteque [mailto:[EMAIL
subscribe to the MyODBC list at lists.mysql.com
Here's a sample linked to from the MyODBC FAQ:
http://www.devarticles.com/art/1/50
Regards,
Mike Hillyer
www.vbmysql.com
-Original Message-
From: Jorge Cornejo [mailto:[EMAIL PROTECTED]
Sent: Friday, June 20, 2003 1:44 AM
To: [EMAIL
You need only ask once.
This article by Paul Dubois may help
:http://www.kitebird.com/articles/mysql-xml.html
This Google search resulted in hundreds of resources:
http://www.google.com/search?hl=enedition=caq=convert+xml+to+mysqlbtn
meta%3Dsearch%3Dsearch=Search+the+Web
Regards,
Mike Hillyer
If you have queries that are only selects, in small tables, with few
rows, you should have very fast performance as is. Are your queries
properly indexed? What hardware are you running on? What do these
queries look like?
Regards,
Mike Hillyer
www.vbmysql.com
-Original Message-
From
guess.
Regards,
Mike Hillyer
www.vbmysql.com
-Original Message-
From: Mojtaba Faridzad [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 19, 2003 9:16 AM
To: [EMAIL PROTECTED]
Subject: selecting PRIMARY KEY when there is no unique value
Hi,
In a docuement such as Invoice Form, we
mailto:[EMAIL PROTECTED]
This is what I found at lists.mysql.com
Regards,
Mike Hillyer
www.vbmysql.com
-Original Message-
From: Luis Enrique Bauzá Peña [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 19, 2003 10:00 AM
To: Lista Mysql Inglés
Subject: Help me!!!
Hi, I need some
. If so you better
post what the table looks like.
Regards,
Mike Hillyer
-Original Message-
From: vernon [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 19, 2003 1:25 PM
To: [EMAIL PROTECTED]
Subject: RE: Complex SQL involving 10 checkboxes
OK, I've done this.
Problem occurs
the last or
and replace it with an and, you are always Ok for what follows.
-Original Message-
From: vernon [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 19, 2003 1:49 PM
To: Mike Hillyer
Subject: RE: Complex SQL involving 10 checkboxes
if (isset($HTTP_GET_VARS['check00
Well, from what limited info I have, it looks like your image tag is not
closed properly.
Regards,
Mike Hillyer
www.vbmysql.com
-Original Message-
From: Rolf C [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 19, 2003 2:57 PM
To: [EMAIL PROTECTED]
Subject: SQL query question
DROP TABLE tablename;
ALTER TABLE tablename RENAME newname;
http://www.mysql.com/doc/en/ALTER_TABLE.html
http://www.mysql.com/doc/en/DROP_TABLE.html
Regards,
Mike Hillyer
www.vbmysql.com
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 18
performance at a great price. I would also look at
Opteron based servers if you are looking for performance for a good
price.
Regards,
Mike Hillyer
www.vbmysql.com
-Original Message-
From: David Griffiths [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 17, 2003 10:59 AM
To: [EMAIL PROTECTED
,
Mike Hillyer
www.vbmysql.com
A significant question remains for SATA: basic drive
reliability. Related
to that is length of time drive will remain available. A
dirty secret of
RAID is that when a drive goes it must be replaced you must replace it
with the same drive (please..please
This is a know bug that has been addressed in version 4.0.13, you will
need to upgrade.
See http://bugs.mysql.com/bug.php?id=164
Regards,
Mike Hillyer
www.vbmysql.com
-Original Message-
From: Shane Kirk [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 17, 2003 12:25 PM
To: [EMAIL
What you need to do is specify username in your select query and JOIN
the two tables together.
Marks table:
User_id | Marks
User Table
User_id | Name
Query:
SELECT User.Name, Marks.Marks FROM User, Marks WHERE User.User_id =
Marks.User_id
Regards,
Mike Hillyer
www.vbmysql.com
Did you GRANT SHOW DATABASES to the user? If not then they will not be
able to use the command. The SHOW DATABASES GRANT clause is a new
addition.
Regards,
Mike Hillyer
www.vbmysql.com
-Original Message-
From: Ronan Lucio [mailto:[EMAIL PROTECTED]
Sent: Friday, June 13, 2003 8:34 AM
GRANT SHOW DATABASES will allow a user to see all databases, whether the
user can access them or not.
-Original Message-
From: Ronan Lucio [mailto:[EMAIL PROTECTED]
Sent: Friday, June 13, 2003 8:56 AM
To: Mike Hillyer
Cc: [EMAIL PROTECTED]
Subject: Re: Access denied
Mike,
On Fri, 13
)
order by field1,field2,field3
Regards,
Mike Hillyer
www.vbmysql.com
-Original Message-
From: H M Kunzmann [mailto:[EMAIL PROTECTED]
Sent: Friday, June 13, 2003 10:33 AM
To: [EMAIL PROTECTED]
Subject: fulltext searching and query order question
Hi all.
I have a fulltext index on a table
,
Mike Hillyer
www.vbmysql.com
-Original Message-
From: Varghonan [mailto:[EMAIL PROTECTED]
Sent: Friday, June 13, 2003 10:36 AM
To: [EMAIL PROTECTED]
Subject: Please help me!
Hi!
I am new here and wonder if anyone could help me with a problem in my community.
The adress is http
That depends, do you have a backup tape? ;)
Unfortunatly a DELETE is a one-way trip. In theory the data is still
there is the spot on the hard-drive has not been overwritten, but there
are no tools (that I know of) to retrieve that row.
Regards,
Mike Hillyer
www.vbmysql.com
-Original Message
Subselects such as this are only available in MySQL 4.1 and higher. You
can upgrade, or rewrite this query as follows:
SELECT tblSiteConfig.fldSiteID
FROM tblSiteConfig, tblServerConfig
WHERE tblSiteConfig.fldServerName = tblServerConfig.fldServerName
Regards,
Mike Hillyer
www.vbmysql.com
SELECT * FROM mytable WHERE LENGTH(phone) 10;
http://www.mysql.com/doc/en/String_functions.html
Regards,
Mike Hillyer
www.vbmysql.com
-Original Message-
From: Susan Ator [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 12, 2003 11:23 AM
To: [EMAIL PROTECTED]
Subject: query question
Use the ALTER TABLE syntax, see
http://www.mysql.com/doc/en/ALTER_TABLE.html
Regards,
Mike Hillyer
www.vbmysql.com
-Original Message-
From: Wong Zach-CHZ013 [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 12, 2003 3:43 PM
To: 'Paul DuBois'; [EMAIL PROTECTED]
Subject: DATE
Hi
How do I
generates temporary tables for some complicated joins, as in
these cases MySQL trusts that the data did fit into the original column
width.
--END QUOTE--
Regards,
Mike Hillyer
-Original Message-
From: Mojtaba Faridzad [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 10, 2003 11:26 AM
certification tests are a brain-dump, but hey,
most HR people do not have the knowledge to check whether you know what
the job descriptions need to know, so you have to have something to show
you meet the requirements in a job description.
Regards,
Mike Hillyer
www.vbmysql.com
-Original Message
and inventory tables be innodb and take advantage of
transactions, but keep your log tables in MyISAM for extra speed and
fulltext searching (just an example).
Regards,
Mike Hillyer
www.vbmysql.com
-Original Message-
From: Mojtaba Faridzad [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 10, 2003
It depends on what you want to do with the font end. You would always
look at MyCC and SQLyog at
http://www.mysql.com/products/mysqlcc/index.html and
http://www.webyog.com/ respectively.
Regards,
Mike Hillyer
www.vbmysql.com
-Original Message-
From: David Brodbeck [mailto:[EMAIL
Try TRUNCATE TABLE tablename--http://www.mysql.com/doc/en/TRUNCATE.html
Or DELETE FROM tablename
Regards,
Mike Hillyer
www.vbmysql.com
-Original Message-
From: Fabio Bernardo [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 10, 2003 3:33 PM
To: Mysql (E-mail)
Subject: empty a table
Addslashes()
http://us3.php.net/manual/en/function.addslashes.php
-M
-Original Message-
From: Steve Marquez [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 10, 2003 4:28 PM
To: MySQL List; PHP eMail List
Subject: Characters
I am inserting a file via a PHP form. It works great, however,
You may find that it is the index that is slowing you down. Have you
tried disabling the index(s) on your table before the delete and
re-enabling them after?
Regards,
Mike Hillyer
www.vbmysql.com
-Original Message-
From: Todd Gruben [mailto:[EMAIL PROTECTED]
Sent: Monday, June 09, 2003
SELECT * FROM table ORDER BY id DESC LIMIT 1;
Regards,
Miek Hillyer
www.vbmysql.com
-Original Message-
From: Chris Edwards [mailto:[EMAIL PROTECTED]
Sent: Monday, June 09, 2003 12:23 PM
To: MySQL List
Subject: fastest way to get last row
Hi
Does anyone have tips on the fastest way
Well, that would be TEXT, MEDIUMTEXT, or LARGETEXT, they hold 65535,
16777215, and 4294967295 characters accordingly.
I personally would stick to TEXT, maybe MEDIUMTEXT.
Regards,
Mike Hillyer
www.vbmysql.com
-Original Message-
From: DuSTiN KRySaK [mailto:[EMAIL PROTECTED]
Sent
Why not just specify what columns you are inserting into? This check has
to be in place, because in the case of a mismatch MySQL would not know
which value goes into which column.
Regards,
Mike Hillyer
www.vbmysql.com
-Original Message-
From: Campbell D. McCausland [mailto:[EMAIL
,
Mike Hillyer
www.vbmysql.com
-Original Message-
From: Sparky Kopetzky [mailto:[EMAIL PROTECTED]
Sent: Monday, June 09, 2003 1:43 PM
To: My Sql List
Subject: SSL and Windows
Does anyone know how to turn the SSL on for mySql for Windows?? I need
to encrypt and decrypt certain items
There is no way to turn it off (well, no practical way, with open source
nothing is impossible).
Can you add dummy columns to the mysql table to the insert statements
match up?
Regards,
Mike Hillyer
www.vbmysql.com
-Original Message-
From: Campbell D. McCausland [mailto:[EMAIL PROTECTED
,
create tables, just the basic functions on their database only. Multiple
databases are hosted on the same mysql server.
Thank you for your help in these questions.
Mike Walth
CinoFusion
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
That should work just fine (although you should end the line with ; and
not l)
Regards,
Mike Hillyer
www.vbmysql.com
-Original Message-
From: Anthony Ward [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 05, 2003 3:54 AM
To: [EMAIL PROTECTED]
Subject: load file
Hi,
I have a a text
Can you show some table structure so we have something work with? It's
hard to recommend a query when we do not know what your sales table
structure is.
Regards,
Mike Hillyer
www.vbmysql.com
-Original Message-
From: Ralph [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 04, 2003 4:00 PM
' AND
clicks.affiliate_stores_id = '123' AND
MONTH(clicks.affiliate_clientdate) = '06' AND
YEAR(clicks.affiliate_clientdate) = '2003' GROUP BY date;
Does that do what you are looking for?
Regards,
Mike Hillyer
www.vbmysql.com
-Original Message-
From: Ralph [mailto:[EMAIL PROTECTED]
Sent: Thursday, June
are looking for, otherwise let us know.
Regards,
Mike Hilyer
www.vbmysql.com
-Original Message-
From: Anthony Ward [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 05, 2003 12:17 PM
To: [EMAIL PROTECTED]
Subject: Join question
Hi,
I have posted a similar question, but can't find
Syntax only.
INNER JOIN table2 USING (id)
INNER JOIN table3 USING (id)
Equates to
table1.id = table2.id
AND table2.id = table3.id;
Regards,
Mike Hillyer
www.vbmysql.com
-Original Message-
From: Anthony Ward [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 05, 2003 12:53 PM
Take a look at SQLyog http://www.webyog.com/
It has a pretty solid import utility for importing from databases such
as SQL server.
Regards,
Mike Hillyer
www.vbmysql.com
-Original Message-
From: Karma Dorji [mailto:[EMAIL PROTECTED]
Sent: Friday, June 06, 2003 3:34 AM
To: [EMAIL
(StartDate) = 30;
Regards,
Mike Hillyer
www.vbmysql.com
-Original Message-
From: Trevor Sather [mailto:[EMAIL PROTECTED]
Sent: Friday, June 06, 2003 1:34 PM
To: [EMAIL PROTECTED]
Subject: Help with Date Range Query
Hello,
Any idea why the following doesn't work? It's taken from
Aah, I stand corrected. Friday afternoon is not my best day to be
answering questions on here. ;)
Regards,
Mike Hillyer
www.vbmysql.com
-Original Message-
From: Keith C. Ivey [mailto:[EMAIL PROTECTED]
Sent: Friday, June 06, 2003 1:59 PM
To: [EMAIL PROTECTED]
Subject: RE: Help with Date
You can always catch the Duplicate Key error and respond accordingly in
your PHP script.
Regards,
Mike Hillyer
www.vbmysql.com
-Original Message-
From: Steve Marquez [mailto:[EMAIL PROTECTED]
Sent: Friday, June 06, 2003 1:41 PM
To: MySQL List
Cc: PHP eMail List
Subject: Duplicate
Drop the second ORDER BY clause in favor of a comma.
ORDER BY table1.time_created DESC, table1.name LIMIT 50
Regards,
Mike Hillyer
www.vbmysql.com
-Original Message-
From: Dave Terrio [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 04, 2003 7:38 AM
To: [EMAIL PROTECTED]
Subject
to take away
the first select and the union statement, I am not sure.
Regards,
Mike Hillyer
www.vbmysql.com
-Original Message-
From: Dave Terrio [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 04, 2003 8:27 AM
To: Mike Hillyer
Subject: RE: nested ORDER BY statements
Thanks
I had a little time to test, and this should work fine without the UNION
(SELECT * FROM table1 ORDER BY table1.time_created DESC LIMIT 50)
ORDER BY table1.name;
Regards,
Mike Hillyer
www.vbmysql.com
-Original Message-
From: Mike Hillyer
Sent: Wednesday, June 04, 2003 8:41 AM
To: Dave
SubSelects are allowed in MySQL 4.1, but not in any earlier versions. If
I recall what rownum is (a number generated to represent the rownum of
the returned data set), it has no equivalent in MySQL, as the LIMIT
clause is available.
Regards,
Mike Hillyer
www.vbmysql.com
-Original Message
hello all,
sorry for the newbe question, but want is the correct command line sytax to
restore table data from a file, table_name.sql
each of our .sql files contains all the table structure and insert data and we
need to restore a whole bunch of tables and data.
TIA
--
MikemickaloBlezien
The SOURCE command will allow you to execute files in batch mode:
Mysql SOURCE table_name.sql;
Check http://www.mysql.com/doc/en/Batch_mode.html
For more info.
Regards,
Mike Hillyer
www.vbmysql.com
-Original Message-
From: Mike Blezien [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 03
Thanks, that exactly what I was looking for. been battle all nite with a crashed
server and trying to get everything back up... appreciate the help. :)
Mike Hillyer wrote:
The SOURCE command will allow you to execute files in batch mode:
Mysql SOURCE table_name.sql;
Check http://www.mysql.com
UPDATE mytable SET email = CONCAT(LEFT(email,LENGTH(email) - 4),.ca)
WHERE RIGHT(email,8) = test.com;
Something like that?
Regards,
Mike Hillyer
www.vbmysql.com
-Original Message-
From: Grant Cooper [mailto:[EMAIL PROTECTED]
Sent: Sunday, June 01, 2003 2:39 PM
To: [EMAIL PROTECTED
auto_increment values can cause all kinds of trouble. Besides, an
unsigned BIGINT can store so much data there is really no need to get
into auto_increment reuse.
Regards,
Mike Hillyer
www.vbmysql.com
-Original Message-
From: Daniel Crompton [mailto:[EMAIL PROTECTED]
Sent: Monday, June 02, 2003
Wouldn't you just type SELECT.LIMIT 10,10 ??
Mike Hillyer
www.vbmysql.com
-Original Message-
From: Anthony Ward [mailto:[EMAIL PROTECTED]
Sent: Monday, June 02, 2003 11:21 AM
To: [EMAIL PROTECTED]
Subject: Row Number
Hi,
If i have a table with just Userid,Name,Language
What column is MySQL complaining about being ambiguous? Isn't it just a
matter of adding tablename. To the start of the guilty column?
Mike Hillyer
www.vbmysql.com
-Original Message-
From: Peter J. Milanese [mailto:[EMAIL PROTECTED]
Sent: Monday, June 02, 2003 11:25 AM
To: [EMAIL
by count DESC
limit 10
That should do it, right?
Regards,
Mike Hillyer
www.vbmysql.com
-Original Message-
From: Peter J. Milanese [mailto:[EMAIL PROTECTED]
Sent: Monday, June 02, 2003 12:23 PM
To: Mike Hillyer
Cc: [EMAIL PROTECTED]
Subject: RE: Suggestions on joins/merges
and type='sessions_unk'
That will return three rows, which your application logic could add
together.
Mike Hillyer
www.vbmysql.com
-Original Message-
From: Peter J. Milanese [mailto:[EMAIL PROTECTED]
Sent: Monday, June 02, 2003 1:27 PM
To: Mike Hillyer
Cc: [EMAIL PROTECTED]
Subject: RE
You need a LEFT JOIN.
SELECT blah, blah, blah
FROM bite bite LEFT JOIN person agency ON agency.person_id =
bite.bite_agency_id
WHERE bite.bite_id = AC-2003-0004;
Check out http://www.mysql.com/doc/en/JOIN.html to learn more about LEFT
JOIN.
Regards,
Mike Hillyer
www.vbmysql.com
-Original
.
There are multiple db's on the server, and only one user per db, and they
only need the basic privilges, i.e. create tables, select, insert, etc.
Your help is greatly appreciated.
Mike Walth
CinoFusion
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
Try something like SELECT formatted_date FROM mytable WHERE
formatted_date BETWEEN '04-08-2003' and '07-08-2003';
Or something along those lines, I would get more specific but I do not
have specific information to go from.
Regards,
Mike Hillyer
www.vbmysql.com
-Original Message-
From
Hi... silly question maybe.
I want to execute the following query:
mysql_query(SELECT MIN(order), MAX(order) FROM downloads WHERE class='1');
...but it doesn't work and gives me a SYNTAX ERROR. If I use my 'id' column
(the primary key) instead of the 'order' column, it works fine:
Yes, a few days after posting this the MySQL site finally came out with
some useful information on the subject. Should be interesting to see
where this goes.
Mike Hillyer
www.vbmysql.com
-Original Message-
From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 29, 2003 9:04
Subqueries are only available in MySQL 4.1. However, you should be able
to write this as follows:
UPDATE test1 a, test2 b SET a.visit_date = NOW() WHERE a.id = b.id AND
b.code = 'Z';
Regards,
Mike Hillyer
www.vbmysql.com
-Original Message-
From: Terry Spencer [mailto:[EMAIL PROTECTED
I would suggest myCC -- http://www.mysql.com/downloads/mysqlcc.html
Regards,
Mike Hillyer
www.vbmysql.com
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 28, 2003 6:45 AM
To: [EMAIL PROTECTED]
Subject: Creating a Table (wot no GUI?)
Excuse my
Export the worksheet to CSV and use the LOAD DATA command in MySQL to
import it. That is how I import all but my most complex excel
spreadsheets.
Mike Hillyer
www.vbmysql.com
-Original Message-
From: D Crompton [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 28, 2003 9:51 AM
To: [EMAIL
/en/UNION.html
http://www.mysql.com/doc/en/JOIN.html
Mike Hillyer
www.vbmysql.com
-Original Message-
From: Terry Spencer [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 28, 2003 9:44 AM
To: Mike Hillyer; MySQL (E-mail)
Subject: RE: Update in select
Thanks for the help, that close
I know MySQL CC can place a text or image blob into the database, might
be worth a look.
Mike Hillyer
www.vbmysql.com
-Original Message-
From: Thomas Hoelsken [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 27, 2003 10:54 AM
To: [EMAIL PROTECTED]
Subject: How to fill an Blob with binary
Like I said, for Image and text blobs, use MyCC and it should work.
Mike Hillyer
www.vbmysql.com
-Original Message-
From: Adam Clauss [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 27, 2003 11:18 AM
To: [EMAIL PROTECTED]
Subject: RE: How to fill an Blob with binary data
I am in need
In what language?
Mike Hillyer
www.vbmysql.com
-Original Message-
From: Adam Clauss [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 27, 2003 11:30 AM
To: Mike Hillyer; [EMAIL PROTECTED]
Subject: RE: How to fill an Blob with binary data
In my case, its neither. Some random binary data
From [EMAIL PROTECTED] Wed Apr 2 17:09:15 2003
At 16:53 -0500 4/2/03, Mike South wrote:
In load testing I noticed that, even though all the queries in the
tests are for the exact same tables, at some point in the test
the Open_files variable (from SHOW STATUS) drops very quickly. Does
anyone
From [EMAIL PROTECTED] Wed Apr 2 17:12:36 2003
In the last episode (Apr 02), Mike South said:
In load testing I noticed that, even though all the queries in the
tests are for the exact same tables, at some point in the test
the Open_files variable (from SHOW STATUS) drops very quickly
In load testing I noticed that, even though all the queries in the
tests are for the exact same tables, at some point in the test
the Open_files variable (from SHOW STATUS) drops very quickly. Does
anyone have any idea what would cause that?
mike
--
MySQL General Mailing List
For list
any
error messages anywhere. I still need to give it a few days, but at the
moment I am thinking that somehow, for reasons I don't really understand,
raising ulimit -u fixed the problem.
If it didn't, I will probably be back on the mailing list in a couple days. :)
Thanks,
Mike
At 02:42 PM 3/31
would explain why in my initial post the ceiling I was
complaining about was 251.
Good luck to anyone in the future who has this same problem. I hope you
are able to find this thread in the archives!
Mike
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
|
| Connections | 60980 |
| Threads_cached | 5 |
| Threads_created | 4303 |
| Threads_connected| 86 |
| Threads_running | 1 |
If anyone has any ideas, please let me know. Thanks!
Mike
--
MySQL General Mailing List
., both max_used_connections and the
number of sleeping/persistent connections both shot right back up to their
ceiling level of ~250. Any thoughts on this?
Thanks again for your help,
Mike
P.S. For anyone who's interested, the whole thread so far is reprinted below:
On 31-Mar-2003 Mike
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/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
version of any software usually has some bugs and a lot of ISP
and other software hosting companies will wait for a few updates to be
implimented into the code to patch any holes that weren't noticed at launch.
Other than that, you really do have to ask your ISPs.
-Mike
-Original Message-
From
- and if you
need the data to conform to a specific set, then you can easily check it
against an array of valid responses.
Just my $.02.
-Mike
-Original Message-
From: Bhavin Vyas [mailto:[EMAIL PROTECTED]
Sent: Sunday, March 30, 2003 9:01 PM
To: warm-fusion; [EMAIL PROTECTED]
Subject: Re
or
password (the fields are completely blank) under generic hosts (localhost,
etc). Should I delete these?
Thanks,
-Mike
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
.
Mike Hillyer
-Original Message-
From: Prabu Subroto [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 25, 2003 2:35 PM
To: [EMAIL PROTECTED]
Subject: Re: Allowing a user to change their password
I suggest you to make a special application for this
operation. With three-tier architecture
://www.fulcrum.org/gsg/with_sar/db01p/testdata/3.20.21.34/show_variables
mike south
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request
The topmost query in a series of queries, each connected by UNION ALL, dictates
the allocated space for data in each column for the resulting row set! This is
very bad - and makes the UNION useless.
Is there some database option that will make a UNION behave properly in mySQL?
See msg 135092
JOIN Users ON Cars.UserID = Users.UserID
WHERE Users.UserId='2'
ORDER BY 'Cars!2!CarID!hide',
'User!1!UserID!hide',
Tag
;
This example references these setup scripts:
http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:mss:135092
-Mike
Hello MySQL Guru's-
This is regarding UNION support in MySQL 4.0.12.
The query below is attempting to return rows that can
be easily parsed for the purposes of creating XML.
The ORDER BY is not being processed properly at the
end of the query. Sample scripts are shown below, to
setup the DB and
understand why top-level
users with global privs can access the database when the restricted
users cannot.
please advise, and feel free to request more data. Thank you for your time!
--
Mike Whybark - [EMAIL PROTECTED]
http://mike.whybark.com
Hello all,
we will be upgrading our current MySQL version 3.23.40 to 3.23.55, compiled from
source. We've always had good luck on our machine compiling from the source as
opposed to using binaries.
my question is, I was told, that using the --enable-thread-safe-client when
compiling was a
the
compressed protocol(producing OPTION=18475), it is especially useful when
dealing with blobs.
Mike Hillyer
http://www.dynamergy.com/mike
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
Sent: Friday, March 14, 2003 8:43 AM
To: Tamayo, Nelson
Cc: '[EMAIL PROTECTED
mysqldump dbname | grep 'text'
Keith Roberts wrote:
I need to look in several different tables/columns in a database for a
particular value. If I find it, I need to update it. Is there any way to
search/update every table/column in one query in a particular database?
--
Keith Roberts
IT
Ok, lessee...
SELECT user.user_id, user_name, user_history FROM user, history
WHERE user_history LIKE %58% AND user.user_id = history.user_id;
That should do what you need, lemme know.
Mike Hillyer
http://www.dynamergy.com/mike
-Original Message-
From: [EMAIL PROTECTED] [mailto
Well, if this is a one-time batch transfer then a simple
UPDATE abctable SET SomethingDate IS NULL when SomethingDate = '-00-00';
should null all the fields in question. Of course, you have to have a
NULLable date field.
Regards,
Mike Hillyer
http://www.dynamergy.com/mike
-Original
(Activity Date) = '2003-01-01'
) AS T1
ON
Activity.License Number = T1.License Number and
Activity.Activity Date = T1.Activity Date
cut here
Any help would be appreciated.
Thanks,
Mike Hillyer
http://www.dynamergy.com/mike
www.astatech.com and ZEOS components.
-Original Message-
From: Liu Qianghua-qch1942 [mailto:[EMAIL PROTECTED]
Sent: Saturday, March 01, 2003 11:50 PM
To: [EMAIL PROTECTED]
Subject: How to connect to mysql server without myODBC
All,
I want to develop application with Delphi which can
I am new to MySQL ( Converting from MS SQL )
Any how I currently have a productions server running Mac OS 10.2.4
MySQL 3.23 and the latest version of PHP.
I was wondering when to start working with the 4.xx version of MySQL?
When should I start developing for it when should I upgrade the
701 - 800 of 1406 matches
Mail list logo