Hi All,
Just a quick question on whether I need both fields to be indexed.
The table is as below.. I'm wondering if I need to have these 2 fields ->
fa_id & serial_no
fa_id would be a 7 character int like "001", "002"
serial_no would be like "WMACK001", "WMACM121"
most o
I used mysql_real_escape_string() method to insert image file into
database. Now how do icheck whether it got stored in proper format
??
I used
SELECT * INTO OUTFILE F1 FROM IMGTABLE;
command , but i'm not able to see the image back in F1. How do i
retrieve the image in proper format??
__
Barry,
On Thu, Jul 24, 2003 at 11:22:28PM -0500, Barry Hayden wrote:
> I have to admit I am very much a newbie at MySQL in general (but I'm
> working on it).
>
> I have a fairly complex (for me) query that I am trying to complete
> using php. I can't get it to work, and I'm sure it's just in the
Hi Vikram,
ignore both previous posts. Both don't work as wanted. I just realized that
and I will come back to you after I created the tables and made it sure.
Sorry for the confusion.
Best regards
Nils Valentin
Tokyo/Japan
2003年 7月 25日 金曜日 14:42、Nils Valentin さんは書きました:
> Hi Vikram,
>
> just
Hi all,
Is there a way to update the record with maximum value in a table with
another value?
I am trying this:
mysql> update services set sfee = 1 where sfee = max(sfee);
Query OK, 0 rows affected (0.06 sec)
Rows matched: 0 Changed: 0 Warnings: 0
But it doesn't make any changes to the data.
Hi Vikram,
just read the post once more. I made a mistake. You want to delete the
clients with no branches you said, so the command should look like
mysql> delete from clients where cid = (select clients.cid from clients
left join branches using (cid) WHERE ISNULL(clients.cid);
Note that cid
Hi Vikram,
NULL is a special data type and requires special procedures.
Try this:
> mysql> delete from clients where cid = (select clients.cid from clients
> left join branches using (cid) WHERE ISNULL(bid);
Please make NO SPACE betwen ISNULL and (bid) as otherwise wit will give you
an syntax
hi ,
I installed MySQL-server-4.0.14-0.i386.rpm
MySQL-client-4.0.14-0.i386.rpm
when I give mysqladmin -u root
it is asking for password . The doc says that initially the password is
empty and we just need to press enter .
I read the mailing list posting but didnt find any clue
i didnt set any pas
I have to admit I am very much a newbie at MySQL in general (but I'm
working on it).
I have a fairly complex (for me) query that I am trying to complete
using php. I can't get it to work, and I'm sure it's just in the way I
am phrasing the MySQL part of this. The premise of this is a four
question
I would just add a few words to Nils' excellent reply:
In the most general sense, a foreign key is just a primary
key value that occurs outside of its native table (i.e. in
a "foreign" table, get it?) in order to point to the record
in its native table with that value as its primary key.
You c
Hi all,
I have the following two tables:
mysql> SELECT * FROM clients;
+-+-+
| cid | cname |
+-+-+
| 101 | JV Real Estate |
| 102 | ABC Talent Agency |
| 103 | DMW Trading
Hello,
I have been using Snitz forums on windows 2000 IIS5 and MySQL for the
DB. I have set up a test Microsoft Server 2003 IIS6, but I am having
problems with the setup. It is able to connect to the database and the
account I have set up has full rights to the db. The problem is the
setup.asp c
§A̦n! §Ú¨Ï¥Îlinux rehat 7.2 ¦w¸Ëmysql-3.23.43-1.scr.rpm®ÉÔ,¹B¦æ¥X²{¦pªþ¥óªº¿ù»~«H®§,
¤£ª¾§A̯à§_À°À°§Ú,ÁÂÁÂ!
P
§
jackliu
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com
Sounds like you want to give the DEBUG version a try ;-)
Best regards
Nils Valentin
Tokyo/Japan
2003年 7月 25日 金曜日 01:25、Miguel Perez さんは書きました:
> Hi:
>
> I have a question: does anyone know if exists a log in mysql to store only
> incorrect queries or queries that causes a code error in mysql.
>
Hi Eli,
The short answer is .. you create relationships between tables by creating
foreign keys and primary keys. However, you might not even need them ;-) - I
explain below.
Foreign keys and primary keys are used to create relations between tables.
Using them will bind you to some rules whic
I was hoping someone could tell me a way to increase the productivity of a
database server. It has nothing else installed other than the newest
production version of mysql and the default packages from FreeBSD.
Is there a toaster than can bring me up to speed.
Thanks.
--
MySQL General Mailing
Looks like you really want to be doing full-text searching:
http://www.mysql.com/doc/en/Fulltext_Search.html
As you are doing it now, your users will only get a hit if
they enter the target keywords in the same sequence they
are stored in.
--John
On Wednesday 23 July 2003 04:24 am, Ercan Yurt
Hi,
I read at MysQl.com about Explain SELECT, it says at then end of a paragraph to
optimize your query, using filesort or temporary, but I went to MySQL search engine no
luck on finding them, can someone explain me both type.
**What i'm doing, since I'm using mysql for a program***
**I execute
Heikki,
> I just tested this. You are probably using the query cache in 4.0. Then
> SELECT can return immediately without acquiring any locks.
Thank you very much. You are absolutly right.
> Of course, it can be discussed if the query cache, too, should respect
LOCK
> TABLES. I am forwarding thi
You will need to run multiple mysqld servers on the slave.
Reason: a slave can have only one master (although it wouldn't be
technically difficult to change this, if a matrix struct was used).
How to run multiple slaves:
I have some code I'm adding to mysqld_multi, but you should use the
document
Mikhail,
I just tested this. You are probably using the query cache in 4.0. Then
SELECT can return immediately without acquiring any locks.
Of course, it can be discussed if the query cache, too, should respect LOCK
TABLES. I am forwarding this to Sanja.
Thank you,
Heikki
- Original Messag
Joe,
- Original Message -
From: "Joe Shear" <[EMAIL PROTECTED]>
To: "Heikki Tuuri" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, July 24, 2003 11:33 PM
Subject: Re: mysql stops processing
> We do not use LOCK TABLES anywhere. Are there any other commands that
> could caus
Yep, saw that and did just as you stated :)
> Nick, As you stated, your priority field datatype is "varchar", with
> possible
> values "Hi", "Medium" and "Low", as opposed to being integers. The use of
> max
> function, as suggested by some colleagues without knowing exactly the
> datatype
> woul
Hi guys, I need your help with this:
I have two big databases in two different servers, each database
it's different too and I need to replicate each one to a single
mysql slave server.
I need this:
MasterA ---> SlaveC <-- MasterB
So, I need dbA and dbB replicated on the slave server C
Nick, As you stated, your priority field datatype is "varchar", with possible
values "Hi", "Medium" and "Low", as opposed to being integers. The use of max
function, as suggested by some colleagues without knowing exactly the datatype
would work correctly only on columns of datatype integer. In yo
Use UNIX_TIMESTAMP or TIME_TO_SEC
-->-Original Message-
-->From: C.F. Scheidecker Antunes [mailto:[EMAIL PROTECTED]
-->Sent: Thursday, July 24, 2003 1:43 PM
-->Cc: 'MySQL Users'
-->Subject: Function to extract difference in Minutes from DateTime
-->variables
-->
-->Hello all,
-->
-->I need
That works great. =D
Knew it shouldn't be that difficult, thanks a bunch.
And it actually works with the Priorities being in text form to (low, med,
hi).
-Nick
> At 02:52 PM 7/24/2003, you wrote:
>>After some searching around different books/manuals/google I still can't
>>seem to figure out how d
Try:
select task, resource, department, max(priority)
from table
group by task, resource, department
Regards,
Ulises
-Mensaje original-
De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Enviado el: Jueves 24 de Julio de 2003 02:53 PM
Para: [EMAIL PROTECTED]
Asunto: SQL Help...
After som
I looked at the group by option already and I dont think it will do what I
need it to do. I say this because it will only group things in the
priority/task/whatever but that still leaves options for duplicate
resources. Yes, it would get rid of the dup. resources per priority, but
not for the entir
Hello all,
I need to compare a datetime field in my database with the current time
and return only the records that are 5 minutes old or older. Is there
any way to do it? Any function to it?
I use to_days() when I am doing the same thing but with days instead of
minutes.
Thanks in advance.
We do not use LOCK TABLES anywhere. Are there any other commands that
could cause a LOCK TABLES to occur? It's possible that we have some
process that is opening up two threads and processing on both. We
definitely didn't intend to if it is happening. What exactly would be
the case that would c
-Original Message-
From: Jason Joines [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 24, 2003 1:53 PM
To: MySQL Users
Subject: select part of a field into another field
I have a table with an email field that contains values of the form
[EMAIL PROTECTED] I need to populate a new field
At 02:52 PM 7/24/2003, you wrote:
After some searching around different books/manuals/google I still can't
seem to figure out how do to this. What I have is a table with 4 cols
(task, resource, department, priority) and what I want to do is be able to
select distinct resources and list what their h
-->-Original Message-
-->From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
-->Sent: Thursday, July 24, 2003 12:53 PM
-->To: [EMAIL PROTECTED]
-->Subject: SQL Help...
-->
-->After some searching around different books/manuals/google I still
can't
-->seem to figure out how do to this. What
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: amg
To: [EMAIL PROTECTED]
Subject: [Command in the Tutorial generates error msg]
>Description:
LOAD DATA LOCAL INFIL
After some searching around different books/manuals/google I still can't
seem to figure out how do to this. What I have is a table with 4 cols
(task, resource, department, priority) and what I want to do is be able to
select distinct resources and list what their highest priority is.
In other words
Joe,
are you using LOCK TABLES? Or does your application program open two
connections to MySQL and work based on the results from 2 connections?
"
---TRANSACTION 0 221806686, ACTIVE 925 sec, OS thread id 163881
2 lock struct(s), heap size 320, undo log entries 1
MySQL thread id 31, query id 910 p
On Wed, 2003-07-23 at 15:27, Andrew Braithwaite wrote:
> >>Power problems are handled by our colo facility, we want to quickly
> restore for most hardware problems (disk/machine failures).
>
> Just have multiple inexpensive fully replicated servers with failover built
> into the application layer
Jason Joines <[EMAIL PROTECTED]> wrote:
> I have a table with an email field that contains values of the form
> [EMAIL PROTECTED] I need to populate a new field called uid with just the uid
> part of the email address. Is there any way of using select to just
> retrieve the part before the @
Jason Joines wrote:
I have a table with an email field that contains values of the form
[EMAIL PROTECTED] I need to populate a new field called uid with just the
uid part of the email address. Is there any way of using select to
just retrieve the part before the @ and insert it into the uid
Its easier to do it code in my opinion but here is the function you will
need.
SUBSTRING_INDEX('[EMAIL PROTECTED]','@',1) --> joines
-->-Original Message-
-->From: Jason Joines [mailto:[EMAIL PROTECTED]
-->Sent: Thursday, July 24, 2003 10:53 AM
-->To: MySQL Users
-->Subject: select part o
Jason,
For example, if you had a table named "test" with a column named "a", which contained
one row "[EMAIL PROTECTED]" you would do a query like:
mysql> select substring(a,1,instr(a,'@')-1) from test;
+---+
| substring(a,1,instr(a,'@')-1) |
+--
-->-Original Message-
-->From: Mysql List [mailto:[EMAIL PROTECTED]
-->Sent: Thursday, July 24, 2003 10:47 AM
-->To: Dathan Vance Pattishall
-->Cc: [EMAIL PROTECTED]
-->Subject: Re: Huge Server configuration
-->
-->Dathan Vance Pattishall wrote:
-->
-->Only for read with lots of filtering
I have a table with an email field that contains values of the form
[EMAIL PROTECTED] I need to populate a new field called uid with just the uid
part of the email address. Is there any way of using select to just
retrieve the part before the @ and insert it into the uid field?
Thanks,
Jaso
Dathan Vance Pattishall wrote:
RAID-5 is cool, RAID-1+0 (10) is better for writes.
Your defiantly are going to be IO bound. I would go with many smaller
disks >= 20 disk, in multiple RAID-1+0 configurations on different
channels or better yet different RAID controllers.
Well I do not have the l
BEGIN my.cnf
[mysqld]
port = 3306
socket= /tmp/mysql.sock
basedir = /usr/local/mysql
log = /var/log/mysql/mysql.log
log-slow-queries = /var/log/mysql/mysql-slow.log
log-err = /var/log/mysql/mysql.err
log-bi
Hi,
Can anyone explain me how to create relationships between tables in Mysql?
For making some kind of functions like joins, it is indispensable to have
relationships defined?
Thanks in advanced.
eli
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubsc
RAID-5 is cool, RAID-1+0 (10) is better for writes.
Your defiantly are going to be IO bound. I would go with many smaller
disks >= 20 disk, in multiple RAID-1+0 configurations on different
channels or better yet different RAID controllers.
Reason by example:
Sun T3 with 7 drives. I'm IO bound with
Dathan Vance Pattishall wrote:
NICE
No matter how big your disks are, the number of spindles and throughput
is your win.
I have RAID 5 with 5 hardisks, so usuable number of spindle will only be 4.
my.cnf 3.5x options
skip-locking
skip-name-resolve
set-variable = tmp_table_size=4096
log-bin=b
Christopher Knight wrote:
what table types? Innodb.etc...
It is mainly innodb.
about how many tables?
there are around 200 tables
do you do alot of sorting?
Lots of sorting and fltering is done
are the exact same queries repeated alot?
Not likely
is the machine doing anything else or is ma
* Chuck Barnett
> Hi I'm looking to create a query that will look through my previous orders
> and create a table of what items have sold with what products.
>
> My current table that holds the order details is set up like this.
> orderID, productID, quantity.
>
> Any suggestions would be appreceia
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Michael Masse wrote:
> In the later part of June a new Linux Mysql server was installed.
> While mysqld was still running, the data folder was moved to a different
> volume and a soft link to the new location was put in it's place. I
> know, bad ide
what table types? Innodb.etc...
about how many tables?
do you do alot of sorting?
are the exact same queries repeated alot?
is the machine doing anything else or is mainly a DB server?
can I borrow the machine for awhile?
what version of mysql are you running?
chris
-Original Message-
Fr
NICE
No matter how big your disks are, the number of spindles and throughput
is your win.
my.cnf 3.5x options
skip-locking
skip-name-resolve
set-variable = tmp_table_size=4096
log-bin=binlog/something make sure binlog is a symlink to a separate
partition / drive
set-variable = key_buffer=4G
s
Hello all,
I have a server like 8way Intel Pentium 4 Xeon processor with 12GB RAM
and 1TB harddisk space.
All the tables size are over 10GB and they have over 100mm records.
Could some one help me get an appropriate mysql configuration(my.conf)
file for the machine.
I understand ther are lots
At 11:25 -0500 7/24/03, Miguel Perez wrote:
Hi:
I have a question: does anyone know if exists a log in mysql to
store only incorrect queries or queries that causes a code error in
mysql.
There is no such log.
--
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL AB, www.mysql.co
I use an extraction layer between mysql and the application/db calls to
handle this.. typically it's only enabled in development to work out any bugs..
Might want to look at something like that..
On Thu, 24 Jul 2003, Miguel Perez wrote:
> Hi:
>
> I have a question: does anyone know if exists a lo
Hi:
I have a question: does anyone know if exists a log in mysql to store only
incorrect queries or queries that causes a code error in mysql.
Greetings and thnx in advanced.
_
MSN. Más Útil Cada Día http://www.msn.es/intmap/
--
M
[snip]
Hi I'm looking to create a query that will look through my previous
orders
and create a table of what items have sold with what products.
My current table that holds the order details is set up like this.
orderID, productID, quantity.
Any suggestions would be appreceiated.
[/snip]
You wou
At 11:14 -0400 7/24/03, Jeff McKeon wrote:
Is there a way to issue a "REPAIR TABLE table_name" command to all
tables at once? Something like "REPAIR TABLE *"
If you have access to the mysqlcheck command-line program, you can
accomplish that with this command:
mysqlcheck --repair db_name
Thanks,
At 11:02 -0500 7/24/03, Chuck Barnett wrote:
Hi I'm looking to create a query that will look through my previous orders
and create a table of what items have sold with what products.
My current table that holds the order details is set up like this.
orderID, productID, quantity.
I see an order ID a
Hi I'm looking to create a query that will look through my previous orders
and create a table of what items have sold with what products.
My current table that holds the order details is set up like this.
orderID, productID, quantity.
Any suggestions would be appreceiated.
Thanks,
Chuck
--
My
Hi all,
There is a limitation on Win98 when a client app using mm.mysql driver doing
extensive queries to MySQL 3.23.x frequently encounters a connection lost
error.
Error msg is something like:
'java.lang.Exception: Cannot connect to MySQL server on localhost:3306. Is
there a MySQL server runnin
I'm running as normal user (not root or database owner). This user has create
temporary table priv.
show tables partial:
GRANT CREATE TEMPORARY TABLES ON `foobar0`.* TO 'foo'@'localhost' -> (foobar0
and foo are masks for the database name and user, respectively)
I created two tmp tables with i
Successfully removed the services. I rechecked and, no mysqld, just
MySQL and mysqld2. Thanks!
That should close out this thread!
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 24, 2003 11:30 AM
To: Degan, George E, JR, MGSVC; Stefan Hinz
Cc: [EMAIL
It may or may not help, but if you connect to the database using
MySQLCC, you can highlight all the tables and repair, optimise or check
in one go (in the Windows version at least!).
Gary
-Original Message-
From: Jeff McKeon [mailto:[EMAIL PROTECTED]
Sent: 24 July 2003 16:15
To: MySQL LI
At 6:23 -0500 7/24/03, Degan, George E, JR, MGSVC wrote:
(I think I messed up here. I decided to start from scratch, I removed
"MySQL Servers and Clients 4.0.13" from the program list (as it appears
when I run the "setup.exe" it installs MySQL software in Windows) and
deleted all the folders (whi
mazur <[EMAIL PROTECTED]> wrote:
> Anyone know if there is a way to defeat the new format for the
> timestamp that appears in 4.1 alpha?
>
> I upgraded a MySQL install on a development box that holds a copy of
> our production data. I quickly saw that the timestamp format was
> changed from:
>
>
On Thu, Jul 24, 2003 at 11:14:51AM -0400, Jeff McKeon wrote:
> Is there a way to issue a "REPAIR TABLE table_name" command to all
> tables at once? Something like "REPAIR TABLE *"
No.
However, you could use myisamchk with the server off-line. Then you'd
be able to script it and/or use shell wil
[EMAIL PROTECTED] wrote:
>
> I am very much familier with the replication in 3.x version of mysql. Now I
> am trying with the Innodb version of mysql 4.0.13. The show slave status of
> this version is giving some new fieldswhat is actually Relay_Log_File.
> what is the use of this...
You can
Is there a way to issue a "REPAIR TABLE table_name" command to all
tables at once? Something like "REPAIR TABLE *"
Thanks,
Jeff McKeon
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I think you're going to have trouble doing this with .asp. I know it can be
done with Perl or PHP, so you might want to look into those programming
languages. MySQL won't do it automatically.
Thanks to everyone who Helped,
Regards
Marty
- Original Message -
From: "Joseph Bueno" <[EMAIL PROTECTED]>
To: "Martin Moss" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, July 24, 2003 3:56 PM
Subject: Re: New Group By, order by question
> select order by abs(field)
At 12:20 +1000 7/23/03, Daniel Kasak wrote:
Paul DuBois wrote:
At 10:46 +1000 7/23/03, Daniel Kasak wrote:
Hi all.
I need to test whether the first bit of a field is numeric.
For example, the field might contain:
154 boxes
Define this more precisely. Is an acceptable match one or more
digits
select order by abs(field) desc;
Hope this helps,
Joseph Bueno
Martin Moss wrote:
All,
I have a question about grouping numbers.
Lets say I have 10 records each containing a numeric value:-
1
2
3
5
10
-1
-2
-3
-4
-5
What I wish to do is to select the records from the database but group the
Anyone know if there is a way to defeat the new format for the
timestamp that appears in 4.1 alpha?
I upgraded a MySQL install on a development box that holds a copy of
our production data. I quickly saw that the timestamp format was
changed from:
20030520124559 , to:
2003-05-20 12:45:59
For
Hi Martin,
I understand the ABS() function is used for this.
Best regards
Nils Valentin
Tokyo/Japan
2003年 7月 24日 木曜日 23:42、Martin Moss さんは書きました:
> All,
>
> I have a question about grouping numbers.
>
> Lets say I have 10 records each containing a numeric value:-
>
> 1
> 2
> 3
> 5
> 10
> -1
> -
With new HP ultrium tape drives, you can get 200GB/hr transfer rate. I
kind of hate tapes (just like everybody else), but tapes have really
improved in the past few years. These things are under $6k and could
back up 1-2 TB overnight without much problem. With a library
(MSL6060), you can have 4
> If I run the script:
>
> -snip-
> datadir="/var/lib/mysql/telaurus/"
> find $datadir -name "*.MYI" -print | xargs myisamchk -r
> --silent --fast
> -snip-
>
> With the -r option on a live running db while connections are
> being made, could there be any consequences? Our production
> db is a
That did it! I tried disabling and rebooting and that didn't work, but I went into
the new folders and simply removed the services as indicated and they are now gone.
Thanks!!
George
-Original Message-
From: miguel solórzano [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 24, 2003 9:45
All,
I have a question about grouping numbers.
Lets say I have 10 records each containing a numeric value:-
1
2
3
5
10
-1
-2
-3
-4
-5
What I wish to do is to select the records from the database but group them
like this :-
e.g. by the highest value (ASC or DESC) regarldess of whether the value
Hope I could be of help.
Best regards
Nils Valentin
Tokyo/Japan
2003年 7月 24日 木曜日 22:51、Henrik Schmiediche さんは書きました:
> Thanks for the help!
>
> - Henrik
>
>
> -Original Message-
> From: Nils Valentin [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, July 23, 2003 10:19 PM
> To: Henrik Schm
Hi Group,
I am very much familier with the replication in 3.x version of mysql. Now I
am trying with the Innodb version of mysql 4.0.13. The show slave status of
this version is giving some new fieldswhat is actually Relay_Log_File.
what is the use of this...
regds,
--
MySQL General Mai
On Thu, 2003-07-24 at 11:58, mixo wrote:
> How can I write this query so it works on mysql 3.54:
>
> select groupmembers.memberid,users.name from groupmembers,users where
> (not users.name='root')
> and groupmembers.groupid=(select groups.id from
> grou
YesThe replication stopped in the next 60 secs.
I've tried to change connect-retry to 30 secs without result.
:-/
Max
-Messaggio originale-
Da: Dominicus Donny [mailto:[EMAIL PROTECTED]
Inviato: giovedì 24 luglio 2003 11.36
A: [EMAIL PROTECTED]
Oggetto: Re: Replication stopped w
If I run the script:
-snip-
datadir="/var/lib/mysql/telaurus/"
find $datadir -name "*.MYI" -print | xargs myisamchk -r --silent --fast
-snip-
With the -r option on a live running db while connections are being
made, could there be any consequences? Our production db is a bear to
bring down becau
Hi
Many thanks to one and all for your time and assistance with my
question. I used the 'AS cnt' method and it works brilliantly. Simple
isn't it? :-)
Cheers
Gary
-Original Message-
From: Victoria Reznichenko [mailto:[EMAIL PROTECTED]
Sent: 24 July 2003 14:01
To: [EMAIL PROTECTED]
Subj
Thank you. Changing it to:
$max_esn = mysql_result($max_esn_result,$i);
did the trick.
sa
-Original Message-
From: Jennifer Goodie [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 23, 2003 6:33 PM
To: Susan Ator; [EMAIL PROTECTED]
Subject: RE: Why is this query not working?
> I
I have recently set up mySQL on a Mandrake release of Linux (Version 7 of
Mandrake, I believe), using the binary 4.0.13 standard release.
The set up and start up all were normal, as far as I could tell, with no
warnings or error messages.
In nearly all respects, the database appears to be running
At 14:47 24/7/2003 +0200, Stefan Hinz wrote:
Hi,
> (I think I messed up here. I decided to start from scratch, I removed
> "MySQL Servers and Clients 4.0.13" from the program list (as it appears
> when I run the "setup.exe" it installs MySQL software in Windows) and
> deleted all the folders (whic
Shutdown mysqld before running myisamcheck,
or use check/repair table.
Jeff McKeon wrote:
Hello,
When I run a script to issue myismchk against the tables in my database,
I get the following..
[EMAIL PROTECTED] scripts]# ./check_mysql_tables
myisamchk: MyISAM file /var/lib/mysql/telaurus/Admin.MYI
Degan,
> On Windows 2000, you can open the Services Manager window as follows:
Start >> Settings > Control Panel > Administration > Services
> In that window you see a list of Windows services, and you should find
> two MySQL-related services running.
> (I think I messed up here. I decided to
"Gary Broughton" <[EMAIL PROTECTED]> wrote:
>
> I wonder if someone could help with what I assume is a simple query
> using GROUP and/or ORDER statements (something I struggle to get to
> grips with). I am trying to get a list of users who have posted to a
> forum by number of posts descending, b
try this:
order by 1 desc
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hello,
When I run a script to issue myismchk against the tables in my database,
I get the following..
[EMAIL PROTECTED] scripts]# ./check_mysql_tables
myisamchk: MyISAM file /var/lib/mysql/telaurus/Admin.MYI
myisamchk: warning: 1 clients is using or hasn't closed the table
properly
MyISAM-table '
Hi
I have 2 MySQL servers:
Server1 is 3.23.55-max-log
Server2 is 4.0.13-standard-log
Let's assume that we have 2 connections (Conn1 and Conn2) and table test:
CREATE TABLE `test` (
`id` int(3) NOT NULL auto_increment,
`name` char(
Does the user you wish to run mysqld as have owner read write to
/var/lib/mysql and its sub directories?
(if you are not sure what I mean, can we see your my.cnf file
and do a 'ls -la /var/lib/mysql')
Matthew
-Original Message-
From: antoine druon [mailto:[EMAIL PROTECTED]
Sent: 24 July
I try to install mysql 3.23 on mandrake 9.0 but I have somme problems
first I have this problem /usr/share/rpm-helper/add-service: line 27:
[: : integer expression expected a the end of install
i saw for mandrake 9.1 a patch so i modified my add-service in rpm-
helper
but after that a the end of
Hi
I wonder if someone could help with what I assume is a simple query
using GROUP and/or ORDER statements (something I struggle to get to
grips with). I am trying to get a list of users who have posted to a
forum by number of posts descending, but am unable to find the right
statement to do i
-Original Message-
From: Stefan Hinz [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 23, 2003 5:15 PM
To: Degan, George E, JR, MGSVC
Cc: Paul DuBois; [EMAIL PROTECTED]
Subject: Re[2]: Can run two versions of MySQL in Windows 2000?
Degan,
jumping in to try and solve some problems that l
1 - 100 of 115 matches
Mail list logo