2017/10/18 18:32 ... Roger House:
I get the same behavior with the MySQL Command Line Tool when I run it on
Windows, Mac OS X, and Ubuntu, so I'm pretty sure the problem has to do
with mysql itself.
What do you know about the displays to which the client is writing?
In the case of "cmd" under
2017/09/19 17:19 ... Don Wieland:
Of these found rows, I want to omit those rows where there are rows found after
the END TimeStamp based on ?below ?where clause:
WHERE 1 AND apt.appt_status_id IN (16) AND apt.user_id IN (3) AND apt.time_start
> ‘1504238399'
We are trying to find Former Cl
2017/06/13 17:42 ... Chris Knipe:
Can someone explain to me why this is happening please:
mysql> SELECT * FROM CustomerDetails WHERE Username=’blah’\G
*** 1. row ***
EntryID: F83D4109-DCA8-426F-98B1-00B4AF117ACB
Username: bla
2017/03/24 15:19 ... william drescher:
While loading a database using the mysql command 'source' I see
occasional warnings flash by on the screen.
when it finished I used the command "show warnings," but only one
warning showed (the last one).
How can I see the warnings earlier in the load ?
2017/02/18 ... debt:
Is there a formula to change the format of the data in a single field in
every record of a table? She has a "timestamp” in a text field formatted as
2017|02|16|04|58|42 and she wants to convert it to a more human readable format like
2017-02-16 @ 04:58:42
It no
2016/12/07 01:26 ... mach...@seworx.co.za:
well in essence the following is required.
we need to know who made what changes to tables.
There is a machination that you can try in every trigger that will add
the user-name to the binary log:
set @asdfasdfasd = CURRENT_USER();
INSERT INTO
2016/12/06 02:33 ... mach...@seworx.co.za:
The audit table should include the following information:
-- Who made the changes (username logged in)
-- What type of change (insert,update,delete)
-- Date of change including time.
-- if update, which fields w
2016/12/02 18:58 ... Martin Mueller:
Alas, running the stop and start commands under sudo makes zero difference.
This is a very frustrating problem, and I hope somebody in the MySQl
documentation department will take a look at it. It’s cleary a problem that
has been around for years because t
...
Now - would searching, saving/storing then removing NULL vs ALLbutNULL
in a simple DB with one table wich has only primary key be sa
...
What is "removing NULL"? Deleting the record with NULL?
It has no bearing on the primary key, because NULL never is allowed in one.
It seems to me that r
2016/07/08 09:15 ... Johan De Meersman:
You will have to repeat all the column names - no wildcards in where clause
fieldnames - but the clause you're looking for is WHERE field IS NULL. Or IS
NOT NULL if you want those:-)
Well, one could try this:
set @sel=(select 'SELECT ' || GROUP_CONCAT(c
2016/07/02 18:49 ... Martin Mueller:
It’s clear from Section 6.6 of the Reference manual that I need to make sure
that the new installation differs from the old one with regard to the data
directory, the port number, the socket, the shared memory-base-name, and the
pid-file.
It’s less clear t
2016/05/14 16:23 ... shawn l.green:
> ... If the numeric
> value is quoted, it is still interpreted as an index if there is no
> matching string in the list of enumeration values.
One of the many cases where I believe that MySQL s attempt to be helpful
by converting is not helpful. Thus it wa
2016/04/22 04:49 ... Jigal van Hemert:
It works for a lot of Western European languages very well, but in some
cases there are problems. For Asian languages there are a lot more
problems. For example, 'ß' isn't considered the same as 'ss'.
Well, the former is an sz-ligature, and the latter is a d
2016/03/25 06:39 ... JAHANZAIB SYED:
I want to query user quota for current date. I am using following code
SELECT SUM(acctinputoctets)+SUM(acctoutputoctets) AS Total FROM radacct where
(acctstarttime between DATE_FORMAT(NOW(),'%Y-%m-%d') AND NOW() AND
acctstoptime between DATE_FORMAT(NOW() ,
2016/03/18 12:54 ... Don Wieland:
Trying to get the correct syntax on this:
ORDER BY
CASE
WHEN tr.Placed = "X" THEN r.Division ASC,
FIELD(tr.Place,"1","2","3","4","5","6","7","8","R","WD","Exc","E","S”), tr.Score DESC
WHEN tr.Placed != "X" THEN tr.ride_time ASC
END
How does on
2016/03/17 12:47 ... lejeczek:
.. that you experts I hope can crack like a digestive biscuit...
how does one update, or merge or whatever is right technical term for it
- a my.table from my.another table (both are schematically identical, no
foreign keys, one primary key) but..
does it a way so
I wrote a Java program to connect with MySQL server. As long as it was
loose classes in a directory, it worked. As soon as I made it into a JAR
file, I had trouble. If I used flag "classpath" to refer to the
connector, the connector was not found: with flag "-XshowSettings" I saw
that the conne
2016/01/25 19:16 ... Larry Martell:
SELECT IFNULL(f_tag_bottom,
IFNULL(f_tag_bottom_major_axis,
IFNULL(f_tag_bottom_minor_axis,
IFNULL(f_tag_ch_x_bottom,
IFNULL(f_tag_ch_y_bottom, NULL) as ftag,
STDDEV(c
18 matches
Mail list logo