Re: How do I determine if versions of phpMyAdmin before 4.8.5 is SQL Injectable using sqlmap?

2019-04-17 Thread shawn l.green
Hello, On 4/17/2019 10:29 AM, Turritopsis Dohrnii Teo En Ming wrote: Subject/Topic: How do I determine if versions of phpMyAdmin before 4.8.5 is SQL Injectable using sqlmap? Good evening from Singapore, Our customer (company name is Confidential/not disclosed) reported that their MySQL

How do I determine if versions of phpMyAdmin before 4.8.5 is SQL Injectable using sqlmap?

2019-04-17 Thread Turritopsis Dohrnii Teo En Ming
Subject/Topic: How do I determine if versions of phpMyAdmin before 4.8.5 is SQL Injectable using sqlmap? Good evening from Singapore, Our customer (company name is Confidential/not disclosed) reported that their MySQL database has been found missing or was deleted a few times. They are using

Re: how to select the record with one sql statement?

2018-08-18 Thread shawn l.green
for num_of_day); expecting the output: certain_day, pigId;from certain_day, pigId'weight increasing continuously for num_of_day. How to select the records in one sql statement? thanks I've thought about this a bit (since your question appeared on the list) and I break down the tasks you

how to select the record with one sql statement?

2018-08-13 Thread sea
certain_day, pigId'weight increasing continuously for num_of_day. How to select the records in one sql statement? thanks

Re: Automated SQL checker?

2017-04-13 Thread SSC_perl
> On Apr 12, 2017, at 3:38 PM, Ronan McGlue wrote: > > Enable the slow log on the DB. Thanks Ronan. That sounds like it would be beneficial. I take it you’re referring to a setting on the server, though. If that’s the case, I don’t think I can do that as

Re: Automated SQL checker?

2017-04-12 Thread Ronan McGlue
Hi Frank, Enable the slow log on the DB. Any queries which are above the threshold variable ( |long_query_time| ) will be logged . Default is 10s, so I assume you'd want to drop this down to 1-2 (

Re: Automated SQL checker?

2017-04-12 Thread SSC_perl
> On Apr 11, 2017, at 1:26 PM, Michael Munger > wrote: > > Use MySQL workbench. Thanks, Michael. I played with it some already and it looks like it will give me a lot to work with. Will it also let me know if field types are wrong for the given

RE: Automated SQL checker?

2017-04-11 Thread Michael Munger
ist <mysql@lists.mysql.com> Subject: Automated SQL checker? Is there a way, perhaps with a script or a service, that one can check MySQL code to see about making it more efficient? I maintain an open source shopping cart written in Perl and it’s been awhile since the SQL has been work

Automated SQL checker?

2017-04-11 Thread SSC_perl
Is there a way, perhaps with a script or a service, that one can check MySQL code to see about making it more efficient? I maintain an open source shopping cart written in Perl and it’s been awhile since the SQL has been worked on, so I want to see if it could use some updating

Re: Unsubscribing my sql mailing list

2015-07-23 Thread Reindl Harald
why do you think we could do that for you and what do you think is that link in every mail for? YES i send this to the list hopefully to save a few of this meh i can't handle my mail. To unsubscribe:http://lists.mysql.com/mysql Am 22.07.2015 um 18:08 schrieb Charles Turner: Dear

Unsubscribing my sql mailing list

2015-07-22 Thread Charles Turner
Dear Sirs, I'd like to unsubscribe my subscription to this mailing list. Thank you so much. Regards Andrea Fanni -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

ANN: SQL Maestro for MySQL 15.5 released

2015-05-18 Thread SQL Maestro Team
Hi! SQL Maestro Group announces the release of SQL Maestro for MySQL 15.5, a powerful Windows GUI solution for MySQL administration and database development. The new version is immediately available for download at http://www.sqlmaestro.com/products/mysql/maestro/ Top 10 new features

Re: Merging multiple SQL requests

2015-02-23 Thread Johan De Meersman
- Original Message - From: Jay Ess li...@netrogenic.com Subject: Re: Merging multiple SQL requests UNION is used to combine the result from multiple SELECT statements into a single result set. Yes, but only if your queries return the same number of fields; and you get a single

Re: Merging multiple SQL requests

2015-02-22 Thread Learner Study
Thanks for the response! Looks like the only way MySQL server would merge requests is based on keywords used by client side, such as UNION etc. If client doesn't specify such keyword, the server won't automatically merge multiple requests. I'm now profiling the MySQL code to identify the

