I want to split a datafile to two datafiles.How can i do?
From MySQL 5.0.18 manual
==
When accessing the auto-increment counter, InnoDB uses a special table
level AUTO-INC lock that it keeps to the end of the current SQL
statement, not to the end of the transaction. The special lock release
strategy was introduced to improve concurren
Dear Reynier,
You can use JOIN on your both,
The JOIN have to run on the same feilds i.e IDA.
SELECT * FROM carro_de_compras LEFT JOIN os_articulo ON carro_de_compras.IDA
= os_articulo.IDA
This query returns all your users with their articles if any and you can
iterate on it.
but one note:
Use
Hi:
I'm develop a simple shopping cart. I have this two tables:
carro_de_compras
--
IDU int(11) NOT NULL
IDA int(11) NOT NULL
CantidadDeArticulos int(11) NOT NULL
os_articulo
--
IDA int(11) NOT NULL auto_increment,
IDC int(11) NOT NULL default '0',
ANombre varchar(200) NOT NULL def
In the last episode (Feb 06), David T. Ashley said:
> I remember in MySQL that you can define an integer table field as
> AUTOINCREMENT and UNIQUE (I might have the specific keywords wrong,
> but everyone will know what I mean).
>
> In the life of a database where there are frequent additions and
I remember in MySQL that you can define an integer table field as
AUTOINCREMENT and UNIQUE (I might have the specific keywords wrong, but
everyone will know what I mean).
In the life of a database where there are frequent additions and
deletions, 2^32 isn't that large of a number.
When the intege
I am finishing up on performing an Oraclectomy on a bunch of legacy java
code (don't ask why the DBA got stuck w/this - sore subject) and have one
outstanding problem to solve:
Oracle has a function, initcap(), which capitalizes the 1st character of
each word and lowercases the rest. for example,
I just managed to get two identical test-servers running, both being
slaves of my production system replicating a few databases including two
of the heavy-use tables.
One server uses heap-tables, on the other one i changed the table-format
to innodb.
I've had some problems with the replication
You might get a time out with phpMyAdmin
The many web hosts I have used pretty much have all used php's default
90 second exection time for php pages.
I have a zip code database with 50,000 records and had to do this import
through a ssh session
On the web server using mysqldump on the old server
Brian Dunning wrote:
I have a bunch of databases - some are really big, 2GB - on a number of
different accounts at PowWeb. I am buying a Rackspace server and want to
move everything over -- hopefully all in one night. Can anyone suggest
the best way to do this? Would it be to use the Export com
I have a bunch of databases - some are really big, 2GB - on a number
of different accounts at PowWeb. I am buying a Rackspace server and
want to move everything over -- hopefully all in one night. Can
anyone suggest the best way to do this? Would it be to use the Export
command in phpMyAdmi
Can you show us the results of
SHOW CREATE TABLE tbl_nada;
preferably for the system as it was before, if you have backups from
then, and for how it is now. I would guess that your table type
changed, or perhaps indexing did.
What do you mean by "crashes"? What's the error message from the app
What table types? The filesystem doesn't have this info for innodb or
memory tables (tablespaces, sure...)
-Sheeri
On 2/3/06, Andrew Braithwaite <[EMAIL PROTECTED]> wrote:
> Hi everyone,
>
> Does anyone know if there is a way to get the last access time from a
> mysql table through mysql command
I can confirm that using a large buffer pool, putting all the hot data
in there, and setting the logfiles large, etc. works in the real world
-- that's what we do, and all our important data resides in memory.
The wonder of transactions, foreign keys, etc., with the speed of
memory tables.
-Sheer
Chuck,
Check this out - it's a real **simple** JSP that just does a query and
dumps out the results to the
web browser.
http://www.thebook-demo.com/java-server/jsp/Mysql/MysqlExample.jsp
Its been a while since I have worked with JSP - I wrote this example
several years ago (the web site
belongs
Hello.
I'm not sure, but have a look here:
http://dev.mysql.com/tech-resources/articles/dba-dashboard.html
Chuck Craig wrote:
> Hi, I'm new to the list and not sure whether my question belongs here or
> not. I'm looking for an open source program, that runs on JSP, to
> generate reports on d
Hi,
> I was running a legacy app on a MySQL 4.0.20 server.
> The app queried the server like this "SELECT count(total) as total from
> tbl_nada"
>
> For 4.0.20 the result of this query was an integer.
>
> Running the same query on 4.1.16 returns a much larger Integer and the
> app crashes.
>
> Pro
17 matches
Mail list logo
