Hi List,
When can we expect limits in sub-queries? I am currently on 4.1.0.
1235 - This version of MySQL doesn't yet support 'LIMIT IN/ALL/ANY/SOME
subquery'
Query:
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
Hi,
I've got 2 tables in a circular dependency as follows
CREATE TABLE USERDETAILS
(
USERDETAILS_ID BIGINT NOT NULL,
FORENAME VARCHAR(30) BINARY NULL,
SURNAME VARCHAR(30) BINARY NULL,
USER_USER_ID_OID BIGINT NULL,
PRIMARY KEY (USERDETAILS_ID)
) TYPE=INNODB
CREATE TABLE
Yingyos [EMAIL PROTECTED] wrote:
I type this command line.
mysql -uuser -N -eselect date_format('2004-02-29','%X') sample2.txt
When i open in text editor,it show that '2004' only.
But i want format display on text file.
mysql select date_format('2004-02-29','%X');
We have found a bug in MySQL 4.1 (tested on Win2k machine):
create database testdate;
use testdate;
create table a (id int not null auto_increment, dt date, primary key(id));
insert into a (dt) values ('');
insert into a (dt) values ('2004-05-06');
select * from a where dt = '';
Pre Mysql 4.1
Ivan Cukic (Foment) escribio':
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
| Another question how can see the compatibility of authentification?
|
I don't know. It should be written in docs...
Anyway, try the next thing...
Try to create a symlink for every db except for mysql.
create a symlink
Hi All
I've not been able to find a good answer to this or figure out what
would be the best approach - bear in mind I am a beginner.
I have tried the following
USE databas
SELECT Item_A AS 'Something 1',
Item_B AS 'Something 2',
Item_C AS 'Something 3',
INTERVAL 6 MONTH + Item_B AS
Hi, I'd be grateful if someone could help me and tell me what I'm doing wrong with my
query. I suspect the answer is simple but I'm suffering a mental block right now.
In basic terms, I have three tables.
Two are reference tables thus:
table: locations
fields: location_id (primary key),
Andy Jefferson [EMAIL PROTECTED] wrote:
I've got 2 tables in a circular dependency as follows
CREATE TABLE USERDETAILS
(
USERDETAILS_ID BIGINT NOT NULL,
FORENAME VARCHAR(30) BINARY NULL,
SURNAME VARCHAR(30) BINARY NULL,
USER_USER_ID_OID BIGINT NULL,
PRIMARY KEY
Are there any NetBSD users on this list? Has anyone succesfully compiled MySQL 4.1x or
5.x on NetBSD? Why arent they in pkgsrc? Not just done yet or did something happend in
the 4.1.x release that stopped MySQL from working on NetBSD?
Regards
/Jonas
table: locations
fields: location_id (primary key), location_name
example data: 1, Lisbon; 2, Porto
table: teams
fields: team_id (primary key), team_name
example data: 1, France; 2, England
table: matches
fields: match_id, match_datetime, match_location (foreign key to locations
table),
Brad wrote
Josh Trutwin writes:
Javascript is a client-side language, the code is executed by the user's
browser. It has no way to connect to the database server and run queries
so you need to use a server-side programming language like Java (JDBC),
PhP, Perl, etc. Tomcat is a decent servlet
Hi:
I would like to add an identical server to the one I already have: Double Xeon
processors, 4 Gb RAM and RAID 5 (Hardware) HD's. I would also like to cluster
them using OpenMosix, but I'm told that MySQL 4.0 will not take advantage of
the cluster. Is there a way to cluster MySQL so that
Well, you don't need the distinct.
Are you inserting with your PHP script? LAST_INSERT_ID(), as per the
manual,
only returns the id from the last insert on that connect. You cannot
get the
LAST_INSERT_ID() for another connection.
j- k-
I used distinct because otherwise, I was
I am new to MySQL but I some basic database experience.
I have about 50,000 rows of data in a CSV file.
Where I can find some examples of SQL scripts that show how to:
a. Create a database X.
b. Create a table Y.
c. Import the 50,000 rows of CSV data into table Y.
I am running MySQL on Red
Hi,
I have a problem with a SELECT query. I have a users table and each user can
be a Rep, Nurse or Administrator defined by User_Type. Each Rep has two
Nurses allocated to them and the User_ID of the nurse is held in column
Rep_Nurse_1 and Rep_Nurse_2. I am trying to perform a query that
SELECT user_id, rep_nurse_1, rep_nurse_2
FROM Users
WHERE User_ID = 'x'
I have a problem with a SELECT query. I have a users table and each user
can
be a Rep, Nurse or Administrator defined by User_Type. Each Rep has two
Nurses allocated to them and the User_ID of the nurse is held in column
On Thu, May 06, 2004 at 06:55:38AM -0600, Alfredo Cole wrote:
Hi:
I would like to add an identical server to the one I already have: Double Xeon
processors, 4 Gb RAM and RAID 5 (Hardware) HD's. I would also like to cluster
them using OpenMosix, but I'm told that MySQL 4.0 will not take
Hello,
I'm trying to estimate which disks to buy for an mySQL DB for my clienst.
May biggest table is around 700GB and has following format:
TECHLOG table
ARDKey 4 Integer
TIMESTAMP 8
Hi everyone,
Please help.
I have MySQL server running on host A in US and I am
using it on host B in Europe. Every query takes about
0.3 seconds.
Now I want to do update db with 5000 updates. So I put
all the UPDATES commands in a file cmd.sql and do:
mysql -hA cmd.sql
and it takes 30
shaun thornburgh wrote
Hi,
I have a problem with a SELECT query. I have a users table and each user
can
be a Rep, Nurse or Administrator defined by User_Type. Each Rep has two
Nurses allocated to them and the User_ID of the nurse is held in column
Rep_Nurse_1 and Rep_Nurse_2. I am trying to
I'm trying to find documentation on how to setup MySQL cluster
Any ideas?
Vadim
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Jason Weiss wrote:
Hello Sir or Madam,
As for my class project, I need to implement a function to calculate miss ratio.
But I am having a such problem where to start. I appreciate if you can give me any
advice how to do modify the codes and where to start.
Thank you.
Jason:
See
On Thu, May 06, 2004 at 10:12:19AM -0700, William Wang wrote:
Hi everyone,
Please help.
I have MySQL server running on host A in US and I am
using it on host B in Europe. Every query takes about
0.3 seconds.
Now I want to do update db with 5000 updates. So I put
all the UPDATES
El Jue 06 May 2004 11:05, escribió:
On Thu, May 06, 2004 at 06:55:38AM -0600, Alfredo Cole wrote:
Hi:
I would like to add an identical server to the one I already have: Double
Xeon processors, 4 Gb RAM and RAID 5 (Hardware) HD's. I would also like
to cluster them using OpenMosix, but
I'm guessing here but it sounds like you have the cmd.sql file on your local
machine (in Europe). If that's the case, compress the file, ftp it to the
US server, uncompress it and do the load locally on the US server.
If you're doing the update remotely, you're probably being killed by
Thanks Jack and Jeremy.
But this is part of my application and I need to do
this automatically. I don't want to write a
server-client application to just to handle file
transimission and do pass the update cmd to local
server. Any idea? Thanks.
William
--- Jack Coxen [EMAIL PROTECTED] wrote:
I'd suggest a shell script - a couple of them, actually. Have a shell
script on the Europe machine that runs continually. It checks for the
existence of the cmd.sql file. If it finds it, it FTPs it to the US server
and then deletes or archives the file locally. If it doesn't find it, it
sleeps
On Thu, 2004-05-06 at 07:24, luther van dam wrote:
I am new to MySQL but I some basic database experience.
I have about 50,000 rows of data in a CSV file.
Where I can find some examples of SQL scripts that show how to:
a. Create a database X.
b. Create a table Y.
c. Import the 50,000
We're trying to set up SSL so that we can access our MySQL server from a
remote site. I am having a hard time trying to find a HOW-TO that describes
the whole process, and am finding instead little snippets scattered all
over. Can anyone point me in a direction that might provide more (and
Thanks Jack and Jeremy.
But this is part of my application and I need to do
this automatically. I don't want to write a
server-client application to just to handle file
transimission and do pass the update cmd to local
server. Any idea? Thanks.
If you have ssh installed on both
Well look at that. I didn't look back to the Connect statement that starts
the ID. Just when I think I'm getting a handle, I dive back into the
quicksand! Ugh.
Thanks
Lou
- Original Message -
From: Egor Egorov [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, May 04, 2004
if it is part of app. use soap to communicate with server and adopt your
application. Send all your commands as one string parameter to server,
and execute it all there. Such modification to is quite simple to write
using gSoap library (if your application is C++ based) or Axis (Java).
mirza
Luther -
I would recommend picking up Paul DuBois' book MySQL - The Definitive
Guide. The MySQL.com website has docs which will answer your question,
but I think a good text always helps with learning MySQL.
If you have any specific questions or issues. Please feel free to ask.
Thanks,
Where's the presentations? They were supposed to be on the website at
the end of last week.
Thanks
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi all,
When I run the following code the default value isn't being calculated using the concat
and other functions. Instead it is setting the column definition as a string:
CONCAT(TMP
How can I rework this to get a result more like
TMP-T-2
?
USE cro;
CREATE TABLE lpamform (
Tim Russell wrote:
Hi all,
When I run the following code the default value isn't being calculated using the concat
and other functions. Instead it is setting the column definition as a string:
CONCAT(TMP
How can I rework this to get a result more like
TMP-T-2
?
You can't.
Default
Matthew Stuart wrote:
I have a home page where I need to show three news articles which are
specified by the administrator - so it might not be the latest
articles and they might not be in any order. I have designed the db to
have two tables to fulfill this function the first table 'tbl_press'
Matthew Stuart wrote
I have a home page where I need to show three news articles which are
specified by the administrator - so it might not be the latest articles
and they might not be in any order. I have designed the db to have two
tables to fulfill this function the first table 'tbl_press'
Should work fine. Quick test from a large sales test table (1.9
million rows):
mysql select count(*) from sali;
+--+
| count(*) |
+--+
| 1983026 |
+--+
1 row in set (0.00 sec)
mysql select salidate,sum(saliQtySold) from sali where salidate
DATE_SUB(CURRENT_DATE,
Hi Bob,
I don't use openBSD, but from the FreeBSD ldconfig man page I have:
-m Instead of replacing the contents of the hints file with
those
found in the directories specified, ``merge'' in new
entries.
Directories recorded in the hints file by previous runs
This one is more curiosity than a problem.
I have read the docs about HASH indexes and how they are used, but I'm just wholly
unfamiliar with WHAT a HASH index is. I'm only familiar with the term 'hash' as it
relates to encryption. What exactly IS a hash index?
Just curious,
Lou
Ok having some problems with MySQL's fulltext search. I have the fields
that I need fulltext indexed, everything seems to be working correctly, but
for some reason when I search for beyond looking for an item called:
Beyond Heaven yoga Day Spa
It doesn¹t find it.. I am searching in boolean
Hi,
In MySQL, I do:
mysql SELECT * FROM my_table WHERE myconditions LIMIT
10;
It retrieves 10 rows of data that meets 'myconditions'
from my_table. Is it possible to get the total row
count that meets 'myconditions' without another query?
Thanks.
Dexin
Lou Olsten wrote:
This one is more curiosity than a problem.
I have read the docs about HASH indexes and how they are used, but I'm just wholly
unfamiliar with WHAT a HASH index is. I'm only familiar with the term 'hash' as it
relates to encryption. What exactly IS a hash index?
Just curious,
Yes
Use SQL_CALC_ROWS
And then SELECT FOUND_ROWS()
-Original Message-
From: William Wang [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 06, 2004 2:12 PM
To: [EMAIL PROTECTED]
Subject: use LIMIT and get total count
Hi,
In MySQL, I do:
mysql SELECT * FROM my_table WHERE
Check to see if beyond is in your stopword file.
-Original Message-
From: Richard Baskett [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 06, 2004 2:12 PM
To: MySQL
Subject: Fulltext searching
Ok having some problems with MySQL's fulltext search. I have the fields
that I need
[EMAIL PROTECTED] wrote:
Hi folks.
I've got MySQL running on a W2K dev box and want to run it on a production
Linux box.
Being new to Linux, I'm wondering what's the difference between the version
of MySQL that ships with a Linux distro and downloading it from the MySQL
website.
By way of
Dear folks,
Right after installing from mysql-standard-4.0.18.pkg, I came up with
the following:
sudo /usr/local/mysql/bin/mysqld_safe
Password:
Starting mysqld daemon with databases from /usr/local/mysql/data
040506 07:13:11 mysqld ended
As far as I read the instruction I have no clue if
In my system variables it shown that the stopword file is (built-in) so
where would I find it then if it is built in.. 'Beyond does not seem like
a word that would be in a built-in stopword file does it? Could it be
reserved?
Thanks!
Rick
on 5/6/04 15:30, Dathan Vance Pattishall at [EMAIL
If you've built from source, the stopwords are in
path-to-source/myisam/ft_static.c
In my copy of 4.0.18, beyond is in the list.
You can create your own stopword list, or turn off stopwords altogether, if
you want. See http://dev.mysql.com/doc/mysql/en/Fulltext_Fine-tuning.html
for the
Greetings,
I've recently inherited a FreeBSD server running MySQL
3.23.54. It's good and stable. I have a second
server that runs as a slave to the first. Everything
goes smoothly until I make changes to a certain table
on my master. This will kill the slave with the error
that this table is
hAj wrote:
Dear folks,
Right after installing from mysql-standard-4.0.18.pkg, I came up with
the following:
sudo /usr/local/mysql/bin/mysqld_safe
Password:
Starting mysqld daemon with databases from /usr/local/mysql/data
040506 07:13:11 mysqld ended
As far as I read the instruction I have
on 5/6/04 16:53, Michael Stassen at [EMAIL PROTECTED] wrote:
If you've built from source, the stopwords are in
path-to-source/myisam/ft_static.c
In my copy of 4.0.18, beyond is in the list.
You can create your own stopword list, or turn off stopwords altogether, if
you want. See
Where's the presentations? They were supposed to be on the website at
the end of last week.
Thanks
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi, I am setting up a lab to evaluate main features of MySQL so that
provide advise for other departments to consider for their choice of
database. Do you have a list of such features? Or do you have similar
evaluation reports for my reference?
Thanks,
Joseph
--
MySQL General Mailing List
For
There's a bunch.
Check out:
http://dev.mysql.com/doc/mysql/en/Introduction.html
HTH,
Robert J Taylor
[EMAIL PROTECTED]
On Thu, 2004-05-06 at 20:09, [EMAIL PROTECTED] wrote:
Hi, I am setting up a lab to evaluate main features of MySQL so that
provide advise for other departments to consider
We are pleased to announce the release of the new DBManager 2.3.0. This
versions is not only a bug fix but it has new features which make the
application more powerful.
Starting in this version it's possible to manage MySQL servers through
webservices (and soon for other engines). If you have a
57 matches
Mail list logo