On Sun, May 19, 2002 at 06:26:54AM -0700, Henry Hank wrote:
Hello All,
I recently moved my database from mysql 3.22.29 to 3.23.41, and
udated all my tables to MyISAM tables. Under ISAM, I could take the
filesize of the ISD table and divide by the record length to get the
exact number
On Mon, May 20, 2002 at 10:10:04AM +0800, Patrick Hsieh wrote:
Hello list,
I am planing to write a script to telnet mysql server(port:3306) and
try to verify the server status. When I try something like this:
home:~ #telnet localhost 3306
Trying 127.0.0.1...
Connected to localhost.
On Thu, May 16, 2002 at 11:45:26AM -0400, adam nelson wrote:
I'm finally getting around to working with InnoDB for real :-)
Great.
Anyway, is there any reason to still use MyISAM on any tables.
Of course there is.
Concurrency is my biggest problem (Locked tables, etc.).
Then for you the
On Thu, May 16, 2002 at 12:36:31PM -0400, vlady wrote:
Hi all,
I would like to know how often (delay in sec.) the slave checks the
master for new records in the log, and if one can control that .
The only delay is caused by the slave running a query and network
latency. There's not other
On Mon, May 20, 2002 at 04:33:41PM +0200, andy wrote:
Thank you Egor for you reply.
I did read about indexing text column on the mysql site. So I tryed
to index my column like described. After 1 hour, I had to reboot my
machine because there was no other way.
No other way?
You could have
On Thu, May 16, 2002 at 11:32:48AM -0400, Lance Lovette wrote:
I have partitioned my data such that each client has its own
database (clientdb1, clientdb2, ... clientdbN). All the databases
have the same structure (same tables, columns, etc.). This design
works great except for one caveat -
On Mon, May 20, 2002 at 09:39:52AM -0600, Andrei Cojocaru wrote:
I believe mySQL uses B-Trees (not binary trees), that's about all I
know :)
Right. The indexes are B-Tree structures (until R-Trees appear in
4.1, of course).
Jeremy
--
Jeremy D. Zawodny | Perl, Web, MySQL, Linux
On Fri, May 17, 2002 at 11:41:49AM +0300, Michael Widenius wrote:
[snip]
In a case like this (where so many rows are covered by the index)
it's not self evident that a table scan is not faster than an index
scan.
Especially with many users using the key cache at the same time, a
table
On Mon, May 20, 2002 at 12:25:26PM -0400, walt wrote:
Does anyone know where rollbacks are stored for innodb tables? I
assume memory since I keep getting a table full error when trying to
drop an index. sql,query
I'm not exactly sure what you're asking, but the rollback information
needs
Hi,
I have my Database in MYSQL and wanna use PHP on Apache
At the starting of the page I have given
?php
$query = SELECT * FROM appl;
// Establish a connection to the MySQL DBMS
$connection = mysql_connect(linuxsrv, sameer, sameer);
// Use the rcmms database
Hello,
My hard drive has just failed on my database server, and I have rebuilt it
and copied the data from backups back on to the drive, however mySQL
cannot see all of the databases.
A 'show databases' shows all of the databases, however 'use DBNAME' says
ERROR 1102: Incorrect database
Stavros,
As an absolute last resort try the following...
Shutdown mysql first. copy your database backups to a safe place before
doing this.
Removed all tables first off. Then move the .MYD and .MYI and .frm files for
each database.
Run mysqladmin and re-create all of the tables again. and
Hello alessio,
Tuesday, May 21, 2002, 10:23:54 AM, you wrote:
aavi Hi all,
aavi I've got a problem in configuring my.ini file for using InnoDB tables.
aavi I am using mysql ver. 3.23.49 and winnt ws sp6.
aavi I read almost everything from the manual and I was not able to solve the
aavi
On Tuesday 21 May 2002 10:38, Sameer Maggon wrote:
Hi,
I have my Database in MYSQL and wanna use PHP on Apache
At the starting of the page I have given
?php
$query = SELECT * FROM appl;
// Establish a connection to the MySQL DBMS
$connection = mysql_connect(linuxsrv, sameer,
Hello,
Can you not have '.' in database names any more??
I just renamed one of the databases to something without .'s, and it
worked.
Kind Regards,
0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0
escape net
m a k i n g t h e n e t
On Tuesday 21 May 2002 09:51, Robert Vetter wrote:
On Tuesday 21 May 2002 10:38, Sameer Maggon wrote:
in /var/www/html/rcmms/appl.php on line 5
Hello,
1. make shure the PHP module is compiled into Apache, or runs as CGI.
rubbish, sorry. Make shure PHP is compiled with MySQL support.
I understand that a query like SELECT... FOR UPDATE will lock other
threads from being able to modify those records in any way, however,
other threads can still read them. I would like to be able to SELECT say
10 records and place a READ and WRITE lock on those rows so that the
next SELECT thread
Probably a very simple one for you guys, but I'm stuck.
Given a simple table (events):
id int
st time not null
et time not null
I know I can get duration by converting st and et to secs and subtracting
(that bits easy), but how would I go about getting the gap between
successive
How can one evaluation the security of a MySQL installation and what are
the steps that should be taken to secure an installation from the ground
up.
Thanks
Frank
-
Before posting, please check:
I'm using MySQL from ASP pages, I use MyODBC 3.50 and have a problem with a
query. If I type the query directly in mysql it works OK but from ASP pages
I get an error.
I'm trying to use a multiline query separated by ; like this
query1;query2;
If I do like this
query1;
execute
query2;
execute
How do you do this:
SELECT * FROM table1 WHERE table1.field1=0
--
SELECT * FROM table1 WHERE table1.field1=0
Is there a function in mysql that allows you to
evaluate(dunno whether I use the correct term here)
the string and not to treat it like a string?
TIA.
Ho Keat
You could join the table against itself, matching each row against every
following record and then summarizing to find the next one. If your table
is of a fair size, you'd need to play with the optimizer to make sure you
get the efficiency you need. The SQL would be along the lines of:
select
SEND-PR: -*- send-pr -*-
SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as
SEND-PR: will all comments (text enclosed in `' and `').
SEND-PR:
From: bug
To: [EMAIL PROTECTED]
Subject: [50 character or so descriptive subject here (for reference)]
Description: when configuring
Do you mean, a character client for windows or the linux client?
On linux I can do everything, delete, alter, insert, create,
but I don't think that is going to solve my problem on windows.
- Original Message -
From: Andrei Cojocaru [EMAIL PROTECTED]
To: Federico Coco [EMAIL PROTECTED];
On Tue, 21 May 2002, David Shields wrote:
Probably a very simple one for you guys, but I'm stuck.
Given a simple table (events):
idint
sttime not null
ettime not null
I know I can get duration by converting st and et to secs and subtracting
(that bits easy), but how would I
[snip all kinds of stuff]
?php
$query = SELECT * FROM appl;
$connection = mysql_connect(linuxsrv, sameer, sameer);
mysql_select_db(rcmms, $connection);
$result = mysql_query($query, $connection);
?
I says that mysql_connect
Fatal error: Call to undefined function: mysql_connect()
in
Ok, so know you got me interested. What exactly are R-Trees. I know the
structure of B trees, hadto program a small version of a B' tree before, but never
heard of an R-Tree.
Any explanation
or link to where I might find some info would be appreciated.
-Nick
On Mon, May 20, 2002
at 09:39:52AM
Hi!
Vadim == Vadim P [EMAIL PROTECTED] writes:
Vadim Sergei Golubchik wrote:
rebuild your indexes (the proper way to do it is to issue
REPAIR table_name USE_FRM
Vadim Sergei, would ALTER TABLE.. DROP INDEX.. ADD FULLTEXT... do the same trick?
Yes, this would do the same thing as REPAIR,
I was wondering if anyone knew the proper way to restart MySQL on OS X?
I did mysqladmin -p shutdown then safe_mysqld...is this the same as
if the machine started up?
--
---
Alex Pilson
FlagShip Interactive, Inc.
[EMAIL
Hi!
Grigory == Grigory Kolesov [EMAIL PROTECTED] writes:
cut
Grigory 1) Endiannes. I figured out that the size of packet is stored at the
Grigory beginning of packet as little endian unsigned int.
Grigory Is it so in all cases, or it just happens because both client and server
Grigory run
Hello,
I would like to do this witihn mysql:
SELECT con.id,con.name FROM contacts con, registrar_contact reg
WHERE NOT con.id IN
(SELECT contactid FROM registrar_contact WHERE registrarid=1)
can someone tell me how to do this ?
contacts table consists of:
id(primary key)
name
Hello,
approximatly twice a week I get Error 1030: error 127 (table handler) on
one table. This table is around 2.3 GB, the indexfile around 2.2 GB.
There are around 24.000.000 records in the table.
I am running mysql 4.0.1-alpha on linux with 2.4.18 kernel. But I also
got this error with
Hi,
What i know :
Indexing progressively, smaller regions of data space using a B tree like
data structure.
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL
Hi,
I have a table containing data on a number of families.
I want to retrieve members of each family that have the two highest
scoring values for a column. i.e the max and second max.
Is there a function similar to max() or greatest() that will return the
top 2 values when grouping by family
alex, chuck a copy of phpMyAdmin onto the machine.
edit the phpMyAdmin configuration file to your username and password and
load it up on the loopback address.
you should find a button saying 'reload mysql' on the page.
phpMyAdmin rules!!!
cheers,
jake
on 21/5/02 1:43 pm, Alex Pilson at
Hello,
I would like to do this witihn mysql:
SELECT con.id,con.name FROM contacts con, registrar_contact reg
WHERE NOT con.id IN
(SELECT contactid FROM registrar_contact WHERE registrarid=1)
can someone tell me how to do this ?
contacts table consists of:
id(primary key)
name
Hi!
Michael == Michael B Venezia [EMAIL PROTECTED] writes:
Description:
MichaelPossible Bug in UPDATE in MySQL 4.0.1
cut
Michael Attempting backtrace. You can use the following information to find out
Michael where mysqld died. If you see no messages after this, something went
There is a link for mysql-startupitem.pkg.tar.gz on
http://www.entropy.ch/software/macosx/mysql/
This will install the startup stuff needed to do what you want.
On 5/21/2002 5:43 AM, Alex Pilson [EMAIL PROTECTED] wrote:
I was wondering if anyone knew the proper way to restart MySQL on OS X?
Hi,
I have a MySQL database with a table named CONNEXION. When i'm trying to do
something with the specific table, i have the following error:
ERROR1016:Can't open file: 'CONNEXION.MYD'. (errno: 145)
Please can anybody help me?
Thanks in advance
--
Alex Pilson wrote:
I was wondering if anyone knew the proper way to restart MySQL on OS X?
I did mysqladmin -p shutdown then safe_mysqld...is this the same as if
the machine started up?
Not exactly the same. But for intents and purposes it does what you want.
If you want to truly make it
At 9:20 AM -0400 5/21/02, Reid Sutherland (mysql) wrote:
Alex Pilson wrote:
I was wondering if anyone knew the proper way to restart MySQL on OS X?
I did mysqladmin -p shutdown then safe_mysqld...is this the same as
if the machine started up?
Not exactly the same. But for intents and purposes
Not a problem. I think the easist way to do it is
SELECT * FROM families ORDER BY score DESC
LIMIT 2 Of course you need your grouping statement in there but the ORDER
BY section shouldntmake a difference.
There are MAX and MIN functions but my understanding is that those will
only return THE
Hi Rich,
Use the LIMIT 2 and sort the SELECT with ORDER BY family ID DESC
//
Jonny
-Ursprungligt meddelande-
Från: R.Dobson [SMTP:[EMAIL PROTECTED]]
Skickat: den 21 maj 2002 14:57
Till: [EMAIL PROTECTED]
Ämne: returning top two values
Hi,
I have a table containing data
[snip]
SELECT con.id,con.name FROM contacts con, registrar_contact reg
WHERE NOT con.id IN
(SELECT contactid FROM registrar_contact WHERE registrarid=1)
[/snip]
Current versions of MySQL do not support sub-selects.
HTH!
Jay
[snip]
I want to retrieve members of each family that have the two highest
scoring values for a column. i.e the max and second max.
Is there a function similar to max() or greatest() that will return the
top 2 values when grouping by family ID?
[/snip]
Try this query
select foo, MAX(bar)
from
Could someone give me a brief description of the following priviledges and what they
are used for...?
1) References Not yet implemented. Is that still true?
2) File ??
3) Index Is this so the person can create an index, and if so, they must first have
the alter statement right?
I
Dear All,
I have a table contains airline ticket prices, and I want to get the
following data from this table
The first 5 records of the lowest price of each airline from each city, and
don't want to get a duplicated combination of (airline, city) in this result
(even if I didn't see all airlines
You can use JOIN...
See: http://www.mysql.com/doc/A/N/ANSI_diff_Sub-selects.html
Gurhan
-Original Message-
From: van den Heuvel, Frank [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 21, 2002 8:47 AM
To: '[EMAIL PROTECTED]'
Subject: select in select
Hello,
I would like to do this
There is no secure, nonsecure installation. You usually take security
measurements after the installation.. The security mesaure you take before
installation is to create a group and user called mysql to have appropriate
permissions on the datadirs, socketfiles, etc.
See:
Hello~
I read the MySQL manual on how to set passwords but i'm a little confused.
How can i remove privileges so that you cant log on anonymously?
Thanks.
Amy
-
Before posting, please check:
Use perror program to see what the error code means..
perror 145
Error code 145: Unknown error 145
145 = Table was marked as crashed and should be repaired
Repair your table..
see: http://www.mysql.com/doc/R/E/REPAIR_TABLE.html
Gurhan
-Original Message-
From: Bertrand TACHAGO
Hi!
This problem is now fixed in the current BK tree and will OK in 0.8.3.
Below is the modification you need to make MyCC work with Qt 3.04!
+++ mycc/src/CSqlEditor/syntaxhighliter_sql.cpp
@@ +125 @@
SyntaxHighlighter_SQL::SyntaxHighlighter_SQL()
: QTextPreProcessor(), lastFormat( 0 ),
We've been seeing this quite often at our web application company.
The development machines run debian linux with kernel 2.4.x (they differ)
and ReiserFS, and on local installations of the web app, which puts DB, web
server, and CGIs on the same box, we see frequent table corruption.
Sometimes
Hi!
Jeremy == Jeremy Zawodny [EMAIL PROTECTED] writes:
Jeremy On Fri, May 17, 2002 at 11:41:49AM +0300, Michael Widenius wrote:
Jeremy [snip]
cut
Jeremy That reminds me. A while back (9 months, maybe), I seem to remember
Jeremy you discussion a re-write of the key cache so that it would
On Tuesday 21 May 2002 12:24 am, Jeremy Zawodny wrote:
On Mon, May 20, 2002 at 12:25:26PM -0400, walt wrote:
Does anyone know where rollbacks are stored for innodb tables? I
assume memory since I keep getting a table full error when trying to
drop an index. sql,query
I'm not exactly
Hello!
I have a strange problem with mysqladmin on Solaris 8.
I can't seem to shut down the server via mysqladmin -uroot -p shutdown. It
just... well... sits there. Hitting ctrl-c gives
bash-2.03$ mysqladmin shutdown
^CWarning; Aborted waiting on pid file: '/opt/db/simon.pid' after 121
Stavros Patiniotis wrote:
Hello,
My hard drive has just failed on my database server, and I have rebuilt it
and copied the data from backups back on to the drive, however mySQL
cannot see all of the databases.
A 'show databases' shows all of the databases, however 'use DBNAME' says
ERROR
At 01:22 AM 5/19/2002, you wrote:
Dear all,
I have some large MySQL tables and II want to delete for example month
2-2002
entirelly from an sql table.
I use now ...
delete from table_name where year(data)=2002 and month(data)=2;
I have almost 25.000.000 row and something like 7-8 mil is from
Hello,
I'm not sure if my previous post made it to the list, but it seems that
mysql no longer accepts '.' in database names.
I merely changed the . with _ and the missing databases came alive :)
Kind Regards,
0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0o0
Any suggestions on how to load images from a web site into a MySQL db? I would like
to set up a page that allows you to select an image from the local machine and load
it to my MySQL DB on my web server.
I'm not sure if it would just be a regular insert statement or something else?
Hi.
On Tue, May 21, 2002 at 02:14:26PM +0300, [EMAIL PROTECTED] wrote:
This bug was fixed interim, as it is no longer present in 4.0.2 nor in
3.23.51.
Ah. Okay. Thanks for testing.
This must be this change from 3.23.49, I guess:
Hi.
Just a little addition to the original e-mail: you want to try
SHOW TABLE STATUS
Bye,
Benjamin.
On Mon, May 20, 2002 at 10:08:13PM -0700, [EMAIL PROTECTED] wrote:
On Sun, May 19, 2002 at 06:26:54AM -0700, Henry Hank wrote:
Hello All,
I recently moved my database
Hoa,
Tuesday, May 21, 2002, 6:33:46 AM, you wrote:
HD Please don't kill me. I want to learn about databases. I hear MySQL is a
HD good start. I have RedHat Linux and I've download and (I believe) installed
HD mysql.
HD Okay, my questions are? What is the difference between the mysql
Alex,
Tuesday, May 21, 2002, 3:43:16 PM, you wrote:
AP I was wondering if anyone knew the proper way to restart MySQL on OS X?
AP I did mysqladmin -p shutdown then safe_mysqld...is this the same as
AP if the machine started up?
mysqladmin shutdown - takes down your MySQL server. Using
matt,
Sunday, May 19, 2002, 6:14:17 PM, you wrote:
m Description:
m mysql describe DLSummary;
m ++--+--+-+-+---+
m | Field | Type | Null | Key | Default | Extra |
m ++--+--+-+-+---+
Benjamin,
Monday, May 20, 2002, 9:21:02 PM, you wrote:
BP On Mon, May 20, 2002 at 07:28:01PM +0300, [EMAIL PROTECTED] wrote:
BP [...]
II select
II o.orderid,
II o.shipping_date,
II o.cancel_date
II from orders o, member u
II where o.userid = u.userid;
BP [...]
II the results of the last
Simon,
Monday, May 20, 2002, 7:24:28 PM, you wrote:
SKC I'm running mysql-3.23.36-sun-solaris2.7-sparc.
SKC And yes, I'm pretty sure that the server is installed. I can still
SKC query the database using a DBI script and get results back.
SKC My mysqld is in /usr/local/mysql/bin
SKC When I try
Frank,
Tuesday, May 21, 2002, 12:56:38 PM, you wrote:
FS How can one evaluation the security of a MySQL installation and what are
FS the steps that should be taken to secure an installation from the ground
FS up.
What did you mean security of a MySQL installation? Access to the
MySQL server or
Federico,
Monday, May 20, 2002, 6:57:28 PM, you wrote:
FC I'm testing MySQL Client on Win98, my Server on Suse Linux 7.0.
FC 1- I select database test
2-Commands--tables--Choose Tables, I choose f0001, I can see info Found 3
FC columns in 1 tables
3-Commands--Tables--Edit Tables here nothing
Bertrand,
Tuesday, May 21, 2002, 4:15:37 PM, you wrote:
BT I have a MySQL database with a table named CONNEXION. When i'm trying to do
BT something with the specific table, i have the following error:
BT ERROR1016:Can't open file: 'CONNEXION.MYD'. (errno: 145)
BT Please can anybody help me?
Given your query, you would access it like:
$avgField = $avg-fields['avg(fieldname)'];
You can also change your query to use an alias like:
select avg(fieldname) as theAvg from tablename
HTH,
Scott
-Original Message-
From: bobbie bob [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 21,
Thanks, i had check and had already solve the problem.
Gurhan Ozen [EMAIL PROTECTED] a dit :
Use perror program to see what the error code means..
perror 145
Error code 145: Unknown error 145
145 = Table was marked as crashed and should be repaired
Repair your table..
see:
I was wondering if any one could help me with a about writing UDF's for
mysql.
If I reallocate more memory for the result string;
ie
char *myResult;
myResult = (char *) calloc(1, resultSize);
*res_length = (ulong) resultSize;
return myResult;
Do I have to free it anywhere - and if so where?
Hello,
I have built an application that connects to a mysql
database located on a remote server in our LAN.
When running the application locally on the server and
I open the main window (it as several forms and does a
lot of queries to fill the fields, etc.) it takes
about 2 to 3 seconds
Hi Monty,
Michael Widenius wrote:
Hi!
Jeremy commit that affected the key cache yet.
Sanja has been trying to do improvements to the key cache code, but we
are still not satisfied with this. He just went back to the sub
select code, so we can't just now give a definite answer when we
Do you mean, a character client for windows or the linux client?
On linux I can do everything, delete, alter, insert, create,
but I don't think that is going to solve my problem on windows.
- Original Message -
From: Andrei Cojocaru [EMAIL PROTECTED]
To: Federico Coco [EMAIL
Hi,
I have an application in Java that access MySQL
databases through JDBC. The issue is that I have to be
able to move the database files across different
platforms (Windows, UNIX-Solaris, UNIX-IBM, UNIX-HP).
If I go to the manual, MySQL says that the database
files are compatible between
There is a function called Load_File which will cause the mysqld to read the
file into a field. It is designed for such things.
Check out http://www.mysqldeveloper.com/faqs/index.pcgi?id=7 for more
information.
Keep in mind that generally it is better to use the file system to store
files and
I am getting lots of emails sent to me for your address. Either you
have a virus or you need to contact your hosting company
Larry Thrall
2924 1/2 Main Street
Santa Monica, CA 90405
t. 310.314.5126
f. 310.450.0143
-Original Message-
From: Gav Brown [mailto:[EMAIL PROTECTED]]
Sent:
I can't seem to properly wrap my brain around left joins. If anyone
knows of a good tutorial somewhere, I'd appreciate it. That having been
said, I was hoping someone could help with this query I'm trying to do
as I've been horribly unsuccessful.
3 tables: goal (own goals), goalopp (opponent
Hi,
Look at mysqld.log and tell us what errors are.
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
- Original Message -
From: Avalon
On UNIX and Linux machines, there are a few places that MySQL will look for
your my.cnf.
The are detailed at: http://www.mysql.com/doc/O/p/Option_files.html
However if none of these files exist, then MySQL will use the default values
assigned for all neccesary settings. You can then just create
Amy,
Tuesday, May 21, 2002, 5:25:10 PM, you wrote:
I read the MySQL manual on how to set passwords but i'm a little confused.
How can i remove privileges so that you cant log on anonymously?
Anonymous user - a user that is defined as '' (empty string) in table
user.
So, if you want to
Hi,
I have an application in Java that access MySQL
databases through JDBC. The issue is that I have to be
able to move the database files across different
platforms (Windows, UNIX-Solaris, UNIX-IBM, UNIX-HP).
If I go to the manual, MySQL says that the database
files are compatible between
Andrei,
how many rows in ne satisfy
(1) ne.playerid=28575,
(2) ne.type=2?
What version you are using? .48 was tuned to favor index searches over table
scans.
What does EXPLAIN SELECT say if you force the index usage with USE INDEX and
STRAIGHT JOIN clauses?
Best regards,
Heikki Tuuri
Greetings,
We got the following lines in our error logfile on one of our slave servers:
020521 13:19:29 Error reading packet from server: Lost connection to MySQL
server during query (read_errno 0,server_errno=2013)
020521 13:19:29 Slave: Failed reading log event, reconnecting to retry, log
You have to create it yourself.
The base mysql install comes with example .cnf files ( 3 I think )
-Original Message-
From: Amy Zediak [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 21, 2002 1:12 PM
To: [EMAIL PROTECTED]
Subject: my.cnf
According to the MySQL manual, the my.cnf option
On Tuesday 21 May 2002 10:54 am, Info_Best-IT wrote:
Any suggestions on how to load images from a web site into a MySQL db? I
would like to set up a page that allows you to select an image from the
local machine and load it to my MySQL DB on my web server.
I'm not sure if it would just be a
Hi,
I have an application in Java that access MySQL
databases through JDBC. The issue is that I have to be
able to move the database files across different
platforms (Windows, UNIX-Solaris, UNIX-IBM, UNIX-HP).
If I go to the manual, MySQL says that the database
files are compatible between
Here is a query that will do what you want I think:
SELECT count(distinct goal.id) as ours, count(distinct goalopp.id) as
theirs, game.id
FROM game LEFT JOIN goalopp ON game.id=goalopp.game
LEFT JOIN goal ON game.id=goal.game
GROUP BY game.id
HAVING ours theirs;
We have to use
Hi,
I know, this might be the dumbest question MySql is Open Source
database, but I am not able from where to download the source code for
MySql. Please help me
Thanks
-
Before posting, please check:
How can I set up mysql so as if the id of an entry from table 1 is
inserted in table 2 it will not allow me to delete the information in
table 1?
EX:
table1 holds the description of the products (table1_id is the primary
key of the table);
table2 holds the information about all the purchased
On Tue, 21 May 2002, Mugdha Kulkarni wrote:
Hi,
I know, this might be the dumbest question MySql is Open Source
database, but I am not able from where to download the source code for
MySql. Please help me
Thanks
Here ya go.
http://www.mysql.com/downloads/mysql.html
Look on
Hi,
I've been trying to install Msql-Mysql-modules-1.2216, but I'm getting the
following error:
After executing
#perl Makefile.PL (I've also tried INC=-I/usr/lib perl Makefile.PL)
.
.
.
Looks good
Note (probably harmless): No library found for -lgz
.
.
.
Then I type
#make
.
.
.
on 5/21/02 2:09 PM, Jim Philips at [EMAIL PROTECTED] wrote:
On Tuesday 21 May 2002 10:54 am, Info_Best-IT wrote:
Any suggestions on how to load images from a web site into a MySQL db? I
would like to set up a page that allows you to select an image from the
local machine and load it to my
SELECT ISBN,TITLE FROM tBooks
WHERE tBooks.ISBN=1876340436
AND MATCH (tBooks.TITLE) AGAINST (britannica)
++-+
| ISBN | TITLE |
++-+
| 1876340436 | 2000 Lonely Planet Calendar |
On Tue, 21 May 2002, Michael Widenius wrote:
Hi!
Michael == Michael B Venezia [EMAIL PROTECTED] writes:
Description:
Michael Possible Bug in UPDATE in MySQL 4.0.1
cut
Michael Attempting backtrace. You can use the following information to find out
Michael where mysqld died.
hi there ...
can some one point in the right direction .. other than the mysql manul for
mroe information on the INSERT SELECT statement whether or not it can
handle date inserted from a form on a web page...
Cheers
Peter
the only dumb question is the one that wasn't asked
I am using mysql 4.0.1-alpha on Linux 2.4.18, the info you requested is:
select count(*) from newsentries10 where playerid=28575 and type=2;
+--+
| count(*) |
+--+
| 4218 |
+--+
1 row in set (13.81 sec)
mysql select count(*) from newsentries10 where playerid=28575 and
Hi,
I am having two servers running Oracle and MySQL
database.
Views has been created for me in Oracle and I want to
import data from that Oracle table to my MySQL table.
I want a script like something main thing is I
want to import data from that Oracle database to MySQL
daily...like a
1 - 100 of 112 matches
Mail list logo