.
-Original Message-
From: Stefan Hinz, iConnect (Berlin) [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 23, 2003 2:27 AM
To: Norris, Joseph; Mysql_List (E-mail)
Subject: Re: Install on WIN2k
Norris,
ERROR 2003: Can't connect to MySQL server on 'localhost' (10061)
I remember this well but I
Thanks Stefan - I found the problem in my my.ini file. Fixed and on.
Thanks for the help.
-Original Message-
From: Stefan Hinz, iConnect (Berlin) [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 23, 2003 3:15 PM
To: Norris, Joseph; Mysql_List (E-mail)
Subject: Re: Install on WIN2k
-Original Message-
From: Norris, Joseph
Sent: Wednesday, January 22, 2003 10:56 AM
To: Mysql_List (E-mail)
Subject: question about update sql
Hello,
I have the following in my SQL:
update call_center set call_center.who_for_id = activeemployees.hr_emp_no
where call_center.who_for_id
Hello,
I have been running mysql on windows 2000 for about 8 months. Now I have to
install it on a new win2k box.
I get everything installed and go to get into mysql and I am getting this
error:
ERROR 2003: Can't connect to MySQL server on 'localhost' (10061)
I remember this well but I don't
Group,
Here is the problem.
I have my mysql databases set up on one windoze 2000 box on d drive with the
main folder on C drive using junction
to create a symbolic link ( Unix so much easier! ) so as to make the sys
admin happier.
I have a perl script on another box that accesses this database
Jeff,
Here is a piece of my backup script. Its been modified from Unix world to
windoze world ( because at this point I
am working in that environment - seeking to return to Unix if anyone has a
gig )
=pod
=head1 Script: mysql_backup.pl
=head2
=over 4
=item 1
This script builds a db dump
I had a problem that required a proper sort of the following:
IT66
ITD38
IT68
ITD39
ITD40
IT69
ITD55
ITD56
IT72
ITD57
ITD58
ITD59
ITD60
IT73
ITD73
ITD67
IT74
ITD69
ITD70
IT78
IT79
IT83
ITD71
IT81
ITD75
ITD76
IT84
ITD96
ITD97
ITD98
ITD99
ITD100
ITD101
ITD102
Thanks - this is even better - I will give it a try.
-Original Message-
From: Cal Evans [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 05, 2002 6:19 AM
To: Norris, Joseph; Mysql_List (E-mail)
Subject: RE: WoW SQL is something!
select req_number,
right(concat('00',trim
Colin,
According to the docs this function wants a string and when I use the field
name it says unknown column.
Thanks anyway.
-Original Message-
From: Colin Kettenacker [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 04, 2002 5:32 PM
To: Mysql_List (E-mail)
Subject: Re: WoW SQL
Hello to all
I have the following sql:
select phones.*, ops.plid, ops.box, ops.mac,
concat(phones.prefix1,phones.suffix1) as complete_phone
from phones inner join ops
on phones.suffix1 = ops.phone
I do
QD answer in PERL!
my ($file);
$file = 'database_names';
$cmd = qq!show databases;!;
open O, cmd or die could open cmd - $!;
print O $cmd\n;
close O;
system (mysql -uusername -ppassword cmd $file)
== 0 or die could not do system - $!;
open I, $file or die could not open
I had a problem that required a proper sort of the following:
IT66
ITD38
IT68
ITD39
ITD40
IT69
ITD55
ITD56
IT72
ITD57
ITD58
ITD59
ITD60
IT73
ITD73
ITD67
IT74
ITD69
ITD70
IT78
IT79
IT83
ITD71
IT81
ITD75
ITD76
IT84
ITD96
ITD97
ITD98
ITD99
ITD100
ITD101
ITD102
Group,
We have been running along with little or no problems with mysql installed
on windows 2000. Just recently I have been noticing a creation - great qty
of creation of temp files in my script directories.
I have all of my scripts on C drive with mysql on my D drive using junction
to make a
Sorry if this not on the exact mysql subject. I have an upcoming project
that requires use of a SQL database system. I wanted to use mysql but mysql
is not available for OpenVMS (thread issue as I understand it). Does anyone
know of something out there that would be on the same order as mysql for
Why do you use the single quotes around your field names. I have never used
them when I build my schemas. That way you don't have to worry about
spaces.
HTH
-Original Message-
From: Insanely Great [mailto:insanely420;PunkAss.com]
Sent: Thursday, October 24, 2002 8:59 AM
To: MySQL List
Group,
Here is my query:
explain select phones.*, ops.plid, ops.box, ops.mac from phones, ops where
(ops.box = 'Mcds') or (ops.box = 'Mn3300') and (phones.suffix1 = ops.phone)
order by
ops.mac
My describe of the phones table and the ops table:
Phones:
Group,
I have the following query:
select phones.*, ops.plid, ops.box, ops.mac
from phones, ops where
(ops.box = 'Mcds') or (ops.box = 'Mn3300') and
(phones.suffix1 = ops.phone) order by ops.mac
When I change the order by to a field in the phones table - sorts just fine
and produces
Group,
I have the following query:
select phones.*, ops.plid, ops.box, ops.mac
from phones, ops where
(ops.box = 'Mcds') or (ops.box = 'Mn3300') and
(phones.suffix1 = ops.phone) order by ops.mac
When I change the order by to a field in the phones table - sorts just fine
and produces
Group,
I have the following query:
select phones.*, ops.plid, ops.box, ops.mac
from phones, ops where
(ops.box = 'Mcds') or (ops.box = 'Mn3300') and
(phones.suffix1 = ops.phone) order by ops.mac
When I change the order by to a field in the phones table - sorts just fine
and produces
In which tables of the three that you mention are the fields:
part number, part description, location, part cost, sell
price and on hand quantity
What is the structure of each or the tables.
-Original Message-
From: William Martell [mailto:[EMAIL PROTECTED]]
Sent: Friday, October
This email leads to a question I have about SQL. I have been accustomed to
Mysql with all of its nifty little extensions - like describe. Now I have a
project with MSSQL (not because I wanted it - politics). Does any one now
how to describe a table structure with standard SQL. Even more
: Wednesday, September 25, 2002 8:50 AM
To: 'Norris, Joseph'; 'Peter van der Goes'; 'Thomas R Wyant_III';
[EMAIL PROTECTED]; 'Mysql_List (E-mail)'
Subject: RE: Win32::ODBC Question (Oracle)
Hi,
Use the following:
SELECT * FROM sysobjects WHERE type='U'
This will show you all of the user tables
Figured it out. just use the use name_of_db and you can switch to another
DB.
thanks.
-Original Message-
From: Norris, Joseph
Sent: Wednesday, September 25, 2002 9:02 AM
To: 'Ian Robertson'; Norris, Joseph; 'Peter van der Goes'; 'Thomas R
Wyant_III'; [EMAIL PROTECTED]; 'Mysql_List
(E
-Original Message-
From: Norris, Joseph
Sent: Thursday, September 12, 2002 12:39 PM
To: Mysql_List (E-mail)
Subject: questions about IF(expr1,expr2,expr3)
Hello,
Can any one give me some examples of how they have used this function in a
practical way? I would like to get a better
I would write this in this way:
select * from table where (field = x and ($field = y or field = z))
or (field = x and (field = a or field = b or field = c));
assuming that you want a record with x in field having either
y or z in field or a or b o c in field
HATH
-Original Message-
(filter bypass words - Mysql, sql, query)
Group,
I have just got into a situation in which I need to explore replication and
I know nothing about it. Can any one direct me to specific documentation on
this and maybe a simple tutorial for the greener of us?
Thanks.
Groups,
I have this snippet of code:
$dbh = DBI-connect( dbi:ODBC:${db_name}, $user, $pass)
or DoError(Unable to connect: $DBI::errstr);
#$dbh-debug(2);
$fsql = qq!select empl_no_a, user_ln, user_fn, user_mi, aka,
longname_a, longname_b, longname_c, useaka from activeempsinfo!;
Agreed except in this case what I have to read is a FoxPro database -
(yuck!)
-Original Message-
From: Gerald Clark [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 21, 2002 11:28 AM
To: Norris, Joseph
Cc: Mysql_List (E-mail); Perl Database (E-mail); Perl Web (E-mail); Perl
Win32 Users
Group,
I have to move my work from Mysql to Postgres ( political decision ) - Need
any and all recommendations for books on advanced SQL. Mysql is a holds a
lot less to the standard than
postgres - or so it seems and I need to look more at standard SQL for some
of the things that
I am doing.
]]
Sent: Wednesday, August 14, 2002 9:14 AM
To: Norris, Joseph
Cc: Mysql_List (E-mail)
Subject: Re: Need recommendations Advanced SQL book
Let us know how your support issues are addressed when you have your
first problem.
Mine were never even acknowledged on the postgresql group
Hello,
What you say below is of great interest to me. Currently I have been
writing front end code to handle the size
issue but I would like to be open to other possibilities. So my question
about your answer below is:
Just how does the developer obtain the error condition from Mysql when an
Hello!
two ways:
Fun way: Get Perl and write some cgi using html/javascript front end
Another way (maybe not as fun - but gets the job done):
Enter data in Excel spreadsheet and export to comma delimited file. Then go
and read the docs on mysqlimport command.
Cheers!
-Original
Group,
Given the following code:
$sql = qq! select * from table where suffix1 ''!;
$db_action = $DB-prepare($sql);
$db_action-execute or die could not do $sql - $DBI::errstr;
$rows = $db_action-rows;
$rec = $db_action-fetchall_arrayref;
Group,
I have a system running on windoze 2000 with apache and perl that was
running just great until I mades some
changes to the sql and a join of two tables. Now I get a bunch of disk
activity and my pages take forever to load
I shut down the browser and still the activity - memory usage goes
: Tuesday, June 18, 2002 11:26 AM
To: Norris, Joseph
Cc: Mysql_List (E-mail)
Subject: Re: HELP!!! major situation with mysql on windows 2000
Hi.
On Tue 2002-06-18 at 10:28:41 -0700, [EMAIL PROTECTED] wrote:
Group,
I have a system running on windoze 2000 with apache and perl that was
running just
Justin,
delete from table_name where field = 'search criteria';
example:
delete from properties where some_field_in_properties = 'search criteria'
-Original Message-
From: justin cunningham [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 13, 2002 12:46 PM
To: 'mysql'
Subject:
Group,
On my unix box when I use mysql I can spawn vi and edit the sql statement or
save it out for reuse.
This feature does not appear to be present on the windows version - or did I
miss something?
Thanks.
-
Before posting,
group,
Here is the situation. I have to connect to Mysql running on another
windows 2000 box. I have never done this before. Do I set this up in the
tables as another
host and use the -h parm in command shell and the host parm in my perl
scripts? or is there another way to do it?
Any help
I am running mysql and apache on windows 2000. Everything is running
smoothly and then all of the sudden my perl scripts that have been running
just find are loading
very very slowly. I am not sure if it is mysql, perl, apache or what. These
are the same scripts that have been running just fine
Group,
I have been using (very happily) mysql on unix boxes. I am in a new job and
there is not a unix box in sight!!! ouch!
This is a windows 2000 shop. Here is the situation and I am looking for any
and all suggestions:
1) I have mysql, apache, perl, etc running on my own box and I
40 matches
Mail list logo