Re: Merging multiple SQL requests

2015-02-21 Thread Jay Ess
On 2015-02-15 23:55, Learner Study wrote: Hello experts, Is it possible for MySQL server to automatically merge responses for different queries into a single response? Are there any kernel parameters that may dictate that? UNION is used to combine the result from multiple SELECT statements

is a .sql file transactional

2015-02-19 Thread thufir
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

Re: is a .sql file transactional

2015-02-19 Thread Johan De Meersman
- Original Message - From: thufir hawat.thu...@gmail.com 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 is nothing

Re: Merging multiple SQL requests

2015-02-17 Thread Bob Eby
Hi Learner, You might want to try reading about SQL JOIN and/or CLIENT_MULTI_STATEMENTS. Using databases is all about conglomerating results, but it helps to know the environment first.

Re: Merging multiple SQL requests

2015-02-16 Thread Johan De Meersman
- From: Learner Study learner.st...@gmail.com To: Stewart Smith stew...@linux.vnet.ibm.com Cc: MySql mysql@lists.mysql.com, internals intern...@lists.mysql.com Sent: Monday, 16 February, 2015 02:07:45 Subject: Re: Merging multiple SQL requests I meant that can MySQL server combine

Re: Merging multiple SQL requests

2015-02-15 Thread Stewart Smith
Learner Study learner.st...@gmail.com writes: Is it possible for MySQL server to automatically merge responses for different queries into a single response? Are there any kernel parameters that may dictate that? I'm not sure what you could be meaning here... In the client protocol? to send

Re: Merging multiple SQL requests

2015-02-15 Thread Learner Study
I meant that can MySQL server combine multiple responses for a client and send a single TCP packet back to the client. But based on your response, I don't think that is possible - please correct? Are there are any gothas to debug/investigate MySQL latency? I have checked TCP tunables, kernel

Merging multiple SQL requests

2015-02-15 Thread Learner Study
Hello experts, Is it possible for MySQL server to automatically merge responses for different queries into a single response? Are there any kernel parameters that may dictate that? Thanks! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Re: Merging multiple SQL requests

2015-02-15 Thread Stewart Smith
Learner Study learner.st...@gmail.com writes: I meant that can MySQL server combine multiple responses for a client and send a single TCP packet back to the client. Unless there's a way to send multiple simultaneous requests, you won't get multiple responses in one packet. -- MySQL General

When will MySQL support the ANSI SQL MERGE command?

2014-09-19 Thread ccleve
I need to do upserts and I need cross-database compatibility. I'd hate to drop support for MySQL in my product. Does MySQL plan to support the ANSI-standard MERGE command for upserts? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Re: When will MySQL support the ANSI SQL MERGE command?

2014-09-19 Thread shawn l.green
Hello ccleve, On 9/19/2014 3:06 PM, ccleve wrote: I need to do upserts and I need cross-database compatibility. I'd hate to drop support for MySQL in my product. Does MySQL plan to support the ANSI-standard MERGE command for upserts? You appear to be looking for one of these commands

sql syntax error

2014-08-08 Thread florent larose
hello, i am working on my personal website wih php 5.4.16 / mysql 5.6.12 (my system : windows 7 / wampserver 2). i have a bug when i am running my connection to database webpage. My error message is the following : Erreur SQL : You have an error in your SQL syntax; check the manual

Re: sql syntax error

2014-08-08 Thread Johan De Meersman
- Original Message - From: florent larose florent.lar...@hotmail.com Subject: sql syntax error near ''membres2' WHERE [...] FROM 'espace_membre2'.'membres2' WHERE You were on the right path - mysql is wibbly about quotes. Either remove the quotes entirely ( espace_membre2

Re: sql syntax error

2014-08-08 Thread Christophe
Hi, Le 08/08/2014 17:48, Johan De Meersman a écrit : As your code is french, I'll assume you're on Azerty; the backtick is Alt-Gr plus the rightmost key (right next to return) on the middle row. Enjoy spraining your fingers :-p /johan Alt-GR plus '7' for French keyboard layout ;)

Migration from SQL Server

2014-07-14 Thread Felipe Coutinho
Hello, I'm a web developer and I'm developing a web application on Rails. I'm gonna use MySQL at production (I'm using Amazon RDS with MySQL) for this app. But this app already has a version of it (developed at ASP.NET) at production using SQL Server. Now I need to migrate the data from SQL

