Otdfbt

51k Euros annually for a family of 4 in Berlin: Is it enough?

Why didn't this character "real die" when they blew their stack out in Altered Carbon?

How to bypass password on Windows XP account?

How come Sam didn't become Lord of Horn Hill?

What is Arya's weapon design?

How to react to hostile behavior from a senior developer?

How do I name drop voicings

Short Story with Cinderella as a Voo-doo Witch

Extract all GPU name, model and GPU ram

Bete Noir -- no dairy

Why did the IBM 650 use bi-quinary?

How do I stop a creek from eroding my steep embankment?

What does this icon in iOS Stardew Valley mean?

How discoverable are IPv6 addresses and AAAA names by potential attackers?

How does debian/ubuntu knows a package has a updated version

Why are Kinder Surprise Eggs illegal in the USA?

Why is "Consequences inflicted." not a sentence?

Using et al. for a last / senior author rather than for a first author

Dating a Former Employee

Why aren't air breathing engines used as small first stages

How widely used is the term Treppenwitz? Is it something that most Germans know?

Book where humans were engineered with genes from animal species to survive hostile planets

3 doors, three guards, one stone

Can a USB port passively 'listen only'?

Set MySQL connection flags from command line client

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;

0

Is it possible to set MySQL client flags when using the command line client?

I would like to set the CLIENT_FOUND_ROWS client flag, but the manpages of the mysql client do not mention the setting of client flags. This is only documented in the documentation of the mysql_real_connect() function.

Is using client flags in the command line client at all possible? If so, how?

The problem at hand is this. I am using the command line mysql client. After an update statement, I would like to be able to issue a SELECT ROW_COUNT() command, and have it return the number of rows matched, not the number of rows changed. When accessing the database via a library where you can call the mysql_real_connect() function, this can be achieved by setting the CLIENT_FOUND_ROWS client flag. I would like to achive the same behaviour but with the command line client instead.

I know I could screen scrape the output of the sql update statement, but I'd prefer not to.

mysql

share|improve this question

edited Apr 12 at 11:52

Dave M

4,37982428

asked Apr 11 at 13:52

roelvanmeerroelvanmeer

6461817

add a comment | 

0

Is it possible to set MySQL client flags when using the command line client?

I would like to set the CLIENT_FOUND_ROWS client flag, but the manpages of the mysql client do not mention the setting of client flags. This is only documented in the documentation of the mysql_real_connect() function.

Is using client flags in the command line client at all possible? If so, how?

The problem at hand is this. I am using the command line mysql client. After an update statement, I would like to be able to issue a SELECT ROW_COUNT() command, and have it return the number of rows matched, not the number of rows changed. When accessing the database via a library where you can call the mysql_real_connect() function, this can be achieved by setting the CLIENT_FOUND_ROWS client flag. I would like to achive the same behaviour but with the command line client instead.

I know I could screen scrape the output of the sql update statement, but I'd prefer not to.

mysql

share|improve this question

edited Apr 12 at 11:52

Dave M

4,37982428

asked Apr 11 at 13:52

roelvanmeerroelvanmeer

6461817

add a comment | 

Is it possible to set MySQL client flags when using the command line client?

I would like to set the CLIENT_FOUND_ROWS client flag, but the manpages of the mysql client do not mention the setting of client flags. This is only documented in the documentation of the mysql_real_connect() function.

Is using client flags in the command line client at all possible? If so, how?

The problem at hand is this. I am using the command line mysql client. After an update statement, I would like to be able to issue a SELECT ROW_COUNT() command, and have it return the number of rows matched, not the number of rows changed. When accessing the database via a library where you can call the mysql_real_connect() function, this can be achieved by setting the CLIENT_FOUND_ROWS client flag. I would like to achive the same behaviour but with the command line client instead.

I know I could screen scrape the output of the sql update statement, but I'd prefer not to.

mysql

share|improve this question

edited Apr 12 at 11:52

Dave M

4,37982428

asked Apr 11 at 13:52

roelvanmeerroelvanmeer

6461817

share|improve this question

edited Apr 12 at 11:52

Dave M

4,37982428

asked Apr 11 at 13:52

roelvanmeerroelvanmeer

6461817

share|improve this question

edited Apr 12 at 11:52

Dave M

4,37982428

asked Apr 11 at 13:52

