Put

    SELECT ROW_COUNT();

as the last statement in your batch and parse the output


I might have answered myself the question, been looking at the parameters, and aparently using &quot;-v -v -v&quot; as parameters to the mysql command forces it to be more verbose and it spits out how many rows where affected.

Not an answer, but useful addition, you also could try the other MySQL information functions ( which include ROW_COUNT() ) to give you specific information you require.
[See MySQL reference here][1]

  [1]: http://dev.mysql.com/doc/refman/5.1/en/information-functions.html

*Quick note: Examples from the tutorial &lt;em&gt;[Scala for Java Refugees Part 5: Traits and Types][1]&lt;/em&gt;.*

Suppose I have the traits Student, Worker, Underpaid, and Young.

How could I declare a class (**not instance**), CollegeStudent, with all these traits?

*Note:* I am aware of the simplests cases, such as CollegeStudent with one or two Traits:

    class CollegeStudent extends Student with Worker

  [1]: https://web.archive.org/web/20170423024917/http://www.codecommit.com/blog/scala/scala-for-java-refugees-part-5


Mixing multiple traits in Scala

Applications send out emails to verify user accounts or reset a password. I believe the following is the way it should be and I am asking for references and implementations.

If an application has to send out a link in an email to verify the user&#39;s address, according to my view, the link and the application&#39;s processing of the link should have the following characteristics:

 1. The link contains a [nonce][1] in the request URI (`http://host/path?nonce`).
 2. On following the link (GET), the user is presented a form, optionally with the nonce.
 3. User confirms the input (POST).
 4. The server receives the request and
  - checks input parameters,
  - performs the change,
  - and invalidates the nonce.

This should be correct per [HTTP RFC on Safe and Idempotent Methods][2].

The problem is that this process involves one additional page or user action (item 3), which is considered superfluous (if not useless) by a lot of people. I had problems presenting this approach to peers and customers, so I am asking for input on this from a broader technical group. The only argument I had against skipping the POST step was a possible pre-loading of the link from the browser.

 - Are there references on this subject that might better explain the idea and convince even a non-technical person (best practices from journals, blogs, ...)?
 - Are there reference sites (preferably popular and with many users) that implement this approach?
  - If not, are there documented reasons or equivalent alternatives?



Thank you,&lt;br/&gt;
Kariem

----
**Details spared**

I have kept the main part short, but to reduce too much discussion around the details which I had intentionally left out, I will add a few assumptions:

 - The content of the email is not part of this discussion. The user knows that she has to click the link to perform the action. If the user does not react, nothing will happen, which is also known.
 - We do not have to indicate why we are mailing the user, nor the communication policy. We assume that the user expects to receive the email.
 - The nonce has an expiration timestamp and is directly associated with the recipients email address to reduce duplicates.

----
**Notes**

With OpenID and the like, normal web applications are relieved from implementing standard user account management (password, email ...), but still some customers want &#39;*their own users*&#39;

Strangely enough I haven&#39;t found a satisfying question nor answer here yet. What I have found so far:

 - [Answer by Don in *HTTP POST with URL query parameters — good idea or not?*][3]
 - [Question from Thomas -- *When do you use POST and when do you use GET?*][4]


  [1]: http://en.wikipedia.org/wiki/Cryptographic_nonce
  [2]: https://www.rfc-editor.org/rfc/rfc2616#section-9.1
  [3]: https://stackoverflow.com/questions/611906/http-post-with-url-query-parameters-good-idea-or-not/612035#612035
  [4]: https://stackoverflow.com/questions/46585/when-do-you-use-post-and-when-do-you-use-get

What are best practices for activation/registration/password-reset links in emails with nonce

I know how one can execute MySQL queries / commands from bash:

    mysql -u[user] -p[pass] -e &quot;[mysql commands]&quot;

or 

    mysql -u[user] -p[pass] `&lt;&lt;`QUERY_INPUT
    
    [mysql commands]
    
    QUERY_INPUT

How can I capture how many rows were affected by the query?  
I tried doing:

    variable=&#39;`mysql -u[user] -p[pass] -e &quot;[mysql commands]&quot;`&#39;

It does execute the command but it does not return the number of affected rows.

How to get number of rows affected, while executing MySQL query from bash?

I know how one can execute MySQL queries / commands from bash:
<pre><code class="hljs language-css">mysql -u[user] -p[pass] -e "[mysql commands]"
</code></pre>
or
<pre><code class="hljs language-css">mysql -u[user] -p[pass] `&#x3C;&#x3C;`QUERY_INPUT

[mysql commands]

QUERY_INPUT
</code></pre>
How can I capture how many rows were affected by the query? 
I tried doing:
<pre><code class="hljs language-css">variable='`mysql -u[user] -p[pass] -e "[mysql commands]"`'
</code></pre>
It does execute the command but it does not return the number of affected rows.

