On Tue, Dec 16, 2003 at 12:01:55PM +0700, David Garamond wrote:
> Sven K?hler wrote:
> >I was very disappointed by Interbase/Firebird. It seemed to me like a
> >MS-Access: a database-engine that works on regular files
>
> Firebird seems simple, but it doesn't mean it's inferior or
> [intentional
try this:
grant ALL on abc.* to 'abc'@'localhost' identified by 'abc';
>I have created database 'abc' .
>mysql> grant ALL on abc.table to 'abc' identified by 'abc';
>Query OK, 0 rows affected (0.00 sec)
-Original Message-
From: ads mysql [mailto:[EMAIL PROTECTED]
Sent: Monday, Decemb
O K.
I accessed to mysql as root user and tried to created user 'abc' as folows :
[EMAIL PROTECTED] mysql]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 61 to server version: 4.0.16-standard
Type 'help;' or '\h' for help.
right now, u r trying to connect t omyql with uer abc, not creating it.
to create user abc
grant on dbname.tablename to 'abc' identified by 'abc';
you can view the list of privileges available on myql website at
http://www.mysql.com/doc/en/GRANT.html
Enjoy
Nitin
- Original Message -
Hi,
I have installed mysql. As per documentation with user as 'root'.
I can create Database, table. I can enter data into table.
I have created user 'abc' with passowrd 'abc' on my Linux 8.0 server.
by using command :
adduser abc -p 'abc'
Now I want to create mysql database user 'abc' with comm
At 04:22 AM 12/15/2003, you wrote:
To elaborate on Dr Frank's thing if you're interested, here's a classic
deadlock example:
1. Transaction A obtains an exclusive lock on a set of rows which we will
call R1.
2. Transaction B obtains an exclusive lock on another set of rows which we
will call R2
Sven Köhler wrote:
I was very disappointed by Interbase/Firebird. It seemed to me like a
MS-Access: a database-engine that works on regular files
Firebird seems simple, but it doesn't mean it's inferior or
[intentionally] crippled like MS-Access. SQL server also works on
"regular files" (db is s
I tried the below. asked show master status on SERVER2 and I see the two db's I asked
to replicate on that server but no indication that the logging is happening from the
replication of DB1 from SERVER1
( I missed below showing replicate-do-db=DB1 in the SERVER2 my.cnf, and the
binlog-do-db's i
> I have only recently started these evaluations. BTW, my own background is
> from the Oracle DBA world.
>
> MySQL is certainly popular and seems to have very good performance, but I am
> concerned that the lack of Triggers, Stored Procedures, User-Defined
> Functions, and Views (to a lesser deg
I have scoured the archives and reconfigured my.ini with:
Set-variable = local-infile=1
I have tried it on the command line tooand still I get the dreaded
"command not valid for this version of MySQL" error.
I am using:
WinXP Pro/IIS
MyODBC driver 3.51
MySQL 3.23.58 - I cant go to 4 but the p
I don't really know exactly what happened. As luck would have it, I had
a username with all privileges that WOULD connect. Using that, in
combination with shutting down and restarting MySQL, I reorganized the
user database and now things work. Thanks.
Bob Cohen
b.p.e.Creative
http://www.bpecrea
Its not my data. I'm simply writting a program that reads in the meta data,
and does stuff with it client side. I just need to be able to handle all
sorts of stuff, and I wanted to test it on MySQL (amongst others).
Mof.
On Tue, 16 Dec 2003 11:49 am, Chris Nolan wrote:
> Hi,
>
> Have you consid
Still doesn't work But thanks for trying.
Mof.
On Tue, 16 Dec 2003 11:40 am, Aftab Jahan Subedar wrote:
> If you have foreign key then add a key for each,
> so the
>
> > CREATE TABLE foo (
> >ID INT PRIMARY KEY,
> >note VARCHAR(50),
> >Fname VARCHAR(50),
> >Lname VARCHAR(
I agree with all your points. Indexes are very useful, even necessary in
some situations. On the other hand, they also use up diskspace, and can slow
INSERTs and UPDATEs. If you have a very small database, you may simply not
need them.
Joshua Thomas
Network Operations Engineer
PowerOne Media, Inc.
Hi,
Have you considered just normalising the schema a bit more? It looks
like you're attempting to duplicate data within the
table (which you don't strictly need) and duplicating Fname and Lname
between Blah and foo. Why not just have an
AUTO_INCREMENT column (or some other unique row identifier
On Tue, Dec 16, 2003 at 01:11:21AM +1100, Chris Nolan wrote:
>
> To backup those funky sleek MyISAM tables, you could just issue a
> LOCK TABLE statement or two (LOCK DATABASE?), do a FLUSH and copy
> the files. If I recall correctly, (and I'm sure sirs DuBois and
> Zawodny will find out where I
If you have foreign key then add a key for each,
so the
> CREATE TABLE foo (
>ID INT PRIMARY KEY,
>note VARCHAR(50),
>Fname VARCHAR(50),
>Lname VARCHAR(50),
>FOO_ID INT,
>INDEX(FOO_ID),
KEY(Fname,Lname), #here this one--if it does not work,its not me
>FOREIGN KEY (
On Sun, Dec 14, 2003 at 10:50:43PM +0100, Rodrigo Moya wrote:
> Hi
>
> We have been supporting MySQL in the GNOME-DB project
> (http://www.gnome-db.org) since the beginning almost (1998). GNOME-DB
> provides several liraries, and one of those is a plugin-based generic
> data access library (libgda
It's funny you should mention that thread, as it's what peaked my curiosity.
Everyone on the SQLBase forums reckons that NetWare has this limit. The
reason I'm asking for
clarification is that the post in the "InnoDB in Production" thread did
not mention how the InnoDB
table space was split up (
On Tue, Dec 16, 2003 at 11:12:43AM +1100, Chris Nolan wrote:
> Hi all!
>
> I was wondering if anyone on the list currently runs MySQL on Novell
> NetWare. Any comments about performance relative to MySQL
> on similar hardware running a different OS?
See the "InnoDB in Production" thread from las
Can anyone tell me what the current support for the UTF8 character set is?
How strong is it? Do I have to do anything special to save the characters?
I will be getting the characters from a webpage form and inserting the
characters with PHP.
--
MySQL General Mailing List
For list archives: htt
Hi all!
I was wondering if anyone on the list currently runs MySQL on Novell
NetWare. Any comments about performance relative to MySQL
on similar hardware running a different OS?
Additionally, I've been told (by someone of dubious authority) that
NetWare has (and has had for a long time) a 2 GB
Even if your database fits entirely in memory, not having indexes in
place would not be a good idea.
In an interview Monty did regarding in-memory databases, he very
specifically made the point that where
your database is sitting will never remove the need for various types of
index.
From some
You may have to increase the size of the table cache, and you will most
probably need to do something about
ensuring that the mysqld process can open about 1 billion files at the
same time. There was a discussion along these
lines not so long ago focusing on having massive numbers of tables that
Curtis Maurand wrote:
Matthew Stanfield said:
Hi,
Usually, i'll use "enum('0','1')" in place of a boolean type.
Curtis
[snip]
For JDBC stuff, I've found that if you really want to call this a
shortcoming, then that's about as far as you can take it
- the MySQL JDBC driver makes the B
Hi,
Regarding backups, mysqlhotcopy locks all MyISAM tables named for backup
before copying the files. As a result, they are in a consistant state.
InnoDB and BDB tables need to be handled differently though, so you're
looking at 1 of 4 methods:
1. Shut the database down and copy the table spa
Okay, that sounds good and all, but how does that help me, since the date is
chosen
from the javascript "calander" in this format: mm/dd/
So then, when I'm selecting a date of at least todays value, or less in the
database
how would I do it, since it's in mm/dd/?
Thanks,
Richard
- O
In the last episode (Dec 15), Jeremy Zawodny said:
> On Mon, Dec 15, 2003 at 02:31:16PM -0800, Rob Brackett wrote:
> > How hard would it be to modify the MySQL code, and what sort of
> > performance hits would I take, if I was to try to run a hundred
> > thousand MySQL DBs on the same server? Obvi
On Mon, Dec 15, 2003 at 10:13:44AM -0500, Nicolas Ross wrote:
> Hi !
>
> Our db server has about 140+ db's for a total of about 1.5 gigs of data.
>
> Some while ago, for a specific DB, I did testing using transaction tables
> with bdb. This was a bad experience. I ran into some problems and I had
On Tue, Dec 16, 2003 at 01:55:49AM +1100, Chris Nolan wrote:
> Hi all,
>
> I was sitting here thinking to myself (which can be quite dangerous)
> and was wondering if anyone on the list actually uses dirty reads in
> their apps. If so, what advantages do you get from using this
> isolation level?
On Mon, 15 Dec 2003 09:22 pm, Victoria Reznichenko wrote:
> Mofeed Shahin <[EMAIL PROTECTED]> wrote:
> > On Mon, 15 Dec 2003 12:42 pm, Paul DuBois wrote:
> >> At 11:09 +1030 12/15/03, Mofeed Shahin wrote:
> >> >I'm trying to create a bunch of tables in MySQL. I'm having problems
> >> > creating the
On Mon, Dec 15, 2003 at 02:31:16PM -0800, Rob Brackett wrote:
> How hard would it be to modify the MySQL code, and what sort of
> performance hits would I take, if I was to try to run a hundred thousand
> MySQL DBs on the same server? Obviously, some tweaks would be necessary
> to be able to break
.
My apologies for taking so long to get back to you. The MasterMind in
charge of the project kept me too busy to experiment.
Now that I have, thank you! It went well, and all is now sweetness and light.
Yrs,
Iain.
fatblokeonbike wrote:
.
I'm seeing double with this, and I just KNOW it'
How hard would it be to modify the MySQL code, and what sort of
performance hits would I take, if I was to try to run a hundred thousand
MySQL DBs on the same server? Obviously, some tweaks would be necessary
to be able to break up the directory structure of /var/lib/mysql, and I
may be souding un
select last_insert_id();
or in php use the mysql_insert_id() eg:
$somevalue = mysql_insert_id();
print ("The last auto incremented number was: $somevalue\n");
Cheers
Curtis
Paul Fine said:
> Greetinsg.
>
> If I have a table like with a column being the PK for the table and
> being an Auto In
Matthew Stanfield said:
> Hi,
Usually, i'll use "enum('0','1')" in place of a boolean type.
Curtis
[snip]
> well. The only annoying thing I can think of, from a programming
> perspective, is MySQL's lack of a Boolean type - the manual says use
> TINYINT(1) which works fine but is slightly an
Thanks, Jon. I'll try that and report back.
-Original Message-
From: Jon Frisby [mailto:[EMAIL PROTECTED]
Sent: Monday, December 15, 2003 3:06 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: Zeos, MySQL problem
You can disable connection timeouts at the MySQ
Hi, I don't know much about the foreign key syntax, but I would think it
should reference a field in a different table. If I'm wrong, I'm sorry.
:-)
Bob
-Original Message-
From: Mofeed Shahin [mailto:[EMAIL PROTECTED]
Sent: Sunday, December 14, 2003 9:56 PM
To: Paul DuBois; [EMAIL PROTE
You can disable connection timeouts at the MySQL server level. You should
check the docs to be sure, but I think the relevant variable is
"wait_timeout" -- setting it to 0 should disable connection timeouts.
-JF
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
>
Hi,
is it possible to represent on MySQL a Matrix as data type into a table
creation?
Thanks,
Nivaldo
__
Yahoo! Mail: 6MB, anti-spam e antivírus gratuito! Crie sua conta agora:
http://mail.yahoo.com.br
--
MySQL General Mai
Good Afternoon!
We're building an application with Delphi 7.0, the Zeos controls and MySQL
v.4.0.15 which runs on a Red Hat 7.3 server. We are experiencing a problem
where when a person lets the application sit for a while, we're losing
dataset connectivity that doesn't restore itself. I've been
>
> If an INT has a fixed range, then what is the point of giving it scale? As
> in, "int(12)".
>
> In Oracle, a NUMBER(12) indicates how many digits you could have (in this
> case, 999 would be the max value).
>
> Would an int(2) allow -99 to 99, or -2147483648 to 2147483647?
That's bec
Hi, i have a problem with getting the right return values from field purrdato.
All records exept a few are set with date and the rest is NULL. The field allows Null
values. when using: DATE_FORMAT(purrdato, '%d.%m.%Y') AS purrdato ...it even
returns '00.00.' on null values.
Is there a wa
This may sound crazy, and maybe paul would kill me but try this :)
1.- backup your data base files, just for moment, while we recover the
users data base
2.- erase your data base file completly
3.- run mysql_install_db
4.- restore your data bases, only _YOUR_ data bases, do not restore
mysql inter
On Mon, Dec 15, 2003 at 01:42:30PM -0600, Paul Fine wrote:
> Thanks (to all who replied)
>
> If I lock the table however, if another user is trying to insert (via php
> page) another record they will get an error right and I will need to make a
> wait+retry script?
_if_ you lock the other thread
At 11:34 15/12/2003 -0800, Jim Gallagher wrote:
Hi,
Hello,
Last month I posted here a question (with no responses) about a problem I
am having with myisamchk ("myisamchk Error 22 WinServer 2003 Large
table"). My problem seems to be identical to that described here:
http://bugs.mysql.com/bug.ph
Thanks (to all who replied)
If I lock the table however, if another user is trying to insert (via php
page) another record they will get an error right and I will need to make a
wait+retry script?
Thanks!
-Original Message-
From: Tobias Asplund [mailto:[EMAIL PROTECTED]
Sent: Monday, De
Hello,
Last month I posted here a question (with no responses) about a problem I am having
with myisamchk ("myisamchk Error 22 WinServer 2003 Large table"). My problem seems to
be identical to that described here:
http://bugs.mysql.com/bug.php?id=779
However, that bug was for the 3.x version
I seem to be locked out. The trouble started when I deleted the "Any"
user while in phpMyAdmin. After doing that, I reloaded MySQL.
MySQL seems to load from the command line using the command mysqld_safe,
except the command prompt doesn't return unless I hit control Z. Once I
^Z myself back to
On Mon, 15 Dec 2003, Paul Fine wrote:
> If I have a table like with a column being the PK for the table and being an
> Auto Increment value, what is the best way to return this value to my
> script?
If you insert a row LAST_INSERT_ID() will return the primary key value in
this setup.
The other w
Hello,
> > Could one not store the total while using the
> index
> > and use "select FOUND_ROWS()" without
> > SQL_CALC_FOUND_ROWS to retrieve the total?
>
> Yes, it could.
> It is the optimization that wasn't implemented yet.
> (but it's in the TODO)
Once again, thanks for the response.
Could
Find out the real way: Use EXPLAIN and BENCHMARK() commands to get the speed
of your operations with and without an index. That's the only way to know
for certain.
Cheers,
Joshua Thomas
Network Operations Engineer
PowerOne Media, Inc.
tel: 518-687-6143
[EMAIL PROTECTED]
---
In theory there is n
Hi,
I've used both PostgreSQL and MySQL on a Linux server and found both
setting up (using RPM) and maintaining them very easy (MySQL was slightly
easier to set up but I set it up after I was already proficient on
PostgreSQL, so perhaps comparing the ease of setup is unfair). Both are
well doc
since you're using PHP, you can also get this via the php function
mysql_insert_id(). directly after your insert, i think another insert would
be nearly impossible to get int he middle of these two.
$insert = mysql_query("insert stuff into table");
$last_id = mysql_insert_id($res_link); (resourc
Oops, I didn't mean "datetime as index", but "like with datetime" is
broken in 4.1.1.
On Tue, 16 Dec 2003 03:12:20 +0900
Tatsuhiko Miyagawa <[EMAIL PROTECTED]> wrote:
> Seems like a bug in 4.1.1-alpha using datetime as index.
>
>
> mysql> create table foo (d datetime, index (d));
> Query OK, 0
> With such a small database it really boils down to just being tidy;
> you don't want indexes you're not going to use.
Well the database is going to be like 200MB and executing several
hundred queries a minute. Thus my concern about speed. Is a P4 w/ 1GB
RAM going to choke and die, or will inde
Hello, I'm currently testing out replication on a high volume innodb based
database. This has been working great for several weeks, but when I came in
this morning I found my slave had the following error:
031212 23:30:24 Slave: query 'UPDATE monitor_tunnel_cisco_phase_2 SET
counter=0, timest
Hi,
> I imagine there has to be a better way!
Yes :) Take a look at the LAST_INSERT_ID() function.
Take care,
Aleksandar
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Seems like a bug in 4.1.1-alpha using datetime as index.
mysql> create table foo (d datetime, index (d));
Query OK, 0 rows affected (0.01 sec)
mysql> insert into foo values ('2003-12-15 00:00:00');
Query OK, 1 row affected (0.01 sec)
mysql> select * from foo where d like '2003%';
Empty set (0.0
Greetinsg.
If I have a table like with a column being the PK for the table and being an
Auto Increment value, what is the best way to return this value to my
script? It is possible that additional rows may have been added during the
small wait.
Ie.
Col 1 Col 2 Col 3
A
On Mon, 15 Dec 2003, Roberts, Mark (Tulsa) wrote:
> I have an order taking system where the tables are store in a MySql database. I need
> to develop a select statement to output all new orders to a .csv formatted file.
>
> Is this possible to do in MySql. I would try looking this up, however, I
I have an order taking system where the tables are store in a MySql database. I need
to develop a select statement to output all new orders to a .csv formatted file.
Is this possible to do in MySql. I would try looking this up, however, I am not even
sure what to look for in the documentation.
I sent this out friday, but didn't see it come through to the list, so sorry if it
comes up twice if the original is lost in lala land at the moment.
-Original Message-
From: Luc Foisy
Sent: Friday, December 12, 2003 4:17 PM
To: MYSQL-List (E-mail)
Subject: Replication
The scenario we
Hi Chris,
> >>Firebird/Interbase have all those nice things like row-level locking
> >>(although it doesn't seem to have multiversioning like InnoDB,
> >>PostgreSQL or Oracle), deadlock detection, prepared statements, views,
> >>
> >>
> >
> >Yes it DOES have multi-versioning. Actually, I believe i
Hi,
> How are you doing backups???
Since it's replicated, I stop the slave and copy the entire database
directory.
Then, I restart the server and the slave will get all the queries from the
master...
Works very well!
Eduardo
- Original Message -
From: "Arnoldus Th.J. Koeleman" <[EMAI
Martijn Tonies wrote:
Firebird/Interbase have all those nice things like row-level locking
(although it doesn't seem to have multiversioning like InnoDB,
PostgreSQL or Oracle), deadlock detection, prepared statements, views,
Yes it DOES have multi-versioning. Actually, I believe it was the
fi
> Is innodb stable enough to use un mass production environement ?
Yes, it's.
We use it on a 24x7 system (replicated), with 20GB w/no issues. We're using
4.0.16 on NetWare6.5.
Eduardo
- Original Message -
From: "Nicolas Ross" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, De
InnoDB is extremely stable!
I have a single InnoDB database that's currently holding about 20GB
(with about 95% of that in a single table).
All of this database is contained inside a single InnoDB tablespace
file. In the last 12 months, the only command
I've thrown at it by hand was "ALTER TABL
Jeremy Zawodny wrote:
On Mon, Dec 15, 2003 at 02:12:01PM +1100, Chris Nolan wrote:
It seems slightly ambiguous - updates are redirected and stalled. The
fact that the two statements are in different sentences threw me off
slightly.
Oh, okay. If you can suggest a more clear version, perhap
> Firebird/Interbase have all those nice things like row-level locking
> (although it doesn't seem to have multiversioning like InnoDB,
> PostgreSQL or Oracle), deadlock detection, prepared statements, views,
Yes it DOES have multi-versioning. Actually, I believe it was the
first (InterBase that i
Hi !
Our db server has about 140+ db's for a total of about 1.5 gigs of data.
Some while ago, for a specific DB, I did testing using transaction tables
with bdb. This was a bad experience. I ran into some problems and I had to
convert back to myisam.
One thing I don't like about innobd and bdb i
Tobias Asplund wrote:
Sven Köhler wrote:
I set the isolation level to READ_REPEATABLE and use mysqldump |
bzip2 to get the result. I've tested the restore and it's fine!
So how does mysqldump handle binary data?
If it does embed the data into the SQL-statement somehow, that's crap,
On Mon, Dec 15, 2003 at 02:12:01PM +1100, Chris Nolan wrote:
> It seems slightly ambiguous - updates are redirected and stalled. The
> fact that the two statements are in different sentences threw me off
> slightly.
Oh, okay. If you can suggest a more clear version, perhaps Paul will
update the m
> Sven Köhler wrote:
>
> >> I set the isolation level to READ_REPEATABLE and use mysqldump |
> >> bzip2 to get the result. I've tested the restore and it's fine!
> >
> >
> > So how does mysqldump handle binary data?
> >
> > If it does embed the data into the SQL-statement somehow, that's crap,
> >
Hi all,
I was sitting here thinking to myself (which can be quite dangerous) and
was wondering if anyone on the list actually uses dirty reads in their
apps. If so,
what advantages do you get from using this isolation level? I can't
think of any myself (damned limited brain...)
Best regards,
That is brilliant thank you. I was doing it the wrong way
around when i was naming the fields.
Thank you for your help
graham
-Original Message-
From: Tobias Asplund [mailto:[EMAIL PROTECTED]
Sent: 15 December 2003 14:46
To: Graham Little
Cc: '[EMAIL PROTECTED]'
Subject: Re: LOAD DATA IN
Sven Köhler wrote:
I was very disappointed by Interbase/Firebird. It seemed to me like a
MS-Access: a database-engine that works on regular files
What gave you that idea? Firebird (and InterBase of course) use
a at least 1 file per database, but that's all. Can you define
"regular files"?
My i
On Mon, 15 Dec 2003, Graham Little wrote:
doing selective quoting below.
> LOAD DATA INFILE "D:\mysql\sql\CountryData.txt"
> INTO TABLE cou (id, country);
See how you try to load from a file into the columns id and country in the
cou table?
> The table the data is being inserted int
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Am Sonntag, 14. Dezember 2003 20:59 schrieb Jerry Apfelbaum:
> Hello.
>
> I have been tasked with evaluating open source databases for a large
> upcoming project: e-commerce, B2B, high availability.
So, you should choose SapDB 7.3 or 7.4 due Licens
on 15/12/03 12:13 pm, Graham Little at [EMAIL PROTECTED]
wrote:
>
> +--+-+--+-+-+---+
> | Field| Type| Null | Key | Default | Extra |
> +--+-+--+-+-+---+
> | cou_id | int(11) | | PRI | 0 | |
> | cou
Graham Little <[EMAIL PROTECTED]> wrote:
>
> I am currently trying to run the following command:
>
>LOAD DATA INFILE "D:\mysql\sql\CountryData.txt"
>INTO TABLE cou
>FIELDS TERMINATED BY ','
>LINES TERMINATED BY '\r\n'
>(id, country);
>
> Example data in f
On Mon, 15 Dec 2003, Peter Lovatt wrote:
> Try
>
> Insert INTO `table` ( `inc_field` ) values (10)
>
> the auto inc field will then generate the next sequential numbers
>
> HTH
>
> Peter
Or just use
ALTER TABLE table AUTO_INCREMENT=10
That way you don't have to enter a record jus
Hi Sven,
> >>I was very disappointed by Interbase/Firebird. It seemed to me like a
> >>MS-Access: a database-engine that works on regular files
> >
> > What gave you that idea? Firebird (and InterBase of course) use
> > a at least 1 file per database, but that's all. Can you define
> > "regular f
I noticed that too. Does anyone know the reason?
May the force be with you all!
nelson
>>> hotmail <[EMAIL PROTECTED]> 12/14/03 01:53pm >>>
Clear DayEvening,
No setup file is included in the ZIP mysql-4.1.1-alpha-win.zip
Do you know why ??
Cheers
Mark
Are they? Shoving in rows that are several meg in size didn't pose any
problems. The restore procedure looked like this:
bunzip2 dumpfile | mysql -u db_grunt -p projectdb
May I ask where the limitation you mentioned is documented? Maybe the
situations we were using it in didn't come close to th
I was very disappointed by Interbase/Firebird. It seemed to me like a
MS-Access: a database-engine that works on regular files
What gave you that idea? Firebird (and InterBase of course) use
a at least 1 file per database, but that's all. Can you define
"regular files"?
My idea of Firebird is the f
I set the isolation level to READ_REPEATABLE and use mysqldump | bzip2
to get the result. I've tested the restore and it's fine!
So how does mysqldump handle binary data?
If it does embed the data into the SQL-statement somehow, that's crap,
since SQL-Statements are limited in length.
--
MySQL
Hi Chris,
Thanks for your help, i will find another way around it.
Graham
-Original Message-
From: Chris Nolan [mailto:[EMAIL PROTECTED]
Sent: 15 December 2003 14:13
To: Graham Little
Cc: '[EMAIL PROTECTED]'
Subject: Re: SEQUENCES
Hi,
As far as I know, definitely not. However, you co
Try
Insert INTO `table` ( `inc_field` ) values (10)
the auto inc field will then generate the next sequential numbers
HTH
Peter
-Original Message-
From: Graham Little [mailto:[EMAIL PROTECTED]
Sent: 15 December 2003 14:01
To: '[EMAIL PROTECTED]'
Subject: SEQUENCES
I was won
I looked in the documentation but could not find any mention of
SEQUENCES. The AUTO_INCREMENT documentation seems to say that you
can change a server variable to adjust the incremented count, but
unless i can put an equation into their, i don't see how changing
that would help.
thanks
Graham
Hi,
As far as I know, definitely not. However, you could use an
AUTO_INCREMENT field as the independent variable
for some application-level function you use to generate the values in
the sequence.
Best regards,
Chris
Graham Little wrote:
I was wondering whether it was possible to make and AU
Huh? Not know how to backup a MySQL database? *sigh*
Every night, I do a backup of our MySQL database server that's holding
all of our mail and various other things (20GB+).
I set the isolation level to READ_REPEATABLE and use mysqldump | bzip2
to get the result. I've tested the restore and it'
Hi everyone,
I am currently trying to run the following command:
LOAD DATA INFILE "D:\mysql\sql\CountryData.txt"
INTO TABLE cou
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\r\n'
(id, country);
Example data in file is:
country, id
AFGHAN
Chris Nolan wrote:
Hi!
There are many ways, depending on whether you want the database to
handle it, or you want your application to handle it.
What you want is a UNIQUE index on surname_original and name_original.
Assuming the table already exists:
ALTER TABLE names ADD UNIQUE(name_original,
More information please ... what Operating System, where are the MySQL
binaries and data directories on your machine, did you create a my.ini, is
MySQL installed as a service
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, December 14, 2003 1:51 P
[snip]
I was wondering whether it was possible to make and AUTO_INCREMENT
field instead of always adding 1 and starting at zero, into a SEQUENCE
type field so that it is say a 10 digit integer and numbers are created
according to the SEQUENCE.
[/snip]
I was wondering if you had tried it in a tes
"Gordon" <[EMAIL PROTECTED]> wrote:
> We have 2 tables which are roughly half the size of the entire database
> { ~1.5GB}. These 2 tables are rarely changed {1-2 times a quarter}.
> Is there a way in mysqldump to exclude these two tables without
> specifically naming all of the tables { > 100} we
I was wondering whether it was possible to make and AUTO_INCREMENT
field instead of always adding 1 and starting at zero, into a SEQUENCE
type field so that it is say a 10 digit integer and numbers are created
according to the SEQUENCE.
thanks
Graham
Thanks for Joshua and Jay.
The querys is that I expect.
Best regards,
Pawel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi,
> > So far, it seems that MySQL, MaxDB, PostgreSQL, and Interbase/Firebird
are
> > possible candidates.
> >
> > Does anyone know why we should or should not use any of these? Does
anyone
> > know of other possibilities?
>
> I was very disappointed by Interbase/Firebird. It seemed to me like a
1 - 100 of 124 matches
Mail list logo