Hello Mr.Venu,
yes, of course, I took a look at it and I checked this out. It was quite
useable for mass-mailings, but not for single letters.
e.g. My database contains a lot of adresses. I created a dialogbox, where I
enter a name and now the corresponding adress will be looked up in th DB.
now
Tuesday, January 29, 2002, 1:57:21 AM, David Piasecki wrote:
I have a server here that is troubling me -
I have a database server that is lagging no matter what I do. When I
start the server, I can watch CPU usage slowly creep up to 99% and it
never drops. The queries that are hitting the
Check out this program. Just wish there was an OS X version :-(
http://www.datanamic.com/dezign/index.html
-- greg willits
-- [EMAIL PROTECTED]
From: Steven Wren [EMAIL PROTECTED]
Date: Tue, 29 Jan 2002 16:22:12 +1000 (EST)
To: Paul DuBois [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re:
Hi,
It is said that if the connection is lost then there will be an entry of
the .err file.
But nothing of that sort is happening here.
Connection is not lost, and replication is also not taking place.
Can any one help to get the solution.
On Tue, 29 Jan 2002, Jai Kumar Shinde wrote:
Hi,
On Sun, 27 Jan 2002, Michael Widenius wrote:
One way to do this is to do as follows:
SELECT something FROM sometable WHERE somevar=somevalue ORDER BY
RAND() LIMIT 10
OK. I still think that my extended LIMIT syntax would be a good idea,
because ORDER BY RAND() does not seem to be very fast.
Hi,
I have an Sun Ultra 2 with 500Megs of swap and I constantly get the
following swap space messages when I try to install mysql-3.23.39.
-
Note: The following compile may take a long time.
If it fails, re-run
On 28 Jan, Paul DuBois wrote:
On 28 Jan John A. Murdie wrote:
I decided that it was probably simpler just to build from source - I'm
on a Solaris 2.8 system - and so it proved to be. I was careful to use
the recommended configure options.
I found that I had to build in the installation directory
Eric,
Monday, January 28, 2002, 2:30:47 PM, you wrote:
ETK Eric here from South Africa.
ETK I'm fairly new at using mysql and need to access images via a php website.
ETK What is the best way to store images or reference to images like jpg and
ETK gifs in a mysql db? Also what would the sql
Hello,
I'm developing an application with MySQL using the C API. I would like
to implement a mechanism to prepare some queries in advance and just
bind the parameters before execution. I have found in the documentation
a way to do that using the DBI Interface but not for C API. Is it
possible to
I'm developing in asp and connect to databases using something like this:
(using ODBC)
set db = Create.ServerObject(ADODB.Connection)
db.open databaseName;
This works fine and I can get and insert data with no trouble. However,
when I do:
db.close
set db=nothing
Nothing happens. The
thanks for your quick reply !!
that's fine !! I have done the max.RPM installation part.
but what is fix up the startup scripts so that
binary will be the one started.
When I am trying show variables like have_%;
+---+---+
| Variable_name | Value |
+---+---+
|
xgao,
Tuesday, January 29, 2002, 3:45:30 AM, you wrote:
x Hi all
x I try to connect mysql on turbolinux with my windows mysql client but the
x client tells me my host is not allowed to connect the mysql server.
Please refer the following link:
http://www.mysql.com/doc/C/o/Connecting.html
Cindy,
Tuesday, January 29, 2002, 1:28:59 AM, you wrote:
CY Hello,
CY Can anyone tell me how to load data into non-empty tables? Can you
CY give me an example?
CY Any help appreciates!
Look in the manual about LOAD DATA at: http://www.mysql.com/doc/L/O/LOAD_DATA.html
--
For technical
Stephane,
Monday, January 28, 2002, 1:29:40 PM, you wrote:
SP I've installed mysql 3.23.47 (Binaries) on a Linux RedHat 7.0 box.
SP Everything seems to be OK (the server runs) but I cannot connect to it using
SP mysql client:
SP When I enter mysql -u etc...
SP I've got a bash: mysql: command
Samy,
Monday, January 28, 2002, 8:09:37 PM, you wrote:
SE Hope some of you could help me here.
SE I have done
SE ./configure --prefix=/ussr/loca/mysql
SE --localstatedir=/usr/loca/mysql/data
SE --withunix-socket-path=/tmp/mysql.sock
SE make
SE make
Ed,
Monday, January 28, 2002, 11:26:44 PM, you wrote:
EC Hi! I'm having a problem with mysql hanging. I'm running mysql-3.23.36 on
EC a Linux 2.2.17 kernel. It ran just fine last week, but when we rebooted the
EC box, mysql will start, but connections to the database just hang.
EC mysqldmin,
Matthew,
Tuesday, January 29, 2002, 6:37:32 AM, you wrote:
MW You can only do this while compiling it from source.
MW Matthew Walker
MW Ecommerce Project Manager
MW Mountain Top Herbs
MW -Original Message-
MW From: Chetan Lavti [mailto:[EMAIL PROTECTED]]
MW Sent: Monday, January 28,
Frank,
Tuesday, January 29, 2002, 12:33:03 PM, you wrote:
FRSE I have an Sun Ultra 2 with 500Megs of swap and I constantly get the
FRSE following swap space messages when I try to install mysql-3.23.39.
[]
FRSE --
Chetan,
Tuesday, January 29, 2002, 7:02:18 AM, you wrote:
CL thanks for reply,
CL but I have installed MySQL on Linux using the RPM files and while using
CL RPM files should I have to give the option while installing? As while
CL using the RPM files there is no compilation.
CL It is no where
Torkil,
Monday, January 28, 2002, 5:47:48 PM, you wrote:
TJ A friend of mine is having a problem with the 3 norwegian characters æ Æ, ø
TJ Ø and å Å. (html: æ ø and å)
TJ When a string is inserted with either of these characters, and later
TJ selected and returned, they do not appear as they
Joachim,
Monday, January 28, 2002, 2:15:51 PM, you wrote:
JH I have installed MySQL Version 3.23.47 on Suse Linux 7.2 (Kernel 2.4.4)
JH After the installation of mysql I run the mysql_install_db script
JH I could change the passwords for root so I reset the GRANT table using
JH
Jessica,
Monday, January 28, 2002, 3:13:11 PM, you wrote:
JR Can anyone help me -
JR I am trying to extract data on the availability of a holiday villa using the
JR statement
JR 'SELECT PossDate from JuneDates where not exists(SELECT PossDate FROM
JR Reservation WHERE PossDate Between ArrDate
could you be subscribed under two (or more) email addresses?
Peter
-Original Message-
From: Yuxia Li [mailto:[EMAIL PROTECTED]]
Sent: 29 January 2002 06:15
To: [EMAIL PROTECTED]
Subject: Re: Trouble in unsubscribing
Hi:
Does anyone know how to unsubcrib from sql
SE ./configure --prefix=/ussr/loca/mysql
Typo I used /usr/local/mysql
To make a long stroty short , I downloaded the source
rpm and started over , now I have the mysql.sock file.
Looks like the download was currupt. I nned to use the
sourcee as I am
Hi there,
I wish to setup replication between a pair of mysql servers. However
since my slave only has an ADSL connection to the master I want to
compress the data between them. A small wrapper around zlib does this for
me. My slave mysql must therefore connect to a port on the local machine
Tried that , but I used the source to compile , and
put it into /usr/local/mysql
So every thing is diffrent. Haveing relied on YaST I
do not know how to do it manualy , where and what
files to edit. I came from the windows world an jumpt
on to linux back during suse 5.1 days. Tells you how
good
Hi all,
there must be some kinds of technical difficulties as I'm also not
able to unsubscribe at the moment.
At 14:28 29.01.02 +, you wrote:
could you be subscribed under two (or more) email addresses?
Peter
-Original Message-
From: Yuxia Li [mailto:[EMAIL PROTECTED]]
Sent:
Hi!
Ulf == Ulf Harnhammar [EMAIL PROTECTED] writes:
Ulf On Sun, 27 Jan 2002, Michael Widenius wrote:
One way to do this is to do as follows:
SELECT something FROM sometable WHERE somevar=somevalue ORDER BY
RAND() LIMIT 10
Ulf OK. I still think that my extended LIMIT syntax would be a good
David,
Monday, January 28, 2002, 10:43:38 PM, you wrote:
DS REALFROM: David Shields [EMAIL PROTECTED]
DS HOUR: 2002012901
DS You wrote:
DS What about mysqldump? See http://www.mysql.com/doc/m/y/mysqldump.html
DS for more info about mysqldump.
DS well, no, not really :
DS site1 - has apache
Chetan,
Tuesday, January 29, 2002, 4:06:30 PM, you wrote:
CL thanks for your quick reply !!
CL that's fine !! I have done the max.RPM installation part.
CL but what is fix up the startup scripts so that
CL binary will be the one started.
CL When I am trying show variables like have_%;
CL
I am a new user to MySQL. The server is running, but I keep getting the
following error:
Host 'www.usapa.army.mil' is not allowed to connect to this MySQL
server.
When I enter the mysqladmin version command, I get the following:
mysqladmin Ver 8.23 Distrib 3.23.47, for
Description:
slaves does not honore the mysqlimport --lines-terminated-by='\n\n' switch
How-To-Repeat:
i've set up two machines as master - slave. i start out with a running
replication in a sane state.
now i do on the master:
mysql -e '
drop table TOR5;
Hi Egor,
the ./configure --with-low-memory works but I don't understand why the
same version of mysql compiles successfully on smaller system with less
swap ?
There surely can't be a requirement for 500 Megs swap for an ultra 2
and 1.5 Gigs for a starfire ?
thanks,
-- frank
Egor Egorov
At 16:25 +0100 1/29/02, Lutz, Helmuth wrote:
Paul,
thanks for answering. Because of my job I have to succeed this
correspondence from within another location and machine.
Could you please give some more explaination to a bloody guy to Unix and
the terminal like me:
1)
Kill the server (kill
I compiled mysql 3.23.47 from source and still can't shutdown the daemon
with a mysql.server stop or a simple kill command. Only way to stop it is
with a kill -9. I previously installed the precompiled binary and had the
same problem. I guess this isn't fully fixed with the .45 version as was
I used to use some php scripts that allowed me to work on my database. I'm
trying to find them again... anyone know what they might have been called
or where to find them?
-Ed
-
Before posting, please check:
Hi all,
I can't find a description of the algorithm used in the mySQL PASSWROD
function. I understand it's a hashing algorithm of some kind, but I
don't know which algorithm (and I suspect it's *not* MD5.)
Can anyone tell me what algorithm PASSWORD uses? The reason I ask is
that we're trying
Hello,
I have two servers under a mutual master-slave relationship. I need to
ignore certain databases when replicating. I tried to use
replicate-ignore-db but according to the MySQL manual this won't work for
cross database updates. The manual suggests using
replicate-wild-ignore-table instead.
Hi,
The most widely used tool to reach MySQL over PHP is phpMyAdmin. You can
obtain it from http://www.phpwizard.net/projects/phpMyAdmin/
- Original Message -
From: Ed Lazor [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, January 29, 2002 5:53 PM
Subject: mysql web-based admin
Hi,
On Tuesday 29 January 2002 16:53, Ed Lazor wrote:
I used to use some php scripts that allowed me to work on my database. I'm
trying to find them again... anyone know what they might have been called
or where to find them?
-Ed
Maybe it's phpMyAdmin...
http://phpmyadmin.sf.net/
Regards,
admin,
Tuesday, January 29, 2002, 4:38:56 PM, you wrote:
bashmysqladmin -u root ?
Find your answers at:
http://www.mysql.com/doc/D/e/Default_privileges.html
and at:
http://www.mysql.com/doc/G/R/GRANT.html
--
For technical support contracts, goto https://order.mysql.com/
This
Palmer,
Tuesday, January 29, 2002, 5:19:00 PM, you wrote:
Peoen I am a new user to MySQL. The server is running, but I keep getting the
Peoen following error:
Peoen Host 'www.usapa.army.mil' is not allowed to connect to this MySQL
Peoen server.
[]
Peoen Why am I getting Host is not
In the last episode (Jan 29), John Kemp said:
Hi all,
I can't find a description of the algorithm used in the mySQL PASSWROD
function. I understand it's a hashing algorithm of some kind, but I
don't know which algorithm (and I suspect it's *not* MD5.)
The algorithm is in the
John Kemp writes:
Hi all,
I can't find a description of the algorithm used in the mySQL PASSWROD
function. I understand it's a hashing algorithm of some kind, but I
don't know which algorithm (and I suspect it's *not* MD5.)
Can anyone tell me what algorithm PASSWORD uses? The reason I
Phpmyadmin is pretty good for what you ar elooking for.
You can find it at:
http://www.phpwizard.net/projects/phpMyAdmin/
Gurhan
-Original Message-
From: Ed Lazor [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 29, 2002 10:54 AM
To: [EMAIL PROTECTED]
Subject: mysql web-based admin
You could find a useful tool at
http://www.phpwizard.net/projects/phpMyAdmin/
Hy Moreno
-Messaggio originale-
Da: Ed Lazor [mailto:[EMAIL PROTECTED]]
Inviato: martedi 29 gennaio 2002 16.54
A: [EMAIL PROTECTED]
Oggetto: mysql web-based admin tool?
I used to use some php scripts that
Has anyone on this list used Veritas Cluster Server to build an HA MySQL
solution? If so, please email me. I am in the process of attempting to do
this. So far, I have been able to deal well with the hardware agents
(network, disk, nfs, cpu). However, when it comes to creating software
agents
Ed,
Have you checked out phpMyAdmin? It can be downloaded at:
http://phpwizard.net/projects/phpMyAdmin/
I use it with all my clients and it's great! For when I want a bit
more control I Telnet, but most of the time I use this to help my
with my databases.
I used to use some php scripts
I think mysql uses the system crypt() function. This is, no-doubt, available
through some well hidden Java class. Just do man crypt to learn about
crypt().
Chris
On Tue, 29 Jan 2002 10:59:55 -0500
John Kemp [EMAIL PROTECTED] wrote:
Hi all,
I can't find a description of the algorithm used
Billy,
Where is the source code you are trying to compile located? Is it same as
where you keep your .jar file? If not, give java_home/jre/lib/ext path to
javac as an -classpath option ...
The drivers don't know where to find the databases.. Your program specifies
them the server IP,
Hi all,
I can't find a description of the algorithm used in the mySQL PASSWROD
function. I understand it's a hashing algorithm of some kind, but I
don't know which algorithm (and I suspect it's *not* MD5.)
Can anyone tell me what algorithm PASSWORD uses? The reason I ask is
that
{ Am I to assume there is no solution to my problem? }
Greetings,
I have two large tables in a database with a few million entries. There is only one
column in each table.
Everything was working okay until today. The size of the table files is 1gb+ but
PHPMyAdmin says it has no records.
Hi Guys
I've been using MySQL for a few years now, but always on medium sized
projects. I think the biggest thing I ever did has maybe 200k records in it.
Now all of a sudden I have a client with a requirement for a database that we
estimate will be in the range of 1 to 4 TERABYTES of
Samy,
Tuesday, January 29, 2002, 4:54:24 PM, you wrote:
SE ./configure --prefix=/ussr/loca/mysql
SE
SE Typo I used /usr/local/mysql
SE To make a long stroty short , I downloaded the source
SE rpm and started over , now I have the mysql.sock file.
SE Looks
Frank,
Tuesday, January 29, 2002, 5:30:33 PM, you wrote:
FRSE the ./configure --with-low-memory works but I don't FRSE understand why the
same version of mysql compilesFRSE successfully on smaller system with less
FRSE swap ?
God knows. Compiling such a complicated system like MySQL is
--On Tuesday, January 29, 2002 2:08 AM -0600 Ed Carp [EMAIL PROTECTED] wrote:
What seems to be happening is that the open of the db hangs. So, when
you attempt to connect with a client, mysql tries to look at the grant
tables and hangs waiting for access. This is just a guess though.
When
I am using mysql verison 3.23.41-nt
I am working with the following two tables.
mysql show create table table1;
| Table | Create Table
-
| table1 | CREATE TABLE `table1` (
`Column1` varchar(63) NOT NULL default '',
`Column2` varchar(31) default NULL
mysql must be in your PATH. Is it?
-Original Message-
From: Egor Egorov [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 29, 2002 8:30 AM
To: [EMAIL PROTECTED]
Subject: [NEWBIE]Can't run mysql client
Stephane,
Monday, January 28, 2002, 1:29:40 PM, you wrote:
SP I've installed mysql
Tod Harter writes:
Hi Guys
I've been using MySQL for a few years now, but always on medium sized
projects. I think the biggest thing I ever did has maybe 200k records in it.
Now all of a sudden I have a client with a requirement for a database that we
estimate will be in the range of
Scott -
I recently had a similar problem with a JSP application I built using MySQL
on the backend.
Don't know what the issue is/was but I did notice that if I was updating
rows in a table on a regular basis - PHPmyAdmin 2.2 says I have a lot of
overhead in the table. I'm not sure what is
Hi!
MySQL Control Center (MyCC) is the new GUI client for MySQL databases.
MyCC is developed and provided by MySQL AB - a commercial company that
builds its business providing services around the MySQL database.
MyCC is a platform independent graphical client which is based on
Trolltech's QT
Hi,
I'm brasiliam, so..
my english is very bad
I'm a error:
Warning: Host 'fire1.uniube.br' is not allowed to connect to this MySQL
server
Tanks
Joabe
-
Before posting, please check:
http://www.mysql.com/manual.php
Hi, my problem is that when i do a
show table status like al%
one of my innodb tables (named
'aluno') says to have 255 rows.
But, in fact, it have 286 rows, by:
select count (*) from aluno;
Someone can help me ?
__
On Tuesday 29 January 2002 12:40, Sinisa Milivojevic wrote:
Tod Harter writes:
Hi Guys
I've been using MySQL for a few years now, but always on medium sized
projects. I think the biggest thing I ever did has maybe 200k records in
it.
Now all of a sudden I have a client with a
Hi everybody!
I am developing a site under PHP and Mysql
which is now in the first steps.
My question is, (since I don't administer the server), how can I calculate
the resources
that the system will need to run as smothly as possible?
I mean, for example I am planning to use temporary table to
Tod Harter writes:
What would be the performance considerations? Considering it theoretically if
I (for instance) set things up so that I had an ftp server for the images and
stored filenames in a column then as far as raw data transfer efficiency its
tcp either way. I guess the question
Paul,
I do not know why, but it did not work. Please see yourself:
This lines I could not copy and paste because the results are on a not
connected Mac and this is a windows machine. So I had to write it by hand
(- but looked 2 times at the text)
Your example:
% ps ax | grep mysql
251 ?? S
I m franch a little latin,
no u re not an error.
see at www.mysql.com if u can found doc into your language have a look at
grant / revoke command to make 'fire1.uniube.br' allowed to query the
server.
GRANT ALL ON database.* TO [EMAIL PROTECTED] IDENTIFIED BY password
all is too much u can try
At 20:14 +0100 1/29/02, Lutz, Helmuth wrote:
Paul,
I do not know why, but it did not work. Please see yourself:
This lines I could not copy and paste because the results are on a not
connected Mac and this is a windows machine. So I had to write it by hand
(- but looked 2 times at the text)
Your
Carsten Hammer writes:
Hi,
I just experienced the following bug in tables created as berkeley
tables:
on bdb tables:
mysql SELECT
jobs.number,jobs.status,jobs.filename,jobs.source_file,verarbeitung.name
FROM verarbeitung right join jobs on (verarbeitung.verarbeitung =
jobs.verarbeitung)
- Original Message -
From: sdfine [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, January 28, 2002 12:06
Subject: Accessing MySQL Using ASP
Does anyone have a good example of accessing and displaying data in a
MySQL
database using ASP and displaying it on a web page? I'm a VB
Hi all,
I hava a mysql database wich contain some country name only country names
some a old
like USSR ...
I have to add some field into this db from the file found at the ripe net
ftp.ripe.net
file : iso3166-countrycodes.txt
see part of this file :
Some Codes from ISO 3166
Updated by the
The tarball seems to be missing libmysqlclient.so, I can get the database
server started fine, and can connect to it using client applications.
However, any attempt at using the dynamic client libs fails for obvious
reasons. Am I missing something? Maybe downloading the wrong tarball? Or
do I
I have a big problem with pattern matching;
Why does the first example work like this I need to find everything with
MWF in it and I only get the 1 entry? Is there a way I can make this
work.
mysql select schdays from courses where schdays LIKE %MWF%;
+-+
| schdays |
+-+
| MWF
Hello,
I have a big problem! I need to match all patterns in schdays from a
variable schdays and if schdays = mwf it only turns up mwf and not all
entries containing M, W or F. Is there a way to do this?
mysql select schdays from courses where schdays LIKE %MWF%;
+-+
| schdays |
Hi all,
I want to know how to make software using mySQL as the database server.
I'm using SuSE Linux 7.3Pro + KDE 2.2.2
I've open a project in KDevelop 2.0 and put this link -lmysqlclient
but I can't go thru: MYSQL mysql
Am I missing something else
Thank you.
At 14:59 -0500 1/29/02, Douglas Brantz wrote:
I have a big problem with pattern matching;
Why does the first example work like this I need to find everything with
MWF in it and I only get the 1 entry? Is there a way I can make this
work.
It's unclear what you're expecting to happen. From the
At 03:15 PM 1/29/2002 -0500, Douglas Brantz wrote:
Hello,
I have a big problem! I need to match all patterns in schdays from a
variable schdays and if schdays = mwf it only turns up mwf and not all
entries containing M, W or F. Is there a way to do this?
mysql select schdays from courses where
Is there an OLE DB Provider for MySQL or should I use the Generic ANSI SQL
provider (if there are one of those)? Trying to use MySQL as a backend
database for a project but performance is slower than using even MS Access -
surely there must be a provider out there that blow away at least MS
Doug,
MySql is doing what it is supposed to... If you specify '%MWF%' it will only
select the values with the string literal 'MWF' in it. If you would like to
match all the rows that have either M or W or F in it, then use a query like
:
select schdays from courses where schdays LIKE %M% OR
In the last episode (Jan 29), Douglas Brantz said:
I have a big problem with pattern matching;
Why does the first example work like this I need to find everything with
MWF in it and I only get the 1 entry? Is there a way I can make this
work.
mysql select schdays from courses where
At 15:15 -0500 1/29/02, Douglas Brantz wrote:
Hello,
I have a big problem! I need to match all patterns in schdays from a
variable schdays and if schdays = mwf it only turns up mwf and not all
entries containing M, W or F. Is there a way to do this?
Yes, but you can't do it with LIKE except in
SELECT schdays FROM courses WHERE (schdays LIKE M) OR (schdays LIKE
W) OR (schdays LIKE F)
Matthew Walker
Ecommerce Project Manager
Mountain Top Herbs
-Original Message-
From: Douglas Brantz [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 29, 2002 1:15 PM
To: [EMAIL PROTECTED]
Paul Dubois helped me on this: Check page 520 of his book.
REGEXP [MWF] matches all I need everything inside the [...]
(brackets).
Thank you again Paul.
That problem fixed now moving on to the next one.
Douglas
--
Douglas R. Brantz
Computer Consultant
Fine Applied Arts
Appalachian State
Try this:
select schdays from courses where schdays Regexp[MWF];
-Original Message-
From: Douglas Brantz [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 29, 2002 2:59 PM
To: [EMAIL PROTECTED]
Subject: Please Help with Pattern Matching
I have a big problem with pattern matching;
Why
Given this example:
table CARS
has got an entity Labourghini with car_id=5
table NEWS
has got an entity Lambourghini displays new super model with
date=2002-05-02, news_id=735 and car_id=5
Now:
I want this output:
NEWS HEADLINES
date: headline (car_brand)
Can I do this without 2 select
Thanks to everyone for being so helpful with this solution.
Douglas
--
Douglas R. Brantz
Computer Consultant
Fine Applied Arts
Appalachian State University
Boone, NC 28608
828-262-6549 (office)
828-262-6312 (fax)
-Original Message-
From: Matthew Walker [mailto:[EMAIL PROTECTED]]
Since the days in a week are not likely to change, why not have an indexed
column for each day? For example,
select id from courses where day_m = 1 and day_t = 0 and day_w = 1 and day_h
= 0 and day_f = 1;
Wouldn't this approach be more efficient than a full table scan with regular
expression
At 09:50 PM 1/29/2002 +0100, Torkil Johnsen wrote:
Given this example:
table CARS
has got an entity Labourghini with car_id=5
table NEWS
has got an entity Lambourghini displays new super model with
date=2002-05-02, news_id=735 and car_id=5
Now:
I want this output:
NEWS HEADLINES
date:
Given this example:
table CARS
has got an entity Labourghini with car_id=5
table NEWS
has got an entity Lambourghini displays new super model with
date=2002-05-02, news_id=735 and car_id=5
I want this output:
NEWS HEADLINES
date: headline (car_brand)
Can I do this without 2 select
I got this address from the MyCC README file. If it is the wrong one, my
apologies - could you send me the right one.
Description: Starting MyCC on a W2000 native dual monitor PC results in the
main window spanning both monitors.
Details: Normally, when an application is started on a native
Yes it is so easy.. You just need to use table joins..
Check out:
http://www.mysql.com/doc/J/O/JOIN.html
Gurhan
-Original Message-
From: Torkil Johnsen [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 29, 2002 3:50 PM
To: [EMAIL PROTECTED]
Subject: Need some easy select assistance
Hi,
On Wed, 2002-01-30 at 00:06, Chetan Lavti wrote:
thanks for your quick reply !!
that's fine !! I have done the max.RPM installation part.
but what is fix up the startup scripts so that
binary will be the one started.
When I am trying show variables like have_%;
Hello everyone,
I need to export some data from one DB to another.
Suppose I'm connected to DB1 and my trying to get stuff from there and insert into
DB2. I'm using Insert Select statements. Once I'm connected to DB1, do I have to
establish separate connection for DB2?
An example Insert
Description:
Executing a SELECT DISTINCT statement in conjunction
with the BINARY cast operator will crash MySQL server
when the column being cast contains one or more null
values.
How-To-Repeat:
Executing the following code from a mysql prompt will
cause the MySQL server to
At 15:48 -0600 1/29/02, Demirchyan Oganes-AOD098 wrote:
Hello everyone,
I need to export some data from one DB to another.
Suppose I'm connected to DB1 and my trying to get stuff from there
and insert into DB2. I'm using Insert Select statements. Once I'm
connected to DB1, do I have to
I tried this on an existing table using a char(50) column with 956 entries,
of which I have 1 valid entry and 954 NULL values. I have 2 records returned
1 = valid entry, 1 = NULL and mysql did not crash.
Is it only when you are using temporary tables? Or have you tried this on
multiple tables to
Hi,
Can anyone point me to some good examples of how to add images using PHP 4 (from
within a browser) to a MySQL database running on MacOSX, which is already configured
working, then display the images by selecting their name or category etc, again within
the browser. I also need to
I am in the process of migrating our data from m$ SQL Server to MySQL. I
am having a heck of a time trying to figure out how to deal with m$ SQL
Server's data type called 'uniqueidentifier'. I have tried very large
varchar's and blob's and even longtext but I always get datatype
conversion errors
database,sql,query,table
I need to find out what the next value will be in an auto_increment field
will be. could someone help me out with the select statement?
-
Before posting, please check:
1 - 100 of 171 matches
Mail list logo