Brunoalano: First, decide.

Soong: I have a job_requests table

Buetti: Farra_000: just curious, but why are you asking Bridendolph ?

Hamersly: Bc the error message says I have a SQL problem

Buetti: Rakm: no, you cannot alter the data in a table referenced in a subquery

Ruff: Hmm ok. is there another way to delete all but the first 100 rows?

Morinville: Or any 100 rows, really

Cashion: Just need to cut down a staging instance to use less resources. it’s all junk data

Harig: Buetti, I just didn’t know if the performance tuning is a viable approach. I could be getting poor performance inherently because of the table structure.

Buetti: Rakm: hint – you can delete anything you can select

Buetti: Farra_000: TOP 10 ID is not mysql s syntax

Buetti: Farra_000: TOP 10 ID is not mysql syntax

Buetti: Farra_000: microsoft sql server

Buetti: Keesler: This is loosely true: For planning – competent hardware, competent mysql server config as to buffers and caches and log file sizes, normalized schema design, correct table storage engine choice, proper data types, adequate indexing, competent queries. For performance troubleshooting – reverse the order. :-

Buetti: Farra_000: sorry, I confused your post with that of rakm

Buetti: Farra_000: so i just looked at your pastebin, and your code is also looking for Microsft SQL Server.

Buetti: So I quit for the night, since Microsoft stuff gives me the willies

Paulson: Someone can give me a tip about Cl*** Table Inheritance?

Arguilez: Brunoalano: really doesn’t sounds like a mysql question. be specific.

Arguilez: If this is how to get an application library working you’d be better of in and discussion channel language

Nanka: SELECT t1.productId, t1.productName FROM products t1 LEFT JOIN productvariations t2 ON t1.productId = t2.productID WHERE t1.productMainProduct IS NULL; i have many rows in t2 that match t1.productId = t2.productID is possible to limit ONE t2.productID? im getting duplicated products because can limit that to just one result latestone

Dramis: Arguilez: I can talk about Schema Design here?

Arguilez: Yes, but don’t expect people to design it all for you.

Moog: T1 and t2 are not related date

Bourke: Just store date in t2

Capparelli: But have multiples records on t2 that match t1.productId = t2.productID i need to filter just the latest one do get displayd

Knezevic: It get all the rows i get duplicated ones

Jett: My problem is that: I’ve a Employee and a User. Both are authenticable email and p***word, but Employee will access our dashboard, and the User, will have a custom subdomain

Luangxay: In t2 i store the stock variations related to products stored in t1

Arguilez: You may need to join inner, not left/right on product/productvariations again

Daluz: It’s better to create an Account model with email and p***word, and then inherits User and Employee

Wishart: Ok, let me try with inner

Christophe: I tryied inned a few minutes ago but still getting duplicated ones

Kahre: Maybe with SELECT DISTINCT :

Arguilez: Dont’ help select which one.

Arguilez: Brunoalano: sql doesn’t have inheritence

Huffmaster: Brunoalano: and and some here

Arguilez: SamSagaZ: my mistake – might be left as duplicatates may not exists.

Kneedler: Brunoalano: First, decide on the term with which you will refer to these objects in your database. Employee and User, as you describe them, do not inherit in from one another. But they share a common root object. So you should have a root table pick a better name and then a user is a root object that has a subdomain ***igned and an employee has email and p***word ***igned in some way.