I came accross a problem porting our tv listings system from postgres to
mysql with InnoDB.
With InnoDB tables, read-only transactions started after a read-write
transaction touching the same rows are able to read data as it was before
the read-write transaction began; UNLESS the read-only
Hi
you can use
SELECT * FROM table WHERE expireNOW();
or
SELECT * FROM table WHERE to_days(expire)to_days(NOW());
HTH
Dobromir Velev
[EMAIL PROTECTED]
http://www.websitepulse.com/
- Original Message -
From: Stephen of Blank Canvas [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent:
Hello,
Can anyone tell me if MySQL will work on Windows XP Home Ed.?
I have MySQL installed according to the instructions on the CreateASite
web page.
I tried contacted CreateASite with this description of the problem:
The start up looks good: when I use the Run function
Hi Calvin,
Just do drop database db_name
Regards,
Eric
On Wed, 5 Feb 2003, Calvin Lam wrote:
Hi,
I am a newbie with this and I need help with Mysql
How can I delete a database in Mysql
thanks!
-
Before posting, please
In the 4.0.10 version I found a new computername.err file instead the old
lod named mysql.err . This feature is a new standard or there is a way to
continue to named it to mysql.err ?
Regards
-
Massimo Petrini
c/o Omt spa
Via Ferrero 67/a
Sam,
I assume you are having the MySQL binlogging on? The following manual
excerpt explains why this has to work as it does:
INSERT INTO T SELECT ... FROM S WHERE ... sets an exclusive (non-next-key)
lock on each row inserted into T. Normally does the search on S as a
consistent read, but sets
Scott,
http://www.innodb.com/ibman.html#InnoDB_foreign_keys
Starting from version 3.23.50 you can also associate the ON DELETE CASCADE
or ON DELETE SET NULL clause with the foreign key constraint. Corresponding
ON UPDATE options are available starting from 4.0.8.
Regards,
Heikki
Innobase Oy
Hello,
I would like to know what are limitations for mysql in number of records, size
of records, size of tables etc.
Can anyone help me please?
--
Martin Hudec
===
:m:+421 907 303 393
:@:[EMAIL PROTECTED]
:w: http://www.corwin.sk
In google non est, ergo non est.
Davy,
DO I have been trying to get InnoDb to run on my windows XP machine.
DO (...)
DO #innodb_data_home_dir =
DO #innodb_log_group_home_dir =
DO #innodb_data_file_path = /ibdata/ibdata1:10M:autoextend
The remarks are in German, but I guess you will know what to do if
you look at the following
Calvin,
CL I am a newbie with this and I need help with Mysql
CL How can I delete a database in Mysql
DROP DATABASE database_name;
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin (Germany)
Telefon: +49 30 7970948-0 Fax: +49 30
DISTINCT?
-Original Message-
From: Tab Alleman [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 05, 2003 12:31 PM
To: Jaime Teng; [EMAIL PROTECTED]
Subject: RE: need help with GROUP BY
SELECT id,account FROM tablename WHERE detail LIKE '%pattern%' GROUP BY
Account;
-Original
DOOD!! THAT IS NOT P.C.!!! YOU GONNA GET US IN TROUBLE...
Peter
^_^
-Original Message-
From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 05, 2003 5:10 PM
To: Defryn, Guy
Cc: [EMAIL PROTECTED]
Subject: Re: Is it my English or does this sound bad?
On Wed,
As long as the foreign keys are index it should be pretty quick. There
really is no way to get around processing every record in table data.
As that table grows, your query will get slower. But a 157K rows isn't
really a whole lot.
How long does it take? Obviously you would want to run SELECT
The assertion in the manual referred to windows I think is not correct. In
my XP version I found the log file as in Unix ie \mysql\data\hostname.err
instead \mysql\data\mysql.err as in previous version. Note in my.ini file
there is nothing about log-error option . Which is the correct
Here are a number of queries that are run from time to time on the master. They are
always run together and in order that they appear.
Version of the server is 3.23.32 ( yes its old, but difficult to update at this time )
Version of the slave is 3.23.49a
Note: [param:variable] is handled by our
Hi,
I am new to SQL. I am attempting to create a database that was created in
MS SQL to MySQL. The below SQL statements works with MS SQL.
I am executing the following:
CREATE TABLE 'Accounting'(
'Username' VARCHAR(254) NULL,
'CallerID' VARCHAR(128) NULL,
'Addr' VARCHAR(128) NULL,
Paul DuBois wrote:
I believe the Horde IMP server uses MySQL:
http://www.horde.org
Thanks. Looking at this, I belive it's an IMAP clinet. Unless the web
site is in error.
I was rather trying to find an IMAP server using MySQL. Ie, somewhere
to store my millions of email messages, from
On Wed, 2003-02-05 at 13:53, Kamara Eric R-M wrote:
INSERT into tbl_name (username,password) values
('user',PASSWORD('passwd'));
and when authenticating the user you can do something like
SELECT username from tbl_name where passwd=PASSWORD('$pass'); and in this
case $pass is the variable
What version MySQL are you using? Did you set up the MySQL server?
SQL_BIG_SELECTS is to prevent users from making 'foolish' queries'
SQL_BIG_SELECTS = 0 | 1
If set to 0, MySQL will abort if a SELECT is attempted that probably will
take a very long time. This is useful when an inadvisable WHERE
DROP DATABASE dataBaseName;
-Original Message-
From: Calvin Lam [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 05, 2003 8:50 AM
To: [EMAIL PROTECTED]
Subject: Deleting a database in Mysql
Hi,
I am a newbie with this and I need help with Mysql
How can I delete a database in
Does anyone know a program for Windows that can create reports for
MySQL databases?
Check out Crystal Reports
http://www.crystaldecisions.com
or
ReportMill
http://www.reportmill.com
hope these help. We use Crystal Reports. If you have any questions
about crystal please let me know.
(query,
On Wednesday 05 February 2003 16:50, Calvin Lam wrote:
I am a newbie with this and I need help with Mysql
How can I delete a database in Mysql
Use DROP DATABASE statement:
http://www.mysql.com/doc/en/DROP_DATABASE.html
--
For technical support contracts, goto
On Tuesday 04 February 2003 19:16, Dmitry Kosoy wrote:
I can put ibdata files on separate disks.
Yup, you can find example of my.cnf in the manual:
http://www.mysql.com/doc/en/InnoDB_start.html
Is there any way to put different db on separate disks ?
You can move database
On Wednesday 05 February 2003 06:02, Mudit Wahal wrote:
Description:
I have a delete statement and an insert statment. I'm replacing a line but
I want to make sure, that its deleted. The insertion is successful as per
sql batch output. But when I dump the data from the table, there is
select columnName
from tableName
where expireColumnDateValue = Now()
-Original Message-
From: Stephen of Blank Canvas [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 05, 2003 10:18 AM
To: [EMAIL PROTECTED]
Subject: SELECT with DATE
Can anyone point me in the right direction for
Are indexes present on both tables? Do the columns that are being joined
upon both indexed?
-Original Message-
From: James Pharaoh [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 05, 2003 11:28 AM
To: [EMAIL PROTECTED]
Subject: 1 column - 2 column join optimisation
Hi,
I'm trying
Good morning there (and sorry if this mail comes twice - I do not know
If the first try succeeded),
I have a question regarding mysql replication:
I have set up a 2 node replication where each host acts as master AND
slave to the other, so it does not matter where you make changes, both
I would keep it in one table. Structured properly, you could then have
groups, sub-groups and categories, creating a hierarchy as deep as you
want. It's more for future proofing your database than anything else.
Just add two more columns to your table, one for a parent id and one to
indicate
Maybe I'm missing something, but those queries look the same to me.
I think it's your use of OR that is causing things to slow down. Try
using a table alias and another left join instead and see if that speeds
things up.
SELECT *
FROM user LEFT JOIN history ON user.userid=history.touserid
LEFT
I have tried report manager http://reportman.sourceforge.net/
that works fine ans is in opensource. The big trouble of it for me is that
is is written in delphi with borland tools. I made a dll with C++ builder to
be able to use it in C/C++ with the gnu compilers. It works, but gdb crashes
when it
Hello,
If it's a documented feature which I've missed - please excuse, but after
upgrading from 4.0.2 to 4.0.7 the following sql statement started to
behave differently then before:
select Sections.ReportName, Creatives.Name,
from HourlyStats natural left join Sections
left join
I attempted to search various places for my answer but with no luck. So I'm posting
here.
I create the following table:
create table t1 ( id varchar(5) not null, name varchar(5) not null );
I insert the following row:
insert into t1 ( id ) values ( 1234 );
I do the following selects:
Why not just use the word gender.
Richard
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 05, 2003 10:18 AM
To: Defryn, Guy; [EMAIL PROTECTED]
Subject: Re: Is it my English or does this sound bad?
At 15:58 +1300 2/5/03, Defryn,
Hi all,
Please tell me how can I sort a column and force placing the null values to
the end of list?
Thank you sql query
Teddy,
Teddy's Center: http://teddy.fcc.ro/
Email: [EMAIL PROTECTED]
-
Before posting, please check:
Try this:
insert into tablename values ('myusername', password('mypassword'));
[EMAIL PROTECTED] wrote:
On Tue, Feb 04, 2003 at 02:58:28PM -0500, Jianping Zhu wrote:
I have mysql in a redhat machine. I need to use mysql do user
authentication to a website.
I have a table like following.
You are inserting 6 values into 7 fields, so it fails.
looks like a 6 field table to me
create table if not exists MSFT (date DATE not null, close
DECIMAL(10,2), high DECIMAL(10,2), low DECIMAL(10,2), volume MEDIUMINT,
yest DECIMAL(10,2), PRIMARY KEY date (date));
1) date
2) close
3) high
4)
When you store the information into the field you can us the mysql function
password. Then when you wish to test for a match you do something like
select count(*) where username='$username' and passwd = Password($password)
Where $username is the input username and $password is the input
I have just downloaded the mysql-3.23.55-win.zip file from your website
onto my pc running win98_se. I am learning sql using the Teach Yourself
SQL in 24 hours book by Ryan Stephens and Ron Plew. They suggest
downloading your propram in order to complete the hands-on exercises
mentioned in each
SQLyog v3.02 - The definitive Windows Front End for MySQL, has been
released. It is a superfast, compact and easy to use Front End for MySQL. A
must for MySQL developers. SQLyog is FREE!
Some of the new features added in SQLyog 3.02 are -
-- ODBC Import. The simplest and the most powerful tool
I just had to alter a large (25Gig, 100Million rows) table to
increase the max_rows parameter. The 'alter table' query is now
running 60+ hours, the last 30+hours it spend in 'repair with
keycache' mode. Is there any way to speed up this operation?
I realize, it is probably too late now. But next
On 5 Feb 2003, at 16:02, Darren Young wrote:
I've looked through the mysql manual for information on regualar
expressions, and all that it seems to have are references such as:
SELECT fo\nfo REGEXP ^fo$;
How can the REGEXP be applied to a 'SELECT field FROM table' kind of
statement?
The
escape your data with a black slash
\' if you mean to have a literal single quotation mark.
-Original Message-
From: ahimsa [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 05, 2003 11:43 AM
To: [EMAIL PROTECTED]
Subject: apostrophe and comma error on submit
Does anyone know about
Hello,
I get the a table handler error (ERROR 1030: Got error 28 from table
handler), when using mySQL to evaluate numerious queries in a loop (from
Java), after a certain number of successfully evaluated queries.
My impression is that it is caused by the appearance of large files in
/tmp/
There are three kinds of people in this world;
those who can count, and those who can't.
Ray wrote:
You are inserting 6 values into 7 fields, so it fails.
looks like a 6 field table to me
create table if not exists MSFT (date DATE not null, close
DECIMAL(10,2), high DECIMAL(10,2), low
Am I blind, or are those two queries the same?
James Pharaoh wrote:
Hi,
I'm trying to optimize the following query:
SELECT *
FROM user LEFT JOIN history ON user.userid = history.touserid OR
user.userid = history.fromuserid
WHERE user.state = 'ready'
GROUP BY user.userid
This causes a full
Hy,
im trying to create a replication between two MySql Servers. The Master
is running 4.0.6 (linux) and the slave ist 4.0.10 (solaris sparc
64-bit). If i try to start the replication process on the slave it
prints the following error message in the message log :
030206 20:09:36 Slave I/O
Rather use Gender than Sex?
Regards,
Joseph
-Original Message-
From: Kevin Smith [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 05, 2003 8:01 PM
To: [EMAIL PROTECTED]
Subject: Re: Is it my English or does this sound bad?
I guess it depends on if you have a dirty mind, or, you
You can achieve using LIMIT option with the select stmt.
Regards,
Joseph
-Original Message-
From: Andrew Maynes [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 05, 2003 11:22 PM
To: MySQL-Lista
Subject: query produces a navigation
I have a set of records in a mysql table that
Hi,
Does anyone know about an error that occurs when you try to
submit into mysql.
Whever i try to imput any text with a comma in it or an
appostrophe, i get an error until i remove it.
Any suggestions. .. anyone...? Im using php and submiting
via post, when i get the error.
Thank
http://froogle.google.com/froogle?q=sql+for+smartiesbtnG=Froogle+Search
Chapters 28 and 29 on Trees.
No another table is not a solution because what happens when you need yet
another sub-category.
I could explain it to you but I'd do a very poor job compared to the
chapters in the book above.
I am using MySQL CC, the GUI client. It is easy to drop a db there. Any
GUI client should have that option. If you are newbie, I would suggest
doing this. If using command line, it is
Drop database dbname
Refer the manual
http://www.mysql.com/doc/en/DROP_DATABASE.html
Regards,
Joseph
A short while ago I announced a couple of papers I've written on using
MySQL from Ruby programs, made available at my web site:
http://www.kitebird.com/articles/
More recently, I've also put there a series of other MySQL-related articles
that may be of interest to some of you:
Securing Your
52 matches
Mail list logo