Re: Migration from SQL Server

2014-07-14 Thread Carlos Proal
Workbench provides some migration features and supports SQL Server http://www.mysql.com/products/workbench/migrate/ On Mon, Jul 14, 2014 at 4:47 PM, Felipe Coutinho felipelcouti...@gmail.com wrote: Hello, I'm a web developer and I'm developing a web application on Rails. I'm gonna use

career advice - Excel Expert and MySQL SQL specialist

2014-02-19 Thread Lukas Lehner
Hi I passed Oracle SQL Expert and working on MySQL 5.6 developer exam. I work 5% of my job with SQL but I am searching for a full time SQL job. http://shop.oreilly.com/product/0790145363466.do Is the Excel exam (Microsoft Office Specialist - MOS) useful for getting a junior SQL pro job? What do

Re: LIKE sql optimization

2014-02-12 Thread Jesper Wisborg Krogh
On 12/02/2014 13:16, Morgan Tocker wrote: Hi Zhigang, On Feb 11, 2014, at 8:48 PM, Zhigang Zhang zzgang2...@gmail.com wrote: I want to know the reason, in my opinion, to scan the smaller index data has better performance than to scan the whole table data. I think I understand the question

RE: LIKE sql optimization

2014-02-12 Thread Zhigang Zhang
Done. Thand you very much! Zhigang _ From: Jesper Wisborg Krogh [mailto:my...@wisborg.dk] Sent: Wednesday, February 12, 2014 5:30 PM To: Morgan Tocker; Zhigang Zhang Cc: mysql@lists.mysql.com Subject: Re: LIKE sql optimization On 12/02/2014 13:16, Morgan Tocker wrote: Hi

LIKE sql optimization

2014-02-11 Thread Zhigang Zhang
For example: Select * from T where col like ‘%abcd’; The table T is myisam table and we created a index on col. As we known, this like sql does not use the index created on col, it confuse me, why? I think in mysiam engine, the index data is smaller, it can use index link list

Re: LIKE sql optimization

2014-02-11 Thread Reindl Harald
Am 12.02.2014 02:23, schrieb Zhigang Zhang: For example: Select * from T where col like ‘%abcd’; The table T is myisam table and we created a index on col. As we known, this like sql does not use the index created on col, it confuse me, why? I think in mysiam engine, the index data

Re: LIKE sql optimization

2014-02-11 Thread Mathieu Desharnais
Sql database doesn't use index in like statement if it starts with % .. like 'abcd%' would work though... To use an index you can store your value using reverse function and index it .. then your like would use the index. 2014-02-11 20:23 GMT-05:00 Zhigang Zhang zzgang2...@gmail.com

RE: LIKE sql optimization

2014-02-11 Thread Zhigang Zhang
@lists.mysql.com Subject: Re: LIKE sql optimization Sql database doesn't use index in like statement if it starts with % .. like 'abcd%' would work though... To use an index you can store your value using reverse function and index it .. then your like would use the index. 2014-02-11 20:23

Re: LIKE sql optimization

2014-02-11 Thread kitlenv
Desharnais [mailto:mdesharn...@diffusion.cc] Sent: Wednesday, February 12, 2014 9:41 AM To: Zhigang Zhang; mysql@lists.mysql.com Subject: Re: LIKE sql optimization Sql database doesn't use index in like statement if it starts with % .. like 'abcd%' would work though... To use an index you

Re: LIKE sql optimization

2014-02-11 Thread Reindl Harald
better performance than to scan the whole table data. From: Mathieu Desharnais [mailto:mdesharn...@diffusion.cc] Sent: Wednesday, February 12, 2014 9:41 AM To: Zhigang Zhang; mysql@lists.mysql.com Subject: Re: LIKE sql optimization Sql database doesn't use index in like statement

Re: LIKE sql optimization

2014-02-11 Thread louis liu
Subject: Re: LIKE sql optimization Sql database doesn't use index in like statement if it starts with % .. like 'abcd%' would work though... To use an index you can store your value using reverse function and index it .. then your like would use the index. 2014

Re: LIKE sql optimization

2014-02-11 Thread Mathieu Desharnais
: Mathieu Desharnais [mailto:mdesharn...@diffusion.cc] Sent: Wednesday, February 12, 2014 9:41 AM To: Zhigang Zhang; mysql@lists.mysql.com Subject: Re: LIKE sql optimization Sql database doesn't use index in like statement if it starts with % .. like 'abcd%' would work though

