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

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?

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 do I mysqldump different database tables to the same .sql file?

--databases, methinks. - Original Message - > From: "Daevid Vincent" > 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 co

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

21, 2013 1:59 PM > To: MySql > Subject: Re: How 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

Re: How 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 these lines.. you might to do something a little more sophisticated. ###

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

I'm working on some code where I am trying to merge two customer accounts (we get people signing up under different usernames, emails, or just create a new account sometimes). I want to test it, and so I need a way to restore the data in the particular tables. Taking a dump of all the DBs and table

RE: How do I select all rows of table that have some rows in another table (AND, not OR)

2013/06/13 23:08 +, Rick James FIND_IN_SET might work the cleanest... WHERE FIND_IN_SET('action', genres) OR/AND [NOT] ... And have genres look like 'action,drama,foobar', that is comma-separators, and no need for leading/trailing comma. That would also work for genres = '1,3,10,19,

Re: How do I select all rows of table that have some rows in another table (AND, not OR)

2013/06/11 12:59 -0700, Daevid Vincent Also, just for S&G this is how we are currently implementing it, but we feel the REGEXP is killing our queries and while "clever" is a bit hacky and nullifies any indexes we have on the genres column as it requires a file_sort table scan to compare s

Re: How do I select all rows of table that have some rows in another table (AND, not OR)

2013/06/11 12:59 -0700, Daevid Vincent Also, just for S&G this is how we are currently implementing it, but we feel the REGEXP is killing our queries and while "clever" is a bit hacky and nullifies any indexes we have on the genres column as it requires a file_sort table scan to compare s

RE: How do I select all rows of table that have some rows in another table (AND, not OR)

I am so, so glad that someone finally said what I think each time I see a message from you Mr. James.  Original message From: Rick James Date: 06-12-2013 8:45 PM (GMT-04:00) To: Daevid Vincent ,mysql@lists.mysql.com Subject: RE: How do I select all rows of table that have

RE: How do I select all rows of table that have some rows in another table (AND, not OR)

ent: Wednesday, June 12, 2013 11:26 AM > To: mysql@lists.mysql.com > Subject: RE: How do I select all rows of table that have some rows in > another table (AND, not OR) > > This idea is so fancy pants and clever I *wish* it could have worked for > me. > I checked and we actual

RE: How do I select all rows of table that have some rows in another table (AND, not OR)

Oh! I must have misread. I didn't see how you had a solution for > 64 bits. I may have to experiment with that! > -Original Message- > From: Daevid Vincent [mailto:dae...@daevid.com] > Sent: Wednesday, June 12, 2013 11:26 AM > To: mysql@lists.mysql.com > Subject:

RE: How do I select all rows of table that have some rows in another table (AND, not OR)

