Re: Changing a field's data in every record

On Sat, 18 Feb 2017, debt wrote: How does one "grab" the existing data and then change it? Can this be done solely in MySQL I am not sure to understand your question ... you usually manipulate data inside mysql ... but here it seems to me you are not talking of changing the

using indices with SMALL tables

Now what had taken 38 minutes takes 3.02 sec !!! Great ! -- -------- Lucio Chiappetti - INAF/IASF - via Bassini 15 - I-20133 Milano (Italy) For more info : http://www.iasf-milano.inaf.it/~luci

Re: get row inserted time or modified time

On Tue, 2 Jun 2015, Selvam Gce wrote: Is there any way to get row inserted time or modified time in my mysql table??? if you define a column with any name and a type of timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP this will automatically timestamp each record

Re: Select one valuebut not the other

| -- Lucio Chiappetti - INAF/IASF - via Bassini 15 - I-20133 Milano (Italy) For more info : http://www.iasf-milano.inaf.it/~lucio/personal.html Do not like Firefox =29 ? Get Pale Moon ! http

Re: store search result as new table in memory

the table later to add them. if they are big, using proper indices is a must to get quick responses. -- Lucio Chiappetti - INAF/IASF - via Bassini 15 - I-20133 Milano (Italy) For more info : http://www.iasf-milano.inaf.it

Re: ssh basics

a select into a table, and read back the output in an IDL structure) but I never managed to do it. But I did not try hard. -- Lucio Chiappetti - INAF/IASF - via Bassini 15 - I-20133 Milano (Italy) For more info : http

Re: Users and Groups

-- Lucio Chiappetti - INAF/IASF - via Bassini 15 - I-20133 Milano (Italy) For more info : http://www.iasf-milano.inaf.it/~lucio/personal.html Do not like Firefox =29 ? Get Pale Moon ! http

Re: mysql float data type

16. So if a quantity needs high precision (typically this occurs for angular quantities where arcseconds are important), use double. -- Lucio Chiappetti - INAF/IASF - via Bassini 15 - I-20133 Milano (Italy) For more info

Re: forum vs email

one. -- Lucio Chiappetti - INAF/IASF - via Bassini 15 - I-20133 Milano (Italy) For more info : http://www.iasf-milano.inaf.it/~lucio/personal.html Do

RE: How MyISAM handle auto_increment

. -- Lucio Chiappetti - INAF/IASF - via Bassini 15 - I-20133 Milano (Italy) Citizens entrusted of public functions have the duty to accomplish them

Re: How MyISAM handle auto_increment

. -- Lucio Chiappetti - INAF/IASF - via Bassini 15 - I-20133 Milano (Italy) Citizens entrusted of public functions have the duty to accomplish them with discipline and honour [Art. 54 Constitution

Re: int(10) va int(11)

, but sometime affect also comparison and that's very annoying if you work usually with numbers like 1.43E-12 ! -- Lucio Chiappetti - INAF/IASF - via Bassini 15 - I-20133 Milano (Italy

Re: Record old passwords ?

no real life application (unless perhaps one is a spy) which really require this degree of security ! -- Lucio Chiappetti - INAF/IASF - via Bassini 15 - I-20133 Milano (Italy

using Unix soft links

intrinsically wrong in the usage of soft-links, or whether this might be an indication instead of hardware problems with our machine or disks ! -- Lucio Chiappetti - INAF/IASF - via Bassini 15 - I-20133 Milano (Italy) For more info : http://www.iasf-milano.inaf.it/~lucio/personal.html

Re: optimizing UNIONs ?

be automatized). -- Lucio Chiappetti - INAF/IASF - via Bassini 15 - I-20133 Milano (Italy) For more info : http://www.iasf-milano.inaf.it/~lucio/personal.html

optimizing UNIONs ?

of the various indices present in the individual tables ? It shall be noted that the various member tables are all of comparable length with just a few thousand records each. -- Lucio Chiappetti - INAF/IASF - via Bassini 15

Re: excessive time spent in statistics status

) changed according to the content of the query (e.g. the particular WHERE condition). So for me experimentally use of SELECT STRAIGHT_JOIN is an effective solution. -- --- Lucio Chiappetti - INAF/IASF - via Bassini 15 - I-20133

Re: excessive time spent in statistics status

On Tue, 4 Sep 2007, Shawn Green wrote: On Tue, 4 Sep 2007, Lucio Chiappetti wrote: For each I tested 3 cases (total 16*3=48) : a) the query on the virtual table correlated with the external (the virtual is my G left join t1 ... left join tn). [...] represents my REFERENCE

Re: excessive time spent in statistics status

and report back. -- --- Lucio Chiappetti - INAF/IASF - via Bassini 15 - I-20133 Milano (Italy) For more info : http://www.iasf-milano.inaf.it/~lucio/personal.html

Re: excessive time spent in statistics status

On Tue, 4 Sep 2007, Lucio Chiappetti wrote: I'll do some experimenting and report back. In lack of better ways of doing a tie-break, I've done the following tests (with the linemode client), checking both the results of a query and the total time spent. I tested 16 different combinations

Re: excessive time spent in statistics status

: Lucio Chiappetti wrote: I have some queries, involving a largish number of JOIN, which are [...] very slow or [...] remain in the statistics status [forever] This involved creating a working table G [...] The simultaneous access was achieved in our interface by a mechanism we called

excessive time spent in statistics status

. -- --- Lucio Chiappetti - INAF/IASF - via Bassini 15 - I-20133 Milano (Italy) For more info : http://www.iasf-milano.inaf.it/~lucio/personal.html --- -- MySQL General

echoing comments in mysql (changed 4.0 to 5.0 ?)

on that ! -- Lucio Chiappetti - INAF/IASF - via Bassini 15 - I-20133 Milano (Italy) For more info : http://www.iasf-milano.inaf.it/~lucio/personal.html