Hi gang, sorta newish to MySQL so please bear with me...
I am putting together a system of referals for my photography company.
The referal system works, like many others. A business refers customers
to me, for which they recieve a referal fee when the customer pays a
deposit.
I can create a the
oh,yes.
There is a blob column in mytable.So i use "dumpfile" instead of "outfile".
There are more than 100 rows in mytable.
The follow sql is successful: select * into dumpfile '/home/wangxu/test4.data'
from mytable where id=1 or id=2;
Why it is false that select all rows in mytable?
At 10:15 AM +0800 4/11/07, wangxu wrote:
follow is my sql:
select * into dumpfile '/home/wangxu/test4.data' from mytable ;
mysql server report: Result consisted of more than one row
why?how to use the "select into dumpfile"?
From the manual:
If you use INTO DUMPFILE instead of INTO
follow is my sql:
select * into dumpfile '/home/wangxu/test4.data' from mytable ;
mysql server report: Result consisted of more than one row
why?how to use the "select into dumpfile"?
Hey.
We have the need to have some tables stored in memory for performance
reasons.
We were thinking about just using MEMORY tables but this is non ideal since
it uses a fixed row size.
Using MyISAM would be much better since it supports variable length rows.
Backups would be handled by just u
I've got a table with two fields, (a string [Primary Key], and an
integer).
The table needs to be as secure as possible against corruption,
and need as fast access as possible, but do not need transaction
support.
(The integer is an access counter for a web page, so is does not need
to be ve
Baron Schwartz wrote:
Greetings,
On 5.2.3:
select plugin_name, plugin_license from plugins;
+-++
| plugin_name | plugin_license |
+-++
| binlog | GPL|
| partition | GPL|
| ARCHIVE | GPL|
| BLA
At 4:46 PM -0400 4/10/07, David T. Ashley wrote:
I'd like to have a table in MySQL with the key field being a 12-character
text string consisting of digits and upper-case letters (minus the vowels
and Y, to prevent accidental bad words), i.e. something like:
XM39C6B4...
When I do queries and ge
I'd like to have a table in MySQL with the key field being a 12-character
text string consisting of digits and upper-case letters (minus the vowels
and Y, to prevent accidental bad words), i.e. something like:
XM39C6B4...
When I do queries and get back result sets sorted on this text string, is
The closest thing to an absolute limit on query size is the value of
the configuration variable max_allowed_packet which defaults to 1 meg.
- michael
On 4/10/07, Anil D <[EMAIL PROTECTED]> wrote:
Hi List,
What is the practical limit on size of the sql query in mysql 4.1.x
Anil
--
Oie,
Sim, é seguro usar MySQL 64Bits.
Is safe to use MySQL 64Bits, much better Innodb.
Only try to understand that + 10% of Memory is use for 64 bit.
For example : total memory 4G ( OS 10% + IO 10% + database 70% + 10% for use
64Bit). You must reserve this 10% in the ecuation.
Any help, pleas
I want to use Debian 4.0 x64 with MySQL 64 bits... (5.0 version) and
InnoDB tables
is it safe ?
is it stable ?
is it ready for enterprise production ?
TNKS !
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMA
I get "Illegal mix of collations (latin1_swedish_ci,COERCIBLE) and
(utf8_general_ci,IMPLICIT) for operation 'UNION'.
in a query like (SELECT ...) UNION (SELECT * INTO OUTFILE ...) to build a CSV
file.
The database has default charset UTF8 and collation utf8_general_ci
and all query tables have d
Hi,
Try the format below:
ALTER DATABASE mybase DEFAULT CHARACTER SET = latin1;
ALTER DATABASE mybase DEFAULT COLLATE = latin1_swedish_ci;
HTH ...
- Original Message -
From: "Mário Gamito" <[EMAIL PROTECTED]>
To: "MySQL List"
Sent: Monday, April 09, 2007 4:19 PM
Subject: charset
14 matches
Mail list logo