ne 12, 2013 9:39 AM > To: Daevid Vincent; mysql@lists.mysql.com > Cc: 'shawn green' > Subject: RE: How do I select all rows of table that have some rows in > another table (AND, not OR) > > Thinking out of the box... (And posting my reply at the 'wrong' end o

Re: How do I select all rows of table that have some rows in another table (AND, not OR)

Hello Daevid, On 6/11/2013 7:17 PM, Daevid Vincent wrote: -Original Message- From: shawn green [mailto:shawn.l.gr...@oracle.com] Sent: Tuesday, June 11, 2013 2:16 PM To: mysql@lists.mysql.com Subject: Re: How do I select all rows of table that have some rows in another table (AND

RE: How do I select all rows of table that have some rows in another table (AND, not OR)

re# field. I would use 32 and INT UNSIGNED.) > -Original Message- > From: Daevid Vincent [mailto:dae...@daevid.com] > Sent: Tuesday, June 11, 2013 4:17 PM > To: mysql@lists.mysql.com > Cc: 'shawn green' > Subject: RE: How do I select all rows of table that have some ro

RE: How do I select all rows of table that have some rows in another table (AND, not OR)

> -Original Message- > From: shawn green [mailto:shawn.l.gr...@oracle.com] > Sent: Tuesday, June 11, 2013 2:16 PM > To: mysql@lists.mysql.com > Subject: Re: How do I select all rows of table that have some rows in > another table (AND, not OR) > > Hello Daevid, &

Re: How do I select all rows of table that have some rows in another table (AND, not OR)

Hello Daevid, On 6/11/2013 3:59 PM, Daevid Vincent wrote: I am trying to implement a filter so that a user could select various genres they want "in" or "out". Perhaps they like 'action' and 'car chases' but don't like 'foreign' and 'drifting' (or whatever...) So I want something sort of like t

How do I select all rows of table that have some rows in another table (AND, not OR)

I am trying to implement a filter so that a user could select various genres they want "in" or "out". Perhaps they like 'action' and 'car chases' but don't like 'foreign' and 'drifting' (or whatever...) So I want something sort of like this, however IN() is using an "OR" comparison when I need it

Re: How do I use a dynamic filename for an into outfile statement

On Feb 29, 2012, at 10:43 AM, Ed Patterson wrote: > Be kind, I am by no means any type of DB expert. > > I would like to eventually move this to a stored procedure but for now I am > using the \. to fire it off. > > Here is what I have so far (generating a list of machines missing software) >

Re: How do I use a dynamic filename for an into outfile statement

By using your shell's variable substitution, I'm afraid. export outfile='/path/to/file' mysql -e "select blah into outfile '$outfile'" You'll have to build a shell script or something that generates your filename, and then do an interactive call. Maybe you could write a stored procedure tha

Re: How do I use a dynamic filename for an into outfile statement

2012/02/29 11:43 -0500, Ed Patterson The select concat() works from the command line I can manually add the file name but would like to automate the process Lastly, if it makes a difference, I don't use any graphical tools for DB stuff. Look up the command! http://dev.mysql.com/

How do I use a dynamic filename for an into outfile statement

Be kind, I am by no means any type of DB expert. I would like to eventually move this to a stored procedure but for now I am using the \. to fire it off. Here is what I have so far (generating a list of machines missing software) select last_logon.host_name_short from last_logon left join mca

Re: how do I make utf8 the default encoding for my MySQL installation

Am 18.11.2011 04:31, schrieb Martin Mueller: > [mysqld] > init_connect=’SET collation_connection = utf8_general_ci’ > init_connect=’SET NAMES utf8′ > default-character-set=utf8 > character-set-server=utf8 > collation-server=utf8_general_ci > skip-character-set-client-handshake > On a Mac with My

Re: how do I make utf8 the default encoding for my MySQL installation

On Friday, November 18, 2011 at 03:31:44 UTC, martin.muel...@mac.com confabulated: > Is it possible to make utf8 the default for all databases and transactions > in a MySQL installation? > The current default is Latin1. There is a suggestion on the Web to edit > the my.cnf file as follows > [m

how do I make utf8 the default encoding for my MySQL installation

Is it possible to make utf8 the default for all databases and transactions in a MySQL installation? The current default is Latin1. There is a suggestion on the Web to edit the my.cnf file as follows [mysqld] init_connect=’SET collation_connection = utf8_general_ci’ init_connect=’SET NAMES utf8′

How do I get more pages in mySQL Workbench?? WAS: Any table visualization tools with wires connecting the actual columns?

I just discovered that MySQL Workbench actually WILL connect columns. Use the #6 wire type shortcut (bottom one). However, I must be retarded or blind because I can't figure out how to make the diagram have more than the default of 2 pages. I have a database with 50 tables and they just don't fit

RE: How do I GRANT SELECT to mysql.time_zone_name for ANYONE?!

> -Original Message- > From: Jesper Wisborg Krogh [mailto:jes...@noggin.com.au] > Sent: Friday, October 15, 2010 5:54 PM > To: MY SQL Mailing list > Subject: Re: How do I GRANT SELECT to mysql.time_zone_name > for ANYONE?! > > > Any user can get into mysql,

Re: How do I GRANT SELECT to mysql.time_zone_name for ANYONE?!

Hi, On 16/10/2010, at 8:50 AM, Daevid Vincent wrote: Thanks for the reply Jesper, but either there isn't a solution in your response, or I'm missing it? What I mean is that you have to explicitly give the grant to each user that should be allowed to query the table. You can't run one gr

RE: How do I GRANT SELECT to mysql.time_zone_name for ANYONE?!

> -Original Message- > From: Jesper Wisborg Krogh [mailto:jes...@noggin.com.au] > Sent: Friday, October 15, 2010 2:33 PM > To: MY SQL Mailing list > Subject: Re: How do I GRANT SELECT to mysql.time_zone_name > for ANYONE?! > > Hi > > > On 16/10/20

Re: How do I GRANT SELECT to mysql.time_zone_name for ANYONE?!

Hi On 16/10/2010, at 1:47 AM, Suresh Kuna wrote: Hey Daevid, As this time zone table won't change once it is set up. Do a copy of the table data into another database and give grants to it. Copy the data is not a good solution. First of all, time zone data does change. Secondly if you

Re: How do I GRANT SELECT to mysql.time_zone_name for ANYONE?!

then flush privileges. > > JW > > > On Thu, Oct 14, 2010 at 6:46 PM, Daevid Vincent wrote: > > > I'm pulling my hair out. How do I GRANT the SELECT ability to ANY USER > for > > the very specific mysql.time_zone_name table?? I don't want to GRANT it >

Re: How do I GRANT SELECT to mysql.time_zone_name for ANYONE?!

I think this is one of those times you would update the mysql.user table directly, then flush privileges. JW On Thu, Oct 14, 2010 at 6:46 PM, Daevid Vincent wrote: > I'm pulling my hair out. How do I GRANT the SELECT ability to ANY USER for > the very specific mysql.time_zone_nam

How do I GRANT SELECT to mysql.time_zone_name for ANYONE?!

I'm pulling my hair out. How do I GRANT the SELECT ability to ANY USER for the very specific mysql.time_zone_name table?? I don't want to GRANT it to every individual user manually, I want one single GRANT that encompasses every user simultaneously. I've tried all of these, and the

RE: How do I use and JOIN the mysql.time_zone% tables?

ww.the-infoshop.com >-Original Message- >From: Daevid Vincent [mailto:dae...@daevid.com] >Sent: Wednesday, October 13, 2010 10:51 PM >To: mysql@lists.mysql.com >Subject: How do I use and JOIN the mysql.time_zone% tables? > >I'm trying to figure out how to join the mys

Re: How do I use and JOIN the mysql.time_zone% tables?

Part of your answer is the offset column, which seems to be relative to the abbreviation used. This implies, to me, that each particular abbreviation has it's own way of specifying the "starting point" of the time. Added is the DST flag, which (probably) tells you that your app needs to keep daylig

How do I use and JOIN the mysql.time_zone% tables?

I'm trying to figure out how to join the mysql.time_zone% tables and make sense of this. YES, I know how to "use" them with SET time_zone = timezone; and all that. http://dev.mysql.com/doc/refman/5.0/en/time-zone-support.html That is NOT what I need them for (yet). I have a list of airports and

Re: How do I change MySQL data folder and move data over on ubuntu 10.04?

After I run sudo mysqld, I run sudo /etc/init.d/mysql start and check the syslog by running sudo tail -f /var/log/syslog, the output is Aug 29 21:05:42 hpdesktop kernel: [27909.007727] type=1505 audit(1283130342.751:150): operation="profile_replace" pid=9994 name="/usr/bin/evince-previewer" Aug 2

Re: How do I change MySQL data folder and move data over on ubuntu 10.04?

I think so. When I run ls -l /var/run/mysqld/ I get total 0 srwxrwxrwx 1 mysql mysql 0 2010-08-29 14:45 mysqld.sock On Sun, Aug 29, 2010 at 4:02 PM, Sabika Gmail wrote: > Does your mysql sock file reside in the same location as the error? > > > > On Aug 29, 2010, at 12:20 PM, chen jia wrote:

Re: How do I change MySQL data folder and move data over on ubuntu 10.04?

Does your mysql sock file reside in the same location as the error? On Aug 29, 2010, at 12:20 PM, chen jia wrote: > Hi there, > > I install ubuntu 10.04 (64bit) on my desktop and try to move my > existing MySQL data over. > > I first install MySQL on the new machine, and it can start and sto

How do I change MySQL data folder and move data over on ubuntu 10.04?

Hi there, I install ubuntu 10.04 (64bit) on my desktop and try to move my existing MySQL data over. I first install MySQL on the new machine, and it can start and stop fine. I decide to change the data folder from the default (/var/lib/mysql) to /home/MyAccount/MySQLdata and move my existing MySQ

Re: How do I get a list of all defined UDF's known to the system?

> Table “information_schema.routines” does not exist. > > > > Kind Regards, > > > > Robert. > > > > > > > > *From:* Wagner Bianchi [mailto:wagnerbianch...@gmail.com] > *Sent:* Monday, 8 February 2010 11:11 PM > *To:* Robert Gilland >

Re: How do I get a list of all defined UDF's known to the system?

n, Feb 8, 2010 at 10:37 AM, Sir Wally Lewis > > wrote: > >> How do I get a list of all defined UDF's known to the system? >> >> >> >> Kind Regards, >> >> >> >> Robert. >> >> >> >> -- >> MySQL General Mail

Re: How do I get a list of all defined UDF's known to the system?

Hi Robert, We can see the functions by using the below command Show function status ; -- Suresh Kuna MySQL DBA On Mon, Feb 8, 2010 at 10:37 AM, Sir Wally Lewis wrote: > How do I get a list of all defined UDF's known to the system? > > > > Kind Regards, > > >

How do I get a list of all defined UDF's known to the system?

How do I get a list of all defined UDF's known to the system? Kind Regards, Robert. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: how do I select multiple conditions from 1 table column?

David Giragosian wrote: > On Wed, Apr 1, 2009 at 1:27 PM, PJ > wrote: > > I am trying to select all books whose authors last names begin > with I, J > or K. I have 3 tables: book, author and book_author. The following > query > works with one con

Re: how do I select multiple conditions from 1 table column?

On Wed, Apr 1, 2009 at 1:27 PM, PJ wrote: > I am trying to select all books whose authors last names begin with I, J > or K. I have 3 tables: book, author and book_author. The following query > works with one condition but not with three. > SELECT * FROM book >WHERE id IN (SELECT bookID >

how do I select multiple conditions from 1 table column?

I am trying to select all books whose authors last names begin with I, J or K. I have 3 tables: book, author and book_author. The following query works with one condition but not with three. SELECT * FROM book WHERE id IN (SELECT bookID FROM book_author WHERE authID IN (SELECT autho

Re: FW: How do I (can I) use aggregate functions inside a select

Why? Because it's Friday and I'm feeling silly :) mysql> SELECT * FROM sales; +--+---++ | company | state | sales | +--+---++ | ABC | AZ| 140.01 | | XYZ | AZ| 17.76 | | ABC | NY| 123.45 | | XYZ

FW: How do I (can I) use aggregate functions inside a select

10) 285-7200 [EMAIL PROTECTED] -Original Message- From: Ian Simpson [mailto:[EMAIL PROTECTED] Sent: Friday, July 25, 2008 11:15 AM To: David Ruggles Cc: 'mysql' Subject: RE: How do I (can I) use aggregate functions inside a select Hi David, Try Select company, state, sales, sum(s

RE: How do I (can I) use aggregate functions inside a select

>-Original Message- >From: David Ruggles [mailto:[EMAIL PROTECTED] >Sent: Friday, July 25, 2008 10:53 AM >To: 'mysql' >Subject: RE: How do I (can I) use aggregate functions inside a select > >I get: >Error Code : 1140 >Mixing of GROUP columns (MIN(),MAX

RE: How do I (can I) use aggregate functions inside a select

ineer Safe Data, Inc. > (910) 285-7200[EMAIL PROTECTED] > > > > -Original Message- > From: Ananda Kumar [mailto:[EMAIL PROTECTED] > Sent: Friday, July 25, 2008 10:37 AM > To: David Ruggles > Cc: mysql > Subject: Re: How do I (can I) use aggregate

Re: How do I (can I) use aggregate functions inside a select

David Ruggles wrote: > I may be approaching this all wrong, but I need to know a percentage of > total sales within a select statement. > > So I can do something like this: > Select company, state, sales, sum(sales) / sales as percent > From Sales > > mmh, you want sum(sales where compan

RE: How do I (can I) use aggregate functions inside a select

: Ananda Kumar [mailto:[EMAIL PROTECTED] Sent: Friday, July 25, 2008 10:37 AM To: David Ruggles Cc: mysql Subject: Re: How do I (can I) use aggregate functions inside a select yes, u can use the below sql. regards anandkl On 7/25/08, David Ruggles <[EMAIL PROTECTED]> wrote: > > I may be

Re: How do I (can I) use aggregate functions inside a select

yes, u can use the below sql. regards anandkl On 7/25/08, David Ruggles <[EMAIL PROTECTED]> wrote: > > I may be approaching this all wrong, but I need to know a percentage of > total sales within a select statement. > > So I can do something like this: > Select company, state, sales, sum(sales)

How do I (can I) use aggregate functions inside a select

I may be approaching this all wrong, but I need to know a percentage of total sales within a select statement. So I can do something like this: Select company, state, sales, sum(sales) / sales as percent >From Sales Thanks, David Ruggles CCNA MCSE (NT) CNA A+ Network EngineerSafe Data,

Re: How do I get the file names from a certain directory in SQL?

I accept that.. but my requirement is , I have some no of Excel files..I just need to check the modified time of the files ,if it is modified currently then I need to open those files and convert the excel data to database.. otherwise i didnt change anything in my database.. how can i going

Re: How do I get the file names from a certain directory in SQL?

Martijn Tonies wrote: Hey, How do I get the file names from a certain directory in SQL? It seems to me that you're trying to do things that are beyong SQL really. SQL is about the database, not about a file system. Yes, by creating a DBMS that allows you to write functions

Re: How do I get the file names from a certain directory in SQL?

On Thu, 2008-07-24 at 17:36 +0530, Sivasakthi wrote: > Hi all, > > How do I get the file names from a certain directory in SQL? SQL is designed to deal with RDBs, not the rest of the computer system. I suggest you switch to a modern language such as Perl, Python, Ruby, or even PHP. E

Re: How do I get the file names from a certain directory in SQL?

Hey, > How do I get the file names from a certain directory in SQL? It seems to me that you're trying to do things that are beyong SQL really. SQL is about the database, not about a file system. Yes, by creating a DBMS that allows you to write functions that interact with the file sys

How do I get the file names from a certain directory in SQL?

Hi all, How do I get the file names from a certain directory in SQL? Thanks, Siva -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Newbie question, how do I respond to post?

MCSE (NT) CNA A+ Network EngineerSafe Data, Inc. (910) 285-7200 [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 23, 2008 10:19 AM To: mysql@lists.mysql.com Subject: Newbie question, how do I respond to post

Newbie question, how do I respond to post?

Hello, I feel stupid here... How do I respond to a specific post? I posted last night, I got a response... now I want to post a response to the response. Don't see a way to do that... Thanks, Lee ** Start the year off right. Easy ways to stay in shape. http://body.ao

Re: How do I get myself of this email list?

[EMAIL PROTECTED] wrote: Hey Peoples... How do I get myself of this email list? Thanks It's a very complicated 2 step process: 1) learn to read. 2) follow the directions. Every email list in the civilized world has instructions on how to unsubscribe at the bottom or top of EVERY me

How do I change the Collation Variables?

How do I change: | collation_connection| latin1_swedish_ci | | collation_database | latin1_swedish_ci | | collation_server| latin1_swedish_ci to latin1_bin? Is this in my.cnf? or is this another way to do this? -- Albert E. Whale, CHS CISA CISSP Sr

RE: How do I find products when a user types freeform strings like 'Sony 20" TV' or '20" Sony TV'? [SOLVED]

> -Original Message- > From: Daevid Vincent [mailto:[EMAIL PROTECTED] > Sent: Friday, May 04, 2007 1:22 AM > To: mysql@lists.mysql.com > Subject: How do I find products when a user types freeform > strings like 'Sony 20" TV' or '20" Sony TV

RE: How do I find products when a user types freeform strings like 'Sony 20" TV' or '20" Sony TV'?

> -Original Message- > From: Iain Alexander [mailto:[EMAIL PROTECTED] > Sent: Wednesday, May 09, 2007 3:11 PM > To: mysql@lists.mysql.com > Subject: Re: How do I find products when a user types > freeform strings like 'Sony 20" TV' or '20" S

Re: How do I find products when a user types freeform strings like 'Sony 20" TV' or '20" Sony TV'?

On 4 May 2007 at 1:21, Daevid Vincent wrote: > I'm having trouble figuring out the logic/query I want. > I know that all those "OR"s are not right. [snip] > WHERE products.enabled = 1 > AND( > (products.model LIKE 'sony%' OR products.model LIKE '20%' OR > products.model LIKE

Re: How do I find products when a user types freeform strings like 'Sony 20" TV' or '20" Sony TV'?

uery I want. > > I know that all those "OR"s are not right. > > I'm doing this in PHP and mySQL (of course), > > so if it can't be done with a single query, I can split it up. > > > > Here's the challenge, given a text field search box, someone e

Re: How do I find products when a user types freeform strings like 'Sony 20" TV' or '20" Sony TV'?

, so if it can't be done with a single query, I can split it up. Here's the challenge, given a text field search box, someone enters: Sony 20" TV How do I search for that, not knowing which fields are which? For example, they could have also entered: 20" Son

RE: How do I find products when a user types freeform strings like 'Sony 20" TV' or '20" Sony TV'?

QL (of course), > > so if it can't be done with a single query, I can split it up. > > > > Here's the challenge, given a text field search box, someone enters: > > > > Sony 20" TV > > > > How do I search for that, not knowing which fi

Re: How do I find products when a user types freeform strings like 'Sony 20" TV' or '20" Sony TV'?

given a text field search box, someone enters: Sony 20" TV How do I search for that, not knowing which fields are which? For example, they could have also entered: 20" Sony TV I think you're describing full-text indexing. MySQL supports it but only on MyISAM t

Re: How do I find products when a user types freeform strings like 'Sony 20" TV' or '20" Sony TV'?

up. > > Here's the challenge, given a text field search box, someone enters: > > Sony 20" TV > > How do I search for that, not knowing which fields are which? > For example, they could have also entered: > > 20" Sony TV > How about: select

How do I find products when a user types freeform strings like 'Sony 20" TV' or '20" Sony TV'?

e enters: Sony 20" TV How do I search for that, not knowing which fields are which? For example, they could have also entered: 20" Sony TV This is the one I have now, but (as you probably noticed), it will return many rows, I expect that most of the time > 1 row wil

Re: How do I alter the result of a select

Brian, the online MySQL documentation is very complete and easy to read. That said, you do kind of have to know what you're looking for! I'm not sure what to recommend for a guide to beginning SQL, sorry, others may have some thoughts. You are going down the right road with an aggregate function

RE: How do I alter the result of a select

Brian Menke [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 07, 2007 6:23 PM To: 'MySQL List' Subject: How do I alter the result of a select MySQL 5.x I have a table that looks like this: module_id question_id email participant_answer 2 2.1

How do I alter the result of a select

MySQL 5.x I have a table that looks like this: module_id question_id email participant_answer 2 2.1 [EMAIL PROTECTED] a 2 2.2 [EMAIL PROTECTED] b 2 2.3 [EMAIL PROTECTED]

RE: mysql v5 math a bit out. How do I round the info to become correct

Thanks for the reference Jay. Most helpful. Kerry -Original Message- From: Jay Pipes [mailto:[EMAIL PROTECTED] Sent: 14 December 2006 20:29 To: [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Subject: Re: mysql v5 math a bit out. How do I round the info to become correct For exact

Re: mysql v5 math a bit out. How do I round the info to become correct

For exact calculations, you need to use the DECIMAL data type. See this section in the manual for the reasons why: http://dev.mysql.com/doc/refman/5.1/en/precision-math-examples.html Cheers, Jay Kerry Frater wrote: > I am running a small procedure for set jobs that calculates a running total >

mysql v5 math a bit out. How do I round the info to become correct

I am running a small procedure for set jobs that calculates a running total for me to display. It works fine in most cases but the math concerns me. I am using 5.0.18 on my Windows PC and the latest 5.x on my Linux server (both test machines). The finance table is an InnoDb table. CreditAmount and

Re: How Do I Know If mySQL is using MyISAM or InnoDB?

Hi, If you are particular about a table, i.e what engine my table uses? Try, mysql > show table status like 'tablename' \G Thanks ViSolve DB Team. - Original Message - From: "John Kopanas" <[EMAIL PROTECTED]> To: Sent: Friday, November 17, 2006 10:43

Re: How Do I Know If mySQL is using MyISAM or InnoDB?

Kruckenberg <[EMAIL PROTECTED]> To: John Kopanas <[EMAIL PROTECTED]> Cc: mysql@lists.mysql.com Sent: Friday, November 17, 2006 12:32:19 PM GMT-0500 US/Eastern Subject: Re: How Do I Know If mySQL is using MyISAM or InnoDB? For any specific table if you do: show create table ; It will te

Re: How Do I Know If mySQL is using MyISAM or InnoDB?

This is in 4.0, it has changed in more recent versions. Mike Kruckenberg wrote: For any specific table if you do: show create table ; It will tell you what the able was created using. To create tables using a specific engine add ENGINE= to the end of your create statement. To see the defau

Re: How Do I Know If mySQL is using MyISAM or InnoDB?

For any specific table if you do: show create table ; It will tell you what the able was created using. To create tables using a specific engine add ENGINE= to the end of your create statement. To see the default that is used (I think this is what the table_type variable does): mysql> show

Re: How Do I Know If mySQL is using MyISAM or InnoDB?

Friday, November 17, 2006 12:13:33 PM GMT-0500 US/Eastern Subject: How Do I Know If mySQL is using MyISAM or InnoDB? Is there a command at the command line that can tell me if I am using MyISAM or InnoDB? Thanks :-). -- John Kopanas [EMAIL PROTECTED] http://www.kopanas.com http://www.cuse

Re: How Do I Know If mySQL is using MyISAM or InnoDB?

INE=MyISAM; CREATE TABLE ( ... ) ENGINE=InnoDB; To show what engines are available on your MySQL server, do this: show engines; - Original Message - From: John Kopanas <[EMAIL PROTECTED]> To: mysql@lists.mysql.com Sent: Friday, November 17, 2006 12:13:33 PM GMT-0500 US/Eastern Subject:

How Do I Know If mySQL is using MyISAM or InnoDB?

Is there a command at the command line that can tell me if I am using MyISAM or InnoDB? Thanks :-). -- John Kopanas [EMAIL PROTECTED] http://www.kopanas.com http://www.cusec.net http://www.soen.info

Re: How do I do this query efficiently?

2006/11/16, Peter Brawley <[EMAIL PROTECTED]>: Michael, >SELECT t1.id, t1.version, t1.value >FROM data t1 >LEFT JOIN data t2 ON t1.id=t2.id AND t1.version < t2.version >WHERE t2.id IS NULL; >I had almost the same problem and I found this solution very smart... >even smarter than I can unde

Re: How do I do this query efficiently?

Michael, >SELECT t1.id, t1.version, t1.value >FROM data t1 >LEFT JOIN data t2 ON t1.id=t2.id AND t1.version < t2.version >WHERE t2.id IS NULL; >I had almost the same problem and I found this solution very smart... >even smarter than I can understand :) >Can someone explain to me why/how this quer

Re: How do I do this query efficiently?

Wow, neat. I didn't think you could do that without a subquery somewhere. Learned a cool new trick today. Thanks! Regards, Sebastiaan Peter Brawley wrote: Right, if you want the value column you need too, you need a different query ... SELECT t1.id, t1.version, t1.value FROM data t1 LEFT JOIN

Re: How do I do this query efficiently?

Pretty slick. - Original Message - From: Peter Brawley <[EMAIL PROTECTED]> To: Sebastiaan van Erk <[EMAIL PROTECTED]> Cc: mysql@lists.mysql.com Sent: Monday, November 13, 2006 10:43:26 AM GMT-0500 US/Eastern Subject: Re: How do I do this query efficiently? Right, if you wa

Re: How do I do this query efficiently?

Right, if you want the value column you need too, you need a different query ... SELECT t1.id, t1.version, t1.value FROM data t1 LEFT JOIN data t2 ON t1.id=t2.id AND t1.version < t2.version WHERE t2.id IS NULL; PB Sebastiaan van Erk wrote: Hi, Thanks for your quick answer, but unfortunately

Re: How do I do this query efficiently?

rsion; - Original Message - From: Peter Brawley <[EMAIL PROTECTED]> To: Sebastiaan van Erk <[EMAIL PROTECTED]>, mysql@lists.mysql.com Sent: Monday, November 13, 2006 9:18:49 AM GMT-0500 US/Eastern Subject: Re: How do I do this query efficiently? >for every "id" I want exactly on

Re: How do I do this query efficiently?

Try this !!! - Original Message - From: Rolando Edwards <[EMAIL PROTECTED]> To: peter brawley <[EMAIL PROTECTED]> Cc: Sebastiaan van Erk <[EMAIL PROTECTED]>, mysql@lists.mysql.com Sent: Monday, November 13, 2006 9:28:46 AM GMT-0500 US/Eastern Subject: Re: How

Re: How do I do this query efficiently?

Hi, Thanks for your quick answer, but unfortunately this query does not return the "value" column of the row; and that is the column I am ultimately interested in (in combination with the id). Regards, Sebastiaan Peter Brawley wrote: >for every "id" I want exactly one row, namely the row wit

Re: How do I do this query efficiently?

ssage - From: Peter Brawley <[EMAIL PROTECTED]> To: Sebastiaan van Erk <[EMAIL PROTECTED]>, mysql@lists.mysql.com Sent: Monday, November 13, 2006 9:18:49 AM GMT-0500 US/Eastern Subject: Re: How do I do this query efficiently? >for every "id" I want exactly one row, namely t

Re: How do I do this query efficiently?

>for every "id" I want exactly one row, namely the row with the maximum value of "version". SELECT id,MAX(version) FROM data GROUP BY id; PB - Sebastiaan van Erk wrote: Hi all, I have the following simple table: CREATE TABLE data ( id int NOT NULL, version int NOT NULL, value int

How do I do this query efficiently?

Hi all, I have the following simple table: CREATE TABLE data ( id int NOT NULL, version int NOT NULL, value int NOT NULL, PRIMARY KEY (id, version) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; What I would like to do is to find all the values for the latest versions, that is, for every "id" I

Re: How do i initialize a new datadir in mysql ?

TECTED]> To: Sent: Friday, October 13, 2006 10:11 AM Subject: How do i initialize a new datadir in mysql ? Dear all, If I am already have a datadir in /var/lib/mysql and I intend to start a new one in /var/lib/mysql2, how do i do it ? Thanks in advance, Low Kian Seong -- MySQL General

How do i initialize a new datadir in mysql ?

Dear all, If I am already have a datadir in /var/lib/mysql and I intend to start a new one in /var/lib/mysql2, how do i do it ? Thanks in advance, Low Kian Seong -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

RE: FW: How do I find all the users that are new since my last login (repost)

riginal Message- > From: Martin Jespersen [mailto:[EMAIL PROTECTED] > Sent: Friday, August 04, 2006 5:35 PM > To: Daevid Vincent > Cc: mysql@lists.mysql.com > Subject: Re: FW: How do I find all the users that are new > since my last login (repost) > > You could add an e

  1   2   3   4   5   >