it's work :)
thanks all,
On Sun, 2002-11-24 at 12:28, Jocelyn Fournier wrote:
> don't forget
>
> FROM table1,table2 ;)
> :
>
> SELECT name, table1.position, table2.position
>
> FROM table1,table2
> WHERE table1.name=table2.name;
>
> Regards,
> Jocelyn
> - Original Message -
> From:
Doh!
Just when you think you have a softball . . .
Yes, the answer should include the FROM:
SELECT name, table1.position, table2.position
FROM table1,table2
WHERE table1.name=table2.name
Filter: MySQL SQL
- Original Message -
From: "Jocelyn Fournier" <[EMAIL PROTECTED]>
To: "Dennis Sal
Doh!
Just when you think you have a softball . . .
Yes, the answer should include the FROM:
SELECT name, table1.position, table2.position
FROM table1,table2
WHERE table1.name=table2.name
Filter: MySQL SQL
- Original Message -
From: "Jocelyn Fournier" <[EMAIL PROTECTED]>
To: "Dennis Sal
don't forget
FROM table1,table2 ;)
:
SELECT name, table1.position, table2.position
FROM table1,table2
WHERE table1.name=table2.name;
Regards,
Jocelyn
- Original Message -
From: "Dennis Salguero" <[EMAIL PROTECTED]>
To: "Osman Omar" <[EMAIL PROTECTED]>; "MySQL" <[EMAIL PROTECTED]>
Sent
Hi,
Try :
SELECT table1.name,table1.position,table2.position FROM table1 LEFT JOIN
table2 USING(name);
Take a look here :
http://www.mysql.com/doc/en/JOIN.html
Regards,
Jocelyn
- Original Message -
From: "Osman Omar" <[EMAIL PROTECTED]>
To: "MySQL" <[EMAIL PROTECTED]>
Sent: Saturday,
You might want to add some unique IDs or something else in common to make
this query a bit better, but the following is what you should be doing:
SELECT name, table1.position, table2.position
WHERE table1.name=table2.name
Good Luck!
Dennis
- Original Message -
From: "Osman Omar" <[EMAI
I have 2 table with same structure
table 1 have name and position
table 2 have name and position
name in table 1 same as name in table 2 but position in table 1 may not
same as position in table 2
how do I get data like this
what is sql command
nameposition.table1 position.table2
tha
Hi All!
I am using mysql-.3.23.49 on windows. It generates the
following error:-
General error: Incorrect key file for table: 'lotjob'.
Try to repair it .
or some times it generates a table handler error.
why do these errors occur?
Regards
Amit Lonkar
I have mysql running using its standard myisam database.
The server is version 3.23.39-max, clien 3.23.36
Operating system Windows 2000 5.00.2195 Service pack 2
I am using the following my.ini
#This File was made using the WinMySQLadmin 1.1 Tool
#11/21/2002 9:16:12 PM
#Uncomment or Add only the
Hi,
i faced a problem when using LIMIT clause in select
statement..
select * from Discussion Where ParentID=x Order By
DatePosted Desc LIMIT 1
iam using the above select statement inside a loop
where ParentID varies...
when u run that program, suddenly mysql stopped and
said mysql-opt error
t
I have the same problem with inserting the links in MySQL using Perl.
I can do all the job with Perl, but if the link contains a "?" sign, it is
replaced by the string "NULL" in the MySQL database and the link stored will
be something like:
http://www.server.com/cgi-bin/script.plNULLid=3
Do I ne
On Fri, Nov 22, 2002 at 06:56:53PM -0500, Michael T. Babcock wrote:
> On Fri, Nov 22, 2002 at 06:20:14PM -0500, Philip Mak wrote:
> > sql,query
> >
>
> Why not just:
> SELECT * FROM users, boardAdmins, boardMembers WHERE id = 5;
>
> You're not really 'joining', since boardAdmins and boardMembers
On Fri, Nov 22, 2002 at 06:20:14PM -0500, Philip Mak wrote:
> sql,query
>
Why not just:
SELECT * FROM users, boardAdmins, boardMembers WHERE id = 5;
You're not really 'joining', since boardAdmins and boardMembers don't have the
structure JOINs are made for (it seems).
--
Michael T. Babcock
CTO
sql,query
Which way is faster?
Way 1:
SELECT *
FROM users
LEFT JOIN boardAdmins ON boardAdmins.userId = users.id
LEFT JOIN boardMembers ON boardMembers.userId = users.id
WHERE id = 5;
Way 2:
SELECT * FROM users WHERE id = 5;
SELECT * FROM boardAdmins WHERE userId = 5;
SELECT * FROM boardMemb
Hello Sergei,
In going through the archives I found this message which is similar to an
issue I am currently having. You mention to "Consult the manual for
details." I've check through the on-line manual:
http://www.mysql.com/doc/en/index.html
specifically,
http://www.mysql.com/doc/en/SHOW_
some of the gurus (which i'm not) on the list
will help you find some of the problems.
however, before you jump into them, remember that
ms. access is not a database server; it is a
desktop database manager. as such, it runs
without much of a server's overhead even when the
server is runni
since i've not done much with blobs, i hesitate
to respond, but since nobody else has, maybe some
observations might help.
first of all, you're coding to an oledb provider,
but specifying an odbc driver. you can use both
if you feed the provider from the driver.
otherwise, you need to use
What are your permissions on /tmp ?
should be:
drwxrwxrwt 3 root wheel 512 Nov 22 14:56 /tmp
Van
--
=
Linux rocks!!! http://www.dedserius.com/
=
Kenneth Illing
Mysqld.log shows this error:
021122 11:29:05 mysqld started
021122 11:29:06 Can't start server : Bind on unix socket: Permission denied
021122 11:29:06 Do you already have another mysqld server running on socket:
/var/lib/mysql/mysql.sock ?
Actually, Marc has broken most of his packages out to those that work
with 10.2 and those that work with 10.1.
I went there a while back to see if he had v4, which he did, but it was
a few beta versions behind. I didn't try it since I've been meaning to
try building it myself, which I tried onc
I'm trying to install the pre-built version of MySQL on Mac OS X. Can
someone point me at installation instructions?
Thanks,
Michael-
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://li
i see. there is an option in my.cnf which says which user to run mysqld as.
change this to mysql. make sure that mysql is a real user on your system.
also, be sure to set the full path to the basedir and datadir in the my.cnf
user = mysql
basedir = /usr/local/mysql
datadir = /usr/local/mysql/data
At 13:11 +1100 11/22/02, Alan McDonald wrote:
this might give you some ideas
select
CONCAT(DAYOFMONTH(p.DATEGOLIVE),'.',MONTH(p.DATEGOLIVE),'.',YEAR(p.DATEGOLIV
E)) DATEGOLIVEF
from my table p
It's a little easier to use DATE_FORMAT(d,'%M, %d, %Y') instead.
-Original Message-
From:
On 22 Nov 2002, at 12:43, Hans Zaunere wrote:
> I know all about cacheing and all, but I'm just frustrated
> by this DATETIME column issue, after switching from the fantastic INT column
> and UNIX timestamp scheme.
If using a Unix timestamp was fantastic, why did you move away from
it? (And su
THANKS! :-)
JF> Hi,
JF> Take a look here :
JF> http://www.mysql.com/doc/en/DATETIME.html
JF>...
thanks for your help!
i used to work with postgresql and there timestamp and datetime are equivalent.
thanks again!
--
Best regards,
ozy
--- "Keith C. Ivey" <[EMAIL PROTECTED]> wrote:
> On 21 Nov 2002, at 18:20, Hans Zaunere wrote:
>
> > > but as long as it's a DATETIME
> > > column then you are looking for a range of values, so 'range' is the
> > > best you're going to get in the EXPLAIN output.
> >
> > Yes, but the real data
you say you chown -R mysql /usr/local/mysql/data, yet the error shows mysql
trying to start with databases from /var/lib/mysql. check your startup
script for basedir and datadir settings.
-Original Message-
From: Kenneth Illingsworth [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 22, 20
This happens when I try to start the mysql daemon. I have checked the manual, but
cannot fathom what else I am supposed to do.
Here is what has been done so far:
./scripts//mysql_install_db seemed to initialize the MySQL db's ok.
I also executed the following statements without issue:
chown -
Hello everyone,
try using: update szurtcounter set hely='kulfold', datum=datum;
instead of: update szurtcounter set hely='kulfold';
this works, maybe there are better ways.
Regards,
Stefano Locati - http://dev.obliquid.com/
> now i run an SQL query like this one:
>
> update szurtcounter set
Hi,
Take a look here :
http://www.mysql.com/doc/en/DATETIME.html
"Automatic updating of the first TIMESTAMP column occurs under any of the
following conditions:
a.. The column is not specified explicitly in an INSERT or LOAD DATA
INFILE statement.
b.. The column is not specified explicitly i
At 20:16 +0100 11/22/02, ozy wrote:
Hello everyone,
/first of all, sorry about my bad english :-)/
i had just found some interesting thing with MySQL 3.23 (win2000).
i have a table like this:
++---+--+-+-+---+
| Field | Type | Null | Key
Hello everyone,
/first of all, sorry about my bad english :-)/
i had just found some interesting thing with MySQL 3.23 (win2000).
i have a table like this:
++---+--+-+-+---+
| Field | Type | Null | Key | Default | Extra |
++--
On 11/22/02 4:32 AM, "Stu Duncan" <[EMAIL PROTECTED]> wrote:
> Try going to
> http://www.entropy.ch/software/macosx/mysql/
> It's the best Mac MySQL reference around (but seems to be down this
> Friday AM). I've used version 3.23.52-entropy.ch on a low bandwidth
> website with no problems at all.
What version of MySql?
Are you connecting from Access?
Are the server and the front end on the same machine?
Jfernando
** sql **
-Original Message-
From: Weiwei Wang [mailto:[EMAIL PROTECTED]]
Sent: November 22, 2002 11:51
To: [EMAIL PROTECTED]
Subject: why so slow?
Hi,all:
I am runni
Hello,
I've got this question about query cache in mysql 4 - when I do query like
this:
SELECT SQL_CACHE column_a FROM table_a WHERE column_a = 'const';
and then I update table like this:
UPDATE table_a SET column_b = column_b + 1;
cache entry is invalidated and deleted (I hope, I understood
There are a couple managed .Net providers for mySQL. One that I use is eInfo
Designs' dbProvider. They have a couple different versions available, the
personal is free. It works very well and is designed to work within
Microsoft's .Net framework for data objects. www.einfodesigns.com
I'd be intere
Use the DISTINCT keyword.
SELECT DISTINCT table2.* FROM table2, table1 WHERE table2.id=table1.id
-Original Message-
From: Tarik Ansari [mailto:[EMAIL PROTECTED]]
Sent: 22 November 2002 17:10
To: [EMAIL PROTECTED]
Subject: Selecting rows issue
Hello,
I got two tables containing foll
After taring mysql-3.23.53-unknown-linux-gnu-s390.tar.gz successfully on our Linux VM
and linking the new directory to simply mysql, I ran into the following error trying
to start the mysql daemon:
[root@cofr3 mysql]# ./bin/mysqld -L /mysql/share/mysql/english
Fatal error: Please read "Security"
Hi,
yes
www.einfodesigns.com
dbProvider (samples are included)
Thanks
Anibal Cascais Santos
www.engrenagem.net
22 731 93 74
- Original Message -
From: "Natale Babbo" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday,
Hello Tarik,
The DISTINCT option will sort this out for you.
=dn
> I got two tables containing following data :
>
> table1
> --
> id
> --
> 2
> 3
> 2
> 2
>
> table2
> --
> id | label
> --
> 1 | one
> 2 | two
> 3 | three
> 4 | four
>
> I would like to select table2's rows th
Hi Trask,
> Can anyone tell me how to set the following parameters in mySQL 3.23? I'm
> new to MySQL and am setting up a BBS. MySQL is installed and running OK.
>
> Database Server Hostname / DSN:
> Database Name:
> Database Username:
> Database Password:
> Prefix for tables in database:
Welco
Hello,
I got two tables containing following data :
table1
--
id
--
2
3
2
2
table2
--
id | label
--
1 | one
2 | two
3 | three
4 | four
I would like to select table2's rows that got at less one occurrence in
table1, ie (2, two) and (3, three).
That I tried was the follow
Hello All,
Is it possible to connect to a MySQL database using
.NET without ODBC?
... and if yes then please give me a sample connection
string and tell me what provider/driver to use!
Thanks a lot!
__
Per te Blu American Expres
At 11:20 +0200 11/22/02, Mircea LUTIC wrote:
Hello!
Question: Can I rely on the following behaviour?
mysql> create table test(id integer not null auto_increment primary key, t
char(15));
mysql> insert into test(t) values (last_insert_id());
mysql> insert into test(t) values (last_insert_id()+1);
On Friday 22 November 2002 17:19, RAHARD Matthieu wrote:
> I set up replication on my servers since the version 3.23.43. Recently I
> upgrade all my servers to version 4.0.3.
> The replication work fine for insert and delete queries (also alter table)
> but doesn't take care of update queries.
re
Hi,all:
I am running my project based on the MySql ODBC connection.
Now the operations including select,update and delete to the tables
are so slow compared with the former MS Access ODBC connection.
COULD U TELL ME HOW TO FIX THIS?
thanks a million!!
weiwei
On Fri, Nov 22, 2002 at 07:40:26AM -0800, tmb wrote:
> Does PHP have to do all the work here...
>
> 1 - fetch the url from the db
> 2 - fetch the link name from the db
> 3 - construct the html code to display it
Yes; what else had you imagined?
If you do it right, it will probably look something
On Fri, Nov 22, 2002 at 10:32:59AM +0100, Roger Baklund wrote:
> > How would MySQL react to having some of its data files stored on
> > encrypted loop-back devices that aren't available all the time, but are
> > always available when a certain user logs in?
>
> I'm sorry, I don't understand the qu
> > Im running the following query:
> >
> > SELECT
> > user.nickname,
> > user.id,
> > user_detail.points
> > FROM
> > user,
> > user_detail
> > WHERE
> > user.details = user_detail.id
> > AND user.id > 101
> > AND user.language = 'en'
> > ORDER BY user_detail.point
sql,query
At 8:53 -0500 11/22/02, Nicholas Elliott wrote:
So essentially, you want to put an index on part of the column, and not the
whole column, right? As in, an index on just the date part, and not the time
part. (Or both -- it seems like you want it to do both at the same time).
Much like yo
At 7:40 -0800 11/22/02, tmb wrote:
I want to store some web links in a MySQL db...
than later using PHP retreive them and put them on a
web page...
Does PHP have to do all the work here...
1 - fetch the url from the db
2 - fetch the link name from the db
3 - construct the html code to display i
On 21 Nov 2002, at 18:20, Hans Zaunere wrote:
> > but as long as it's a DATETIME
> > column then you are looking for a range of values, so 'range' is the
> > best you're going to get in the EXPLAIN output.
>
> Yes, but the real data I'm looking for is not a range - it's simply a part of
> a sin
slickmik,
Thursday, November 21, 2002, 6:58:18 PM, you wrote:
saedodedn> Description:
saedodedn> When mysql is installed via linux rpm file, it does not install
saedodedn> mysqladmin command?
saedodedn> How-To-Repeat:
saedodedn> just install mysql from redhat linu
Mark,
Thursday, November 21, 2002, 5:01:51 PM, you wrote:
MC> I should have been more specific in my previous post. I am actually after
MC> the syntax to get the data out of a table and into a file. I couldn't quite
MC> work this out from the stuff I read in the manual.
What exactly do you want t
Massimo,
Friday, November 22, 2002, 2:59:38 PM, you wrote:
MB> I'd want to backup my database. Which is the best method between mysqldump and
copying the /usr/local/var directory?
For InnoDB tables take a look at InnoDB Hot Backup software (non-free). It is a must
to have on a production box. W
On Fri, 2002-11-22 at 10:40, tmb wrote:
> I want to store some web links in a MySQL db...
>
> than later using PHP retreive them and put them on a
> web page...
>
> Does PHP have to do all the work here...
>
Personally I would use Perl to do this.. :-P :-)
Yeah... you're going to have to write
Has 4.0 Been offical release, I thought it was still in Beta?
-Original Message-
From: Josh Wilson [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 22, 2002 10:32 AM
To: [EMAIL PROTECTED]
Subject: Re: MySql 5.0
When can we expect a release of 5.0 with stored procedure
functionality in M
Dobrý den,
sexta-feira, 22 de novembro de 2002, 13:26:01, napsal jste:
JC> What is MYI and frm files?
The MySQL tables in case of "MyISAM tables" are separated in :
.frm - The struct (header) of table
.MYD - The DATA of table
.MYI - The Indexes of table
in case of InnoDB , only .frm exists , t
I want to store some web links in a MySQL db...
than later using PHP retreive them and put them on a
web page...
Does PHP have to do all the work here...
1 - fetch the url from the db
2 - fetch the link name from the db
3 - construct the html code to display it
or is there a better way?
thanks
When can we expect a release of 5.0 with stored procedure
functionality in MySQL?
Sincerely,
Joshua Wilson
Software Engineer
SOSystems Corporation
[EMAIL PROTECTED]
801-222-0200
'Whoever controls your thoughts, controls your actions.'
--
Hello,
I set up replication on my servers since the version 3.23.43. Recently I
upgrade all my servers to version 4.0.3.
The replication work fine for insert and delete queries (also alter table)
but doesn't take care of update queries.
When I make an update on an existant row in a table on the m
hi everyone.
sometimes it happens, that the slave mysql server dies because a floating point
exception.
on the console where I started the slave mysql daemon I get the error:
/usr/local/mysql/bin/safe_mysqld: line 274: 24423 Floating point
exception$NOHUP_NICENESS $ledir/$MYSQLD $defaults --b
So essentially, you want to put an index on part of the column, and not the
whole column, right? As in, an index on just the date part, and not the time
part. (Or both -- it seems like you want it to do both at the same time).
Much like you can with a char column -- put a char on the first 2 letter
Dobrý den,
sexta-feira, 22 de novembro de 2002, 11:32:00, napsal jste:
MB> which is the command to restore from a dump??
if you use the InnoDB hot Backup tool the command is
ibbackup --restore
in case of InnoDB, of course...
In case of mysqldump , the command is
source file_dumped.sql; ( i
which is the command to restore from a dump??
-Messaggio originale-
Da: Dyego Souza do Carmo [mailto:[EMAIL PROTECTED]]
Inviato: venerdì 22 novembre 2002 14.23
A: Massimo Bandinelli
Cc: [EMAIL PROTECTED]
Oggetto: Re: Recovery
Dobrý den,
sexta-feira, 22 de novembro de 2002, 10:59:38, naps
Dobrý den,
sexta-feira, 22 de novembro de 2002, 10:59:38, napsal jste:
MB> I'd want to backup my database. Which is the best method between mysqldump and
copying the /usr/local/var directory?
MB> Thanks, Massimo.
you use InnoDB ? the best and fast metod to backup your InnoDB
databases is usin
I'd want to backup my database. Which is the best method between mysqldump and copying
the /usr/local/var directory?
Thanks, Massimo.
Massimo Bandinelli
System Administrator
-
Register.it S.p.A. - Gruppo DADA
tel +39 199 REGIST (+39 199 734478)
fa
Try going to
http://www.entropy.ch/software/macosx/mysql/
It's the best Mac MySQL reference around (but seems to be down this
Friday AM). I've used version 3.23.52-entropy.ch on a low bandwidth
website with no problems at all.
HTH,
Stu
On Thursday, November 21, 2002, at 11:30 PM, R. Hannes Nie
On Fri, 22 Nov 2002 12:43:58 -
"Jocelyn Fournier" <[EMAIL PROTECTED]> wrote:
> I just want to add that unlike what it is printed ("Download BitKeeper
> from http://www.bitmover.com/cgi-bin/download.cgi. You will need
> Bitkeeper 2.0 or newer to access our repository."), Bitkeeper 3.x seems
> t
>
>
> > hallo,
> >
> > I try to skip logging on three special databases where a couple of
> > otherdatabases
> > should log their update in te binlog-file. The options in the
> > my.cnf-file
> >
> > log-bin= /www/cmsdata/log/bin-log
> > binlog-ignore-db = db_1,db_2,db_3
> >
>
* Maximo Migliari
> Im running the following query:
>
> SELECT
> user.nickname,
> user.id,
> user_detail.points
> FROM
> user,
> user_detail
> WHERE
> user.details = user_detail.id
> AND user.id > 101
> AND user.language = 'en'
> ORDER BY user_detail.
Hello!
Question: Can I rely on the following behaviour?
mysql> create table test(id integer not null auto_increment primary key, t
char(15));
mysql> insert into test(t) values (last_insert_id());
mysql> insert into test(t) values (last_insert_id()+1);
mysql> select * from test;
++--+
| id
Guenter,
Nice piece of analysis!
As it happens WinMySQLadmin v1.4 under Win2000 fares little better,
apparently gobbling up VM until... (Bug Report posted 20Nov2002 shortly
after midnight UTC - as yet unacknowledged)
[won't attach here (not correct list procedure), so will forward private
copy sep
73 matches
Mail list logo
