On 5/24/2017 12:21, Papa wrote:
I am learning Java and I'd like to use MySQL to create, delete and
update databases using Java. I have done this with C++ SQLite, but
now, as I said, I want to port my code to Java [not easy for a Java
nubby]. However, the MySQL installer
[mysql-installer-web-co
in one of your files. Did you try recreating
virtual_users?
PB
-
Thanks.
Dave.
On 4/24/17, Peter Brawley wrote:
On 4/24/2017 18:16, David Mehler wrote:
Hello,
I'm running Mysql 5.7.18.
My virtual_users are working fine, it's the new table that isn't. Or
am I missing so
On 4/24/2017 15:28, Peter Brawley wrote:
On 4/24/2017 13:59, David Mehler wrote:
Hello,
root@localhost [mail]> show engine innodb_status;
ERROR 1286 (42000): Unknown storage engine 'innodb_status'
Well it's very unlikely InnoDB made that up, it's probably in one of
is on a Mysql 5.7 setup.
Thanks.
Dave.
On 4/24/17, Peter Brawley wrote:
On 4/24/2017 12:28, David Mehler wrote:
Hello,
Here's the create table sand error message.
root@localhost [(none)]> use mail;
Database changed
root@localhost [mail]> CREATE TABLE IF NOT EX
On 4/24/2017 12:28, David Mehler wrote:
Hello,
Here's the create table sand error message.
root@localhost [(none)]> use mail;
Database changed
root@localhost [mail]> CREATE TABLE IF NOT EXISTS `lastauth` (
-> `user` varchar(40) NOT NULL,
-> `remote_ip` varchar(18) NOT
On 4/24/2017 9:18, David Mehler wrote:
Hello,
I'm trying to add a table to an existing database. I'm wanting it to get
one of it's fields from an already existing table. I've done this
before in this database. This works:
CREATE TABLE `virtual_users` (
`id` int(11) NOT NULL auto_inc
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 wants to conve
On 12/3/2016 14:23, Martin Mueller wrote:
I abandoned a MySQL 5.22 database
There's been 5.0m 5,1, 5,4 (briefly), 5.5, 5.6 and now 5.7. No 5,.2.
that quite suddenly andthat I wasn’t able to start up again. The data
directory consists of a mix of ISAM and Inno tables.
You mean MyISAM?
could and should be more explicit about what is a
significant change in Apple’s start/stop routines.
If you mean that seriously, it needs to be more specific.
PB
-
On 12/3/16, 12:43 PM, "Peter Brawley" wrote:
On 12/2/2016 17:58, Martin Mueller wrote:
> Alas, run
On 12/2/2016 17:58, Martin Mueller wrote:
Alas, running the stop and start commands under sudo makes zero difference.
?! The cited page recommends more than sudo starts and stops, eg ...
|unset TMPDIR mysql_install_db |
Did you try that? Did you check the pid setting in my.cnf, eg
pid-file=/
On 12/2/2016 16:59, Martin Mueller wrote:
I have been trying repeatedly and in vain to install the community edition of
MySQL 5.7.16 on an iMac running OS sierra. I religiously followed the
instructions for uninstalling previous versions found at
http://community.jaspersoft.com/wiki/uninstall
On 5/14/2016 11:16, shawn l.green wrote:
Hello Sukhjinder,
On 5/3/2016 8:55 AM, Sukhjinder K. Narula wrote:
Hello,
i have a question regarding the GREATEST function of mysql.
I would like to add the values returned by GREATEST function is
mysql, so a
query is like below:
For example table t
On 4/21/2016 10:51, Stephen R Guglielmo wrote:
Hello,
I have a empty db that I'm trying to load a .sql file (created via
mysqldump) into. The dump has 791611 lines and is 807 MB. Loading the
dump is consistently failing at line 1763. Line 1763 is an INSERT
statement. The line is 95610 characters
On 1/8/2016 3:14, Nitin Mehta wrote:
Looks like some kind of locking mechanism in the application. Should not be a
database issue.
On Friday, January 8, 2016 10:47 AM, geetanjali mehra
wrote:
Hi all,
Suddenly I have started getting below error from our web site:
'commands out
On 12/31/2015 0:51, Larry Martell wrote:
I need to count the number of rows in a table that are grouped by a
list of columns, but I also need to exclude rows that have more then
some count when grouped by a different set of columns. Conceptually,
this is not hard, but I am having trouble doing th
On 2015-10-20 12:54 PM, Don Wieland wrote:
Hi all,
Trying to get a query working:
SELECT
ht.*,
CONCAT(o.first_name, " ", o.last_name) AS orphan,
GROUP_CONCAT(DISTINCT hti.rec_code ORDER BY hti.rec_code ASC SEPARATOR ", ") AS
alloc
FROM hiv_transactions ht
LEFT JOIN tk_orphans o ON ht.orphan_
On 2015-09-04 11:39 AM, Richard Reina wrote:
2015-09-04 11:18 GMT-05:00 Peter Brawley <mailto:peter.braw...@earthlink.net>>:
On 2015-09-04 9:40 AM, Richard Reina wrote:
I have the following two tables;
mysql> select * fr
On 2015-09-04 9:40 AM, Richard Reina wrote:
I have the following two tables;
mysql> select * from challenge;
+++-++--+-+--+
| ID | PLR_ID | ACC_TYPE_ID | season | year | CHAR_ID |
+++-++--+-+-
On 2015-06-29 7:03 PM, Johnny Withers wrote:
Hello all,
I have a tabled defined:
CREATE TABLE `store_seq` (
`seq_type_id` smallint(3) unsigned NOT NULL DEFAULT '0',
`store_id` int(10) unsigned NOT NULL DEFAULT '0',
`loan_model_id` int(10) unsigned NOT NULL DEFAULT '0',
`store_bank_i
On 2015-06-03 2:55 PM, Robert Voliva wrote:
We're finding that, when working with the em dash character, the LEFT and
LENGTH functions don't work well together. This query shows trying to
strip off the last character from a string containing an em dash:
mysql> select LEFT('031492349−0002,', LEN
On 2015-04-29 12:20 AM, Olivier Nicole wrote:
SELECT * FROM table WHERE item_number=1;
Sorry if my question was not clear: what I am looking for is:
SELECT * FROM table WHERE data_value=1 AND "there is not any reccord with
the same item_number and data_value=2"
Assuming a table named t ...
O
On 2014-12-09 9:55 AM, Johan De Meersman wrote:
- Original Message -
From: "Sándor Halász"
Subject: Re: forum vs email
That is, this list, right? What does it lack (besides readers)?
This list interacts with the forums on mysql.com?
Nope.
PB
-
Every thread here matches one on
On 2014-12-04 9:56 PM, shawn l.green wrote:
On 12/1/2014 6:09 AM, Johan De Meersman wrote:
- Original Message -
From: "peter brawley"
Subject: Re: table-for-column
I wonder if anyone knows why sites like Stack Overflow and those of
ours
I mentioned are seeing more vol
On 2014-11-27 9:31 AM, h...@tbbs.net wrote:
2014/11/26 20:06 -0600, Peter Brawley >>>>
Why do you call it a hack, you get outta bed on the wrong side?
<<<<<<<<
2014/11/27 14:08 +0100, Johan De Meersman >>>>
Doesn't really belong on the list
On 2014-11-24 3:24 PM, Neil Tompkins wrote:
Personally I think people, myself included are using other resources like
stackoverflow to get answers to my MySQL questions.
Visits to our MySQL article pages (www.artfulsoftware.com/queries.php,
http://www.artfulsoftware.com/infotree/mysqlquerytre
Let's see the results of Explain Extended this query, & result of Show
Create Table cc_member_queue_end_log.
PB
-
On 2014-11-13 1:34 PM, Mimiko wrote:
Hello. I have this table:
> show create table cc_agents_tier_status_log:
CREATE TABLE "cc_agents_tier_status_log" (
"id" int(10) unsign
On 2014-11-09 10:37 AM, Steffan A. Cline wrote:
Looking for suggestions on how to best pull some data.
I need to do some calcs but pull the data by year and month to make a
table like such.
201220132014
Jan $243$567$890
Feb $123$456
On 2014-10-08 1:38 PM, Jan Steinman wrote:
I often use CASE WHEN ... to pivot tables. For example, splitting sales data by
year:
SELECT
s_product.name AS `Product`,
SUM(CASE WHEN YEAR(sales.Date)='2007' THEN sales.Total ELSE NULL END) AS
`2007`,
SUM(CASE WHEN YEAR(sales.Date)
On 2014-09-18 5:25 PM, Jopoy Solano wrote:
Hi!
I want to say sorry in advance for my ignorance. I was wondering how can I
extract year-month-day-hour in one go. For example:
>From "2014-09-17 12:22:16" to "2014-09-17 12"
Is this what you mean?
date_format( tsvalue, '%Y-%m-%d %H' )
PB
-
On 2014-05-04 9:17 PM, EdwardKing wrote:
I use mysql to create a database and grant rights to a user hadooptest,then I
use hadooptest to login mysql and use the database,but it failed. Why raise
error after I grant rights? How to solve it? Thanks.
The command sequence ...
mysql> create data
On 2014-04-15 5:37 AM, reena.kam...@jktech.com wrote:
It can be done by data masking tool itself. Its one time activity, I do not need it
again & again.
Rilly? If that's so, the data will never be accessed.
'PB
Please suggest data masking tool link.
-Original Message-
From: "Reindl
On 2014-03-23 8:02 PM, David Lerer wrote:
Thanks Shawn, This may work for us with some script changes. We'll take a look.
By the way, too bad we cannot rename a database, or can we?
See http://dev.mysql.com/doc/refman/5.1/en/rename-database.html about removal of a
"dangerous RENMAE DATABASE" st
On 2014-01-12 9:13 PM, Larry Martell wrote:
On Sun, Jan 12, 2014 at 2:47 PM, Peter Brawley
wrote:
On 2014-01-12 1:17 PM, Larry Martell wrote:
I've been asked to do something that I do not think is possible in SQL.
I have a query that has this basic form:
SELECT a, b, c, d, AVG(e),
On 2014-01-12 1:17 PM, Larry Martell wrote:
I've been asked to do something that I do not think is possible in SQL.
I have a query that has this basic form:
SELECT a, b, c, d, AVG(e), STD(e), CONCAT(x, ',', y) as f
FROM t
GROUP BY a, b, c, d, f
x and y are numbers (378.18, 2213.797 or 378.218,
On 2014-01-07 1:22 PM, Larry Martell wrote:
Can I use an regexp in a conditional? I need to do something like this:
SELECT (IF r REGEXP '^ED[HMUZ][0-9]$', 'yes', 'no') FROM s;
I'm getting an error from that. Is there some way to do this?
SELECT IF( r REGEXP '^ED[HMUZ][0-9]$', 'yes', 'no' )
F
On 2013-12-04 1:33 PM, Ilya Kazakevich wrote:
Hello,
Have anybody tried to upgrade 5.1 to 5.6? I believe running mysql_upgrade
should be enough, but does there are some caveats?
Ilya Kazakevich.
The MySQL recommendation is to upgrade one major version at a time, ie
5.1->5.5->5.6. There are s
On 2013-09-23 8:10 PM, Jeremiah Jester wrote:
Hello,
How would i go about selecting 5
random cars that are flagged as internet_special (value 1) for each
dealer from a specific table? Ive tried sub selects with no luck.
Here's a basic query that has my
required conditional. Note that I get all
On 2013-03-29 9:57 AM, Dotan Cohen wrote:
On Thu, Mar 28, 2013 at 11:15 PM, Peter Brawley
wrote:
Can someone run the server with --skip-grant-tables to retrieve this code?
Possibly, I'll ask. However, it is highly unlikely that such a thing
was done to create the routine.
That'
On 2013-03-28 3:33 PM, Dotan Cohen wrote:
On Wed, Mar 27, 2013 at 5:46 PM, wrote:
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.
On 2013-03-25 4:28 AM, Dotan Cohen wrote:
On Sun, Mar 24, 2013 at 11:08 PM, Peter Brawley
wrote:
Log in as admin@localhost.
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?
Ask admin to grant you the required
On 2013-03-24 8:25 AM, Dotan Cohen wrote:
A MySQL database is using a stored function avg_sales in some SQL
queries. I am having a hard time finding the code for this function,
in order to track down a bug that I suspect is in the function. Here
is what I get when I try to query MySQL for the fun
On 2013-03-21 8:12 AM, Norah Jones wrote:
I'm trying to create a foreign key on two columns but getting error...
Here's what I tried:
CREATE TABLE test2 (
ID INT NOT NULL AUTO_INCREMENT,
col1 INT NOT NULL,
col2 INT NOT NULL,
PRIMARY KEY (ID),
CONSTRAINT f
On 2013-02-07 8:29 PM, Daevid Vincent wrote:
http://adtmag.com/articles/2013/02/06/mysql-update.aspx
The headline is weirdly deceptive. Mebbe they thought the headline would
draw eyes to their ads.
This edition of MySQL is less like NoSQL, and more determinedly
relational, than any before.
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,
specialprice,
unitprice
) as used_pric
On 2013-01-31 8:13 PM, Angela Barone wrote:
Hello,
I'm trying to write a select query that grabs two prices from my db and
displays them on a web page. I want it to grab the `listprice`, and either the
`unitprice` or the `specialprice` depending on the following criteria:
if the `spec
On 2012-12-18 2:52 AM, Haidar Pesebe wrote:
Hi all--
There are 3 tables which each like this:
NOTE: The linkage between table A and table B is ID and IDPUBLISHER, while Table
B to C is the ISBN. Sometimes there are some titles that are not sold
in a given month.
TABLE A (Publisher)
On 2012-12-14 3:28 AM, Neil Tompkins wrote:
Hi,
I've the following data
total, supplier_id, product_name, supplier_code
125,2,iPod,xyz123
100,1,iPod,abc123
145,3,iPod,1213113
245,4,iPod,12345
What query do I need to get the lowest total in this case 100 for
supplier_id 1 ?
See "Within-group
>ERROR 1054 (42S22): Unknown column 'data_tool.category_id' in 'on clause'
>But category_id is a column in data_tool.
Then a bit of reordering is required ...
SELECT data_target.name, ep, wafer_id, lot_id,
date_time, data_file_id, data_cstimage.name,
bottom, wf_file_path_id, data_m
On 2012-12-11 3:19 PM, Larry Martell wrote:
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, d
On 2012-12-03 7:40 AM, amit wrote:
Hi Team,
I am not able to use multi value insert via argument in mysql stored
procedure, Please help where am I wrong. Thanks in Advance !
mysql> insert into input_data1 values(),(),(),();
Query OK, 4 rows affected (0.00 sec)
*Problem*
mysql
when I call a
stored procedure does the control get backs immediately to the php script?
No, sprocs wil lvery likely slow you down.
Probably best to split the job into several part-tasks (i) read rows into a
work buffer, (ii) walk the work buffer and mark done rows, (iii) walk the done
list a
On 2012-11-14 5:08 PM, Mogens Melander wrote:
Thanks Rick
Yes, I know it's not going the most (in lack of descriptive words) pretty
piece of code. The variable number of columns is the key phrase here.
I've already told them, this is not a SQL task, but having infinite
trust in my peers "out th
On 2012-09-18 5:53 AM, Larry Martell wrote:
I have this query:
SELECT data_target.name as Target,
q1.ep as EP,
COUNT(*) as Wafers,
Lots,
SUM(numonep)/(COUNT(*)+SUM(CASE WHEN reruns > 0 THEN reruns
ELSE 0 END)) as 'Sites/Wafer',
MAX(LastRun) as "Last Run",
n 2012-09-17 12:58 PM, h...@tbbs.net wrote:
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 wron
cascade
on delete cascade,
...
) engine=innodb;
PB
thx in advance.
Rajeev
From: Peter Brawley
To: Rajeev Prasad ; "mysql@lists.mysql.com"
Sent: Wednesday, August 15, 2012 4:01 PM
Subject: Re: suggestion needed for table
On 2012-08-15 1:54 PM, Rajeev Prasad wrote:
I have to keep this data in MySql, and i am not sure (as SQL/databse is not my
field) how to organise this into one or many tables? right now I would
represent my info as follows:
device_name|HW_version|SW_version|IP_addr_pvt|IP_addr_pub|data_specifi
On 2012-07-07 9:52 AM, Cabbar Duzayak wrote:
Hmm,
Looking at the link http://www.artfulsoftware.com/infotree/queries.php
and explanations here, EXISTS() should have performed better, but does
not seem to??? I stopped it after about 5 minutes.
I tried both:
SELECT * FROM A WHERE EXISTS (SELE
On 2012-07-06 5:07 PM, David Lerer wrote:
Cabbar, try to replace the IN subquery with an EXISTS. Something like:
SELECT * FROM A WHERE EXISTS (SELECT * FROM B WHERE A.id=B.A_ID and B.name
like 'X%');
See "The unbearable slowness of IN()" at
http://www.artfulsoftware.com/infotree/queries.
On 2012-05-25 8:35 AM, h...@tbbs.net wrote:
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
On 2012-05-21 11:17 AM, Don Wieland wrote:
I have got this query that returns the correct rows I want to display,
BUT the columns dr_ther_qty, dr_not_ther_qty, and dr_all_ther_qty are
not calculating correctly:
--- START QUERY ONE ---
SELECT q1.* FROM
(SELECT apt.user_id, apt.client_id, c.l
On 2012-05-17 9:37 AM, Don Wieland wrote:
Hi folks,
I am trying to compile a query that does statistics on appointments
based on specific criteria. Here is my starting query:
SELECT
u.user_id,
c.client_id,
c.first_name,
c.last_name,
a.time_start AS stime,
FROM_UNIXTIME
On 4/11/2012 1:30 PM, Haluk Karamete wrote:
I've got this relational mySQL table that ties peopleIDs from the people
table to the states IDs
peopleID___stateID
1__1
2__4
3__5
people table is like this;
___peopleID_FName__
On 2/22/2012 9:47 AM, Steven Staples wrote:
Good [insert time of day here] all!
I am trying to reorder my auto-inc field in my database, and I have
successfully done it with my "front end" that I use (SQLYog) with the
following code:
SET @var_name = 0;
UPDATE `my_database`.`my_table` SET `id` =
On 2/13/2012 10:18 AM, James W. McNeely wrote:
When I run this query in workbench:
select c.acc_number 'Accession Number', e.DateExam 'MBI Exam Date', s.ExamDate
'SJH Exam Date'
from chestcon_log c
left join exams e on CONCAT("000",c.acc_number) = e.LastWordAccNum
left join sjhreports_ s on c.ac
On 2/12/2012 4:40 PM, Reindl Harald wrote:
Am 12.02.2012 23:25, schrieb Cabbar Duzayak:
Hi All,
I have a table with a btree index on its searchKey column, and when I
send a simple query on this table:
explain select * from DataIndex where (searchKey like 'A%') order by
searchKey limit 10
rows
On 2/5/2012 9:21 PM, Michael Dykman wrote:
You are right. It seems to have fallen into disuse since I used it last.
AFAIK it has never been used.
PB
-
At any rate, the format does not affect storage. I, like most others,
generally specify the format using the date_format function wit
On 1/27/2012 2:24 PM, william drescher wrote:
On 1/27/2012 3:21 PM, Peter Brawley wrote:
On 1/27/2012 11:18 AM, william drescher wrote:
Is there a way to set the default of a date field to the date
the record is generated ?
bill
Use a TIMESTAMP. Default DATE(TIME) columns with Triggers
On 1/27/2012 11:18 AM, william drescher wrote:
Is there a way to set the default of a date field to the date the
record is generated ?
bill
Use a TIMESTAMP. Default DATE(TIME) columns with Triggers.
PB
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubsc
On 1/27/2012 12:09 PM, John Heim wrote:
I'm trying to create a function that formats a time in a standard way
('%H:%i'). But all I can seem to get back is null.
DROP TABLE IF EXISTS bogus_table;
CREATE TABLE IF NOT EXISTS bogus_table (
btime TIME
);
INSERT INTO bogus_table VALUES ('12:34:56');
On 1/20/2012 5:54 AM, bruce wrote:
Hi.
Got a major pain that I'm trying to solve using mysql.
Trying to handle a hierarchical tree structure, where I have a
parent/child structure that grows as data is added to the system.
The process needs to continuously determine if the overall tree, and
al
the status of the childID/app.
And like I said, I'm not quite sure how to proceed in an efficient
manner on this.
Thanks
On Mon, Jan 16, 2012 at 4:08 PM, Peter Brawley
wrote:
On 1/16/2012 2:08 PM, bruce wrote:
Hi Peter.
Not a mysql guru... so I've never used stored procedures/s
On 1/16/2012 12:53 PM, bruce wrote:
On Mon, Jan 16, 2012 at 1:52 PM, bruce wrote:
Hey Authur.
Should have been more clear. I've looked over a number of sites. And
with the exception of the the articles that talk about using the
"Nested List" approach, nowhere did I find data on how to get a
co
On 1/8/2012 2:21 PM, Donovan Brooke wrote:
Hello, I'm doing an insert into with date and time type fields.
I was reading:
http://dev.mysql.com/doc/refman/5.1/en/date-and-time-literals.html
My question is: is the format always 'year month day'?.. or can we
save dates in 'month day year' as well
On 12/27/2011 12:13 PM, Mark Haney wrote:
I've had a DEVIL of a time with this problem and I'm sure it's something
simple, but I can't find it anywhere in the documentation or online what the
problem is. Let me explain.
I cannot get any WHILE loop to work from either a CLI or a script on MySQ
On 12/3/2011 9:35 PM, Jan Steinman wrote:
Second attempt, using a join, returns just one row for Dewey "000" with the
COUNT being about half the volumes in the library, which isn't right...
I thought a LEFT OUTER JOIN would have returned a record for every record in
s_library_dewey, but it onl
On 11/15/2011 2:10 PM, Angela liu wrote:
In mysql 5.0 ,how to check how big a database is?
Thanks
See "Database size" at http://www.artfulsoftware.com/queries.php
PB
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?
On 10/21/2011 3:05 AM, 王科选 wrote:
Hi,
Is there any way to dynamically create database and tables on mysql?
For example, if I want to create 100 databases(dbname is unknown until
run time), with 100 predefined tables in it, how to achieve that?
Thanks in advance!
Easiest mebbe from a scripting
On 10/20/2011 9:11 AM, Shawn Green (MySQL) wrote:
On 10/19/2011 20:03, Dotan Cohen wrote:
...
Thank you Shawn. I very much appreciate your help, and I also
appreciate your employer's initiative to have such a position
monitoring the mailing list. Is that an Oracle-created position, or
did it
On 10/11/2011 12:26 PM, Paul Halliday wrote:
On Tue, Oct 11, 2011 at 10:37 AM, Peter Brawley
wrote:
On 10/11/2011 8:11 AM, Paul Halliday wrote:
I have the following query:
SELECT COUNT(signature) AS count, MAX(timestamp) AS maxTime,
INET_NTOA(src_ip), map1.cc as src_cc, INET_NTOA(dst_ip
On 10/11/2011 8:11 AM, Paul Halliday wrote:
I have the following query:
SELECT COUNT(signature) AS count, MAX(timestamp) AS maxTime,
INET_NTOA(src_ip), map1.cc as src_cc, INET_NTOA(dst_ip), map2.cc as
dst_cc, signature, signature_id, ip_proto FROM event LEFT JOIN
mappings AS map1 ON event.src_ip
Several MySQL fora, including all the Usage fora, have been overrun by
spam to the point of unusability, with no sign of effective remediation.
This gives the impression that a process of letting MySQL die of
neglect has begun.
PB
--
MySQL General Mailing List
For list archives: http://lists
On 10/4/2011 4:20 PM, Adam Gerson wrote:
I am getting the error that "TABLENAME" does not exist. How do I get
it to substitute the value stored in TABLENAME, and not the literal
string?
See the manual page for PREPARE.
PB
-
begin
declare v_max int unsigned default 1;
declare v_counter
On 9/26/2011 1:30 PM, Michael Albert wrote:
I don't suppose I am the first to notice this, but most of
the pages on dev.mysql.com have been listed by google
as "attack pages", e.g http://dev.mysql.com/downloads/.
Has there been a problem, or is google being overzealous?
No. There are problems on
On 9/2/2011 6:15 AM, Jochem van Dieten wrote:
On Wed, Aug 31, 2011 at 4:10 AM, Peter Brawley wrote:
While a transaction in one thread tries to update a non-existent InnoDB row
with a given key value, an attempt to insert that value in another thread is
locked out. Does anyone know where this
On 9/1/2011 9:06 AM, Jerry Schwartz wrote:
-Original Message-
From: Peter Brawley [mailto:peter.braw...@earthlink.net]
Sent: Wednesday, August 31, 2011 10:40 AM
To: r...@grib.nl; mysql@lists.mysql.com
Subject: Re: locked non-existent row
On 8/31/2011 4:50 AM, Rik Wasmus wrote:
While a
On 9/1/2011 9:46 AM, Rik Wasmus wrote:
-Original Message-
From: Peter Brawley [mailto:peter.braw...@earthlink.net]
Sent: Wednesday, August 31, 2011 10:40 AM
To: r...@grib.nl; mysql@lists.mysql.com
Subject: Re: locked non-existent row
On 8/31/2011 4:50 AM, Rik Wasmus wrote:
While a
On 8/31/2011 4:50 AM, Rik Wasmus wrote:
While a transaction in one thread tries to update a non-existent InnoDB
row with a given key value, an attempt to insert that value in another
thread is locked out. Does anyone know where this behaviour is documented?
-- connection 1
drop table if exists t
While a transaction in one thread tries to update a non-existent InnoDB
row with a given key value, an attempt to insert that value in another
thread is locked out. Does anyone know where this behaviour is documented?
-- connection 1
drop table if exists t;
create table t( lockid char(3), locki
On 8/19/2011 5:10 AM, Adarsh Sharma wrote:
Dear all,
I researched a lot on storing Hierarchical data in mysql tables.
Below links :
http://scvinodkumar.wordpress.com/2011/01/30/managing-hierarchical-data-in-mysql/
http://www.sitepoint.com/hierarchical-data-database-2/
shows different ways t
On 8/10/2011 1:01 PM, Brandon Phelps wrote:
Hello all,
I am using the query below and variations of it to query a database
with a TON of records. Currently the database has around 11 million
records but it grows every day and should cap out at around 150 million.
I am curious if there is an
On 7/12/2011 9:45 AM, Jerry Schwartz wrote:
Let this be a lesson to all of those designers who say "That will never
happen."
"Let this be a lesson to all of those designers who say ''That will
never happen'" will never happen. :-)
PB
-
Regards,
Jerry Schwartz
Global Information Incorpor
On 7/10/2011 3:32 AM, vishesh kumar wrote:Hi Members
Whats wrong i am doing in following create trigger statement
Create trigger test before insert on user
for each row
begin
set New.host=upper(new.host)
end
Above statement giving error check sql syntax , please guide me.
> Is it ALWAYS possible to fabricate a query/schema in
> such a way that MySQL ALWAYS uses the ideal
No. Optimisation is better in 5.6 than in 5.0, though.
Did you try adding multi-column indexes to cover the join and the order
by clause?
> 'Using where' extra -- you just have to keep at it?
On 5/12/2011 2:30 PM, Grega Leskovšek wrote:
CREATE TABLE log ( idlog int auto_increment not null, imepriimek
varchar(50), clock timestamp, action varchar(30), onfile
varchar(100), filesize float(6,2), uniqueid(idlog) );
CREATE TABLE log (
idlog int auto_increment primary key,
imepriimek va
>I would like to create a table with the top 25 Amt_Sold products for
each day
Examples at "Top N per group" at http://www.artfulsoftware.com/queries.php
PB
-
On 5/8/2011 12:21 PM, mos wrote:
I have a table (MyISAM) with summarized Sales data:
Table: ProdSales
Columns:
Sales_Date Date
hit many
different nodes. I always tried to avoid joins because I am planning
to horizontally partition my data. But if MySQL cluster can handle
this join transparently and split it up based on the partition, then
that's fine. Do you have any info on this?
Greg
On 3/29/11 2:10 PM, Peter Bra
> How can I quickly find all the articles written by this user's
friends, and not just random articles?
Taking the simplest possible case, with table friends(userID,friendID)
where each friendID refers to a userID in another row, the friends of
userID u are ...
select friendID from user wher
> What I need is a list of orgs they bought all of items 34, 36, 58,
63. every of them.
Some solutions under "What else did buyers of X buy" at
http://www.artfulsoftware.com/infotree/queries.php.
PB
---
On 3/17/2011 12:00 PM, LAMP wrote:
Yes, that was my question. Though, since English is n
Yes, but Access s "IIF", of the same use, evaluates all three, and the
documentation explicitly says so.
Let's be glad we don't depend on Access, then.
PB
-
On 3/14/2011 7:52 PM, Sándor Halász wrote:
2011/03/14 16:08 +0100, Johan De Meersman
I'm afraid I'm not authoritative on t
er Windows boxes.
PB
-
On 3/11/2011 10:31 AM, Sándor Halász wrote:
2011/03/10 23:03 -0600, Peter Brawley>>>>
On 3/10/2011 8:10 PM, h...@tbbs.net wrote:
MYSQLDUMP.EXE (Ver 10.13 Distrib 5.5.8, for Win32 (x86)) has flags for
trigger-dumping; the help that I downloaded for this
1 - 100 of 894 matches
Mail list logo