Dear all,
Benetl, a free ETL tool for MySQL, is out in version 4.9.
This new version is providing some code optimizations, tests coverage
improvement.
This version supports Java 1.8 and providesone bug correction (dist
function now returns result as double type).
You should really update
Hello Mogens,
On 8/18/2018 2:32 PM, Mogens Melander wrote:
Guys,
I think I remember this from way back.
You could ask for a lock, and get an OK if it is safe.
Something like, if there is pending transactions, on your target tables,
you would get a NO.
But then again. I could be wrong, and
Guys,
I think I remember this from way back.
You could ask for a lock, and get an OK if it is safe.
Something like, if there is pending transactions, on your target tables,
you would get a NO.
But then again. I could be wrong, and Shawn is the authority on this.
On 2018-08-18 23:59, shawn
Hello Jeff,
On 8/13/2018 12:05 PM, j...@lxvi.net wrote:
Hello, I have read through several pages of the reference manual, and
I've seen several instances where it is stated that LOCK TABLES (and
UNLOCK TABLES) is not allowed in a stored procedure, but so far, I
haven't found an expl
Hello, I have read through several pages of the reference manual, and
I've seen several instances where it is stated that LOCK TABLES (and
UNLOCK TABLES) is not allowed in a stored procedure, but so far, I
haven't found an explanation as to *why* that is. Could someone please
enlighten m
Unfortunately not with the standard configuration.
You're best bet going forward would be to look at
MySQL Enterprise Audit -
https://www.mysql.com/products/enterprise/audit.html
On Tue, Oct 10, 2017 at 3:54 PM, Gone, Sajan wrote:
> Hi,
>
>We have a MySQL instance whic
Hi,
We have a MySQL instance which is currently running on version
`5.7.11-enterprise-commercial-advanced-log`. On this instance I am trying to
figure out the most recent timestamp at which a specific user has established a
connection to this instance (or) performed any DML operations
On 10/9/2017 3:27 AM, Xiaoyu Wang wrote:
Hello,I reported a bug, at https://bugs.mysql.com/bug.php?id=87637, as well as
a patch. And Bogdan, the bug hunter, told me this patch would show up on the
dev contribution report. So, could anyone please tell me how to contact dev
team, or how can I
Hello,I reported a bug, at https://bugs.mysql.com/bug.php?id=87637, as well as
a patch. And Bogdan, the bug hunter, told me this patch would show up on the
dev contribution report. So, could anyone please tell me how to contact dev
team, or how can I know the progress about integrating the
Hi, I signed Oracle Contributor Agreement about a month ago, but have not got a
response. I reported a bug, but I can not contribute my patch. So, could anyone
please tell me how long will it take before I am informed? Thanks, sincerely
Dear all,
Benetl, a free ETL tool for MySQL, is out in version 4.8.
This new version is providing some code optimizations, tests coverage
improvement.
This version supports Java 1.8 and providesone bug correction.
You should really update.
Benetl is freely dowloadable at:http
certain the names resolve correctly in DNS... Then
see point 1 above.
he is talking about *server* address not the client
that you always should use "skip-name-resolve" and never ever set
permissions based on reverse-DNS because a) when DNS lags everything
lags and b) it is easy for m
DNS... Then
see point 1 above.
On 3/2/17 7:01 AM, Kaushal Shriyan wrote:
Hi,
Is there any pros and cons to multiple domain names mapped to a single IP
work in MySQL client server setup like in case of httpd webserver there is
a concept of VHost having multiple domain names mapped to a single
Am 02.03.2017 um 16:01 schrieb Kaushal Shriyan:
Is there any pros and cons to multiple domain names mapped to a single IP
work in MySQL client server setup like in case of httpd webserver there is
a concept of VHost having multiple domain names mapped to a single IP?
For example :-
int
Hi,
Is there any pros and cons to multiple domain names mapped to a single IP
work in MySQL client server setup like in case of httpd webserver there is
a concept of VHost having multiple domain names mapped to a single IP?
For example :-
int-mysqldbserver1.example.com :- 192.168.0.11
int
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
e it seems to me you are not talking of
changing the data VALUE (UPDATE table SET column=new value WHERE ...)
but of changing the DATA TYPE (ALTER TABLE table CHANGE or ALTER TABLE
table MODIFY depending on whether ypou change the column name too) or
even of (just) changing the FORMAT in which
nging
the data VALUE (UPDATE table SET column=new value WHERE ...) but of
changing the DATA TYPE (ALTER TABLE table CHANGE or ALTER TABLE table
MODIFY depending on whether ypou change the column name too) or even of
(just) changing the FORMAT in which a value is displayed ...
Is there
> On Feb 19, 2017, at 3:50 AM, Brad Barnett wrote:
>
> SUBSTRING_INDEX
Thanks a million, Brad! That works perfectly. SUBSTRING_INDEX didn’t
come up in my searches so this is the first I’ve heard of it.
Also, as you could see, it wasn’t a true timestamp. It is only
Erm.
I've seen some weird responses to this. Yes, you can do this.
First -- get the data into a usable format. Then, put it into a usable
format (eg, timestamp for datetime field).
Read up on how mysql interprets date/time data on fields. And, create a
new timestamp or date field.
The
Am 19.02.2017 um 11:11 schrieb Peter Brawley:
On 2/18/2017 15:13, debt wrote:
I’ve been asked to post a question here for a friend.
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 formatt
On 2/18/2017 15:13, debt wrote:
I’ve been asked to post a question here for a friend.
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 wan
I’ve been asked to post a question here for a friend.
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 rea
Hello,
QxOrm library 1.4.3 and QxEntityEditor application 1.2.1 just released :
http://www.qxorm.com/
The Qt ORM library now supports CMake and provides a new QxEntityEditor
documentation : http://www.qxorm.com/qxorm_en/manual_qxee.html
QxOrm library 1.4.3 changes log :
- Support CMake : new
/mysql/support-files/mysql.server start
starts it
On 12/3/16, 4:40 PM, "Peter Brawley" wrote:
On 12/3/2016 13:58, Martin Mueller wrote:
> I was able to install a version of MySQL 5.6 on OS Sierra. It appears
that the “launchdaemon’ method works while the mysql.serv
On 12/3/2016 13:58, Martin Mueller wrote:
I was able to install a version of MySQL 5.6 on OS Sierra. It appears that the
“launchdaemon’ method works while the mysql.server start/stop method does not
work. In retrospect I should have seen that, but I also think that the
official documentation
-process-in-mac-os-x-and-not-have-it-restart-on-its-own
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 the Web is full of complaints and tips. But
there doesn’t seem
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
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 the Web is full of complaints and tips
-
I have tried this and that, looking at advice on the Web, which is plentiful
but not always. Nothing works.
I have installed Postgresql, about which I know very little. But the
installation proceeded smoothly, and turning the server on and off works like a
charm.
Is it a reasonable
, about which I know very little. But the
installation proceeded smoothly, and turning the server on and off works like a
charm.
Is it a reasonable conclusion that MySQl and OS 10 just don’t like each other
very much and that a prudent man is better off with some other database? The
MySQL
Hello all,
Had a normal MySQL shutdown, reboot and then this happens:
161010 10:58:30 [Note] Plugin 'FEDERATED' is disabled.
161010 10:58:31 InnoDB: The InnoDB memory heap is disabled
161010 10:58:31 InnoDB: Mutexes and rw_locks use Windows interlocked functions
161010 10:58
Dear all,
Benetl, a free ETL tool for MySQL, is out in version 4.7.
This new version is providing some code optimizations, performance and
tests coverage improvement.
This version provides also two corrections :
- correcting one bug in debug mode.
- correcting one bug in logging system.
You
.. 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 when there is a duplicate
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
ment,
name varchar(255)
)//
CREATE TRIGGER TEST_TRIGGER
BEFORE INSERT ON Test
FOR EACH ROW
BEGIN
SET NEW.name = CONCAT(NEW.name, '_X');
END//
RENAME TABLE Test TO TestRenamed//
DROP TRIGGER Test.TEST_TRIGGER//
Are there any workarounds for this?
Thank you for
If you execute the script below, you will get the following error:
'Error Code: 1146. Table 'testschema.TestRenamed' doesn't exist"
delimiter //
CREATE TABLE Test(
id int not null primary key auto_increment,
name varchar(255)
)//
CREATE TRIGGER TEST_TRIGGER
BEFORE INSERT ON Test
FOR EACH R
I have a solution.
SELECT start_bit_boundary FROM (
SELECT
min(address) as start_bit_boundary,
status, count(*) as CT
FROM MAC_addresses
WHERE status = 0
GROUP BY address >> 2
) AS _INNER
WHERE
_INNER.CT = 4
ORDER BY start_bit_boundary
LIMIT 0,1;
It returns the firs
Hi Don,
On 17.12.15 16.14, Don Wieland wrote:
Hey gang,
I need the ability to produce this end result:
condition a) All clients who have had at least 2 appointments in the last 24
months
condition b) of the set of “condition a” rows, which of those have NO
appointments in the last 6 months
I should have said consecutive addresses, rather than contiguous.
I care about a set of consecutive addresses, and there is no guarantee
of record order.
On 12/17/2015 07:35 AM, John Stile wrote:
> I need help creating a select that returns 4 records that have
> contiguous addresses that st
I need help creating a select that returns 4 records that have
contiguous addresses that start on a bit boundary.
If 4 do not exist, I need a return of zero records.
I would like to do this in one statement and I do not have ownership of
this mysql server, so fancy views, temporary tables
Hey gang,
I need the ability to produce this end result:
condition a) All clients who have had at least 2 appointments in the last 24
months
condition b) of the set of “condition a” rows, which of those have NO
appointments in the last 6 months
I am able to get the clients with >
Hey gang,
I need the ability to produce this end result:
condition a) All clients who have had at least 2 appointments in the last 24
months
condition b) but have NO appointments in the last 6 months
I am able to get the clients with >= 2 appointments with this query
SELECT
c.client
No, he's the one who already receives a ton of email and could do without
"conversations" like this. I'm also in that boat.
sent from my mobile
On Oct 19, 2015 7:41 PM, "Ryan Coleman" wrote:
> You’re the one in grade school that always reminded us the teacher m
m [mailto:ryan.esca...@gmail.com] On Behalf
>>>> Of Ryan Escarez
>>>> Sent: Friday, October 16, 2015 2:47 AM
>>>> To: Ryan Coleman
>>>> Cc: Dennis Ruiz; mysql-le...@lists.mysql.com
>>>> Subject: Re: a
>>>>
>>>> c
...@gmail.com] On Behalf
Of Ryan Escarez
Sent: Friday, October 16, 2015 2:47 AM
To: Ryan Coleman
Cc: Dennis Ruiz; mysql-le...@lists.mysql.com
Subject: Re: a
c
On Fri, Oct 16, 2015 at 3:01 PM, Ryan Coleman
wrote:
b
On Oct 15, 2015, at 10:07 PM, Dennis Ruiz wrote:
a
signature.asc
Description
To: Ryan Coleman
>> Cc: Dennis Ruiz; mysql-le...@lists.mysql.com
>> Subject: Re: a
>>
>> c
>>
>> On Fri, Oct 16, 2015 at 3:01 PM, Ryan Coleman
>> wrote:
>>
>>> b
>>>
>>>> On Oct 15, 2015, at 10:07 PM, Dennis Ruiz
d
> -Original Message-
> From: ryan.esca...@gmail.com [mailto:ryan.esca...@gmail.com] On Behalf
> Of Ryan Escarez
> Sent: Friday, October 16, 2015 2:47 AM
> To: Ryan Coleman
> Cc: Dennis Ruiz; mysql-le...@lists.mysql.com
> Subject: Re: a
>
> c
>
> On F
c
On Fri, Oct 16, 2015 at 3:01 PM, Ryan Coleman wrote:
> b
>
> > On Oct 15, 2015, at 10:07 PM, Dennis Ruiz wrote:
> >
> > a
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe
b
> On Oct 15, 2015, at 10:07 PM, Dennis Ruiz wrote:
>
> a
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/mysql
>
--
MySQL General Mailing List
For list archives: http://lists.mys
a
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
- Original Message -
> From: "Reindl Harald"
> Subject: Re: When to create a new database
>
> it makes zero sense since you can use different users for the same
> database down to table and even column permissions
No, it does make some sense in the case whe
- Original Message -
> From: "Ron Piggott"
> Subject: Re: When to create a new database
>
> I would lean towards keeping it all together because of the speed
> decrease between connecting to different databases.
Heh, that consideration is a matter of semantics,
On 10/10/2015 10:28 AM, Richard Reina wrote:
If I were keeping tract of high school sports statistics and thus designed
the following tables:
sports, rules, statistical definitions
and
players, teams, games
Would it be a good or bad idea to put the first set of tables in a separate
When I read the OP I was thinking: This is one for Reindl. And here we
go.
When dealing with data of this specific kind, you most definitely
would want a date reference. A very small computer will be able to
handle
mane years of all kinds of weird sports statistics.
You need to define the
data_teams
data_games
Ron
On 10/10/15 10:28, Richard Reina wrote:
If I were keeping tract of high school sports statistics and thus designed
the following tables:
sports, rules, statistical definitions
and
players, teams, games
Would it be a good or bad idea to put the first set of tables in a
Am 10.10.2015 um 16:28 schrieb Richard Reina:
If I were keeping tract of high school sports statistics and thus designed
the following tables:
sports, rules, statistical definitions
and
players, teams, games
Would it be a good or bad idea to put the first set of tables in a separate
If I were keeping tract of high school sports statistics and thus designed
the following tables:
sports, rules, statistical definitions
and
players, teams, games
Would it be a good or bad idea to put the first set of tables in a separate
database called "library" since they ar
Hello Steve,
On 8/27/2015 9:11 PM, Steve Matzura wrote:
I have a Wordpress user who is setting up a Website and says he can't
connect to his database. Both I and the Wordpress admin are new to
this, so I've probably done something wron when I set him up
initiallyg.
Once I connected
I have a Wordpress user who is setting up a Website and says he can't
connect to his database. Both I and the Wordpress admin are new to
this, so I've probably done something wron when I set him up
initiallyg.
Once I connected to SQL as the SQL admin, I used the following
commands to
> From: Richard Reina
>
> I am writing a web application... As new users sign up for
> the application should each get their own MySQL username and password or is
> okay to execute their queries with the same (one generic) MySQL username
> and password?
As others have said,
>
That is rather vague.
What data is stored for each user?
What are these queries that a user may perform?
- --
James Moe
moe dot james at sohnen-moe dot com
520.743.3936
-BEGIN PGP SIGNATURE-
Version: GnuPG v2
iEYEARECAAYFAlXUvlgACgkQzTcr8Prq0ZPrHQCdFDqY9uEa1mS6
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 08/19/2015 10:06 AM, Richard Reina wrote:
> Data stored for each user would be a list of places visited that
> and details relating to those trips. The type of queries they would
> be able to perform be able to read, update and create ne
On 8/19/2015 9:24 AM, Reindl Harald wrote:
Am 19.08.2015 um 15:18 schrieb Jim:
On 8/19/2015 8:40 AM, Reindl Harald wrote:
Am 19.08.2015 um 14:29 schrieb Richard Reina:
I am writing a web application in perl that will create, edit, update
and
delete data from a MySQL database. I have written
Am 19.08.2015 um 15:18 schrieb Jim:
On 8/19/2015 8:40 AM, Reindl Harald wrote:
Am 19.08.2015 um 14:29 schrieb Richard Reina:
I am writing a web application in perl that will create, edit, update
and
delete data from a MySQL database. I have written a perl module that
will
manage the
On 8/19/2015 8:40 AM, Reindl Harald wrote:
Am 19.08.2015 um 14:29 schrieb Richard Reina:
I am writing a web application in perl that will create, edit, update and
delete data from a MySQL database. I have written a perl module that will
manage the connections (issue database handles ). As new
Am 19.08.2015 um 14:29 schrieb Richard Reina:
I am writing a web application in perl that will create, edit, update and
delete data from a MySQL database. I have written a perl module that will
manage the connections (issue database handles ). As new users sign up for
the application should
I am writing a web application in perl that will create, edit, update and
delete data from a MySQL database. I have written a perl module that will
manage the connections (issue database handles ). As new users sign up for
the application should each get their own MySQL username and password or is
Bernd wrote:
> a password ?
>
> Hi,
>
> this is my system:
>
> mysql> status
> --
> mysql Ver 14.12 Distrib 5.0.26, for suse-linux (x86_64) using readline 5.1
>
> Connection id: 142883
> Current database: mysql
> Cu
.0.1 | root | *1939D66C9255EE78C765CD91B5FB465C7A9472D9 |
++--+---+
I know that this is not the best solution, I will change it.
Using mysql on a Linux-system I can login with "mysql -u root" without
supplying a password. How is this po
Hello Steve,
To what list should I post with a post-installation config and startup
> question?
>
>
This list, the MySQL General Mailing List, is the right place if the
question is about MySQL!
Cheers
--
Claudio
To what list should I post with a post-installation config and startup
question?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
Caus' I was waiting for this kind of futile answer... pff
Reindl Harald schreef op 15-06-15 om 20:10:
and WHY THE FUCK don't you call some buddy instead spam large, public
mailing-lists? creep away!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To u
Am 15.06.2015 um 19:24 schrieb Trianon 33:
Jim,
It's just a fax to email service I would like to test..
and WHY THE FUCK don't you call some buddy instead spam large, public
mailing-lists? creep away!
signature.asc
Description: OpenPGP digital signature
Jim,
It's just a fax to email service I would like to test..
No, it won't cost a lot. Allthought it is location independent, it has
the same cost as every normal call to The Netherlands.
1) I said already, just one is enough, so I'm not after making mon
What is this “fax” he is speaking of?
> On Jun 15, 2015, at 9:28 AM, Jørn Dahl-Stamnes wrote:
>
> On Monday, June 15, 2015, Trianon 33 wrote:
>> All,
>>
>> Maybe a somewhat weird request: I need to verufy my fax can receive
>> foreign faxes.
>>
>>
All,
No, it won't cost a lot. Allthought it is location independent, it has
the same cost as every normal call to The Netherlands.
1) I said already, just one is enough, so I'm not after making money by
receiving faxes
2) As Stefan pointed out, it's just a fax to email service I
On Monday, June 15, 2015, Trianon 33 wrote:
> All,
>
> Maybe a somewhat weird request: I need to verufy my fax can receive
> foreign faxes.
>
> If someone (one is really enough) send me a (preferrably 2 pager) fax on
> +31848708584 (destination is in The Netherlands)
I hope
Hello Stefan,
You're right it is a fax to email service, which is location independent.
Tariff for calling should not differ to other fax numbers, that's why I
explained it is in The Netherlands and not somewhere on the North Pole.
All,
Maybe a somewhat weird request: I need to verufy my fax can receive
foreign faxes.
If someone (one is really enough) send me a (preferrably 2 pager) fax on
+31848708584 (destination is in The Netherlands)
For those I'm joking: no it is my fax, nobody will be stalked.
If the re
On 2015/05/07 19:42, Paul Halliday wrote:
Should have showed the whole thing. Take a look here (click image to see
full output):
http://www.pintumbler.org/tmp
I don't see why this worries you. Joining often increases variation.
Indeed, if in some case an inner join never did, mayb
Should have showed the whole thing. Take a look here (click image to see
full output):
http://www.pintumbler.org/tmp
On Thu, May 7, 2015 at 4:11 PM, shawn l.green
wrote:
> Hi Paul,
>
> On 5/7/2015 10:17 AM, Paul Halliday wrote:
>
>> Fighting a bit with this one...
>>
&
First, have you tried GROUP_CONCAT(DISTINCT types) ?
Second I see my counts rise just as my group_concat() terms when I do
something similar to what you're talking about. Also, here:
val c_types d_types
3t9,t9,t9 a2,a3,a9
Your column headers don't seem to match your query.
Hi Paul,
On 5/7/2015 10:17 AM, Paul Halliday wrote:
Fighting a bit with this one...
If I do something like (pseudo):
SELECT count(val) AS n, GROUP_CONCAT(types) AS c_types FROM tbl1
returns something like:
n c_types
1 t9
when I add a left join though:
SELECT count(val) AS n, GROUP_CONCAT
Fighting a bit with this one...
If I do something like (pseudo):
SELECT count(val) AS n, GROUP_CONCAT(types) AS c_types FROM tbl1
returns something like:
n c_types
1 t9
when I add a left join though:
SELECT count(val) AS n, GROUP_CONCAT(types) AS c_types,
GROUP_CONCAT(two.types) AS d_types
ev is this:
I maintain a database with rougly 13 million (13.000.000) records. Since
some statistics consume too much time for an on-line environment, I
generate them during the night.
What I do is count some things, which go into the INT fields, but I also
make some (smaller and bigger) tabl
Hi Andrew,
On 4/1/2015 1:58 PM, Andrew Wallace wrote:
I thought that TEXT fields only stored a pointer to the actual data in
the table,
not the data itself - storing 9 to 12 bytes in the table:
|"BLOB| <https://dev.mysql.com/doc/refman/5.0/en/blob.html>and|TEXT|
<https://dev
I thought that TEXT fields only stored a pointer to the actual data in the
table,
not the data itself - storing 9 to 12 bytes in the table:
|"BLOB| <https://dev.mysql.com/doc/refman/5.0/en/blob.html>and|TEXT| <https://dev.mysql.com/doc/refman/5.0/en/blob.html>columns count
Ok, thanks, couldn't find that anywhere.
Need to think for a different solution..
Anyway thanks for the remark, best regards, Schimanski.
Andrew Mueller schreef op 01-04-15 om 19:35:
There is a max row size of 65,535 bytes.
There is no real way to get around this limit other
There is a max row size of 65,535 bytes.
There is no real way to get around this limit other than placing the HTML
code somewhere else, perhaps in a different table.
On Wednesday, April 1, 2015, Trianon 33 wrote:
> Hello,
>
> I'm fiddling wit a table where I put in a date field (
Hello,
I'm fiddling wit a table where I put in a date field (datetime, also
key) and some integer fields (8 of them mostly 14 long) and some
longtext fields (16 of them).
The longtext fields are filled with some statistics I generate complete
with HTML around, something like
>>>> 2015/03/04 09:21 -0500, Phil >>>>
One option would be to create a trigger for each milestone to generate the
data instead. That could be a lot of triggers, not sure if it could be
done in a single trigger, plus then I would have to maintain the trigger
wh
- Original Message -
> From: "Phil"
> Subject: Capturing milestone data in a table
> user_credits where metric1 > $mile and (metric1 - lastupdate) < $mile)
That second where condition is bad. Rewrite it as metric1 < ($mile +
lastupdate). Better yet,
om 0
up to the 100's of millions. All increases only (or remain the same) never
decrease.
So I'm trying to insert to a new table to capture when they pass 100, 200,
500, 10001M etc etc.
Currently I do this with the following statement looping around each
milestone point I've
- Original Message -
> From: "thufir"
> Subject: is a .sql file transactional
> when you run a .sql file, which modifies a schema, is it transactional?
> Specifically, is it an all-or-nothing proposition? Or, can some commands
> get executed, some fail?
A file
when you run a .sql file, which modifies a schema, is it transactional?
Specifically, is it an all-or-nothing proposition? Or, can some commands
get executed, some fail?
thanks,
Thufir
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
- Original Message -
> From: "Richard Reina"
> Subject: Specking a small MySQL server
>
> somewhat of an energy hog and is due to be replaced. I was considering
> replacing it with a lap-top so as to conserve energy and because a laptop
> has a built in batter
I have used MySQL for about twelve years as a database on our private LAN
that has only a handful of users at a time that query about a dozen
databases. The current server is an old rack-mounted machine that is
somewhat of an energy hog and is due to be replaced. I was considering
replacing it
2014-11-06 21:49 GMT+01:00, Roberta Jaskólski :
> Ugh--I missed the discussion shift from the DATEs to the VARCHAR labels ...
> and now I wholeheartedly agree with you.
>
> As for the DATEs, I yet suspect that for performance maybe TIMESTAMP is
> slightly better than DATE.
Well what I'm interest
>>>> 2014/11/04 11:04 -0800, Jan Steinman >>>>
I was not suggesting it for dates. The OP appeared to have a well-defined set
of strings in a VARCHAR field  THAT is what I suggested ENUMs for!
What is the update frequency of those VARCHARs? If you're adding
1 - 100 of 11444 matches
Mail list logo
