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,
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 ...
I created a MySQL backup file from MySQL Administrator 1.0.18 (running MySQL 4.1). When I try to restore this file to another instance of MySQL Administrator 1.2.12 (running MySQL 5.0) on an...
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...
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 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 '...
I'm a newbie to this forum and am looking for some help with MySQL. I'm trying to get a count of users that have completed specific activities. For example, I need to be able to run a query ...
Having a problem with create temporary table.
I have these queries, and when I go to display in the browser, it gives me the error of "Table 'packets' already exists"
CREATE TEMPORARY TA...
Im attempting to install Moodle LMS and when I get to a certain page the error message displayed is "PHP has not been properly configured with the MySQL extension so that it can communicate wi...
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 All,
Can I ask the most proper way to copy a table (table structure + data) from one database to another?
Thanks
Hi
I have been sent a file that is a dump from an sql database (which has been dumped as an sql insert query) and I need to get the data into a mysql database table.
The problem is when I ru...
I am running MySQL 4.1 on Windows XP professional. I am trying to connect to MySQL administrator. But it is giving the following error when I try to connect:
Could not connect to the specif...
I would like to know how to properly alter a table column name in MySQL; to rename it without using 3rd party editors.
ERROR I receive when I try any of the Snippet Samples.
I receive a sy...
Hi all
How do i define a currency format in mySql
I have imported a Access database table to mySql
Got a collum containing prices with 2 decimal after a comma... like this 7,25 eur...
I can't seem to get select into outfile to work. Take a look of what I've tried:
# cd /
# mkdir test
# chmod 777 test
# chown mysql:mysql test
mysql> select * into outfile '/test/data' ...
Hello,
i have 2 tables, one containing product information (product number, description) and the other containing product details (price by customer).
I would like to run a query that disp...
I have enetered the following syntax into my database and it all enters fine. However when I run;
Delete from questionnaire_title Where Survey_ID = '1'
I get the error;
[localhost] ER...
Hi!
I need a mysql query that will select only the rows that have duplicates in a table.
For example if there are 10 identical rows, I need to delete 9 of them so that I will end up with...
Hi,
Is there a function on mysql 5 we can use to encrypt a column? this column contains the passwrods.
Please kindly assist on how can we encrypt and decrypt?
Thanks.
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 ...
Hi,
When i am inserting date in just created table it returns following error: Duplicate entry '1' for key 1. The primary key is set to auto_increament. What could cause the problem and where...
Hi all,
Working with Classic ASP and MySQL
I have a MySQL database of membership names(firstName,midName,lastName). Before adding a new name I check the recordset RS for any records cont...
Hi!
Recently I installed mySQL 5.0.2 on my Server PC, and I need clients PC can connect to mySQL server, and when I installed mySQl Administrator, MySQL front on clients PC and tried to con...
Hi,
Can anyone please tell me the equivalent syntax in MySql for the following?
*** isnull(col_name,' ') *** (Microsoft SQL Server)
Since the query,
*** select isnull(col_name,' '...
