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 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 \
> >
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?
>
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
> >
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
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
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.
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
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: " or:
:0:
* ^[EMAIL PROTECTED]
IN.mysql
for procmail.
--
Any technol
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 /etc/rc.d/ini
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,
> rath
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 "b
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:
>
> ./configu
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 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-
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: er
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 m
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 ou
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 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 embe
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 t
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]
> rul
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 suc
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 @
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 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 an
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_i
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
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 (th
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
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
> st
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.
>
>
>
> /usr/local/mysql-3.23.41/lib/li
On Sun, Aug 19, 2001 at 10:52:00AM +0100, Mike Clemson wrote:
>
> gcc
> filename.c -I/usr/local/mysql/include -L/usr/local/mysql/lib -lmysqlclient
>
> and get the error:
>
> /usr/local/mysql/lib/libmysqlclient.a (my_compress.o): In function
> 'my_compress':
> my_compress.o (.text+0x9a): undefin
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
> EMAILS(PERSONALITY_ID,EMAIL_HEADE
On Sat, Aug 18, 2001 at 11:07:06AM -0400, Steven Marx wrote:
> I am having a problem with MySQL. I am seeking some advice on either what is wrong
> or how to pursue the cause of this bug.
>
> I am using Perl DBI to interface with MySQL and when i execute the
> following statement:
> $dbh = DBI->c
On Fri, Aug 17, 2001 at 10:55:03PM -0500, Craig Westerman wrote:
> I have data I create daily in MS Excel. I need to insert this data into
> MySQL data base on my web server every night. Does anyone here have a VB
> technique to upload to MySQL from Excel via a macro?
VB?!?! Pth!
-F blahbla
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 So
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
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 m
Am I missing something? I just looked at this thing (General
Discussion List?) from netscape and lynx. It looks like a brain dump
of subject lines[*]. I clicked on threaded, same. There's some
cryptic "[#]" along the left side; does that have any meaning?
Is my browser just too old to do what
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 o
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 thi
42 matches
Mail list logo
