> I think I really misunderstood the directions for alter table, an I'm
> not sure how to fix this. I was trying to allow certain columns to be
> null in an existing table.
> I used the following syntax:
> ALTER TABLE users ALTER COLUMN title SET DEFAULT NULL;
> Now 'describe users;' shows ex
Dear Friends,
I need to do the timezone settings so that now() gives the system
time.Actually first i have installed mysql on a different timezone han
changed the system time zone but perhaps mysql shows the previous time zone
or the default time zone only.
Pl. tell me how to change that .
I shall
I think I really misunderstood the directions for alter table, an I'm
not sure how to fix this. I was trying to allow certain columns to be
null in an existing table.
I used the following syntax:
ALTER TABLE users ALTER COLUMN title SET DEFAULT NULL;
Now 'describe users;' shows extra columns wit
Ian,
I'ld like to help you, but a more specific db design would depend on
more
specific description on your application needs.
What I can say is that you need to adapt your database to your reality.
What I got til now is that you need a product table, where you can
sto
Thanks Ed. That's another good idea. The consensus I'm getting is to
create one table that stores unchanging data about the product and another
that stores transaction details. The
problem I'm still having is how to efficiently handle more than one
changing value.
As an example, let's say I
I have a new installation of MySQL 5.0 (I did not port an old ver). I am
running a Ruby on Rails application that uses this db. I have grants for
[EMAIL PROTECTED], root@"localhost" and root@'192.168.0.63'. The passwords for these 3
grants are old style 16 byte hashes. There was one single g
01182006 1627 GMT-6
Im on Ubuntu. I have mysql 4.0.24. I have phpmyadmin installed.
Im a little frustrated at this point so bear with me.
Mysql is running.
My book says type in: mysql -h localhost testto see if the install
is working. That provides me with Access denied.
I then tried: mys
I built my inventory system like this,
I have a products table that contains all the information specific to each
part, less the quantity, i.e. Part Number, Description, Vendor, Color, Weight,
SKU number, etc...
Then I have another table that is my Inventory Tranactions Log that is just the
- Original Message -
From: <[EMAIL PROTECTED]>
To: "Rhino" <[EMAIL PROTECTED]>
Cc: "Imran" <[EMAIL PROTECTED]>;
Sent: Wednesday, January 18, 2006 5:07 PM
Subject: Re: Help in joining three tables
"Rhino" <[EMAIL PROTECTED]> wrote on 01/18/2006 03:30:44 PM:
- Original Message
"Rhino" <[EMAIL PROTECTED]> wrote on 01/18/2006 03:30:44 PM:
>
> - Original Message -
> From: "Imran" <[EMAIL PROTECTED]>
> To:
> Sent: Wednesday, January 18, 2006 3:13 PM
> Subject: Help in joining three tables
>
>
> > Hello All:
> >
> > I need to join three tables but I am not sure
Dan,
>I tried using prepared statements to make a procedure that
>converts every table in a schema from ARCHIVE to MyISAM...
"The following SQL statements can be used in prepared statements: CREATE TABLE, DELETE,
DO, INSERT, REPLACE, SELECT, SET, UPDATE, and
most SHOW statements. Other statem
Actually please ignore my previous question. I just had a brain cramp.
Thanks
>>> "Ed Reed" <[EMAIL PROTECTED]> 1/18/06 11:34:11 AM >>>
Can you (or anyone else) explain to me how, or point me somewhere that I can
learn how this works? I'd really like to know more about how bitwise arithmetic
Hello,
I have a simple Records table with two columns, member_id and question_id.
The object of the query is to retrieve the question_id, as well as how many
times it's been answered - as long as the current user hasn't answered it
(member_id). So, the query shouldn't return any question_id
- Original Message -
From: "Imran" <[EMAIL PROTECTED]>
To:
Sent: Wednesday, January 18, 2006 3:13 PM
Subject: Help in joining three tables
Hello All:
I need to join three tables but I am not sure how to structure the query.
I need to join table1 to table2 and then join table3 to th
Please do not hijack someone elses thread.
]Imran wrote:
Hello All:
I need to join three tables but I am not sure how to structure the query.
I need to join table1 to table2 and then join table3 to this result set.
So like (table1 join table2) join table3.
Table1 and Table2 will be joined o
"Imran" <[EMAIL PROTECTED]> wrote on 01/18/2006 03:13:08 PM:
> Hello All:
>
> I need to join three tables but I am not sure how to structure the
query.
> I need to join table1 to table2 and then join table3 to this result set.
>
> So like (table1 join table2) join table3.
>
> Table1 and Table
Hello All:
I need to join three tables but I am not sure how to structure the query.
I need to join table1 to table2 and then join table3 to this result set.
So like (table1 join table2) join table3.
Table1 and Table2 will be joined on ProdNo,CustNo and Branch. Table3 will be
joined to the resu
At 06:27 PM 1/18/2006 +, Marco Neves wrote:
Hi,
Why don't you create two table:
* a product table, with the product discriptions, and other
product related
info (call it prod):
|ID|NAME|SOME|OTHER|FIELDS|
|1|ProdA|..|..|..|
|2|ProdB|..|..|..|
Assume the following table:
CREATE TABLE test (
id MEDIUMINT UNSIGNED NOT NULL AUTO_INCREMENT,
parent MEDIUMINT UNSIGNED NOT NULL DEFAULT 0,
name VARCHAR(60) NOT NULL,
PRIMARY KEY (id)
);
INSERT INTO test (name) VALUES ('root');
SELECT @root_id:=id FROM test WHERE name = 'roo
Oh, I thought I had rolled all the changes back, I guess I missed that
line before posting. I had tried to see if it was because the tables
were ARCHIVE tables to being with, so I tried in another DB to convert a
bunch of tables the other way and got the same error. Either way, I'm
getting an
Can you (or anyone else) explain to me how, or point me somewhere that I can
learn how this works? I'd really like to know more about how bitwise arithmetic
works.
Thanks
>>> Francesco Riosa <[EMAIL PROTECTED]> 1/10/06 4:58:47 PM >>>
Francesco Riosa wrote:
> And another one is (in inverse orde
"Burke, Dan" <[EMAIL PROTECTED]> wrote on 01/18/2006 02:05:24 PM:
>
> I tried using prepared statements to make a procedure that converts
> every table in a schema from ARCHIVE to MyISAM (there's about three
> dozen archive tables here). But for some odd reason it will give an
> error after doin
I tried using prepared statements to make a procedure that converts
every table in a schema from ARCHIVE to MyISAM (there's about three
dozen archive tables here). But for some odd reason it will give an
error after doing the first table, and abort. The really odd thing is
that the table it give
mysql> insert into ccard values(AES_ENCRYPT(123453535,'uiwuerw'),'10/2003');
Query OK, 1 row affected (0.00 sec)
mysql> select * from ccard
-> ;
+--+-+
| crypt| expire |
+--+-+
| )\u\u\u\u\u\u\u | 10/
Ian Klassen <[EMAIL PROTECTED]> wrote on 01/18/2006 01:09:55 PM:
> Hi all,
>
> I'm trying to figure out a solution to the following problem.
>
> Let's say I have a store with various products. I take inventory of
these
> products on different days. At any given time I want to view what the
Hi,
Why don't you create two table:
* a product table, with the product discriptions, and other product
related
info (call it prod):
|ID|NAME|SOME|OTHER|FIELDS|
|1|ProdA|..|..|..|
|2|ProdB|..|..|..|
* a stock movements table, with moviments by p
Hi all,
I'm trying to figure out a solution to the following problem.
Let's say I have a store with various products. I take inventory of these
products on different days. At any given time I want to view what the
inventory is for the entire store. I also want to know whether the
inventory
If you are writing something that does INSERT, UPDATE, or DELETE, you need
to use the MODIFIES SQL DATA option.
Rhino
- Original Message -
From: "wangxu" <[EMAIL PROTECTED]>
To: "Rhino" <[EMAIL PROTECTED]>;
Sent: Wednesday, January 18, 2006 3:05 AM
Subject: Re: question about "CONTAI
Gleb Paharenko <[EMAIL PROTECTED]> wrote on 01/18/2006 11:02:15
AM:
> Hello.
>
> > MyISAM table of about 1.8 GB it stops restoring with no error output.
>
> It looks strange. Get the debug binary of mysql command line tool
> and create a trace file to find out the place where if fails. See:
>
Hi,
I am trying to update a field so that it retains its contents plus the
contents of another column like this:
UPDATE MyTable SET Comments = CONCAT(Comments, 'Old_ID_Field = ',
Old_ID_Field) WHERE Table_ID = 1;
However I just get a blank Comments field, any ideas why this is happening?
Than
On Tuesday 17 January 2006 14:37, Gleb Paharenko wrote:
> This is a bug:
> http://bugs.mysql.com/bug.php?id=15965
>
> Have a look here as well:
> http://bugs.mysql.com/bug.php?id=15151
>
> Most probable you will have to install the latest development source,
> which has this bug fixed:
> htt
"Shaun" <[EMAIL PROTECTED]> wrote on 01/18/2006 10:57:49 AM:
> Hi,
>
> I am trying to update a field so that it retains its contents plus the
> contents of another column like this:
>
> UPDATE MyTable SET Comments = CONCAT(Comments, 'Old_ID_Field = ',
> Old_ID_Field) WHERE Table_ID = 1;
>
> H
Hello.
> ALTER TABLE `filos`.`settings` MODIFY COLUMN `IntVal` INTEGER
>CHARACTER SET latin1 COLLATE latin1_general_ci;
This seems like a bug. MySQL Administrator should not assign character
set to integer columns. See:
http://dev.mysql.com/doc/refman/5.0/en/bug-reports.html
Kerry Frater wrot
Hello.
> MyISAM table of about 1.8 GB it stops restoring with no error output.
It looks strange. Get the debug binary of mysql command line tool
and create a trace file to find out the place where if fails. See:
http://dev.mysql.com/doc/refman/5.0/en/debugging-client.html
Jose Maria de Dios w
Hello.
Start solving the locking issues with reading this part of the manual:
http://dev.mysql.com/doc/refman/5.0/en/locking-issues.html
Xor wrote:
> Hi,
>
> Recently i think sqlrelay is a solution for me, but now i don't know. I
> try to explain what I would like to do. I have written a sof
Hello.
You should not use a cross database syntax for you queries. Instead of
'DROP TABLE `livedb`.`test_replication`'
use
use livedb;
DROP TABLE test_replication
Ian wrote:
> Hi List,
>
> I have been asked to setup replication between two customers servers for one
> p
Hello.
My advice doesn't solve your issue, but if you had a 5.0, you would have
been able to use INFORMATION_SCHEMA to retrieve the table names and
assign them to variables. Then using prepared statements and variables
you can dynamically drop a table. And at the end, you can put all this
stuff in
Hi everyone,
Could you let me know if there is a way to enable CSV storage engine
after MySQL was built.
Below is my current configuration and output of "show engines"
mysql> show engines;
++-+
+
| Engine |
Hello.
Perhaps this can resolve some queries:
http://lists.mysql.com/mysql/177314
John Lauck wrote:
> I'm using SET time_zone = 'US/Hawaii' to convert timezones and it's not
> working.
>
> What am I doing wrong?
>
> I have verified that the session.time_zone var is set correctly.
>
>
> if(
Hello.
Some information you can find here:
http://dev.mysql.com/doc/refman/5.0/en/innodb-parameters.html
http://dev.mysql.com/doc/refman/5.0/en/innodb-checkpoints.html
Have a look to innobase/log/log0log.c file in MySQL source distribution.
wangxu wrote:
> There are many information about di
Is there a way i can convert the strings converted from old password to
passwords one.So that it become compatible to the passwords one.
--
Abhishek jain
Original Message:
-
From: Ryan Stille [EMAIL PROTECTED]
Date: Wed, 18 Jan 2006 08:03:14 -0600
To: [EMAIL PROTECTED]
Subject: RE:
Hello.
My fault - it is a typo, instead of dealer_type_name, I should have
written PRIMARY KEY (`dealer_type_id`,`dealer_type_id`). I don't know
how it was possible to import this table to the same version, but it is
not a right syntax. Change it to PRIMARY KEY (`dealer_type_id`).
cybermalandr
Dear Friends,
I had an application built using MySQL where i stored mine customers
passwords encrypted using password function of mysql, now i changed mine
servers and do find a new function old_password and password. I believe
that old_password is equivalent to password.
Actually i do not want to
Hi!
Daniel Kasak wrote:
[EMAIL PROTECTED] wrote:
Views differ from tables in that they cannot be indexed.
I've just started experimenting with derived tables under 4.1.14, and I
had a hunch this was so. Is there any plan to include index support for
views / derived tables?
An index is a s
Sorry I should have said. I get error 1064 whenever I am working with an
integer or real column. char's are fine.
Kerry
Can someone help me.
I was running v4.1 and just upgraded the version to v5.0.
Most of my tables are MyISAM with some InnoDb. Most of the My
There are many information about different logs in manual but innodb log file.
Please tell me where can i find it?
What's innodb log file different to binlog?
Where can i find data about redo and undo?
thanks
But what is INSERT OR UPDATE need?
> - Original Message -
> From: "Rhino" <[EMAIL PROTECTED]>
> To: "wangxu" <[EMAIL PROTECTED]>;
> Sent: Tuesday, January 17, 2006 9:49 PM
> Re: question about "CONTAINS SQL"
>
>
> > - Original Message -
> > From: "wangxu" <[EMAIL PROTECT
47 matches
Mail list logo
