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 ...
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...
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.
...
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 ...
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 ...
hi,
how can I Insert the entire row if Not Exist and Update if exist ?
thx
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 am attempting to add a column to a table with data in it. Nothing
I have seen says you can't butI get an error that says it could not save
the table as some other name. I am assuming it cr...
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):...
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?
Hi,
How can I change the existing database name in mysql? I cannot find any entries in phpmyadmin.
Pls, advise
Thanks
A
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
...
What is the SQL command to list all tables in a database?
What is the SQL command to list all columns in a table?
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:
...
Dear Members:
I'm experiencing the same issue as a previous question: "Title: Unable to connect to the database: Could not connect to MySQL" but I can't seem to find any posting of a possib...
Hi,
I'm getting the above error when trying to configure MySQL, after I type the following:
c:\mysql\bin\mysql mysql
I don't have the faintest idea what to do. (I have another questio...
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...
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...
Hi ALL;
How to set up a foreign key to a table in MySQL using phpMyAdmin ( 2.9.2 )?
Please help
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...
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...
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...
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...
Hi,
Please kindly assist how can we resolve this error? mysql 5
Thanks.
Error Code : 1093
You can't specify target table 'member' for update in FROM clause
(0 ms taken)
(1 row(s) ...
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 ...
