Latest Tracked Programming Questions Of MYSQL

MYSQL : Primary Key Name   (Views   2011)

Posted On: Monday 31st of December 2012 01:46:17 AM
I have a question about how to name the primary row id key in my MySQL tables. Is it good practice to use the same naming convention for the primary row id field in every table e.g. "row_id", or should i name them all uniquely e.g. in the users table call it "users_row_id" and in the...Show More

MYSQL : requirements changed in join...now...how to do it   (Views   194)

Posted On: Monday 31st of December 2012 01:46:13 AM
Hi I have 2 tables, faq and faq_categories...i have a join that work, and so far, I was a happy camper. But...requirements change, and i have to change the join, but i don't know how to do itHere is the current code that works just fine:Show More

MYSQL : [MySQL 5.5.24-log] Error in output query   (Views   208)

Posted On: Monday 31st of December 2012 01:46:11 AM
hello , I hope your help.I can't understand why different output between these two queries.Can you help meShow More

MYSQL : two unique indexes   (Views   250)

Posted On: Monday 31st of December 2012 01:45:56 AM
If there are 10 columns in the tablethen can we set "index type" = "unique" for 2 or more columnsOr is it limited to only 1 column vineetShow More

MYSQL : Inventory Report   (Views   218)

Posted On: Monday 31st of December 2012 01:45:25 AM
My database with the following table:ITDetail Table:InvTrans Table:Currency Table:Show More

MYSQL : Is there a better way to relate a web page to a row in a database   (Views   142)

Posted On: Monday 31st of December 2012 01:45:22 AM
We currently use a CMS we developed in-house. It's not a full CMS, as it just contains things like the contact name for a given web page, page title, and some other details, but not the content.As it is now, each page is "linked" to its row in the database by the page URL (minus the...Show More

MYSQL : string comparison question   (Views   225)

Posted On: Monday 31st of December 2012 01:45:19 AM
been away for a while and am obviously rusty. Please assume 'today' is Saturday.I am trying to output the days on which a product is available either side of...Show More

MYSQL : Need help for my database design   (Views   215)

Posted On: Monday 31st of December 2012 01:45:15 AM
can i ask some help for my db design,i want to make cake ordering...but i have some doubt on my tables and my fields,i am not good in this db design,..I hope you can help me.Please see my attachment.Thank you in advance.Show More

MYSQL : MySql Join 3 Tables   (Views   210)

Posted On: Monday 31st of December 2012 01:44:56 AM
Hi Everyone, How would I go about joining 3 tables at once My database design/setup is at the below URL. I want the mysql statement to say "1992 Ford Explorer" Show More

MYSQL : Using DISTINCT and COALESCE together   (Views   229)

Posted On: Monday 31st of December 2012 01:44:53 AM
Below is a query which gives me the Usernames of the Last-10 Visitors to a Member's Profile... Code SQL: Show More

MYSQL : [Solved] Why isn't my triple join working   (Views   231)

Posted On: Monday 31st of December 2012 01:44:50 AM
SP,I'm trying to join three tables. I want some items from table "item_inventory" to be displayed if they are appear in the right category and are also set as a "best seller". The best seller is set in a table called item_field_data. If there is a record in item_field_data with the...Show More

MYSQL : Change column to autonumber (MSSQL)   (Views   211)

Posted On: Monday 31st of December 2012 01:44:45 AM
After six years of constant nagging from me, my office has finally implemented a copy of MSSQL to replace Access (Woohoo!), so I am now going through and making changes to my queries, which is going quite well.The one problem I noticed was that when the server people imported my...Show More

MYSQL : How to paginate in case of SELECT * AGAINST    (Views   218)

Posted On: Monday 31st of December 2012 01:44:31 AM
When generating a LIST via SELECT AGAINST then LIMIT X, Y does not work.That is if the SELECT statemenet is like:SELECT ix_id, title, descpt FROM customers WHERE MATCH (title, descpt) AGAINST('$find') LIMIT 90, 100Rather than getting the results from...Show More

MYSQL : Problems reinstalling mySql   (Views   217)

Posted On: Monday 31st of December 2012 01:44:25 AM
Hi all. I have problems reinstalling mySql. Two days ago I started to get problems setting up Datasources. The error stated that the connection to the database server had failed. When I tried to login in mySql I couldn't any longer so I decided to start from scratch but every time It doesn't pass...Show More

MYSQL : SELECT by non-primary key   (Views   200)

