|
 |
On Jan 16, 6:25 am, Captain Paralytic <paul_laut...@yahoo.com> wrote:
>
> You could start here:http://www.databaseanswers.org/data_models/index.htm
Thanks, Cap, these are helpful!
lawpoop
|
14th December 2010 11:45
by lawpoop 
|
7 |
361 |
|
|
|
I'm working on an application that uses IPv6 addresses in the
database. For IPv4 addresses, it's pretty simple, you make the data
INTEGER UNSIGNED and use INET_ATON() and INET_NTOA() to translate to
and from the usual text display format.
Is there a common way to handle IPv6 addresses? I'm...
John Levine
|
|
0 |
292 |
|
|
|
Send mail on event
Outlook.Application outLookApp = new Outlook.ApplicationClass();
outLookApp.ItemSend += new
Microsoft.Office.Interop.Outlook.ApplicationEvents_11_ItemSendEventHandler
(Application_SendItem);
But if I write the event into a file, all ok.
void...
win
|
14th December 2010 11:45
by win
|
0 |
231 |
|
|
|
Doug Miller wrote:
> In article <026a43bd-6930-4c26-bbc7-0b35f6d8cec3@22g2000yqr.googlegroups.com>, JustWondering <eastsidedev@gmail.com> wrote:
>> I know this is a PHP group, but when I search the google groups for
>> MySQL, I get pointed to this group. If you have a better
>> recommendation...
The Natural Philosopher
|
|
0 |
230 |
|
|
|
Hallo,
Can someone help me to improve my query ?
In first table - 'tasks' I have two datetime field: d_start and d_stop.
Second table - working_minutes I have one field - date.
The second table contains list of working minutes.
I want to calculate how long last the task :
pluton
|
14th December 2010 11:45
by pluton
|
0 |
221 |
|
|
|
On Fri, 08 Jan 2010 18:55:31 +0000, iass wrote:
> On Thu, 07 Jan 2010 23:10:56 +0100, Axel Schwenke wrote:
>
>> Hi,
>>
>> iass <iass@gmail.com> wrote:
>>
>>> I did some more monitoring on the Mysql server and on the client and I
>>> can see that after two hours the Mysql Server sends 9...
iass
|
|
14 |
261 |
|
|
|
Captain Paralytic wrote:
> On Jan 16, 6:57 am, "sl@my-rialto" <ecp_...@my-rialto.com> wrote:
>> Scenario
>> ---------
>> 1. My client has a database on its web server.
>>
>> 2. I am running a portal on another web server.
>>
>> 3. At a particular time, I need to update my client's database....
sl@my-rialto
|
|
5 |
219 |
|
|
|
;
>
> What happens?- Hide quoted text -
>
> - Show quoted text -
I was getting various errors relating to fields, the END statement and
the correct use of Delimiter. I've now fixed everything and the
following code works a treat:
CALdan
|
14th December 2010 11:45
by CALdan
|
8 |
242 |
|
|
|
Peter H. Coffin wrote:
> On Fri, 15 Jan 2010 12:03:06 +0000, The Natural Philosopher wrote:
>> access it remotely and slowly from home, and fast from work.
>>
>> If you build a decent web app to access it, and don't transfer huge
>> amounts of data, it will be no slower anyway.
>>
>> The...
David
|
|
4 |
249 |
|
|
|
I intend to create a database to enumerate / explore a large search
space. It'll grow to any available capacity - I've got about 350GB
available, and I intend to use it all. The solution space probably
converges way beyond my available storage space, but I want to try it
anyway.
The...
ReaanB
|
14th December 2010 11:45
by ReaanB
|
0 |
221 |
|
|
|
On Jan 12, 4:17 pm, Frank Peterson <fictionalper...@gmail.com> wrote:
> Well if I do
>
> SELECT g.title AS title, g.slug AS slug FROM band AS g, genre AS p
> WHERE g.genre = p.id AND p.slug='blink-182' ORDER BY RAND() LIMIT 10
>
> I get 10 records back, but its slow.
That may not be...
Frank Peterson
|
14th December 2010 11:45
by toby
|
8 |
243 |
|
|
|
On Jan 12, 6:40 am, The Natural Philosopher <t...@invalid.invalid>
wrote:
> bill wrote:
> > I am an experienced programmer, new to PHP.
> > Jerry has consistently been helpful, even if a bit acerbic at times.
> > Other philosophers, not so much.
>
> > bill
>
> lucky you. But wait....
The Natural Philosopher
|
|
22 |
268 |
|
|
|
Thank you all for responding, I used Toby's solution because it looks
simple and I understand the query ;)
Thanks again,
BPG
BPG
|
14th December 2010 11:45
by BPG
|
6 |
252 |
|
|
|
>to use the software.
>Short of modifying the database names in my application, how can I
>have separate databases for each user but with the same schema on the
>same server?
Duplicating a schema in serveral databases is easy. mysqldump -d
dumps tables without the data in them. Dump once,...
SpreadTooThin
|
|
1 |
242 |
|
|
|
On Sat, 9 Jan 2010 06:17:00 -0800 (PST), ravel wrote:
> On 9 Jan., 15:05, Jerry Stuckle <jstuck...@attglobal.net> wrote:
>> ravel wrote:
>> > On 9 Jan., 13:50, Jerry Stuckle <jstuck...@attglobal.net> wrote:
>> >> ravel wrote:
>> >>> On 9 Jan., 03:05, Jerry Stuckle <jstuck...@attglobal.net>...
ravel
|
|
23 |
230 |
|
|
|
Robert Hairgrove <rhairgrove@bigfoot.com> wrote in news:daacb$4b483f92
$d9a28130$28069@news.hispeed.ch:
> Jason wrote:
>>
>> create trigger avg_inc_trig after update on pst
>> for each row
>> update pst set new.avg_daily_inc = ((new.size-new.start_size) / datediff
>> (new.date,...
Jason
|
14th December 2010 11:45
by Jason
|
3 |
240 |
|
|
|
toby wrote:
> On Jan 9, 7:46 am, The Natural Philosopher <t...@invalid.invalid>
> wrote:
>> Erick T. Barkhuis wrote:
>>> The Natural Philosopher:
>>>> Erick T. Barkhuis wrote:
>>>>> The Natural Philosopher:
>>>>>> Joe Makowiec wrote:
>>>>>>> On 09 Jan 2010 in comp.databases.mysql, The...
The Natural Philosopher
|
|
8 |
248 |
|
|
|
On Jan 8, 12:15 am, bruce <bruc...@bellsouth.net> wrote:
> I am trying to reset a field
>
> UPDATE addresses SET telephone = NULL WHERE addressid=114;
>
> Field telephone is defined as NOT NULL. I can change NULL to
> "" (double quotes) but would prefer NULL, if that is possible.
>
> Is...
bruce
|
|
4 |
234 |
|
|
|
"Ross" <ross@nospam.ca> wrote:
> I'd like to duplicate all tables within a database.
> I know how to duplicate individual table like this:
> CREATE TABLE new_table1 LIKE old_table1;
> INSERT INTO new_table1 SELECT * FROM old_table1;
>
> But I have hundreds of tables. It's hard to...
Ross
|
|
7 |
244 |
|
|
|
Arne Vajhøj wrote:
> On 27-11-2009 22:29, Jerry Stuckle wrote:
>> Arne Vajhøj wrote:
>>> Jerry Stuckle wrote:
>>>> Arne Vajhøj wrote:
>>>>> Jerry Stuckle wrote:
>>>>>> Arne Vajhøj wrote:
>>>>>>> Axel Schwenke wrote:
>>>>>>>> You should not keep a MySQL connection open if you don't need it.
>>>>>>>> Unlike...
RVic
|
|
14 |
224 |
|
|
|
On Dec 30 2009, 11:15 am, Sherm Pendley <spamt...@shermpendley.com>
wrote:
> Banana <Ban...@Republic.com> writes:
> > JRough wrote:
> >> Is it working?
>
> > If you can connect via mysql client, then it's working.
>
> Yep. The absence of any error messages is a good sign though!
>
(
1
2
)
JRough
|
14th December 2010 11:45
by JRough
|
35 |
538 |
|
|
|
On 4 Jan, 11:11, ChrisW <c.c.w...@gmail.com> wrote:
> On Jan 3, 9:02 pm, Captain Paralytic <paul_laut...@yahoo.com> wrote:
>
>
>
> > On Jan 3, 7:52 pm, ChrisW <c.c.w...@gmail.com> wrote:
>
> > > Dear all,
>
> > > Although I'm using MySQL, this is more of a general SQL question, so
ChrisW
|
14th December 2010 11:45
by Lennart
|
3 |
242 |
|
|
|
> The data from the "custom_data" fields contains key/value pairs which
> I want to use to update the fields in that same row. For example, if
> you parse custom_data, in row 1, I want to update the column "Agry"
> with the value paired with to the "Agry" key. I've written some SQL
> already...
Casey
|
|
2 |
223 |
|
|
|
On Dec 24, 4:59 am, "Greg Russell" <gruss...@invalid.com> wrote:
> Innews:bb3017f3-4795-4984-825a-fdc13df5aedf@z10g2000prh.googlegroups.com,
> JRough <jlro...@yahoo.com> typed:
>
> >> The README in the code you say you downloaded contains no
> >> installation instructions. The MySQL code you...
JRough
|
|
12 |
246 |
|
|
|
On Dec 28, 5:49 pm, alberto <alberto.pri...@gmail.com> wrote:
> Hi,
> if in my web application I started to save data in MyISAM I can at any
> time to bring them to innodb?
>
> thanks in advance
As well as what Jerry mentioned, InnoDB doesn't support FULLTEXT
whereas MyISAM does, so if you...
alberto
|
|
2 |
244 |
|
|
|
Steffan A. Cline wrote:
> in article hhllne$4gh$1@news.eternal-september.org, Jerry Stuckle at
>> I've read Monty's blog. It's full of conjecture and possibilities. The
>> only real fact in it is the most important one. It is owned by Oracle.
>> And they can keep it going or kill it - or...
Steffan A. Cline
|
|
10 |
237 |
|
|
|
The Natural Philosopher wrote:
> Erick T. Barkhuis wrote:
>> Jerry Stuckle:
>>
>>> houghi wrote:
>>>> Peter H. Coffin wrote:
>>>>>> I would use enum. In the case that somebody invents a new
>>>>>> voice, you just add it.
>>>>> That requires a table alteration which (in my little world)...
Derek Turner
|
|
17 |
494 |
|
|
|
Erick T. Barkhuis wrote:
> Jerry Stuckle:
>
>> Erick T. Barkhuis wrote:
>
>>> Those people are probably RDB designers, not data analysts. In data
>>> analysis, there's no such thing as a row number or a "unique entity
>>> for a row".
>>>
>> Actually, there is the concept of a unique entity...
Derek Turner
|
|
25 |
290 |
|
|
|
Thanks!
On Dec 28, 9:46 am, Jerry Stuckle <jstuck...@attglobal.net> wrote:
> gamename wrote:
> > Hi,
>
> > I need to make a copy of a db. This is for testing purposes. The
> > copy will be resident on the same machine.
>
> > So, a 'show databases' would look like:
gamename
|
|
2 |
244 |
|
|
|
On Dec 27, 1:32 pm, Dikkie Dik <dik...@nospam.org> wrote:
> Ryan Chan wrote:
> > In Oracle, the way to create auto-increment field is to create a
> > sequence and update via trigger.
>
> Why do you have to define a sequence if you still have to write a trigger?
Sequences may be directly...
Ryan Chan
|
|
14 |
285 |
|
|
|
El 27/12/2009 5:45, Ccming escribió:
> I like MYSQL Administrator.
> I like MYSQL Query Browser.
> I like MYSQL System Tray Monitor.
> Please don't take away them. thanks.
In case someone else was wondering what's this all about:
"EOL of MySQL Query Browser, MySQL Administrator, MySQL...
Ccming
|
|
3 |
235 |
|
|
|
I'm using the "Ruport" packaeg of Ruby on Rails to do it -- a little
arcane, I know! -RVInce
> > The 'Time' column is the first (leftmost) returned, when, in fact, I
> > am specifying that I want it as the last (rightmost) column returned.
> > How can I get it to be the last column returned, or...
RVince
|
14th December 2010 11:45
by RVince
|
2 |
229 |
|
|
|
>> Indexes are usually not mandatory.
>
>So it's OK with you if I not bother adding any more indexes than I
>already have?
I'm not the one who's going to complain if your site turns out to
be unbearably slow, or never goes production in the first place..
What do you have against...
Robert Maas, http://tinyurl.com/uh3t
|
|
17 |
279 |
|
|
|
On 23 Dec, 09:34, David <david.greenh...@gmail.com> wrote:
> On 22 Dec, 17:30, "Álvaro G. Vicario"
>
>
>
> <alvaro.NOSPAMTH...@demogracia.com.invalid> wrote:
> > El 22/12/2009 18:13, David escribió:
>
> > > Hoping someone could point me in the right direction, i am trying to
> > > run a report...
David
|
14th December 2010 11:44
by David
|
3 |
228 |
|
|
|
On Fri, 18 Dec 2009 15:33:49 +0000, Radoulov, Dimitre wrote:
> Thank you very much for bearing with me, Jerry and Johannes!
> It's definitely because of my English,
> I was confused because of that MySQL: 5.0 listed in the affected systems
> section.
The "alpha" part can be a problem when...
Radoulov, Dimitre
|
|
7 |
212 |
|
|
|
Peter H. Coffin wrote:
> On Sun, 20 Dec 2009 18:44:48 +0000 (UTC), D Finnigan wrote:
>> Jerry Stuckle wrote:
>>> D Finnigan wrote:
>>>> Banana wrote:
>>>>> As suggested already, FULLTEXT indexing will probably be much better
>>>>> at
>>>>> this. If there is a specific reason why you don't...
D Finnigan
|
|
8 |
203 |
|
|
|
Thank you for your help.
My connections are only local and agalf is not a root.
But the problem remains unsolved.
I have a trace file mysql error in my PHP site.
This file gives me the url, the query mysql, type, mysql error, time,
the browser that caused the error.
First, I find no...
user@domain.invalid
|
|
10 |
221 |
|
|
|
Banana wrote:
> Jerry Stuckle wrote:
>> Which is an entirely different situation than what the original op wants.
>>
>
> Hmm. OP stated in his post:
>
> Select * from Table where UTC_TIME(currentRecord-previousRecord)>=P
>
> Anything that attempts to compare a record in a table against a
fittizio
|
|
11 |
207 |
|
|
|
Banana, domenica 20 dicembre 2009 19:26:
> 1) You're using a correlated subquery. Generally, joins should be
> preferred over a correlated subquery.
I agree, but i don't know how to convert the subquery in a join. I've
googled a bit, but i've not found a way to do it.
> 2) It seems that...
Giovanni
|
|
3 |
232 |
|
|
|
Vilius wrote:
>
> Should be something like this I think:
>
> $query = "SELECT files.id, files.filename, users.username, files.date,
> files.rating, files.featured, ratings.myrating
> FROM (files INNER JOIN users ON files.userid = users.id) LEFT JOIN
> ratings ON files.id = ratings.fileid...
Bint
|
|
13 |
212 |
|
|
|
Taliesin Nuin wrote:
> Jerry Stuckle wrote:
>
>> I haven't seen anything for it. But why not just put all the SQL to
>> build the database in a file and execute it from the mysql command
>> prompt, using the "source" command?
Actually, the ability to extract table definitions in XML and...
Taliesin Nuin
|
|
12 |
833 |
|
|
|
John Nagle wrote:
> The Natural Philosopher wrote:
>> When I edit a form I tend to read the entire record subset (or in many
>> cases records) off the database, and update everything whether or not
>> a field, row or table has changed.
>>
>> I was wondering if this actually results in a call...
The Natural Philosopher
|
|
15 |
200 |
|
|
|
On Dec 3, 3:37 pm, lawpoop <lawp...@gmail.com> wrote:
> Is there a command to see how much total resources were used to
> construct a result set?
>
Not yet: MySQL has a profiler built into it as of 5.0.37:
http://dev.mysql.com/tech-resources/articles/using-new-query-profiler.html
But...
lawpoop
|
14th December 2010 11:44
by lawpoop
|
9 |
199 |
|
|
|
I wrote an article about full join in mysql some time ago (in spanish)
http://disemq21.blogspot.com/2009/08/another-mysql-full-join.html
SELECT b.host,
one.host AS one, one.ip,
two.host AS two, two.ip,
three.host AS three, three.ip
FROM (
SQL newbie
|
14th December 2010 11:44
by edward
|
7 |
237 |
|
|
|
El 15/12/2009 17:11, Taliesin Nuin escribió:
> Ãlvaro G. Vicario wrote:
>> El 15/12/2009 15:56, Captain Paralytic escribió:
>>> On 15 Dec, 11:28, "Erick T. Barkhuis"<erick.use-...@ardane.c.o.m>
>>> wrote:
>>>> Captain Paralytic:
>>>>
>>>>> On 15 Dec, 10:09, Taliesin Nuin<tn...@bath.ac.uk>...
Derek Turner
|
|
10 |
199 |
|
|
|
On Fri, 11 Dec 2009 13:45:00 +0000, Taliesin Nuin wrote:
> You realise this is going to be something really simple and annoying
> when you finally work it out, right? ;)
>
> Taliesin.
>
>
> But yes, to proceed we probably need the logs. They'll probably be at
Derek Turner
|
|
12 |
204 |
|
|
|
Hi all,
can any one have mysql cerfification model question papers or
materials . If any one have could you share with group.
thanks and regards
sudheer kumar
sudheer
|
14th December 2010 11:44
by sudheer
|
0 |
220 |
|
|
|
Hi everybody,
database is cheap ;-)
Ah, ok, i didn't understand that,
thanks a lot.
--
kevin kitenik
|
|
9 |
211 |
|
|
|
On 10 Dez., 12:27, Axel Schwenke <axel.schwe...@gmx.de> wrote:
> Yukari <yukaricha...@googlemail.com> wrote:
> > On 8 Dez., 14:46, Axel Schwenke <axel.schwe...@gmx.de> wrote:
> >>I suggest to log anything into the binlog and do any filtering on the
> >>slave side.
> > How can I do that?
>
>...
Yukari
|
14th December 2010 11:44
by Yukari
|
13 |
216 |
|
|
|
Hi, everyone
This set of ideas was originally inspired by the adressbook of the mail
client sylpeed-claws where you can define your own keys for each entry.
The basic features is: The user can define his own models (adress,
person, website...) and properties (surname, domain...) according...
Walter Anger
|
|
0 |
199 |
|
|
|
Thanks Jerry - appreciated.
Michael.... and btnw ;-)
btnw
|
14th December 2010 11:44
by btnw
|
2 |
187 |
|
|
|
My replication server is segfaulting for a reason that is currently
unknown. The log is as follows below:
091207 15:16:11 Neither --relay-log nor --relay-log-index
were used; so replication may break when this MySQL server acts as a
slave and has his hostname changed!! Please use...
mahmoud abdelkader
|
|
0 |
238 |
|
|
|
s-roughs-power-mac-g5.local.pid
> tee: /usr/local//usr/local/mysql-5.0.82-osx10.5-powerpc/data/janis-
> roughs-power-mac-g5.local.err: No such file or directory
> 091204 09:16:26 mysqld ended
> tee: /usr/local//usr/local/mysql-5.0.82-osx10.5-powerpc/data/janis-
>...
JRough
|
14th December 2010 11:44
by JRough
|
1 |
207 |
|
|
|
> I am looking for some advanced level MySql Tutorials/questions that I
> can use for practice .
>
> Your replies are welcome ..
Forgive me for shamelessly plugging my own howto:
http://www.howtoforge.org/node/4833
Best regards,
Rahul
|
|
6 |
210 |
|
|
|
On 2009-12-03, Martijn Tonies <m.tonies@upscene.removethis.com> wrote:
>
> Make sure you have a SINGLE Foreign Key constraint per
> case, you can set both the ON DELETE and ON UPDATE
> attributes per foreign key constraint.
>
>> mysql> update people set userid = "foo" where userid = "bar";...
Patrick Nolan
|
|
8 |
206 |
|
|
|
>
> Which manual? I am working out of a big PHP and MySql development
> book, but it does not go into enough detail for me on table joining.
> Thanks
> Bob
See my paper join types here
http://www.gplivna.eu/papers/sql_join_types.htm
Gints Plivna
Bob Sabiston
|
|
10 |
224 |
|
|
|
Jason Carlton wrote:
> My script is written in Perl. It opens the database at the beginning,
> then there are several IF-ELSE statements that lead to subroutines,
> then it disconnects.
>
> Something like this:
>
> $dbh = DBI->connect("dbi:mysql:mydb", $DBUSER, $DBPASS), {'RaiseError'
> =>...
Jason Carlton
|
|
3 |
210 |
|
|
|
"The Natural Philosopher" <tnp@invalid.invalid> wrote in message
news:hem3cf$j0l$1@news.albasani.net...
>I have a table called 'category'
>
> >show fields in category;
> +-------------+------------------+------+-----+---------+----------------+
> | Field | Type | Null | Key...
The Natural Philosopher
|
|
5 |
227 |
|
|
|
Franz wrote:
> Richard ha scritto:
>
>> Dont judge too soon here, we know nothing of the guys situation.
>>
>> I can think of valid reasons to store a sum, historical reports is one.
>>
>> Easy to shout "booboo" from a distance...
>>
>
Franz
|
|
22 |
213 |
|
|
|
On 24 Nov, 19:31, Chris <matchett...@googlemail.com> wrote:
> My query doesn't work on the occassion that transaction_id is null,
> which may be the case.
Please define "doesn't work". I think you will find that the query
does precisely what it is supposed to do in the circumstances, so from...
Chris
|
|
3 |
213 |
