Would you suggest mysql to build a vocabulary?
Any examples?
thank you
Pol
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi Friends,
Can you please help me this info, it would be of great help.
regards
anandkl
On 3/25/07, Ananda Kumar <[EMAIL PROTECTED]> wrote:
Hi Friends,
We are in the processing of building a new Mysql database. We are planing
to use innodb.
I need help on couple of questions.
1. What are t
Use --allow-keywords option with mysqldump command
Anil
-Original Message-
From: Brian Mansell [mailto:[EMAIL PROTECTED]
Sent: Monday, March 26, 2007 11:18 PM
To: Rob Tanner
Cc: mysql@lists.mysql.com
Subject: Re: Getting SQL errors porting databases between MySQL v4 and v5
The 'group'
Hi Daevid,
Ugh. How about not going berserk on the public mailing list?
We can understand that you're upset that you didn't read the manual
before starting a MyISAM to InnoDB conversion. You didn't do your
research and now you're being hit by a very simple (and not really all
that unexpecte
On Mon, March 26, 2007 16:21, Daevid Vincent said:
>> You're about 5 years too late for this converation, but I recall it
>
> Really? People have just happily accepted this absurd limitation for
> _five_
> years? Wow.
>
>> having to do with the fact that when you're on a table that supports
>> tran
> You're about 5 years too late for this converation, but I recall it
Really? People have just happily accepted this absurd limitation for _five_
years? Wow.
> having to do with the fact that when you're on a table that supports
> transactions, you don't know exactly how many records a particular
> > Is mySQL planning on fixing this BUG. YES -- it is a BUG. A
> BIG FAT HARRY
> > ONE.
> >
>
> I think you mean 'hairy', not 'harry'. There are no 'harry'
> bugs, apart
LOL! Doh! Yeah. I was so blinded by rage that I forgot my spelling.
> > It's completely stupid that I can't query and
group is a reserved word, so MySQL thinks you're attempting a 'group
by' statement. Put backticks around group, you should always quote your
table and column names.
DROP TABLE IF EXISTS `admission_quotes`;
CREATE TABLE `admission_quotes` (
`id` int(4) NOT NULL auto_increment,
`quote` text,
Daevid Vincent wrote:
Is mySQL planning on fixing this BUG. YES -- it is a BUG. A BIG FAT HARRY
ONE.
I think you mean 'hairy', not 'harry'. There are no 'harry' bugs, apart
from that British fool who's in line for the throne.
It's completely stupid that I can't query and get an accurat
In the last episode (Mar 26), Daevid Vincent said:
> > In the last episode (Mar 26), Daevid Vincent said:
> > > Aside from the incredibly annoying fact that InnoDB tables don't
> > > store a total COUNT(), my question is... Why are these numbers
> > > different? I could easily parse out the second
> In the last episode (Mar 26), Daevid Vincent said:
> > Aside from the incredibly annoying fact that InnoDB tables
> don't store a
> > total COUNT(), my question is... Why are these numbers
> different? I could
> > easily parse out the second query which is REDICULOUSLY
> faster. BTW, why
> > d
In the last episode (Mar 26), Daevid Vincent said:
> Aside from the incredibly annoying fact that InnoDB tables don't store a
> total COUNT(), my question is... Why are these numbers different? I could
> easily parse out the second query which is REDICULOUSLY faster. BTW, why
> doesn't mySQL just '
I installed a preconfigured package called MAMP on my MacBook Pro and have just
about everything working except my database connections. I can use phpMyAdmin
to manipulate databases and tables, but I can't connect to those databases from
Dreamweaver.
I read somewhere that you have to use a spec
Aside from the incredibly annoying fact that InnoDB tables don't store a
total COUNT(), my question is... Why are these numbers different? I could
easily parse out the second query which is REDICULOUSLY faster. BTW, why
doesn't mySQL just 'alias' the first query behind the scenes for us and
parse o
Yes I can touch the file with the mysql user. The only thing I can't do is a
select into file. However select into file works anywhere else on the
filesystem.
Thanks,
David Ruggles
CCNA MCSE (NT) CNA A+
Network EngineerSafe Data, Inc.
(910) 285-7200 [EMAIL PROTECTED]
-Original Mes
When using "USING" clause, yes the column must have the same name.
But there is an alternative called "ON" clause.
Example usage of "USING":
table t1, columns a,b
table t2: columns a,c
You want match t1.a against t2.a:
SELECT t1.a, t1.b, t2.c FROM t1 LEFT JOIN t2 USING(a);
---
Thanks Maciek:
The table that I'm doing this query on will be huge. It's
essentially the users table for an online activity with, we hope,
lots of users. :)
The thing is that if I do a query for the entire result set and use
PHP to figure out the position of the user and then do a query o
I have verified that the user can read and write as I mentioned in my first
post.
Thanks,
David Ruggles
CCNA MCSE (NT) CNA A+
Network EngineerSafe Data, Inc.
(910) 285-7200 [EMAIL PROTECTED]
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
Sent: Monday, Ma
Let me describe the problem another way, too. It's related to
creating a paging interface to view many records. I figured that
people deal with paging all the time and the solution to my problem
may already be out there.
Typically when you access a single record via a top down method, i.e
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
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 the following command to dump the data in the v4 installation:
mysqldump -u root --password=secret --add-drop-table --databases db1
db2 db3 db4 db5 db6
On 3/26/07, Anil D <[EMAIL PROTECTED]> wrote:
Varchar = 0 bytes
I don't think this is right, see below.
Charset used: UTF8
UTF8 means that some characters may be two bytes, see below.
Note: When consider even the size Varchar(m) = m+1 bytes, the size of row
has reached 35,000 bytes.
Thank you.
You say the column must be in both tables, do you mean that the column name
must be the same in each table?
Sid.
Sid Price Software Design
http://www.softtools.com
_
From: Ales Zoulek [mailto:[EMAIL PROTECTED]
Sent: Monday, March 26, 2007 10:06 AM
To: [EMAIL PROTE
Yes, but wouldn't it be the user that the mysql service is running as? That
is the user I am logging in as to test this.
Thanks,
David Ruggles
CCNA MCSE (NT) CNA A+
Network EngineerSafe Data, Inc.
(910) 285-7200 [EMAIL PROTECTED]
-Original Message-
From: [EMAIL PROTECTED]
[mai
Can you "touch" the file name? It might be a permission issue at the
directory level, it has to be writeable.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
> -Original Message-
> From: David Ruggles [ma
Try:
select * from business_names
left join business_entries using (bus_id)
left join business_categories using (bcat_id)
where business_categories.bcat_id=17
order by business_names.organisation
You must have brackets around column name after "USING" and do not write
table names there, 'cause t
I'm unable to select into an outfile, the path is in an nfs mount point. I'm
sure it's some sort of permissions issue or something, but I can't figure it
out. I've googled everything I can think of and haven't found anything. Any
help or suggestions would be greatly appreciated.
The error I'm gett
Micah,
I think I understand, here is my query, however I get a syntax error report
and it is not clear what the problem is. Any suggestions:
select * from business_names
left join business_entries using business_entries.bus_id
left join business_categories using business_categories.bcat_i
Hello Lucas,
[EMAIL PROTECTED] wrote:
I don't see how to use this here, I will have to research the |/||/|
select rpad(|IFNULL(|null, ''),5,'1');
|/||/|
The function you want to use is IFNULL() documented
here:http://dev.mysql.com/doc/refman/5.0/en/control-flow-functions.html
Try it
hello,
i am having some trouble getting mysql to perform decently on my machine. it is
a 2 GHz dual core AMD 64 machine (although i am presently running a 32 bit
linux system) with 1 Gb RAM and 1 Gb swap partition. the data i am using is
loaded into a table described by:
CREATE TABLE IF NOT EX
Hi,
Is it possible using PHP (PDO or native mysql/mysqli drivers) to do XA
transactions over two seperate database servers. In my case I need to process
remove rows from a production database server only once the slave has processed
the rows, and using XA transactions sounds like the better way t
31 matches
Mail list logo
