Forum

Posts

RECENTLY INDEXED PROGRAMMING SOLUTIONS OF MYSQL


Character encoding issue with mySQL - '�'  

The collation for the field is utf8_general_ci and the page's character set is utf8, but it appears that some of the data I am storing in my database is not being recognized. I keep getting this character � for something that appears to have no values in the field when looking at... Continue Reading
Views : 2
Monday 31st of December 2012

Should I be putting comma separated lists in fields  

I have a table for insurance agents who need to handle applications from a web form. Depending on the state the user enters in the form, an email would notify a particular agent. One agent handles multiple states. So my table is looking like this: Continue Reading
Views : 74
Monday 31st of December 2012

Update MySQL table from another table  

I inherited a database from an old project and would like to make the data more robust. Currently it stores a group of Jobs and each job has a customer listed, however the customer name is stored as a string value and there is a separate "Customer" table that I would prefer to instead of a... Continue Reading
Views : 90
Monday 31st of December 2012

the big, bad thread of "MySQL Best Practices and Other Useful Information"  

in this thread will be posted various Best Practices and Other Useful Infomation, gleaned from the experienced members lurking around the forums and good other external resources.please observe the following when posting in this thread:make sure to create a... Continue Reading
Views : 68
Monday 31st of December 2012

help with REGEXP  

