What do you think about Windows 7? Write a review or a how-to about Microsoft's newest product and earn unlimited points!

 

Having problems asking a question? Have a general question about Experts Exchange? Let us know!

 
Time Tested MySQL Server Solutions: 51 - 75 of 3218
 
MySQL: How to INNER JOIN a COUNT with a SELECT statement
I have two tables. One has a bunch of listings.. One has a bunch of votes.. or views or whatever based on Table A. So Table A has a bunch of listings with Unique ID Numbers. Table B has info...
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Hi I've just changed my mysql root user password and now when I try to login to the mysql command line shell using the new password I get the following error: ERROR 2002 (HY000): Can't c...
MySQL - copy data from one column to another in the same table
I have a table as shown below, how can I copy the contents from itemName to itemDescb I need to copy from one column to another column in the same table. CREATE TABLE `products` (   `PI...
While Loops In MySQL
I am am MS SQL developer and I am busy trying to migrate over to MySQL. I need to populate a table for testing and I would like to do this using a while loop. I noticed that MySQL does support...
ERROR 1 (HY000): Can't create/write to file '/test/data' (Errcode: 13)
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' ...
PhpMyAdmin: "You probably tried to upload too large file. Please refer to documentation for ways to workaround this limit."
I am trying to import a .csv table into MySQL via PHPMyAdmin.  At first, it was timing out whenever I tried to import.  Based on various forumn posts, I increased the following to 10000M in or...
Updating multiple rows in a single statement
Hey all! I thought I'd have a look at trying to make our update queries more efficient, because our code currently generates multiple update queries when I'd rather just operate on multiple...
Cannot delete or update a parent row: a foreign key constraint fails
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...
Create PDF file using PHP+mysql info
Hi: Using PHP 4 need to create a PDF file with the info taken from a mysql database, how ever this is not the problem, I need to display an image from the database this is the hard part, s...
to_date() from MSsql not working in mysql
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...
Keys in Mysql (PRI and MUL)
Hi guys Im hoping you can help me understand what the MUL key actually means for a field in a MySQL table. Field                   Type                        Key -------------------------...
clear screen in mysql command prompt
hi experts, is there anyway to clear the screen in mysql command line prompt. Like CLS in windows command prompt I am using version 5. thanx in advance kiranvj
Count Columns in table
Is their a way to count the columns in a table?
MySQL Query - Change all UPPER CASE to Upper Case (first letter only)
I have some Data in a MySQL table that needs to have the letter casing changed.  I imported some product data into a shopping cart but the original data was messy and the product titles were a...
Query to transpose data in rows into column.
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...
How to change lower_case_table_names to 1
I found solution for my case sensitivity problem: i need to set lower_case_table_names=1 so MYSQL on my remote server(linux) is not case senisitive. But how to actually change this value?
Writing an insert/update stored procedure
I have a table called Product with the following fields product_id, name, description, company, country where product_id is an automatically generated ID. I have a stored proc to insert ...
CHANGE NULL TO ZERO WHEN SUM IN SQL  ( MYsql)
The code below when  , SUM(`sellnote`.Paid) then `sellhead`.RcvAmt + SUM(`sellnote`.Paid) As total  become null How can I change the code SUM(`sellnote`.Paid) if it is null it choose be come...
Datepart in mySQL
Is it possible to get only the datepart from date using mySQL? ie., if I have a date '2003-10-03', is it possible to extract only '03' which is the date part?
Wrong permissions on configuration file, should not be world writable!
Hello Experts, when I open http://192.168.0.2/phppgadmin/ I got this message "Wrong permissions on configuration file, should not be world writable!" on my FF 2 I do not know what I had ...
copy a table from one db to another
Dear All, Can I ask the most proper way to copy a table (table structure + data) from one database to another? Thanks
MySql/PHP Select records modified in last 30 days
Hi! I need to retrieve records that have been modified in the past 30 days and the past 7 days. I've tried using $query = "SELECT * FROM dd_productinfo ORDER BY code DESC where DATE_SUB(D...
Could not start the service MySQL
When I try to install MySQL server (no matter if 5.0 or 5.1) I get the error: "Could not start the service MySQL" I have earlier had 5.0.45 on the machine, and I just wanted to upgrade i...
MySQL: need a SQL query to replace NULL with "" (empty string)
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...
How do I use visio to export a MySQL model?
I am trying to get VISIO to export a database model, but I can't get it to export the correct things. I made the connection through the DSN just fine. When I use the export to database wiza...