. If not, take the necesscary steps
now to ensure that your system is not infected.
--
Mike Hillyer, Technical Writer
MySQL AB, www.mysql.com
Office: +1 403-380-6535
Mobile: +1 403-330-0870
MySQL User Conference (Santa Clara CA, 18-21 April 2005)
Early registration until February 28: www.mysqluc.com
It sounds like you want the LOAD DATA function, found at
http://dev.mysql.com/doc/mysql/en/LOAD_DATA.html
As long as there is some wat of distinguishing the two fields in the
file, you can load them into MySQL.
Mike Hillyer
Robin Lynn Frank wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash
! Canada Personals
Why wouldn't you just use ODBC to connect to the server and work
directly? Remotely initiating a perl script would involve creating a
telnet or SSH session from within Excel using VBA, which would be a far
more complex undertaking.
--
Mike Hillyer, Technical Writer
MySQL AB
,
Scott Purcell
--
Mike Hillyer, Technical Writer
MySQL AB, www.mysql.com
Office: +1 403-686-
The Open Source movement has become a major force across the software
industry, and MySQL is the world's most popular open source database.
--Fortune Magazine
--
MySQL General Mailing List
For list
I would say easiest is best. There is no specific field for
uniqueidentifier.
Mike Hillyer
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
encourage you to post your photos in the gallery. I hope
everyone can benefit from this!
Regards,
Mike Hillyer
www.vbmysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
.
VBMySQLDirect is available at http://projects.vbmysql.com/vbmysqldirect
Regards,
Mike Hillyer
www.vbmysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
. VBMySQLDirect
uses a more recent MySQL API as it's basis as well and therefore
supports more recent functionality than MyVbQl.
VBMySQLDirect is available at http://projects.vbmysql.com/vbmysqldirect
Regards,
Mike Hillyer
www.vbmysql.com
--
MySQL General Mailing List
For list archives: http
be useful even to those who do not use VB as their language of
choice. I hope you like it!
Regards,
Mike Hillyer
www.vbmysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
and also covers opening and closing SSH tunnels from within Visual
Basic.
In any case, I hope you find these of use!
Regards,
Mike Hillyer
www.vbmysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
You are correct. I interpreted Function or a procedure to be the
questioner referring to stored procedures with two seperate terms.
Mike Hillyer
-Original Message-
From: Dan Nelson [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 25, 2003 8:06 PM
To: mike
Cc: [EMAIL PROTECTED
I know this is a little off-topic, but I have been approached to do some
consulting to move an ISAM based app to MySQL. The potential customer is
asking an hourly rate but as I have not done MySQL work as a consultant I am
not sure what to charge.
Any Ideas?
Thanks,
Mike Hillyer
www.vbmysql.com
Hi all;
I was given a query today of the following:
SELECT record_id, record_title,artist_name,label_name,record_catalog
FROM record_profile
LEFT JOIN artist_profile,label_profile
ON record_profile.artist_id = artist_profile.artist_id OR
record_profile.label_id = label_profile.label_id
GROUP BY
At this point it is pure academic curiousity. I am putting together a cheap
cluster to play with shared drive failover, and thought I would see what
happens when I point two MySQL machines at the same drive while I'm at it.
Mike
-Original Message-
From: Jeremy Zawodny [mailto:[EMAIL
in a shared disk cluster? If not, would this ever be on a to-do
list or is it too much trouble to implement?
Thanks,
Mike Hillyer
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Conceptually, SERIALIZABLE just adds LOCK IN SHARE MODE to every SELECT
query. Other than that there is not much difference.
Regards,
Mike Hillyer
www.vbmysql.com
-Original Message-
From: Bill Todd [mailto:[EMAIL PROTECTED]
Sent: Monday, September 08, 2003 7:13 PM
To: [EMAIL
Sure, use the --all-databases option instead of $DBNAME
http://www.mysql.com/doc/en/mysqldump.html
Regards,
Mike Hillyer
www.vbmysql.com
-Original Message-
From: René Mølsted [mailto:[EMAIL PROTECTED]
Sent: Monday, September 08, 2003 11:51 AM
To: [EMAIL PROTECTED]
Subject: Backing
And will you be making your deadline? ;)
-Original Message-
From: Heikki Tuuri [mailto:[EMAIL PROTECTED]
Sent: Monday, September 08, 2003 10:38 AM
To: [EMAIL PROTECTED]
Subject: Re: Innodb multiple tablespaces
Sean,
I am at this very moment programming them :). The deadline
Well, I saw your message.
Regards,
Mike Hillyer
www.vbmysql.com
-Original Message-
From: Jay Blanchard [mailto:[EMAIL PROTECTED]
Sent: Monday, September 08, 2003 7:46 AM
To: [EMAIL PROTECTED]
Subject: Has the list gone down...
I haven't gotten any e-mails from the list
After a few too many bad questions, I wrote something on a similar vein,
but a little shorter:
http://www.vbmysql.com/mike/blog/archives/11.php
Regards,
Mike Hillyer
www.vbmysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
.
Thanks,
Mike Hillyer
www.vbmysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
UPDATE mytable SET mytext = REPLACE(mytext,'','');
Assuming you wised to strip a double quote, modify to suit.
Regards,
Mike Hillyer
www.vbmysql.com
-Original Message-
From: Dean Householder [mailto:[EMAIL PROTECTED]
Sent: Monday, July 21, 2003 2:49 PM
To: [EMAIL PROTECTED
You have to search for 'string functions' to find it. Problem is that a
search for REPLACE will bring up the REPLACE syntax, not the REPLACE()
syntax (not the brackets ;-) )
Regards,
Mike Hillyer
www.vbmysql.com
-Original Message-
From: Dean Householder [mailto:[EMAIL PROTECTED]
Sent
the invoice number will not be unique, and
the detail number will not be unique, but the combination of the two will be).
As for question #2, if two fields, one on each table, will be used to join tables
together, both fields should be indexed.
Regards,
Mike Hillyer
www.vbmysql.com
Yes it is. If you are using VB look at
www.vbmysql.com/articles/blobaccessvb.html
Regards,
Mike Hillyer
www.vbmysql.com
-Original Message-
From: Dan Anderson [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 09, 2003 8:49 AM
To: [EMAIL PROTECTED]
Subject: Is it possible to dump
this. That way you can prevent some potential
conflicts.
You can reset the auto_increment with ALTER TABLE tablename AUTO_INCREMENT = 1; but
know what you are doing when you do.
Regards,
Mike Hillyer
www.vbmysql.com
-Original Message-
From: Miguel Perez [mailto:[EMAIL PROTECTED]
Sent
Well, I would avoid NAS as it introduces unwanted overhead when
accessing the data. As for SAN versus the internal RAID5, I am not sure,
I would say benchmark the two and see which comes out better, or wait to
see if there is anyone out there that has dealt with both.
Regards,
Mike Hillyer
Well, I have sent queries over 4 times as long without difficulty, so I
do not think you are coming up against a limit on query length. I would
not use MySQL 5 for any production or even development machines, as a
development tree is not even guaranteed to work.
Regards,
Mike Hillyer
No
Yes
www.php.net
Regards,
Mike Hillyer
-Original Message-
From: Jeremy [mailto:[EMAIL PROTECTED]
Sent: Monday, July 07, 2003 1:49 PM
To: [EMAIL PROTECTED]
Subject: Newbie questions (3) - listeners / BLOB / PHP
Hi I'm from an Oracle background and wanted to ask a couple
If your table is MyISAM, then
SELECT COUNT(*) FROM tablename
Will return a rowcount without a major performance hit as the rowcount
is stored and a table scan is not needed.
Regards,
Mike Hillyer
www.vbmysql.com
-Original Message-
From: Roy W [mailto:[EMAIL PROTECTED]
Sent
.
Regards,
Mike Hillyer
www.vbmysql.com
-Original Message-
From: Jackson Miller [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 02, 2003 10:47 AM
To: Jake Johnson
Cc: [EMAIL PROTECTED]
Subject: Re: More tables or more joins
I appreciate the idea of normalizing, but those tables
sti_tracking WHERE sessionID
IN (SELECT DISTINCT sessionID FROM sti_tracking WHERE userID = 99);
Assuming you have MySQL 4.1 that is (which supports subselects).
Regards,
Mike Hillyer
www.vbmysql.com
-Original Message-
From: Tim Winters [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July
be degraded though.
Regards,
Mike Hillyer
www.vbmysql.com
-Original Message-
From: Aleksandr Zingorenko [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 02, 2003 11:05 AM
To: [EMAIL PROTECTED]
Subject: Having MySQL Server and databases on different computers
I am wondering
and a database SELECT
privilege. http://www.mysql.com/doc/en/News-3.23.57.html
But it depends on how you GRANTed UPDATE privileges.
Regards,
Mike Hillyer
www.vbmysql.com
-Original Message-
From: Twibell, Cory L [mailto:[EMAIL PROTECTED]
Sent: Monday, June 30, 2003 3:26 PM
To: '[EMAIL
Well, with that in mind, does the user have the appropriate INSERT
privileges?
Regards,
Mike Hillyer
www.vbmysql.com
-Original Message-
From: Twibell, Cory L [mailto:[EMAIL PROTECTED]
Sent: Monday, June 30, 2003 3:49 PM
To: Mike Hillyer; Twibell, Cory L; [EMAIL PROTECTED]
Subject
Hmm, if you have UPDATE privilege on A and SELECT on A and B then it
should work. Do you have UPDATE granted on B (though I know you should
not need it)?
Regards,
Mike Hillyer
www.vbmysql.com
-Original Message-
From: Twibell, Cory L [mailto:[EMAIL PROTECTED]
Sent: Monday, June 30
That is my conclusion as well. I think you should post it as such
barring any comments otherwise.
Regards,
Mike Hillyer
www.vbmysql.com
-Original Message-
From: Twibell, Cory L [mailto:[EMAIL PROTECTED]
Sent: Monday, June 30, 2003 4:51 PM
To: Mike Hillyer; [EMAIL PROTECTED
In that case they are probably fixed width files. If they are not fixed
with and are in fact delimited by tab or comma, you can use LOAD DATA to
bring them in.
See http://www.mysql.com/doc/en/LOAD_DATA.html
Regards,
Mike Hillyer
www.vbmysql.com
-Original Message-
From: Ben Ferderer
Plain text. Use of the upcoming MyODBC 3.52 will make it in binary form,
but not encrypted. Is the remote server MySQL 4.x? You could possibly
use Stunnel (www.stunnel.org) to access the server via SSL.
Regards,
Mike Hillyer
www.vbmysql.com
-Original Message-
From: Mike Fish (Shoal
.
Regards,
Mike Hillyer
www.vbmysql.com
-Original Message-
From: Daniel Rossi [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 25, 2003 9:15 PM
To: [EMAIL PROTECTED]
Subject: use of UNION
hi there , i finally worked out union joines are supported in
4.0 i thought it was 4.1 , anyway
This may not help with the comma problem, but your app looks like a good
candidate for FULLTEXT searching, check out
http://www.mysql.com/doc/en/Fulltext_Search.html for information.
Regards,
Mike Hillyer
www.vbmysql.com
-Original Message-
From: Tom Johnson [mailto:[EMAIL PROTECTED
If your tables are InnoDB, you could look at InnoDB HotBackup:
http://www.innodb.com/hotbackup.html
Regards,
Mike Hillyer
www.vbmysql.com
-Original Message-
From: SAQIB [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 26, 2003 11:45 AM
To: [EMAIL PROTECTED]
Subject: Best Pratices
Sounds like a corrupt table, try REPAIR TABLE:
http://www.mysql.com/doc/en/REPAIR_TABLE.html
Regards,
Mike Hillyer
www.vbmysql.com
-Original Message-
From: Steven Dowd [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 26, 2003 11:13 AM
To: [EMAIL PROTECTED]
Subject: error message
I believe % doesn't include localhost, but I could be wrong.
% Does indeed include localhost. At least it does on 4.0.13.
Regards,
Mike Hillyer
www.vbmysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
I simply followed the directions listed here:
http://www.mysql.com/doc/en/SCO_UnixWare.html
And I had no problems.
Regards,
Mike Hillyer
www.vbmysql.com
-Original Message-
From: Sudhipan Sharma [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 25, 2003 3:08 AM
To: [EMAIL PROTECTED
In a situation with many concurrent reads and writes an InnoDB table
would be preferable.
See http://www.mysql.com/doc/en/Table_types.html
Regards,
Mike Hillyer
www.vbmysql.com
-Original Message-
From: JOUANNET, Rodolphe [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 25, 2003 2:30
MyISAM tables do not support row-level locking, only table locking.
See http://www.mysql.com/doc/en/Table_locking.html
Regards,
Mike Hillyer
www.vbmysql.com
-Original Message-
From: Cedric Gavage [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 25, 2003 2:14 AM
To: [EMAIL PROTECTED
to create/write a file at the location you specify.
/QUOTE
You will also want to look at http://www.mysql.com/doc/en/mysqldump.html
Regards,
Mike Hillyer
www.vbmysql.com
-Original Message-
From: Rob [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 25, 2003 1:57 AM
To: MySql
Subject
I am not sure that could be viewed as a subselect, as it in not a SELECT
within an SELECT, but is instead a SELECT within a CREATE. I would
imagine that the SELECT within the CREATE is easier to implement that
the actual SELECT within a SELECT.
Regards,
Mike Hillyer
www.vbmysql.com
You need simply add the column predefined as AUTO_INCREMENT and PRIMARY
KEY:
CREATE TABLE incrtest (
name varchar(100) NOT NULL
) TYPE=MyISAM;
INSERT INTO incrtest VALUES(ben);
INSERT INTO incrtest VALUES(bob);
INSERT INTO incrtest VALUES(bom);
INSERT INTO incrtest VALUES(gddo);
INSERT INTO
The TIMESTAMP column type does this for you:
See: http://www.mysql.com/doc/en/DATETIME.html
Regards,
Mike Hillyer
www.vbmysql.com
-Original Message-
From: MaFai [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 24, 2003 11:01 AM
To: [EMAIL PROTECTED]
Subject: datetime column dummy
You may want to try disabling the index during the insert:
ALTER TABLE table1 DISABLE KEYS;
insert into table1 select * from table2;
ALTER TABLE table1 ENABLE KEYS;
And see what that does.
See: http://www.mysql.com/doc/en/ALTER_TABLE.html
Regards,
Mike Hillyer
www.vbmysql.com
-Original
Does enclosing the username and host in single quotes help?
I.E. GRANT SELECT ON *.* TO 'update'@'localhost' IDENTIFIED BY 'update';
Regards,
Mike Hillyer
www.vbmysql.com
-Original Message-
From: Adam Lawrence [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 25, 2003 8:10 AM
://www.mysql.com/doc/en/mysqldump.html for info.
Regards,
Mike Hillyer
www.vbmysql.com
-Original Message-
From: Leo Genyuk [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 25, 2003 12:54 PM
To: MYSQL-List (E-mail)
Subject: Updating MySQL db's
I have two server running Appache + PHP
Sounds like your windows install process is not complete, check
http://www.mysql.com/doc/en/Windows_installation.html for more info.
Regards,
Mike Hillyer
www.vbmysql.com
-Original Message-
From: Russ Guillemot [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 25, 2003 4:15 PM
MUL indicates a that the column is part of a composite INDEX.
SHOW INDEX FROM tablename
Should let you know what columns make up the MUL column INDEX.
If this was not supposed to be indexed, your table is corrupt, best try
MyIsamChk
Regards,
Mike Hillyer
www.vbmysql.com
-Original
For automated setup under windows, the MyODBC-3.51.06.exe file should be
downloaded.
Regards,
Mike Hillyer
www.vbmysql.com
-Original Message-
From: Ellen Cain [mailto:[EMAIL PROTECTED]
Sent: Saturday, June 21, 2003 4:37 PM
To: [EMAIL PROTECTED]
Subject: Driver 3.51 Not Found 2
will not be using ODBC, then you need
not worry about that message.
Regards,
Mike Hillyer
www.vbmysql.com
-Original Message-
From: Ellen Cain [mailto:[EMAIL PROTECTED]
Sent: Saturday, June 21, 2003 10:05 AM
To: [EMAIL PROTECTED]
Subject: Driver 3.51 Not Found
Hello,
I'm new to mySQL
It will not. If such a change is desirable, you will have to make the
change in the related table as well.
Regards,
Mike Hillyer
www.vbmysql.com
-Original Message-
From: Andrew [mailto:[EMAIL PROTECTED]
Sent: Monday, June 23, 2003 7:57 AM
To: MySQL-Lista
Subject: varchar
= 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
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
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
1 - 100 of 167 matches
Mail list logo