SETUP:
WindowXP Home Edition
Almost fresh installation, only softwares installed are: IIS, Apache, Tomcat, J2SE, Perl, PHP, and two firewalls.
GOAL:
I installed before MySQL on window ...
Hello,
in MS SQL there is a command that I can issue where when used as the default value for
the fields (DateTime datatype) will generate date & time value when a new row is inserted.
...
Hi,
Please kindly assist how can we remotly login to mysql ?
running on fedora core 3 (fresh install) everything is default.
how can we change the root (mysql) password? are there com...
I am going out of my mind.... I have installed and uninstalled MySQL about 8 times now due to problems I've been having and I STILL cannot uninstall it completely. Every time I reinstall, and ...
Hi,
The following is a simplified version of a complex query i wrote.
SELECT table2.x, table2.y
FROM table1
LEFT JOIN (SELECT table3.x, max(table3.y)
FROM table3
...
Hi,
I have this table: tbl_1
Type Value
x 1
x 2
y 1
z 0
x 3
y 1
I'd like to get the average of ...
hi,
how can I Insert the entire row if Not Exist and Update if exist ?
thx
I have a table called PK_members with a column names Unique Key set to false.
I need an SQL statement that will cahnge it to true
How can I do this?
I am a total newbie to MySQL. I'm in a position where I need to grasp MySQL and FAST!!!!
I have been really struggling. I was first getting the Error 2003 but after following the advice in ...
Hello,
I am using a standard [config.inc.php] for phpMyAdmin. When trying to login to my VPS I received that error:
#1045 - Access denied for user 'root'@'localhost' (using password: YE...
In MySQL, how do I do an insert based upon whether or not a row already exists in a table? The SQL below doesn't seem to work, so I'm looking for another way to accomplish this. Below is all o...
Hi,
I just reset mysql's password to be empty. It's a virtual machine so I don't care of the security.
After the mysqld restart I got this error "Checking for corrupt, not cleanly closed a...
Hi,
How can I change the existing database name in mysql? I cannot find any entries in phpmyadmin.
Pls, advise
Thanks
A
Hi, I'm trying to run a php script on a VPS I just ordered and it keeps failing. I have php and mysql installed but I keep getting this error when trying to start the irc bot php script:
...
Mysql v3.23.49 says I have an error with the following syntax:
SELECT * FROM enquiry_courses WHERE enquiry_id IN ( SELECT enquiry_id FROM enquiries WHERE session_id = '4cd3420a16dbd61c6af...
how do i select the top 10 row of data in mysql?
in M$ $QL $erver, i can get only n-row of data using this query
SELECT TOP 1 *
FROM [dbo].[SHOES]
but it doesnt work in m...
I've installed Apache 2.054 WIN, PHP 5.04 and MySQL 4.1 with MySqlAdmin for window. Running XP Service Pack 2.
Whenever I try to connectt MySQL, I get Error 1045 - Acess denied for 'root@l...
Hi ALL;
How to set up a foreign key to a table in MySQL using phpMyAdmin ( 2.9.2 )?
Please help
mysql> select qin, qout, yield, reject FROM yield WHERE date BETWEEN '11/01/2003' AND '01/31/2004';
hi...
i have this sql statement that does not extract the query i want
It did not even ...
I'm just doing a simple searching type script and can't seem to find the answer to this anywhere. In MSSQL, I can run the following:
SELECT field_name
FROM table_name
WHERE CONTAINS(fi...
In MS-Access this query:
SELECT dens.id AS [value], [description] & " Den " & [den] AS [text]
FROM dens INNER JOIN dentype ON dens.dentype = dentype.code;
Returns
Value Descriptio...
I have installed mysql just now ,but i dont know how to change the root password .
as i type in './mysql_secure_installation' ,it shows:
Enter current password for root (enter for none):...
Hello,
I got a bunch of questions on mysql, and answered all of them but one. I know asking to solve homework is against this forums rules, so I only ask for a VERY SMALL hint.
And here ...
Hi ppl,
I am just wondering whether the MySQL table will need to do reindexing after a period of time? As far as I am concerned, POSTGRESQL will need to do this after to period of time to r...
Dear Experts,
I've been using MySQL for some time now, but I haven't really explored the more advanced features. Regarding field types for currency, when should I use a decimal and when sho...