MySQL Database Forum

Two newbie questions... I want to try MySQL but I already have Microsoft SQL Server on my machine. Can they reside on the same PC or will they mess eachother up? And why does the name of this newsgroup start with 'mailing.'? Thanks for your help.

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...

------=_NextPart_000_0034_01C221EC.6C64FAAA270 Content-Type: text/plain; charset="iso-8859-1" ...ãÌÇäÇ :.ÌäÓ. ÓßÑí . ÈßÇÑå.æÒä. ÝíÇÛÑÇ ÞÖíÈ.Øæá.ÕáÚ.ãÈíÖ.ãÒíá.ÓæÇÏ.ÚÌÑã.ÞÐÝ.ÐßÑ.ÖÛØ ÇáãæÖæÚ : ãÌÇäÇ : ÇáÇÓÊÔÇÑå ÇáØÈíå ÇáÇãÑíßíå : 0096395414798- 0096395441826 Çáæßíáå ÇáãæÞÚ Çhttp://www.drrah.com ãÌÇäÇ: ÇáÇÓÊÔÇÑå ÇáØÈíå ÇáÇãÑíßíå...

Hello All, I was searching for a response about this topic but none get the right answare, I hope i get help from you on this. :) I trying to do an insert using a stored procedure to rely the charge on the db but every type I run the call from my web page ussing PHP 5.X I get the same error. This is what I'm doing:

Is there a way to filter 'show processlist'? like show processlist where Host rlike "abc" Thanks, Sam

Hello I installed MySQL ver 4.0.20d on a Windows XP Professional PC. I created a user and database that I would like to delete, and at this point I would just like to uninstall MySQL and do a fresh installation. I have deleted MySQL by going to Start > Settings > Control Panel > Add or Remove Programs. However, when I reinstall MySQL, ...

I REALLY dont want to switch to oracle :( but I cant get these tables working any faster. I've got 2 dedicated servers, each with a slave, all run 32gig 15k rpm raid 5 on u320 perc raid cards, dell 2600/4600's with single channel backplanes (new ones will have dual channel) All have 2 gig of ram, but I've never seen mysql use more than...

I'm trying to install MySQL. During the security settings portion fo the setup. I keep getting a Connection Error. Error Nr. 1045 Access denied for user'root'@'localhost'(using password:YES) ........ I had Zonealarm running. Changed the trusted zone security setting to low(disabled) then selected "retry" Failed again.

Hello! I'm having a bit of trouble with a query. I am trying to paginate a set of results using LIMIT. Each result has a bit of 'basic' data and potentially multiple 'additional' data. I have used LEFT JOIN to get the data from table 2. I want to limit the amount of data to 10 rows of table 1 but if there are two pieces of data on table 2...

Folks, I'm writing an application on a LAMPhp server... Everything has been fine up until now though I have only got about 6months of MySQL behind me. Today... my server has started to report the following while trying to do a mysql_query() select from an empty table... Warning: mysql_query(): Can't connect to local MySQL server through...

Hi, I am switching to Linux and I am new to MySQL. I can do this in MS SQL: Given a persons DB and a weddings DB: persons : ID, NAME weddings: ID, MANID, WOMANID, DATE

hello friends , i just want to know whether SQL and MySQL are same ,if not what is the difference in them

im trying to dump my database for a replication but i encounter this error message... mysqldump: Got error: 1045: access denied for user 'ODBC' @ 'localhost' <using password NO> when trying to connect.... can somebody tell me how can i solve this problem please..

Hi everyone. I have two tables in the same DB. They both contain alphanumeric codes like "XX123". (one looks up the other) I need to do a natural sort on these in both tables. In one table if I use the trick +0 it works perfectly : SELECT * FROM `thistable` ORDER BY `thiscode` + 0 ASC However in the other table SELECT * FROM...

Hi, I would like to move my DBs in another directory. I know that I have to change in my.cnf the datadir path .... datadir=/var/lib/mysql -datadir=/user/mysql/databases

How can we get the table schema information in MYSQL 5.1.34? Like we use in ORACLE to get it as: OCIDescribeAny() // //get the describe handle for the table to be described. OCIAttrGet() // to get parameter handle OCIAttrGet() ////get the number of columns in the table

The following query produces a very slow running failure. (Usually time out). I am not sure about the syntax. Any ideas? UPDATE `table1`,`table2`,`table3` SET WHERE `tables1`.`id` = '20439'

hi friends, i imported my database from ms access to mysql, there is a problem though the date in mysql has the format (yyyy-mm-dd) and i want to change it to dd/mm/yyyy.how can i do it?i am using phpmyadmin(wamp) to manage my database.please give me a solution to convert the date format from my phpmyadmin.thanks. regards, ajos

I have inherited a table where date information was saved from PHP as a VARCHAR. (Sigh.) This means that the so-called date fields look like this : August 1, 2005, 9:09 am EDT October 13, 2004, 12:28 pm EDT This makes them essentially useless for sorting and logical evaluation. Understandbly, the MySQL date functions don't seem able to...

I keep getting the famous 'Too Many Connection' Error, and don't know how to change my variables, so they persist even if i have to restart mysql service. Platform: Windows 2003 Server My Program is a WebApplication that is written in VB.Net Using ODBC and OLEDB to connect <- (don't blame me, i just took this over) From what i have read...

Hi All, I am a PHP programmer, i am using XAMPP software for programming and Mysal as a Database. I want to use my MySql database from command prompt. Help me how to connect,create databases in MySql from Command prompt. Thank you Pavankumar P

Hi I'm using linux with mysql , when i type mysql in terminal it says like: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) i'm logged in as root but it works when i type mysql -u root -p and then type root password.

Hello, I found the key to solve this problem in: http://darkstar.ist.utl.pt/mysql/doc/en/InnoDB_foreign_key_constraints.html You'll probably need an INDEX for that new foreign key you are declaring in older versions this isn't neccesary but in latest ones it is a restriction. You can have more info about the error description if you...

Hi! I have 4 tables (table1, table2, table3, table 4) I need to do select * from all four table and get them sorted all the tables have field named id, so I figured that's the field I should join all the tables with let's say table1 has 5 records in it, and table2 has 3 when I do select I want that id from table2 starts from 6 and goes to...

comapre column value of two row of same table. suppose in table tabl1 have column name comn1 it has two row means two value... after comparison i have to return some value like true or false................... So tell me any in-built function is there in MS-sql.................