Just fix your `--where` option.  It should be a valid SQL WHERE clause, like:

`--where=&quot;date_pulled=&#39;2011-05-23&#39;&quot;`

You have the column name outside of the quotes.

You need to quote the &quot;where&quot; clause.

Try 


    mysqldump --opt --user=username --password=password lmhprogram myResumes  --where=&quot;date_pulled=&#39;2011-05-23&#39;&quot; &gt; test.sql



Use this code for specific table rows, using LIKE condition.

    mysqldump -u root -p sel_db_server case_today --where=&quot;date_created LIKE &#39;%2018
    %&#39;&quot; &gt; few_rows_dump.sql

I like my UIs to be intuitive; each screen should naturally and unobtrusively guide the user on to the next step in the app. Barring that, I strive to make things as confusing and confounding as possible.

Just kidding  :-)

I&#39;ve got three `TableRow`s, each containing a read-only and non-focusable EditText control and then a button to its right. Each button starts the same activity but with a different argument. The user makes a selection there and the sub-activity finishes, populating the appropriate `EditText` with the user&#39;s selection.

It&#39;s the classic cascading values mechanism; each selection narrows the available options for the next selection, etc. Thus I&#39;m disabling both controls on each of the next rows until the EditText on the current row contains a value.

I need to do one of two things, in this order of preference:

 1. When a button is clicked, immediately remove focus without setting focus to a different button
 2. Set focus to the first button when the activity starts

The problem manifests after the sub-activity returns; the button that was clicked retains focus.

Re: #1 above - There doesn&#39;t appear to be a `removeFocus()` method, or something similar

Re: #2 above - I can use `requestFocus()` to set focus to the button on the next row, and that works after the sub-activity returns, but for some reason it doesn&#39;t work in the parent activity&#39;s `onCreate()`.

I need UI consistency in either direction--either no buttons have focus after the sub-activity finishes or each button receives focus depending on its place in the logic flow, including the very first (and only) active button prior to any selection.

How to remove focus without setting focus to another control?

