Databases
StackOverflow2013
Postsdbo
POVB.net WHERE Statement for MySQL
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POVB.net WHERE Statement for MySQL
    primarykey
    data
    text
    <p>Good evening everyone. I ran into a problem that has me somewhat stumped. I am converting over to MySQL from Access and it seems that some of the Syntax is different for a MySQL Query. What I am doing is an operator selects a Client form a "ComboBox" which is populated from records in the "Client" table. I got that done with no problems. When the user selects a client, another combobox gets populated with data from the table "Lines". The table "Lines" has 2 columns Client and Line. I was trying to get each line WHERE Client = LEXAR. Any thoughts or ideas?</p> <p>I figured it would be something like:</p> <pre><code>"SELECT * FROM Lines WHERE Client=LEXAR" or "SELECT * FROM Lines WHERE(client = @LEXAR)" or "SELECT * FROM Lines WHERE(client = '@LEXAR')" or "SELECT * FROM Lines WHERE client LIKE LEXAR)" or "SELECT * FROM ``Lines``WHERE ``Client``='LEXAR')" or "SELECT * FROM Lines WHERE Client ='LEXAR')" </code></pre> <p>but none work. Here is my code:</p> <pre><code>Dim sql As MySqlCommand = New MySqlCommand("SELECT * FROM Lines WHERE(client = @LEXAR)", con) Dim dt As DataTable = New DataTable() Dim DataAdapter1 As MySqlDataAdapter = New MySqlDataAdapter(sql) DataAdapter1.Fill(dt) If dt.Rows.Count &gt; 0 Then ComboBox1.DataSource = dt ComboBox1.DisplayMember = "Line" End If con.Close() </code></pre> <p>These are the errors:</p> <pre><code>Fatal error encountered during command execution. </code></pre> <p>and</p> <pre><code>You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Lines WHERE client = LEXAR)' at line 1 </code></pre> <p>Full Code:</p> <pre><code>Imports MySql.Data.MySqlClient Imports System.Net Imports System.IO Dim con As MySqlConnection = New MySqlConnection("Data Source=xxx.xxx.xxx.xxx;Database=productiontrackerpro;User ID=xxxxxxxx;Password=xxxxxxxx;") Public Sub LoadClients() Dim sql As MySqlCommand = New MySqlCommand("SELECT * FROM Lines WHERE Client = 'LEXAR')", con) Dim dt As DataTable = New DataTable() Dim DataAdapter1 As MySqlDataAdapter = New MySqlDataAdapter(sql) DataAdapter1.Fill(dt) If dt.Rows.Count &gt; 0 Then ComboBox1.DataSource = dt ComboBox1.DisplayMember = "Line" End If con.Close() End Sub </code></pre> <p>Error:</p> <pre><code>You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Lines WHERE Client = 'LEXAR')' at line 1 </code></pre>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USTy Jacobs
    1. USTy Jacobs
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. CONot a MySQL guy, but try `SELECT * FROM Lines WHERE Client = 'LEXAR'`
      singulars
      1. POVB.net WHERE Statement for MySQL
      1. USCortright
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload