Hi Ariel,
Maybe this example helps you to create CSV output from MySQL.
The first SELECT generates the headerline; the second the data.
( SELECT 'FieldA','FieldB','FieldC', ... )
UNION
( SELECT `FieldA`, `FieldB`, `FieldC`, ...
INTO OUTFILE 'D:/MySQL Datafiles/myFile.csv'
FIELDS TERMINATED BY '
hi guys, it's a simple thing (I think), but I can't find the docu on
this from the mysql site.
Thanks in advance for the help.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Heikki
Please see my testing result on MySQL Forum
http://forums.mysql.com/read.php?22,74279,74279#msg-74279
I need explanation about this issue :)
Heikki Tuuri wrote:
Ady,
- Original Message - From: "Ady Wicaksono"
<[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Mo
Ady,
- Original Message -
From: "Ady Wicaksono" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Monday, March 06, 2006 5:32 PM
Subject: MySQL InnoDB Row insert Calculation
With autocommit=1, anybody could give calculation on how many rows could
be inserted in 1 seconds?
Daevid,
- Original Message -
From: ""Daevid Vincent"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Tuesday, March 07, 2006 5:54 AM
Subject: RE: Boolean searches on InnoDB tables?
Osku is working on FULLTEXT for InnoDB.
So, despite what the documentation says:
http:
Osvaldo,
- Original Message -
From: ""Osvaldo Sommer"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Tuesday, March 07, 2006 12:58 AM
Subject: Problem INNODB error 995
--Boundary_(ID_PMYElD1sU13Il0ENO4J+aw)
Content-Type: text/plain;
charset=us-ascii
Content-Transfer-E
Anyone have some pointers at a HowTo on creating a social network?
Basically I need to show people in your immediate network, and also friends
of your friends, etc... Like the whole 'six degrees of separation' thing.
Ala: myspace, friendster, etc. ad nauseum.
I prefer mySQL and PHP, but I could p
Speed of InnoDB Insert with autocommit=1;
Personal Test !
Linux : Fedora Core 4, kernel 2.6.11
mysql> \s
--
mysql Ver 14.12 Distrib 5.0.18, for pc-linux-gnu (i686) using readline 5.0
Connection id: 2349
Current database: test
Current user: [EMAIL PROTECTED
Date: Sun, 5 Mar 2006 16:59:13 +0100
To: mysql@lists.mysql.com
From: Jochen Kaechelin <[EMAIL PROTECTED]>
Subject: is this safe against sql-injection?
Message-Id: <[EMAIL PROTECTED]
Can somebody give me some general hints how to prevent
sql-injection?
You may also want to consider the use of the
> Osku is working on FULLTEXT for InnoDB.
So, despite what the documentation says:
http://dev.mysql.com/doc/refman/5.0/en/fulltext-boolean.html
Which states:
"They can work even without a FULLTEXT index, although a search executed in
this fashion would be quite slow. "
You're saying that InnoDB t
Im trying to select an IP from a TEXT (details) type field, which works if I do
this:
select id from `table` where `details` like '%192.168.0.1%' :
But If I want any record with an IP in that TEXT type field it seems a little
tricky. I have tried:
select id from `table` where INET_ATON(details)
SELECT DISTINCT can be kind of slow if there are many result values,
specifically if those result values include large VARCHARs. Furthermore,
some database engines cannot support a SELECT DISTINCT if any LOBs are
included in the result values.
I'm trying to find a general way to optimize SELECT DI
The original message was included as attachment
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Bibi,
WinMySqlAdmin has been disocntinued. Try
mysql/bin/MySqlInstqanceConfig.exe.
Getting PHP to work with MySQL under Windows is a bit tricky at first,
but once set up it's solid. For setup have a look at
http://forums.mysql.com/read.php?52,70381,70628#msg-70628.
PB
http://www.artfulsoftwa
We have 4 windows 2003 server with mysql 4.0.12 install in each one. They
have been working for about 1.5 years with no problem.
Two weeks ago, in one server we lost the mysql service, and when we look the
.err file it report a 995 error. We can star the service again and it works.
In the two
Hi everybody,
I have Windows XP computer and I've installed Apache, and MySQL 5.0.18. I
downloaded MySQL from:
http://www.softpedia.com/progDownload/MySQL-for-Windows-Download-2668.html
but the following problem occurs.
According to the instructions in php and mysql for dummies (I'm a newbee) I
sho
Maybe, if you make a file with the SELECT content and call them
from the OS shell, like this:
SELECT table1.a, tabela1.b, table1.c FROM mydatabase.table;
After, call this file from the OS shell:
shell>mysql -A mydatabase < my_file
This will result on the screen. You can direct the result to a
At 14:12 -0600 3/6/06, Ariel Sánchez Mora wrote:
When using select into outfile, I can only get
the table data, but I can't find how to include
the column names. I haven't been able to include
the column names into the actual return of the
query, and they don't get stored in the .csv
Anyone
Ariel Sánchez Mora <[EMAIL PROTECTED]> wrote on 03/06/2006 03:12:20 PM:
> When using select into outfile, I can only get the table data, but I
> can't find how to include the column names. I haven't been able to
> include the column names into the actual return of the query, and
> they don't get
When using select into outfile, I can only get the table data, but I can't find
how to include the column names. I haven't been able to include the column
names into the actual return of the query, and they don't get stored in the .csv
Anyone know how to include the column names, table name, oth
Hi,
is it not possible to lock federated tables (creating a lock on the remote
machine to lock the table on the machine containing the data?)
I've a situation where I have some different databases on different servers but
they share a small amount of tables that are physically stored on only one
Hi,
MySQL 5.1.7-beta, a new version of the popular Open Source Database
Management System, has been released. The Community Edition is now
available in source and binary form for a number of platforms from our
download pages at
http://dev.mysql.com/downloads/ and mirror sites.
Note that not a
Jochen Kaechelin wrote:
Can somebody give me some general hints how to prevent
sql-injection?
I always go this way to build my queries:
function clean_mysql_string($string) {
$clean_string = stripslashes($string);
$clean_string = htmlentities(strip_tags(($clean_s
hello
i have a strange problem.
freebsd 6.0 amd64, dual xeon
mysql 5.0.18
huge conf, myisam and heap tables.
around 1000 query/sec, without any problem in the last 2 week.
the problem is:
the stuff is running perfectly with a load of 0.8-1.0
it was correct, but 20 hours before something happened
Well,
I supposed that your slave is broken from now, because your bin-log
is not the exact situation of your databases. So:
1) no. If your slave is stopped for a abrupt lost of connection to your
master, the old binlogs cannot do anything about. You need to copy the
databases from your master to
With autocommit=1, anybody could give calculation on how many rows could
be inserted in 1 seconds?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I believe Daniel is correct. The passwords are hashed before leaving the
client. You may be able to capture invalid hashes but they are already
encrypted before they get to the server. I do not know of any event or
callback function you can use to tie into the server to trigger a logging
event.
jonathan <[EMAIL PROTECTED]> wrote on 03/05/2006 03:19:41 PM:
> is there a way to view the current number of connections in mysql?
> I'm developing a PHP / MySQL app and would like to be able to debug a
> few performance problems.
>
> Ideally, I'd like to be able to query the number of current
Hello all,
I had a problem last night where my Master server filled up the /var/
partition and stopped logging to the bin log. This caused all sorts of
havok on my slaves and replication. My bad for not watching this but now
what I'd like to do is move where MySQL writes the binlog to. Currently
[snip]
While writing a Script file for Batch execution, Suppose I just wanna
print
a comment on screen how should I do that.. ?
( I want and output Comment on Screen )
Can any one suggest rather than using a SELECT statement to print an out
put
on screen for the same purpose..
[/snip]
Depending
I was wondering about a simple solution.
While writing a Script file for Batch execution, Suppose I just wanna print
a comment on screen how should I do that.. ?
( I want and output Comment on Screen )
Can any one suggest rather than using a SELECT statement to print an out put
on screen for t
Hi,
Any info about when 5.0.19 will come out? We have some serious problems
with some bugs is MySQL 5.0.18, and we have to choose: wait a bit, or
try to downgrade to 4.1.x (and unfortunately no guarantee, that there is
no bug there, too).
Bye,
Andras
--
MySQL General Mailing List
For list
On 3/5/06, Manuel Schmitt (manitu) <[EMAIL PROTECTED]> wrote:
> > is there a reason that the unknown passwords can't simply be reset?
>
> yes, because not all clients are currently known and resetting them
> would possibly break the application(s)
I am not pretty sure, but MySQL use to send encryp
Hi, List!
First of all, what does mean 'log' suffix in version name of MySQL server?
I have some problems with MySQL server 4.0.25-log (Don't say that I
should update it. I don't have such privileges, so I have to deal with
it). Server doesn't understand quoted DB names in USE statement.
my
Hi!
unplug wrote:
Thanks!
If I have the glibc 2.3, I have to use Linux x86 generic RPM
(dynamically linked). Otherwise, version lower than 2.3, we should
use Linux x86 generic RPM (statically linked against glibc 2.2.5). Am
I right?
Yes.
HTH,
Joerg
--
Joerg Bruehe, Senior Production Engin
35 matches
Mail list logo
