On Sun, 30 Jan 2005, Andy wrote:
Hi all
I just wanted to know what would be the easiest way to retrieve simple data
from a MySQL database from a bash script.
I do this a lot - just construct the query and dump it into a file from
within the script, eg:
echo select * from widgets
On Thu, 9 Dec 2004, sharif islam wrote:
How mysql deals with spaces in table / column name? I am also using
mysqlcc. If I try the following in the doesn't work. Creating table
name with spaces from mysqlcc didn't give any error. But the following
does:
INSERT INTO 'tbl name with spaces'
On Wed, 24 Nov 2004 [EMAIL PROTECTED] wrote:
Dear all,
We are running mysql 4.0.17 on linux environment. Our database resides
on external disk connected via FC cables. We recently noticed a loss
of data in the following scenario.
Inserted a row in a table in a separate transaction by a
On Fri, 12 Nov 2004, Fagyal Csongor wrote:
Hi List,
I am putting in a separate disk for our MySQL (4.1.7) server. I have
some MyISAM, some InnoDB tables. Lots of reads, lots of writes (mostly
atomic ones, insert/update one row), a few million rows per table,
approx. 100-400 queries per
On Mon, 8 Nov 2004, José Antonio Viadas O. wrote:
Can someone help me, i have two files one dbf and one dbt thant i need to
import it in mysql, can someone help me telling me how can i do this.
Have a look at dbf2mysql (http://dbf2mysql.soourceforge.net) - this will
import .dbf files. I'm not
On Wed, 3 Nov 2004, Yves Arsenault wrote:
Hello all,
I have MySQL installed on a Mandrake Linux system, it is installed on
the /usr partition.
I was wondering, is it possible to store some databases on the /var
partition while MySQL is installed on the /usr partition?
Yes. In fact,
On Thu, 23 Sep 2004, John Meyer wrote:
Just to let people know. And BTW, you have to say that you want the
account. Reply off list.
Onlist, I'd like to know how most people back up their Mysql dbs? XML
or direct SQL file? I prefer the latter, although I'd like to hear
from proponents of
On Wed, 15 Sep 2004, [GB2312] ÀîÈñ wrote:
Hi
I have installed some software on aix5.2 .
the list of software:
apache-1.3.29-1.aix4.3.ppc.rpm
php-4.0.6-5.aix4.3.ppc.rpm
MySQL-3.23.47-3.aix4.3.ppc.rpm
MySQL-client-3.23.47-3.aix4.3.ppc.rpm
All of them was installed by using the command :
On Wed, 15 Sep 2004, [GB2312] ÀîÈñ wrote:
Hi
I have installed some software on aix5.2 .
the list of software:
apache-1.3.29-1.aix4.3.ppc.rpm
php-4.0.6-5.aix4.3.ppc.rpm
MySQL-3.23.47-3.aix4.3.ppc.rpm
MySQL-client-3.23.47-3.aix4.3.ppc.rpm
All of them was installed by using the command :
On Wed, 15 Sep 2004, nestor(earth) wrote:
People,
This more of a php mysql question. I have installed PHP ( 5.01) with
Apache(1.31) and it runs.
I have install Mysql (the latest as of last night) and it runs. My
problem is that PHP does not see
Mysql. Now I have done this installation
On Wed, 15 Sep 2004, Greg Donald wrote:
On Wed, 15 Sep 2004 16:02:45 +0100 (BST), andy thomas [EMAIL PROTECTED] wrote:
Did you build both php and apache with MySQL support?
I wasn't aware you could build Apache with MySQL support. How is that done?
Apologies - I should have said just php
my apache with MySQL
support! I tend to build my apache httpd with modules like php and
mod_auth_mysql statically compiled into the binary (for speed and
performance reasons) rather than loaded at run-time as a dynamic module.
Andy
-Original Message-
From: andy thomas [mailto:[EMAIL
On Fri, 27 Aug 2004, Lehman, Jason (Registrar's Office) wrote:
I am switching from a Windows computer to a Linux computer and when I
dump the data from Windows to Linux I have no problem except for the
fact that some of my characters have been converted to strange
characters and when the data
On Tue, 13 Jul 2004, s.ahmad wrote:
thankyou for your kind attention.
there are 50+ Reservation stations in the country. Where multiple
operators are sitting and reserving seats. Indexes are being used in
the DB. as i am related to hosting company, i havent seen if they are
taking advantage
On Fri, 2 Jul 2004, Chuck Barnett wrote:
Hello, I have a huge problem that you guys may be able to help me with.
I did a mysqldump all databases into a sql71.sql file.
when I try and I get the following error when trying to restore
ERROR 1050 at line 204528: Table 'columns_priv' already
On Tue, 29 Jun 2004 [EMAIL PROTECTED] wrote:
Hello!
We are currently running with one big ms sql-server.
Is it possible to do federated servers on mysql?
What I want to do is to purchase one more server and split the work load on
the two servers.
Yes, you can use master/slave
.
Andy
-Mensagem original-
De: andy thomas [mailto:[EMAIL PROTECTED]
Enviada em: terça-feira, 8 de junho de 2004 08:51
Para: [EMAIL PROTECTED]
Assunto: ORDER BY problem
In a table called 'advisers' I have a column called 'surname' which
contains the surnames of a number of people
: andy thomas [mailto:[EMAIL PROTECTED]
Gesendet: Dienstag, 8. Juni 2004 13:51
An: [EMAIL PROTECTED]
Betreff: ORDER BY problem
In a table called 'advisers' I have a column called 'surname' which contains the
surnames of a number of people. Using a query like: 'select * from advisers order
On Tue, 8 Jun 2004, Andy Eastham wrote:
Andy,
Just:
select substring_index(surname,' ',-1) as r from advisers order by r;
Yes, that did the trick!
Thanks,
Andy
-Original Message-
From: andy thomas [mailto:[EMAIL PROTECTED]
Sent: 08 June 2004 15:57
To: Andy Eastham
Cc
|
| Andy | Thomas |
| Gabrielle | de la Tour |
++--+
SELECT CONCAT_WS(' ', first_name, surname_prefix, surname) AS name
FROM advisers
ORDER BY surname, surname_prefix, first_name;
+--+
| name
In a table called 'advisers' I have a column called 'surname' which
contains the surnames of a number of people. Using a query like:
'select * from advisers order by surname' lists the people in the
correct order but some people have surnames like 'du Sautoy' and
'van den Berg' and these are
On Tue, 8 Jun 2004, Paul McNeil wrote:
I have never done anything like this but after looking at the spec's I have
a possible direction for you
In String functions there is
LOCATE(substr,str,pos)
The first syntax returns the position of the first occurrence of substring
substr in
the IF
syntax, etc (not done this before ;-) so that the result from thsi query
can be used as an argument for the next.
cheers,
Andy
andy thomas wrote:
Yes, this is the approach I was thinking of using but:
select locate(' ','surname',1) from advisers
just returns 0 for all records
On Tue, 8 Jun 2004, Andy Eastham wrote:
Look at using the Reverse() function, then take the substring up to the
first space, then reverse the result.
Well, 'select substring_index(surname,' ',-1) from advisers' does the
trick as far as extracting the wanted parts of surnames at the end of
the
On Wed, 12 Feb 2003, Dan Tappin wrote:
Does any one have a suggestion on running a daily / weekly e-mail
notification based on results from a MySQL query?
I have a table with date sensitive rows. The idea that as rows become
stale (they were created / updated more than a week or month ago)
On Wed, 4 Dec 2002, Helmut Apfelholz wrote:
Hi,
I am assembling mysql only server. I am planning 2Gb
RAM, 4 x 15k SCSI disks. However I cannot decide if I
should get 2 p4 processors or 2 tuallatin pIII.
I could not find any mysql specif?c benchmarks, that
would show which processors I
On Sat, 9 Nov 2002, R. Hannes Niedner wrote:
On 11/10/02 5:12 AM, Robert Macwange [EMAIL PROTECTED] wrote:
I am bothers me.
It bothers me that that the MySQL people have a bias towards PHP.
PHP is an inferior language. Deal with perl instead.
Robert
On Wed, 6 Nov 2002, von Boehn, Gunnar wrote:
Hello,
what is the status of MySQL 4.x for debian?
Does MySQL AB plan to release deb paketes or will
MySQL AB support or encourage the debian pakete maintainers?
I think MySQL policy is to support generic packaging formats applicable to
all
On Fri, 27 Sep 2002, Michael J. Fuhrman wrote:
Hello All,
I seem to be running into a very strange problem.
In the mySQL command line interface I issue SELECT COUNT (*) FROM
The correct syntax is SELCT COUNT(*) ie, there's no space between SELECT
and the (*).
Andy
On Mon, 2 Sep 2002, Marian wrote:
Why mysql corrupt tables if filesystem if full ... ?
On good database servers (eg. PROGRESS) process shutdown server
(protetcting data).
sytem:
linux-2.2.19
mysql-3.23-38
Good sys admins don't let filesystems become full
Andy
On Mon, 8 Jul 2002 [EMAIL PROTECTED] wrote:
Todd Cary writes:
Is there a quick and simple way to move a MySQL DB from one server to another
MySQL server? Can I just copy the tables?
for as far i know, you can just copy the directory ( DB ) from one server to
the other.
i've done
On Tue, 2 Jul 2002, Darley, Terry wrote:
I'm in the UK and I can get to it okay !!!
Perhaps something has changed on your PC/Network ???
I've had problems reaching the MySQL web site too. I think it's to do with
the fact I'm connecting through a UK academic site which relies in ebone
for
Does anyone know if stored procedures have been implemented in MySQL?
Getting into the MySQL web site from the UK is almost impossible these
days so I thought I'd ask here.
Thanks in advance for any information,
Andy
-
-
From: andy thomas [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, June 27, 2002 7:01 AM
Subject: Stored procedures
Does anyone know if stored procedures have been implemented in MySQL?
Getting into the MySQL web site from the UK is almost impossible these
days so I thought
On Thu, 18 Apr 2002, Atila Hajnal wrote:
We have Digital UNIX V4.0F (Rev. 1229) and we will to run MySQL but
only binary is for OSF 5.1 version. This isn't adecvate.
Can anybody help us in compiling source or have anybody binary version
(just compiled)?
I have a version 3.23.18 binary
On Sat, 6 Apr 2002 [EMAIL PROTECTED] wrote:
I sense this could be a troll, but...
/* Hugh O'Loughlin [[EMAIL PROTECTED]] writes: */
.
.
Frankly, the agreement your client should look at cancelling is the one
with your company. Your inability to install MySQL notwithstanding,
jumping
On Fri, 5 Apr 2002, Steve Rapaport wrote:
On Friday 05 April 2002 06:37 pm, andy thomas wrote:
On Fri, 5 Apr 2002, Steve Rapaport wrote:
With InnoDB, I'm sure this problem goes away, but as soon as we
go to InnoDB, we have to pay for backups and support,
which means we start looking
be run through a suitable web
server, browser, etc - I want a command line solution like mysqlshow ...
or from within the mysql client itself.
Andy
-Original Message-
From: andy thomas [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 03, 2002 11:23 PM
To: [EMAIL PROTECTED]
Subject
On Wed, 3 Apr 2002, Nick Arnett wrote:
-Original Message-
From: Doug Bishop [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 03, 2002 10:13 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: Table statistics
Try:
?
mysql_connect(localhost, user,
On Thu, 4 Apr 2002, denonymous wrote:
From: andy thomas [EMAIL PROTECTED]
Is there a command I can give in the mysql client to find the number of
rows in a table or, better still, the number of rows in all the tables in
a database?
To return the # of rows in a table:
SELECT COUNT
On Thu, 4 Apr 2002, Georg Richter wrote:
On Thursday, 4. April 2002 10:42, andy thomas wrote:
Yes but this is PHP code that can only be run through a suitable web
server, browser, etc - I want a command line solution like mysqlshow ...
or from within the mysql client itself.
You can
Is there a command I can give in the mysql client to find the number of
rows in a table or, better still, the number of rows in all the tables in
a database?
Andy
-
Before posting, please check:
On Tue, 26 Mar 2002, [EMAIL PROTECTED] wrote:
Hi there .
I am new to Mysql.I have to access mysql from coldfusion..and we dont get
myODBC as binary for solaris 6 ot 8. so we have to compile them...and i am
not able to compile the myODBC bit...its giving compilation problem..Any
-Message d'origine-
De : andy thomas [mailto:[EMAIL PROTECTED]]
Envoye : mardi 26 mars 2002 13:14
A : [EMAIL PROTECTED]
Cc : [EMAIL PROTECTED]; [EMAIL PROTECTED]
Objet : Re: Coldfusion,Mysql,Myodbc
On Tue, 26 Mar 2002, [EMAIL PROTECTED] wrote:
Hi there .
I am new to Mysql.I
On Tue, 26 Mar 2002, colin o wrote:
Same thing happens to me,
i just use bin/safe_mysqld --user=root
to start to server so that i can use mysql.
I don't know exactly why it happens though.
Possibly permissions??
It is better to run mysqld as a non-root user, such as mysql.
--- Mike
We have a Unix server which in addition to running MySQL is also a
fileserver for a group of MS Windows PCs (using samba) and it would be
useful to be able to convert the Microsoft Access .mdb files put there
by users directly to MySQL, or at least to .csv format.
Does anyone know of such a
On Tue, 19 Mar 2002, Young Sul wrote:
Hi,
I've got a website that uses a mysql backend database. Due to the way in
which
the database and development has been architected, I'm unable to
load-balance
the database between multiple DB servers, taking advantage of replication
inherent
in
47 matches
Mail list logo