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.
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
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 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
> >
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 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 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.
(*)
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
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
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 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
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 So
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
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 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 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 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 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 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 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 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 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 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 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 @
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 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 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 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 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 ou
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 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 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-
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:
>
> ./configu
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 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 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 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
42 matches
Mail list logo
