`RESTRICT` prevents the action from happening if there&#39;s any foreign keys that rely on the field that&#39;s being changed.

I have this code to focus a textarea when the user clicks on the &quot;Reply&quot; button:

&lt;!-- begin snippet: js hide: false console: true babel: false --&gt;

&lt;!-- language: lang-js --&gt;

        $(&#39;#reply_msg&#39;).live(&#39;mousedown&#39;, function() {
            $(this).hide();
            $(&#39;#reply_holder&#39;).show();
            $(&#39;#reply_message&#39;).focus();
        });

&lt;!-- language: lang-html --&gt;

    &lt;script src=&quot;https://cdnjs.cloudflare.com/ajax/libs/jquery/1.4.3/jquery.min.js&quot;&gt;&lt;/script&gt;
    &lt;div id=&quot;reply_msg&quot;&gt;
          &lt;div class=&quot;replybox&quot;&gt;
          &lt;span&gt;Click here to &lt;span class=&quot;link&quot;&gt;Reply&lt;/span&gt;&lt;/span&gt;
          &lt;/div&gt;
          &lt;/div&gt;
          &lt;div id=&quot;reply_holder&quot; style=&quot;display: none;&quot;&gt;
          &lt;div id=&quot;reply_tab&quot;&gt;&lt;img src=&quot;images/blank.gif&quot; /&gt; Reply&lt;/div&gt;
          &lt;label class=&quot;label&quot; for=&quot;reply_subject&quot; style=&quot;padding-top: 7px; width: 64px; color: #999; font-weight: bold; font-size: 13px;&quot;&gt;Subject&lt;/label&gt;
          &lt;input type=&quot;text&quot; id=&quot;reply_subject&quot; class=&quot;input&quot; style=&quot;width: 799px;&quot; value=&quot;Re: &lt;?php echo $info[&#39;subject&#39;]; ?&gt;&quot; /&gt;
          &lt;br /&gt;&lt;br /&gt;
          &lt;textarea name=&quot;reply&quot; id=&quot;reply_message&quot; class=&quot;input&quot; spellcheck=&quot;false&quot;&gt;&lt;/textarea&gt;
          &lt;br /&gt;
          &lt;div id=&quot;reply_buttons&quot;&gt;
          &lt;button type=&quot;button&quot; class=&quot;button&quot; id=&quot;send_reply&quot;&gt;Send&lt;/button&gt;
          &lt;button type=&quot;button&quot; class=&quot;button&quot; id=&quot;cancel_reply_msg&quot;&gt;Cancel&lt;/button&gt;
          &lt;!--&lt;button type=&quot;button&quot; class=&quot;button&quot; id=&quot;save_draft_reply&quot;&gt;Save Draft&lt;/button&gt;--&gt;
          &lt;/div&gt;
        &lt;/div&gt;

&lt;!-- end snippet --&gt;

It shows the reply form, but the textarea won&#39;t focus. I&#39;m adding the textarea via AJAX which is why I am using `.live()`. The box that I add shows (I even add `#reply_msg` via AJAX and stuff happens when I mouse down on it) but it won&#39;t focus on the textarea. 





Why isn&#39;t this textarea focusing with .focus()?

I know I can use `while(dr.Read()){...}` but that loops every field on my table, I want to retrieve all the values from the first row, and then second... and so on.

Let&#39;s say I have a table like this:

    ID--------------Value1--------------Value2------------------Value3
    1               hello               hello2                  hello3
    2               hi1                  hi2                      hi3

first I want to get, `hello`, `hello2` and `hello3` and then go to the second row and get all the values.

Is there a way to achieve this? I hope somebody understand what I mean.

**I am so sorry, this is solved now. I just wasn&#39;t coding right...**

**And yeah the SqlDataReader.Read() method does what it is supposed to do, again the mistake was mine.**


How do I loop through rows with a data reader in C#?

    ...
    user_id INTEGER NOT NULL, 
	CONSTRAINT fk_user_meta FOREIGN KEY (user_id)
		REFERENCES users (id) ON DELETE CASCADE ON UPDATE RESTRICT

I know from [here][1] that ON DELETE CASCADE means that if I delete a row from the users table, then the associated row from the user meta table will be removed too. But what does  ON UPDATE RESTRICT do?


  [1]: http://www.techonthenet.com/oracle/foreign_keys/foreign_delete.php

What does ON UPDATE RESTRICT do?

<pre><code class="hljs language-sql">...
user_id INTEGER NOT NULL, 
CONSTRAINT fk_user_meta FOREIGN KEY (user_id)
	REFERENCES users (id) ON DELETE CASCADE ON UPDATE RESTRICT
</code></pre>
I know from <a href="http://www.techonthenet.com/oracle/foreign_keys/foreign_delete.php" target="_blank" rel="noopener noreferrer">here</a> that ON DELETE CASCADE means that if I delete a row from the users table, then the associated row from the user meta table will be removed too. But what does ON UPDATE RESTRICT do?

MySQL 5.1.31 running on Windows XP.

From the **local** MySQL server (192.168.233.142) I can connect as root as follows:

    &gt;mysql --host=192.168.233.142 --user=root --password=redacted

From a **remote** machine (192.168.233.163), I can see that the mysql port is open:

    # telnet 192.168.233.142 3306
    Trying 192.168.233.142...
    Connected to 192.168.233.142 (192.168.233.142).

But when trying to connect to mysql from the **remote** machine, I receive:

    # mysql --host=192.168.233.142 --user=root --password=redacted
    ERROR 1045 (28000): Access denied for user &#39;root&#39;@&#39;192.168.233.163&#39; (using password: YES)

I have only 2 entries in mysql.user:

    Host         User     Password
    --------------------------------------
    localhost    root     *blahblahblah
    %            root     [same as above]

What more do I need to do to enable remote access?

**EDIT**

As suggested by Paulo below, I tried replacing the mysql.user entry for % with an IP specific entry, so my user table now looks like this:

    Host             User     Password
    ------------------------------------------
    localhost        root     *blahblahblah
    192.168.233.163  root     [same as above]

I then restarted the machine, but the problem persists.

Enable remote MySQL connection: ERROR 1045 (28000): Access denied for user

When working in XAMPP with phpmyadmin, after creating a table I have the option to click &quot;relation view&quot; after clicking on the structure tab. See below:

![enter image description here][1]

However anytime when I create a table with my host phpmyadmin, I dont have the option to select &quot;relation view&quot; See below:

![enter image description here][2]

Is there anyway of enabling this? Currently I have to set up relationships in xampp and export to my host phpmyadmin for it to work. 


  [1]: http://i.stack.imgur.com/SdQOf.png
  [2]: http://i.stack.imgur.com/mdV8D.png

How to enable relation view in phpmyadmin

I have two tables and I need to create a view. The tables are:

    credit_orders(id, client_id, number_of_credits, payment_status)
    credit_usage(id, client_id, credits_used, date)

I use the following query to do this. The query without the &quot;create view&quot; part works well but with &quot;create view&quot;, it shows the error &quot;View&#39;s SELECT contains a subquery in the FROM clause&quot;. What could be the issue &amp; possible solution:

    create view view_credit_status as 
    (select credit_orders.client_id, 
            sum(credit_orders.number_of_credits) as purchased, 
            ifnull(t1.credits_used,0) as used 
     from credit_orders
     left outer join (select * from (select credit_usage.client_id, 
                                            sum(credits_used) as credits_used 
                                     from credit_usage 
                                     group by credit_usage.client_id) as t0
                      ) as t1 on t1.client_id = credit_orders.client_id
     where credit_orders.payment_status=&#39;Paid&#39;
     group by credit_orders.client_id)

View&#39;s SELECT contains a subquery in the FROM clause

I have two tables, `table1` is the parent table with a column `ID` and `table2` with a column `IDFromTable1` (not the actual name) when I put a FK on `IDFromTable1` to `ID` in `table1` I get the error `Foreign key constraint is incorrectly formed error`. I would like to delete table 2 record if `table1` record gets deleted. Thanks for any help

   

    ALTER TABLE `table2`  
       ADD CONSTRAINT `FK1` 
          FOREIGN KEY (`IDFromTable1`) REFERENCES `table1` (`ID`) 
          ON UPDATE CASCADE 
          ON DELETE CASCADE;

Let me know if any other information is needed. I am new to mysql

mysql Foreign key constraint is incorrectly formed error

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 read the quote :
*data depends on the key [1NF], the whole key [2NF] and nothing but the key [3NF]*. 

However, I am having trouble understanding 3.5NF or BCNF as it&#39;s called. Here is what I understand :

 - BCNF is stricter than 3NF
 - left side of any FD in the table must be a superkey (or at least a candidate key)

So why is it then, that some 3NF tables are not in BCNF? I mean, the 3NF quote explicitly says &quot;nothing but the key&quot; meaning that all attributes depend solely on the primary key. The primary key is, after all, a candidate key until it is chosen to be our primary key.

If anything is amiss regarding my understanding so far, please correct me and thanks for any help you can provide.




Difference between 3NF and BCNF in simple terms (must be able to explain to an 8-year old)

I have 3 types of users:

 - Admins
 - Suppliers
 - Employees

Each user type will have different user interface and access different types of data. Their only similarity is they are using one web application but they access totally different things. Is it better to put them all in one user table like tbl_users or is it better to create tbl_admins, tbl_suppliers, tbl_employees?

Database design: 3 types of users, separate or one table?

I am trying to setup a few simple SQL scripts to help with some short term DB administration.
As such, I&#39;m setting up variables to try to make it easier to reuse these scripts.

The problem I&#39;m having is specifically with the LIKE clause.

    SET @email = &#39;test@test.com&#39;;
    
    SELECT email from `user` WHERE email LIKE &#39;%@email%&#39;;

So I want to have it finding results based on the email SET in the variable.  The query works if I manually enter the email into the LIKE clause.

How can I get the LIKE clause to work with the user variable?

UPDATE:
@dems&#39;s answer works for this simple case, but I&#39;m having trouble with a more complex query.

    SET @email = &#39;test@test.com&#39;;

    SELECT project.projectno, project.projectname, login.username, 
    CONCAT(login.firstname, &#39; &#39;, login.lastname), projectuser.title 
    FROM projectuser 
    INNER JOIN login ON projectuser.uid = login.uid 
    LEFT JOIN project ON projectuser.pid = project.pid
    WHERE login.username LIKE CONCAT (&#39;%&#39;, @email, &#39;%&#39;)

Gives me the error &quot;FUNCTION mydb.CONCAT does not exist&quot;

The query works without the CONCAT():

    SET @email = &#39;test@test.com&#39;;
    
    SELECT project.projectno, project.projectname, login.username, 
    CONCAT(login.firstname, &#39; &#39;, login.lastname), projectuser.title 
    FROM projectuser 
    INNER JOIN login ON projectuser.uid = login.uid 
    LEFT JOIN project ON projectuser.pid = project.pid
    WHERE login.username LIKE @email

How to use an user variables in MySQL LIKE clause?

I am very confused about those two terms. Are they the same or different?

Some books and people say they are the same and others say they are different.

I tried but couldn&#39;t find a conclusive answer.


What is difference between foreign key and reference key?

I&#39;m writing a PHP application that will store `STUDENT` data in a MySQL relational database. I&#39;m trying to find the best way / datatype to store a month and year together without the day.

I don&#39;t know whether I should just store it as a DATE and use PHP someway to just store the day as the 1-st or use a different datatype that I&#39;m not currently familiar with. Ideally, I do not want to store a day, because the day will not always be the same and would require changing PHP source code if the day changed in the future.

Just for more background info, I&#39;m storing a STUDENT&#39;s `INTENT_TO_GRAD`. The client seems to only want this information as a reference or a visual for a report as opposed to using it for data manipulation. In other words, the only functional requirement for this data is to be displayed in a report.

MySQL datatype to store month and year only


I know that this sort of goes against the principles of a relational database but let me describe the situation.

I have a page where the user will place a number of items.

     ________________
    | -Item1         |
    | -Item2         |
    | -Item3         |
    | -Item4         |
    |________________|

These  items have must stay in a the order the user gives them. However this order may be changed an arbitrary number of times by the user.


     ________________
    | -Item1         |
    | -Item4         |
    | -Item2         |
    | -Item3         |
    |________________|

**Approach 1**

My original thought was to give the items an index to represent thier place in the list

    Page           Item
    -----------    ---------------
    FK | pid       FK | pid 
       | name      PK | iid 
                      | index
                      | content 

With this solution you can select items `where pid = Page.pid` and `order by index` which is convenient. However every time you change the order you have to change anywhere between one other item (best case) and all the other items (worst case).

**Approach 2**

I also considered making a &quot;linked list&quot; like data structure where each item points to the next item in the list. 

    Page           Item
    -----------    ---------------
    FK | pid       FK | pid 
       | name      PK | iid 
                      | next
                      | content 

This potentially makes changing the order less expensive but we would have to rely on front end programming to extract the order. 


Is there an approach that I haven&#39;t thought of? Please let me know.

Best representation of an ordered list in a database?

So this is more of a design question. 

I have one primary key (say the user&#39;s ID), and I have tons of information associated with that user. 

Should I have multiple tables broken down into categories according to the information, or should I have just one table with many columns?

The way I used to do it was to have multiple tables, so say, one table for application usage data, one table for profile info, one table for back end tokens etc. to keep things looking organized. 

Recently some one told me that it&#39;s better not to do it that way and having a table with lots of columns is fine. The thing is, all those columns have the same primary key.

I&#39;m pretty new to database design so which approach is better and what are the pros and cons? 

What&#39;s the conventional way of doing it?

MySQL: multiple tables or one table with many columns?

I believe the title is self-explanatory. How do you create the table structure in  PostgreSQL to make a many-to-many relationship.

My example:

    Product(name, price);
    Bill(name, date, Products);

Content Type	Original Author	Original Content on Stackoverflow
Question	Alex	View Question on Stackoverflow
Solution 1 - Mysql	Chris Eberle	View Answer on Stackoverflow

What does ON UPDATE RESTRICT do?

Mysql Problem Overview

Mysql Solutions

Solution 1 - Mysql

How do I loop through rows with a data reader in C#?

Why isn't this textarea focusing with .focus()?

Attributions