php - SQL duplicate row -

-

I have a big filter with many options and want to generate SQL for automaticle and without any code without query.

Obtain: 

  SearchView = ABC and Title = ABC and Description = ABC and Category = 1 and Subcategory = 2 & amp; Zip = 7 & amp; City = K & amp; Country = DE

SQL: 

  select activity * Activity, subcategory, city, country, like WHERE activity.title '% abc%' or activity. Details like '% ABC%' and subcategory. SBID = 2 and the city. Zip '% 7%' and like the city. '% For%' and country. C. Shortcode = 'D'

With this option, I have 1 row in my database, the answer is many times many times.

I know that SQL duplicates a line when a table is not used in WHERE clausel - but why do they do this now and how can I solve that?

EDIT: I have an ER, but the database is in German (school project), maybe it helps you understand:

Thanks!

You are doing a cross product by selecting multiple tables. SQL will combine each row from one table to each row in the second table.

For example in a database in the table 

  | ------ | ---------- | | IDA | Text A | | ------ | ---------- | | 1 | Foo | | 2 | Baré | | ------ | ---------- |

and Table B 

  | ------ | ---------- | | IDB | Text B | | ------ | ---------- | | 1 | Fubi | | 2 | Barb | | ------ | ---------- |

When you do 

  SELECT * to a, b

you will get 

  | ------ | ---------- | ------ | ---------- | | IDA | Text A | IDB | Text B | | ------ | ---------- | ------ | ---------- | | 1 | Foo | 1 | Foo | | 1 | Foo | 2 | Baré | | 2 | Baré | 1 | Fubi | | 2 | Baré | 2 | Barb | | ------ | ---------- | ------ | ---------- |

You add to add these rows to the rows. This means that you tell in your query which rows are in place, you can do that in the straight line WHERE of the JOIN clause or the joint contract without it. For example you will do 

  SELECT * to a, b WHERE a.idA = b.idb - or SELECT * to a. AIDA = B.IDB on BEd

You will only get 2 rows. 

  | ------ | ---------- | ----- - | ---------- | | IDA | Text A | IDB | Text B | | ------ | ---------- | ------ | ---------- | | 1 | Foo | 1 | Foo | | 2 | Baré | 2 | Barb | | ------ | ---------- | ------ | ---------- |

To answer your question: JOIN / WHERE to connect you to your table activity , subcategory The Client will have to support city and country according to your database schema.

I do not have your table structure, but for example such sections: 

  where ... and city.country_id = country.id and activity subcategory_id = Subcategory.id and ...

Comments

Post a Comment

Popular posts from this blog

import - Python ImportError: No module named wmi -

-
I followed the instructions for downloading WMI for Python When I try to run the code for C.Win32_Service (StartMode = "Auto", state = "Stopped") import wmi c = wmi.WMI (): if Raw_input ("restart% s?"% S.Caption) .upper () == "Y": s.StartService () I got the error < Code> traceback (most recent call end): file ". \", Line 1, edit: I am using Python 2.7.6 EDIT2: I am running 64-bit Windows 2008 R2, and I've downloaded WMI-1.4.9.zip (md5). I removed the content and put it in D: Python \ Tools \ Scripts I executed dragon setup.py.install I said D : \ Python \ tools \ scripts to% PATH% and when I execute the code for C.Win32_Service (StartMode = "Auto", state = "Stopped") import wmi c = Wmi.WMI (): If raw_input ("Restart% s?"% S. Caption). () == "Y": s.StartService () error me Gets traceback (most recent call final): File ". See \", line 1, &
Read more

Editing Python Class in Shell and SQLAlchemy -

-
I am working on the terminal on a shell script after this tutorial SQLAlchemy tutorial. I need to type gt; & Gt; & Gt; Sqlalchemy import column, integer, string & gt; & Gt; & Gt; Class user (base): __tablename__ = 'users' id = column (integer, primary_key = true) name = column (string) absolute name = column (string) password = column (string) def __repr __ (self): return "& lt ; User (name = '% s', absolute name = '% s', password = '% s') & gt; "% (Self.name, self.fullname, self.password) After the problem I have typed the password = column (string) I hit twice and changed .... >> I then took everything back but then an error was thrown because the class already exists ... I am not completely sure how to fix it. How do I open that slip in the shell script and edit it (Add DF to DRR) The error thrown below: / user / giripeters / TFSQLLX / Lib / python2.7 / site-packages / sqlalchemy / ext / decla
Read more

c# - MySQL Parameterized Select Query joining tables issue -

-
I am using parameterized select questions in conjunction with my program and it works entirely, When I try to join the table Everything I have done is a small fraction: using (MySqlCommand cmd = new MySqlCommand (paramQuery) ToSql (), Connection)) /etc/ paramQuery.ToSql () Equal: "Select TableOne ID, Tableon, Department, Tablet. One by name table, Table 2 h Yes TableOnEID = @Pharmak "* / for (Int Index = 0; Index and Lt; ParamariX Parameter (.c calculation; Index ++) Cmd.Parameters.AddWithValue (paramQuery.Parameters (). ElementAt (index). , ParamQuery.Parameters (). ElementAt (index) .Value); / * ParamQuery.Parameters (). ElementAt (index) .k = "@most 0" paramQuery.Parameters (). ElementAt (index) .Value = "tableTwo.ID" * / MySqlDataReader Reader = cmd.ExecuteReader (); While (reader.Read ()) {// do stuff} } One of the tables I attempt to join is For the table, two with the same id for all. Is there something that I'm doing wrong?
Read more