RE: LIKE sql optimization

2014-02-11 Thread Zhigang Zhang
I checked a myisam table index, the index is a copy of the whole field. Zhigang -Original Message- From: Reindl Harald [mailto:h.rei...@thelounge.net] Sent: Wednesday, February 12, 2014 10:02 AM To: mysql@lists.mysql.com Subject: Re: LIKE sql optimization because a index

Re: LIKE sql optimization

2014-02-11 Thread Morgan Tocker
Hi Zhigang, On Feb 11, 2014, at 8:48 PM, Zhigang Zhang zzgang2...@gmail.com wrote: I want to know the reason, in my opinion, to scan the smaller index data has better performance than to scan the whole table data. I think I understand the question - you are asking why MySQL will not index

RE: LIKE sql optimization

2014-02-11 Thread Zhigang Zhang
Thank you very much! Zhigang -Original Message- From: Morgan Tocker [mailto:morgan.toc...@oracle.com] Sent: Wednesday, February 12, 2014 10:16 AM To: Zhigang Zhang Cc: mysql@lists.mysql.com Subject: Re: LIKE sql optimization Hi Zhigang, On Feb 11, 2014, at 8:48 PM

ANN: SQL Maestro for MySQL 14.2 released

2014-02-06 Thread SQL Maestro Team
Hi! SQL Maestro Group announces the release of SQL Maestro for MySQL 14.2, a powerful Windows GUI solution for MySQL administration and database development. The new version is immediately available for download at http://www.sqlmaestro.com/products/mysql/maestro/ Top 10 new features

MySQL 5.0.0 [2003] vs. MySQL 5.6 [2013] from a SQL and SQL/PSM developer viewpoint

2014-01-07 Thread Lukas Lehner
Hi Are there big changes between MySQL 5.0.0 vs. MySQL 5.6? I am only interested in developer changes (not admin) Can I use development books for MySQL 5.0.0 [2003] and use the code an recent MariaDB and MySQL releases?

Re: MySQL 5.0.0 [2003] vs. MySQL 5.6 [2013] from a SQL and SQL/PSM developer viewpoint

2014-01-07 Thread Reindl Harald
Am 07.01.2014 13:48, schrieb Lukas Lehner: Are there big changes between MySQL 5.0.0 vs. MySQL 5.6? I am only interested in developer changes (not admin) Can I use development books for MySQL 5.0.0 [2003] and use the code an recent MariaDB and MySQL releases? clearly yes the *other

Re: How do I mysqldump different database tables to the same .sql file?

2013-11-22 Thread Johan De Meersman
--databases, methinks. - Original Message - From: Daevid Vincent dae...@daevid.com To: mysql@lists.mysql.com Sent: Thursday, 21 November, 2013 10:44:39 PM Subject: How do I mysqldump different database tables to the same .sql file? I'm working on some code where I am trying

Re: How do I mysqldump different database tables to the same .sql file?

2013-11-21 Thread Michael Dykman
option to force it to output this seemingly obvious statement. It's a pretty significant shortcoming of mysqldump if you ask me that I can't do it the way I had it in the first example since that's pretty much standard SQL convetion of db.table.column format. And even more baffling is why

RE: How do I mysqldump different database tables to the same .sql file?

2013-11-21 Thread Daevid Vincent
do I mysqldump different database tables to the same .sql file? There is a good reason that the USE database is not output in those dumps.. it would make the tool very difficult to use for moving data around. If I might suggest, a simple workaround is to create a shell script along

How do I mysqldump different database tables to the same .sql file?

2013-11-21 Thread Daevid Vincent
this seemingly obvious statement. It's a pretty significant shortcoming of mysqldump if you ask me that I can't do it the way I had it in the first example since that's pretty much standard SQL convetion of db.table.column format. And even more baffling is why it wouldn't dump out the USE statement

RE: How can I drop a table that is named “logs/#sql-ib203” and appeared after MySQL crash?

2013-06-25 Thread Rick James
If a crash occurs in the middle of an ALTER, the files may not get cleaned up. -Original Message- From: Reindl Harald [mailto:h.rei...@thelounge.net] Sent: Thursday, June 20, 2013 12:57 PM To: mysql@lists.mysql.com Subject: Re: How can I drop a table that is named “logs/#sql-ib203

Re: How can I drop a table that is named “logs/#sql-ib203” and appeared after MySQL crash?

