On Wed, Nov 28, 2001 at 11:41:49PM -0800, Brian Aker wrote:
On Wed, 2001-11-28 at 22:40, Jeremy Zawodny wrote:
Has anyone considered optionally putting PCRE (Phil Hazel's Perl
Compatible Regular Expressions -- http://www.pcre.org/) in MySQL so
that someone could write:
SELECT * FROM
Does anyone know what this error means -
General error: Can't find file: 'A.MYD' (errno: 2)
I have just installed the InnoDB Database.
When I created the table, Mysql created just A.frm file.
Thanks
-
Before posting, please
Hi,
Select unix_timestamp(Now()) - unix_timestamp(datetime_column) from table_name;
At 08:50 AM 29/11/2001 +0100, you wrote:
Hi
Could i in some way find out the seconds between to datetimes
I.E.
I have a DATETIME in a table and i want to find out how many
second it is from that DATETIME to
Hi all!
I am trying to get rid of SQL Server 6.5(NT 4.0 server) and replacing it with
mysql(Linux 7.0).As an initial step i have to transfer data daily from mysql to SQL
6.5.
If anybody know an efficient way to do this.The size of data is 1.5 GB.
Regards
Manzoor
--
If you wouldn't mind, though I think the folks at MySQL.Com
should consider
throwing a copy back up. Maybe I'm just a nervous nelly, but I won't be
I agree with that. It wasn't really a problem using a manual for a
subrevision higher than the version I used, but to V4, some things changed,
On Wed, 28 Nov 2001, john wrote:
mysql load data local infile '/tmp/Parts.txt'
- replace
- into table Parts
- fields
- optionally enclosed by ''
- terminated by ','
- ('PN','APN','C','Q','D')
Query OK, 100946 rows affected (39.66 sec)
Records: 100946 Deleted: 0
On Wed, 28 Nov 2001, john wrote:
Yes, but won't this only replace and not load the rest of the items in
the file?
This is my code, but it only updates the existing items.
load data local infile '/tmp/Parts.txt'
replace
into table Parts
fields optionally
Hello,
Which version of MySQL ( RPM packages ) is good for work with php 4.0.6
and Linux Red Hat 6.2 ?
Thank for your help !
Edward.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
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
-
Before posting, please check:
http://www.mysql.com/manual.php
Chang-Ping Hsiao writes:
Hi!
Thanks for the help. Tried both and both failed. Still get the
following.
[skip]
make[2]: Entering directory `/tmp/mysql-3.23.45/client'
/bin/sh ../libtool --mode=link gcc -O3 -DDBUG_OFF -fno-implicit-templates
-fno-exceptions -fno-rtti
On Wed, 28 Nov 2001, A. Clausen wrote:
That is the MySQL 4.x manual, I'm looking for the 3.23.x PDF-formatted
manual. The HTML and text versions supplied with the 3.23 distributions are
way too unwieldly, and I'm not going to upgrade my mission critical app to
what is apparently alpha
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 -
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: Can't connect
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
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)
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)
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]
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
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 depends on
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
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
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.2 ?
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:
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:
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
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
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 question since it
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
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
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
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
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
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:
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
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 good for work with
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
- 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' into the file
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 |||
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
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;
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
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
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 manual)
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) {
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' function
does.
I
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 stack as
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
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 PROTECTED] as
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 number
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
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)
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
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
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
-
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 that
-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
mysql that has
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, items are
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
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.
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,
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 password
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
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
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
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...
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
-
start paste message
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
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.sql
# or
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]
[...]
-- in
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
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
stored.
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.
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:
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 |
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
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
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 Journel.
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
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 ... IN
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
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
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
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
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
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
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 PROTECTED]
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 been able
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 and
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
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 DateTime? At least
[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
$ 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: sreedhar [EMAIL
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
[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?
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:
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 .
help
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
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
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:
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
1 - 100 of 101 matches
Mail list logo
