 | | | MySQL General | | Hello
this is a continued problem we are having from a earlier posting to the list
regarding a query. We need to calculate the SUM of the column
'agent_product_time ' which is a TIME datatype columThe short answer is "in the config file. " The long answer is to read
http //dev.mysql.com/doc/refman/4.1/en/log-files.html
Or whatever manual version is appropriate to your MySQL version.
-SheeriI 'm doing a little something for the earth and I thought I 'd invite
you to join me
http //friends.earthscreen.com/?r UQF0KDIIICdXCWoICigC&i gmail&ml mysql@(protected)&p 2&z 1&tc#
--
MySQL GeneI 've got a backup that is scheduled by MySQL Administrator which appears to be happening without a problem. However I just tried to restore that backup on my machine and the data doesn 't appear to > > I 'm fairly new to all this and duing everything step by step...
> >
> > I made my first (test) php site - and it works... then i have this
> > script
> > where i 'm supposed to find out if MySQL aHello
MySQL 4.1.12
trying to figure out why I keep getting this error with the following query
SELECT c.account_id a.name a.company SUM(c.agent_product_time) AS mins
FROM account a LEFT JOIN cal > I 'm creating a new MySQL database from an existing Filemaker db.
>
> My problem is that some of the existing 'numbers ' in one column (it
> was a text field in FMP) have leading zeros. eg 003 00Hi
I need to upgrade a server from Solaris 8 to Solaris 10. There is one
MySQL server running on it (the binary
mysql-standard-4.1.15-sun-solaris2.8-sparc from mysql.com) do I need
to upgrade MySQ
Hi All
Does anybody have some advise on automating the install of mySQL and our DB
on a PC/Laptop with no user interaction required.
Does the SETUP.EXE take any paramaters to auto install witI 'm having some trouble writing this trigger and wasn 't sure what I 'm
doing wrong. My goal is after a row has been added to tcphdr it will
pull data from several other tables based on the NEW rows evePeng Yi-fan schrieb
> Hi
>
> I would like to change the path of a database 's log. Which command I should choose?
>
> Thanks.
>
> Peng
Change the config files ?
--
Smileys rule (cX.x)C --o(^_^o)I don 't know what version you 're running but a
mysql -?
will show you the variables you can set. It 's not ALL variables you
can set that way just a few. You will see that the variable you 're
tryiHello everyone!
The mysql documentation doesn 't show any good infos er examples about
writing procedures.
To be more specific
I have a table with saved clicks by users.
Now i want to draw a grapI 've had this same problem -- if the database loses connection at the
same time the log file flushes you need to SET MASTER_LOG_FILE and
MASTER_LOG_POS again and restart. I believe this probably quaBarry wrote
> Hello everyone!
> <snip >
> I have a table with saved clicks by users.
> Now i want to draw a graph with a php extension.
> Problem is if i let me show the clicks one day is missing.
>Daevid
> This is my first trigger I 'm trying to write.
>
> I have two tables. 'stores ' and 'zipcodes '.
>
> I want to automatically set the latitude and longitude of the store using
> it 's zipcode loAs a word of advice before posting to any list please RTFM (Read The Fine
Manual).
You have to escape all "special characters " like apostrophes and single
quotes with the backslash.
INSERT INTO Check out line 1 of the fill_help_tables.sql file. (on my
installation it was in /usr/share/mysql) See if there is an errant ".
There shouldn 't be of course but that 's the problem according to
MyAnd why we are not informed on the progress of it? Because of this *severity
1* bug I and many people cannot upgrade to 5.x release.
http //bugs.mysql.com/bug.php?id 15269
Gokhan
I have a few large databases each has over 1 000 tables. If I use the "SHOW
tables " statement then mysql returns all the names of the tables in any
one of my large databases in about 0.07 seconds. VIn the last episode (May 12) Ferindo Middleton said
> Suppose you have a field in a db table that holds email addresses and all of
> the address end in domain.com. Is there a MySQL function that canHi Sheeri
No I wanted to search through both columns in the same time (and it
will be always at the same time) - the problem was I didn 't know that I
have to have one multi-column index.
)
But iSo our MySQL master database crashes about once a week then
immediately recovers. We are running a Dell 2850 -- 64-bit Fedora Core
3 box with 6G of memory 4 Intel Xeon processors at 3.60 GHz speedHey folks I 'm trying to crate a view that runs a stored procedure. Can
anyone tell me what I might be doing wrong or if what I 'm trying it
possible?
Here is what I get
mysql > create view v as CALL
----- Original Message -----
From "Steffan A. Cline " <steffan@(protected) >
To <mysql@(protected) >
Sent Friday May 12 2006 1 38 PM
Subject Returning records in a circle
> Is there a way I c
Hi
MySQL 4.0.27 a new version of the popular Open Source Database
Management System has been released. The Community Edition is now
available in source and binary form for a number of platforms f > > 1) Is there a way to see MySQL using both processors? Is SMP helpful in
> > this case? (This server is dedicated to MySQL only one instance).
>
> PS (*nix) should tell you how your processors are abhishek jain schrieb
> Hi all
> I have been using mysql from last few years but for small projects only
> recently i have been on to some good projects I want toknow what is the
> best coding praFolks
I had some recommendations about operating system last time I posted and
decided to follow it. It 's been a couple of weeks running Gentoo Linux
2006.0 SMP 2.6.15-gentoo-r5 with glibc 2.4 (Adam Lipscombe wrote
>Folks
>
>
>We have a commercial product that uses mysql 4.0.24. We bought a commercial
>licence for this version.
>We want to upgrade to 5.0.21.
>
>I spoke with the MySQL sa |
|
|
