Hi, i was just wondering... i have inserted 1 row on my table,
how come when i did lock table. Mysql did not see one of my insert.
Please check mail below, thanks.
mysql> select * from louie2;
++---+
| id | firstname |
++---+
| 1 | louie |
++---+
1 row in
Hi,
I have a scenario..
I lock this mysql table and then a query/insert came in one of my script's.
the table is locked, what will happen to that query?
Will it retry again to insert on that table or no, it will not.
ty,
louie...
--
Thats right...
But I don't want all id's with nr=123 or nr=456.
I want all id's with nr=123 and nr=456 and only these id's.
For Example:
id nr
---
1123
1 456
1 678
2 457
2 897
2 123
3 123
3 678
3 456
Id 1 and id 3 have only both numbers.
If I
David,
did you upgrade from a very old version of MySQL to .49? The sorting order
of latin1 accent characters was changed about 8 months ago, and that may
cause the assertion you have encountered. You should dump and reimport your
tables if you have accent characters.
Anyway, the B-tree index is
OK!
You can use SELECT DISTINCT:
SELECT DISTINCT id
FROM Table
WHERE nr=123
OR nr=456
this gives you all uniqe id's with nr = 123 OR nr = 456 and that is id = 1.
//
Jonny
> -Ursprungligt meddelande-
> Från: Spielberg Micha [SMTP:[EMAIL PROTECTED]]
> Skickat: den 22 maj 2
Hi, i was thingking about locking the tables first so no connection
could write so i can do myisamchk. Is this process safe?
Procedures:
1. lockdb
2. run myisamchk -r or -o
3. unlock db
Btw, mysqld is running. I want to off it but i can't its a production
server.
Hope anyone could give me more
hi list user ,
i am new to list and new to mysql
i gotta do a project of my company w=hci reqiure to extract data
from a server
the user in his browser reqest a graph .in the client m/c and
this requset goes to server where a java servelet has to accept
the request ..now what the servelet
I think my english ist too bad
My table looks like this
id nr
---
1 123
1 456
1 678
2 457
2 897
2 123
I want to select in a query only these id that have nr=123 and nr=456.
In the example its only id 1.
regards Micha
-Ursprüngliche Nachricht-
This is a simple SELECT statement:
SELECT id
FROM Table
WHERE nr=3D123
AND id = 3D456
this gives you probably one record, or you could use OR:
SELECT id
FROM Table
WHERE nr=3D123
OR id = 3D456
this gives you all records with nr 3D123 OR id 3D456
//
Jonny
> -Ursprunglig
Hi,
i have a table like this:
Fields: id,nr
I want now a query like this:
SELECT id FROM Table WHERE nr=3D123 and (SELECT id FROM Table
WHERE nr=3D456).
Must i do this with a temp Table or ist there any other way to do this
with Joins?
I hope someone can help me..
regards Micha
Andrei,
this is probably not a bug in InnoDB. In theory, 4000 random disk seeks
would use more time than scanning the whole table of 700 000 rows.
The optimizer was tuned .48 (not yet in 4.0.1) to favor index searches over
table scans. That may solve the problem here.
On the other hand, the fac
Create a table like this:
CREATE TABLE itg_passwd (
Username char(20) NOT NULL default '',
Password char(20) NOT NULL default '',
PRIMARY KEY (Username),
KEY (Password(4))
) TYPE=MyISAM;
And insert some data;
insert into itg_passwd values('1','h1'), ('2','h2'), ('3','h1/a');
Then
I'm running MySQL 3.23.49. Everything was going good until today. I did
a couple of large table reads/inserts/deletes on the InnoDB tables which
appeared to go fine. I then restarted MySQL which also appeared to go
fine. From that point on, however, I kept losing connection with the DB,
and couldn
Yep, I'm a n00b, or whatever you want to call it.
I'm having a problem installing MySQL version 4.0.1-2 (or any other
version for that matter).
I'm starting a rather large project where our funds are limited and we
want a high performance database, so we chose to go with MySQL. Since
we need
Create a table like this:
CREATE TABLE itg_passwd (
Username char(20) NOT NULL default '',
Password char(20) NOT NULL default '',
PRIMARY KEY (Username),
KEY (Password(4))
) TYPE=MyISAM;
And insert some data;
insert into itg_passwd values('1','h1'), ('2','h2'), ('3','h1/a');
Then
This seems like a fairly straight forward and simple query, however you run
into the max row information problem as described in the manual at
http://www.mysql.com/doc/e/x/example-Maximum-column-group-row.html
Finding the first part is fairly easy and straight forward, it is just
getting the pri
I think I will describe the problem in detail.
I using Container-Managed Persistence (CMP) beans in
J2EE RI 1.3. I will like to specify the SQL for one
of the finder methods to be:
SELECT * FROM table1 WHERE ( ? )
This is to faciliate me manipulating the WHERE clause
b4 sending it as a strin
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
I have a simple SQL problem: I have two tables (two different log files):
tbl1
TimeStamp, Code, OrderType
...
10:22:01, , "N"
10:23:02, , "N"
10:23:19, , "N"
10:24:11, 1222, "N"
10:25:11, , "D"
10:27:33, , "N"
...
tbl2
TimeS
On Mon, May 20, 2002 at 04:13:36PM -0400, Rick Shifman wrote:
> My OS is Linux, running Apache. Do I have to go with Alpha
> architecture ? I need to keep 64Gb index in RAM to maintain quick
> response for web users. I heard of index clustering across multiple
> machines - is that an option ? T
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 sch
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 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"
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
>
>
>
> Michael> Attempting backtrace. You can use the following information to find out
> Michael
SELECT ISBN,TITLE FROM tBooks
WHERE tBooks.ISBN="1876340436"
AND MATCH (tBooks.TITLE) AGAINST ("britannica")
++-+
| ISBN | TITLE |
++-+
| 1876340436 | 2000 Lonely Planet Calendar |
+---
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 t
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
.
.
.
LD_RUN_PATH="/l
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
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 p
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:
http://www.mysq
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 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 comput
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
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 fi
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
'd
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
Innoba
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 comput
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
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 t
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" <[EM
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 g
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: Tues
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 th
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 comput
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" <[EM
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 whe
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 to
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?
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: h
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
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 m
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 no
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
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
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> th
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> ++--+--+-+-+
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 saf
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 se
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 data
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:
--
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?
Thanks..
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
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
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
>
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 gives
bash-2.03$ mysqladmin shutdown
^CWarning; Aborted waiting on pid file: '/opt/db/simon.pid' after 121 seconds
b
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 ex
Hi!
> "Jeremy" == Jeremy Zawodny <[EMAIL PROTECTED]> writes:
Jeremy> On Fri, May 17, 2002 at 11:41:49AM +0300, Michael Widenius wrote:
Jeremy> [snip]
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
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 it'
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 ), lastFor
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 [mailto:
> 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:
http://www.mysql
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: http://www.mysql.com/doc
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 witih
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
check that the file exists. also check that the user that mysql is running
as has the appropriate permissions to read/write that file. run the "perror"
command.
-Original Message-
From: Bertrand TACHAGO [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 21, 2002 09:16
To: [EMAIL PROTECTED]
Sub
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 did
[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
[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
---
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 containi
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 high
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
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 ma
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
--
Jay Blanchard wrote:
> [snip all kinds of stuff]
>$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
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 O
Hi!
> "Michael" == Michael B Venezia <[EMAIL PROTECTED]> writes:
>> Description:
Michael>Possible Bug in UPDATE in MySQL 4.0.1
Michael> Attempting backtrace. You can use the following information to find out
Michael> where mysqld died. If you see no messages after this, something
> 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
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 [E
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 I
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 PROT
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 old
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
registrar_contac
Hi!
> "Grigory" == Grigory Kolesov <[EMAIL PROTECTED]> writes:
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
Gri
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.
[EM
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 t
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
[snip all kinds of stuff]
I says that mysql_connect
Fatal error: Call to undefined function: mysql_connect()
in /var/www/html/rcmms/appl.php on line 5
[/snip]
Try...
Connections first, database selections next, then queries and results. If
you get an "undefined function" now there is no MyS
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
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 PROTE
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 configuri
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 m
1 - 100 of 111 matches
Mail list logo
