On Thu, 21 Aug 2003 18:18:37 -0700
Jon Drukman <[EMAIL PROTECTED]> wrote:
> that is true, but in this case, neither $php_errmsg nor mysql_error()
> return anything. i print them both out when the connect fails and they
> are both just blank.
try to use error_reporting(E_ALL); and to see what h
Rajesh Kumar wrote:
> Peter Brawley unknowingly asked us:
>>> Interestingly, use of date_add() and date_sub() on 'odd' dates such
>>> as "Feb 31" does produce sane results.
>>> Subtract one from "2000 Feb 31", and you'll get 2000-03-01.
>> This is sane!!??
> This is where Unix Timestamps come into
Hi, is it possible to link databases within mysql? I have a access database that I
need to import into mysql this db consists of 4 other dbs linked together sharing a
common switchboard. Can I link the tables in one db to tables in another db?
thanks
Bob
Hi,
We are using MySql version 3.27.53 on a Red Hat Linux platform version
7.2. For the past couple of months we are noticing that the performance
of the server has gone down very badly. Every, single insertion is
taking a hell lot of time.The particular table has only 150,000 records.
Is there
Hi all,
I pretty much set a fields default value to NULL if it not a "required"
field in my app. Just wondering if this is the way to go since I just
sort of guessed at this method ;)
- Charles
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:htt
On Thu, Aug 21, 2003 at 06:58:29PM -0700, Steven Roussey wrote:
>Jesse Sheidlower wrote:
>
> > Hmm. When I returned to the multiple-table query that started
> > this thread,
>
> And it was slow. Yeah, one thing at a time. It makes it easier for
> people reading this list now or in the future (if
In the last episode (Aug 21), Jon Drukman said:
> Lefevre, Steven wrote:
> >I say go with RAID 5, on a controller card.
> > Mirroring just gives you backup, and you lose half your diskspace.
> > It offers no performance benefit, and actually the computer might
> > have to work harder to make sure t
funny i was just having the same problemo with mysql 3.22 on php3 the most painful
system to debug i hate it to bits, anyway mysql_error doesnt get returned on
permission or database connection errors, i wonder if that is soughted out in mysql4
?? maybe this is a php.net question
>>> Jon Drukma
ft_stopword_file The file from which to read the list of stopwords for full-
text searches. All the words from the file will be used; comments are not
honored. By default, built-in list of stopwords is used (as defined in
`myisam/ft_static.c'). Setting this parameter to an empty string ("") will
di
> GOD! OK, sorry, I wasn't quite expecting this:
> Wow!
:)
>
> But what's the explanation for this huge improvement? Again, I
> was always told the opposite, and the Manual itself says: ...
Yes, and it is true (usually). But your EXPLAIN showed a filesort and
that is bad. What happens is that i
On Thu, Aug 21, 2003 at 04:58:47PM -0700, Steven Roussey wrote:
> > No, the contents can be of mixed case. Where does that leave things?
>
> **Index the length of the entire column.** It then should not need to
> have to do the filesort. Actually the binary option would not have
> really helped. T
Glad that helped!
-M
- Original Message -
From: "Dan Jones" <[EMAIL PROTECTED]>
To: "MySQL Mailing List" <[EMAIL PROTECTED]>
Sent: Thursday, August 21, 2003 5:46 PM
Subject: Re: Copying distinct data to a new table
> On Thu, 2003-08-21 at 20:09, Dan Jones wrote:
> > I'm attempting to nor
At 10:12 +1000 8/22/03, <[EMAIL PROTECTED]> wrote:
sorry to be vague but what is the ft_stopword_file i havent been able to be
up to speed on that variable.
Read the page referenced below:
http://www.mysql.com/doc/en/SHOW_VARIABLES.html
It describes what the variable is for.
At 15:53 -0300 8/2
Lefevre, Steven wrote:
I say go with RAID 5, on a controller card.
Mirroring just gives you backup, and you lose half your diskspace. It offers
no performance benefit, and actually the computer might have to work harder
to make sure the drives are in sync.
that is not true. mirroring gives you d
Antony Dovgal wrote:
mysql_error is not set when mysql_connect fails, because there is no
actual mysql resource to get the error message from.
yes, there is no mysql resource at this moment.
just don't specify it and mysql_error() will tell something like "Can't connect to local
MySQL server thro
At 17:56 -0400 8/21/03, Rajesh Kumar wrote:
Hello,
I'm using a PHP API with MySql.
I can use the mysql_num_rows() function to find out the number of
rows in the resultset.
But does anyone know of a way to find out the number of seconds it
took to execute a particular query using PHP?
Why I ne
Type show slave status to figure out what the problem is on the slave.
Type show full processlist on the master to see if the slave is
connected waiting for binlog updates.
Make sure the master is replicating..
Etc.
-->-Original Message-
-->From: Sanya Shaik [mailto:[EMAIL PROTECTED]
--
Hello,
I'm using a PHP API with MySql.
I can use the mysql_num_rows() function to find out the number of rows
in the resultset.
But does anyone know of a way to find out the number of seconds it took
to execute a particular query using PHP?
Why I need this is because, I would like to execute
On Thu, 2003-08-21 at 20:09, Dan Jones wrote:
> I'm attempting to normalize a database that was originally created as a
> flat file. I want to extract distinct values from a table and insert
> them as new entries into a new table. Unless I'm missing something,
> INSERT doesn't allow you to SELECT
Dan Jones unknowingly asked us:
I'm attempting to normalize a database that was originally created as a
flat file. I want to extract distinct values from a table and insert
them as new entries into a new table. Unless I'm missing something,
INSERT doesn't allow you to SELECT data from another tab
hi there, i am trying to remove values from a list menu if the join table doesnt have
keys when a key is selected for instance:
locations
locationID
locations_join
locationID shotlistID
SELECT SQL_NO_CACHE l.locationID , l.location FROM locations l LEFT JOIN
locations_join lj ON l.locationID =
sorry to be vague but what is the ft_stopword_file i havent been able to be
up to speed on that variable.
> At 15:53 -0300 8/21/03, Cleber Hostalácio de Melo wrote:
>>Hi,
>>
>>I need to change the stop word file used by the MySQL in fulltext
>>seach.
>>
>>The documentation (www.mysql.com/doc/en/Fu
I'm attempting to normalize a database that was originally created as a
flat file. I want to extract distinct values from a table and insert
them as new entries into a new table. Unless I'm missing something,
INSERT doesn't allow you to SELECT data from another table for
insertion, and UPDATE doe
I will be out of the office starting 21/08/2003 and will not return until
08/09/2003.
I will respond to your message when I return. If you have any urgent
queries please contact Stuart Mclean
==
Disclaimer Notice
This messa
> No, the contents can be of mixed case. Where does that leave things?
**Index the length of the entire column.** It then should not need to
have to do the filesort. Actually the binary option would not have
really helped. The explain should say 'Using Index'. Get back to me on
this and tell me th
Peter Brawley unknowingly asked us:
Interestingly, use of date_add() and date_sub() on 'odd' dates such as
"Feb 31" does produce sane results.
Subtract one from "2000 Feb 31", and you'll get 2000-03-01.
This is sane!!??
This is where Unix Timestamps come into action (and perhaps rescue)!
To be sur
Kevin Fries wrote:
> I agree it's unfortunate that the dates get stored. But some do seem
> to prefer it this way.
>
> To quote the manual at the bottom of:
> http://www.mysql.com/doc/en/Using_DATE.html
>
> If the date cannot be converted to any reasonable value, a 0 is
> stored in the DATE field,
>Interestingly, use of date_add() and date_sub() on 'odd' dates such as
>"Feb 31" does produce sane results.
>Subtract one from "2000 Feb 31", and you'll get 2000-03-01.
This is sane!!??
PB
[mysql]
On Thu, Aug 21, 2003 at 03:36:54PM -0700, Steven Roussey wrote:
> > Executing just the search on the word table, with no joins to the
> > table with the dates, is still slow:
>
> Then it is not worth while to focus on anything else until you fix that.
> Are the contents of this field always in low
At 15:53 -0300 8/21/03, Cleber Hostalácio de Melo wrote:
Hi,
I need to change the stop word file used by the MySQL in fulltext seach.
The documentation (www.mysql.com/doc/en/Fulltext_Fine-tuning.html)
explains how to inform to MySQL the new stop word file through the
"ft_stopword_file" variable.
> how to separate each stop word in the list
A different word on each line.
-steve-
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I agree it's unfortunate that the dates get stored. But some do seem to
prefer it this way.
To quote the manual at the bottom of:
http://www.mysql.com/doc/en/Using_DATE.html
If the date cannot be converted to any reasonable value, a 0 is
stored in the DATE field, which will be retrieved
> Executing just the search on the word table, with no joins to the
> table with the dates, is still slow:
Then it is not worth while to focus on anything else until you fix that.
Are the contents of this field always in lower case?
Is so, then change the column to a binary type. The explain says
for what i understand of this problem, it should not be possible an easy way.
once i have found an article on this on the internet, don't know where it was anymore.
(neither devshed nor phpbuilder)
but it was about JOINing the result with an 'integers table' that has all the needed
values from 1
Adam Clauss and Rajesh Kumar wrote:
>> Hans van Harten unknowingly asked us:
LOL
>>> Some make the laughing stock of MySQL with this code:
>>> create database data_test ;
>>> use data_test;
>>> create table test3 (a date);
>>> insert into test3 values (-1);
>>> insert into test3
As per the manual that is correct.
The only correct date will be 1996-02-31.
what is the problem?
-Original Message-
From: Hans van Harten [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 21, 2003 4:09 PM
To: [EMAIL PROTECTED]
Subject: MySQL running out of date
Some make the laughing st
* Rajesh Kumar
> Roger Baklund unknowingly asked us:
>
> >>What would be a good way to deal with the following...
No, I did not. Scott Haneda asked the question. I replied. :) And I
recommended considering the SET column.
> But for a couple of reasons, SET is not recommend.
>
> 1. It introduces f
Same here.
Got 0's for the invalid dates, correct date for the other. What is wrong?
Adam Clauss
[EMAIL PROTECTED]
> -Original Message-
> From: Rajesh Kumar [mailto:[EMAIL PROTECTED]
> Sent: Thursday, August 21, 2003 1:35 PM
> To: Hans van Harten
> Cc: [EMAIL PROTECTED]
> Subject: Re:
Absolutely! I have multiple indexes. I think it might be a problem with ODBC
> Are your tables indexed? http://www.mysql.com/doc/en/MySQL_indexes.html
>
> Saqib Ali
> -
> http://www.xml-dev.com
>
>
-
Visit CARMEL MUSIC & ENTERTAINMENT we
Hans van Harten unknowingly asked us:
Some make the laughing stock of MySQL with this code:
create database data_test ;
use data_test;
create table test3 (a date);
insert into test3 values (-1);
insert into test3 values ('1996-02-31');
insert into test3 values ('1996-67-31')
[EMAIL PROTECTED] (Lefevre, Steven) writes:
> I say go with RAID 5, on a controller card.
> ..
>
> You get better performance than mirroring or regular drive, because
> the data is spread out over your drives. It's not as good as disk
> striping, though.
Ehh. Wrong. That is not how it works. If y
Hi!
On Aug 21, Luc Foisy wrote:
> Thank you Paul.
> whew! So just checking will not do anything to the database, in an case?
yes, but ONLY if you run myisamchk with --read-only flag.
> I am not really caring if it returns the "# users still connected/ or
> table not closed right" warning. I am n
Some make the laughing stock of MySQL with this code:
create database data_test ;
use data_test;
create table test3 (a date);
insert into test3 values (-1);
insert into test3 values ('1996-02-31');
insert into test3 values ('1996-67-31');
select * from test3;
I ran it o
At 16:32 -0400 8/21/03, Luc Foisy wrote:
Thank you Paul.
whew! So just checking will not do anything to the database, in an case?
I am not really caring if it returns the "# users still connected/
or table not closed right" warning. I am not really looking for that.
I am looking for warnings telli
Thanxs for the URLS, I'll check them out.
Greetings
Mikel
_
Charla con tus amigos en línea mediante MSN Messenger:
http://messenger.microsoft.com/es
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
Can you post your DDL to go along with your DML?
-Original Message-
From: Allen Weeks [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 21, 2003 4:51 PM
To: Jesse Sheidlower; Cybot
Cc: [EMAIL PROTECTED]
Subject: RE: Slow results with simple, well-indexed query
The only thing I can add is
Here is a good URL, maybe it can help you to deploy your Master-Slave
solution.
URL: http://mysql.us.themoes.org/doc/en/Replication_HOWTO.html
Greetings
Mikel
From: Sanya Shaik <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: Master-Slave Replication Date: Thu, 21 Aug 2003 12:50:31 -0700
(PD
The only thing I can add is check you hardware and OS platform.
Cheers
-Original Message-
From: Jesse Sheidlower [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 21, 2003 11:44 AM
To: Cybot
Cc: [EMAIL PROTECTED]
Subject: Re: Slow results with simple, well-indexed query
On Thu, Aug 21,
Thank you Paul.
whew! So just checking will not do anything to the database, in an case?
I am not really caring if it returns the "# users still connected/ or table not closed
right" warning. I am not really looking for that.
I am looking for warnings telling my that tables are corrupted...
---
Cybot wrote:
> Jesse Sheidlower wrote:
>> An example of a query is to get all the words (the cg.cw
>> field) in a particular alphabetical range that have been
>> added in some timespan (the sref.cd field). The cg table
>> has about 3M rows, and the sref table about 70,000; the
>> intervening tables
Hi all,
Thanks for the answers for Master-Master replication. Right now i want to try the
Master-Slave replication first and then do a circular replication.
Unfortunately, I am facing problems with updating slave automatically.
I started the slave and loaded the data from the master, late
Veritas might be a good solution. I'm trying to find out if a mounted
Veritas file system that stores only the snapshots while the data
resides locally is possible. If so then backing up the data could happen
every 5 min if necessary in my environment.
Does anyone know if the Veritas software allo
Hi everyone,
I've got a very simple table which contains records of events. It's just
a table with 2 columns: an id and a timestamp. Every time this event
occurs, I insert a timestamp in the table.
I use this query to extract the number of events on each separate day:
SELECT COUNT(id) AS number
I should qualify my answer, to indicate something that may not apply
to the situation you have in mind.
If you're using myisamchk only to *check* tables, it operates in read-only
fashion. The problems occur if you're using it to repair tables, because
then if you have both myisamchk and the server
Hi,
I need to change the stop word file used by the MySQL in fulltext seach.
The documentation (www.mysql.com/doc/en/Fulltext_Fine-tuning.html)
explains how to inform to MySQL the new stop word file through the
"ft_stopword_file" variable.
But I could not find any reference to the layout of thi
Roger Baklund unknowingly asked us:
What would be a good way to deal with the following...
I have a form that has 5 checkboxes on it, lets say the
checkboxes are for categories, and more than one can be
selected.
For example:
please tell is what brochure you want
[] car
[] boat
[] truck
[] SUV
[]
On Thu, Aug 21, 2003 at 06:01:31PM +0200, Cybot wrote:
> Jesse Sheidlower wrote:
>
> >I'm struggling with speed issues on some queries that
> >I would have expected to be relatively fast. Perhaps
> >even more frustratingly, when I've tried to break
> >these down into their components, they still
At 14:37 -0400 8/21/03, Luc Foisy wrote:
If you read http://www.mysql.com/doc/en/Maintenance_regimen.html
they say something interesting that would contracdict other places
in the documentation
They actually recomend running myisamchk on a running instance of
mysqld. The method on that page (a m
Luc Foisy unknowingly asked us:
Would anything happen to the database if I ran "myisamchk --silent /usr/data/mysql/*/*.MYI" when I havent run "FLUSH TABLES" first?
As it states in the documentation:
If mysqld is running, you must force a sync/close of all tables with FLUSH TABLES and ensure that n
At 01:02 PM 8/21/2003, you wrote:
Using an Apache/PHP/MySQL/Linux (Redhat 8.0) solution, PHPList, to create
an e-mailing list for our 5.6 million book club members. Unfortunately,
the import speed for importing records (at record number 150,000) is about
2,000 records per hour. We're running o
If you read http://www.mysql.com/doc/en/Maintenance_regimen.html they say something
interesting that would contracdict other places in the documentation
They actually recomend running myisamchk on a running instance of mysqld. The method
on that page (a method they use themselves) would not even
> "Creigh" == Creigh Shank <[EMAIL PROTECTED]> writes:
Creigh> Using an Apache/PHP/MySQL/Linux (Redhat 8.0) solution,
Creigh> PHPList, to create an e-mailing list for our 5.6 million book
Creigh> club members. Unfortunately, the import speed for importing
Creigh> records (at record number 150
* Creigh Shank
> Using an Apache/PHP/MySQL/Linux (Redhat 8.0) solution, PHPList, to create
> an e-mailing list for our 5.6 million book club members. Unfortunately,
> the import speed for importing records (at record number 150,000)
> is about
> 2,000 records per hour. We're running on the follow
On Thu, Aug 21, 2003 at 03:30:11PM +, Nick Heppleston wrote:
> I have a concatenation problem and I was wondering if somebody might be
> able to offer some help :-)
Hi Nick,
Your problem is a formatting problem, not a concatenation problem; i.e.
SQL concatenation wasn't intended to solve th
3Ware makes reasonably priced ATA and SATA RAID-5 cards (IDE, not SCSI). You
can get hot-swappable enclosures so that when a drive fails, you swap it
without shutting down the machine.
We are gradually adding this hardware to our webservers, etc so that we
don't have to rebuild them when a drive d
Ich bin vom 13.08.2003 bis 08.09.2003 außer Haus.
Ich werde Ihre Nachrichten nach meiner Rückkehr beantworten.
Using an Apache/PHP/MySQL/Linux (Redhat 8.0) solution, PHPList, to create
an e-mailing list for our 5.6 million book club members. Unfortunately,
the import speed for importing records (at record number 150,000) is about
2,000 records per hour. We're running on the following:
P4 (1.5 Ghz), 1.
Group,
I have been working with Mysql for about 5 years - mainly in LAMP shops. The
tables have been between 20-100 thousand records size. Now I have a project
where the tables are in the millions of records.
This is very new to me and I am noticing that my queries are really
sloww!
What ar
On Thu, Aug 21, 2003 at 05:59:54PM +0200, Mechain Marc wrote:
>
> What is the value of "sort_buffer_size", may be you could
> increase the value for having faster ORDER BY (all in memory
> intead of using temporary file on disk).
I had previously tried that--I sometimes have big GROUP BY
queries a
[already posted to mailing.database.mysql newsgroup but not to list; sorry
for cross-post]
I found a way to do this before, but I didn't write down how I did it, so I
don't remember it now. And I've searched http://www.mysql.com/doc/ in
vain.
What's the command to show all current locks on a
I say go with RAID 5, on a controller card.
Mirroring just gives you backup, and you lose half your diskspace. It offers
no performance benefit, and actually the computer might have to work harder
to make sure the drives are in sync.
Disk striping makes things *fast*, BUT THERE IS NO PROTECTION.
* Roger Baklund
[...]
> SET @a="";
> SELECT @a:=CONCAT(@a,' ',long_desc) FROM YourTable;
> SELECT @a;
Sorry, my test table only contained records for a single product... you
would need something like this:
SELECT @a:=CONCAT(@a,' ',long_desc)
FROM YourTable
WHERE pn = "HL1450"
ORDER BY seq;
Hi again,
> From: Diana Soares [mailto:[EMAIL PROTECTED]
> Sent: Thursday, August 21, 2003 4:05 PM
> | NOW() + sec_to_time(6000) |
That i allready tried, and it's leading to wrong results,
as same as
> From: Cybot [mailto:[EMAIL PROTECTED]
> Sent: Thursday, August 21, 2003 3:42 PM
> UPDATE `user
* Nick Heppleston
> I have a concatenation problem and I was wondering if somebody might be
> able to offer some help :-)
I can try. :)
> I have the following table structure holding product long descriptions:
>
> Part No (pn)Sequence (seq) Long Description (long_desc)
> --
Using an Apache/PHP/MySQL/Linux (Redhat 8.0) solution, PHPList, to create
an e-mailing list for our 5.6 million book club members. Unfortunately,
the import speed for importing records (at record number 150,000 the rate
is about 2,000 records per hour). We're running on the following:
P4 (1.5
Ich bin vom 05.08.2003 bis 28.08.2003 außer Haus.
Ich bin vom 06.08.03 bis einschließlich 28.08.03 auf Urlaub.
In dringenden Fällen wenden Sie sich bitte an meine Kollegen in der MPS.
Frau Juric, DW 212
Frau Sommer,DW 631
Herr Zwischenbrugger, DW 635
Herr Kessler, DW 217
Ab 28.08.03 stehe ich Ihn
Dear Friends
i´ve just download mysql 4.0.14
where i can find an mysqlclient.lib for borland c++compilers, the one on
windows download page is for version 3.23.xx
Regards
Luiz
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.c
Jesse Sheidlower wrote:
I'm struggling with speed issues on some queries that
I would have expected to be relatively fast. Perhaps
even more frustratingly, when I've tried to break
these down into their components, they still execute
very slowly. I've looked over all the relevant suggestions
for
What is the value of "sort_buffer_size", may be you could increase the value for
having faster ORDER BY (all in memory intead of using temporary file on disk).
Marc.
-Message d'origine-
De : Jesse Sheidlower [mailto:[EMAIL PROTECTED]
Envoyé : jeudi 21 août 2003 17:34
À : [EMAIL PROTECTED
On Thursday 21 August 2003 2:23, Jon Drukman wrote:
> if you're mostly running SELECTs then i would recommend a mirrored
> configuration.
I would say I am running about %50 SELECTS, 30% UPDATE, 20% INSERT. However I
don't know how to find that out for sure.
Would that affect how I set up the RA
I am sure if it's possible to do that, but I want to use mysqldump to backup
my databases. However, there is only one large table I want to exclude. Can
this be easily done?
Thanks.
Jay
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://list
On Thu, Aug 21, 2003 at 11:34:00AM -0400, Jesse Sheidlower wrote:
>
> I'm struggling with speed issues on some queries that
> I would have expected to be relatively fast. Perhaps
> even more frustratingly, when I've tried to break
> these down into their components, they still execute
> very slow
I have a concatenation problem and I was wondering if somebody might be
able to offer some help :-)
I have the following table structure holding product long descriptions:
Part No (pn)Sequence (seq) Long Description (long_desc)
--- ---
Jackson,
Jackson Miller <[EMAIL PROTECTED]> writes:
> I have 4 SCSI drives currently.
Well, is you want Redundancy you don't have a choice. Mirror them. 2x 2
drives.
You might want to put OS and write-ahead-log on one and
InnoDB/MyISAM-data on the other.
> I would like to have 1 drive run the
I'm struggling with speed issues on some queries that
I would have expected to be relatively fast. Perhaps
even more frustratingly, when I've tried to break
these down into their components, they still execute
very slowly. I've looked over all the relevant suggestions
for optimization and so fort
I like using either raid 0+1.. it really cooks, or if you can'y spare the
disks, raid 1 ...Something pushing that many queries, should probably
be protected from disk failure.
On Wed, 20 Aug 2003, Jackson Miller wrote:
> I am setting up a dedicated MySQL server with some pretty heavy usage.
This is my differential backup script. I've put it into cron so it runs
every hour automatically. I've a master sql dump files in
'/master/DBNAME' and I compare this file to the most recent dump and
calculate diff.
Basically it mysqldumps database without buffering (-q), by adding ' to
table and fi
Hi Victoria,
2003年 8月 21日 木曜日 20:20、Victoria Reznichenko さんは書きました:
> "Nils Valentin" <[EMAIL PROTECTED]> wrote:
> > 2003? 8? 21? ??? 16:09?Victoria Reznichenko :
> >> "Nils Valentin" <[EMAIL PROTECTED]> wrote:
> >> > This time I am using 4.0.13-max (tar format from www.mysql.com) on
> >> >
Hi,
You're adding 2 different type elements.
Try just doing
SELECT NOW() + SEC_TO_TIME(6000);
and check the result:
mysql> select NOW() + sec_to_time(6000);
+---+
| NOW() + sec_to_time(6000) |
+---+
|20030821159528 |
+-
M. Bader wrote:
Hi,
i'm struggling with updating session expire times in my login table.
Can you tell me, how to correctly add an amount of seconds (after that
the session expires) to a datetime field?
when i do the insert for a new login, or an update, the expire field
will alway end up contain
It may be that you did not give the mysql user ownership of the Data
folder?
Check your permissions first by typing:
[KieranMac:~] kieran% ls -al /usr/local/mysql/
this shold show data folder as something like this:
drwxr-x--- 13 mysql wheel 442 Aug 19 19:52 data
Type this on the co
"Devang Panchalia" <[EMAIL PROTECTED]> wrote:
> Hi,
> I have downloaded MySql-standard-4.0.12 FOR MAC from the MySql website.
> I have installed it on Mac OS X 10.1.3.
> When i am starting the MySql, it starts and ends with the message
> "030821 MySqld ended".
> Does anyone know what the pro
Hi,
I've created some fulltext indexes and would like to
know the size in bytes of each one.
Someone would please help me on that?
Thanks in advance!
Cleber Melo
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROT
- Original Message -
From: "Jon Drukman" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, August 20, 2003 9:28 PM
Subject: [EMAIL PROTECTED] Re: apache/mysql errors
> grant select on *.* to [EMAIL PROTECTED] identified by 'yourpasswordhere';
[...
Just a quick note to Ed and Amer,
You two were right on, with this. I took the plunge and re-thought my db as
you both suggested. Sage advice, as successive queries and relationships
have been much easier to achieve with the new allocation table. It's clear
to see that this method also will offer
Ich bin vom 15.08.2003 bis 01.09.2003 außer Haus.
Ich werde Ihre Nachrichten nach meiner Rückkehr beantworten.
Während dieser Zeit erreichen Sie meine Vertretung Fr. Renate Trummer unter:
Tel. 0316/8056-514
Fax 0316/8056-400
E-Mail [EMAIL PROTECTED]
Hi,
i'm struggling with updating session expire times in my login table.
Can you tell me, how to correctly add an amount of seconds (after that
the session expires) to a datetime field?
when i do the insert for a new login, or an update, the expire field
will alway end up containing zeros
below
Ich bin vom 08.08.2003 bis 24.08.2003 außer Haus.
Ich werde Ihre Nachricht nach meiner Rückkehr beantworten.
VR> User has some privileges on the global level (CREATE
VR> TEMPORARY TABLES, LOCK TABLES). That is why user can see list of
VR> all databases.
All right! :) It works, thanks! :)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql
"Nils Valentin" <[EMAIL PROTECTED]> wrote:
> 2003? 8? 21? ??? 16:09?Victoria Reznichenko :
>> "Nils Valentin" <[EMAIL PROTECTED]> wrote:
>> > This time I am using 4.0.13-max (tar format from www.mysql.com) on Redhat
>> > 9.
>> >
>> > When I issue the command mysqlbinlog it does not show me
1 - 100 of 145 matches
Mail list logo