Posted On: Monday 31st of December 2012 01:44:21 AM
I have a tableCREATE TABLE IF NOT EXISTS `reviews` ( `id` smallint unsigned NOT NULL auto_increment, `from` varchar(50) NOT NULL, `length` varchar(20) NOT NULL default '', `date` date NOT NULL, `providerid` smallint unsigned NOT NULL, PRIMARY KEY ...Show More

MYSQL : locating phpmyadmin login   (Views   229)

Posted On: Monday 31st of December 2012 01:44:16 AM
So, I need to edit some content on a website that someone else built. It appears that it was built using joomla. http://newportsportsclub.com/I have the ftp, but I don't know the login to joomla admin. The...Show More

MYSQL : SQL and RDBMS Database Design DO's and DON'Ts   (Views   262)

Posted On: Monday 31st of December 2012 01:44:09 AM
This is a document I've been slowly adding to as I come across things 'in the wild'. Maybe it can be of some useSQL and RDBMS Database Design DO's and DON'Ts------------------------------------------Generic DOs:Develop a backup strategy...Show More

MYSQL : Help with this simple query   (Views   228)

Posted On: Monday 31st of December 2012 01:06:36 AM
Ok, I am hoping someone could help me out here. I have a query which is not working properly and is driving me crazy.I have two tables data_table = my main working tabledaily_removed = same structure as main table, but less recordswhat I would like to do isupdate...Show More

MYSQL : How to count a column correctly after join 2 tables   (Views   142)

Posted On: Monday 31st of December 2012 01:06:32 AM
I have these two tables and the following values Code: Table Popular Table...Show More

MYSQL : Update TABLE from a Related Table with Multiple Entries (only wanting the latest val)   (Views   183)

Posted On: Monday 31st of December 2012 01:06:28 AM
The example below is not real, but if I can solve this, I know I can solve the bigger problem I have!Using MYSQL, I have two tables. Farm and Animals. Animals can have several items connected to farm with the "farmid" serving as a related key.FARM id ...Show More

MYSQL : Grouping records by category name   (Views   236)

Posted On: Monday 31st of December 2012 01:06:26 AM
Table data structure is:link_id | name | url | category--------------------------------------------------------------------1 | SitePoint Forums | http://sitepoint.com/forums |...Show More

MYSQL : Database and seach engine, with suggests, synonyms, full text search, etc   (Views   175)

Posted On: Monday 31st of December 2012 01:05:54 AM
Hi I'm searching a database with search engine to my job.We use vbulletin forum , and we want to create new landing to search threads and posts. But we can't use the vbulletin mysql database because in the future we will include other external results.I think this...Show More

MYSQL : MySQL Foreign Key Issues   (Views   203)

Posted On: Monday 31st of December 2012 01:05:50 AM
Hi , I am a newbie with mysql. I am creating tables but i get stuck when it comes to foreign keys. I tried to remove the foreign keys and than paste the rest of the code, add an additional column of the foreign key but still its not working. Could someone assist me please. i will really be...Show More

MYSQL : [MySQL 5.0.45-community-nt-log] How do I insert a random value into mysql   (Views   147)

Posted On: Monday 31st of December 2012 01:05:47 AM
hello.It looks like RAND is what I need but I'm having a bit of trouble understanding how it works.I need to insert a random name between 1 and 3 into a table mysql, selecting these random name from a first table called listing_names.Table name is: listing and the...Show More

MYSQL : Viewing a MDF database in Access 2010   (Views   195)

Posted On: Monday 31st of December 2012 01:05:43 AM
I have a database, Northwind.mdf. I want to view it in Access 2010 or any other Database Programs like Microsoft SQL Server 2012.Could someone help me through the steps to do thisShow More

MYSQL : Order by count   (Views   200)

Posted On: Monday 31st of December 2012 01:05:26 AM
I have a query that orders results by the count of another table:"SELECT table1.*, COUNT(table2.id) AS rev_count FROM table1 LEFT JOIN table2 ON table1.name = table2.name WHERE table1.active = 1 AND table1.city='$city' GROUP BY table1.name ORDER BY rev_count...Show More

MYSQL : php - mysql count from morethan one table   (Views   201)

Posted On: Monday 31st of December 2012 01:05:23 AM
Hai folks,table1empno|salary-------------10 | 150020 | 275021 | 4000table2empno|department-------------19 | a24 | b31 | xi want a query to get the total records in both tables.so the...Show More

MYSQL : database courses   (Views   269)

Posted On: Monday 31st of December 2012 01:05:20 AM
hi , i need some information from you .actually i want learn database side courses,but i don't know what are the courses available other than sql,mysql etc.. if you know about other courses please let me tellthnks in advance.Show More

MYSQL : COUNT Causing Problems.   (Views   198)

Posted On: Monday 31st of December 2012 01:05:17 AM
Hi allWhat I have below works good and returns all the reviews depending on the venue_id selected. Code SQL: Show More

MYSQL : Trying to optimize slow MySQL query   (Views   194)

Posted On: Monday 31st of December 2012 01:05:01 AM
You should have a look at "Using temporary; Using filesort". This is what is slowing your SQL down as it is writing to disk and sorting on disk. You might want to have a look at increasing the sort_buffer_size on your server to have the sorts performed in memory and not on disk.Show More