Incoming from s. keeling:
Incoming from Pooly:
2005/10/3, s. keeling [EMAIL PROTECTED]:
I'd like to add a bit of history data to a table (who changed a record
last, and when it was last changed). Is this the way to do it?
[snip]
alter table MEMBERS
alter CHG_DATE set
Incoming from Arno Coetzee:
s. keeling wrote:
Grr. Please, what's wrong with this?!?
alter table MEMBERS
alter MEMBER_INFO varchar(160);
ERROR 1064: You have an error in your SQL syntax. Check the manual \
that corresponds to your MySQL server version for the right \
syntax
Incoming from Arno Coetzee:
sorry ... bit busy on this side... had a quick look...
give this a go...
alter table MEMBERS
MODIFY MEMBER_INFO varchar(160);
hope this works
It did. Much appreciated.
--
Any technology distinguishable from magic is insufficiently advanced.
(*)
Incoming from Pooly:
2005/10/3, s. keeling [EMAIL PROTECTED]:
I'd like to add a bit of history data to a table (who changed a record
last, and when it was last changed). Is this the way to do it?
[snip]
alter table MEMBERS
alter CHG_DATE set default CURRENT_DATE
btw, you
I'd like to add a bit of history data to a table (who changed a record
last, and when it was last changed). Is this the way to do it?
alter table MEMBERS
add CHG_BY varchar(3)
alter table MEMBERS
alter CHG_BY set default sbk
alter table MEMBERS
add CHG_DATE date
I've checked everywhere I can find (Paul DuBois' MySQL, ML archives,
dev.mysql.com, my local User Group) for this, but everything I find
either describes a simplistic or far more complex case. This is all
on my local box, no networking required, and I'm the only one
accessing the data. I've four
Incoming from Paul DuBois:
At 16:39 -0600 10/2/05, s. keeling wrote:
The admin account, with no password, doesn't function at all. perl
programs appear to ignore ~/.my.cnf forcing me to open() them and
slurp username and password that way.
How is this supposed to work? Surely, you're
Incoming from Paul DuBois:
At 18:50 -0600 10/2/05, s. keeling wrote:
Groan. More stuff to learn, configure, maintain, and memorize. I'm
trying to replicate Unix's root vs. mere user security paradigm in
I think your analogy is flawed. If you really want the root vs mere
user
On Sat, Sep 01, 2001 at 03:54:31PM -0700, Edward Blazer wrote:
When i do a portscan on my box, the mysql port does not show up leading me
to beleive that mysql has not bound to the port. I've confirmed this by
trying to telnet to the port, but I do not get the garble that I expect,
rather
On Sun, Sep 02, 2001 at 02:01:36AM +0200, Daniel Urstöger wrote:
Hiya !
I am not new with mysql, but I guess my experience is not enough for that
kind of problem ;)
mysql runs fine now the last 3 weeks, but now I am running into problems.
I want to restart mysql with the
On Sat, Sep 01, 2001 at 09:10:01PM -0500, Cal Evans wrote:
Wow, has it been a month already?
Please check the archives before posting. There are several discussions on
this exact topic.
Specifically, List-ID: mysql.mysql.com or:
:0:
* ^[EMAIL PROTECTED]
IN.mysql
for procmail.
--
Is anyone else getting these goofy bounces from 123box.co.uk besides
me? Should I report them to Spamcop? :-)
database, sql, ...
--
Any technology distinguishable from magic is insufficiently advanced.
[EMAIL PROTECTED] TopQuark Software Serv. Contract programmer, server bum.
On Fri, Aug 31, 2001 at 05:37:58PM -0300, Pablo Javier Gonzalez Mateos wrote:
Hello, im in this situation:
i have a PC AMD K6-2 with 64 MB RAM. SuSE Linux 6.3 OS
when i compile the php with mysql everything works fine, but after y
compile the apache with this command:
./configure
On Sat, Sep 01, 2001 at 04:43:25AM +0100, christopher sagayam wrote:
so how to fix the error ?
How did file /usr/local/mysql/bin/mysql
become a text file ?
You tell us.
Regardless, is your data still intact? Make sure it's safe, rip out
mysql, and re-install.
Binaries don't just become
On Thu, Aug 30, 2001 at 10:22:02AM -0600, Jeff Isom wrote:
I am fairly new to MySQL and I am unfamiliar with the term escaped form.
This a Unix-ism. For instance:
this line
'this line'
this\ line
The last two are functionally equivalent. The last one has an
'escaped' space embedded
On Thu, Aug 30, 2001 at 02:50:47PM -0400, Ryan Shrout wrote:
I have tried to enable slow query logging for a couple days now, with no
success.
I have tried adding the line to the my.cnf file as well as stoppign the
service then starting it with the command line version. Both ways, the
On Thu, Aug 30, 2001 at 11:00:14AM -0600, Benjamin Krajmalnik wrote:
OK. I tracked the problem to being out of disk space in the var partition.
The default source installation plaved the data in the /var/db directory.
The var partition is not that large by default, and therefore I am now out
On Thu, Aug 30, 2001 at 04:48:16PM -0500, [EMAIL PROTECTED] wrote:
Question,
Could some one tell me why our mysqld daemon appears to be incrementing on time.
For instance I get the following output when I use ps -elf. the 470 you see below
was 460
30 secs ago. Is there a memory
On Thu, Aug 30, 2001 at 05:01:14PM -0700, Rodney Broom wrote:
mysqld is restarting, a lot. So I put it into debug mode, got 200KB+
trace file, and then took mysqld out of debug mode. Now I'm trying
to analyze the trace file. The best clue I'm finding are these
lines:
vio_read: error:
On Thu, Aug 30, 2001 at 05:21:57PM -0700, Igbar Foosenhopper wrote:
Thursday, August 30, 2001, 2:13:56 AM, you wrote:
CT A quick question: How come the mailing list software
CT doesn't add a reply-to header? Is this intentional to
Reply to All seems to work
In mutt (g for group-reply), I
On Thu, Aug 30, 2001 at 12:21:28AM +0100, Kemal Danisman wrote:
Some people say translate INNER JOINS from Access to WHERE clauses, some say
Personally, I'd say drop Access and all references to it, and begin
redesign using a sensible alternative which doesn't encourage the
production of such
On Wed, Aug 29, 2001 at 11:39:22PM -0400, Gary Huntress wrote:
I run a mysql host that currently has about 5500 seperate mysql
databases. Yesterday one of my users reported to me that he couldn't
connect. I suspected many of the usual culprits (grants, network, wrong
[snip]
rule
On Wed, Aug 29, 2001 at 10:01:23PM -0600, s. keeling wrote:
On Thu, Aug 30, 2001 at 12:21:28AM +0100, Kemal Danisman wrote:
Some people say translate INNER JOINS from Access to WHERE clauses, some say
Personally, I'd say drop Access and all references to it, and begin
redesign using
On Sat, Aug 25, 2001 at 09:42:33AM +0800, aDragon wrote:
hi,
I think this mail list is very helpful to me.
But several hundred letters one day may bomb my mailbox up,
and it is a great problem to manage all the letter.
I have an advice to the friends who manage this list.
On Fri, Aug 24, 2001 at 10:07:59AM -0700, Katherine Porter wrote:
For single values I usually use this DBI function and query:
my $val =3D $dbh-selectrow_array(SELECT value FROM tab1 WHERE test=3D=
2);
However, what if I want to store a bunch of values into an array?
my @vals =3D
On Thu, Aug 23, 2001 at 04:15:47PM -0700, Edgart Gonzalez wrote:
Hi guys,
Could you please tell us if can I make a distributed query inside ob mysql
Something like :
SELECT A.c1, b.c2 from serverA.TableA A, serverB.TableB B
Wow, that would slow a db down. Not only are you waiting for disk
On Fri, Aug 24, 2001 at 09:05:35AM +0800, Osman Omar wrote:
Hi,
Hi yourself. Sorry for my last reply. I regret the insult.
Example, I have data inside my table
id model data_in
1 str-de453 20010910
Now I have new update data inside text file
eg model date_in
On Thu, Aug 23, 2001 at 06:30:37PM -0700, Armando Cerna wrote:
HI installed the mysql-server port in freebsd and the
/usr/local/etc/rc.d/mysql-server.sh file just disapeared its done this before
and I fixed it by reinstalling I think but I would like to avoid this. Does
anyone know
On Wed, Aug 22, 2001 at 03:19:43PM -0600, Sasha Pachev wrote:
Just to make it difficult for people to migrate to Oracle, the only
documentation that we provide for the PASSWORD() function algorithm is the
source :-)
On a serious note, what is it that makes MySQL not good enough for your
On Thu, Aug 23, 2001 at 08:35:44AM +0800, Osman Omar wrote:
I have these data inside my tables
id modelname datein
1 str-de345 20010901
-
Before posting, please check:
http://www.mysql.com/manual.php (the
On Tue, Aug 21, 2001 at 03:25:07PM -0500, Ben Davis wrote:
I have a .sql file that I got from a PHPMyAdmin dump. Now I want to run the
sql commands that are in that sql file, possibly even including the INSERT
commands.. I have one that contains just the structure and one that has the
On Sun, Aug 19, 2001 at 07:44:40PM +0200, Greennet wrote:
Greetings!
I'm trying to install Apache 1.3.20 and MySql 3.23.41.
During the make of Apache I get the following errors then make exits with
Errors 1 and 2.
On Sat, Aug 18, 2001 at 04:25:50PM -0700, John Meyer wrote:
Here's the error message that I am getting:
[911] [2] [0] [Microsoft][ODBC Driver Manager] Invalid string or buffer
length
And here is the code
my $sqlcommand = INSERT INTO
On Fri, Aug 17, 2001 at 10:51:17AM +0800, Denny wrote:
I am new to linux and i currently trying to install mysql on my redhat 7.1.
I always got this error message at the end of the make Internal error:
Segmentation fault..
I wonder if anyone would tell me what's going on?
My machine is
Post a couple of lines from your data file. Does .csv insist on all
values single quoted?
On Thu, Aug 16, 2001 at 09:03:36PM -0700, Yeong CN wrote:
Hi.
This is the script I write to upload a .csv file into my online mysql database :
$sql_query=LOAD DATA LOCAL INFILE '$textfile' INTO
Please, define supply. You want to hire me at some wildly
outrageous rate, or ... =[8]-)
On Thu, Aug 16, 2001 at 10:29:31PM -0400, jay downs wrote:
we at IOWNA Software Company would be happy to supply those outrageous fees if
anyone is interested.
Jay Downs
Owner
IOWNA Software
On Wed, Aug 15, 2001 at 11:30:44AM -0400, Philip Mak wrote:
I've had an ongoing problem where the SQL statements in my perl programs
come out rather messily.
Does anyone have specific and general suggestions on how to write embedded
SQL code cleanly in perl programs? Here's an example of an
Please suggest some newsgroups I can monitor to help me learn mysql?
Thanks. I've done the 'L' thing with slrn and *sql*, and this
mailing list shows up. :-)
I've just spent a very enjoyable weekend with mysql and perl DBI. Way
cool. I've been looking forward to this for too long.
I hope
38 matches
Mail list logo