I want to create a regex that removes all non-alphanumber characters but keeps spaces. This is to clean search input before it hits the db. Here&#39;s what I have so far:

    @search_query = @search_query.gsub(/[^0-9a-z]/i, &#39;&#39;)

Problem here is it removes all the spaces. Solutions on how to retain spaces?

How do I strip non alphanumeric characters from a string and keep spaces?

I am trying to do a mysql dump of a few rows in my database. I can then use the dump to upload those few rows into another database. The code I have is working, but it dumps everything. How can I get mysqldump to only dump certain rows of a table?

Here is my code:

&lt;pre&gt;&lt;code&gt;
mysqldump --opt --user=username --password=password lmhprogram myResumes  --where=date_pulled=&#39;2011-05-23&#39; &gt; test.sql

&lt;/code&gt;&lt;/pre&gt;



MYSQL Dump only certain rows

I am trying to do a mysql dump of a few rows in my database. I can then use the dump to upload those few rows into another database. The code I have is working, but it dumps everything. How can I get mysqldump to only dump certain rows of a table?
Here is my code:
<pre><code class="hljs language-css">
mysqldump --opt --user=username --password=password lmhprogram myResumes --where=date_pulled='2011-05-23' > test.sql


</code><code></code></pre>

I created a stored procedure in phpMyAdmin

    CREATE PROCEDURE Sample()
    SELECT * FROM feedback

Where could I view this this procedure? If it&#39;s not possible in phpMyAdmin, what is/are some good program(s) that have the feature to write, store, and view stored procedures, tables, etc?

How do I view my stored procedures in phpMyAdmin?

How can I convert entire MySQL database character-set to UTF-8 and collation to UTF-8?

How to convert an entire MySQL database characterset and collation to UTF-8?

Are table names in MySQL case sensitive?

On my Windows development machine the code I have is able to query my tables which appear to be all lowercase. When I deploy to the test server in our datacenter the table names appear to start with an uppercase letter.

The servers we use are all on Ubuntu.




Are table names in MySQL case sensitive?

I&#39;ve got a couple of duplicates in a database that I want to inspect, so what I did to see which are duplicates, I did this:

    SELECT relevant_field
    FROM some_table
    GROUP BY relevant_field
    HAVING COUNT(*) &gt; 1

This way, I will get all rows with relevant_field occuring more than once. This query takes milliseconds to execute.

Now, I wanted to inspect each of the duplicates, so I thought I could SELECT each row in some_table with a relevant_field in the above query, so I did like this:

    SELECT *
	FROM some_table 
    WHERE relevant_field IN
	(
		SELECT relevant_field
		FROM some_table
		GROUP BY relevant_field
		HAVING COUNT(*) &gt; 1
	)


This turns out to be extreeeemely slow for some reason (it takes minutes). What exactly is going on here to make it that slow? relevant_field is indexed.

Eventually I tried creating a view &quot;temp_view&quot; from the first query `(SELECT relevant_field FROM some_table GROUP BY relevant_field HAVING COUNT(*) &gt; 1)`, and then making my second query like this instead:

    SELECT *
    FROM some_table
    WHERE relevant_field IN
    (
    	SELECT relevant_field
    	FROM temp_view
    )

And that works just fine. MySQL does this in some milliseconds.

Any SQL experts here who can explain what&#39;s going on?


MySQL - SELECT WHERE field IN (subquery) - Extremely slow why?

Is it possible to negate a where clause?

e.g.

    DELETE * FROM table WHERE id != 2;

SQL WHERE condition is not equal to?

I have a query that I am running in SQL Server Management Studio (connecting to a SQL Server 2005 database). I want to export the data in CSV format. Not wannabe CSV format, where you just stick a comma between each column, but &quot;real&quot; CSV format, where you put quotes around your strings. This way you can export data that has commas or quotes in it.

All the examples I see limit themselves to the wannabe format. I can&#39;t figure out where the option to quote strings is.

If SSMS is truly incapable of this basic feat, are there other tools that will do it easily? I don&#39;t want to have to write a C# program every time I need a data dump.


How to get export output in &quot;real&quot; CSV format in SQL Server Management Studio?

How do I query DateTime database field within a certain range?

I am using SQL SERVER 2005

Error code below

    SELECT * 
      FROM TABLENAME 
     WHERE DateTime &gt;= 12/04/2011 12:00:00 AM 
       AND DateTime &lt;= 25/05/2011 3:53:04 AM

Note that I need to get rows within a certain time range.  Example, 10 mins time range.

Currently SQL return with Incorrect syntax near &#39;12&#39;.&quot;

Simple DateTime sql query

    SELECT DISTINCT field1, field2, field3, ......   FROM table

I am trying to accomplish the following sql statement but I want it to return all columns is this possible? Something like:

    SELECT DISTINCT field1, * from table

SQL/mysql - Select distinct/UNIQUE but return all columns?

I want to extract just the date part from a timestamp in PostgreSQL.

I need it to be a postgresql `DATE` type so I can insert it into another table that expects a `DATE` value.

For example, if I have `2011/05/26 09:00:00`, I want `2011/05/26`

**I tried casting, but I only get 2011:**
     
    timestamp:date
    cast(timestamp as date)


**I tried `to_char()` with `to_date()`:**

    SELECT to_date(to_char(timestamp, &#39;YYYY/MM/DD&#39;), &#39;YYYY/MM/DD&#39;) 
    FROM val3 WHERE id=1;


**I tried to make it a function:**
    
    CREATE OR REPLACE FUNCTION testing() RETURNS void AS &#39;
    DECLARE i_date DATE;
    BEGIN
        SELECT to_date(to_char(val1, &quot;YYYY/MM/DD&quot;),&quot;YYYY/MM/DD&quot;) 
          INTO i_date FROM exampTable WHERE id=1;
        INSERT INTO foo(testd) VALUES (i);
    END

What is the best way to extract date (yyyy/mm/dd) from a timestamp in PostgreSQL?

Extract date (yyyy/mm/dd) from a timestamp in PostgreSQL

Here&#39;s the information I have:

I am working with a Linux based system using MySQL and PHP5.  I need to be able to generate a `mysqldump` from within a .php file, and then have that dump be stored in a file on the server in a location I would specify.

As I&#39;m a PHP nooblet, I&#39;d like someone to give me some assistance, guidance, or code, that would do what I require. This would have to be run remotely from the Internet.

Using a .php file to generate a MySQL dump

I wrote a script to backup my MySQL databases using:

    mysqldump --opt --all-databases -u user -pmypassword &gt; myDump.sql

A cron launches it every night and scp the result to another server.
`mypassword` appears in clear in my script, everyone can see it with the appropriate rights. I have been told about /proc issues too (where the cmd run can be seen).

MySQL documentation says:

&gt; Specifying a password on the command line should be considered insecure. See Section 7.6, &quot;Keeping Your Password Secure&quot;.

I have not found this magic 7.6 sections anywhere.

 What is the good practice to deal with automatic mysqldump and password security?

Mysqldump launched by cron and password security

How can I backup a mysql database which is running on a remote server, I need to store the back up file in the local pc.

How to use MySQL dump from a remote machine

I have a MySQL user called *dump* with the following perms:
    
    GRANT USAGE ON *.* TO &#39;dump&#39;@&#39;%&#39; IDENTIFIED BY ...
    GRANT SELECT, LOCK TABLES ON `mysql`.* TO &#39;dump&#39;@&#39;%&#39;
    GRANT SELECT, LOCK TABLES ON `myschema`.* TO &#39;dump&#39;@&#39;%&#39;

I want to dump all data (included triggers and procedures) using the *dump* user. I call mysqldump in the following way:

    mysqldump -u dump -p --routines --triggers --quote-names --opt \
        --add-drop-database --databases myschema &gt; myschema.sql

Everything is OK with the dumped file except for the **triggers, they are missing**!!

The triggers are dumped correctly if I try mysqldump with _root_ MySQL user:

    mysqldump -u root -p --routines --triggers --quote-names --opt \
        --add-drop-database --databases myschema &gt; myschema.sql


So, I guess it is a perms issue... what are the **extra grants my _dump_ MySQL user needs for doing the full dump correctly?** 


Minimum GRANTs needed by mysqldump for dumping a full schema? (TRIGGERs are missing!!)

I know questions with this title have been answered before, but please do read on. I&#39;ve read thoroughly all the other questions/answers on this error before posting.

I am getting the above error for the following query:

    CREATE TABLE IF NOT EXISTS `pds_core_menu_items` (
      `menu_id` varchar(32) NOT NULL,
      `parent_menu_id` int(32) unsigned DEFAULT NULL,
      `menu_name` varchar(255) DEFAULT NULL,
      `menu_link` varchar(255) DEFAULT NULL,
      `plugin` varchar(255) DEFAULT NULL,
      `menu_type` int(1) DEFAULT NULL,
      `extend` varchar(255) DEFAULT NULL,
      `new_window` int(1) DEFAULT NULL,
      `rank` int(100) DEFAULT NULL,
      `hide` int(1) DEFAULT NULL,
      `template_id` int(32) unsigned DEFAULT NULL,
      `alias` varchar(255) DEFAULT NULL,
      `layout` varchar(255) DEFAULT NULL,
      PRIMARY KEY (`menu_id`),
      KEY `index` (`parent_menu_id`,`menu_link`,`plugin`,`alias`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

Does anyone have idea why and how to fix it?
The catch is - this same query works perfectly on my local machine, and worked as well on my previous host. Btw.it&#39;s from a mature project - phpdevshell - so I&#39;d guess these guys know what they are doing, although you never know.

Any clue appreciated.

I&#39;m using phpMyAdmin.

Content Type	Original Author	Original Content on Stackoverflow
Question	Shattuck	View Question on Stackoverflow
Solution 1 - Mysql	AJ.	View Answer on Stackoverflow
Solution 2 - Mysql	Neville Kuyt	View Answer on Stackoverflow
Solution 3 - Mysql	Rokonz Zaz	View Answer on Stackoverflow

MYSQL Dump only certain rows

Mysql Problem Overview

Mysql Solutions

Solution 1 - Mysql

Solution 2 - Mysql

Solution 3 - Mysql

How do I strip non alphanumeric characters from a string and keep spaces?

How to remove focus without setting focus to another control?

Attributions