MySQL Database Forum

Hi Folk I want to create something like AMAZON: those who liked page A also liked page B (I am going to apply the concept to a few different selections, but to keep it simple I will talk about page popularity here - like AMAZON talks about purchase patterns: those who bought A also bought B, C and D). In my mysql table, I record everytime...

Hi All Wondered if you could help me with the below query. I have 1 simple table called STOCKCATS that consists of 2 fields. These fields are called CATID and LEVEL. The contents of this table are as follows:

I have an adserver - redhat p4 2GB ram - during peak time the server crashes with hundreds of queued processes (load average 70.00!!!). It serves approx. 1.000.000 impressions per day (page views) - images on remote servers. The database simply select + update views#. I was considering an upgrade to a bigger server with 8-10G RAM (mayby a...

Hello I would like to query the user table of the mysql database from my VB application to check that a user's password entered in a text field on a form corresponds to that users password in the mysql database. However, when I retreive the password using an sql statement into a recordset, it is encrypted. How can I decrypt it so I can make...

Hi All One of my VarChar fields in my MySQL DB isn't big enough so I need to expand it. In light of this, could you please answer these queries: 1) How do I expand the size of the field without affecting the actual data inside the field? 2) As I like to try and keep things as tight as possible in the DB, is there any REAL differences...

Hello, To followup my last post, how do I keep a field in a table already sorted. eg. if a field in it going to have values like "10", "3330" and "1", I want the row with the "1' first in the table, and the "10" second and so on. I want this to happen when I UPDATE, *not* when SELECT-ing, as, according to the last post, if I 'm doing a SELECT...

Hello Does mysql allow you to restrict users access to spcecific tables while allowing access to others. I cant seem to find anything in the manual related to this Ian

Hi, I need a way to read a numeric field and then increment it by one in such a way that even if two users did this at the exact same time, they would still each get their own unique value. I would prefer a method not requiring me to lock the whole table. What is the best way to accomplish this? I am using MySQL 3.23.58 and I use an...

I have a client who wants me to take on a project wherein they have, on another table in another DB, about 1.2 million records. I am going to have to consider, in this project, a record length of about 200 bytes, and am wondering if MYSQL (5.x, on a first-rate Windows server) can handle such size. Does anyone have experience with something...

Hello, If I have a field in a table which will have values like "2.2.2", I want to do a SELECT rows WHERE field "HAS 3 DOTS", AND, a SELECT rows WHERE field "starts with 2.2" but could be anything after that - simply put, a "2.2*", in shell terms.

Hi there I just installed MySQL 5, and its running great except that the query cache is not working, despite the configuration excerpt from my "my.ini" below: query_cache_size=5M query_cache_limit=2M query_cache_min_res_unit=4096k query_cache_type=1

I recently converted data and discovered that when the date wasn't formatted properly '01/01/001' (I think) that I was unable to find the record using Sql i.e 'Select * from table where order_#=100' . However, using utilities (Navicat) I was able to find the record. Any reason? PS In a way I was happy because it helped me determine how I got...

Hi! I have a table with 2000 products, and I want to make my current search engine better. Now I just split the keywords by spaces, and do a 'WHERE blah='$keyword1' OR blah='$keyword2'' It works, but it requires that I have used just that keyword. For example I dont get a match for "pens" if I have "pen" in my database. I have read...

After a failure, we promoted a slave to master. This included renaming the server to the old master's name and ip address, but leaving the server id alone. The new master works fine. We repaired the old server, gave it a different name and ip address but leaving the server id the same. I get the following error on the slave:

TurboAjax Group is proud to release the first public beta version of TurboDbAdmin (http://www.turboajax.com/turbodbadmin.html). TurboDbAdmin is a single-page AJAX solution for exploring and editing databases from a browser. Edit data just like you would in a desktop application, without submit buttons or page refreshes. This release...

I'm not sure if this is the right Newsgroup for MySQL dev questions? I'm currently writing some ODBC interface code, and using a local MySQL db as a development test database. In the medium term, the customer expects many of the databases will indeed be MySQL. So this is a good test. When I have the functionality up and running, we'll then...

I'm trying to pull the last 10 records from a transactions from a table using this query: SELECT * FROM transactions ORDER BY timestamp DESC LIMIT 10 But I want to display the rows in ascending order by timestamp. I can't get the subquery below to work and not sure why: SELECT *

Hi there I was just wondering why I should explicitly create a foreign key, especially if i'm not concerned with Cascading/Deleting when a row is changed. For example, let's say I have a USERS table, with the column 'USERID' as a primary key. Other columns would be 'NAME' and 'EMAIL'. In my users table I have two rows: and

How do I make a table with fields again, say, name, age, address, wife etc. that I want people to be able to look at (with any client like MysqlCC etc), but only be able to modify certain fields, eg. wife (this includes deleting the field from the database, maybe) - the name, age etc. must be left intact, ie. not changeable by anyone. ...

Hello, Example: I have 100 rows that all have the field vaule of 'XYZ' I would like to delete only 10 of those rows. Is there such a query like "Delete 10 rows from table where table.field = 'XYZ'"

Hello, I have a table with columns 'user_ip' and 'user_name'. I need to find out users who are logged under several logins with the same IP. I really don't know how to do this ! Any help will be very appreciated Thanks in advance

UNIVERSITY DIPLOMAS OBTAIN A PROSPEROUS FUTURE, MONEY-EARNING POWER, AND THE PRESTIGE THAT COMES WITH HAVING THE CAREER POSITION YOU'VE ALWAYS DREAMED OF. DIPLOMAS FROM PRESTIGIOUS NON-ACCREDITED UNIVERSITIES BASED ON YOUR PRESENT KNOWLEDGE AND LIFE EXPERIENCE If you qualify, no required tests, classes, books or examinations. ...

I have a backed up table and need to restore it. It is quite large (120 Million Rows) and I am using a file created by mysqldump to restore it (and it is taking forever). I am checking out the various tips on the mysql site about optimizing performance, but am only getting about 1k inserts per second which is way to slow. I am hoping I am...

Hi Guys, I'm missing something in the MySQL clustering design. In the basic design outlined in the How-To, there are two NDBD nodes, a manager node and a MySQL node (ndb). If I now write an application that connects to the single MySQL node, and it fails ... well then the redundant NDBD nodes on the back end don't seem to help much. Am I...

Any other mysql newsgroups besides this one? ian