MySQL Database Forum

Hello, >From the following table showing which countries people have been to Name Countries Fred France Fred UK Bill Germany Jack USA

Hello, I've got databases on one box i have to transfer to another box, both are running Linux one a Centos4 machine, the other rh9 i think. I could tar up the /var/lib/mysql directory, but i was lead to believe that was a bad idea. I don't know the permissions of the user's and i don't want to give out global permissions. What i was...

Hi! How do I limit the amount of returned rows? Lets say, that I want only the latest 400 rows (of e.g. 4034634 rows) - is there a parameter for that like rownum in Oracle? e.g. select * from someplace where rownum < 400 order by sometimefield? BR

I want to make a scheduled task in windows to do a mysqldump. Someone gave me this .bat to run but I'm not able to get it to work. REM @echo off for /f "tokens=1" %%i in ('date /t') do set DATE_DOW=%%i for /f "tokens=2" %%i in ('date /t') do set DATE_DAY=%%i for /f %%i in ('echo %date_day:/=-%') do set DATE_DAY=%%i for /f %%i in ('time...

Hi There, not sure if this can be done with SQL or if there is an SQL crossover I have two tables: Table "record": id, record_id, data1, data2 Table "subrecord": id, record_id, name, value

Hi everyone. I hope someone can help me with this problem. I have installed MySQL CE 5.0, but during the configuration wizard I get an error. It has frozen up during the final step (MySQL Server Instance Configuration). I'm installing it on Windows XP, and I used all the default settings, except that I changed "Detailed Configuration" to...

Does such a thing exist? I have the following DB2 query I need to rewrite to work with MySQL and am having trouble: SELECT DAY(`DATE`), CASE WHEN STATUS='O' OR STATUS='N' OR STATUS='V' OR STATUS='H' OR STATUS='P' OR STATUS='C' OR STATUS='M' THEN 'O' ELSE 'I' END AS STATUS, `GROUP`, COUNT (*) FROM DPS.MYTABLE WHERE YEAR(`DATE`)=2006 AND...

Firstly, I know there's a lot of old posts on this topic but none seem to be relevant to my problem (selecting from a single table rather than several different tables)... I have a table with a user identifier (uID) and a movie identifier (movID) and need to select the movie identifiers that appear in the table for uID-1 but not for uID-2,...

timediff('2006-03-08 22:38:42','2006-03-09 08:47:03') = -13:51:39 How can I make it not output negative numbers when the days increase? -Ike

Hi, I'm trying to insert 5112 lines of data into a table named INVENTORY via phpmyadmin. All the data types are CHAR and have a limit of 50 (there are 8 columns). I tried inserting the data by commands; basically copying and pasting INSERT INTO INVENTORY VALUES ('AHS','312','cpu','dell','3248','HN97P01','','');

I just upgraded my Slackware Linux box from MySQL 4.0 to 5.0 and I'm getting a strange error when I try to start the service. The error log says: /usr/libexec/mysqld: File '/var/log/mysql.000001' not found (Errcode: 13) 060324 15:05:19 Could not use /var/log/mysql for logging (error 13). Turning logging off for the whole duration of the...

Hey NG- I'm trying to order a column such that it's in order by pinyin, hence an ORDER BY clause would change this: ma mà má ma ma

I have a table that contains keywords (Varchars) each one mapped to a product. so the database schema is just an id column, product column and keyword column. I want to select the products that contain x,y,z keywords. Now if this query involves many keywords I end up with a massive amount of self joins on the keywords table, is there a...

Hi, I have big problem with mysql 4.0.18 . Because my database is growing up, every night records that are older than some date are deleted. But size of database on disk isn`t smaller after this operation. There are some solutions to free space by OPTIMIZE TABLE command, but this command when executes, does temporary copy of database. How...

Hello, I am trying to construct a query to be run against a timestamp so that data is displayed from a certain time backwards. For example: SELECT Time_Stamp, Park_Name, Mill_Name, Size, Email_Type FROM emails WHERE TIMEDIFF(NOW(),Time_Stamp) <= '96:00:00' ORDER BY Time_Stamp LIMIT 0, 30 This would theoretically pull all the records...

I am getting: Incorrect information in file: './nitewise/newsletters.frm' Error SQL-query : SHOW COLUMNS FROM `newsletters` FROM `nitewise`

we are designing a data collecting system, at each site we have a database and have a central database,we will write data to site's database, we want the site-database can publish the data to central-database Asynchronously, how could we do that? single replication sounds work,but it will replicate all update ,including delete ,we dont...

I am trying to insert a string with single quote ie can't but mysql fails to insert record how do I get round this.

Hello, I want to select the users from 'userTBL' which does not have any property in 'live_properties' table, Both table has a same column called 'username' I have 2 tables called 'usersTBL' and 'live_properties' user info stored in 'usersTBL' and their properties stored in 'live_properties'

hello everybody, i am new to MySQL. i have installed WinMySQLadmin Ver 1.4 in my computer. anybody pl. help me how to start ? how can i create databse?

I am using the following query to generate a web page. Searchterm is derived from a search form. $query="select * from jobs, items where jobs.JobNumber like '$Searchterm' and items.JobNumber like '$Searchterm'"; The data from the jobs table goes in a general form describing a specific job. The data from the items table goes in a separate...

Hello, is it possible(and how?) to make a new database in a specified folder - i.e. /home/me/mysqldb? or how may i install mysql on debian to use this folder for data files? thanks j.

I'm new to mysql and I was wondering if I could trouble some of you for help. I have a table in my database that may contain multiple versions of the same element as different rows. I wanted to use the following query to group the rows by element with "group by" and then use the "having" to get the most recent version of each element,...

Is there any way I can do a content analysis with MySQL? I need to find text in a database that have similarity. /Jacob

Hello, is it possible(and how?) to make a new database in a specified folder - i.e. /home/me/mysqldb? or how may i install mysql on debian to use this folder for data files? thanks j.