In MySQL, how would I get a timestamp from, say 30 days ago?

Something like:

    select now() - 30

The result should return a timestamp.

MySQL get the date n days ago as a timestamp

I have a column that has comma separated data:

    1,2,3
    3,2,1
    4,5,6
    5,5,5

I&#39;m trying to run a search that would query each value of the CSV string individually.

    0&lt;first&lt;5   and  1&lt;second&lt;3  and  2&lt;third&lt;4 

I get that I could return all queries and split it myself and compare it myself. I&#39;m curious if there is a way to do this so MySQL does that processing work.

Thanks!


Can MySQL split a column?

Is it better to use `default null` or `default &quot;&quot;` for text fields in MySQL?

Why?

Update: I know what means each of them. I am interested what is better to use considering disk space and performance.

Update 2: Hey ppl! The question was &quot;what is better to use&quot; not &quot;what each means&quot; or &quot;how to check them&quot;...

MySQL: NULL vs &quot;&quot;

I store various user details in my MySQL database. Originally it was set up in various tables meaning data is linked with UserIds and outputting via sometimes complicated calls to display and manipulate the data as required. Setting up a new system, it almost makes sense to combine all of these tables into one big table of related content.

- Is this going to be a help or hindrance?
- Speed considerations in calling, updating or searching/manipulating?

Here&#39;s an example of some of my table structure(s):

- users - UserId, username, email, encrypted password, registration date, ip
- user_details - cookie data, name, address, contact details, affiliation, demographic data
- user_activity - contributions, last online, last viewing
- user_settings - profile display settings
- user_interests - advertising targetable variables
- user_levels - access rights
- user_stats - hits, tallies

---
**Edit:** I&#39;ve upvoted all answers so far, they all have elements that essentially answer my question.

Most of the tables have a 1:1 relationship which was the main reason for denormalising them.

Are there going to be issues if the table spans across 100+ columns when a large portion of these cells are likely to remain empty?

Which is more efficient: Multiple MySQL tables or one large table?

My current query looks like this:

    SELECT * FROM fiberbox f WHERE f.fiberBox LIKE &#39;%1740 %&#39; OR f.fiberBox LIKE &#39;%1938 %&#39; OR f.fiberBox LIKE &#39;%1940 %&#39;

I did some looking around and can&#39;t find anything similar to a LIKE IN() - I envision it working like this:

    SELECT * FROM fiberbox f WHERE f.fiberbox LIKE IN(&#39;%140 %&#39;, &#39;%1938 %&#39;, &#39;%1940 %&#39;)

Any ideas? Am I just thinking of the problem the wrong way - some obscure command I&#39;ve never seen.

MySQL 5.0.77-community-log

MySQL LIKE IN()?

I have a command (cmd1) that greps through a log file to filter out a set of numbers. The numbers are 
in random order, so I use sort -gr to get a reverse sorted list of numbers. There may be duplicates within 
this sorted list. I need to find the count for each unique number in that list. 

For e.g. if the output of cmd1 is:

    100 
    100 
    100 
    99 
    99 
    26 
    25 
    24 
    24

I need another command that I can pipe the above output to, so that, I get:


    100     3
    99      2
    26      1
    25      1
    24      2



counting duplicates in a sorted sequence using command line tools

I need something simple like `date`, but in seconds since 1970 instead of the current date, hours, minutes, and seconds.

`date` doesn&#39;t seem to offer that option. Is there an easy way?

Get current time in seconds since the Epoch on Linux, Bash

In cygwin, I could just do ./script.sh args, but this opens the script file in notepad in PowerShell.

What do I need to do have it execute?

Run bash script from Windows PowerShell

I have a few directories and sub-directories containing files with no file extension. I want to add `.jpg` to all the files contained within these directories. I&#39;ve seen bash scripts for changing the file extension but not for just adding one. It also needs to be recursive, can someone help please?


recursively add file extension to all files

Can two files be swapped in bash?

Or, can they be swapped in a shorter way than this:

    cp old tmp
    cp curr old
    cp tmp curr
    rm tmp


Content Type	Original Author	Original Content on Stackoverflow
Question	florin.bunau	View Question on Stackoverflow
Solution 1 - Mysql	Ken Keenan	View Answer on Stackoverflow
Solution 2 - Mysql	florin.bunau	View Answer on Stackoverflow
Solution 3 - Mysql	Jason	View Answer on Stackoverflow

How to get number of rows affected, while executing MySQL query from bash?

Mysql Problem Overview

Mysql Solutions

Solution 1 - Mysql

Solution 2 - Mysql

Solution 3 - Mysql

What are best practices for activation/registration/password-reset links in emails with nonce

Mixing multiple traits in Scala

Attributions