Hi,
I am new to MySQL and Linux (BASH). I am attempting to run a SQL query from BASH. I often do similar things using Oracle and KShell, but am new to the MySQL/Linux/BASH environment.
...
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...
Hi,
This was all supposed to be so simple...
I downloaded MySql 5.1, installed it very late at night, must have typed my normal password in wrong and now cant get in, struggled a lot, ...
I have a TimeClock table that includes these two fields.
TrxDate 2007-11-02 00:00:00
ClockOut 1899-12-30 14:45:00
I want to take the DatePart of the the TrxDate field and replace ...
SELECT *
FROM `owners`
WHERE `dateregistered` >2007 -06 -01
I'm trying the following query on a date time field but dont get the results im after.
All i want is the records after the...
Does anyone here know how to configure phpMyAdmin to work on a Mac OS X? I have tried so many times with different versions and I keep getting the same error message:
#2002 - The server is...
I need to store HTML code in a MySQL table. The problem is that HTML tags contain double quotes. Normally, to ensure proper security protocols, we would escape all quotes. The problem there is...
Hi,
It seems I must have changed the 'root' user permissions on my databases...and now I can't access anything. I get the following error.
DBI connect failed : Access denied for user: '@l...
i want to compute the total $ for records (rows) in a table where
each row has a quantity and a (different) unit price.
thus if the table contains:
(qty) (unit price)
1 10
2 100
3 ...
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...
Hi all!
I installed MySQL on debian sarge every thing is ok when i use it localy. but when i try to connect to the server from a other machine in the lan (running sarge also ) A have the f...
Afternoon!
I have a table, mmproductcategory, that's a many to many relation table that's used to hold the product and category ID's of products for displaying in a product catalog. Essenti...
Is there some kind of workaround that would make it possible to achieve the equivalent of Oracle's DECODE function in a MySQL query? Or could it be done through some convoluted PHP code?
I'...
I am currently running Debian Sarge 3.1 and have installed MySQL-Server-5.0 deb package. I would like to uninstall the complete package so I run the following:
aptitude remove mysql-server...
Hi Experts,
I need to import some data in a MySql DB and I have problems importing decimal with a comma as separator.
E.G: if I need to import 1234,56 I will get 1234.00 in the db.
Any he...
Hello, I am very new to PHP and MySQL. I need to insert a date into a MySQL datafield of type date.
I would liek to be able to have the user input their date of birth in a form and insert ...
here is my INSERT Statement:
("INSERT INTO STUDENT (FNAME,LNAME,EMAILADDRESS,DATE) VALUES ('LName','FName','email@server.com','{0}')",DateTime.Now.ToShortDateString());
using ODBC, this...
I'd like to find the most efficient way to select the first row of a table, store the values of the columns, then delete the row.
Right now I am doing:
select * from err limit 1;
sto...
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...
Hi all,
What would be the best way to convert a unix timestamp column in a mysql db to a regular date and time?
im new to sql so any help, links would be great
Hi all experts.
I have operated mysql database on linux server for a while and the server seems damaged from power supply problem.(not sure exactly)
Nothing is quite working well. I am not a...
hi guys,
i have two tables in my MySQL database and I would like to merge them. They are almost similar in structure pero mas marami lang columns ung isa. Here the create table statement fo...
Hi, I am using two tables, lets call them biguser (90+ fields) and smalluser (10 fields). Smaller table is used to speed up search. I am trying to add a trigger that deletes record from smallu...
Hey Guys,
I would like to know how to structure and SQL query to query between months ranges
Something along the lines of:
SELECT * FROM table WHERE datetime BETWEEN xx/xx/xx AND xx/xx/...
Hi,
I'm stuck with a small problem. From the table below, i'm trying to get the difference in minutes from Now and the tstamp column where cusmid=1.
So the result ends up in minutes eg: 1...
