The 'group' column needs to be quoted (use --quote-names with mysqldump).
cheers,
--bemansell
On 3/26/07, Rob Tanner <[EMAIL PROTECTED]> wrote:
Hi,
I am porting over 6 databases from a MySQL v4 installation to a MySQL v5
installation and getting an SQL error in the process.
I am using th
Jerad -
First of all, please reply all with a SHOW CREATE TABLE of the table
you're inserting the row into, so that we can identify the indexes
you've established for the table.
thanks,
--bemansell
On 3/7/07, jerad sloan <[EMAIL PROTECTED]> wrote:
when i try to insert the string "
http://vids.
It sounds to me like you're needing to use a left outer join on t2.
Give that a shot instead of the inner join you're currently using.
Cheers,
-bemansell
On 2/17/07, Kerry Frater <[EMAIL PROTECTED]> wrote:
I am trying to select a particular row from a table and include a column for
aq second ta
This is totally possible...
Chris say your table is test, and the column is test_col.. use the
following, and if the number is always at the end.. and always has a
space in front of it this will work:
SELECT test_col, SUBSTRING_INDEX(test_col, '', 1) as test_col_str,
SUBSTRING_INDEX(test_col, '
Russell -
This should basically work for selecting the most recently selected
preference...
SELECT DISTINCT personID, classification FROM results_table ORDER BY date
DESC
On 4/10/06, Russell Horn <[EMAIL PROTECTED]> wrote:
>
> Hi,
>
> I'm storing data against a bunch of people and want to track
>From what I recall MysqlCC has been deprecated and has been replaced by
MySQL Administrator (which does support v5). I don't know think mysqlcc
supports v5.
good luck,
--bemansell
On 8/30/05, Siegfried Heintze <[EMAIL PROTECTED]> wrote:
>
> [Siegfried Heintze] I love MySQL Control center. I c
Scott -
Check this excerpt out (
http://dev.mysql.com/doc/mysql/en/fulltext-search.html ) from the MySQL
Documentation. I hope it helps!
--bemansell
...
"Every correct word in the collection and in the query is weighted according
to its significance in the collection or query. This way, a wo
Lee,
establish the fulltext minimum word length system variable as follows...
[mysqld]
ft_min_word_len=3
reference:
http://dev.mysql.com/doc/mysql/en/Fulltext_Fine-tuning.html
cheers,
--bemansell
Brian E. Mansell
MySQL Professional
On Thu, 06 Jan 2005 20:59:23 -0500, leegold <[EMAIL PROTEC
SHOW TABLE STATUS
(it includes type/storage engine as one of the returned columns)
--bemansell
Brian E. Mansell
MySQL Professional
On Wed, 15 Dec 2004 19:21:24 -0800, sol beach <[EMAIL PROTECTED]> wrote:
> How do I find out what table type is associated with each of the
> tables in MYSQL?
>
>
Julie -
Please specify which database binaries you are downloading. If you
could provide us with the url's that would be much appreciated in
helping you troubleshoot this.
For Windows binaries, I would refer to the HTTP / FTP mirror links
listed at the bottom of this page:
http://dev.mysql.com/ge
>From http://dev.mysql.com/doc/mysql/en/Upgrading-from-4.0.html :
"# Important note: MySQL 4.1 stores table names and column names in
UTF8. If you have table names or column names that use characters
outside of the range from `A' to `Z', you may have to do a mysqldump
of your tables in MySQL 4.0
What build of MySQL are you running? I don't believe an electronic
ignition is included in 4.0 or 4.1.
--bemansell
On Mon, 4 Oct 2004 17:07:07 -0700 (PDT), Don Dachner
<[EMAIL PROTECTED]> wrote:
> Anyone have experience with installing the Dyna III electronic ignition?
>
> I put it on my R80/7,
24 = Too many open files.
I think you can resolve this issue by increasing the number of file
descriptors available to mysqld by setting an appropriately higher
'open-files-limit' in your configuration.
--bmansell
Brian E. Mansell
MySQL Professional
On Thu, 22 Jul 2004 13:20:24 +0200, Wolfgang
Sergei,
Check out Paul DuBois' book MySQL - The Definitive Guide (2nd
edition). It has a few good chapters that discuss foreign key
constraints.
--bmansell
Brian E. Mansell
MySQL Professional
On Thu, 22 Jul 2004 13:06:07 -0700, Sergei Skarupo <[EMAIL PROTECTED]> wrote:
> Hi everyone,
>
> I'd
Cemal,
I recall hearing a similar question mentioned in a previous email
thread. In fact, here it is:
http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&threadm=c6h60e%2419dd%241%40FreeBSD.csie.NCTU.edu.tw&rnum=1&prev=/groups%3Fq%3D%2522enum%2Bor%2Btinyint%2522%26hl%3Den%26lr%3D%26ie%3DUTF-8%26sel
I took the certification exam this morning and passed. When should I
expect to receive the certificate (and other items) in the mail?
--bmansell
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
This page may help: http://dev.mysql.com/doc/mysql/en/Timezone_problems.html
--bmansell
On Wed, 16 Jun 2004 14:32:22 -0500, Mike Blezien
<[EMAIL PROTECTED]> wrote:
>
> Hello,
>
> Somehow the mysql server time is set 3 hours earlier than the system time(CDT),
> is there a way to correct this so
Devshed has a good tutorial:
http://www.devshed.com/c/a/MySQL/MySQL-Installation-and-Configuration/
--bmansell
On Wed, 16 Jun 2004 16:37:44 +0100, [EMAIL PROTECTED]
<[EMAIL PROTECTED]> wrote:
>
> Hi folks,
>
> I'm trying to install mysql on linux and it's giving me trouble. I'm new
> to linux
Dave -
I would recommend (if not done so already) adding an index on owner.
That should improve the speed quite a bit.
On Tue, 15 Jun 2004 21:06:47 +, Dave Torr <[EMAIL PROTECTED]> wrote:
>
> Thanks - that is basically what I used to do (it works fine now on 4.1.2)
> but it was very slow as
Just a minor correction...
select YourField from YourTable order by YourField DESC limit 1;
('DESC' in order to return the greatest value first)
On Tue, 11 May 2004 17:28:05 +0200, Mikhail Entaltsev
<[EMAIL PROTECTED]> wrote:
>
> Hi,
>
> select YourField from YourTable order by YourField limit
Luther -
I would recommend picking up Paul DuBois' book MySQL - The Definitive
Guide. The MySQL.com website has docs which will answer your question,
but I think a good text always helps with learning MySQL.
If you have any specific questions or issues. Please feel free to ask.
Thanks,
--bmanse
oblem
Use INITCAP.
SELECT name, INITCAP(name) new_name
FROM customer WHERE firstname IS NULL
*** REPLY SEPARATOR ***
On 5/5/2004 at 12:43 PM Brian Mansell wrote:
>I may be wrong, but there isn't an easy method for completing this in
>SQL alone.
--
MySQL General
I may be wrong, but there isn't an easy method for completing this in
SQL alone. If you're using PHP, process the field with ucwords( )
http://www.php.net/ucwords on the other hand, capwords() in Python does
something similar, but replaces multiple spaces with individual spaces.
--bmansell
-
To get the current year, use:
SELECT DATE_FORMAT(NOW(), '%Y');
Basically you can use the DATE_FORMAT to show the present time as
desired.
--bmansell
-Original Message-
From: Greg Hosler [mailto:[EMAIL PROTECTED]
Sent: Friday, April 23, 2004 5:08 PM
To: [EMAIL PROTECTED]
Subject:
Jonas,
It's recommended in the docs that you upgrade your slaves to 5.0.0 before your Master
(http://www.mysql.com/doc/en/Replication_upgrade_5.0.html)
You shouldn't run into any problems with replicating InnoDB
tables.(http://www.mysql.com/doc/en/InnoDB_and_MySQL_Replication.html)
good lu
25 matches
Mail list logo
