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 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):...
hi,
how can I Insert the entire row if Not Exist and Update if exist ?
thx
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 ...
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'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...
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, 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:
...
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?
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 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...
Dear friends,
In my client side, they are using different versions of software products in various places. They are using Same/Different MySQL versions depending upon the different versions...
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...
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
...
Dear All,
Can I ask the most proper way to copy a table (table structure + data) from one database to another?
Thanks
Hi ALL;
How to set up a foreign key to a table in MySQL using phpMyAdmin ( 2.9.2 )?
Please help
I need to know if it is possible to OUTER JOIN multiple tables at the same time.
this would be like OUTER JOINing 2 queries together
this code works (but is a pain to update and takes foreve...
I am trying to install phpMyadmin ..for using it as a client for my mysql database .I am doing this on Red hat Linux ,and PHP 4 and Mysql .
I am getting the following error
" Cannot Load M...
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...
I get this error:
ERROR 1064 (42000) at line 39: You have an error in your SQL syntax;
check the manual that corresponds to your MySQL server version for the
right syntax to use near '...
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) ...
