I read from online manual :
=
KEY is normally a synonym for INDEX. From version 4.1, the key attribute
PRIMARY KEY
may also be specified as just KEY. This was implemented for compatibility
with other
I read from online manual :
=
KEY is normally a synonym for INDEX. From version 4.1, the key attribute
PRIMARY KEY
may also be specified as just KEY. This was implemented for compatibility
with other databases
read from online manual :
KEY is normally a synonym for INDEX. From version 4.1, the key attribute
PRIMARY KEY
may also be specified as just KEY. This was implemented for compatibility
with other databases
Hello,
Does the 2 Gig file size limit on Linux get broken when I have a hardware
raid controller?
My ISP says I don't need the raid option activated on MySQL.
Thanks,
Steve
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Jorge Calas [EMAIL PROTECTED] wrote:
Hello, I'm new to SQL and MySQL, I'm developing a web application (php) and I need
some tables relationed between them with a foreing key. The idea is the following
create table persons (
cid smallint auto_increment not null unique,
name
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Steve --
...and then Steve Vernon said...
%
% Hello,
Hi!
%
% Does the 2 Gig file size limit on Linux get broken when I have a hardware
% raid controller?
The limit applies only to ext2 filesystems, and not all of them at that;
ext3 and reiserfs
Hiya!
Thanks for the quick reply!!!
But dosen't it make more sense to have 20 0.5 Gig files rather than one 10
Gig file?
I know you can split files, but basically because we have raid I trust it to
a point. But I would like to make backup's. It costs a lot to have our
server provider to do
Hi
We have a similar challenge. Offsite backups with huge amounts of data,
without spending a fortune.
We have a local Linux box and the remote server both running rsync.
http://samba.anu.edu.au/rsync/
Rsync is brilliant because it only updates file sectors that have changed.
We would only use
Morten [EMAIL PROTECTED] wrote:
Hi, I would like some more extensive logging output, so
I can see what sessions begin etc. In other words, enable
general logging. I'm running RedHat 9 w. mysql-3.23.58
I've tried to add the log=[file] to my.cnf:
[mysqld]
datadir=/var/lib/mysql
* Yuen-Jeong Kim
I read from online manual :
=
KEY is normally a synonym for INDEX. From version 4.1, the key attribute
PRIMARY KEY may also be specified as just KEY. This was implemented for
compatibility with other databases
Hi,
I have 6 tables of type (clientcharacter, amountnumeric) and i want to join
them in a single table containing the client and all the amounts (A1, A2, ..., A6) - 6
rows. A client can be in a single table or in many but is distinct in a table.
T1 (C, A1)
T2 (C, A2)
T3 (C, A3)
T4
Hi,
I have 6 tables of type (clientcharacter, amountnumeric) and i want to join
them in a single table containing the client and all the amounts (A1, A2, ..., A6) - 6
rows. A client can be in a single table or in many but is distinct in a table.
T1 (C, A1)
T2 (C, A2)
T3 (C, A3)
T4
Hi,
I have 6 tables of type (clientcharacter, amountnumeric) and i want to join
them in a single table containing the client and all the amounts (A1, A2, ..., A6) - 6
rows. A client can be in a single table or in many but is distinct in a table.
T1 (C, A1)
T2 (C, A2)
T3 (C, A3)
T4
Unless your TEXT field has the exact same length in every record, it
doesn't really matter whether it changes or not. You have variable
length records. Thus, the database can't guess where the nth record
will start or end like it can with fixed length records. MySQL changes
the char to varchar
Don't confuse hardware RAID with MySQL RAID. The 2GB file size limit is
a function of the operating system and the file system in use, it has
nothing to do with the disk hardware you have installed.
Your ISP may say you don't need the raid option activated because the
system they are using
* [EMAIL PROTECTED] aka Catalin
I have 6 tables of type (clientcharacter, amountnumeric)
and i want to join them in a single table containing the client
and all the amounts (A1, A2, ..., A6) - 6 rows. A client can be
in a single table or in many but is distinct in a table.
T1 (C, A1)
Hi all
What command do I use to strip an sql table column of
everything
but numbers? Let's say I have values in my column
such
as NX-383_H and I only want the number portion 383
in
the column but want to discard the other junk? What
command do I use?
thanks
J
Hiya!
Thanks for the help!!!
Do RSync like big files? Or does it prefer smaller files? I see it supports
larger than 2 Gig files, but, Ive not seen any speed comparrisons etc. E.g.
one big file, or 10 small ones for example.
THANKS!
Steve
- Original Message -
From: Peter Lovatt
* Ciubotariu Catalin
Thanks but I have the tables. What I didn't know is how I can join them.
ok, but you got it now? The final step in my previous message was what you
needed?
A1 ... A6 mean different columns.
Yes, that was clear from your previous message. What was unclear was if they
We are running MySQL 4.0.14 on redhat 8.0.
The server and MySQL have been running fine for over 60 days.
Sometime yesterday afternoon the time reported in mysql using
mysql select now();
+-+
| now() |
+-+
| 2003-10-31 20:22:36 |
Hi
We are working with a lot of smaller databases, (The biggest is 600MB) so I
am not sure about single large files.
It works by checksumming parts of the file (not sure at what level), so if
only one of twenty sections has changed it will only update that section. So
if most of your 10GB is
Have you tried this setting in the my.cnf file?
[mysqld]
default-character-set=latin5
Good luck
Hi,
I am from turkey.I have used mysql for a longtime.I downloaded
mysql_win 4.0.16 and then setup,But I can't startup mysql with latin5
support.What can I do..?
How can I recompile mysql with
I'm getting the error:
When uploading a file in my PHP code to a mysql table.
From what I've read, this has to do with the max_allowed_packet variable in
mysql. How can I tell what that packet variable is set to?
Do I have to re-compile mysql to change it? Or is there a config file
(linux
Dear List,
Could sombody explain this behaviour of mySQL 4 to me:
Assigning a column as not null will AUTOMATICALLY assign (=force upon) it
a default value of an empty string ('') if a string or zero (0) if a
numerical datatype. Thereby effectively bypassing all and every error
message during
I think one of OS or MySQL uses GMT. Just check it out.
I have had a similar problem with a VoIP Router.
What is your time difference with GMT? Are you at GMT-12 or +12?
I am not an expert though
Thanks
Emery
- Original Message -
From: Gordon [EMAIL PROTECTED]
To: [EMAIL
On Fri, Oct 31, 2003 at 05:44:02AM -0500, David T-G wrote:
%
% Does the 2 Gig file size limit on Linux get broken when I have a hardware
% raid controller?
The limit applies only to ext2 filesystems, and not all of them at that;
ext3 and reiserfs (and others) can happily write much larger
* Ciubotariu Catalin
Your solution work only with a table of clients, I don't have one. I
have only 6 tables with clients and amounts and I need to join them.
Should I have to make a table with clients? It's realy necessary?
Please reply to the list, others may have similar problems. :)
Yes,
Could you include the error you receive?
You can check the current value of your max_allowed_packet using the
following command,
mysql show variables like 'max_allowed_packet';
max_allowed_packet determines the maximum packet length that the server
can send and receive.
You can set this value
Ever since upgrading I haven't been able to use the 'mysql' command--it just
hangs. Otherwise, the database seems to be working properly. I even tried
rebuilding from source but it didn't solve the problem. I've attached
ktrace/kdump output of the problem. I'm hoping someone can interpret this
I currently have systems on multiple networks that are only connected via FTP.
On one network (network 1) I have replication running with one master and one slave
(Both running Windows 2000 Server)
On another network (network 2) I have s Sun V880 running Solaris 8 and it is only
connected to
I am having trouble installing the RPM files for MYSql 4.1 on RH 9.0.
1. I believe I have the MYSQLD daemon running, however have no idea how
to talk to the server.
2. When I try to install the Client RPM for 4.1, the terminal window
hangs and nothing is printed to the window.
3. When I tried
What version of mysql are you using? I'm running 4.0.14 and I upgraded
without a problem.
On Friday, October 31, 2003, at 01:20 PM, Anderson, James H [IT] wrote:
Ever since upgrading I haven't been able to use the 'mysql'
command--it just
hangs. Otherwise, the database seems to be working
Hi Brent,
- Original Message -
From: Brent Baisley
Sent: Friday, October 31, 2003 7:39 AM
Subject: Re: Column Types Changing
Unless your TEXT field has the exact same length in every record, it
doesn't really matter whether it changes or not. You have variable
length records. Thus,
Hi,
I am trying to set up MySQL with openssl on linux 9.
first, I installed openss-0.9.7.b at default location
usr/local/ssl
second, I installed MySQL using source installation,
config --with-vio --with-openssl
then, I followed every step on manual 4.3.10.3 Setting
Up SSL Certificates for
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Steve --
...and then Steve Vernon said...
%
% Hiya!
Hi!
%
% Thanks for the quick reply!!!
Sure thing :-)
%
% But dosen't it make more sense to have 20 0.5 Gig files rather than one 10
% Gig file?
I wouldn't think so. The manual doesn't
Hopefully this isn't too far off-topic but I need some help with an
Access database that I need to convert to MSSQL. I need to ensure that
this db can accept reports and applications, and then have a secure
login for both internal and external users. Would this be the list to
post to or would
Jan,
This question comes up a lot. You should take a look at
http://www.mysql.com/doc/en/constraint_NOT_NULL.html. The first line
is, To be able to support easy handling of non-transactional tables,
all fields in MySQL have default values. Mysql automatically converts
missing or illegal
There are several good resources for MS SQL.
www.sqlmag.com
and
www.sqlservercentral.com
are the two that I like best.
For the logins, what OS are you using? For external users, you will
likely need SQL accounts, and if the internal accounts are using an MS
OS, you can use their Windows
38 matches
Mail list logo