Well the @INC is the enviroment array of perl
so the perl script you're running needs DBI.pm perl module that
appears not to be instaled on your box you can find more info about
on http://dbi.perl.org/index.html and you can get it on
http://search.cpan.org/author/TIMB/DBI-1.30/
-jose
I've
Hi!
I have a html-php form which connects to a my-sql DB
and retrieves and displays the name and image(Stored
in Blob) I'm using Header(Content-type: image/gif)
to display the mesage queried from my sql. This
displays the image, but I want it displayed in a img
tag along with other text and not
I'm running mysql-3.23.49 on a redhat machine, mysql has stopped responding
to remote connections ever since i rebooted it today.
/var/log/mysqld.log says
Number of processes running now: 1
mysqld process hanging, pid 3062 - killed
021015 20:37:05 mysqld restarted
/usr/libexec/mysqld: ready for
Hi guys,
I was wondering if anyone knew of a paramter that can be put on the end of a
select statement when querying a table which only pulled out one unique
record based on a field.
I.e
If i had a drink database and in it were 10 cokes 10 fantas 10 pepsi's what
select statement would i need to
I'm running mysql-3.23.49 on a redhat machine, mysql has stopped responding
to remote connections ever since i rebooted it today.
/var/log/mysqld.log says
Number of processes running now: 1
mysqld process hanging, pid 3062 - killed
021015 20:37:05 mysqld restarted
/usr/libexec/mysqld:
Description:
MySQL server crashes when a remote client connects.
A local client connecting thru unix socket file does not have the problem.
How-To-Repeat:
Connect via a remote host.
Fix:
No solution yet.
Submitter-Id: submitter ID
Originator:Aldrian Gintingsuka
Organization:
MySQL
Hello jantos,
Tuesday, October 15, 2002, 2:03:50 PM, you wrote:
jamdd when I'm connecting to mysql-server via tcp/ip then the mysql-server
jamdd cuts the connection and it restarts the mysql-server.
jamdd when I don't make connections from other hosts than it's running
Hello Graham,
Tuesday, October 15, 2002, 12:03:34 PM, you wrote:
1. replace Red Hat's rpms with MySQL binary release, download it from
http://www.mysql.com/
2. run myisamchk on all files.
3. run MySQL and enjoy the reliability since then :-)
GM Why do Linux distributions ship broken MySQL
Hello Mike,
Monday, October 14, 2002, 6:48:36 PM, you wrote:
MZ Recently our DB, which is running MySQL 3.23.52, started experiencing
MZ intermittant load spikes, of the magnitude of 200+ load averages.
Normally,
MZ our high spike is about 0.90 load. When this starts happening, we
notice a
MZ
Michael,
Thank you for your alert.
In the same way that you did not ask the original question, I did not write
the part attributed to 'me'!
There is no such address [EMAIL PROTECTED]
The only address in this sub-domain subscribed to [EMAIL PROTECTED] is
[EMAIL PROTECTED]
I have reduced myself to
Description:
Seems everytime I do a queary on the mysql server it just crashes out and
restarts
displays this /usr/local/mysql/bin/safe_mysqld: line 273: 3078 Segmentation
fault
and also the below in the log file
[root@dev mysql-test]# ./mysql-test-run
Installing Test
Balazs,
Wednesday, October 16, 2002, 8:27:56 AM, you wrote:
BL I installed the full version of Mandrake 8.2.
BL The problem is that i can't setup the mysql server.
BL When i tried: mysql -u root mysql; the server
BL responded: acces denied for root@localhost !!
Have you installed MySQL
Lothar Jenisch wrote:
Hello,
I have a problem with replication and LOAD DATA INFILE.
I use version 3.23.37 on Liunx distribution.
1. I check the replication with a manual i.e. insert and
delete of one record. This works fine without problems.
2. I do a
LOAD DATA INFILE
Thanks very much for all yours replays
The trick to have it build on solaris came on the email
From: Jesse Sheidlower [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Tuesday, October 15, 2002 5:07 PM
Subject: Re: Problems installing on Solaris/Intel
They where dealing with
Andrew,
Wednesday, October 16, 2002, 11:01:05 AM, you wrote:
AW I was wondering if anyone knew of a paramter that can be put on the end of a
AW select statement when querying a table which only pulled out one unique
AW record based on a field.
AW I.e
AW If i had a drink database and in it were
x-gylee+mysql,
Wednesday, October 16, 2002, 11:11:44 AM, you wrote:
Description:
xgmaidc MySQL server crashes when a remote client connects.
xgmaidc A local client connecting thru unix socket file does not have the problem.
How-To-Repeat:
xgmaidc Connect via a remote host.
Fix:
xgmaidc No
Hi everyone,
Basically my problem is that I want to distribute a program that uses
the MySQL C API. The functions mysql_* are available in the dll which
can be packaged along with the programs exe. The database that the
program uses can also be rebuilt using an sql script so it does not need
to
* Andrew Wilson
Hi guys,
I was wondering if anyone knew of a paramter that can be put on
the end of a
select statement when querying a table which only pulled out one unique
record based on a field.
... LIMIT 1
I.e
If i had a drink database and in it were 10 cokes 10 fantas 10
Dear sir,
I have installed mysql-max-3.23.51.tar file on linux machine.
I gave all options which they have given in the INSTALL BINARY file.
such as
shell groupadd mysql
shell useradd -g mysql mysql
shell cd /usr/local
shell gunzip /path/to/mysql-VERSION-OS.tar.gz |
ESCAPE
Mite help...?
Simon
MySQL
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To
perumal,
Wednesday, October 16, 2002, 1:07:14 PM, you wrote:
pI have installed mysql-max-3.23.51.tar file on linux machine.
p I gave all options which they have given in the INSTALL BINARY file.
p such as
p shell groupadd mysql
p shell useradd -g mysql mysql
p shell
Karl,
Wednesday, October 16, 2002, 1:41:24 AM, you wrote:
KS Any help downgrading my MySQL Server from 4.0.0.0ALPHA to 3.23 would be a
KS huge help. I'm not sure where to start. Do I need to save records to a
KS flat file and then reimport them?
Just uninstall 4.0.0 and then install 3.23. But
Jon,
Wednesday, October 16, 2002, 8:04:12 AM, you wrote:
JK I'm running mysql-3.23.49 on a redhat machine, mysql has stopped responding
JK to remote connections ever since i rebooted it today.
JK /var/log/mysqld.log says
JK Number of processes running now: 1
JK mysqld process hanging, pid 3062
clint,
Wednesday, October 16, 2002, 1:14:08 AM, you wrote:
caddn Recently the server had to be hard-booted... a safe shutdown was not
possible. After the server came back up, mysql
caddn has been acting very funny. When the server first boots, mysql wont respond to
anything. I restart
Hi,
I am using MySQL with the mm.mysql-2.0.14 dirver. I got connection with the
databse after that i created an object of statement and after that i got the
object of ResultSet, then i closed the statement and then conection. But
when i use this resultset it works fine. Can anybody tell me how
Hello,
I have a problem with select statetement. I need to query and select
records from multiple tables which have the same column types. I have
done this with left join but my query became so complex. Because i have
written left join between all of my tables and also if i need to query
Hi all,
Can anyone suggest me the highly recomended (non vulnerable)MySQL version.
Thanks
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list
Hello,
You can define a merge table and run your select on it.
Check the manual for details: http://www.mysql.com/doc/en/MERGE.html
Regards
Joseph Bueno
Veysel Harun Sahin wrote:
Hello,
I have a problem with select statetement. I need to query and select
records from multiple tables
Hello,
After upgrading to 4.0.4 from 4.0.2 on three server we have got some
mysterious problems with one of the server.
Several times it appears to be dead. Connecting takes a very long time,
and the CPU load goes throug the roof and beyond.
The two other servers runs without problems. The
Assuming that you're joining data based on colB, you
would use:
select t1.colA,t2.colA,t3.colA
from tblA t1
inner join tblB t2 on t1.colB = t2.colB
inner join tblC t3 on t1.colB = t2.colB
where...
You can alias the table names, but there's really no
way to get around specifying the table
I have a mysql database (version 3.23.47) running on a virtual server.
I have taken the running over from someone else and have been having trouble
with database permissions. To combat this I bypassed passwords by creating a
my.cnf file. I then have deleted all records in the mysql.user table
Ok, I tried to set up MySQL at home (3.23.53), on my windows machine, so I
can test database stuff before I use it on the UNIX server. I installed it,
set it up as services, the service is running, yet I get:
C:\mysql\binmysql.exe
ERROR 2003: Can't connect to MySQL server on 'localhost' (10061)
I'm not sure what the limit is. MySQL limits tend to be dictated by the
OS that is being used. The more columns you have the larger the database
file will be. You should try to avoid having many empty columns in a
database design, even if you are using varchar instead of char. Try to
think
Ok, I tried to set up MySQL at home (3.23.53), on my windows machine, so I
can test database stuff before I use it on the UNIX server. I installed it,
set it up as services, the service is running, yet I get:
C:\mysql\binmysql.exe
ERROR 2003: Can't connect to MySQL server on 'localhost' (10061)
We use Crystal and it is great. It is especially good for the more
complicated reports.
Webmaster MBTRADINGCO [EMAIL PROTECTED] 10/15/02
11:45PM
Hi, does anyone knows if Crystal reports is a good reporter to make
reports out of MySQL, or does anyone knows a good reporter for PHP
MySQL?
My task is to insert a new master record and several detail records within
the one transaction.
There is a foreign key on the detail table set to the unique key (autoinc)
field of the master table.
Inserting a master record, even with a special field value so that it can be
quickly returned
Ok, so I've broken down your problem into small, manageable steps.
First, users are provided with a box to enter a value (e.g. pumpkin) and the 1)ability
to select a ranking for pumpkin, or 2)the ability to select which old value (apefruit)
the new value-pumpkin-belongs above/below (scenarios 1
Hi
insert_id returns the key value. I use php, and the mysql_insert_id is the
last insert_id on that connection, so even if other processes have added new
records in the time the script runs the insert_id is the correct one.
You can then use that as the key in the detail records.
HTH
Peter
Mark,
Wednesday, October 16, 2002, 4:08:03 PM, you wrote:
M Ok, I tried to set up MySQL at home (3.23.53), on my windows machine, so I
M can test database stuff before I use it on the UNIX server. I installed it,
M set it up as services, the service is running, yet I get:
M
* Alan McDonald
My task is to insert a new master record and several detail records within
the one transaction.
There is a foreign key on the detail table set to the unique key (autoinc)
field of the master table.
Inserting a master record, even with a special field value so
that it can
Peter,
Thanks you - I looked up Insert_ID() in the manual...
Page 171-172
If I insert into person but before I insert into short, someone else inserts
into person, surely my inserts into shirt will have their last Insert_ID()?
Do you know if this is true only in the same connection context only?
Sorry your second link makes that claim a little clearer - it's on a
per-connection basis
Alan
-Original Message-
From: Roger Baklund [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, 16 October 2002 23:58
To: [EMAIL PROTECTED]
Cc: Alan McDonald
Subject: Re: Inserting Master and Details
I've compiled and installed this on my Solaris8/Intel box a few times
without a hitch.. I don't recall seeing what version of Solaris you're
running.. ?
I also compiled with just ./configure - I didn't bother with the other
options.. although that might be asking for trouble under certain
Gavin,
Wednesday, October 16, 2002, 3:59:04 PM, you wrote:
GL I have a mysql database (version 3.23.47) running on a virtual server.
GL I have taken the running over from someone else and have been having trouble
GL with database permissions. To combat this I bypassed passwords by creating a
GL
1) What is a syntax example for inserting a NULL into a column?
insert into projects set costing=NULL
2) If a NULL is inserted into a column with a float type, does that NULL
show up as anything else other than NULL? Like my 0.00 for example. Is that
actually mysql's way of showing a NULL for
Re-send. Hopefully someone can help...
-Original Message-
From: Hammons Randy G SSgt 612 ACOMS/SCXX
[mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 15, 2002 9:01 AM
To: Mysql (E-mail)
Subject: data-type help with NULL entries
I have a table named projects. Within that table, one
I followed the directions in the Mysql documentation, but I can't get it
to fire up properly. I dl the binary distribution
mysql-max-3.23.53-pc-linux-gnu-i686.tar.gz
Mysql 3.23.53
Redhat 8.0
When I start it from safe_mysqld I get in the .err log
Fatal error: 'Can't change to run as user
How can I create a autoextend database?
I tried using the following configuration:
inoodb_data_file_path=date_d1:100M:autoextend
But the MySQL don't started.
What's wrong?
-
Before posting, please check:
Alan McDonald wrote:
Do you know if this is true only in the same connection context only? Or
does insert_id() return another connections last insert?
I find it easiest to use MySQL's variables:
INSERT INTO Master ...
SELECT @MasterID:=last_insert_id();
INSERT INTO Detail1 (MasterID, Data)
usha,
Wednesday, October 16, 2002, 7:48:26 PM, you wrote:
u Can anyone suggest me the highly recomended (non vulnerable)MySQL version.
What about stable version?
What OS do you use? 3.23.5X has some loading problems on Linux ..
In Ensita we use v3.23.52 and v4.0.4 on production servers.
Alan,
Wednesday, October 16, 2002, 5:07:05 PM, you wrote:
AM Thanks you - I looked up Insert_ID() in the manual...
AM Page 171-172
AM If I insert into person but before I insert into short, someone else inserts
AM into person, surely my inserts into shirt will have their last Insert_ID()?
I would like to know if this is at all possible using MySQL 4.0.4 in
Windows.
We want to be able to host our web site using either Windows and ASP or
Linux and PHP in our service provider server. All the scripts will be in
their machine away from our network. Then I would like for those
1. inoodb should be innodb.
2. Does the directory named in innodb_data_home_dir exist?
3. Does the file date_d1 already exist?
PB
-
- Original Message -
From: Silmara [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, October 16, 2002 8:08 AM
Subject: Autoextend
How can
sql,query
At 0:07 +1000 10/17/02, Alan McDonald wrote:
Peter,
Thanks you - I looked up Insert_ID() in the manual...
Page 171-172
If I insert into person but before I insert into short, someone else inserts
into person, surely my inserts into shirt will have their last Insert_ID()?
Surely
The section below should be in a loop if you expect it to happen more
than once ...
John Chang wrote:
body
form name=form1 id=form1 method=post action=
?php echo $row_Recordset1['Sdo_ID']; ? ?php echo
$row_Recordset1['V_ID']; ?
?php echo $row_Recordset1['V_image']; ? ?php echo
- Original Message -
From: Egor Egorov [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, October 16, 2002 3:56 PM
Subject: re: mySQL on windows xp
Mark,
Wednesday, October 16, 2002, 4:08:03 PM, you wrote:
M Ok, I tried to set up MySQL at home (3.23.53), on my windows machine,
hi,
Somebody saw comparaisons of productivity for mysql and others RDBMS?
or somebody do comparaisons?
thanks
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
Hi!
Chung == Chung Ha-nyung [EMAIL PROTECTED] writes:
Chung Dear,
Chung I installed MySQL 4.0.4 from source tarball and I found that
Chung safe_mysqld is
Chung mentioned here and there in the manual but I can't where it,
Chung safe_mysqld, is
Chung located. All that I found with `find .
At 12:08 -0300 10/16/02, Silmara wrote:
How can I create a autoextend database?
I tried using the following configuration:
inoodb_data_file_path=date_d1:100M:autoextend
I assume you mean innodb_... and not innnodb_... ?
But the MySQL don't started.
What's wrong?
What does the error log
I have solved my problem with MySQL and MySQLdb. The problem was:
I have installed mysql-3.23.52 as part of the Gentoo Linux
distribution. I am accessing MySQL via mysql-python AKA MySQLdb
which calls the MySQL C API. During testing I start MySQL using
safe_mysqld and shutdown
I'm managing two database servers, one 3.23.52 and one 3.23.52-Max
(using innodb tables on that one).
They are both running along fine until they suddently start to
accumulate a lot of treads (a lot ~= 200-300), the state of these
threads is mostly closing and opening tables. This drives up the
Silmara,
Wednesday, October 16, 2002, 6:08:18 PM, you wrote:
S I tried using the following configuration:
S inoodb_data_file_path=date_d1:100M:autoextend
^
innodb_data_file_path
S But the MySQL don't started.
S What's wrong?
What error did you get? Check error logs.
--
For
Hammons,
Wednesday, October 16, 2002, 4:57:10 PM, you wrote:
HRGS6AS I have a table named projects. Within that table, one specific column is
HRGS6AS called costing and is of the following schema (projects float(8,2)). Nothing
HRGS6AS fancy. The interface that updates information to this table
Zack,
Wednesday, October 16, 2002, 5:56:11 PM, you wrote:
ZWK I followed the directions in the Mysql documentation, but I can't get it
ZWK to fire up properly. I dl the binary distribution
ZWK mysql-max-3.23.53-pc-linux-gnu-i686.tar.gz
ZWK Mysql 3.23.53
ZWK Redhat 8.0
ZWK When I start it
I'm using mysql Ver 11.16 Distrib 3.23.49, for slackware-linux-gnu (i386).
Everything was just fine for months, but yeasterday I started to use one of
the tables by connecting to it with MS Access 2000. The table has ~10
records. And the strange thing: it was working for few hours
Xavier LENOIR wrote:
I use queries like this :
SELECT count(*) FROM MyTable WHERE (MATCH(Title) AGAINST('a word'));
SELECT * FROM MyTable WHERE (MATCH(Title) AGAINST('a word')) LIMIT 10;
Have you tried building a seperate table of titles for the sake of
having a smaller table to scan
John Chang wrote:
Studios (StudioName, StudioID)
Genres (GenreName, GenreID)
Titles (VideoTitle, Details, StudioID, GenreID, BitRateID, TitleID)
Actors (F_Name, L_Name, ActorID)
Stars (TitleID, ActorID)
TitleGenres (TitleID, GenreID)
So, if I just use theses tables I will be OK if the
Insanely Great wrote:
Is it necessary that you usee STL. Other wise MySQL C API are much more
easy to maintain and program. Even SQLyog which I am a beta tester is
written using MySQL C API and its very fast.
But it would be so nice to write:
MySQLConn DB = new MySQLConn ('host', 'port');
- Original Message -
From: Paul DuBois [EMAIL PROTECTED]
To: Silmara [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Wednesday, October 16, 2002 12:16 PM
Subject: Re: Autoextend
At 12:08 -0300 10/16/02, Silmara wrote:
How can I create a autoextend database?
I tried using the following
- Original Message -
From: Peter Brawley [EMAIL PROTECTED]
To: Silmara [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Wednesday, October 16, 2002 12:18 PM
Subject: Re: Autoextend
1. inoodb should be innodb.
Ok. I typed wrong in the e-mail.
2. Does the directory named in
At 13:33 -0300 10/16/02, Silmara wrote:
- Original Message -
From: Paul DuBois [EMAIL PROTECTED]
To: Silmara [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Wednesday, October 16, 2002 12:16 PM
Subject: Re: Autoextend
At 12:08 -0300 10/16/02, Silmara wrote:
How can I create a autoextend
This problems are making me a bit tired, forgot to give you information
about the systems.
MySQL-3.23.52
dual pentium 700, 800MB ram
RedHat 6.1
Kernel 2.2.19-6.2.1smp
glibc-2.1.3-27
MySQL-3.23.52-Max
dual pentium 1.4Ghz, 2 GB ram
Redhat 7.3
Kernel 2.4.18-10smp
glibc-2.2.5-40
regards
/Lars
On
Russ Cindy Stanger wrote:
When I try to add a string to the end of an enum list I get the following
error message:
You have an error in your SQL syntax near '\','Historical
It looks like you've accidentally added a slash to quote a quote ...
check your code.
However, I'd highly suggest
On Wed, Oct 16, 2002 at 10:15:43AM -0400, Ben Goodwin wrote:
I've compiled and installed this on my Solaris8/Intel box a few times
without a hitch.. I don't recall seeing what version of Solaris you're
running.. ?
I'm running Solaris 8 with gcc 2.95.2.
I also compiled with just ./configure
This problem is due to the glibc used by mysql AB for building binary ...
Have a look to mysql 3.23.53 change log :
We've hopefully fixed the problem with spurious load spikes on Linux
systems when accessing the Database via TCP/IP. This was caused by
the
static glibc files we used to
hi,
i'd like to know if there is a way to tell the mysqld to remove a thread
that has hang, without human intervention.
Let say an update query is fired to the engine, and the client just freezes
and we have to reboot the machine manually: how can i make sure that mysqld
will remove that
Mysql was installed from binary, and this is redhat 7.3 running kernel
2.4.18-3
At 02:16 PM 10/16/2002 +0300, you wrote:
Jon,
Wednesday, October 16, 2002, 8:04:12 AM, you wrote:
JK I'm running mysql-3.23.49 on a redhat machine, mysql has stopped
responding
JK to remote connections ever
Jan Steinman wrote:
I believe the Pick operating system from the 70's had a database filesystem, for
example. It was popular among business types. As I recall, it also had a BASIC
command interpreter as its primary way of interacting with the system.
FWIW, we use Pick database systems quite a
Moving from glibc 2.2.5-40 to glibc 2.2.5-39 has solved the problem i was
having with remote connections,
Thanks to everyone who helped.
-Jon Keller
At 06:18 AM 10/16/2002 -0500, you wrote:
I started to receive this error as well after upgrading the glibc update
just released from Red
sql, query
But it would be so nice to write:
MySQLConn DB = new MySQLConn ('host', 'port');
DB.Login('user', 'pass');
MySQLTransaction X = new MySQLQuery(DB);
// STL-derived slist:
MySQLResults Results = X.Query(...);
// STL map:
map Row;
while (Results.NextRow(Row)) {
cout ID:
I had the same problem with 4.0.4, I downgraded to 3.23.52 because I
thought it was something with the unstable version. Is 4.0.4 also built
against the same static glibc?
regards
/Lars
This problem is due to the glibc used by mysql AB for building binary ...
Have a look to mysql 3.23.53
Hi,
I'd like to know if there is something similar to Oracle's Wrapper
in MYSQL.
Thanks in advance.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
Previously I had been a NuSphere subscriber for MySQL (and PHP and Apache). As you
probably know, NuSphere no longer produces or supports the MySQL product. How do I
migrate out of the NuSphere?
I currently have:
RH Linux 7.2 (kernel 2.4.9-34)
MySQL 3.23.44-100.nusphere
Location:
Greetings,
I need to be able to insert many rows into a table at once. Only one
field, an incremental serial number will change for each row. Is there
a way to do that in a single query? I need to be able to specify the
start and end points (i.e. start at 59 and end at 605000) Or do I
have
hello..
i have a winxp and linux 7.2 on the same machine. I
have mysql on the linux server and MyCC in the win
partition.
i connect to the linux MySQL using the vmware lopback
adapter. everything is working fine.
now when i issue a backup table syntax. it is giving
syntax. Is back table only
From: Andrew Kuebler [EMAIL PROTECTED]
2) Is it just as fast with Mysql to access 10 fields in a table with 10
columns as it would be to access those same 10 fields among let's say 90
other fields in a 100 column table?
Are you certain that performance should be your primary concern here?
I
Greetings all,
I have a users table in the DB.
I am importing allot of existing data from various places into this users
table.
There is a strong likelihood of the same user getting entered twice.
Though each record will have a separate and unique ID, I want to be able to
query the table and
Hi from Dresden, Germany!
I have a littlebig problem:
I want to UPDATE table1.fields with data from table2.fields WHERE the id (in this
case a product number) is the same in both tables.
OK, I did this:
UPDATE table1 SET table1.field1 = table2.field1, table1.field2 = table2.field2,...
WHERE
Inandjo
Try setting the variable connection_timeout to 300 seconds.
That way, the mysqld will close the connection automatically.
Set the variable in file my.cnf.
David
-Original Message-
From: Inandjo Taurel [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 16, 2002 9:54 AM
I installed MySQL-max-3.23.52-win in the Win98 with the following
configuration
#This File was made using the WinMySQLAdmin 1.4 Tool
#16/10/2002 14:37:55
#Uncomment or Add only the keys that you know how works.
#Read the MySQL Manual for instructions
[WinMySQLadmin]
Dobrý den,
quarta-feira, 16 de outubro de 2002, 17:33:00, napsal jste:
S I installed MySQL-max-3.23.52-win in the Win98 with the following
S configuration
S #This File was made using the WinMySQLAdmin 1.4 Tool
S #16/10/2002 14:37:55
S #Uncomment or Add only the keys that you know how works.
S
Fibilt
try:
SELECT id, concat(lname, fname) as name, count(*) as cnt
FROM table1
GROUP BY name
HAVING cnt 1;
This is close anyhow.
David
-Original Message-
From: Phillip S. Baker [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 16, 2002 1:17 PM
To: [EMAIL
I've tested this on a table of mine with different names, so it should work when you
tweak your columns/table. The having clause is a seldom taught, but highly useful
clause.
select count(1), first_name, last_name
from myuserstable
group by first_name, last_name
having count(1) 1;
You
I am trying to use mysql.
I use the line
mysql -u username -p
and then enter the correct password
The error message I get is error 1045 access denied for user:
username@localhost (Using password: YES)
I know that I am using the correct username and password, because an
application using jdbc
Florian Litot wrote:
hi,
Somebody saw comparaisons of productivity for mysql and others RDBMS?
or somebody do comparaisons?
thanks
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
You need an InnerJoin to perform the operation similar to:
UPDATE table1 SET table1.field1 = table2.field1, table1.field2 =
table2.field2,...
INNER JOIN Table1 ON Table2.ID = Table1.ID
Bruce Lewis
- Original Message -
From: STIBS [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent:
When I try that modified for my tables that fit this hypothetical, I get:
CREATE TABLE `sales_table` (
`item_s` varchar(100) default '',
`price_s` varchar(100) default ''
) TYPE=MyISAM
CREATE TABLE `lookup_table` (
`item_l` varchar(100) default '',
`price_l` varchar(100) default ''
)
Apache document root works fine, and php3 is fine also. I uncommented the
lines in /etc/apache/httpd.conf
LoadModule php3_module /usr/lib/apache/1.3/libphp3.so
AddType application/x-httpd-php3 .php3
AddType application/x-httpd-php3-source .phps
I added a webpage to document root, with the
Ooops! You just threw a new wrench into the works! A video may have
multiple titles. In this case you must distinguish the original from its
presumably foreign-translations (or whatever). In other words, you might
store the master as La Cage aux Folles and the English subtitled version
as
You need to include the field names along with the table name.
UPDATE table1 INNER JOIN Table1 ON Table2.FieldID = Table1.FieldID
Set Table1.Field1=Table2.Field1, Table1.Field2=Table2.Field2, ...
Bruce Lewis
- Original Message -
From: Greg Knaddison [EMAIL PROTECTED]
To: [EMAIL
1 - 100 of 116 matches
Mail list logo
