.
There are currently no plans to release a new version of 4.0.
Jim Winstead
MySQL Inc.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi All,
Am using mySQLDump to backup db as follows
mysqldump --databases OURDB -uroot -pROOTPASSWRD dump.sql
How can I restore OURDB from dump.sql?
Thanks
Jim
?
You can find the SVN repositories for the GUI tools and Connectors at
http://svn.mysql.com/
The server repositories are still at http://mysql.bkbits.net/
Jim Winstead
MySQL Inc.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
support engineers will log in
to your systems to troubleshoot problems. There is more information
about this here:
http://www.mysql.com/company/legal/supportpolicies/policies-08.html
Jim Winstead
MySQL Inc.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
be downloaded ... if so, where would they be located ??
Old releases can be found at:
http://downloads.mysql.com/archives.php
Specifically, the RPM packages for 4.0.26 can be found at:
http://downloads.mysql.com/archives.php?p=mysql-4.0v=4.0.26
Jim Winstead
MySQL Inc.
--
MySQL General Mailing
Hi All,
We used to use Interbase which required a new file to be assigned for every
4 gig of data stored in a DB.
Is there any issues like this in mySQL?
Thanks,
Jim
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com
There is a TRIGGERS table in the information_schema
Eg.
select Trigger_Name from TRIGGERS
where trigger_name = 'TI_AGENT' AND trigger_schema = 'PROPLINK'
-Original Message-
From: Adrian Co [mailto:[EMAIL PROTECTED]
Sent: Friday, 7 April 2006 1:54 PM
To: mysql@lists.mysql.com
/lib
[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
Thanks
Jim
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
hit in
one of my more complicated use cases takes over 7
seconds.
Someone please help.
karma is yours if you can help me on this.
Thank You
Jim Tyrrell
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
of the repository was changed to mysql-5.1-new, and it looks
like the documentation may not have been updated. try:
sfioball -r+ bk://mysql.bkbits.net/mysql-5.1-new mysql-5.1
Jim Winstead
MySQL Inc.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
This is addressed in the FAQ for the mailing lists.
http://lists.mysql.com/faq.php#replyto
Jim Winstead
MySQL Inc.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
TABLE' look like for your table?
You may want to file a bug about this and attach your data and the
actual queries being run. I was not able to come up with a test case to
reproduce this problem, but you haven't provided much information to go
on.
Jim Winstead
MySQL Inc.
--
MySQL General Mailing
but at least mycc, even in its beta stage, is
fairly useful.
Development of MySQL Control Center was halted a couple of years ago.
The new GUI tools (Query Browser, Administrator, etc) are still under
active development.
Jim Winstead
MySQL Inc.
--
MySQL General Mailing List
For list archives
On Fri, Nov 18, 2005 at 02:41:30PM -0800, Jenny Chen wrote:
I'd ask some questions on MySQL cluster. Does anyone know if there is any
email alias for the cluster questions?
Yes, there is a mailing list for MySQL Cluster:
http://lists.mysql.com/cluster
Jim Winstead
MySQL Inc.
--
MySQL
and
it will get me out, but then I have to login again, which is a pain, how can
I tell mysql to drop me back to a clean prompt?
Just close the open quote before you use \c
mysql select
\c
mysql
Jim Winstead
MySQL Inc.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com
something, but 2005-09-30 looks like the maximum
value of EAPDate in the data above. What did you expect the result to
be?
Jim Winstead
MySQL Inc.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
So follow the installation directions appropriate for the flavor of Linux
you are using. That's where MySQL lives, in the OS, not the application
As far as I can tell, there are none. At least not for Mandriva. The
attitude seems to be that MySQL is just the backend. :-/
Jim C
Hey! Those are some pretty handy looking links. :-)
Thanks!!
Did you see this:
http://www.mythtv.org/docs/mythtv-HOWTO-6.html
And also:
http://wilsonet.com/mythtv/tips.php (see the section on Front Ends)
And lastly:
http://dipper.info/project/ivtv/
signature.asc
Where can I get tips on how to manually set up MySQL for MythTV?
MythTV's site was not very helpful in this regards.
Jim C.
signature.asc
Description: OpenPGP digital signature
running MySQL v5.0.13 on a Debian Etch(Testing) box.
TIA,
Jim Seymour
--
I started using something better than the standard back when IBM advertised
OS/2 Warp on TV. As Linux matured I made the transition from OS/2 v4 to Linux.
You don't have to accept less than you deserve.
Use the Power
are kept in a MySQL database, the message archives
are simply kept in the filesystem, the index of messages used by the
news server and web archive are kept in MySQL, and the search index is
kept in MySQL.
Jim Winstead
MySQL Inc.
--
MySQL General Mailing List
For list archives: http
On Wed, Oct 05, 2005 at 11:23:00AM -0700, Mike Wexler wrote:
Jim Seymour wrote:
I have researched repeatedly and cannot find an answer to the following. I
need to do something like the following (There is probably an easier
way).
end_date - start_date = diff / start_date = return
v5.0.12 on Debian Linux.
TIA,
Jim
--
I started using something better than the standard back when IBM advertised
OS/2 Warp on TV. As Linux matured I made the transition from OS/2 v4 to Linux.
You don't have to accept less than you deserve.
Use the Power of the Penguin Registered Linux user
I had the same problem with both of these:
mysql-standard-4.1.14-apple-darwin7.9.0-powerpc.dmg
and
mysql-standard-4.0.26-apple-darwin7.9.0-powerpc.dmg
They seem to install OK, but when I set the root password I can't get in
afterwards as root.
Clues?
Jim C.
--
MySQL General Mailing List
Jim C. wrote:
I had the same problem with both of these:
mysql-standard-4.1.14-apple-darwin7.9.0-powerpc.dmg
and
mysql-standard-4.0.26-apple-darwin7.9.0-powerpc.dmg
They seem to install OK, but when I set the root password I can't get in
afterwards as root.
Clues?
Jim C.
I can
.
Jim C.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On Sun, Sep 25, 2005 at 03:56:46PM -0500, Peter Brawley wrote:
Jim,
If you really want to return the result in a variable, declare a user
var in the client, declare an OUT var in the SP, have the SP SELECT INTO
it, and pass the user var to the SP in the call:
SET @x=0;
SET GLOBAL
Is this a release candidate as the version in your message subject would
imply, or is it an actual release, as your message states? Or does
MySQL AB even bother to differentiate the two?
- Original Message -
From: Lenz Grimmer [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc:
putting
various parts of the query into the parentheses. The error messages
always seem to occur around the @count variable. I am using MySQL
v.5.0.12 on Debian Etch.
TIA,
Jim Seymour
--
I started using something better than the standard back when IBM advertised
OS/2 Warp on TV. As Linux matured
, the documentation just hasn't caught up with
the change yet. The new syntax is CONNECTION = '...'.
Jim Winstead
MySQL Inc.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On Mon, 2005-09-19 at 12:15 -0400, George Herson wrote:
Dear Jim,
Re: your post at http://lists.mysql.com/mysql/189058, why bother
creating the mysqldump if you already have the snapshot? Why not just
backup the snapshot?
(I'd have hit reply online but didn't see a Reply button
On Mon, 2005-09-19 at 13:14 -0400, George Herson wrote:
James G. Sack (jim) wrote:
On Mon, 2005-09-19 at 12:15 -0400, George Herson wrote:
Dear Jim,
Re: your post at http://lists.mysql.com/mysql/189058, why bother
creating the mysqldump if you already have the snapshot? Why
silly or unwise about this strategy? Do I have misconceptions
about making the database consistent in preparation for backup?
..jim
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
database server daemon accessing the db within the
snapshot (with a suitable alternate my.cnf file)
6. perform mysqldump operation on the snapshot-db
7. cleanup (unload second db server, unmount and delete snapshot)
So what monsters lurk within this backup strategy?
..jim
--
MySQL General
, you will see that I am
aware of the LVM2 option, and that I solicit feed back on whether it's a
good idea to mount snapshots r/w.
Regards,
..jim
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
and is safe, am I out-of line asking for readonly?
-
Thanks all, for your forbearance!
...jim
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
On Tue, Aug 02, 2005 at 02:38:01PM -0400, Jason Pyeron wrote:
why does this list not have the reply to header set?
This is covered in the mailing list FAQ at
http://lists.mysql.com/faq.php
Jim Winstead
MySQL Inc.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
cause...
Yes, there are a number of places within the server that only expect the
username to be 16 characters, and will almost certainly break in the
face of longer usernames.
Jim Winstead
MySQL Inc.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
No, you don't want a table for each monitor. One table for the data will
be _much_ easier to work with. If you want a history then you need to
insert a new record for each datapoint that you get, with, as Frank
suggested, a date/time column. How large your table will get will depend
on the
here?
This is a bug in the version of glibc being shipped with Ubuntu, and
apparently Debian as well. Here's the Ubuntu bug for tracking it:
https://bugzilla.ubuntu.com/show_bug.cgi?id=11730
There's also a Debian bug for it, but I can't find it right now.
Jim Winstead
MySQL Inc.
--
MySQL
be back to normal by next Monday, June 13, at the
latest.
Our apologies for the late notice.
As always, you can contact [EMAIL PROTECTED] about any problems you
are having sending or receiving messages from the lists.mysql.com
mailing lists.
Thanks.
Jim Winstead
MySQL Inc.
--
MySQL General
at [EMAIL PROTECTED]
Jim Winstead
MySQL Inc.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
, I've downloaded the 4.1.12 standard installer package,
installed it, and run the full test suite and it all passed.
Jim Winstead
MySQL Inc.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
It was taken offline temporarily.
It's back now.
Jim Winstead
MySQL Inc.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
in release 5.0.6 (not released yet)
D.1.3. Changes in release 5.0.5 (to be released soon)
The documentation is just out-of-date here. 5.0.5 will not be released.
5.0.6 will be released soon.
Jim Winstead
MySQL Inc.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
We're running an application that creates table names in a numeric
sequence. For example:
jst998_foo
jst998_bar
jst999_foo
jst999_bar
jst0001000_foo
jst0001000_bar
jst0001001_foo
jst0001001_bar
I need to write a maintenance app that first needs to determine the
numeric range of
. Dictated by this (old as alabama)
application. They refuse to support newer versions of MySQL.
- Original Message -
From: Eric Bergen [EMAIL PROTECTED]
To: Jim McAtee [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Sent: Monday, May 02, 2005 11:31 AM
Subject: Re: Determining if a table exists
I
variables. I don't know if this is even the right approach and
what to set which variable to.
Thanks for any advice you can give,
Jim Cramer
University of Iowa
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
for the right syntax to use near '1) DEFAULT
NULL, `borderstates` VARCHAR(255) DEFAULT NULL,
`bordernotes` TEXT DE' at line 1
That's why the error message says near 1)
Jim Winstead
MySQL Inc.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
on the number of rows and the Create_time. We have
far too many tables to just alter them all in one sitting so we do them
as needed.
Thanks.
--
Jim Grill
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I have a table that tracks events by month and year. The field names are
(you guessed it) 'month' and 'year'. I need to do queries over some date
range from variables beg_month, beg_year to end_month, end_year.
How can I do this?
SELECT state,
SUM(borks) AS borkcount
FROM borkstats
Jim Grill [EMAIL PROTECTED] wrote on 02/18/2005 03:17:39 PM:
Hi,
I need some SQL guru help on this one.
I'm trying to re factor an existing application where a number of clicks
grouped by keyword for two different time periods are needed. For
example, a user picks a date range
.
Regards,
Jim Grill
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Say a row is inserted into a table with an auto_increment column and then
deleted before another record is inserted. When a new row is inserted,
will the value of the auto_increment column be the same as the deleted
record's, or will it be one greater?
--
MySQL General Mailing List
For list
The reason I asked about auto_increment behavior is that I'm looking at
the output from mysqldump --opt and there are no commands to preserve/set
the auto_increment value. Is there a mysqldump option to do this? Or
will restoring from a dump always leave the auto_increment value one
greater
Is it recommended to create a MySQL user for doing backups? Running
mysqldump from a script, the username and password will have to be
embedded in plain text.
If I were to create a MySQL user expressly for doing nightly backups what
are the minimum permissions needed?
--
MySQL General
- Original Message -
From: Daniel Kasak [EMAIL PROTECTED]
To: Jim McAtee [EMAIL PROTECTED]; mysql@lists.mysql.com
Sent: Wednesday, February 23, 2005 2:39 PM
Subject: Re: Backup User
Jim McAtee wrote:
Is it recommended to create a MySQL user for doing backups? Running
mysqldump from
help. ???
Thank you for the help!
--
Jim Grill
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I've determined it is not supported. Thx.
-- Jim
--- Jim Hoadley [EMAIL PROTECTED] wrote:
Is DELETE QUICK supported in MySQL version 3.22.32?
-- Jim
__
Do you Yahoo!?
Yahoo! Mail - You care about security. So do we
Is DELETE QUICK supported in MySQL version 3.22.32?
-- Jim
__
Do you Yahoo!?
Yahoo! Mail - You care about security. So do we.
http://promotions.yahoo.com/new_mail
--
MySQL General Mailing List
For list archives: http
A server running MySQL 3.23 crashed yesterday. Since bringing it back
online, doing inserts into a particular table will throw an error
regarding a duplicate key value in an auto_increment field. I assume that
something is corrupted.
There are 779239 records, the most recently added having
,
but you could build one without TOO MUCH pain using CharDirector (a free
version is available from http://www.advsofteng.com/) and your scripting
language of choice. I prefer PHP or Perl, myself.
Jim
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
function will offer that or not.
As the manual says, the PASSWORD() function should not be used within
your application. It is meant only for use with the built-in MySQL
privilege tables.
Use MD5() or SHA1() for your own applications.
Jim Winstead
MySQL Inc.
--
MySQL General Mailing List
For list
record if
found, otherwise create one in one query.
- Original Message -
From: Eric Bergen [EMAIL PROTECTED]
To: Jim McAtee [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Saturday, December 04, 2004 2:40 PM
Subject: Re: More efficient way?
Depending on how your application works you might
all words beginning with that prefix.
For example:
SELECT record FROM table
WHERE MATCH (record) AGAINST ('resident*' IN BOOLEAN MODE)
(Using 'IN BOOLEAN MODE' requires MySQL 4.0 or later.)
--
Jim Winstead
MySQL Inc.
--
MySQL General Mailing List
For list archives: http
I have an application which keeps a table of daily event counters related
to other records in a databse. Since the trackingrecords are kept on a
daily basis new records are created each day for items being referenced.
In pseudo-code:
// Check for the existance of daily tracking record
SELECT
On Mon, Nov 22, 2004 at 03:49:52PM -0800, Emmett Bishop wrote:
I need to snag a copy of MySQL 4.0.20 for Windows. Is
there somewhere on the MySQL I can grab older
versions?
http://downloads.mysql.com/
--
Jim Winstead
MySQL Inc.
--
MySQL General Mailing List
For list archives: http
- Original Message -
From: [EMAIL PROTECTED]
To: Jim McAtee [EMAIL PROTECTED]
Cc: MySQL List [EMAIL PROTECTED]
Sent: Thursday, November 18, 2004 8:28 AM
Subject: Re: copy data only from one table to another table
A semi-generic solution:
You have tableA with columns (col1, col2, col3
- Original Message -
From: Daniel Kasak [EMAIL PROTECTED]
To: Chip Wiegand [EMAIL PROTECTED]; MySQL List
[EMAIL PROTECTED]
Sent: Wednesday, November 17, 2004 5:04 PM
Subject: Re: copy data only from one table to another table
Chip Wiegand wrote:
How do I copy all data only from one
I have a web application using MySQL 3.2x server. In the application
theres an HTML form used for searching an ISAM table of about 500k
records. To populate select (drop down) fields in the form I do a couple
of SELECT DISTINCT queries against this table.
What's the best indexing strategy to
| Extra |
+-+
438710 | Using index |
+-+
- Original Message -
From: Michael Stassen [EMAIL PROTECTED]
To: Jim McAtee [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Tuesday, November 16, 2004 10:03 PM
Subject: Re: Speed up SELECT DISTINCT
. To me this all looks fine. to the parser,
well ;)
You can't compare a column with a comma-delimited list of numbers like
that, and you also want to make sure there is a space before the 'WHERE'
keyword. You want:
$sql .= WHERE VendorJobs.Industry IN ($s_Ind);
--
Jim Winstead
MySQL Inc
On Sat, Nov 13, 2004 at 12:46:12PM -0800, Stuart Felenstein wrote:
--- Jim Winstead [EMAIL PROTECTED] wrote:
You can't compare a column with a comma-delimited
list of numbers like
that...
What should the seperator be then ?
My point was that you can't compare a column
consisting of up to a few months worth of data at a time.
Thanks,
Jim Grill
from
http://dev.mysql.com/downloads/logos.html
There is no official 'Works with MySQL' logo (and I don't think there
ever has been).
Jim Winstead
MySQL Inc.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
that have
characters outside of the standard US-ASCII range.)
Jim Winstead
MySQL Inc.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
the 4.0.20 binaries to not be
available at http://downloads.mysql.com/archives.php (where all older
releases can be downloaded). The binaries for 4.0.20 are available from
there now.
Jim Winstead
MySQL Inc.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
. If you can't guarantee the conditions for (a), then consider
selecting the rows into a temporary table and doing the paging on
that table instead of the original.
--jim
--
Date: Sat, 09 Oct 2004 08:22:14 -0700
From: Jeff Barr [EMAIL PROTECTED]
Subject: Will series
Just goofing around--not making any claims about efficiency other
than this is the shortest way I've found to do this over my years
of working with different flavors of SQL. This one is running
with MySQL 4.1.
Has anyone done better?
--jim
How it works:
1. a MySQL variable (@num) is used
Hey folks.
Apparently I need to say it again: this discussion is off-topic for this
mailing list. Please either let it die or take the discussion off-list.
Thanks.
Jim Winstead
MySQL Inc.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
Hi.
This discussion is very off-topic for this list. Please take the
discussion of how to use your email client off-list.
Thanks.
Jim Winstead
MySQL Inc.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
that will shed some
light on the subject.
Jim Grill
yeah, I seen that have. Have you tried that before? I need to do it
two-way. But have not seen any special setup for that. Each site
will be entering data and all sites will need to see the updated
change.
On Fri, 01 Oct 2004 10:38:07
logic and try to use REPLACE or INSERT ... ON
DUPLICATE KEY UPDATE.
Regards,
Jim Grill
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
? If anyone
knows of analogous examples of how to do this I'd be greatful.
Thanks a bunch.
Jim
--
==
Jim Maas jamaas btinternet com
how safe this
idea is and I'm sure that some unnecessary overhead is introduced by testing
for live connections all the time.
My best advice to you is to set up a few servers and start testing.
Replication is not at all hard to accomplish.
Best of luck.
Jim Grill
Hi Jim, Hi all!
Doing a two
?
Try adding something like ORDER BY d DESC LIMIT 1
Jim Grill
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
' |
+--+--+
The slashes never actually get inserted into the table so there is no need
to call strip_slashes() on the results either. :-)
Jim Grill
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hola ,
Estoy empezando a notar intentos de ingreso con usuarios ilegales
no existentes) a mi server.
Mi pregunta es : Como lo rastreo teniendo como unico dato el numero de
ip desde el cual se esta conectando?
O si alguien tiene una mejor idea o ha pasado por lo mismo,
le agradecere
administrator would probably do
it a different way.
Jim Grill
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
kind of confidence with MySQL.
Although I have not taken the exam, I am feeling pretty confident that I can
pass after reading the online manual and the study guide from front to
(almost) back. I hope I'm right about that feeling!
Wish me luck :-)
Best of luck to you, too.
Jim Grill
and this is covered in the first chapter of the
study guide. :-)
Regards
Jim Grill
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
not actually get inserted into your table
with the slashes.
Regards,
Jim Grill
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
. That would be a cool option though. :-)
There are a number programs that can assist with converting to and from MySQL if
that's the goal.
Regards,
Jim Grill
- Original Message -
From: [EMAIL PROTECTED]
To: Jim Grill
Cc: Monet ; mysql
Sent: Friday, September 24, 2004 1:59 PM
-by= to make a csv
file. You can use BCP or MS DTS to load a csv into sql server tables. There
may be another sql server equivelant to LOAD DATA INFILE that can accept csv
or tsv. Who knows???
Good luck,
Jim Grill
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
(name)
VALUES(CONCAT(UCASE(LEFT('jim',1)),SUBSTRING('jim',2)));
SELECT CONCAT(UCASE(LEFT(name,1)),SUBSTRING(name,2)) FROM testing;
:-)
There might be a better way to do this too??? I do agree that you should
probably handle this with simpler functions in your app like php's
ucfirst().
Jim Grill
Can I run two different versions of MySQL on the same server? I've got a
commercial application for which the vendor will only support MySQL 3.x
and makes no guarantees if running MySQL 4. But I'd like to migrate a
number of our own web applications to MySQL 4. My choices are take my
not support UTF-8.
It is, however, possible to simply store UTF-8 data in a string field
(VARCHAR, CHAR, TEXT, etc) in those versions. You simply won't be able
to get the correct ordering in ORDER BY clauses, and full-text search
will not always work as expected.
Jim Winstead
MySQL Inc.
--
MySQL
http://www.catb.org/~esr/faqs/smart-questions.html
Stop repeating the same question or you will never get an answer. Try again
please.
Hi
I have installed some software on aix5.2 .
the list of software:
apache-1.3.29-1.aix4.3.ppc.rpm
php-4.0.6-5.aix4.3.ppc.rpm
a year ago.
Any ideas?
Thanks!
Nestor :-)
http://www.IneedWork.org
How about some more info. Did you install PHP from source or an RPM? Did you
configure PHP --with-mysql or --with-mysqli? Did you install MySQL after you
installed PHP and Apache or before?
Regards
Jim Grill
--
MySQL
9.0,
kernel 2.6.6.
Could the problem be related to memory size, ie is the index too big? If so,
how come it uses part of the index rather than none at all?
Any help very much appreciated and guruhood grovellingly acknowleged.
Thanks
Jim Page
Relevant data follows:
mysql explain SELECT * FROM
201 - 300 of 685 matches
Mail list logo