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 username.myapp.com
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: http://mysqldump.Naimoli.com/archives/20-Nermalisation.html and http://goo.gl/2X5B4 and some here http://www.keithjbrown.co.uk/vworks/mysql/
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.