Bryan,
Maybe something like this would work?
select 1296158500 - (1296158500 % 3600)
Hope that helps,
Nathan
On Thu, Feb 24, 2011 at 08:41:58AM -0800, Bryan Cantwell wrote:
> How would I go about modifying a unix timestamp to actually represent
> the 'top of the hour' th
Paul,
I think you could accomplish this by adding a subquery to your where clause,
like:
AND NOT EXISTS (SELECT * FROM mappings m where m.src_ip=src_ip)
Hope that helps.
Nathan
On Tue, Oct 12, 2010 at 03:19:36AM -0700, Paul Halliday wrote:
> I have 2 tables: events and mappings.
>
I think you want to do something like this:
select prod, group_concat(category separator ', ')
from products
group by prod;
Hope this helps.
On Wed, Apr 07, 2010 at 08:37:04AM -0700, kalin m wrote:
>
> hi all...
>
> i have a bit of a problem with this:
>
> table products:
>
> --
s for optimising this design? Or where
to start from? One option and at the moment the only option I have is
to denormalise my schema but this will complicate stuff at the
application level considerably.
Any suggestions welcome,
Nathan
--
MySQL General Mailing List
For list archives:
Brian Dunning wrote:
> Hey all -
>
> I need a few million sample contact records - name, company, address, email,
> web, phone, fax. ZIP codes and area codes and street addresses should be
> correct and properly formatted, but preferably not real people or companies
> or email addresses. But th
On Thu, Oct 08, 2009 at 02:33:34PM -0700, Carlos Proal wrote:
> On 10/8/2009 4:19 PM, John Oliver wrote:
> > 1) When I select * from whatever; is there a way to have the results go
> > by one screen at a time?
> >
>
> You can limit output by delimiting your search ie
>
> select * from users li
Carlos,
I think this does what you want: (untested though)
UPDATE identities
SET email=replace(email, 'mail.', '')
WHERE email like '%mail.iamghost.com'
Regards,
Nathan
-Original Message-
From: Carlos Williams [mailto:carlosw...@gmail.com]
Sent: Wedne
Matt,
If you went with option #3, you could avoid the looping by using (tCount - 1)
as the LIMIT in the delete statement instead of always using 1.
Regards,
Nathan
-Original Message-
From: Matt Neimeyer [mailto:m...@neimeyer.org]
Sent: Tuesday, July 14, 2009 8:58 AM
To: mysql
f) to avoid that locking is to
break the operation into two steps: 1) store the result of the select in a
file or something 2) load the result into the destination table. Perhaps
somebody else knows of a better solution...
Regards,
Nathan
-Original Message-
From: Walton Hoops [mailt
server or database to
calculate timestamps of it
thanks in advance
nathan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
day))) then 2
when (date_field_1 between date(current_timestamp) and
date(date_add(current_timestamp, interval 2 day))) then 3
else 4
end, date_field_3, date_field_2, date_field_1;
-Original Message-
From: Nathan Sullivan
Sent: Thursday, July 02, 2009 1:07 PM
To: 'Ravindra Harige&#x
(date_field_3 between date(current_timestamp) and
date(date_add(current_timestamp, interval 2 day))) then 3
else 4
end, date_field_3, date_field_2, date_field_1;
Hope it helps..
Regards,
Nathan
-Original Message-
From: Ravindra Harige [mailto:ravindra.har...@gmail.com]
Sent: Thursday, July 02
John,
I think this should work:
UPDATE members SET email=REPLACE(email, SUBSTRING(email,INSTR(email,'@')+1),
'Thanks_in_advance.com.com')
Regards,
Nathan
-Original Message-
From: John Furlong [mailto:john.furl...@rakutenusa.com]
Sent: Monday, June 29, 200
Hello
I want to fetch and calculate the data from remote database(for example
Japan) and insert them into my local database(for example usa), does
mysql have such function to do it, or do I have to write a script using
perl or other language to help achieving it?
thank you in advance
nathan
Ray,
You can use the results of a query in a join with something like:
select tmp.id, t1.id
from (some_query_selecting_id) as tmp
join t1 on t1.id=tmp.id
Hope that helps.
Regards,
Nathan Sullivan
-Original Message-
From: Ray [mailto:r...@stilltech.net]
Sent: Tuesday, June 02, 2009
Neil,
You can turn on the general query log by adding a line like this to your
configuration file:
log=/var/log/mysql_queries.log
Regards,
Nathan
-Original Message-
From: Tompkins Neil [mailto:neil.tompk...@googlemail.com]
Sent: Wednesday, May 27, 2009 9:13 AM
To: [MySQL]
Subject
Hi guys
Please tell me the command syntax, how to add a colmmen foreign key in
alter syntax
thanks
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Hi,
I ve recently been playing with storing trees in mysql using nested
set, and I was wondering if anyone knows if this could be extended to
forests (set of trees) to be stored in one table?
Many Thanks in advance,
Nathan
--
MySQL General Mailing List
For list archives: http
On 1/27/06, Imran Chaudhry <[EMAIL PROTECTED]> wrote:
> > Hi;
> > My query.log is full of 'show innodb status' queries.
> > How do I get this ascii log file not to log these. OR some help with a
> > grep script to copy the file without these lines.
>
> I noticed the same in the logs of a 4.1 test s
[Sorry] I didn't realize that hitting Reply (using Gmail) sent a
private message. Usually on lists the message ends up on the list.
Will need to observe the header in the future.
tx;
-nat
On 1/27/06, Gleb Paharenko <[EMAIL PROTECTED]> wrote:
> Hello.
>
> Please, next time always CC your messages t
I recently changed all my ibd files to MYISAM. Can I safely remove the
ibdata file and restart mysql?
Thanks;
-nat
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Aye. -v. thanks!
-nat
On 1/26/06, Pooly <[EMAIL PROTECTED]> wrote:
> 2006/1/25, Nathan Gross <[EMAIL PROTECTED]>:
> > Hi;
> > My query.log is full of 'show innodb status' queries.
> > How do I get this ascii log file not to log these. OR some help with
Hi;
My query.log is full of 'show innodb status' queries.
How do I get this ascii log file not to log these. OR some help with a
grep script to copy the file without these lines.
Thanks
-nat
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lis
Yesterday I installed the XAMPP (used to be called LAMP) stack, which
includes mysql 5.0.18, on a Fedora Core 4 system. This seems like the
quickest way of getting version 5 running WITHOUT clashing at all with
my current install.
Everything went 100% smooth, and I was able to copy my 4.x myisam
ba
On 12/21/05, Mark Matthews <[EMAIL PROTECTED]> wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> Nathan Gross wrote:
> > On 12/21/05, Hassan Schroeder <[EMAIL PROTECTED]> wrote:
> >> Nathan Gross wrote:
> >>
> >>>> /* hint
On 12/21/05, Hassan Schroeder <[EMAIL PROTECTED]> wrote:
> Nathan Gross wrote:
>
> > Woa! Let me verify. If I pass a qry string:
> > "SELECT Anyfield from Anytable where Anyfield = 'The man was 100% correct'
> > "
> > to a Connecto
On 12/21/05, Hassan Schroeder <[EMAIL PROTECTED]> wrote:
> Nathan Gross wrote:
>
> >>/* hint: java.sql.PreparedStatement */
> >
> > I thought we are talking about a mysql specific function, which would
> > not be in the vanilla j2se/j2ee pkg's. Actua
On 12/21/05, Hassan Schroeder <[EMAIL PROTECTED]> wrote:
> Nathan Gross wrote:
>
> >>Nearly every mysql client library has some kind of function to perform this
> >>escaping for you. Please refer to the manual of the client library you are
> >>using to see
On 12/21/05, JamesDR <[EMAIL PROTECTED]> wrote:
> Nathan Gross wrote:
>
>
>
> >
> > I get two lists from different sources which I merge into the database
> > via a Java program. Since these two lists themselves sometimes get
> > their data from the same
On 12/21/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>
>
> Nathan Gross <[EMAIL PROTECTED]> wrote on 12/21/2005 11:20:50 AM:
>
>
> > On 12/20/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> > > Nathan Gross <[EMAIL PROTECTED]>
On 12/20/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> Nathan Gross <[EMAIL PROTECTED]> wrote on 12/20/2005 05:34:58 PM:
>
> > Hi;
> > [Mysql 4x] In a table where I get data from another program, I have
> > many records (about 1000) that have ille
Hi;
[Mysql 4x] In a table where I get data from another program, I have
many records (about 1000) that have illegal chars in a [unique]
indexed varchar field. I would like to clean the illegal characters
out and leave the rest of the data intact.
1. Is there a utility to do this?
1b) Or an UPDATE c
On 12/20/05, Gleb Paharenko <[EMAIL PROTECTED]> wrote:
> Hello.
>
>
>
> Please, next time answer to the list as well.
Sorry. I didn't realize Gmail's 'reply' didn't go to the list. First
time I noticed the 'reply to all' option in Gmail. Thanks.
> As far as I know, you can't specify the location
Hi;
Mysql 4x on Linux Fc4.
In /var/lib/mysql there is an ibdata1 file. Also in this directory I
also have various database folders, with *.ibd data files. I would
like to locate the ibdata1 somewhere else, say, /usr/extraData/mysql.
I am confused as how to set *innodb_data_file_path* as well as
*in
Hi;
Is there a formula I can go by in order to estimate how long it would
take to change over from innodb to myisam. Say for a 100meg file, a 5
gig table, etc.
Thank you;
-nat
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[
Hi;
A while ago, I changed most of my myisam based tables over to innodb. Fine.
A while later, I noticed and implemented the option to keep the files separate.
Now, weeks later, I still have a huge, 7 gig ibdata1, plus many *.ibd files.
Can I delete ibdata1? What worries me is that when I have new
Does anybody know what it is I can do to start to get around this
problem?
Thank you very much in advance,
Nathan Whitington <><
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On a 1.6ghz, 1gb ram, Linux machine running Mysql 4.1x.
I have an Innodb table with over 20 million records and index size
about 3.7 gig, data size 2.2gig (yes, many indexes, more space then
the data itself). Last night I tried an Optimize from the Admin gui
console (logged in as root at the host
Hi;
I have been running this server, 4.1.14 on Linux FC 4 for while, no problems.
Yesterday I fiddled with my.cnf via the Administrator console to,
tried some graphs, and also turned on binary logs.
Later in the day, (don't think it was immediate after the server
process restart, but maybe), the JB
Hi;
On FC3, for some silly reason, Yum deleted my mysql 4.1x production server!
I do have my data. Now that I am in this hole, maybe I should go to mysql 5.
Can I install mysql 5, and it will migrate/work with my existing data?
Thanks,
-nat
Hi;
I have run into 'potholes' with CMP beans on Sun's Java App Server 8.1.
While googling around I [think I] see that Sun's Server doesn't really
'like' mysql. (When it comes to CMP beans.)
Question: Honest please! Is this supposed to work? (Nothing fancy, not
even auto generated pk.)
What's t
te to text data.
more than happy to read the docs, just need a pointer to which docs I
should be reading :)
thanks
Nathan
--
Nathan Coast
Managing Director
Codeczar Ltd
mob : (852) 9049 5581
tel : (852) 2834 8733
fax : (852) 2834 8755
web : http://www.codeczar.com
--
MySQL General Mailing List
Fo
Hi,
Is it possible to modify parameters passed to prepared statements?
e.g.
select ...
where username like '%?%'
I'd like to put wildcard chars '%' on either end of a parameter. Is
this legal? or do I have to modify the parameter before passing it to
mysql.
than
Hi,
is it possible to extract the ddl for a table or whole db? ie the ddl
that would be needed to re-create that table. JBoss automatically
creates some tables during ejb deployment and I want to move this to a
manual process.
cheers
Nathan
--
Nathan Coast
Managing Director
codeczar ltd
work fine
select count(*) as RES from ACL_USER_GROUP_ROLE as UGR where UGR.USER_ID
=2 and UGR.ROLE_ID = 3
and
select ROLE_ID from ACL_ROLE where ROLE_NAME = 'projectmanager'
cheers
Nathan
--
Nathan Coast
Managing Director
codeczar ltd
mobile: (852) 9049 5581
email: mailto:[
SELECT city, state, SQRT( POWER( (
latitude - 39.039200
), 2 ) + POWER( (
longitude + 95.689508
), 2 ) ) AS distance
FROM geographics
WHERE distance <1
ORDER BY distance
LIMIT 10;
Returns:
#1054 - Unknown column 'distance' in 'where clause'
Are alias not allowed in WHERE clauses?
I am able to
Has anyone out there had any trouble installing DBD::MySQL for MySQL
4.1.x on Mac OS X 10.3? I have tried it on several machines in my
company's office, but it fails on all that are running 4.1.x, and
installs fine on those running 4.0.x
Thoughts?
Thanks,
Nathan
--
Nathan Mealey
Direct
Is it possible to install 2 versions of MySQL, 4.0.x and 4.1.x, on the
same system? Do you just have to ensure that they are installed in
separate, distinct, directories?
Thanks for any help/advice!
Nathan
--
Nathan Mealey
Director of Operations
Cycle-Smart, Inc.
P.O. Box 1482
Northampton, MA
nd "select" syntax?
Any help would be much appreciated.
Thanks,
Nathan
--
Nathan Mealey
Director of Operations
Cycle-Smart, Inc.
P.O. Box 1482
Northampton, MA
01061-1482
[EMAIL PROTECTED]
(413) 587-3133
(413) 210-7984 Mobile
(512) 681-7043 Fax
--
MySQL General Mailing List
For
to any hosts due to exception:
java.security.AccessControlException: access denied (java.net.SocketPermission
127.0.0.1:3306 connect,resolve)
SQLState: 08S01
VendorError: 0
Nathan E. Pierce
Quoting Sergei Skarupo <[EMAIL PROTECTED]>:
> Generally applets are an
in advance,
Nathan E. Pierce
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
er if others have had
problems with this particular binary.
-nb
Victor Pendleton wrote:
How is this table accessed and updated? Do you have file contention issues?
Is the MySQL message 145?
-Original Message-
From: Nathan Boeger
To: [EMAIL PROTECTED]
Sent: 7/30/04 9:40 AM
Subject: File size
Hello everybody,
We have a few Linux/MySQL boxes and recently we have been having some
problems with one of our databases. We have checked out the usual things
(hardware, disk quotas, table limits etc...) and we have spent several
days looking over newsgroups and other postings with no luck. We are
Hi,
Does anyone know of any written stats on how much overhead for CPU/ Disk
IO replication has for a single master and a single slave?
I am looking for any detailed stats on the proformance issues associated
with replication.
thanks
-Nathan
--
MySQL General Mailing List
For list archives
To any Moderators: This is the only time I will send this message.
Dear List Members,
I am seeking a co-op/paid internship in a Computer Science related
field. If you or someone you know, directly or indirectly, works for a
company that deals with Computer Science, i.e. Computer Programming,
ple
On Wed, 2004-05-05 at 22:49, Paul DuBois wrote:
> At 22:39 -0400 5/5/04, Nathan Jones wrote:
> > > Hi there,
> >>
> >> I seem to be having a problem retrieving the last inserted ID for a
> >> table.
> >>
> >> The query I am using is as
> Hi there,
>
> I seem to be having a problem retrieving the last inserted ID for a
> table.
>
> The query I am using is as follows:
>
It's far easier than anyone else has mentioned, as of my writing. Just
use the PHP function 'mysql_insert_id()' after your insert query. This
function has bee
d from the "title"
column are not bringing up any results (for known-item searching).
The query against this index was: >SELECT * FROM articles WHERE MATCH
(title,text) AGAINST ('search_term');
Am I missing something? Is the query I wrote above incorrect?
Any help would be
Kind of what I was thinking of. How can I generate a unique identifier?
-Nate
-Original Message-
From: Keith C. Ivey [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 18, 2004 2:18 PM
To: [EMAIL PROTECTED]
Subject: Re: Temporary table issues. Do I need persistent connections
with ph
I have a php page which displays quite a bit of dynamically calculated
data which I need to be sortable using different SQL statements.
Currently to display this data, a user browses to the page, the page
checks for a cookie, if the cookie doesn't exist it includes some php to
generate a temporary
x(t2.weird, '-', -1)
)
where
t1.key =
and
t1.id = t2.id;
-- Nathan Christiansen
> -Original Message-
> From: Nathan Christiansen
> Sent: Thursday, January 29, 2004 3:49 PM
> To: [EMAIL PROTECTED]
> Subject: MySQL outer join with substring_
nline manual is
just confusing me.
Thanks.
-- Nathan Christiansen
Software Engineer
Tahitian Noni International
http://www.tahitiannoni.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
How do you merge duplicate rows? All rows involved contain identical data
in each column.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I've seen this question posted in various forms on the web, but not in
such a way that I have found helpful. I have a column of data in the
following format name.xx.yy where the x's and y's represent numbers.
When selected by mySQL, the column is sorted in an odd way, given by the
following exampl
than
try to create it and find out it can't be created because it already
exists. An alternative (which is actually better) would be a query to
determine case sensitivity, but I can't figure out how to get that info
from MySQL either.
At 02:43 AM 11/11/2003, Matt W wrote:
Hi Nathan
I'm relatively new to MySQL, and I'm writing a PHP script that doesn't know
what kind of system the MySQL database is on. The script and database
don't have to be on the same system, so I need a way to determine what kind
of system (*nix, Win, etc.) MySQL is running on. Is there a "fool proof"
I'm looking for a way to select data from one table that is not found in
another. I am sorting on a column called 'model_id'. Basically I want
something like this to work:
"SELECT t1.*, t2.model_id FROM data1 as t1, data2 as t2 WHERE
t1.model_id != t2.model_id"
t1 has about 1000 entries and t
Yeah, I have a similar box like yours. I copied the first column to a new
table with an index. I ran select distinct and the query took 6 seconds to
execute. This must have to do with the record length, because when I indexed
the origional table's first column the query was 1 minute 30 seconds to
Well, it's an InnoDb database and has some decent memory pools.
| innodb_additional_mem_pool_size | 33554432
| innodb_buffer_pool_size | 536870912
-Original Message-
From: Joseph Bueno [mailto:[EMAIL PROTECTED]
Sent: Monday, September 15, 2003 11:47 AM
To: Nathan Cassa
>
> From: Haydies [mailto:[EMAIL PROTECTED]
> Sent: Monday, September 15, 2003 11:19 AM
> To: [EMAIL PROTECTED]
> Subject: Re: Select distinct speed on an indexed column
>
>
> Its a compound key, they are always slow. I would imagin you will need to
> seriously redesign your database to speed t
mysql> explain select distinct AccountLevelId from PostedZpdi;
++---+---+-+-+--+-+-
+
| table | type | possible_keys | key | key_len | ref | rows|
Extra |
++---+---+-+--
ctual
data? Thanks for your insights!
Nathan
show table status;
---+-+++
---+
| Name | Type | Row_format | Rows| Avg_row_length | Data_length
| Max_data_length | Index_length | Data_free | Auto_increment | Create
id AND
company_name regexp '#FORM.query#' AND
product_name regexp '#FORM.query#' AND
description regexp '#FORM.query#'
Also what about indexes?
Thanks in advance for your help.
Nathan
On Fri, 22 Aug 2003 23:28:18 +
"Nathan Simms"
ct_id, company_name, product_name, url, description
FROM product, company
WHERE product.product_id = company.company_id AND description regexp
'#FORM.query#'
Thanks for your help,
Nathan
_
Help STOP SPAM with the new MSN 8 a
Hello,
MySQL has been running smoothly on my machine for the past month. This morning I
installed PHP 4.3.2 and now I can't seem to get MySQL running anymore.
I get the following error message:
# Starting mysqld daemon with databases from /var/lib/mysql
030616 11:19:03 mysqld ended
Any clues?
create
instance if MySQLProv.
And the other thing is what version of mysql supports multple sql commands
in the one statement eg.. Select 'nathan' ; insert into tablename(field)
values(1)
any help would be super ;)
Kind Regards
Nathan Franklin
TSN Internet
[EMAIL PROTECTED]
MSN: [EMAIL
ided nature) is very expensive.
Yes, the point is to ONLY index the row if it matches the restriction.
-- Nathan
----
Nathan Neulinger EMail: [EMAIL PROTECTED]
University of Missouri - Rolla Phone: (573) 341-484
I can make a temporary or results table updated
periodically, which I will likely do in the meantime, but would be nice
to have an efficient way of accomplishing this with live data.)
-- Nathan
----
Nathan Neulinger
uld definately be preferable.
>
> (BTW - Y'all make it far too much a pita to submit a bug report.)
>
> -- Nathan
>
>
> Nathan Neulinger EMail: [EMAIL PROTECTED]
> University of Mi
You could also bypass the num_rows entirely...
".$query);
echo '';
for ($i=0; $row = mysql_fetch_assoc($result); $i++) {
echo ''.($row["field"]).'';
}
echo '';
?>
# Nathan
- Original Message -
From: &q
If you're going to post this much information please use:
mysql> SELECT * FROM user \G
so that this is actually readable.
Thanks
# Nathan
- Original Message -
From: "Brian Warn" <[EMAIL PROTECTED]>
To: "'Daniel Negron/KBE'" <[EMAIL PROTE
e.
Cheers,
# Nathan
- Original Message -
From: "Alainq" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, March 05, 2002 3:34 PM
Subject: Summarize
Dear,
I am stuck on something,
I would like to summarize multiple columns to a total value in a query and
the
like.
Does that not fit in with your plans?
# Nathan
- Original Message -
From: "Forer, Leif" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, March 05, 2002 11:56 AM
Subject: SELECT this IF that
I want to select and join data from two tables if the same id
oops, good point. thanks.
On Mon, 4 Mar 2002, Roger Baklund wrote:
> * Nathan Cowles
> > $query2 = "SELECT SEC_TO_TIME(TIME_TO_SEC('$lastout') -
> > TIME_TO_SEC('$firstin'))";
> > $result2 = mysql_db_query($database, $query, $connection) o
Well after reviewing the DELETE section of the manual, I see nothing to suggest that
it supports
multiple-table deletes...
# Nathan
- Original Message -
From: "Daren Cotter" <[EMAIL PROTECTED]>
To: "Nathan" <[EMAIL PROTECTED]>; "Daren Cotter" &
The file is available at
http://estore.homeip.net/time/pctimesheetnew.php.txt.; How would I supply
a column alias? Thanks.
Nathan Cowles
On Mon, 4 Mar 2002, Paul DuBois wrote:
> At 13:54 -0800 3/4/02, Nathan Cowles wrote:
> >lastout and firstin contain times such as 13:28:01 and
P? Thanks.
Nathan Cowles
On Mon, 4 Mar 2002, Paul DuBois wrote:
> At 13:35 -0800 3/4/02, Nathan Cowles wrote:
> >Paul,
> >
> >You're awesome...thank you. One more question pertaining to this...
> >
> >I'm accustomed to selecting a variable and usin
?
$query2 = "SELECT SEC_TO_TIME(TIME_TO_SEC('$lastout') - TIME_TO_SEC('$firstin'))";
$result2 = mysql_db_query($database, $query, $connection) or die ("Error in query:
$query. " . mysql_error());
This isn't working, I get 23:
$total = mysql_result($result
of this from PHP, so if you happen to know of a way
to make it do the subtraction in PHP without losing all accuracy, please
let me know.
Thanks for any help you can offer.
Nathan Cowles
StormNet Communications
530.897.4069
-
Be
ave tried a few things and it's beyond me at the moment... any insights would be
greatly
appreciated!!! Further info is definitely available if needed.
Thanks!
# Nathan
-
Before posting, please check:
http://www.mysql
-
From: "Mark Stringham" <[EMAIL PROTECTED]>
To: "Nathan" <[EMAIL PROTECTED]>; "MySQL" <[EMAIL PROTECTED]>
Sent: Tuesday, February 26, 2002 11:26 AM
Subject: Re: table backups
Ok - I am going to show my complete ignorance here now.
How do I configure my
... ?
# Nathan
- Original Message -
From: "Mark Stringham" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, February 26, 2002 10:22 AM
Subject: Re: table backups
2 quick questions -
1. What is the Windows equivelant to a cron job. I would like to perform a
Get rid of the second "values".
mysql> INSERT into book(
-> isbn,
-> title,
-> authlname,
-> authfname,
-> publisher,
-> pubdate,
-> dewey,
-> lcnum
-> )
-> values (
-> '1-56592-434-7',
-> 'MySQL & mSQL',
-> 'Yarger',
-> 'Randy Jay',
->
Quite. I was hoping it wasn't my ISP or something... most messages are from the 6th -
8th. I assume
the MySQL list server having a problem?
Although, it is rather amusing to see the new replies to week-old messages. ;)
- Original Message -
From: "Van" <[EMAIL PROTECTED]>
To: "MySQL" <[
. If you
didn't already know, database files end with *.MYI, *.MYD, and *.frm "extensions".
# Nathan
- Original Message -
From: "Jonas Fornander" <[EMAIL PROTECTED]>
To: <>
Sent: Friday, February 08, 2002 11:42 AM
Subject: Default install directory
I
, it's all
on the same line.
# Nathan
- Original Message -
From: "Johnny Withers" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, February 07, 2002 10:36 AM
Subject: RE: long query on php
Or you could do it like this:
$query="some query "
. If you
didn't already know, database files end with *.MYI, *.MYD, and *.frm "extensions".
# Nathan
- Original Message -
From: "Jonas Fornander" <[EMAIL PROTECTED]>
To: <>
Sent: Friday, February 08, 2002 11:42 AM
Subject: Default install directory
I
, it's all
on the same line.
# Nathan
- Original Message -
From: "Johnny Withers" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, February 07, 2002 10:36 AM
Subject: RE: long query on php
Or you could do it like this:
$query="some query "
urned from
your query.
Hope this saves a few people some agony.
# Nathan
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this t
manual
on table types and decide which is best for you. AFAIK there is no "pack" option for
MyISAM.
# Nathan
- Original Message -
From: "savaidis" <[EMAIL PROTECTED]>
To: "MySQL list (E-mail)" <[EMAIL PROTECTED]>
Sent: Monday, February 04, 2002 12
1 - 100 of 139 matches
Mail list logo
