Don't applications have to be kerberized first?
I don't believe mysql is...kerberos libs don't show up when using ldd.
mike
-Original Message-
From: Martin Gainty [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 17, 2003 6:24 PM
To: Tomasz Korycki
Cc: [EMAIL PROTECTED]
Subject: Re
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
You might want to check that the developer tools were installed with Red
Hat 9; if not, you'll have trouble. The RPM is easiest to use, works like a
charm.
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]
Does anyone know of any programs that will parse e00 files and load the data into
MySQL?
Does anyone have any real world experience with the spatial capabilities of MySQL?
Is it still
somewhat beta or is it really ready for prime time?
Thanks.
Mike
__
Do you
tried to re-replicate the data,
it simply ignored entries from it's own server-id.
This makes complete sense, however, I can't find anywhere in the MySQL
documention that explains this behavior. The documention only says that
the master and slaves should have unique server-ids.
-Mike
I have one
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
.
Thanks,
Mike
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Also make sure you installed both the server and the client for MySQL.
And of course if you're not running bash, put the path to the MySQL
directory in the correct shell file. For example, I prefer the tsch shell,
so I would put it in the .tcshrc file in my home directory.
If you're not
I'd recommend Apache, www.apache.org, but be aware that Windows OSes come
with a personal version of IIS that can be used as a single server (i.e.,
no virtuals). Check Windows Components in Add/Remove Programs. The Apache
site has good documentation and some IIS info can be found in the Windows
.
best,
Matthew Gold
--
Cheers
Mike Morton
*
* Tel: 905-465-1263
* Email: [EMAIL PROTECTED]
*
Indeed, it would not be an exaggeration to describe the history of the
computer industry
Yes, it should. Check it yourself by printing out array values:
echo array[2];
echo array[3]; etc.
If it's a really long array and you want to print the whole thing, look at
foreach, http://us2.php.net/manual/en/control-structures.foreach.php
for year to date on some
affiliates
Any other suggestions out there?
P.S. The affiliate_stats database has about 3,000 records, while the
vtconlineusers database has about 9,500 records
On 9/2/03 8:01 PM, Matt W [EMAIL PROTECTED] wrote:
Hi Mike,
If you use a LEFT JOIN, I think you'll
for year to date on some
affiliates
Any other suggestions out there?
P.S. The affiliate_stats database has about 3,000 records, while the
vtconlineusers database has about 9,500 records
On 9/2/03 8:01 PM, Matt W [EMAIL PROTECTED] wrote:
Hi Mike,
If you use a LEFT JOIN, I think you'll
to
connect.
I know the program works because it connects to a commercial site providing Mysql I
also use.
The problem I believe is a parameter I am missing with my own Mysql set up.
Thanks.
Mike
Sounds like a problem authenticating the host the queries are coming from.
Try using the grant command with like john@%, which allows any host to
connect. (replace john with the username you want.)
As a historical note, we tried using Crystal RAS with Lotus Notes and
concluded it was too slow
Is it possible to return results like this, and if so, what is wrong with my
query?
TIA!
--
Cheers
Mike Morton
*
* Tel: 905-465-1263
* Email: [EMAIL PROTECTED]
*
Indeed, it would
on information about MySQL and so far, I;m getting the picture of it all,
however, would appreciate some feedback from the real world experiences or what to do
and not to do, etc.
Thanks in advance!
Mike
-
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use
Because his query only returns one record. A limit wouldn't make any
difference.
John Larsen wrote:
Mark wrote:
Why don't you just always put a limit 1000 on it, do you ever need
more than that?
Hi,
I have a fulltext index on a table with 80,000 rows. when I do a
search for a common word it
to do it in one query. If this is possible to do - how?
TIA!
--
Cheers
Mike Morton
*
* Tel: 905-465-1263
* Email: [EMAIL PROTECTED]
*
Indeed, it would not be an exaggeration to describe
Thanks to everyone that replied on and off list - off to the group by docs
;)
On 8/28/03 5:09 PM, William R. Mussatto [EMAIL PROTECTED] wrote:
Mike Morton said:
Hey y'all - I have been at this too long today - this is driving me
nuts!
Table:
Date (y-m-d),amount (decimal),dealercode
I
without doing all sorts of other connections.
As you can see I am using MYSQL 3 - so no union queries - and I cannot
upgrade the database since it is on a host provider.
Any assistance is appreciated!
TIA
--
Cheers
Mike Morton
*
* Tel: 905
uhhh.there are only two fields in the table, but I'll give it a whirl.
:)
As for Donald's advice: it gave me access denied for user. :\
-Mike
-Original Message-
From: Jay Blanchard [mailto:[EMAIL PROTECTED]
Sent: Friday, August 08, 2003 4:08 PM
To: Mike At Spy; Donald Tyler
When I come across this error:
The used command is not allowed with this MySQL version
Does this mean that I need a whole different verison of MySQL, or just a
different compile? The command was 'LOAD DATA INFILE' and I was doing it
through phpMyAdmin.
Thanks,
-Mike
--
MySQL General
My recommendation would be to use phpmyadmin, http://www.phpmyadmin.net/.
Takes just a few minutes to pull out the original database schema then feed
it back to create new tables. Or you can do it with command-line
instructions. 2000 small databases shouldn't be a problem as long as the
server
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
Sorry, that is the error - my mistake. I am getting this:
LOAD DATA LOCAL INFILE '/tmp/php9GOwvw' INTO TABLE `this_one` FIELDS
TERMINATED BY ';' LINES TERMINATED BY '\r\n'
I am using phpMyAdmin 2.3.3 - would an upgrade to the latest version remedy
the issue?
Thanks,
-Mike
-Original
Functions can be looked up at www.php.net, trim is at
http://us2.php.net/manual/en/function.trim.php
James Johnson
Hi all,
Does anyone have any suggestion for converting a Sequel database to MYSQL?
I just want to copy a Sequel database data to a Mysql one.
Thanks in advance for any suggestion,
Mike
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
Ah. No wonder it dinna work. Neither did specifying the columns as Jay
suggested.
I also have no choice but to do it through the browser - I don't have
command line access on the server. :\
-Mike
-Original Message-
From: Donald Tyler [mailto:[EMAIL PROTECTED]
Sent: Friday, August
15,000 of them. :)
-Mike
-Original Message-
From: Jay Blanchard [mailto:[EMAIL PROTECTED]
Sent: Friday, August 08, 2003 3:58 PM
To: Mike At Spy; Donald Tyler; [EMAIL PROTECTED]
Subject: RE: mysql LOAD DATA INFILE
[snip]
Sorry, that is the error - my mistake. I am getting
,
-Mike
-Original Message-
From: Donald Tyler [mailto:[EMAIL PROTECTED]
Sent: Friday, August 08, 2003 4:30 PM
To: [EMAIL PROTECTED]
Subject: FW: mysql LOAD DATA INFILE
Then the only way you can do it that I can think of is to write a
PHP script
to do basically what PHPMyAdmin is trying
.
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]
index not recognised?
Regards,
Mike Coppinger
--
Resrequest Online Reservation Systems
Tel: +27-11-476 4740
Fax: +27-11-476 7235
Cell: +27-82-774 0820
Email: [EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
Hello,
I need to update one of our mysql tables, which has about 60,000 entires and
correct the amount of days remain on each data record. An example of one of the
data entires is:
memiddaysregdate expdate
--
625290 | 5 | 2003-07-15 |
Hi,
How do i use the UPDATE statement to update a range of Primary Key id
numbers. (let say 100 through 1000).
Example,
UPDATE testTable set testField='' WHERE
test_id in (100:1000);
Thanks in advance for any comments,
Mike
--
MySQL General Mailing List
For list archives: http
, and I'd love to split our invoice table
into years and use pack on the old years and replace the original table with
a MERGE.
--
Mike Miller
Business Analyst Applications Developer
BMG Canada Inc.
Tel: 416-586-1646
Fax: 416-586-0454
EMail: [EMAIL PROTECTED]
I think you're going to have trouble doing this with .asp. I know it can be
done with Perl or PHP, so you might want to look into those programming
languages. MySQL won't do it automatically.
Would that help at all - since the COUNT(*) would execute fully and then
MAX would limit it? (or is the order of operations different than that?)
-M
-Original Message-
From: Yves Goergen [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 22, 2003 10:26 AM
To: Mojtaba Faridzad; [EMAIL
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
Check out http://www.fmpdev.com/fmp2mysql.html, found in Google search for
filemaker to mysql
David Shugarts
Sorry Nils sent in hast.
(B
(B-Original Message-
(BFrom: Mike [mailto:[EMAIL PROTECTED]
(BSent: Friday, July 11, 2003 9:08 PM
(BTo: 'Nils Valentin'
(BSubject: RE: What's up with this GATOR crap? - HOWTO Clean it out
(B
(BI think the answers given are valid but I did not see
I am trying to create an order by in a select statement that takes a
standard 'date' column in a table and sorts the returned data by the month
of that date.
Off hand, I tried
ORDER BY start_date(m)
And I know that is wrong. Anyone have any suggestions?
Thanks,
-Mike
--
MySQL General
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
You'd want to use a BLOB (binary large object) if that's what your goal
is.
But if you're using this for a web application I'd highly suggest that
you instead save images to a directory and make a reference to the path
in the database. If you have many BLOB inserts or selects on a site,
your
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
for is a MyISAM table. These
should be atomic processes. Is there something at the OS-level that might
tell me what's causing the hangup? Did I jump onto the RH9 bandwagon too
soon?
On Fri, 4 Jul 2003, Jeremy Zawodny wrote:
On Thu, Jul 03, 2003 at 06:51:28PM +, Mike Lucente wrote:
Hello,
I
Hello,
Happy 4th to all :)
Anyway, I am attempt to temporarily disable InnoDB tables. We just setup on a
new RH/Linux 7.3 server that had the MySQL version 4.0.13 from RPM's,
pre-installed... but we currently don't need the InnoDB tables but may in the
near future... I've commented out all
Thanks, that did the trick :)
Jeremy Zawodny wrote:
On Fri, Jul 04, 2003 at 07:26:54PM -0500, Mike Blezien wrote:
Hello,
Happy 4th to all :)
Anyway, I am attempt to temporarily disable InnoDB tables. We just
setup on a new RH/Linux 7.3 server that had the MySQL version 4.0.13
from RPM's, pre
Hello,
I have nine process that import data to tables with the same structure
within about 1000 databases on a server. Each process fires at the same
time, every 5 minutes.
Lately I'm seeing these inserts hang, all waiting upon the same table, and
they do not clear up. I've searched through
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
Todd Burke wrote:
Which is the better option to host mysqld:
MACHINE A:
2.4 GHz CPU
1024 MB Ram
2x 18 GB SCSI
HDD RAID 1
MACHINE B:
Dual Xeon
1.8 GHz CPU
1024 MB Ram
3x 18 GB SCSI
HDD RAID 5
I would recommend using RAID
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
a
recompile.
Thanks
--Todd
On Mon, 30 Jun 2003, Mike Wexler wrote:
Todd Burke wrote:
Which is the better option to host mysqld:
MACHINE A:
2.4 GHz CPU
1024 MB Ram
2x 18 GB SCSI
HDD RAID 1
MACHINE B:
Dual Xeon
1.8 GHz CPU
1024 MB Ram
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
Description:
I have just installed MySQL 4.0.4 on Linux kernel 2.4.2-2 on a
Hewlett-Packard
Kayak machine. I ran the mysql_install_db script with no problems,
but am unable
to create a root password as directed by the script. I have started
MySQL with
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
Hi
I'm connecting to a MySQL server on the internet from a VB6 app on Win2K
using MyODBC.
I understand that the connection itself is not secure. I cannot implement
SSH for the connection as my ISP does not support this with MySQL.
However, when MyODBC sends the username and password etc to the
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
Jun 2003 18:02:23 +
To: [EMAIL PROTECTED]
From: Syamsul Arifien
Subject: Help me pls
Hi ...
I hv problem...
I can't conec to my MysqlSvr with mysql_connect() in my php script..
anybody knows?
best regard
Syamsul Arifien
--
Cheers
Mike Morton
.
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
Where can I find more info on converting and what can be converted.
Thanks
Mike Benzel [EMAIL PROTECTED]
Promote your Product with a Free SkyWiremeeting!
SkyWire Meeting - Internet Training from you PC or our Server.
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
in the
right direction?
TIA
--
Cheers
Mike Morton
*
* Tel: 905-465-1263
* Email: [EMAIL PROTECTED]
*
Indeed, it would not be an exaggeration to describe the history of the
computer industry
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
(B
(B Hi Mike,
(B
(B Just a guess. Is perhaps one of the 4 records you mention a NULL record
(B (meaning no entry) ?
(B
(B Why I am asking is because in this case you may want to use INNER JOIN or even
(B LEFT JOIN which should return also the NULL entry (incomplete datarecords).
(B
(B
Not necessarily. People that need relatively affordable 64 bit systems
may be waiting for the Opteron to stabilize. My experience is the Wintel
solutions (like Opteron) tend to have at least a 2-1 price performance
over Sun and Dec. Also, given that HP has basically dropped Alpha, I
don't
need large files.
On the other hand I think need 64 bit and affordable are rare
situations.
--
Michael Conlen
Mike Wexler wrote:
Not necessarily. People that need relatively affordable 64 bit
systems may be waiting for the Opteron to stabilize. My experience is
the Wintel solutions (like Opteron
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
Can anyone point me to docs on installing MySQL on Red Hat 9 on an Intel box?
Thanks,
-m
===
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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
601 - 700 of 1406 matches
Mail list logo
