Amongst the common questions it is explained how to make Mac Eudora filter
MySQL-list email based on the added header-line "List-ID". The explanation is
just as good for Windows Eudora, no need to limit it to Macintosh.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/m
MYSQLDUMP.EXE (Ver 10.13 Distrib 5.5.8, for Win32 (x86)) has flags for
trigger-dumping; the help that I downloaded for this version says it dumps
triggers--but it does not. Now what?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.m
Once more I am surprised by the ordering that I get from 'GROUP BY'.
This defines the table of directors that have been on the board:
CREATE TABLE DIRECTOR
( Chosen DATE NOT NULL
, Through DATE NOT NULL
, MemberIDINTEGER REFERENCES MemberAddress (MemberID)
, CONST
2012/05/25 14:57 +0700, HaidarPesebe
id | name | parentid
--
1 | cat A | 0
2 | cat B | 0
3 | subcat A | 1
4 | subcat A | 1
5 | subncat B | 2
-
I want to display the result like this:
1. Cat A
- Subcat A
- Subcat A
2. Ca
2012/05/28 12:54 +0700, HaidarPesebe
select id,name from TABLE WHERE parentid='0'
and a second call to the same table as this;
select id,name from TABLE WHERE parentid='$id' (this $id is the result of
calling the first call TABLE)
Others have said, and I agree, you have a graph
2012/05/28 08:03 -0700, Don Wieland
Any assistance would be appreciated. Thanks!
Maybe something like this:
SELECT usie.client_id, first_name, last_name, COUNT(anie.client_id)
FROM
(SELECT client_id, first_name, last_name, time_start
FROM tl_appt
JOIN tl_rooms USING(room_id)
**
Scanned by MailScan AntiVirus and Content Security Software.
Visit http://www.escanav.com for more info on eScan and X-Spam.
**
--
MySQL General Mailing List
For list arch
2012/06/15 18:14 +0900, Tsubasa Tanaka
try to use `LOAD DATA INFILE' to import from CSV file.
http://dev.mysql.com/doc/refman/5.5/en/load-data.html
"Try" is the operative word: MySQL s character format is _like_ CSV, but not
the same. The treatment of NULL is doubtless the bigg
To endow CREATE VIEW with COMMENT would be splendid.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
A director s term ends in a given year, but at no given time of year; depends
on the yearly meeting.
I thought I would try YEAR to record it--but, in spite of
http://dev.mysql.com/doc/refman/5.5/en/year.html , simply assigning NOW() to
such a type does not work. There is also no implicit conver
2012/07/23 11:54 -0700, Rick James
mysql> SELECT YEAR(NOW());
+-+
| YEAR(NOW()) |
+-+
|2012 |
+-+
mysql> SELECT CONCAT('2012', '-01-01');
+--+
| CONCAT('2012', '-01-01') |
+--+
| 2012-01-01
2012/07/26 06:52 +0530, Dhaval Jaiswal
SELECT * FROM test INTO OUTFILE '/home/test.csv' FIELDS TERMINATED BY ','
ENCLOSED BY '"' LINES TERMINATED BY '\n'
as above give your join condition before INTO OUTFILE.
Right: MySQL server writes into some directory where it is, not where
2012/07/24 13:07 -0700, Hassan Schroeder
On Tue, Jul 24, 2012 at 10:36 AM, Roberta Jaskólski wrote:
> version(): 5.5.8-log
> @@sql_mode:
> REAL_AS_FLOAT,PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE,ANSI,NO_AUTO_VALUE_ON_ZERO,STRICT_TRANS_TABLES,NO_ZERO_DATE,ALLOW_INVALID_DATES,NO_AUTO_CR
2012/07/31 15:02 -0700, Haluk Karamete
So, in a case like this
shop.orders.32442
shop.orders.82000
shop.orders.34442
It would be the record whose source_recid is shop.orders.82000. Why? Cause
82000 happens to be the largest integer.
Now, if they are always 5-digit-long integer
2012/08/04 23:14 -0400, Fred G
I'm using MySQL 5.2 Workbench, and when I import a csv into MySQL, blank
values become 0 when I define the datatype to be a DECIMAL (in our case
(DECIMAL(12,2)). Since there is the potential for values to be 0, this
poses a problem for us. I initially wanted
2012/08/21 16:35 -0600, Larry Martell
I am trying to write a query that selects from both a correlated
subquery and a table in the main query, and I'm having a lot of
trouble getting the proper row count. I'm sure this is very simple,
and I'm just missing it. I'll try and present a simple
2012/08/22 17:38 -0400, Shawn Green
MySQL does not have a simple OUTER JOIN command (some RDBMSes call this a FULL
OUTER JOIN). What we do have is the option to include the OUTER keyword into
our LEFT or RIGHT joins. For example, both of these are acceptable:
LEFT OUTER JOIN
LEFT JOIN
2012/09/04 11:43 -0700, Rick James
You have DATETIME and TIMESTAMP. Keep in mind that TIMEZONE is timezone-aware;
DATETIME is not.
TIMEZONE is typo for TIMESTAMP?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.m
2012/09/06 08:50 -0400, Mark Haney
>SELECT vLight.* FROM
>(SELECT lights.*, machine.mach_name from lights
>JOIN machine ON lights.mach_id = machine.mach_id
>ORDER BY date DESC) as vLight
>GROUP BY mach_id
How about
SELECT lights.*, machine.mach_name
FROM lights JOIN machine USIN
2012/09/07 09:11 -0400, Mark Haney
All I need is the most recent record for EACH machine ID, THEN to pull the
machine name from the table that has the name in it.
Somehow I'm missing something incredibly obvious here.
That is not certain.
There is a fairly standard, fairly ug
2012/09/10 15:49 -0700, Rick James
SELECT ... ORDER BY .. GROUP BY..
is syntactically incorrect.
Yeap, my mistake.
( SELECT ... ORDER BY .. ) GROUP BY ..
Is what I call the "group by trick". It is an optimal way to SELECT all the
fields corresponding to the MAX (or M
My MySQL is of version 5.5.8-log. I find I cannot save a query with INTERVAL in
a view: redundant round brackets are added. If the query is
SELECT INTERVAL(1, 2, 3, 4)
within the frm file there is the expression
interval((1, 2, 3, 4))
which is wrong.
What is known about this?
--
MySQL Gene
2012/09/17 13:11 -0500, Peter Brawley
Looks like a bug. Report it?
It was reported:
Bug #45346 VIEW containing INTERVAL(...) can be created but does not work
Submitted: 5 Jun 2009 10:00 Modified: 5 Jun 2009 10:16
Severity:S3 (Non-critical)
Version:6.0, 5.4, 5.1 OS:Any
Seems
2012/09/18 06:53 -0400, Larry Martell
This works fine. But now I need to get a certain column
(image_measurer_id) with each row returned that corresponds to the row
from the group that has bottom = Min(bottom), bottom = Max(bottom),
bottom closest to Avg(bottom), and bottom from the row w
2012/09/19 14:36 -0400, Larry Martell
MIN(ABS(Avg(bottom) - bottom))
Is not valid. It gives:
ERROR (HY000): Invalid use of group function
Yes, I had my doubts of that, for all that I suggested it.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/m
2012/09/19 13:44 -0700, Rick James
http://mysql.rjweb.org/doc.php/myisam2innodb
Also, InnoDB enforces foreign-key constraints, MyISAM not.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
2012/09/04 11:43 -0700, Rick James
int(1) does not mean what you think. Probably you want TINYINT UNSIGNED.
Yeap, a real misfeature of MySQL. It is also one of the ways wherin MySQL puts
in C and takes PL1 away.
--
MySQL General Mailing List
For list archives: http://lists.m
2012/09/26 09:31 -0700, Rick James
You could look at the .TYD and .TYI file sizes and compare to the .MYD and
.MYI, but that can be deceptive. If the table is really big, and has lots of
indexes, the generation of the indexes might go slower and slower -- hence any
math on the sizes w
2012/09/24 16:28 -0700, Mark Phillips
I have a table, Articles, of news articles (in English) with three text
columns for the intro, body, and caption. The data came from a web page,
and the content was cut and pasted from other sources. I am finding that
there are some non utf-8 characte
2012/09/30 11:07 -0700, Mark Phillips
The data for this table comes from a web page (charet utf8). I copy/paste word
files into gedit (on linux) and then copy/paste from gedit to a text boxes on
the web page input form. I had thought I was stripping out all the funky
characters by usin
2012/05/07 11:49 +0200, Claudio Nanni
http://www.youtube.com/watch?v=INHF_5RIxTE
and stuff from AlgoRhythmics
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
2012/10/03 20:35 +0700, Morning Star
$ echo $var
"value1","value2","value3"
what i did:
mysql -u $user -p${password} --skip-column-names -e 'ALTER TABLE
'$table' MODIFY '$kolom' SET(" '$var' ");' $database ;
the result:
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax;
Can anyone explain this to me?
The first one seems quite wrong; the rest make perfect sense.
mysql> select ifnull(date('1900/5/3'), date('1900/01/01')) + 1;
+--+
| ifnull(date('1900/5/3'), date('1900/01/01')) + 1 |
+--
For this,
2012/10/04 16:13 +0200, MAS!
IF(GROUP_CONCAT(DISTINCT secA.sec_code SEPARATOR '|') is null,
IF(GROUP_CONCAT(DISTINCT secB.sec_code SEPARATOR '|') is nul
2012/10/08 14:52 -0700, Rick James
Do not use + for DATE arithmetic!
Use, for example
+ INTERVAL 1 YEAR
No, those operations are well defined. Amongst the timestamp-functions there is
constant reference to numeric context, and character context--and well there
is, because the
2012/10/11 13:46 -0400, Mark Haney
I know it's been a while since I wrote serious queries, but I'm sure I have
done something like this before:
SELECT SUBSTR(date,1,10) as vDate, event_id, events.mach_id, machine.factory_id
FROM events JOIN machine ON events.mach_id = machine.mach_id W
2012/10/12 17:56 +0100, Neil Tompkins
Is there such a way in a MySQL query to extract the text "this is a test"
from the following strings as a example
http://www.domain.com/"; class="link">this is a
test
http://www.domain.com/"; title="this is a test"
class="link">link
Amongst
2012/10/16 12:57 -0400, Michael Dykman
your now() statement is getting executed for every row on the select. try
ptting the phrase up front
as in:
set @ut= unix_timestamp(now())
and then use that in your statement.
Quote:
Functions that return the current date or time each are
2012/11/04 22:23 +, Stefan Kuhn
select * from table order by udf(column, 'input_value') desc;
For my understanding, this should give the same result always.
But if for your data function "udf" returns the same for more arguments there
is not enough to fix the order. In that
2012/11/14 10:26 +0530, sagar bs
As i have the data with some 25 variables in csv file and i need to import
to mysql.
The issue is that the date format in csv file is dd/mm/ and mysql takes
the date format like /mm/dd.
The number of variables in the csv file are same in the table
2012/11/14 18:27 +0530, sagar bs
There are four columns in my table named like account_name, c1, c2 and c3.
Account name is the primary key and c1, c2 contain two different dates and in
the column c2 there are few fields showing /00/00, now i need to get the
date different(in da
2012/11/15 00:30 +0100, Mogens Melander
I guess I'm sill learning.
Does that mean that, if the last column in a load blabla. is a -00-00
terminated by ^n it might error ? Or are we talking ODBC ?
Find it under LOAD DATA
If an empty field is parsed for a NOT NULL DATE o
2012/11/19 04:49 -0800, Jan Steinman
> SELECT main.code
> , IF(iconstandardrel.icon = 4,1,0) AS 'internationalt_produkt.eps'
> , IF(iconstandardrel.icon = 3,1,0) AS 'god_vaerdi.eps'
> , IF(iconstandardrel.icon = 2,1,0) AS 'for_miljoeets_skyld.eps'
> , IF(iconstandardrel.icon = 1,1,0) AS '
2012/11/19 05:05 +0100, Mogens Melander
I found an article on:
http://stackoverflow.com/questions/3122424/dynamic-mysql-query-view-for-crosstab
Describing how to do the dynamic generation of SQL statements.
And I was inspired to do some such thing to one of my views.
This view
2012/11/22 14:30 +, Neil Tompkins
I'm struggling with what I think is a basic select but can't think how to
do it : My data is
id,type
1000,5
1001,5
1002,2
1001,2
1003,2
1005,2
1006,1
>From this I what to get a distinct list of id where the type equals 2 and 5
Any ideas ?
2012/11/22 14:30 +, Neil Tompkins
I'm struggling with what I think is a basic select but can't think how to
do it : My data is
id,type
1000,5
1001,5
1002,2
1001,2
1003,2
1005,2
1006,1
>From this I what to get a distinct list of id where the type equals 2 and 5
Any ideas ?
2012/11/23 10:49 +0530, Girish Talluru
I have a scenario where I have to screen a huge bunch of records for in db
using certain rules. I have done in traditional php style record by record
and it took 90 mins for 4000 records. I have 800k - 900k records in
production which might possibly
2012/11/29 11:46 +0530, Trimurthy
i have a table which contains the columns
date,sname,age,item,quantity,units.my question is i want to retrieve all
the values from the table where date=maxdate group by sname how can i get
those values.
A question, I suspect, found in all SQL
2012/12/04 15:18 -0800, Karen Abgarian
MySQL, like all other products, can be peachy or bitchy. Good ones, they also
die.Wish I was kidding :-)
Mind VHS & BetaMax? BetaMax had much better color--but VHS long outlasted it.
--
MySQL General Mailing List
For list archives
2012/12/03 19:10 +0530, amit
Problem
mysql> call mobile_series1('(99889988),(12334565)');
You are expecting MySQL to turn one string operand into twain number operands.
That does not happen, unless you use PREPARE, which, I suspect, is not part of
your homework.
--
MySQL Ge
2012/12/11 16:19 -0500, Larry Martell
I have this query:
SELECT data_target.name, ep, wafer_id, lot_id,
date_time, data_file_id, data_cstimage.name,
bottom, wf_file_path_id, data_measparams.name,
vacc, data_category.name
FROM data_cst, data_target, data_cstimage, dat
This is, maybe, a question of taste. I find it useful in the aggregate
functions that they ignore all NULLs that come under their purview, but yield
NULL if nothing else comes. Now, CONCAT_WS is no aggregate function, but is
like them in that it ignores all NULLs that come its way, aside from th
When I wrote my comment after Larry Martell s problem, I already suspected it
was somewhat out of place because to his problem it did not apply.
2012/12/12 08:25 -0500, Shawn Green
This is a perfectly acceptable naming convention to use. For example if you
have a field on the `art` tab
2013/01/31 22:24 -0600, Peter Brawley
Is this what you mean?
Select,
pricelist
If( !IsNull(specialprice) And specialprice < unitprice And CurDate() Between
startingDate And endingDate,
specialprice,
unitprice
) as used_price
>From catalog
Where itemid='WB314';
PB
Maybe this i
2013/02/02 12:58 -0600, Peter Brawley
On 2013-02-01 10:18 PM, h...@tbbs.net wrote:
>2013/01/31 22:24 -0600, Peter Brawley
>Is this what you mean?
>
>Select,
>pricelist
>If( !IsNull(specialprice) And specialprice < unitprice And CurDate() Between
>startingDate And endingDate,
>sp
It is my impression that when their functions are equivalent, IF takes more
time than CASE. Comment?
Do they always evaluate all their arguments?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
2013/02/05 17:06 +, Rick James
As a Rule of Thumb, function evaluation time is not significant to the overall
time for running a query. (I see IF and CASE as 'functions' for this
discussion.)
Do you have evidence that says that IF is slower? Perhaps using BENCHMARK()?
N
2013/03/13 13:18 +, Norah Jones
I have a table which looks like this:
answer_id q_id answer qscore_id answer_timestamp
1 10Male3 1363091016
2 10Male3 1363091017
3 11Male3 1363091018
2013/03/15 12:43 -0300, Marcus Vinicius
Does anyone knows the author of this:
http://grimoire.ca/mysql/choose-something-else
Title: "Do Not Pass This Way Again"
Not I
--but, as to automatic type-conversion, I find me in agreement with the author.
When I first began to use MyS
2013/03/16 03:44 +0100, Reindl Harald
what are you speaking about?
you can define it in my.cnf and YOU are responsible for
the configuration as you are also responsible the
develop php code with error_reporting = E_ALL
These SQL-modes that pertain to type-safety are really part
2013/03/25 11:28 +0200, Dotan Cohen
Thanks. I don't have the admin or root privileges on this database. Is
that the only way to see the code behind the function?
Well, you showed us "DEFINER: admin@localhost" for the function; here is a
snippet from MySQL help about "
SHOW CREAT
2013/03/27 08:01 +0200, Dotan Cohen
Actually, it is the user that I am logged in as that created the
function. That is why I find it hard to believe that one needs root /
admin access to see its definition.
And that user set DEFINER other than itself, and that worked???
That tak
Is there somewhere within MySQL means of aging the error log, that it not
indefinitly grow big, or is that done through the OS and filesystem on which
"mysqld" runs?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
2013/04/04 22:40 +0200, Manuel Arostegui
You can start with show innodb status;
It is now
show engine innodb status
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
2013/04/04 23:18 +0200, Reindl Harald
> Is there somewhere within MySQL means of aging the error log, that it not
> indefinitly grow big, or is that done through the OS and filesystem on which
> "mysqld" runs?
man logrotate
Not Unix!
In any case, I take this to mean that this
2013/04/06 13:56 -0700, Rajeev Prasad
I have a table with around 2,000,000 records (15 columns). I have to sync this
from an outside source once every day. not all records are changed/removed
/new-added everyday. so what is the best way to update only those which have
changed/added/or
2013/04/05 11:16 +0200, Johan De Meersman
Half and half - rename the file, then issue "flush logs" in mysql to close and
reopen the logs, which will cause a new log with the configured name to be
created.
That being said, I'm not much aware of Windows' idiosyncracies - I hope the
damn
2013/04/17 14:16 +0200, Antonio Fernández Pérez
I have a doubt with stored procedures functionality. Is possible that a
stored procedure works with all databases form the server? I have created a
stored procedure on dataBaseA and also works with dataBaseB. Is that
correct? Independently o
2013/04/24 09:06 -0700, Rajeev Prasad
this table has many columns and only 1 record. select * from table; generates
an unreadable list. how can i list the record as in two columns? (column name
and its value)? i looked at UNPIVOT, but could not get it to work.
SQL> select * from table U
2013/04/30 17:17 +0200, Martin Koch
CREATE OR REPLACE VIEW foo AS
SELECT *
FROM mytable
WHERE id = X'36a461c81cab40169791f49ad65a3728';
Try this: _binary X'36a461c81cab40169791f49ad65a3728'
SHOW CREATE VIEW is the command for the client.
--
MySQL General Mailing List
Fo
2013/05/11 20:50 +0600, SIVASUTHAN NADARAJAH
I want to start the mysql from command prompt using "NET START MYSQL"BUT
the server not started. It display an error message.
C:\Users\PC> NET START MySQLSystem error 5 has occurred.
Access is denied.
could you please help me, how to star
2013/05/11 22:58 +0200, Reindl Harald
why not answer the question another user made hours ago?
under which account do you try to start mysqld?
Well, I learnt something here.
When I had the problem of (under Vista) starting "mysqld", from command prompt
I always did this, "star
2013/05/22 21:17 +, Rick James
In query syntax, TRUE is the same as 1; FALSE is the same as 0.
and UNKNOWN is NULL. (I actually have used a three-state comparison.)
It has been suggested that one who wants a real two-state field use the type
CHAR(0) NULL.
If you ha
2013/05/24 09:49 -0400, shawn green
Or we could coerce datetime values back to their date values when both are
being used. The trick now becomes choosing between rounding the datetime value
(times past noon round to the next date) or do we use the floor() function all
the time.
<<<
2013/05/29 10:39 +0100, Neil Tompkins
Using Workbench with MySQL 5.6 how do I edit a existing Trigger. Do I need
to DROP the Trigger and create a new one ? If that is the case how can you
run start command in a live environment ?
Whatever appearance Workbench adds (I do not kn
2013/05/29 14:51 +0100, Neil Tompkins
This is my Trigger which doesn't seem to work; but doesn't cause a error
DROP TEMPORARY TABLE IF EXISTS tempHotelRateAvailability;
CREATE TEMPORARY TABLE tempHotelRateAvailability(AuditTrailId
varchar(36),UserId bigint(20),ActionType
enum('INSER
I wish to join two tables on likeness, not equality, of character strings.
Soundex does not work. I am using the Levenstein edit distance, written in SQL,
a very costly test, and I am in no position to write it in C and link it to
MySQL--and joining on equality takes a fraction of a second, and
2013/06/03 18:38 +0200, Hartmut Holzgraefe
equality checks have a linear cost of O(min(len1,len2)) and can make
use of indexes, too, while Levenshtein cost is is almost quadratic
O(len1*len2) and can't make any good use of indexes ... even using
a C UDF would help only so far with this ki
2013/06/03 21:43 +, Rick James
Soundex is the 'right' approach, but it needs improvement. So, find an
improvement, then do something like this...
Hashing involves somekind normalizing, and in my case I see no means to it;
otherwise I would not have considered something so
2013/06/06 09:28 -0400, Mike Franon
Long story short, 50% of the time the command /etc/init.d/mysqld stop will
fail
Don't see why it anywhen succeeds. My version of "mysqld" doesn't know "stop".
As for "mysqladmin", it knows "stop", but, since that means "stop-slave", I
doubt
2013/06/11 12:59 -0700, Daevid Vincent
Also, just for S&G this is how we are currently implementing it, but we feel
the REGEXP is killing our queries and while "clever" is a bit hacky and
nullifies any indexes we have on the genres column as it requires a
file_sort table scan to compare s
2013/06/11 12:59 -0700, Daevid Vincent
Also, just for S&G this is how we are currently implementing it, but we feel
the REGEXP is killing our queries and while "clever" is a bit hacky and
nullifies any indexes we have on the genres column as it requires a
file_sort table scan to compare s
2013/06/17 11:38 +0430, Sayyed Mohammad Emami Razavi
update test set desc='test10' where id=1;
_That_ is UPDATE! It is the only means of changing, but neither inserting nor
deleting, a record.
The other fields are left the same.
MySQL also tracks whether it is an actual chang
2013/06/13 23:08 +, Rick James
FIND_IN_SET might work the cleanest...
WHERE FIND_IN_SET('action', genres) OR/AND [NOT] ...
And have genres look like 'action,drama,foobar', that is comma-separators, and
no need for leading/trailing comma.
That would also work for genres = '1,3,10,19,
2013/06/26 17:31 +0100, nixofortune
ALTER TABLE `new_innodb`
ADD KEY `idx1` (`col1`,`col2`),
ADD KEY `idx2` (`col1`,`col2`,`col3`);
Is it really seemly for one index to be a leading part of another?
(or maybe I am really thinking of something else)
--
MySQL General Mailing Li
2013/07/02 12:29 +0100, Neil Tompkins
I have a number of INSERT and UPDATE statements in a MySQL Stored
Procedure, that works in the form of START TRANSACTION followed by COMMIT.
Also I am handling any EXCEPTION.
However, after calling COMMIT, how can I get the number of Rows that were
2013/07/27 00:58 +0200, Chris Knipe
I would definately consider the md5 checksum as a
PK (char(32) due to the hex nature),
Well, not that it greatly matters, but you could convert it to BINARY(16).
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
2013/07/30 14:12 -0400, Sukhjinder K. Narula
I have several databases (all with same structure), which I to query. For
instansce:
db1, db2, db3 - all have table tb1 with field a, b and table tb2 with
fields flag1, flag2
So I want to query and get field a from tb for all db's. One way to
2013/08/21 18:03 -0400, Nick Khamis
We have the following mysql timetampe field
startdate | timestamp | NO | | -00-00 00:00:00
When trying to insert a long value in there:
Calendar c = Calendar.getInstance(TimeZone.getTimeZone("UTC"));
c.getTimeInMillis();
We are presented w
2013/08/22 14:22 -0400, Nick Cameo
SimpleDateFormat sdf = new SimpleDateFormat("-MM-dd'T'HH:mm:ss", new
Locale("en", "US"));
Well, you have your answer (FROM_UNIXTIME( /1000)), but that stupid ISO
format with 'T' in the middle does not work, because to MySQL letters are n
2013/09/02 12:49 +0800, John Smith
> > I looked in mysql.config.pl and no "localhost" :(
> "mysql.config.pl" from what software damned?
> "mysql.config.pl" does not exist in context of mysql
It exists in the following folder on my Win8 box:
/Program Files (x86)/MySQL/MySQL Server 5.5/bi
2013/10/22 12:20 -0400,
I recently upgraded a local MySQL installation to 5.5.32 and am trying to
figure out why the following query won't work as expected anymore. I'm just
trying to compare a set of dates to NOW() but since the upgrade, these don't
seem to work as expected.
SELECT
MySQL fans,
2013/09/21 18:04 +0200, Bjorn Munch
MySQL Server 5.7.2 (Milestone Release) is a new version of the world's
most popular open source database. This is the second public milestone
release of MySQL 5.7.
Is this a good replacement for that 5.5.8 that I long ago download
2013/10/25 00:08 +, Rick James
There's an old saying, "If it ain't broke, don't fix it."
Why _might_ 5.6.x or 5.7.x be "better for you"? Sure there might be some
features you might want, might be some performance improvements that you might
notice, etc. And there might be some re
2013/10/28 21:23 +, Neil Tompkins
Basically the snippet of the UPDATE statement I provided shows updating only 1
field.
However in my live working example, I have about 20 possible fields that
"might" need to be updated if the variable passed for each field is NOT NULL.
We
2013/10/29 11:35 -0400, Shawn Green
My favorite technique is the COALESCE function for this on a column-by-column
basis
SET FieldName1 = Now(), FieldName2 = COALESCE(:MyVariable, FieldName2)
but if MyVariable is NULL, FieldName1 reflects the attempt to change, not
change.
-
2013/11/04 09:32 -0800, Jan Steinman
I noticed that I have similar queries that work as expected. The difference
appears to be that every query that is broken uses " WITH ROLLUP", and removing
this makes them behave as expected.
Is this a known bug? Should I submit it as such?
If some
2013/11/08 17:35 -0800, Jan Steinman
Okay, I think I found it:
http://bugs.mysql.com/bug.php?id=47713
I added a comment with a link to a page I set up to show the behaviour on my
system.
http://www.ecoreality.org/wiki/WITH_ROLLUP_problem
It was submitted in 2009, severi
I have MySQL 5.5.8 under Windows Vista, and I am minded to write Java programs
to talk to the server. I believe that a connecter is needed for that, something
with ODBC in the name--which version is best for my use?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
2013/12/18 11:07 -0500, Anthony Ball
I ran across a curious issue, I'd call it a bug but I'm sure others would
call it a feature.
I have a csv file with space between the " and , and it causes MySQL to eat
that field and the field after it as a single field. Is there a setting I
can use
1 - 100 of 132 matches
Mail list logo
