Hi Tom,
I don't think there is a straight way in Mysql to accomplish this. It
would have been great if Mysql included this provision.
I suggest you to use temporary tables. First make a temporary table
inserting values of job and the maximum date of inv for the job.
Create temporary table te
It would be beneficial to the group if everyone would post their solutions to the list
if they solve it on their own.
IMHO,
Mark
-Original Message-
From: Ken Kinder [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 16, 2001 10:10 AM
To: Walter D. Funk; [EMAIL PROTECTED]
Subject: Re:
I saw that someone posted a question about how to install MySQL under
Mac OS X. I found a great tutorial and I haven't had any problems yet,
4 weeks after I installed.
http://www.entropy.ch/software/macosx/
Good luck!
---
Daryl C. DuLong
http://daryldulong.com
--
Okay, I know you guys have been wracking your brains for the last two days
trying to solve my problem of mysqldump running out of memory while dumping
a large table.
I figured it out, so you can all go on with your lives.
My copy of Paul DuBois' MySQL book came today and immediately solved my
pr
can i do this?
content in field="aaa,bbb,ccc,hhh"
new content="aaa,bbb,ccc,hhh,fff"
can i append new word "fff" into the old field .by
use update command in 1 query :)
it's like
"UPDATE persondata SET age=age+1"
but i want to append new value into old field...
what should i do
hey, i'm having trouble installing MySQL-3.23.45-1.i386.rpm
already installed
MySQL-client-3.23.45-1.i386.rpm
MySQL-devel-3.23.45-1.i386.rpm
when i try to install MySQL-3.23.45-1.i386.rpm i get the following:
[root@localhost rpms]#rpm -U --force --replacefiles MySQL-3.23.45-1.i386.rpm
error: fa
[table]
Does TEXT have any significant disadvantages compared to VARCHAR? We need
to store a bit of text, but in some cases it can exceed 255 characters, so
we have to use TEXT.
I'm guessing that the only difference is that the length counter needs 2
bytes instead of 1 byte of space, right?
-
Check out MySQL Navigator at http://sql.kldp.org/mysql/ I use it almost
every day, and find it does everything I need in a GUI MySQL client.
j- k-
On Thursday 29 November 2001 03:02, Frank J. Schmuck wrote:
> I'm moving from Win2k to Linux and was wondering if there was a GIU MySQL
> f
$ man cron
sreedhar wrote:
> hi Thomas,
>
> Thanks for advice. My database is on LINUX. Can give bit details of cron.
> Even link regarding that also sufficient.
>
> thanks in advance.
>
> regards,
> sreedhar
> - Original Message -
> From: "Thomas Spahni" <[EMAIL PROTECTED]>
> To: "sreed
change timestamp to datetime.
have a look in the manual:
http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#DAT
ETIME
-Kim
-Original Message-
From: David Nagel [mailto:[EMAIL PROTECTED]]
Sent: 29. november 2001 21:01
To: [EMAIL PROTECTED]
Subject: Having trouble w
[table]
Is there a significant CPU consumption difference between this:
SELECT * FROM posts ORDER BY lastPostTime, id
compared to this:
SELECT * FROM posts ORDER BY lastPostTime
My gut feeling tells me that they should almost take the same amount of
time to execute, because 'id' only needs to
In message <[EMAIL PROTECTED]>,
Thomas Spahni <[EMAIL PROTECTED]> writes
>On Mon, 26 Nov 2001, Brent wrote:
>
>> A Select statement will display the TmeStamp as 2005095105. Now I ask
>> you, how many users will understand this format?
>> Why not display TimeStamp in the same format as DateTim
On Thu, 29 Nov 2001, Brian P. Austin wrote:
> The RPMS that are available from the MySQL WebSite are OK to use on 6.2.
> I personnaly prefer to use the source or .src RPMS.
>
> But the RPMS work fine on my 6.2 box.
But once the RPMs are installed you still need to rebuild php with mysql
support
On Thu, 29 Nov 2001, Graham Nichols wrote:
> 'category' can be made up as records such as:
>
> christmas|birthday|easter
> easter|thanksgiving
> birthday|christmas|thanksgiving|easter
The standard way to deal with this kind of problem is to create
a table modelling the event entity set and one
If I were you I would simply upgrade to Red Hat 7.1 or better 7.2.
It probably takes just as much time to install a whole distro
than having to worry about installing apache, then mysql, then
php, all over again, and most likely getting something wrong
and having to go back. Also there may be pro
On Thu, 29 Nov 2001, anandakkumar araskumar wrote:
> Hi all
> Iam new to php and iam learning that from scratch.I
> came across a problem in connecting mysql from php
> script.I run php in windows2000 under IIS configured
> to personal web server.I have installed mysql
> with server and client a
At 16:44 2001-11-29 +, you wrote:
>On Thursday 29 Nov 2001 16:18, Fabien R. wrote:
>
> > > I saw somewhere that this comparaison existed but I can't remember
> > > where.
> > > Does it talk to anyone ?
I am a 2 weeks old newbee
I did try interbase because it came with staroffice 5.2
never
hi Thomas,
Thanks for advice. My database is on LINUX. Can give bit details of cron.
Even link regarding that also sufficient.
thanks in advance.
regards,
sreedhar
- Original Message -
From: "Thomas Spahni" <[EMAIL PROTECTED]>
To: "sreedhar" <[EMAIL PROTECTED]>
Cc: "mysql" <[EMAIL PROTE
Oh, well, I didn't really have a solution. I just took it all out in seconds,
and did the math inside the application.
On Thursday 29 November 2001 01:12 pm, Mark Rissmann wrote:
> It would be beneficial to the group if everyone would post their solutions
> to the list if they solve it on their
I'm having a little trouble with an UPDATE statement in MySQL 3.23.39 on
Mac OS 10.0. The statement is:
UPDATE book SET book_deleted = 'Y' WHERE book_id = '123';
This statement updates the column that I specified and another as well. A
timestamp(14) column is changed to today's date as well.
He
Try installing by fink..
http://fink.sourceforge.net/
If you have worked on debian, you will appreciate it.
Regards,
Kundan
On 11/30/01 12:13 AM, "Kurt Tappe" <[EMAIL PROTECTED]> wrote:
> I'm stuck trying to figure out how to install this thing. What I've tried:
>
> * The download doesn't
Since Mac OS X is Unix it should use the same rules as a Unix machine
when it comes to MySQL and case sensitivity of table and database
names. According to Dubois: "DB and tables in MySQL correspond to
directories and files in the underlying file system on the server
host. As a result, case se
1-
What should I index?
Index is for speed.. Should I mainly index the columns where I do often
searches on them?
Should I index all not null columns event if I rarely search using them?
Should I index enum columns even if there is a lot of identical data.
Will a search using only indexed columns
Just one quick question... I've heard that running a database in a
system using RAID isn't a good idea on RAID 5, but works fine with
mirroring (0, 0/1, 0/5). Does anyone out there have experience with
MySQL on RAID 5, or know how MySQL performs in a RAID 5 environment? My
concern is loss o
Hi,
Can anyone point me, a humble C programmer, to a tutorial for setting up and
using JDBC and MySQL.
We are having the following problem, which boils down to libobdcinst.so.1
not being found - where can I find it?
SKYROAD#mercury1:/mercury/home/morgan/javatrial:java SimpleSelect
DriverManager
Hi, Philip,
Here is the query as you suggested:
SELECT ox.ensembl_id, x.dbprimary_id, x.display_id, db.db_name
FROM objectXref ox, Xref x, externalDB db
WHERE ox.ensembl_id IN ('7263', '7318', '8991', '17508')
AND x.xrefid = ox.xrefid
AND db.externalDBId = x.externalDBId;
>
> Maybe "WHERE ... I
Hi,
Upon closer examination of the query, it seems that both
ensembl_object_type, and xref_index does not have ensembl_id in the 1st
position for the index. So the hints would not work any way. I would still
appreciate if someone points out the syntax error I got.
Looking at the new schemaCore t
On Thursday 29 November 2001 04:02 am, Frank J. Schmuck wrote:
> I'm moving from Win2k to Linux and was wondering if there was a GIU MySQL
> front-end in Linux similar to Mascon or mysqlfront for the windoz Oss.
>
> Thanks
> Frank
MySQLNavigator is quite nice. Got a decent write-up in Linux Journ
Hello,
I have a page whoch should connect to a mysql database via odbc,
on a RH 7.2 PC with the relevant rpm listed below.
I know what to do when the db is reachable, but can't start:
the instruction:
$conn=odbc_connect("db9,"","");
just yelds this result:
Warning: SQL error: [unixODBC][Driver M
> Please please please take the time to look at this problem.
>
> I'm running MySQL 3.23.36 on FreeBSD 4.2. The only application that
> connects and manipulates MySQL is a single PHP application running on PHP
> 4.0.3.
>
> I've eliminated all the errors I can think of and tried to optimize all
>
I am getting the same error message "configure: error: cannot run test program while
cross compiling". I think this a simple
PATH issue where basic functions such as sprintf are not found. I was able to compile
mysql on solaris 7 without any problems
but having trouble compiling ANYTHING on so
Amen to that...
I would think file storage within a database other than the file system
would be a configuration control nightmare. Using links rather than
embedding files in a DB field allows the files to be maintained by their
owners without affecting the validity of or requiring revision to t
I was taught that when it comes to files, use the DBMS designed for files,
namely the file system.
A. Clausen [EMAIL PROTECTED]
- Original Message -
From: "Etienne Marcotte" <[EMAIL PROTECTED]>
To: "Venu Allavatam" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thurs
hum, I think it won't acheive his goal:)
Let's say you have this as data:
| id |date| whatever |
||
| 1 | 2001-11-26 | |
| 2 | 2001-11-27 | |
| 3 | 2001-11-25 | |
| 4 | 2001-11-27 | |
| 5 |
I store links instead of the data.
I don't know I seem to prefer a "light" database and the retreival of
images/others from the server itself instead of pulling it from the
database.
There are a lot of debates on this, I'm only telling you what I prefer
to use:)
Etienne
Venu Allavatam wrote:
>
Tom,
Restating the problem, you want the last two from the set ordered by
invoice date. So, add
ORDER BY site_service.invoice_date DESC
LIMIT 2;
Probably just a typo, but I note your statement selects site_service.id
and site.site_id but has site_service.site_id = site.id in the WHERE
clause.
Recommend that you store the link/url in lieu of the actual files.
cheers,
mikel
Venu Allavatam wrote:
>hello all!
>i have a question regarding the storage of data. The
>doubt is...
>Should the data (mostly binary files) be stored in the
>database as a field or a link(a path) to the data be
>st
hello all!
i have a question regarding the storage of data. The
doubt is...
Should the data (mostly binary files) be stored in the
database as a field or a link(a path) to the data be
stored.
i have read some of the pros and cons on both the
issues and am confused. what is the practice usually
a
At 10:33 AM -0800 11/29/01, Shankar Unni wrote:
>sherzodR wrote:
>
>>Well, Paul, i think he means using source in an .sql script.
>>Yes you can, Shankar. I used it several times for several reasons :)
>>
>>And u can envoke your sql script the same as you use your other
>>scripts.
>>
>>[EXAMPLE]
>>
sherzodR wrote:
> Well, Paul, i think he means using source in an .sql script.
> Yes you can, Shankar. I used it several times for several reasons :)
>
> And u can envoke your sql script the same as you use your other
> scripts.
>
> [EXAMPLE]
> [...]
> -- in source.sql file:
>
> source query.s
From: Thomas Spahni <[EMAIL PROTECTED]> 6:24 AM
Subject:
Re: MySQL 3.23 Manual - PDF
To: "A. Clausen" <[EMAIL PROTECTED]>
CC: MySQL Mailing List <[EMAIL PROTECTED]>
On Wed, 28 Nov 2001, A. Clausen wrote:
[deleted]
... and have a cup of coffee. You need the GNU TeX-info and pdftex
(available
Hi all,
I'm trying to have logs of mySQL activity, I read that I need the
option --log[=file] for
mysqld but I can't understand where I must add this argument. (in my.conf
?)
Thanks in advance,
Nicolas Beaumont
-
Befo
The files aren't owned by mysql.
Venu Allavatam wrote:
> Hello All:
> I am working on a particular database, which I created
> some days ago in mysql ver. 3.23.36. I am quite sure
> that I have not made any changes to the system (Dell
> WS with Red Hat Linux 7.1) either. What I see is
> this...
I'm trying to write a query that will limit the results but not by the total
amount returned like a normal LIMIT. It's an invoice database and I would
like to return the last to invoices for a certain job. So if there are 100
jobs with several invoice dates I would like to return a web page displa
Well there is a 4.x manual, and I know from a few months ago that there was
a 3.23 manual on the site which I foolishly decided I didn't need. Do the
developers of MySQL just delete all copies of manuals for previous version
when they move to new software? I mean, what is a 3 or 4mb file nowaday
Why are you sending email to me.
-Messaggio originale-
Da: Gordan Bobic [mailto:[EMAIL PROTECTED]]
Inviato: giovedì 29 novembre 2001 17.45
A: Fabien R.; [EMAIL PROTECTED]
Oggetto: Re: mySql vs Interbase
On Thursday 29 Nov 2001 16:18, Fabien R. wrote:
> > I saw somewhere that this compa
sorry Todd, i meant into my own users table that i have created.
- Original Message -
From: "Todd Williamsen" <[EMAIL PROTECTED]>
To: "'Anthony Evans'" <[EMAIL PROTECTED]>; "'MYSQL help'"
<[EMAIL PROTECTED]>
Sent: Thursday, November 29, 2001 5:12 PM
Subject: RE: PHP / MySQL username and
What do you mean accept new users?
Via adding new people to the MySQL user list or to a web application?
Please specify..
Thank you,
Todd Williamsen, MCSE
home: 847.265.4692
Cell: 847.867.9427
-Original Message-
From: Anthony Evans [mailto:[EMAIL PROTECTED]]
Sent: Thursday, Novembe
Hi,
I am trying to modify some ASP pages that (already) work with an Access
database so that they will work with mySQL database instead. (an example is
below)
I have been able to read data from mysql and the edit page SEEMS to work -
no errors from ASP - however the database is not updated.
My
I am going to take a stab at this...
Since MacOS X is actually an open sourced kernel, I would assume you
could use the Linux or Unix version to install it. I have not worked
with MacOS X, but if I remember correctly it had a command prompt.
Let me know if it works
Thank you,
Todd Williams
On Thursday 29 November 2001 23:50, Graham Nichols wrote:
> Hi,
>
> I have a table which contains a column 'category'
>
>
> 'category' can be made up as records such as:
>
> christmas|birthday|easter
> easter|thanksgiving
> birthday|christmas|thanksgiving|easter
>
> etc .
>
> As you can see,
> -Original Message-
> From: Cindy [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, November 28, 2001 5:49 PM
> To: MySQL List
> Subject: Re: Error on new connection socket: Invalid argument
>
>
>
> "Jeff Hinds" writes:
> >I have an application that is developed in perl using dbi and
> mys
On Thursday 29 Nov 2001 16:18, Fabien R. wrote:
> > I saw somewhere that this comparaison existed but I can't remember
> > where.
> > Does it talk to anyone ?
I haven't seen one between InterBase and MySQL, but I do remember seeing one
between PostgreSQL and InterBase. Allegedly, they thought
Hi everyone,
Is there an online tutorial out there that can help me to create a PHP page
that will accept a users new username and password which is then dumped with
MySQL ?
Your help would be most appreciated.
Anthony
-
Bef
You can restore it by just doing:
$ mysql dbname < dbnams.sql
ROGGER ALEXIS VASQUEZ MARTINEZ wrote:
:Thanks and
:How DO I RESTORE IT ???
:
:
:mysqldump -uusername -ppassword -hhostname dbname > dbname.sql
:
:That will dump the database 'dbname' into the file 'db
You could treate those delimited columsn just like
SET() columns and pass the following query:
SELECT * FROM cats WHERE category LIKE "%christmas%";
Graham Nichols wrote:
GN: Hi,
GN:
GN: I have a table which contains a column 'category'
GN:
GN:
GN: 'category' can be m
Sorry--found the info:
http://www.latencyzero.com/macosx/mysql.html
http://www.entropy.ch/software/macosx/mysql/
-Kurt
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
last_insert_id() should work
D
Alast_insert_id()
MG: recall something about @@Identity. Does MySQL have something similar? I
MG: know I can always just query Max(ID), but that's not always the safest bet.
MG:
MG: reply to [EMAIL PROTECTED] as I have not subscribed to the maili
Christopher R. Jones writes:
> Correct
> The mean (average) depends on the distribution. If the distribution is
> either positively or negatively skewed, then the median will not equal the
> mean. The median of an ordered list is the middle value if the number of
> elements is odd. If the nu
Matt Graham <[EMAIL PROTECTED]> asked
> Can anyone tell me how to get the id of a row just inserted? In MS-SQL I
> recall something about @@Identity. Does MySQL have something similar? I
> know I can always just query Max(ID), but that's not always the safest bet.
>
> reply to [EMAIL PROTECTE
Take a look at the LAST_INSERT_ID() function.
-bryanw
HalfPriceNames Domain Registry
http://www.halfpricenames.com/
-Original Message-
From: Matt Graham [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 29, 2001 9:12 AM
To: '[EMAIL PROTECTED]'
Subject: getting id or record just inserte
Brian Bartholomew writes:
> Sinisa Milivojevic <[EMAIL PROTECTED]> writes:
>
> > This is simply because we have to limit our errors buffers to some
> > reasonable values.
>
> Are there so many of these filename buffers that they can't be sized
> to MAXPATHLEN?
Yes, and we try to use as little s
"Dieter Hansen" <[EMAIL PROTECTED]> wrote:
> "Steve Werby" <[EMAIL PROTECTED]> schrieb am 28.11.01:
> > "Steve Osborne" <[EMAIL PROTECTED]> wrote:
> > > Simple question for one of you I am sure. I'm new to mysql (and php)
and
> > I
> > > am hoping someone can explain exactly what the 'in_array'
Although this is not a php list...
mysql_connect() returns TRUE on success and FALSE on
failuer, so testing $link like "if($link)" means it
did connect.
your script should read:
$link=mysql_connect("localhost")
// the !(bang as it is called) means NOT
// so !TRUE == FALSE
if(!$link) {
>
>
> Hello,
> I saw somewhere that this comparaison existed but I can't remember
> where.
> Does it talk to anyone ?
>
> TIA,
> Fabien
(mysql)
-
Before posting, please check:
http://www.mysql.com/manual.php (the ma
Hello:
Can anyone tell me how to get the id of a row just inserted? In MS-SQL I
recall something about @@Identity. Does MySQL have something similar? I
know I can always just query Max(ID), but that's not always the safest bet.
reply to [EMAIL PROTECTED] as I have not subscribed to the mailin
I'm stuck trying to figure out how to install this thing. What I've tried:
* The download doesn't contain a standard MacOS .pkg so I can't do a GUI install.
* The command-line instructions require the "groupadd" command in step #1, but MacOS
doesn't support this due to the existence of the Net
mysql -u username -p -h newdbname < dbname.sql
-Original Message-
From: ROGGER ALEXIS VASQUEZ MARTINEZ [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 29, 2001 3:51 PM
To: Tyler Longren; ROGGER ALEXIS VASQUEZ MARTINEZ; [EMAIL PROTECTED]
Subject: RESTORE ??? RE: NewBie Question; Backup
Yes I've seen most of MySQL USERS use
BACKUP tables instead of mysqldump ...
I don't know if it's for the fact the is
easieste to restore?
-Original Message-
From: Michael Collins [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 29, 2001 9:59 AM
To: MySQL List
Cc: ROGGER ALEXIS VASQU
At 9:51 AM -0600 11/29/01, ROGGER ALEXIS VASQUEZ MARTINEZ wrote:
>Thanks and
>How DO I RESTORE IT ???
IF using at least version 3.23.25, then you can use RESTORE TABLE
(described just after BACKUP TABLE).
--
Michael
__
||| Michael Collins |||
||| Kuwago Web Services ||| mailto:[
>- Original Message -
>From: "ROGGER ALEXIS VASQUEZ MARTINEZ" <[EMAIL PROTECTED]>
> > How do I make a Backup of a MYSQL database ,,,
At 9:42 AM -0600 11/29/01, Tyler Longren wrote:
>mysqldump -uusername -ppassword -hhostname dbname > dbname.sql
>
>That will dump the database 'dbname' int
>Description:
Under 4.0.0, the LOCK TABLES command requires the following global privileges:
SELECT, INSERT, DELETE, UPDATE. This is not true under 3.23. Is this done
for a reason, or is it a bug?
>How-To-Repeat:
Use the SQL "LOCK TABLES" command as a non-privileged user under MySQL 4.0.0.
Hi,
I have a table which contains a column 'category'
'category' can be made up as records such as:
christmas|birthday|easter
easter|thanksgiving
birthday|christmas|thanksgiving|easter
etc .
As you can see, items are delimited with a '|' in the fields. If I wish to
select all records whi
Thanks and
How DO I RESTORE IT ???
-Original Message-
From: Tyler Longren [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 29, 2001 9:43 AM
To: ROGGER ALEXIS VASQUEZ MARTINEZ; [EMAIL PROTECTED]
Subject: Re: NewBie Question; Backups?
mysqldump -uusername -ppassword -hhostname dbname
"Brian P. Austin" wrote:
>
> The RPMS that are available from the MySQL WebSite are OK to use on 6.2.
> I personnaly prefer to use the source or .src RPMS.
>
> But the RPMS work fine on my 6.2 box.
>
> [EMAIL PROTECTED] wrote:
>
> > Hello,
> >
> > Which version of MySQL ( RPM packages ) is goo
mysqldump -uusername -ppassword -hhostname dbname > dbname.sql
That will dump the database 'dbname' into the file 'dbname.sql'
Tyler Longren
- Original Message -
From: "ROGGER ALEXIS VASQUEZ MARTINEZ" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, November 29, 2001 9:40 AM
How do I make a Backup of a MYSQL database ,,,
It is simple as just copying the files of each table ?
or exists a command to make backup ( including TEXT Fields ) ?
Thanks
-Original Message-
From: Michael Widenius [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 29, 2001 10:51 AM
To:
After having experience with InnoDB and MyISAM..
There's lack in MySQL engine with InnoDB comparing to MySQL with MyISAM
the problem exists when you do wrong with my.cnf configuration file
for example do wrong in max_connections, table_cache
Using MyISAM although with configuration
I have pared down my bug scenario to a single script, at the end of which I
have
failed to update my table, and have reports that the MYD file cannot be
opened.
Here it is:
#This script file for mysql shows a possible bug.
#The update statement near the bottom of the file (a) appears not to
#work
On 29 Nov 2001, [EMAIL PROTECTED] wrote:
> I need to calculate the difference in seconds for two registers type
> datetime, My question is if exists some function or trick on mysql for
> perform it? I need this for calculate some information about time for
> a billing system so I need precision of
Dear Sirs:
Please I am facing the follow problem:
I need to calculate the difference in seconds for two registers type datetime, My
question is if exists some function or trick on mysql for perform it? I need this for
calculate some information about time for a billing system so I need precis
Hi there,
Was using BDB tables for some full text indexing schema I've got.
Indexing a document involves inserting a whole lot of rows in one table, having
done some selects and possibly inserts on another table.
With BDB, this was averaging 1.5 seconds a document. Thought I'd try InnoDB
since
Hi!
> "Jeremy" == Jeremy Zawodny <[EMAIL PROTECTED]> writes:
Jeremy> On Wed, Nov 28, 2001 at 01:30:42PM -0800, [EMAIL PROTECTED] wrote:
>>
>> I think while you've got the hood up, a better method of doing the
>> difference between two dates should be derived.
>>
>> Unless I'm going about
"Steve Werby" <[EMAIL PROTECTED]> schrieb am 28.11.01:
> "Steve Osborne" <[EMAIL PROTECTED]> wrote:
> > Simple question for one of you I am sure. I'm new to mysql (and php) and
> I
> > am hoping someone can explain exactly what the 'in_array' function does.
> I have to assume this is a PHP ques
Ishis a bug? My table has one row, and my update says it has updated one
row,
but the data doesn't change. After the update, myisamchk
reports the table as crashed.
Possibly related, we have occurrences of mysql saying it is unable to open clips.MYD,
errno 145. clips.MYD still exists.
mysql> sel
Sinisa Milivojevic <[EMAIL PROTECTED]> writes:
> This is simply because we have to limit our errors buffers to some
> reasonable values.
Are there so many of these filename buffers that they can't be sized
to MAXPATHLEN?
Brian
yes, the PN field is a part number and is intently unique. But this seems to
load into CUST_ID=NULL, instead of CUST_ID=1. What can I do to update only
for CUST_ID=1?
-Original Message-
From: Thomas Spahni [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 29, 2001 4:26 AM
To: john
Cc: M
Correct
The mean (average) depends on the distribution. If the distribution is
either positively or negatively skewed, then the median will not equal the
mean. The median of an ordered list is the middle value if the number of
elements is odd. If the number of elements is even, then the medi
>I'm moving from Win2k to Linux and was wondering if there was a GIU MySQL
>front-end in Linux similar to Mascon or mysqlfront for the windoz Oss.
>Thanks
>Frank
Try MySQLnavigator
binaries:
http://ftp.kde.com/Database/MySQL_Navigator/mysqlnavigator-1.3.3.3.binary.tar.gz
sources:
http://ftp.kde.
The RPMS that are available from the MySQL WebSite are OK to use on 6.2.
I personnaly prefer to use the source or .src RPMS.
But the RPMS work fine on my 6.2 box.
[EMAIL PROTECTED] wrote:
> Hello,
>
> Which version of MySQL ( RPM packages ) is good for work with php 4.0.6
> and Linux Red Hat 6.
On Thu, 29 Nov 2001, sreedhar wrote:
> Can you tell how can i do my database backup timely i mean in regular
> intervals with out explicitly doing by us.
Sreedhar,
It depends. You have not been extremely verbose describing your
actual requirements or your system, but you might look into
- a c
median (Websters) 1. being in the middle; medial, middle. 2. Statistics.
Designating a point so chosen in a series that half of the individuals in
the series are on one side of it, and half on the other. To illustrate the
distinction between median and average, suppose five persons have wages
res
Roger I Martin PhD writes:
> Hi,
>
> Median as a function in sql does not exests that I know of. But if you get a
> resultset ordered by the column of numbers, you can then pick the median at
> the row index=n/2 where n is the total number of values in the column?
>
> Roger
Nope .
Median depen
hi mysql guru's,
does anyone put light on the unicode charset support of MYSQL?
i searced everywhere in the archives and the docs , but couldn't find
a related thing.It seems that it doesn't support, however i am
asking you to be sure.
My application needs to save both japanese and chinese char
Hi,
Median as a function in sql does not exests that I know of. But if you get a
resultset ordered by the column of numbers, you can then pick the median at
the row index=n/2 where n is the total number of values in the column?
Roger
- Original Message -
From: "Michael" <[EMAIL PROTECTED
Is there a SQL function available for finding the median value from a
column of numbers? I see AVG() but no reference to medians. Thanks.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http:
Hi.
There may be tools out there but I tend to avoid paying or evaluating a
shareware package. There may also be open source that would do it. If you
don't find anything and are interested in a Java solution let me know
because I have written code to not only transfer data but the (relational)
Hi all
Iam new to php and iam learning that from scratch.I
came across a problem in connecting mysql from php
script.I run php in windows2000 under IIS configured
to personal web server.I have installed mysql
with server and client and both are running in the
same machine(ofcourse, i can you use
Brian Bartholomew writes:
> >Description:
>
> My correct socket filename is:
>
> /home/bb/depot/mysql-3.23.43-9a7c0100047f2d1b5c72210d23df8448/tmp/mysql.sock
>
> However, the socket filename is truncated in the error message when
> the database isn't started:
>
> % mysqlshow
> ./mysqlshow: Ca
On Thursday 29 November 2001 02:01, Auri Net SAC wrote:
> Hi
>
> please who knows a package that install apache + php + mysql in linux,
> i know phptriad but its for windows
> Thanks for your answer
> rvj
>
ApacheToolBox http://www.apachetoolbox.com
--
Jason Wong -> Gremlins Associates -> www.
1 - 100 of 111 matches
Mail list logo