2013-06-25 Thread Reindl Harald
that is named “logs/#sql-ib203” and appeared after MySQL crash? i know what happened but how get rid of these two bullshit files after *three years* not touched and used by mysqld Am 20.06.2013 21:28, schrieb Rick James: #sql files are temp tables that vanish when the ALTER (or whatever) finishes

Re: How can I drop a table that is named “logs/#sql-ib203” and appeared after MySQL crash?

2013-06-21 Thread Jesper Wisborg Krogh
Hi Frank, On 20/06/2013 05:00, Franck Dernoncourt wrote: Hi all, A table `logs/#sql-ib203` appeared after a MySQL crash due to disk space shortage while deleting some attributes in a table in the `logs` database and adding an index. `USE logs; SHOW TABLES;` does not list the table `logs/#sql

Re: How can I drop a table that is named “logs/#sql-ib203” and appeared after MySQL crash?

2013-06-20 Thread Denis Jedig
Franck, Am 19.06.2013 21:00, schrieb Franck Dernoncourt: A table `logs/#sql-ib203` appeared after a MySQL crash the #sql-ibtableID tables are temporarily created during an ALTER TABLE operation for recovery purposes. Apparently these temporary tables might stay in certain circumstances

Re: How can I drop a table that is named “logs/#sql-ib203” and appeared after MySQL crash?

2013-06-20 Thread Carsten Pedersen
This may be a naive question, but I'm not sure I can see you've covered this: Have you tried USE logs before DROP TABLE `#sql-ib203` (without the logs/ bit)? / Carsten On 19-06-2013 21:00, Franck Dernoncourt wrote: Hi all, A table `logs/#sql-ib203` appeared after a MySQL crash due to disk

Re: How can I drop a table that is named “logs/#sql-ib203” and appeared after MySQL crash?

2013-06-20 Thread Franck Dernoncourt
On Thu, Jun 20, 2013 at 7:13 AM, Denis Jedig d...@syneticon.net wrote: If you already tried enclosing the table name in backticks (DROP TABLE `#sql-ib203`) and using the DROP TEMPORARY TABLE syntax without success, Yep, no success with: DROP TEMPORARY TABLE `logs/#sql-ib203`; DROP TEMPORARY

Re: How can I drop a table that is named “logs/#sql-ib203” and appeared after MySQL crash?

2013-06-20 Thread Franck Dernoncourt
On Thu, Jun 20, 2013 at 3:28 PM, Rick James rja...@yahoo-inc.com wrote: #sql files are temp tables that vanish when the ALTER (or whatever) finishes. If you find one sitting around, it sounds like a crash happened in the middle of the ALTER. Yes the crash happened during an ALTER: the table

Re: How can I drop a table that is named “logs/#sql-ib203” and appeared after MySQL crash?

2013-06-20 Thread Reindl Harald
i know what happened but how get rid of these two bullshit files after *three years* not touched and used by mysqld Am 20.06.2013 21:28, schrieb Rick James: #sql files are temp tables that vanish when the ALTER (or whatever) finishes. If you find one sitting around, it sounds like a crash

RE: How can I drop a table that is named “logs/#sql-ib203” and appeared after MySQL crash?

2013-06-20 Thread Rick James
#sql files are temp tables that vanish when the ALTER (or whatever) finishes. If you find one sitting around, it sounds like a crash happened in the middle of the ALTER. -Original Message- From: Reindl Harald [mailto:h.rei...@thelounge.net] Sent: Wednesday, June 19, 2013 12:19 PM

How can I drop a table that is named “logs/#sql-ib203” and appeared after MySQL crash?

2013-06-19 Thread Franck Dernoncourt
Hi all, A table `logs/#sql-ib203` appeared after a MySQL crash due to disk space shortage while deleting some attributes in a table in the `logs` database and adding an index. `USE logs; SHOW TABLES;` does not list the table `logs/#sql-ib203`, but when trying to `ALTER` the table that was being

Re: How can I drop a table that is named “logs/#sql-ib203” and appeared after MySQL crash?

2013-06-19 Thread Reindl Harald
Am 19.06.2013 21:00, schrieb Franck Dernoncourt: `USE logs; SHOW TABLES;` does not list the table `logs/#sql-ib203`, but when trying to `ALTER` the table that was being changed during the crash MySQL complains about the existence of the table `logs/#sql-ib203`: ERROR 1050: Table 'logs/#sql

