HOME PAGE
Home Page: Web development, programming, hosting and design from North West based business
CMS
SERVICES
HOSTING
CONTACT US
TECHNICAL
ABOUT US
Friday 09th May 2008
MySQL General: 2 D query
Hi I have a table with 2 columns Name (variable type) and CODE (variable type)
I need to retrieve a result in the following format
NAME -->
CODE
| FREQUENCY
|
V
The number of names may vary
so also the code
I Need to wri
Read this forum post
Tuesday 29th April 2008
MySQL General: What is clustering in MySQL?
I am not clear about clustering in MySQL? So I have the following questions:
1. What is clustering in MySQL?
2. When should we use the clustering?
3. Does the clustering depend on MySQL Version?
4. How I can create it?
5. What is the difference bet
Read this forum post
Tuesday 29th April 2008
MySQL General: difficult mysql compare / select statement
I am using MySql 5.0.51a and am trying to acheive the following
I have 2 tables, one of categories and one of company details, each company can select up to 6 different categories for their business.
In my category table, I have sub categories, and
Read this forum post
Tuesday 29th April 2008
MySQL General: Postgreql conversion
Hi everyone I recently designed a MYSQL database and used the following function to fetch the row. Unfortunately I have been told that the server is POSTgresql only so I am having to revwerse enjineer the class. I have included the function below and am h
Read this forum post
Tuesday 29th April 2008
MySQL General: How do I validate a field with data from existing values
Hi, Im a beginning PHP/MySQL developer and I'm trying to figure out how to do something, any help would be awesome.
Basically if i enter a value into a table using INSERT INTO; how do make PHP know and alert me when that value is already somewhere els
Read this forum post
Friday 25th April 2008
MySQL General: Select existing from dropdown or fill in new record -in form
Hi, I'm asked to create forms for adding recorded data involving climate research, with many inter-dependencies making the queries somewhat complex. I have to work with PHP Version 4.4.4 and MySQL server version 4.1.18 The budget is quite low, so we can't
Read this forum post
Tuesday 22nd April 2008
MySQL General: keeping a 0 in front of a random integer
Hi, I have a minor problem with keeping the 0 in front of an integer whenever i insert it into a field.
i.e.
inserting a number such 0123 would be stored as 123 in INT datatype field.
how would i get around to keeping the 0 because its crucia
Read this forum post
Sunday 20th April 2008
MySQL General: Alternative to MySQL GUI Tools on the Mac OS X 10.5
Hi
New to using MYSQL only downloaded yesterday, after much messing about I managed to get the server started.
Then I download the GUI tools but these dont work with the latest MAC OS.
Can anyone recommend an alternative that will work with Mac O
Read this forum post
Friday 18th April 2008
MySQL General: Upgrading 5.0 to 5.1 - What happens to old tables?
First off, I made a big mistake. I'm using Mac OS X and I'm just messing around with MySQL, so the data isn't all that important. It will just take time to rebuild it all if its lost.
I had version 5.0.27 running fine. I wanted to upgrade to 5.1.24. So
Read this forum post
Thursday 17th April 2008
MySQL General: MySQL query OK in localhost, error on ISP serve.
The following query run flawlessly in localhost but produces error on ISP server:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'distinct sf_threads.views) as views,
Read this forum post