hi...
pls try this...
mysql> \T c:\result.txt
mysql >select name, email from messages;
after command executed...
you can use this command to stop print result to file.
mysql> \t;
mysql>
have a nice try :-)
Ivan Paul
MySQL, Query
- Original Message -
From: Scott Haneda <[EMAIL P
Hello All,
To start, I'm new to the list. My name is Mark Armendariz, currently
from Brooklyn NY.
Now for my question. I recently had a site go ballistic because of a
huge query I had with about 10 joins and some funky weirdness. It was
locking my db and using a temporary db, it was ugly. So
I want to send the results of
Select name, email from messages
To a plain text file, how can I do this?
Once I am in the mysql prompt, I can not issue normal shell commands, thanks
-
Scott HanedaTel: 415.8
On 24-Mar-2003 Daniel Rossi wrote:
> hi there i have a field which i place comma delimitered id's like so
>
> 64,14,13,15
>
> these are site id's which i check against a user who has access, i also
> use it to check if to show a banner on a particular site, although
> further checking showed th
Andreas-
I have similar problem
(bash shell)
$ mysqld
./mysqld: 1: Syntax error: "(" unexpected
Do I use the same solution or different solution?
I would give anything to understand what Syntax error: "(" unexpected
is trying to say
Thanks,
Martin
- Original Message -
From: "Andreas" <[
>I am trying to install on a AIX box. I do not want >to install into
>/usr/local. I have put everything >in /sybase/mysql/mysql. I am running
into
Set up a symbolic link from usr/local/mysql to the directory where your
files are stored. Let me know if you need any more help.
Scott Pippin
[EMAIL
Hello Don,
Well, you're right ;) I change the column type to int & it just run
perfect. Thanks to both of ya!
Monday, March 24, 2003, 5:21:35 AM, you wrote:
DR> On 24-Mar-2003 Michael Shulman wrote:
>> It looks like it's in now() format, but without the punctuation. The
>> line
>> from your in
hi there i have a field which i place comma delimitered id's like so
64,14,13,15
these are site id's which i check against a user who has access, i also use it to
check if to show a banner on a particular site, although further checking showed that
say i did a select * from table where sites_a
On 24-Mar-2003 Michael Shulman wrote:
> It looks like it's in now() format, but without the punctuation. The
> line
> from your insert statement is
Nope, that's a MySQL timestamp.
UNIX_TIMESTAMPS are # of seconds from the epoch (Jan 1 1970).
"nobody" <[EMAIL PROTECTED]> is trying to store an
Slawomir Orlowski schrieb:
I could connect with new /usr/local/mysql/bin/mysql client (old one was not
working) and select data from moved databases.
problem is that web pages are not working any more,
The old one doesn't find the socket.
I did and it worked, but I do not know what to do in
I could not start ./safte_mysql.
Error message:
touch: /usr/local/mysql/var/gemini.err cannot create
chown: /usr/local/mysql/var/gemini.err: No such file or directory
Starting mysqld daemon with databases from /usr/local/mysql/var
./safe_mysqld: /usr/local/mysql/var/gemini.err: cannot create
the "
Hi, i wonder how my server web site sometimes getting this
error
Err in ADO Object Connection [TCX][MyODBC]Can't connect
to MySQL server on'localhost' (10055) Microsoft VBScript runtime error
'800a01a8' Objectrequired: 'OpenConn()' /functions/fnc-default.asp, line
24
and i found a lot of
Hello Michael,
The most interesting part is that it's not in NOW() format! I've tried
one-two times the same query and:
mysql> select * from news;
+++--+-++
| ID | author | title| text
It looks like it's in now() format, but without the punctuation. The line
from your insert statement is
20030323225645
If we break this apart, we see:
Year = 2003
Month = 03
Date = 23
Hour = 22 (or 10pm)
Minute 56
Seconds 45
Someone else on the list: where or how is the timezone encode, or th
Very close.
Only one table may be updated per UPDATE statement.
Doug
On Sun, 23 Mar 2003 00:52:59 -, [EMAIL PROTECTED] wrote:
>Hi
>
>I may be way off base here but - why do you reference IMPORT_USERS in your
>UPDATE statement? You aren't updating any columns in that table.
>
>Regards,
>
>Sa
First of all, I want to say hello and sorry because my english it s very
poor. I hope you don't care about it.
My name is Esteban, I'm from Uruguay.
I begin whit mySQL and I have a simple question... for the moment... :)
If I define a BLOB(760) column. The maiximum size of the text it is 760
or 758
It seems to be this way on all the lists -- the java.mysql.com List-ID
header is missing, too.
--jeff
- Original Message -
From: "Joseph Bueno" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: "mysql-list" <[EMAIL PROTECTED]>
Sent: Sunday, March 23, 2003 1:43 AM
Subject: List-ID Header
>
I am trying to create indexes on several columns of a huge table in
MySQL 4.0.12 running on Windows 2000 Server. The table contains 42
million rows, and occupies about 7G of disk space. The server is a
1.5GHz P4 with 1G RAM, and performs fairly well - the load data infile
takes from 22 - 28 minut
> -Original Message-
> From: Nick Arnett [mailto:[EMAIL PROTECTED]
> Sent: Sunday, March 23, 2003 1:39 PM
At the risk of talking to myself too much... I've tried creating a table
that has about 100 records with lots of characters with ASCII > 126 and have
no problem building a fulltext ind
At 10:46 + 3/22/03, Andrew wrote:
Hi MySQL
I am now working on the insert into two tables :)
items and items_city
In each table there is the ID which is unique. This is what I have
so far and I
am not getting very far with it.
select from city and display ready for check box selection.
[
> -Original Message-
> From: Nick Arnett [mailto:[EMAIL PROTECTED]
...
> It dawned on me that perhaps the problem had to do with double-byte
> characters,
Actually, what I think I meant to say was "unprintable" characters with
ASCII > 122. Does this break fulltext indexing?
Nick
--
I'm trying to create a full-text index on a large (2.1GB, 1.6M records), two
column table (primary key and a TEXT field), using MySQL 4.0.12 on Win2000.
All looks like it is proceeding well, I see .TMP files in the database
directory and a couple of temporary files in TEMP. It chugs along for an
h
Hello mysql,
I do this:
$query = "INSERT INTO news(ID, author, title, text, date) VALUES(NULL,
'".$_SESSION["ulogged"]."', '".$title."', '".$text."', UNIX_TIMESTAMP(NOW()))";
$result = mysql_query($query, $connection) or die("problem with query");
I get this:
mysql> select * from news where id
Thanks!
I know I'm searching for for a long string within a short string - but that's why I
reversed the expression from "column LIKE(value)" to "value LIKE(column)"
But I think I just might go for your solution using the LOCATE function as it seems to
better fit this specific need.
/Jakob
> -
Dear all,
I started to work with the book "MySQL" from Pau DuBois.
When trying to load data into the samp_db the following two operations
don´t work:
LOAD DATA LOCAL INFILE "member.txt" INTO TABLE member;
-> ERROR 1148: the used command is not allowed with this MySQL version
mysqlimport --loca
The reason that what you are doing isn't working is because you are
trying to find a really long string in a short string. You need to
reverse your string searching.
Try:
SELECT URL, Name
FROM websites
WHERE LOCATE(URL,
'http://www.microsoft.com/kb/knowledgeb.asp?id=3&strse=12') > 0;
Here's s
At 1:47 -0500 3/22/03, Serge Paquin wrote:
Hello,
A few months ago I asked to have the ability to turn off autocommit at a
server level. I was told by a mySQL rep that this would not be added to the
3.23 tree but would be added to the 4 tree.
Well since 4 has been declared stable I have u
I thought you only could use the likesyntax like this;
SELECT column from table where column like '%data%';
i have a hard time seeing what goodit would be calling a column
http:// =)
check;
http://www.mysql.com/doc/en/Pattern_matching.html
regards
lasse
On Sun, 23 Mar 2003, Ville Mattila wr
> I tried to use LIKE:
> SELECT URL, Name
> FROM websites
> WHERE 'http://www.microsoft.com/kb/knowledgeb.asp?id=3&strse=12'
> LIKE (URL + '%');
>
> But this doesn't return any results. I would like the following as output:
> 'http://www.microsoft.com/kb/'Microsoft Knowledgebase
Hi!
How a
I wan't to search for all rows that match a value.
I have these rows:
URL Name
'http://www.microsoft.com/kb/' Microsoft Knowledgebase
'http://www.microsoft.com/search/' Microsoft Search
Now I wan't to find all occurences where any of above URL col
/cygdrive/g/mysql/mysql-3.23.55-pc-linux-i686/mysql-test
$ mysql-test-run
Installing Test Databases
Removing Stale Files
Installing Master Databases
../bin/mysqld: 1: Syntax error: "(" unexpected
Error: Could not install master test DBs
What is the cause of this error?
Thank You,
Martin
--
My
The mailing lists information on the MySQL website says that list
headers can be idenitified with either "List-ID:" or
"Delivered-To:". Though List-ID is missing at the moment,
Delivered-To is still present. Every other majordomo listserver I
see provides, List-ID; perhaps the change is an inadv
On 23/3/03 16:36, "Jeff Shapiro" <[EMAIL PROTECTED]> wrote:
>
> It looks to me like you have a permissions problem with your
> directories. You need to make sure that the directory own for the
> mysql directory tree is your mysql user.
[...]
> I just checked your error code with:
> [~] [0] > pe
Can't create file could be caused by not having enough free space left.
Easy to check .
I think I remember I got a different err number in a simular situation..
You did check permissions.. right?
B.
At 15:32 23-03-2003 +, Phil Dobbin wrote:
On 23/3/03 15:27, "Stefan Siefert" <[EMAIL PROTECTE
³×AI¹o ¸ÞAImysql sql er's
Does anyone else get this?
Andrew
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: 23 March 2003 16:36
To: [EMAIL PROTECTED]
Subject: 메일 전송 실패 알림 <[EMAIL PROTECTED]>
It looks to me like you have a permissions problem with your
directories. You need to make sure that the directory own for the
mysql directory tree is your mysql user.
You can't use the Users section of Systems Preferences to create the
MySQL user, you have to use the NetInfo utility. Apple as
On Sun, Mar 23, 2003 at 10:43:28AM +0100, Joseph Bueno wrote:
> It seems that emails coming from mysql mailing list
> don't include 'List-ID: ' header anymore.
>
> Is this going to be fixed or should we change our email
> filtering rules ?
This List-ID header has been restored.
Sorry for the ove
On 23/3/03 15:41, "Stefan Siefert" <[EMAIL PROTECTED]> wrote:
> Hi Phil,
>
> I guess I don't know the "best possible way" (is there realy one?). But
> let's see... Your OS is OS X? At the moment you are using 3.23.51, the
> actual Version is 3.23.56 I think ... well you could date your system up
Hi Phil,
I guess I don't know the "best possible way" (is there realy one?). But
let's see... Your OS is OS X? At the moment you are using 3.23.51, the
actual Version is 3.23.56 I think ... well you could date your system up I
guess (
http://www.mysql.com/downloads/download.php?file=Downloads%2FMy
On 23/3/03 15:27, "Stefan Siefert" <[EMAIL PROTECTED]> wrote:
> Hi Phil,
>
> ok, just to make sure your mysqld isn't damaged, what about replacing it
> with a new one (just binaries, not config and data)?
Sounds a good idea but I'm unsure how to go about it. Would you know the
best possible way?
Hi Phil,
ok, just to make sure your mysqld isn't damaged, what about replacing it
with a new one (just binaries, not config and data)?
Stefan
-Ursprungliche Nachricht-
Von: Phil Dobbin [mailto:[EMAIL PROTECTED]
Gesendet: Sonntag, 23. Marz 2003 16:21
An: Stefan Siefert; MySQL
Betreff: Re:
On 23/3/03 13:31, "Stefan Siefert" <[EMAIL PROTECTED]> wrote:
> Hi Phil,
>
> first of all I don't think your mysqld is damaged. I would first check the
> following:
>
> - where does mysqld looks for its datadir?
> - under which userid is mysqld supposed to run?
> - under which userid does mysqld
Hi Phil,
first of all I don't think your mysqld is damaged. I would first check the
following:
- where does mysqld looks for its datadir?
- under which userid is mysqld supposed to run?
- under which userid does mysqld runs?
- does the user under which mysqld runs have write access to the datadir
I'm having a problem starting the mysqld. I'm running 3.23.51 on Mac OS X
10.1.5 and have a startup script which confirms on boot that it has started
but doesn't.
I've tried starting manually from the CLI but no luck. I looked in
localhost.err and found:
030323 9:48:21 /usr/local/mysql-3.23.51/
I didn't think MySQL could be master and slave!
Andrew
>-Original Message-
>From: trashMan [mailto:[EMAIL PROTECTED]
>Sent: 23 March 2003 10:07
>To: [EMAIL PROTECTED]
>Subject: Unidirectional replication
>
>
>Hi,
>
>I've installed a mysql server as master and two other pc with mysql as
>
Hi MySQL SQL
I think I need to say this out loud and hopefully someone will read it ans say
stop you are doing this all wrong! Or wait a minute just do this :)
I am trying to display records (which was previously happening with just one
table!) from table 'items'
The search is based on category
Hi,
I've installed a mysql server as master and two other pc with mysql as
slave.
My application read (a lot) on local and write on server but if the
internet connection go down??
I can't write in the local table because the replica is unidirectional
sowhat can i do??
I've thinked to write
I think I need to say this out loud and hopefully someone will read it ans say
stop you are doing this all wrong! Or wait a minute just do this :)
I am trying to display records (which was previously happening with just one
table!) from table 'items'
The search is based on category and city
The
Hello,
It seems that emails coming from mysql mailing list
don't include 'List-ID: ' header anymore.
Is this going to be fixed or should we change our email
filtering rules ?
Thank you
Joseph Bueno
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:htt
Hi all,
I posted about this late yesterday and got some help, but I am really
stuck now. I need to display my results to the web using PHP.
Here is my query:
SELECT p.lname,p.fname,p.degree1,p.degree2,p.degree3,
w.web_link,
a.dra_id,
dra.area,
t.title,
id.interest_id,
i.
50 matches
Mail list logo