Re: Importing SQL dumps into MySQL through Command line

2013-03-31 Thread Manuel Arostegui
2013/3/31 Norah Jones nh.jone...@gmail.com Hi, To source sqldump i can use the source command, but if I need to do the same stuff using command line without going to the sqlpromt, can I achieve that. Hello, You mean cat sqldump.sql | mysql -uwhatever -pwhatever whatever_database ?

RE: Create a VIEW with nested SQL

2012-09-11 Thread hsv
, customer.name, MAX(payments) FROM order,customer WHERE order.custid = customer.custid GROUP BY order.custid; In standard SQL, you would have to add customer.name to the GROUP BY clause. In MySQL, the name is redundant. When using this feature, all rows in each group should have the same values

RE: Create a VIEW with nested SQL

2012-09-10 Thread Rick James
. MariaDB decides that this construct can be optimized, and messes up the 'trick'. -Original Message- From: Mark Haney [mailto:ma...@abemblem.com] Sent: Friday, September 07, 2012 6:12 AM To: mysql@lists.mysql.com Subject: Re: Create a VIEW with nested SQL On 09/06/2012 10:23 AM, h

Re: Create a VIEW with nested SQL

2012-09-07 Thread Mark Haney
, MySQL balks at saving a view with a query for a table. One has to make them separate views. Now that's a syntax I've never seen before. Then again, I haven't done any serious SQL in about 5 years, so I shouldn't be surprised. If I read your question correctly about mach_id, the mach_id

Re: Create a VIEW with nested SQL

2012-09-07 Thread Mark Haney
On 09/06/2012 10:23 AM, h...@tbbs.net wrote: SELECT lights.*, machine.mach_name FROM lights JOIN machine USING (mach_id) /* ORDER BY date DESC */ GROUP BY mach_id ? With USING the fields mach_id from lights and machine become one unambiguous field mach_id. Does mach_id really occur more

RE: Create a VIEW with nested SQL

2012-09-07 Thread Rick James
...@abemblem.com] Sent: Thursday, September 06, 2012 5:51 AM To: mysql@lists.mysql.com Subject: Create a VIEW with nested SQL I have a bit of a performance/best practice question for those in the know. I have a nested SQL statement that selects fields from a SELECT that has a JOIN in it. Here's the SQL

Re: Create a VIEW with nested SQL

2012-09-07 Thread hsv
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 ugly means of

Create a VIEW with nested SQL

2012-09-06 Thread Mark Haney
I have a bit of a performance/best practice question for those in the know. I have a nested SQL statement that selects fields from a SELECT that has a JOIN in it. Here's the SQL: SELECT vLight.* FROM (SELECT lights.*, machine.mach_name from lights JOIN machine ON lights.mach_id

Re: Create a VIEW with nested SQL

