Hello,
I have made a couple of partisions in Linux. Somehow
MySQL got installed in a partision that doesn't have a
lot of space and i'm running very low. How do I add
more space to that directory or partision?
I have a lot of space on my user partision and my home
partition. Is there a command in
Hello,
I've been working on this for a long time now and I
cannot figure this out.
Can someone help me get this sql statement without
erroring or why it doens't work.
Here is the SQL statement...
SELECT DISTINCT ItemMaster.ParentNum,
ItemMaster.Desc1, ItemMaster.Price
FROM BillOfMat AS BillOfMat
Hi Folks,
I'm trying to create a counter for my website. I'm
trying to pull the last 7 days worth of data out of
mysql. My sql statement is as follows.
SELECT TheDate, Count(TheDate) AS CountOfdate
FROM Counter
WHERE (((TheDate)=Now()-7))
GROUP BY TheDate;
When I do this Sql Commmand it returns
Crazy its working this morning. Must of had some kind
of hickup, but I swear yesterday it was not working.
=)
Thanks.
--- Rolf Hopkins <[EMAIL PROTECTED]> wrote:
> In what way doesn't it work? Works fine for me.
>
> - Original Message -
> From: "Mike Mi
Hello,
When I submit data it will not submit data into the
database unless I put some kind of number in the ID
field. This is not supose to be. Here is what my
schema looks like.
CREATE TABLE Parts(
PartNumber INT(6) NOT NULL,
QtyOnHand INT(2) NOT NULL,
QtyOnOrder INT(2) NOT NULL,
DateNextQtyCo
Hello
I was wondering if inserting 307,284 is to much to put
into one table. Can MySQL handle this? Its a 70MEG
File. I have a 550 with 256MEG ram but it only shows
64. I don't know how to make it show 256 and running
redhat 6.1. The table has 12 colums and does not have
much data in each record
Hello,
When I try to drop a database as follows:
mysql> drop database test;
I get an error message of
ERROR 1010: Error dropping database (can't rmdir
'./test', errno: 39)
How do I fix this problem or even how do I delete the
database.
I'm using RedHat 6.2 and MySQL version: 3.22.32
and i'm lo
Hello list,
How would you go about selecting * from 2 tables?
I have 2 tables: table_1 and table_2
In table_1 I have the following data.
dog
bird
cat
In table_2 I have:
mouse
rat
hampster
How do I show both tables contents like:
+--+
|dog |
|bird |
|cat |
|mouse |
|ra
