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...
I run a query which successfully selcts INTO OUTFILE.
But I would like to keep the mysql structure when this select is done, so the result should not be a text file, but the table,rows ......
I want to get the distinct set of rows based on the uniqueness of multiple columns
ex: I have a table last,first whose data is:
smith, john
smith, john
smith, fred
i want to run SQ ...
Hi,
Thanks for your help.
I am currently on an XP box with the following software specs:
Apache/2.2.9 (Win32) PHP/5.2.6 and mySQL 5.0.51a/phpMyAdmin 2.11.7.1
I've uninstalled Apache/PH...
I'm using this code to select people (EXEC) from a database which works fine. But I get php warnings in error_log:
PHP Warning: mysql_fetch_array(): supplied argument is not a valid MySQL ...
Hiya I have a table with a column called "joined", this is a DATE field and another table with DATETIME.
I will be doing a PHP switch to get each type, so I will do a different query for ea...
I have a table with fields
Datefield date
Timefield time
Notify int
I need to select all rows that have the date and time exactly Notify hours (ignoring minutes and seconds, ...
Hi
I got loads of mysql-bin.0000xx files in /usr/local/mysql/var is it safe to delete those files ?
Thanks
Hi I keep getting this message when I try to test mysql with the script below:
#1045 - Access denied for user 'root'@'localhost' (using password: YES)
And I don't know why.
I've only ...
I have a column that has comma separated data:
1,2,3
3,2,1
4,5,6
5,5,5
I'm trying to run a search that would query each value of the CSV string individually.
0<first<5 and 1<second<...
Hello All Experts!
I am building a database of ICONS, literally ICO files and would like to display them in a webpage using PHP, MySQL.
I have been able to upload, insert and retrieve / ...
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...
How can I get dump file from mysql schema and then use this dump file to migrate to a new schema
Thank you so much:)
Can you create a user and grant privileges using CREATE USER and GRANT in a stored procedure using variables from a web page? I have code in my stored procedure to insert into the USER and DB ...
I've been trying to configure MySql on CentOS 5.2 and I'm having trouble with it. When I try to execute the following I get an error:
Localhost # mysql -u root -p
ERROR 1045 (28000): A...
Hello,
I have created a Streets table: with int idStreet ; int idRegion ; String street name as columns.
I have a jsp page with 2 comboboxes that I would like filled with all the streets...
EE DBA Experts on MySQL:
I am a software developer and I have an application that I have written in VB.NET 2005 that uses MySQL version 5.0.45 in a Windows Development Environment that I am...
I'm trying to add a trigger to a database using phpmyadmin. However, I get the error:
Access denied; you need the SUPER privilege for this operation
How would I sort this out in phpmyadmin?
Hi,
I have a problem that i'm not able to drop a table. I did this a lot of times but this time it is throwing me this error as mentioned below and just not letting me to drop the table. Th...
I am using a shared hosting service. My application is ASP.NET and I am using MySQL DB V5.0.23-c-nt
I get the error "SELECT command denied to user 'user'@'ip' for table "municipio" when I t...
The following query works fine to populate my entire table with longitudes
UPDATE tblResellers AS R SET R.Longi=(SELECT zipdb.Longi FROM zipdb ORDER BY ABS(R.Zip-zipdb.Zipcode) LIMIT 1)
...
Table structure
products table:
product id
category id
product name
category table
category id
category_under (foreign key to category id that tells if a category is ...
Hello,
I want to copy a large amount of data from a specific table, and only certain colums within it to another database and table on the same server.
What is the sql syntax to do this?
...
I have a txt file that I import into a Mysql database. One of the fields is a date, but not formatted properly for Mysql. I import it in as a varchar, but eventually need is as a mysql date....
Is it possible to convert an Oracle 10g dump file into a MYSQL database?