roelvanmeerroelvanmeer

6461817

edited Apr 12 at 11:52

Dave M

4,37982428

edited Apr 12 at 11:52

Dave M

4,37982428

asked Apr 11 at 13:52

roelvanmeerroelvanmeer

6461817

asked Apr 11 at 13:52

roelvanmeerroelvanmeer

6461817

1 Answer
1

active

oldest

votes

0

CLIENT_FOUND_ROWS isn't a flag for the command line because the command line already tells you how many rows it matched/updated. That option only works for the mysql_real_connect() function because it tells the function to return the number of rows as part of the return value (otherwise that data would be lost.)

share|improve this answer

answered Apr 11 at 14:16

Bob DoleBob Dole

763

New contributor

Bob Dole is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  How about client flags in general?
  
  – roelvanmeer
  Apr 11 at 14:37
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Here's a list of command line options - techotopia.com/index.php/The_mysql_Command-Line_Tool
  
  – Bob Dole
  Apr 11 at 14:46
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Thanks Bob, but that doesn't answer my question. I know my way around manpages and the mysql client command line options. I've expanded the question a bit.
  
  – roelvanmeer
  Apr 12 at 10:25
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Everything available in the man pages is everything available to the command line client. Why don't you use a COUNT(*) in your SELECT statement if you want to also know the number of rows?
  
  – Bob Dole
  Apr 12 at 13:53
  

  
  
  
  

add a comment | 

Your Answer

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "2"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fserverfault.com%2fquestions%2f962613%2fset-mysql-connection-flags-from-command-line-client%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

0

CLIENT_FOUND_ROWS isn't a flag for the command line because the command line already tells you how many rows it matched/updated. That option only works for the mysql_real_connect() function because it tells the function to return the number of rows as part of the return value (otherwise that data would be lost.)

share|improve this answer

answered Apr 11 at 14:16

Bob DoleBob Dole

763

New contributor

Bob Dole is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  How about client flags in general?
  
  – roelvanmeer
  Apr 11 at 14:37
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Here's a list of command line options - techotopia.com/index.php/The_mysql_Command-Line_Tool
  
  – Bob Dole
  Apr 11 at 14:46
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Thanks Bob, but that doesn't answer my question. I know my way around manpages and the mysql client command line options. I've expanded the question a bit.
  
  – roelvanmeer
  Apr 12 at 10:25
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Everything available in the man pages is everything available to the command line client. Why don't you use a COUNT(*) in your SELECT statement if you want to also know the number of rows?
  
  – Bob Dole
  Apr 12 at 13:53
  

  
  
  
  

add a comment | 

0

CLIENT_FOUND_ROWS isn't a flag for the command line because the command line already tells you how many rows it matched/updated. That option only works for the mysql_real_connect() function because it tells the function to return the number of rows as part of the return value (otherwise that data would be lost.)

share|improve this answer

answered Apr 11 at 14:16

Bob DoleBob Dole

763

New contributor

Bob Dole is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  How about client flags in general?
  
  – roelvanmeer
  Apr 11 at 14:37
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Here's a list of command line options - techotopia.com/index.php/The_mysql_Command-Line_Tool
  
  – Bob Dole
  Apr 11 at 14:46
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Thanks Bob, but that doesn't answer my question. I know my way around manpages and the mysql client command line options. I've expanded the question a bit.
  
  – roelvanmeer
  Apr 12 at 10:25
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Everything available in the man pages is everything available to the command line client. Why don't you use a COUNT(*) in your SELECT statement if you want to also know the number of rows?
  
  – Bob Dole
  Apr 12 at 13:53
  

  
  
  
  

add a comment | 

CLIENT_FOUND_ROWS isn't a flag for the command line because the command line already tells you how many rows it matched/updated. That option only works for the mysql_real_connect() function because it tells the function to return the number of rows as part of the return value (otherwise that data would be lost.)

share|improve this answer

answered Apr 11 at 14:16

Bob DoleBob Dole

763

New contributor

Bob Dole is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

share|improve this answer

answered Apr 11 at 14:16

Bob DoleBob Dole

763

New contributor

Bob Dole is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

answered Apr 11 at 14:16

Bob DoleBob Dole

763

New contributor

Bob Dole is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

answered Apr 11 at 14:16

Bob DoleBob Dole

763