MySQL | Forum profile

Quote: Originally Posted by oorin This table was designed to allow a web site administrator a high level of configuration for collecting data. while at the same time no consideration for how hard it would be to extract meaningful information do a search for EAV (entity-attribute-value) you will find a ...

Code: SELECT ticket_updates.* FROM tickets INNER JOIN ( SELECT TicketId , MAX(DateUpdated) AS LastUpdated FROM ticket_updates GROUP BY TicketId ) AS m ON m.TicketId = tickets.TicketId INNER JOIN ticket_updates ON ticket_updates.TicketId = tickets.TicketId AND ticket_updates.DateUpdated = m.LastUpdated WHERE...

I originally thought that it would be best if I could get all headers with the corresponding links on a single line but I'm starting to think that isn't such a good idea anymore. Maybe a different design? Maybe EAV??

One way you can do this is to start logging slow queries. Check out MySQL Query Log . Once you got the list of slow queries, then you can start improving it. Another option is to use some kind of caching like Memcache .

Dear All, I have installed MySql Server5.0.42 on windows xp sp3. I know how to create database, tables and inserting rows through Mysql Command line only. I have created a database named 'search' having 3 tables. I tried to make backup using following command mysql> mysqldump -u root -p search > backupsearch.sql where i am getting Error 1064 you have an error in your SQL ...

Hello, I'm not sure what function I'm looking for but what I'm wanting to do is group all of the a.version by NULL vs Not NULL no matter what the version value is. What do I need to do? select c.name, c.address, a.version From clients c Left Join app_Info a ON c.uid = a.uid

that is not something any of us can answer from the info you provided. What are all these tables for? What is the relationship between them? Have you read any books on database design? Thought about hiring someone to do your design work? 100,000 tables seems a bit extreme. I have worked on numerous large scale applications and They average 200 - 600 tables for an app. Rows ranging from 1 in a ...

i prefer SIUD to CRUD, because there is a SELECT statement but there is no RETRIEVE statement also, CREATE refers to actually creating tables, while INSERT creates the data in tables other operations include ALTER, DROP, GRANT, and more

Code: SELECT article FROM articles WHERE article_id IN ( SELECT tagConnect_article FROM tagConnect WHERE tagConnect_tag IN ( 1,3,5,7 ) GROUP BY tagConnect_article HAVING COUNT(*) = 4 ) note that your tagConnect_id column is useless -- the tagConnect table should have a compound PK consisting of (tagConnect_article,...

First thing I would do is read on database normalization. That will help with number 1. #2. You will be fine. Forums with hundreds of thousands of messages work perfectly fine on mysql. Holding the information will not slow the server at all. The queries could slow if not properly indexed, but the information is only accessed as needed, so this is not an issue. #3 the data will technically...

Here's a design I was thinking for a forum I'm making right now. Do you think this design will work efficiently. Should I create more posts tables to allow faster querying, or is one fine? Forums: id(int)(primary), name(varchar)(unique), createdeleteboard (int-refers to some security table issuing moderator officer status etc.) Boards: id(int)(primary), forumid(int)(index), name(...

Quote: Originally Posted by lse123 Is any error with this query yes, is any error first, remove the parentheses around the SELECT second, replace the dreaded, evil "select star" (SELECT * ) with a list of all the columns except the auto_increment then add the list of all columns except the auto_...

Not really sure what you're asking but do you mean this: Code: select 'y' as job1, 'Complete' as job2; or do you mean translating the value 'y' to become 'Complete'? Can you give a clearer example? Mike

Hello, I'm not sure what function I'm looking for but what I'm wanting to do is group all of the a.version by NULL vs Not NULL no matter what the version value is. What do I need to do? select c.name, c.address, a.version From clients c Left Join app_Info a ON c.uid = a.uid

so what is the actual message what is the actual SQL that is being sent to the SQL engine you might want to try the "between" syntax

i prefer SIUD to CRUD, because there is a SELECT statement but there is no RETRIEVE statement also, CREATE refers to actually creating tables, while INSERT creates the data in tables other operations include ALTER, DROP, GRANT, and more

that is not something any of us can answer from the info you provided. What are all these tables for? What is the relationship between them? Have you read any books on database design? Thought about hiring someone to do your design work? 100,000 tables seems a bit extreme. I have worked on numerous large scale applications and They average 200 - 600 tables for an app. Rows ranging from 1 in a ...

Dear All, I have installed MySql Server5.0.42 on windows xp sp3. I know how to create database, tables and inserting rows through Mysql Command line only. I have created a database named 'search' having 3 tables. I tried to make backup using following command mysql> mysqldump -u root -p search > backupsearch.sql where i am getting Error 1064 you have an error in your SQL ...