Just use the table name:

    SELECT myTable.*, otherTable.foo, otherTable.bar...

That would select all columns from `myTable` and columns `foo` and `bar` from `otherTable`.

I need more information really but it will be along the lines of..

    SELECT table1.*, table2.col1, table2.col3 FROM table1 JOIN table2 USING(id)

`select a.* , b.Aa , b.Ab, b.Ac 
 from table1 a 
 left join table2 b on a.id=b.id` 

this should select all columns from table 1 and only the listed columns from table 2 joined by id.  

Using alias for referencing the tables to get the columns from different tables after joining them.

    Select tb1.*, tb2.col1, tb2.col2 from table1 tb1 JOIN table2 tb2 on tb1.Id = tb2.Id



When I issue SHOW PROCESSLIST query, only first 100 characters of the running SQL query are returned in the info column.

Is it possible to change Mysql config or issue a different kind of request to see complete query (the queries I&#39;m looking at are longer than 100 characters)

How to see full query from SHOW PROCESSLIST

How to import a jar in Eclipse?

How do you select all the columns from one table and just some columns from another table using JOIN? In MySQL.


MySQL Select all columns from one table and some from another table

<p>How do you select all the columns from one table and just some columns from another table using JOIN? In MySQL.</p>


I have a list like this:

    Red
    Red
    Brown
    Yellow
    Green
    Green
    Brown
    Red
    Orange

I am trying to do a SELECT UNIQUE with LINQ, i.e. I want

    Red
    Brown
    Yellow
    Green
    Orange

    var uniqueColors = from dbo in database.MainTable
                       where dbo.Property == true
                       select dbo.Color.Name;

I then changed this to

    var uniqueColors = from dbo in database.MainTable
                       where dbo.Property == true
                       select dbo.Color.Name.Distinct();

with no success. The first `select` gets ALL the colors, so how do I modify it to only get the unique values?

If there is a better way of structuring this query, more than happy to go that route.

How do I go about editing it so I can have `.OrderBy( &quot;column name&quot; )` i.e. alphabetically by color name, so name property?

I keep getting a message:

&gt; The type arguments cannot be inferred from the usage. Try specifying the type arguments explicitly.


How can I do SELECT UNIQUE with LINQ?

I would like to add some style on a select box with the pseudo :after (to style my select box with 2 parts and without images). Here&#39;s the HTML:

    &lt;select name=&quot;&quot;&gt;
      &lt;option value=&quot;&quot;&gt;Test&lt;/option&gt;
    &lt;/select&gt;

And it doesn&#39;t work. I don&#39;t know why and I didn&#39;t find the answer in the W3C specs. Here&#39;s the CSS:

    select {
      -webkit-appearance: none;
      background: black;
      border: none;
      border-radius: 0;
      color: white;
    }

    select:after {
      content: &quot; &quot;;
      display: inline-block;
      width: 24px; height: 24px;
      background: blue;
    }

So is it normal or is there a trick?

problem with &lt;select&gt; and :after with CSS in WebKit

In SQLite, how can I select records where `some_column` is empty?  
Empty counts as both `NULL` and `&quot;&quot;`.

SQLite select where empty?

I&#39;ve always preached to my developers that `SELECT *` is evil and should be avoided like the plague.

Are there any cases where it can be justified?

I&#39;m not talking about `COUNT(*)` - which most optimizers can figure out.

**Edit**

I&#39;m talking about production code.

And one great example I saw of this bad practice was a legacy asp application that used `select *` in a stored procedure, and used `ADO` to loop through the returned records, but got the columns by index. You can imagine what happened when a new field was added somewhere other than the end of the field list.

Can select * usage ever be justified?

Totally out of ideas here, could be needing a simple solution.

Basically my desired query is :

    SELECT * FROM table WHERE id = 3,4

I want to select only the row which has ID 3 and 4, or maybe name &quot;andy&quot; and &quot;paul&quot;

Thank you very much for the answer

MySQL Select Multiple VALUES

Currently we are using the following commands in PHP to set the character set to [UTF-8][1] in our application. 

Since this is a bit of overhead, we&#39;d like to set this as the default setting in MySQL. Can we do this in /etc/my.cnf or in another location?

    SET NAMES &#39;utf8&#39;
    SET CHARACTER SET utf8

I&#39;ve looked for a default charset in /etc/my.cnf, but there&#39;s nothing there about charsets.

At this point, I did the following to set the MySQL charset and collation variables to UTF-8:

    skip-character-set-client-handshake
    character_set_client=utf8
    character_set_server=utf8

Is that a correct way to handle this?

  [1]: http://en.wikipedia.org/wiki/UTF-8


Change MySQL default character set to UTF-8 in my.cnf?

Is there a way I can make a query in MySQL that will give me the difference between two timestamps in seconds, or would I need to do that in PHP? And if so, how would I go about doing that?

MySQL: how to get the difference between two timestamps in seconds

I want to use order by with union in mysql query.
I am fetching different types of record based on different criteria from a table based on distance for a search on my site.
The first select query returns data related to the exact place search .
The 2nd select query returns data related to distance within 5 kms from the place searched.
The 3rd select query returns data related to distance within 5-15 kms from the place searched.

Then i m using union to merge all results and show on a page with paging. Under appropriate heading as **&#39;Exact search results&#39;**, **&#39;Results within 5 kms&#39;** etc

Now i want to sort results based on id or add_date. But when i add order by clause at the end of my query ( query1 union query 2 union query 3 order by add_date). It sorts all results. But what i want is it should sort under each heading.

Using union and order by clause in mysql

I am getting `NULL` values in the results of an operation in MySQL.   

Is there a way to convert the `NULL` values into the value 0?

Replace null with 0 in MySQL

Does it depend on the number of values sets?  Does it depend on the number of bytes in the INSERT statement?


MySQL - how many rows can I insert in one single INSERT statement?

I have a table customer that stores a customer_id, email and reference. There is an additional table customer_data that stores a historical record of the changes made to the customer, i.e. when there&#39;s a change made a new row is inserted.

In order to display the customer information in a table, the two tables need to be joined, however only the most recent row from customer_data should be joined to the customer table.

It gets a little more complicated in that the query is paginated, so has a limit and an offset.

How can I do this with MySQL? I think I&#39;m wanting to put a DISTINCT in there somewhere...

The query at the minute is like this-

    SELECT *, CONCAT(title,&#39; &#39;,forename,&#39; &#39;,surname) AS name
    FROM customer c
    INNER JOIN customer_data d on c.customer_id=d.customer_id
    WHERE name LIKE &#39;%Smith%&#39; LIMIT 10, 20

Additionaly, am I right in thinking I can use CONCAT with LIKE in this way?

(I appreciate that INNER JOIN might be the wrong type of JOIN to use. I actually have no clue what the difference is between the different JOINs. I&#39;m going to look into that now!)

MySQL JOIN the most recent row only?

I wish to know if I have a **join** query something like this - 

    Select E.Id,E.Name from Employee E join Dept D on E.DeptId=D.Id

and a **subquery** something like this -

    Select E.Id,E.Name from Employee Where DeptId in (Select Id from Dept)

When I consider **performance** which of the two queries would be faster and *why* ?

 Also is there a time when I should prefer one over the other?

Sorry if this is too trivial and asked before but I am confused about it. Also, it would be great if you guys can suggest me **tools** i should use to measure performance of two queries. Thanks a lot!


SQL Joins Vs SQL Subqueries (Performance)?

I am checking some old SQL Statements for the purpose of documenting them and probably enhancing them.

The DBMS is Oracle

I did not understand a statement which read like this:

    select ...
    from a,b
    where a.id=b.id(+)

I am confused about the `(+)` operator, and could not get it at any forums... (searching for + within quotes didn&#39;t work either).

Anyway, I used &#39;Explain Plan&#39; of SQLDeveloper and I got an output saying that `HASH JOIN, RIGHT OUTER`, etc.

Would there be any difference if I remove the `(+)` operator at the end of the query? Does the database have to satisfy some condition (like having some indexes, etc.) before `(+)` can be used?? It would be greatly helpful if you can provide me a simple understanding, or some good links where I can read about this.

Thanks!

Oracle &quot;(+)&quot; Operator

What makes a given table the left table?

Is it that the table is indicated in the &quot;From&quot; part of the query?

Or, is it the left table because it is on the left hand side of the = operator?

Are the following equivalent

    SELECT *
    FROM left_table
    LEFT JOIN right_table ON left_table.right_id = right_table.id

and

    SELECT *
    FROM left_table
    LEFT JOIN right_table on right_table.left_id = left_table.id

???

Thanks

Which table exactly is the &quot;left&quot; table and &quot;right&quot; table in a JOIN statement (SQL)?

This is a little complicated, but I have 2 tables. Let&#39;s say the structure is something like this:

    *Table1*
    ID
    PhoneNumber1
    PhoneNumber2

    *Table2*
    PhoneNumber
    SomeOtherField

The tables can be joined based on Table1.PhoneNumber1 -&gt; Table2.PhoneNumber, or Table1.PhoneNumber2 -&gt; Table2.PhoneNumber.

Now, I want to get a resultset that contains PhoneNumber1, SomeOtherField that corresponds to PhoneNumber1, PhoneNumber2, and SomeOtherField that corresponds to PhoneNumber2.

I thought of 2 ways to do this - either by joining on the table twice, or by joining once with an OR in the ON clause.

**Method 1**:

    SELECT t1.PhoneNumber1, t1.PhoneNumber2, 
       t2.SomeOtherFieldForPhone1, t3.someOtherFieldForPhone2
    FROM Table1 t1
    INNER JOIN Table2 t2
       ON t2.PhoneNumber = t1.PhoneNumber1
    INNER JOIN Table2 t3
       ON t3.PhoneNumber = t1.PhoneNumber2

This seems to work.

**Method 2**:

To somehow have a query that looks a bit like this -

    SELECT ...
    FROM Table1
    INNER JOIN Table2 
       ON Table1.PhoneNumber1 = Table2.PhoneNumber OR
          Table1.PhoneNumber2 = Table2.PhoneNumber

I haven&#39;t gotten this to work yet and I&#39;m not sure if there&#39;s a way to do it.

What&#39;s the best way to accomplish this? Neither way seems simple or intuitive... Is there a more straightforward way to do this? How is this requirement generally implemented?

Content Type	Original Author	Original Content on Stackoverflow
Question	Alex	View Question on Stackoverflow
Solution 1 - Select	Tatu Ulmanen	View Answer on Stackoverflow
Solution 2 - Select	Simon	View Answer on Stackoverflow
Solution 3 - Select	Mzila	View Answer on Stackoverflow
Solution 4 - Select	Himanshu	View Answer on Stackoverflow

MySQL Select all columns from one table and some from another table

Select Problem Overview

Select Solutions

Solution 1 - Select

Solution 2 - Select

Solution 3 - Select

Solution 4 - Select

How to import a jar in Eclipse?

How to see full query from SHOW PROCESSLIST

Attributions