weird... about 1:! generalization and 1:m non identifying...
I think that these examples can make it better to understand some of
those terms... I am quoting from Database Systems -- Design,
Implementation Management fouth edition by Rob Coronel (page 23)
Conceptual Modules use three types of
I have a field telephone.
Set to type :int:
Length: 11
It's not working correctly, and not sure if it's my
application or something I have wrongly set up for the
database.
We are talking about U.S. Telephone numbers here, so 7
digits (area code, exchange, unique number)
Now it seems everything
One issue could be that an int column unsigned can only hold up to
4294967295 a ten digit number. Plus if you put it in a context of a
phone number... only area codes 428 or lower will have ALL THE
EXCHANGES and ALL THE UNIQUE NUMBERS in the range... with part of area
code 429
A bigint will hold
I guess that is why if I enter 703111
I get this back - 4294967295
Stuart
--- GH [EMAIL PROTECTED] wrote:
One issue could be that an int column unsigned can
only hold up to
4294967295 a ten digit number. Plus if you put it in
a context of a
phone number... only area codes 428 or lower
At 4:59 -0700 10/2/04, Stuart Felenstein wrote:
I have a field telephone.
Set to type :int:
Length: 11
It's not working correctly, and not sure if it's my
application or something I have wrongly set up for the
database.
We are talking about U.S. Telephone numbers here, so 7
digits (area code,
Hi
could it be that the - or a space is upsetting things?
111-111- might be calculated to give -
or if the user enters a space it is no longer an integer
unless you need it to be an integer, telephone numbers are usually stored
as a char type
HTH
Peter
-Original Message-
--- Paul DuBois [EMAIL PROTECTED] wrote:
Are you trying to store telephone number values with
the intermediate dashes? Such values are not
actually
numbers. You'll need to store them as strings, or
else remove the dashes.
Yes, they made all the difference.
Set the field type to varchar,
I have a field telephone.
Set to type :int:
Length: 11
You cannot store a phone-number in an int.
Use (var)char.
With regards,
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL MS SQL
Server.
Upscene Productions
http://www.upscene.com
--
MySQL General
Given the many 'standards' for formatting phone numbers, I would recommend
using a char or varchar. Regex is intended for string types.
Do yourself a favor run an alter table and change the column to a char or
varchar.
I hope this helps...
Pat...
[EMAIL PROTECTED]
CocoNet Corporation
SW
i'am not sure if this is related to suse 9.1 or what i'am beginning
with mysql and php
i'am running:
mysql 4.0.21-standard
suse9.1
kernel version 2.6.5-7.10b-default
php version 4.3.4 - default install
apache 2.0.49 - prefork
i created an address book using php and when i go thru and fill in
all
How do I use SQL to look for null values in ANY column?
SELECT * FROM QA WHERE * = null;
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
The problem is not a mysql problem, it's a php problem. It's probably
because you don't have register_globals = On. The new versions of php have
register_globals off by default. If you turn it on in the php.ini and
restart apache, I bet it will work.
Then again, I could just blame it on Novell
I think you would have to do one column at a time.
Like this.
Select * from QA where title is NULL;
Or you could get a little more crazy with something like this.
Select * from QA where (title is NULL) or (blabla is NULL) or (jimbob is
NULL) or (theskyisfall is NULL);
Donnny
-Original
Ok. Will do the crazy mode. Was thinking maybe there were a shortcut or
something, apparently not. Thanks though. Will have to list so many
columns.. *grin*
-Original Message-
From: Donny Simonton [SMTP:[EMAIL PROTECTED]
Sent: Saturday, October 02, 2004 11:31 AM
To: 'Scott
At 5:26 -0700 10/2/04, Stuart Felenstein wrote:
--- Paul DuBois [EMAIL PROTECTED] wrote:
Are you trying to store telephone number values with
the intermediate dashes? Such values are not
actually
numbers. You'll need to store them as strings, or
else remove the dashes.
Yes, they made all the
A 1:M (one to many) non-identifying means that the associated record in the
-one- table is not a parent of the associated record in the -many-
table, but
rather just related.
An example:
an identifying 1:M would be a building which has many rooms. The -one- table
carries data about the building
I am trying to convert from 3.23 to 4.0
This is what I am getting with or with root:
Script started on Sat Oct 2 16:11:30 2004
doctor.nl2k.ab.ca//usr/contrib/var$ man su
[25;1H[KSU(1)BSD Reference Manual
SU(1)
[1mNAME[0;10m
New error WITH password implemented:
Script started on Sat Oct 2 16:28:59 2004
command sent
This scripts updates the mysql.user, mysql.db, mysql.host and the
mysql.func tables to MySQL 3.22.14 and above.
This is needed if you want to use the new GRANT functions,
CREATE AGGREGATE FUNCTION or
Could this be a 'register_globals' issue? (Check your php.ini file.)
Are you sure that the queries you're sending are correct? Is
mysql_query() returning any errors?
Some more information, please!
Seth
On Fri, 1 Oct 2004 23:35:09 -0500, tom miller [EMAIL PROTECTED] wrote:
i'am not sure if
At 16:23 -0600 10/2/04, Dave Shariff Yadallee - System
Administrator a.k.a. The Root wrote:
I am trying to convert from 3.23 to 4.0
This is what I am getting with or with root:
Looks like you're confusing the Unix root user with the MySQL root user.
You don't need to use su to run
At 16:31 -0600 10/2/04, Dave Shariff Yadallee - System
Administrator a.k.a. The Root wrote:
New error WITH password implemented:
Apparently the ownership of the mysql database and/or the files in
it is not set such that the files are accessible to the Unix account
that you're using to run
21 matches
Mail list logo