Hi,I have a table in which one column stores some alphanumeric valuesI am trying to get a count of records in my database that have a particular format (and those that don't)The column has values in the following formatsAAxxxxxxxxxAAAAAand Continue Reading
Views : 72
Sunday 30th of December 2012

fulltext search results  

hi alli m using this below code to search fulltext PHP Code: $sql? Continue Reading
Views : 68
Sunday 30th of December 2012

show sub category if not empty  

hi alli have 5 categories in "category table". with 2 fields "category_id" and "category_name". Code: 1. Adidas2. Reeboketci have 10 sub... Continue Reading
Views : 79
Sunday 30th of December 2012

dynamic query  

I have a database table month_valuesthis table has 12 columns...... columns are jan , feb , march , .....decm.I have data values for each months.I'm writing store procedure. I want to sum values between any two input month columns. Continue Reading
Views : 59
Sunday 30th of December 2012

select with range  

URGENT HELP I have a table of products with age range on them.minAge maxAge 0 62 43 57 118 11i wan to select from products where the age fall within... Continue Reading
Views : 83
Sunday 30th of December 2012

"commands Out Of Sync . . " Mysqli Error  

Below is the code and details of what is happening is below. PHP Code: $stmt? Continue Reading
Views : 133
Sunday 30th of December 2012

Designer Tab in wamp  

Hi, can you help me please where i can find the designer tab in phpmyadmin, i am using wampserver2.2...is the designer tab availabe in wamp?Thank you in advance. Continue Reading
Views : 161
Sunday 30th of December 2012

Addition to Join statement  

Hi all,I have a query that I use that is working a treat that basically checks 2 tables (one of images and one of users) and grabs users who have posted an image. The query is listed below: select tbl_users.user_id, tbl_users.user_display,... Continue Reading
Views : 99
Sunday 30th of December 2012

Applying Mutliple Aggregate Funcs to the Same Columns  

I'm trying to retrieve 2 Averages from records stored in a table of "Business Reviews". The businesses are reviewed in several categories such as "service," "cleanliness," etc... The scores are based on a scale between 1 - 5. The reviews are then compiled based on category into a table with... Continue Reading
Views : 94
Sunday 30th of December 2012

mysql inner join error  

HiI am constructing an inner join with php - below is the code that my php code resolves to:SELECT * FROM `comp-profile-01-general` a INNER JOIN `comp-profile-02-social` b ON `a.co_num` = `b.co_num` INNER JOIN `comp-profile-03-specialties` c ON `a.co_num` = `c.co_num`... Continue Reading
Views : 66
Sunday 30th of December 2012

Trying to decide if I should convert to utf-8  

When I designed my website 8 years ago I never thought that foreign people would register. Most of my users are from the US, Canada and Australia, however, there is a good number from other countries too. Some of their names, obviously, are not stored correctly in the DB because of the... Continue Reading
Views : 64
Sunday 30th of December 2012

Display all derived fields in a query  

I have a very big and complicated query, but the main idea of the query is: Code MySQL: Continue Reading
Views : 159
Sunday 30th of December 2012

How to restore  

Hi, can i ask some help,how can i restore the database Ms sqlserver in other p.c ?can you please help me on this. Thank you in advance. Continue Reading
Views : 61
Sunday 30th of December 2012

table standing  

hallo guys ,first i want to say that i`m fairly new to Php and Mysql .My problem is,i`m making a site for soccer predictions , and i want to show table standings of the leagues .First i want to ask you how i can do it to upgreade dinamycilly the tables .I created 2 tables ,one with the... Continue Reading
Views : 165
Sunday 30th of December 2012

Multiple UPDATES vs. One UPDATE  

My website has a Private Message center which works in a manner very similar to how Yahoo Mail works.When a User views his/her Inbox, next to each Message is a check-box.By checking certain Messages in the Inbox, then choosing an "action" (e.g. Mark as Unread) and then... Continue Reading
Views : 77
Sunday 30th of December 2012

Finding missing numbers in a sequence prior to first existing number  

I have been using this (well circulated) method to ascertain the first missing number in a sequence from a selection of IDs from a specific column (?song_name?) in a... Continue Reading
Views : 64
Sunday 30th of December 2012

PostgreSQL - what are the best resources on the net  

PostgreSQL -what are the best resources on the net?Can anybody submit good links, tutorials, links to references, and recommended booksthanks,DH Continue Reading
Views : 164
Sunday 30th of December 2012

Best way to register votes  

So in the website there are posts, and users can vote them. There is an Id from the post and an Id from the user. Database is MySQL.I'm pretty shure what I'm doing is worng: I have a varchar(22), and in it I put for exemple 233.788, that is: post id "." user id Continue Reading
Views : 79
Sunday 30th of December 2012

send a column value to a function  

Is it possible to send column alias to a function ?I have a select which is basically have a structure like below ..select mytable.myfield as ,func_info(field1), Continue Reading
Views : 89
Sunday 30th of December 2012

Select Statement for Oracle  

Good day for all, I have used MySQL database for my previous projects but now I need to try some on oracle. At the beginner to the Oracle, I decide to familiarize myself with oracle by testing my previous projects in Oracle instead of MySQL. I have the select... Continue Reading
Views : 88
Sunday 30th of December 2012

Update with a join  

Hello I am trying todo the following: Code MySQL: Continue Reading
Views : 74
Sunday 30th of December 2012

Using COUNT in Self Join  

I'm trying to retrieve total counts for musical band/artist type from a single table called 'artist'.For the sake of simplification, let's say the table has only two cols a VARCHAR 'artist_id' and an ENUM 'type'.My problem is, there will never be any matching criteria... Continue Reading
Views : 57
Sunday 30th of December 2012

adding date onto existing date for a where clause  

wanting to gather rows that dateFoo is not the same as dateBar + day(1) tried using DATEADD without any success, for example: select * from table where dateFoo != DATEADD(dayofyear, 1, dateBar) but get the error back: Syntax error: Data Type "dayofyear" does not match Defined Type name. ... Continue Reading
Views : 74
Sunday 30th of December 2012

Determine if Article is in results  

On my website, an "Article" can be in different "Sections", and a "Section" can have many "Articles".When a user selects an Article, I want to be sure that the URL has a valid "Section" for the given "Article" and visa-versa, e.g. Continue Reading
Views : 170
Sunday 30th of December 2012

Database Wiki Page  

Hi. I have been tasked with creating a wiki page on a chosen database. Being an amateur, I do not know what details of the database I should research on, but I do know that I am required to research the security model of that database. I have chosen to do research on MS-Access 2010. What... Continue Reading
Views : 106
Sunday 30th of December 2012

[MySQL 5.0.45-community-nt-log] Sort the rollup in group by  

Hello guys!I found that the "with rollup" option used with group by is very useful. But it does not behave with "order by" clause. Is there any way to order by my way? Code: Continue Reading
Views : 104
Sunday 30th of December 2012