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...
I know this should be fairly easy, but I just cant figure this out for the life of me and I dont want to waste anymore time on it. I have a file that I created using mysqldump --all-databases...
Hi, I am trying to run php and mysql locally on my home computer. I am using a simple install setup called Uniform Server 3.3 and I ran all the queries to setup my database (from my online sit...
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....
I am on Intel Macbook Pro running Leopard. I installed PHP and MySQL. I am now testing all installs with terminal.
-------->Attached Code Snippet here
I had previously confirmed that M...
I'm getting the following error:
ERROR 126 (HY000): Incorrect key file for table '/tmp/#sql_99d_1.MYI'; try to repair it
when running this SQL statement:
UPDATE `temp0_history` INNER JOIN...
Hi
I have recently installed MySQL 4.0 on my Debian Linux box and get the following error when i run:
root@xbox:/# /usr/local/mysql/bin/mysql start
ERROR 2002: Can't connect to local My...
I wanna do:
$today = date("Y-m-d H:i:s");
$result = mysql_query("SELECT sent_date FROM invitations WHERE email='$email' AND uid='$session_uid' AND '$today' - `sent_date` < 24 hours from ...
Dear Experts,
Operating System: Windows Vista
Web Server: Apache 2.2.6
Language: PHP 5.2.5
Database: MySQL 5.0
In an attempt to resolve an ongoing issue with Dreamweaver CS3, I made ...
I am using Excel vba form to connect to a mysql table. My form has several textboxes that can be updated. I am using the following UPDATE statment, but am getting a runtime error message abou...
I'm using VB.NET & MySQL and would like to insert a BLOB (small image) into the database.
I have the image already in a byte array but am a bit confused as to how i'm supposed to INSERT thi...
Hi,
I have two .xls documents that i want to import into a table in my mySQL database. What would be the quickest way to do this? I'm using phpMyAdmin 2.5.4
Thanks
Trevor
mysql 5.0.51b cummunity server
mysql connector .net 5.1.6
After the .aspx html form passes three fields to be inserted, sometimes the insert method works and other times it does not. I the...
Im trying to merge data from 4 different tables (2 really). I want to try to do this using MySQL so that I get a list of unique costcodes, with the various values in the next two columns. Here...
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:)
This is my newbie sob story: For TEN DAYSALL DAY LONG ON HALF OF THEMI have been wrestling with MySQL. It started while I was working through the tutorial in the book Dreamweaver w/ asp, col...
Dear EE members,
I am at a loss here so if anyone can help I would greatly appreciate it!
I have a MySQL server v4.1.21 out of my control (run by a hosting company).
CREATE TABLE `co...
I have 2 Windows 2003 servers each running PHP5 & MySQL5.
Server 1 [Platinum] handles a large amount of transactions on a daily basis so in order to help increase reporting speeds I have se...
Hi,
I've got this datetime column called days_stats in my MySql table called stats_tb
What I'm trying to do is: if the maximum date is not todays date then insert a row with todays date ...
Coulsd anyone help me out. I have installed mysql version 5. I equally installed the mysql control center and successfully connected to the data base. Then I created a new database called "mec...
I am trying to import this database into phpMyAdmin - 2.9.2 MySQL client version: 4.0.21
Server version: 5.0.22 - and I get this error-
#1064 - You have an error in your SQL syntax; check th...
In MySQL5, how can I construct a single query (not a union query) that will show the Lastname of the primary *and* secondary account rep assigned to each supplier, with these tables?
SUPPLI...
Due to a HD crash on a long-term hardware issue (RAM) on an old machine, some active MySQL tables crashed regularly. I've transfered these tables to another MySQL 5 install and have been chec...
I'm using Hibernate to handle my connection to my MySQL database. I found the following formula for finding distances from a point based on its latitude and longitude:
SELECT id, name,(((a...
I have two tables. MySQL version 4.1.22-standard - PHP 5.2.4.
I'm trying to get the data from the Review Table that do not have entries in the Comment Table.
Here's what I have..
...