2012-09-06 Thread hsv
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 USING (mach_id) /* ORDER

Re: Having trouble with SQL query

2012-08-27 Thread rich gray
Hi Nitin Thanks - I tried that and got 0 rows... I have spent more time on describing my problem -- see below hopefully this will make the issue more clear... Rich I have a MySQL database with a menu table and a product table. - The products are linked to the menus in a one-to-many

Re: Having trouble with SQL query

2012-08-27 Thread Shawn Green
Hello Rich, On 8/27/2012 12:19 PM, rich gray wrote: Hi Nitin Thanks - I tried that and got 0 rows... I have spent more time on describing my problem -- see below hopefully this will make the issue more clear... Rich ... snip ... There are many resources out there that can tell you how to

Having trouble with SQL query

2012-08-26 Thread rich gray
I have a MySQL database with a menu table and a product table linked to the menus *(each product can be linked to more than menu row)* and the menus are nested. The query is that when a user clicks on a menu entry then all products linked to that entry *(there may be none)* will get displayed

Re: Having trouble with SQL query

2012-08-26 Thread Nitin Mehta
that works.     Regards,   From: rich gray r...@richgray.com To: mysql@lists.mysql.com Sent: Monday, August 27, 2012 2:46 AM Subject: Having trouble with SQL query I have a MySQL database with a menu table and a product table linked to the menus *(each product can

RE: Hi, how did u do de-emphasis of sql statements?

2012-08-20 Thread Rick James
Message- From: Johan De Meersman [mailto:vegiv...@tuxera.be] Sent: Monday, August 13, 2012 5:49 AM To: MID.night Cc: 673575760; mysql Subject: Re: Hi, how did u do de-emphasis of sql statements? - Original Message - From: MID.night 693893...@qq.com Like select * from table

Hi, how did u do de-emphasis of sql statements?

2012-08-13 Thread MID.night
Hey man, I would like to ask a question about de-emphasis of sql statements? I Mean mysql engines have to be aware of which two statements are exactly the same Despite of variables?? values at runtime. Because in slow log, the execution counter is Maintained for each sql statement. De

Re: Hi, how did u do de-emphasis of sql statements?

2012-08-13 Thread Johan De Meersman
does not bother about that, though, as there is no execution plan cache. The query result cache does not equate the statements - it works based off the EXACT query text, INCLUDING spaces and capitalization. When analyzing various logs, the Maatkit/Aspersa/Percona toolset does transform SQL

?????? Hi, how did u do de-emphasis of sql statements?

2012-08-13 Thread MID.night
this?..._/// -- -- ??: Johan De Meersmanvegiv...@tuxera.be; : 2012??8??13??(??) 8:48 ??: MID.night693893...@qq.com; : 673575760673575...@qq.com; mysqlmysql@lists.mysql.com; : Re: Hi, how did u do de-emphasis of sql

Mysql starts to die at 27 SQL processes

2012-05-31 Thread J M
hi all, i have an issue with our db which hangs and the only way to recover from it is to restart mysql if you had console access or restart the box itself ( only if i can't wait ) show processlist result can be found here: http://pastebin.com/BYvZ5ZFR listed below are info about

Re: Mysql starts to die at 27 SQL processes

2012-05-31 Thread Baron Schwartz
In this case the solution is much easier outside of MySQL than inside. http://ocaoimh.ie/wp-super-cache/ is an excellent option. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

Re: Mysql starts to die at 27 SQL processes

2012-05-31 Thread J M
Thank Baron, i want to see if there is something i can do from the DB end. and BTW, i've been using the plugin already. On Thu, May 31, 2012 at 1:01 PM, Baron Schwartz ba...@xaprb.com wrote: In this case the solution is much easier outside of MySQL than inside.

RE: Mysql starts to die at 27 SQL processes

2012-05-31 Thread Rick James
System to its knees! To see how bad it is, go to the WP directory and do time ls -l | wc (if you are on unix) -Original Message- From: J M [mailto:jerom...@gmail.com] Sent: Thursday, May 31, 2012 11:17 AM To: Baron Schwartz Cc: MySql Subject: Re: Mysql starts to die at 27 SQL

Re: Mysql starts to die at 27 SQL processes

2012-05-31 Thread Andrés Tello
Don't you have any message? For the number of max connections, I suppose you are hitting the limit of file opened, there are no messages at error log? Check this:

Re: SQL query help. Retrieve all DVDs that have at least one scene of a certain encoding format

2012-05-19 Thread Mark Kelly
Hi. On Friday 18 May 2012 18:21:07 Daevid Vincent wrote: Actually, I may have figured it out. Is there a better way to do this? I don't see why you need the dvds table when the dvd_id is in the scene table: SELECT a.dvd_id FROM scenes_list a, moviefiles b WHERE a.scene_id = b.scene_id AND

RE: SQL query help. Retrieve all DVDs that have at least one scene of a certain encoding format

2012-05-19 Thread Daevid Vincent
...@wastedtimes.net] Sent: Saturday, May 19, 2012 3:34 PM To: mysql@lists.mysql.com Subject: Re: SQL query help. Retrieve all DVDs that have at least one scene of a certain encoding format Hi. On Friday 18 May 2012 18:21:07 Daevid Vincent wrote: Actually, I may have figured it out. Is there a better

Re: SQL query help. Retrieve all DVDs that have at least one scene of a certain encoding format

2012-05-19 Thread Baron Schwartz
I would work from the inside out. What you're doing is grouping scenes by DVD and throwing away the ones that have no scenes. If you start with DVDs and do a subquery for each row, you'll process DVDs without scenes and then filter them out. If you start with a subquery that's grouped by DVD ID,

SQL query help. Retrieve all DVDs that have at least one scene of a certain encoding format

2012-05-18 Thread Daevid Vincent
I have a table of DVDs, another of scenes and a last one of encoding formats/files... I want to find in one query all the dvd_id that have 0 scene_id that's encoded in format_id = 13. In other words all DVDs that are format_id = 13 despite not having a direct link. CREATE TABLE `dvds` (

RE: SQL query help. Retrieve all DVDs that have at least one scene of a certain encoding format

2012-05-18 Thread Daevid Vincent
-Original Message- Sent: Friday, May 18, 2012 5:34 PM I have a table of DVDs, another of scenes and a last one of encoding formats/files... I want to find in one query all the dvd_id that have 0 scene_id that's encoded in format_id = 13. In other words all DVDs that are

Re: The most elegant/efficient way to pull this SQL query

2012-04-12 Thread Hal�sz S�ndor
2012/04/11 17:51 -0500, Peter Brawley select b.peopleID, concat('(',p.fname,,')'), b.stateID, concat('(',s.state,')') from bridge b join people p on b.peopleID=p.peopleID join state s on b.stateID=s.stateID; Since the names are the same in the tables, it works to use USING, too, and you are

Re: The most elegant/efficient way to pull this SQL query

2012-04-12 Thread Haluk Karamete
){ //get the $fields argument parse it out to come up //with one of the SQL statements you guys are discussing. SQL = BuildSQL($table,$fields) //and then use this SQL to output the table } The magic would be happening in the $fields argument. The example in my original question was like

Re: The most elegant/efficient way to pull this SQL query

2012-04-12 Thread Hal�sz S�ndor
like this function showtable($dbh,$table,$fields){ //get the $fields argument parse it out to come up //with one of the SQL statements you guys are discussing. SQL = BuildSQL($table,$fields) //and then use this SQL to output the table } The magic would be happening in the $fields argument

Re: The most elegant/efficient way to pull this SQL query

2012-04-11 Thread Peter Brawley
___5___florida__ What's the most straightforward way to achieve the following view with one SQL statement? peopleID__stateID_ 1_(joe)___1__(california)_ 2_(bob)___4__(texas)__ 3_(charlie)___5__(florida) select b.peopleID, concat

Re: The most elegant/efficient way to pull this SQL query

2012-04-11 Thread Hal�sz S�ndor
___5___florida__ What's the most straightforward way to achieve the following view with one SQL statement? peopleID__stateID_ 1_(joe)___1__(california)_ 2_(bob)___4__(texas)__ 3_(charlie)___5__(florida) Look at Stephen Tu s original

Convert SQL Server Compact data to MySQL

2012-04-05 Thread sam
Hello, I have data file written in SQL Server Compact.I need to Convert it to  MySQL. Does anyone know how to do that? Thank you, Sam

Re: Convert SQL Server Compact data to MySQL

2012-04-05 Thread sam
Unfortunately they don't have MySQL Migration Toolkit  for Ubuntu --- On Thu, 4/5/12, Pothanaboyina Trimurthy skd.trimur...@gmail.com wrote: From: Pothanaboyina Trimurthy skd.trimur...@gmail.com Subject: Re: Convert SQL Server Compact data to MySQL To: sam asu_...@yahoo.com Date: Thursday

Re: Convert SQL Server Compact data to MySQL

2012-04-05 Thread Hal�sz S�ndor
2012/04/05 02:15 -0700, sam I have data file written in SQL Server Compact.I need to Convert it to MySQL. Does anyone know how to do that? If it stores in CSV files, you can use that for the data, although to make MySQL read it, you hav to fiddle with it. The SQL, for tables procedures, you

ANN: SQL Maestro for MySQL 12.3 released

2012-04-02 Thread SQL Maestro Team
Hi! SQL Maestro Group announces the release of SQL Maestro for MySQL 12.3, a powerful Windows GUI solution for MySQL administration and database development. The new version is immediately available for download at http://www.sqlmaestro.com/products/mysql/maestro/ Please note that before April

Re: OT: SQL Question

2012-03-25 Thread David Turner
@lists.mysql.com Sent: Friday, March 23, 2012 7:28 PM Subject: OT: SQL Question My question is not specific to MySQL, even though I am using a MySQL db for this project. I have a servlet/jsp/MySQL web site in production, and there are about 2,000 records in the flights table. One of the foreign keys

OT: SQL Question

2012-03-23 Thread Mark Phillips
My question is not specific to MySQL, even though I am using a MySQL db for this project. I have a servlet/jsp/MySQL web site in production, and there are about 2,000 records in the flights table. One of the foreign keys is teacher_id. Up to this point, there is a one to many relationship between

  1   2   3   4   5   6   7   8   9   10   >