MySQL Database Forum

Hi, I have a many to many x-ref table where column a and b have numbers: 1 | 2 2 | 2 4 | 5 7 | 8 9 | 2 10| 8

hi all, i am a newbie to mysql. I want to know is there any function to retrieve a previous row data. I tried it with combination of mysql_row_seek and mysql_row_tell() but its not correct as they are returning offset values which vant be used with mysql_data_seek()...

I am having a problem putting a certain length of text from a textarea form element into a mySQL field. The field is set to LONGTEXT but I get an error. Whne I shorten the text it writes to the DB with no problem. I am getting a long strng, perhaps 200 characters or more into a variable that will then be written to an mySQL DB but I am...

Hello, We sent you an email a while ago, because you now qualify for a much lower rate based on the biggest rate drop in years. You can now get $327,000 for as little as $617 a month! Bad credit? Doesn't matter, ^low rates are fixed no matter what! Follow this link to process your application and a 24 hour approval:

We regularly make drive images of our entire server and store it at a backup site. To be honest I have never fully understood how the imaging programs deal with open files. My question is will the drive image make a good copy of MySQL DB or should I be running a mysqldump before doing the drive image?

I get this error mysql_pconnect Too many connections ... every now and then. Does anyone knows where it comes from ? There are a lot of sites running on the server and all of them use the Database frequently. Is there any configuration that I will have to do to my server in order to handle the load ? Thank you... I would appreciate...

Hello everybody... I need to do something simple (I believe)... I had a database with a products table.. and now I want to move everything in a new database wich the Table products has a different structure but I want to copy from one to the other the basic Columns... like the id the prod_name and the prod_image How can I do that......

Hi! What started out as a simple test of mysql has turned into what is quickly becoming a replacement for our entire business system and web site The bad news is that we are now wrestling with how to we continue working on development the system without risking down time for users. If we work on a development server, how can we log the...

Given this setup: inventory.itemID item.itemID item.description I want a list of item descriptions which do NOT have an inventory record. Any ideas? I did this before in MS Access as I recall by making

I am doing a search now where I have a statement "FirstName LIKE '%$firstname%' OR JobTitle LIKE '%$jobtitle%' how can I do the same statement using full text search, for example with fulltext I would say MATCH (FirstName) AGAINST ('$firstname') OR MATCH (JobTitle) AGAINST ('$jobtitle) But that doesnt work, what is the correct way to do...

Hi, I have data in a row, such as "34,54,12,134" I need to select rows where they match certain numbers, and not others, so match 34,12 and not 134 (ie the above row would fail, but "34,124,12" would pass). How do I build a REGEXP to search this - I've tried (^34|,34,|,34$) - but that only works to find one match. How do I "AND"

Dear developer, Do you often wonder who built a certain website and how it is done? And who manages that website right now? Strange, but developers usually stay anonymous while they should present themselfs to get more orders. We have been working on a website to change this situation: WebmastersLookup.com. It's a special Searchengine...

Hello, I have the following section of php code which updates a mysql record from a form. For the values of livedate and livetime I need to insert the current_date() and current_time() respectively. When I run the code however it falls over at the line with GetSQLValueString(current_date(), "date")

Hi, I am wondering if anyone can enlighten me on how to get the number/count of table in a database using SQL query. I know I can see the number of table using "Show Tables" in MySQL Syntax but don't know how to get just the count. Thank you in advance, Sunny

I have a large contacts table with about 30 columns of text fields and 5 fulltext indexes spanning the different sections of the table. I'm curious if anyone could suggest a better way to find rows in the table based on text entered by the user. It also would be nice if wildcards could be supported like "beginning*". The query I have built...

It looks like mysql doesn't have the ability to set a query timeout. Is this true? So in the mean time I created the following perl DBI script to do it for me. #!perl # DBI service name use constant DSN => "dbi:mysql:ABC:localhost"; # database username

Hello, I am learning PHP/MySQL at the moment. I found what looked like an excellent tutorial site, but the first program I wrote already left me with an error to which I cannot find an answer. I typed in the following program: <html> <head><title>Connect Server</title></head> <body> <?

Hi, I have 3 posts outstanding on this ng. I am not getting any answers! Any good forums out there, where people do answer you? please advise.

hi folks, Need some help. Am new to SQL and have to run a query on two tables A and B to extract some data. Here, B is a subset of A for the field that's common to both of them. How can we get only those rows that belong to A but not to B, that is, all rows in (table A - table B) on the basis of that common field? Thanks in advance,

Hi, I am running mySQL 4.1.11. I am trying to set up key caches. If I execute this from sql prompt, it works fine: set global cache_name.key_buffer_size = 45 * 1024 * 1024; But when I put this in my.cnf under it gives me an error: cache_name.key_buffer_size = 45 * 1024 * 1024

Hi Folk How do I use the if then else statement in an SQL statement. I tried this: SELECT (IF SSG.ID = SSI.ID then true else false) a, SSG.ID gid, SSG.NAM gnam, SSI.ID iid, SSI.NAM inam, SSI.NAM inam FROM SSG, SSI

Hi everyone, This select question has been bothering me for a long time now. SELECT t1.artnr, t2.photo, t1.access FROM lundhags_product AS t1 LEFT JOIN lundhags_photos AS t2 ON t1.uid=t2.product_uid WHERE t1.access <= 1 GROUP BY t1.uid ORDER BY t1.artname

Hi all. I would like to select the fields that exists more than one time. Description of my table is: Create table MYTABLE (CLASS_ID char(2),STUDENT_ID char(2)); I need to select the students that are in more than one class!

I get this error when I am importing the database. What am I doing wrong? ERROR 1064 at line 625735: You have an error in your SQL syntax near ' begin_excerpt varchar(250) default NULL, PRIMARY KEY (id) ) TYPE=MyISAM' at line 5 Thank you, Micah

I am building a query to select contacts and filter by category. I was wondering if anyone could explain why the first select statement takes 950 times as long to execute compared to the second. I'm sure it has something to do with the way the join is processed but I'm still curious what the engine actually does in each case. In my test the...