Steff,
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: "Heikki Tuuri" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Saturday, February 22, 2003 1:26 AM
Subject: Re: LOCK TABLES error , on a select without any update ?
Richard,
> didn't expect this much. All of my databases take like 200gb instead of
> the 100gb used b4.
> Is this normal? Is there anything I can do to mitigate this?
The storage requirement of InnoDB tables is about twice as much as for
MyISAM tables. I've been searching the manual as I think
Dear my friend
I don't want to be spoiled by PHPMyAdmin anymore.
I want to get be more expert in SQL Command of MySQL.
So far, everything is fine but today I realized a
problem. If I want to diplay the columns of an empty
table, the MySQL Client will diplay nothing such as :
"
mysql> select *
Solved, thank you my friend
--- Barry Radloff <[EMAIL PROTECTED]> wrote:
> use describe ;
>
> that chould work
>
>
> *--*
> |Barry Radloff |
> |Analyst/Programmer |
> |Dept: Development |
> *--*
> Media24 IT
> T: +27 021 406 3681
> F: +27 021 406 31
Thank you very much, my friend.
It is solved. Thanks..
--- Stefan Hinz <[EMAIL PROTECTED]> wrote:
> Prabu,
>
> >> Is it possible to define Foreign Key and Primary
> Key
> >> of my database after the tables have been created
> ?
> >> If yes, how?
>
> Yes. Use the ALTER TABLE command for this.
Thank you my friend.
--- Egor Egorov <[EMAIL PROTECTED]> wrote:
> On Wednesday 19 February 2003 13:58, Prabu Subroto
> wrote:
>
> > > I did something very stupid in my development. I
> > > created a database with a couple of tables...but
> I
> > > forgot to defining the foreign key and the
> prima
Hi
Using mysql v: 3.23.28
Having defined an index across x columns if I then query with say 3
words in my against argument will the query return any row that contains
all the words or any row that contains any of the words ?
As the version of mysql that my host uses is: 3.23.28 I do not have the
On Saturday 22 February 2003 14:00, Prabu Subroto wrote:
> I don't want to be spoiled by PHPMyAdmin anymore.
> I want to get be more expert in SQL Command of MySQL.
>
> So far, everything is fine but today I realized a
> problem. If I want to diplay the columns of an empty
> table, the MySQL Clien
On Friday 21 February 2003 19:38, you wrote:
> You asked:
> Does replication user have REPLICATION SLAVE privilege?
>
> Yes it does.
Connect to the master as replication user and see if SHOW SLAVE HOSTS gives
any error messages.
--
For technical support contracts, goto https://order.mysql.co
Howdy all!
I thought InnoDB tables enforced referential integrity? I believe I have set
up MySql to use InnoDB tables and I have created tables of type InnoDB, yet
I can still enter an illegal row!
Can anyone tell me what I am doing wrong? The final "insert into PET " below
should not work!
Rob
Hy Rob,
> == my.ini
> My my.ini file:
>
> [mysqld]
> basedir=C:/mySql/
> datadir=C:/mySql/data
>
> [WinMySQLAdmin]
> Server=C:/mySql/bin/mysqld-MAX-nt.exe
> innodb_data_home_dir = C:\mySql\ibdata
> innodb_data_file_path=ibdata1:30M:autoextend
you have the InnoDB Variables in the wrong section
Hi Oliver,
I tried as you suggested, but I have a different problem now..
> > == my.ini
> > My my.ini file:
> >
> > [mysqld]
> > basedir=C:/mySql/
> > datadir=C:/mySql/data
> >
> > [WinMySQLAdmin]
> > Server=C:/mySql/bin/mysqld-MAX-nt.exe
> > innodb_data_home_dir = C:\mySql\ibdata
> > innodb
I think I solved this.. I deleted C:\mySql\ibdata and I could start it up
again..
I think I know why it happened too.. when I start a connection with this:
mysqld-max-nt.exe --console --standalone
it takes the console over..
How do I properly close it down from another console?
Rob
:)
---
Howdy all!
I have changed my my.ini but my problem remains... details below.
Any further assistance would be greatly appreciated!
I apolagise to all if it seems I am flooding.. :(
Rob
:)
:->
:-}
== my.ini
[mysqld]
basedir=C:/mySql/
datadir=C:/mySql/data
[WinMySQLAdmin]
Server=C:/mySql/bin/
Hi,
I am new at this group. Nowadays I am using PHP/MySQL more than ever. I have
a problem with making queries on my huge database (totally more than 20
million rows and 9 GB).
The main problem is it is rather slow. For example I am making a query which
is checking the 5 biggest tables for, from
Hi,
This is actually a question for Oracle JDeveloper forums, but I couldn't get
any replies from that forum. If you are using JDeveloper on MySQL database,
please help me with this question.
Since MySQL doesn't have any equivalent to schema or user as in Oracle, I am
creating tables in multip
I fixed the problem below by uninstalling, reinstalling and using the
WinMySQLAdmin tool..
It left my.ini as:
[mysqld]
basedir=C:/mySql/
datadir=C:/mySql/data
innodb_data_file_path=ibdata1:30M:autoextend
[WinMySQLAdmin]
Server=C:/mySql/bin/mysqld-max-nt.exe
innodb_data_home_dir = C:\mySql\ibdata
Heikki,
Thanks for the response.
Just to be sure that we did not have a piece of code which we
had forgotten about, I did a search of the Java classes involved in
this application for the word "LOCK". I did not find any instance
where we are locking tables.
If we want to updat
mysql:您好!
这里我收集了一些近期免费加入的网站，搞网赚的朋友可千万不能错过！
http://yxwcyj.yeah.net2/25截止
http://yrt1688.yeah.net 3/1截止
http://yrt168.126.com 3/1截止
http://yxww168.yeah.net 3/1截止
http://yrt168.yeah.net3/1截止
现在你要做的就是赶快加入，并大力招人，等网站正式开通后就会有很多下线为你工作了。
因近期访问人多，可能会出现网站打不开的现象，没关系，多刷新几遍就是了。
>Description:
>How-To-Repeat:
>Fix:
>Submitter-Id:
>Originator:
>Organization:
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis:
>Severity:
>Priority:
>Category: mysql
>Class:
>Release: mys
I've posted a strange NullPointerException in class Connection
with a few days ago (see below).
Now I changed the driver to MySQL Connector/J 2.0.14.
But I'm still getting a NullPointerException:
java.lang.NullPointerException
at com.mysql.jdbc.Connection.execSQL(Unknown Source)
a
OK, I am having a bit of trouble designing a MySQL query that returns what
I want. Here is the query as I have it thus far:
SELECT DISTINCT regformfields.name AS thename,
regformfields.label AS thelabel,
regfields.name AS fieldsname
FROM regformfie
On 19-Feb-2003 Jeff Mao wrote:
> Greetings all,
>
> Not sure if this is the right place to ask this,...I use the
> following script on an OS X server to backup my mysql databases:
>
> #!/bin/sh
> DATE=`/bin/date +%Y%m%d"_"%H%M%S`;
> cd /Users/usernmae/Documents;
> /usr/bin/mysqldump -hhost -u
Hi!
I have a question regarding "Cardinality" for FULLTEXT-indexes.
I have a table with 9 indexes - the last 3 indexes are FULLTEXT.
When I run "show index from ", the last index (FULLTEXT) always shows
cardinality=NULL...
Is this normal? ...everything seems to work ok when I do selects using the
This may be simple for most of you MySQL experts out there so a little help
would be nice :)
I have an index page that is using a Navigation system based on the ID from a
table City:
The link then goes a DIR for that City.
http://www.theaddress.co.uk/City/
The navigation within this DIR is base
I'm a newcomer to MySQL, and I'm having trouble. I've installed MySQL
under RedHat 7.1 Linux, and I can't actually use it; I get authorization
error messages when I try. In particular, I understand that initially a
'root' user is set up without a password. I can't connect to the
database as
Hi Andrew,
You don't need to use seperate tables for each company. In fact you
shouldn't since select queries with index are fast.
I suggest,
1 table for the cities at least two columns, one for a unique column with
autoincrement(cityid), the other is the city names, with appropriate column
types
Try:
SELECT FF.name AS thename,
MAX(FF.label) AS thelabel,
F.name AS fieldsname
FROM regformfields as FF
INNER JOIN regfields as F
ON (FF.name = F.Name)
WHERE FF.label != ''
GROUP BY FF.name, F.name
I don't think you can include the ORDER BY F.saveorder (anot
When designing a database, think of it this way:
The "kinds of things" that you need to keep information about would map to
the first cut of what tables you need. So if you keep information about
Companies and Cities, you need (at least) the tables Companies and Cities.
Keep information (attribut
Unless your WHERE clause includes relationships for all the tables, you are
dealing with a Cartesian product - that is always slow.
And if you do have all the relationships included, this is still a monster
query. Do you have the proper indexes defined? Do you really need to join
these 5 tables
Tore,
Yes, it is necasarry to pick up all the values from 5 tables. I made indexes
for each table. My queries are between 12 to 26 seconds now. I am generating
a WHERE statement before make the query. If the user do not enter the some
min and max values I am skipping this WHERE statements.
The in
Use EXPLAIN to determine what indexes are chosen in the different cases.
AFAIK, version 4 will allow you to specify HINTs in the query, so you may be
able to force the query to use certain indexes.
There are a lot of factors that affect the execution and speed of queries,
including (but not limite
Hi -
I am new to MySQL & SQL in general. I have been
reading the documentation at www.mysql.com, but I've
become quite confused. I hope that one of you can
clear up a few issues for me.
I have a database called "parcel". The primary key in
this database is called "dxf", which contains a unique
Howdy all!
I would like to create a user that will only access my current project's
database. I would also like to store the data for my current project's
database in a particular location.
Can I use my.ini to do this?
For example,
- user = newProject
- pwd = newProject
- datadir=C:/newProjec
I want to keep a cumulative balance field in a mysql table. How do I do
this without corruption...
if the table looks like this:
datetime,desc,amount,balance
How can I insert a new record setting the balance field to the last balance
value + amount and not have data corruption if multiple inser
First, it appears that you are confusing "database" with table. A Database
is a collection of tables. Each table has rows of data which is organized
in columns.
>From what I understand, you have the following situation:
Table: Parcels
Columns:
dxf (Primary Key, auto_number)
[Descriptio
Thanks for the reply. I'll try your suggestions.
Actually, I *do* have two unique databases. They're
originally FoxPro dbase files, each generated by a
different application which I'm converting to MySQL
for a php app. It won't be a problem to create a
table for the buildings in the parcel data
MySQL guarantees that individual statements are atomic, so you can use
something like this:
UPDATE mytable SET balance = balance + 100
Of course, you'd have to provide the right WHERE clause...
Dean Harding.
> -Original Message-
> From: Bryan Waters [mailto:[EMAIL PROTECTED]
> Sent: Sun
I feel so stupid right now! I just loaded up Apache, mySql, and PHP on my
home Windows XP machine to work on my website. It'll be running on a Linux
server when I get it on the web.
I've been trying to check out this catalog program called PHP Catalog.
Their website has a free version to check o
At 20:31 -0500 2/22/03, Stitchin' wrote:
I feel so stupid right now! I just loaded up Apache, mySql, and PHP on my
home Windows XP machine to work on my website. It'll be running on a Linux
server when I get it on the web.
I've been trying to check out this catalog program called PHP Catalog.
The
Howdy all!
How do I open mysqld-max-nt.exe as a service (so I don't have to see a DOS
console open for it all the time). Here is the command I use to open it
currently:
mysqld-max-nt.exe --console --standalone
Any help would be appreciated!
Rob
:)
:->
:-}
So you want to take the balance from some other row, and insert a new
row using that balance?
In that case, you need to lock the whole table, or you need a proper
transaction interface, with read consistency. This implies either
locking the whole table with a MyISAM table type or using an InnoDB
> How do I open mysqld-max-nt.exe as a service (so I don't have to see a
DOS
> console open for it all the time). Here is the command I use to open
it
> currently:
>
> mysqld-max-nt.exe --console --standalone
>
> Any help would be appreciated!
The following command:
mysqld-max-nt.exe --install
43 matches
Mail list logo
