Hi,
I am a newbie to mysql db. I need a select statement which will just
execute and doesn't
return any results. Also, it should not depend on any table which is
specific to a database.
For example, Oracle has a table named 'tab' which will be present in all
databases so my
dummy select
Dear MySQL lovers,
I have approached MySQL for courses / certification in the Malaysia and
Singapore region, and just want to know
if there are people out there who would be interested to attend such
training. They would require a minimum of 8-10
attendees.
If you're interested...reply.
Thanks!
Mike Blezien [EMAIL PROTECTED] wrote:
what is the best way to convert a TIMESTAMP value to a value
similar to a DATETIME value ??
If you mean TIMESTAMP column type, you can just change column type with ALTER TABLE
statement.
--
For technical support contracts, goto
Hi,
I am a newbie to mysql db. I need a select statement which will just
execute and doesn't
return any results. Also, it should not depend on any table which is
specific to a database.
For example, Oracle has a table named 'tab' which will be present in all
databases so my
dummy select
Hi
I cannot see the need for transactions etc.
Why not?
With regards,
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL MS SQL
Server.
Upscene Productions
http://www.upscene.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Fri, 5 Dec 2003, Boehn, Gunnar von wrote:
Yes, we plan to offer Linux/PPC binaries in the near future - we're
currently working on purchasing a system for that.
If you have some harddisk space left, then you can install Linux on one
OK, I will give you more details.
MySQL ver. : 4.0.16
CPU : 2xCelleron 1000 1GB RAM
Table CDS, have 1,053,794 rows, FT index on title,
Data 67,646 KB, Index 70,401 KB
Table ARTISTS, Rows 292,330, FT on name,
Data 8,096 KB
Index 17,218 KB
Table TRACKS, rows 13,841,930, FT on title
Data
OK, I will give you more details.
MySQL ver. : 4.0.16
CPU : 2xCelleron 1000 1GB RAM
Table CDS, have 1,053,794 rows, FT index on title,
Data 67,646 KB, Index 70,401 KB
Table ARTISTS, Rows 292,330, FT on name,
Data 8,096 KB
Index 17,218 KB
Table TRACKS, rows 13,841,930, FT on title
Data
Uros Kotnik wrote:
Time for first SQL : 21 sec.
SELECT artists.name, cds.title, tracks.title FROM artists, cds, tracks
WHERE artists.artistid = cds.artistid AND artists.artistid =
tracks.artistid AND cds.cdid = tracks.cdid AND MATCH (artists.name)
AGAINST ('madonna'IN BOOLEAN MODE) AND
MATCH
Does this mean that I must make all of my web sites non-commercial?
(since I use mySQL as my main DBMS)
This was sarcastic, not real question aiming the next sentence
MySQL You need a license if you sell a product designed specifically
for use with MySQL or that requires the MySQL server to
It makes sense, but Sergei G. said :
And are you sure the numbers are correct, the first query - the one
without IN BOOLEAN MODE - is faster ? I would expect the opposite.
I guess that for my DB I can't expect satisfied in boolena mode times
?
But also when searching without in boolean mode and
[snip]
Well Todd, it is a little more complex than this. How much do
you know about XML?
In fact, exporting is quite simple. Just give
mysqldump --xml --password=[password] \
[-u username] \
databasename \
[tables]
A try. Of course,
Hi,
I have a table witch has a column of type VARCHAR(10) BINARY. When I tried to insert
white spaces in it (insert into mytable (mycolumn) values('')), an empty String is
stored. Why?
Lemasson Sylvain
Ingénieur développeur
[EMAIL PROTECTED]
tel: 01.48.63.27.27
MAK-SYSTEM SERVICES
Groupe
Am I able to specify to somebody who is dumping from Oracle to use TAB
as the delimiter? Does MySQL enable me to specify during import that
the CSV is a TAB delimited file?
What do most of you use that would not cause problems with text heavy
dumps? Double quotes and comas etc are used through
On Monday 08 December 2003 13:06, Matthew Stuart wrote:
Am I able to specify to somebody who is dumping from Oracle to use TAB
as the delimiter? Does MySQL enable me to specify during import that
the CSV is a TAB delimited file?
Read The Fine Manual :)
[snip]
I have a table witch has a column of type VARCHAR(10) BINARY. When I
tried to insert white spaces in it (insert into mytable (mycolumn)
values('')), an empty String is stored. Why?
[/snip]
Because (' ') is an empty string
see
http://www.mysql.com/doc/en/String_syntax.html
I try to add a primary key on a BLOB column and I have got an error (ERROR 1170: BLOB
column 'value5' used in key specification without a key length).
May be the answer is in the documentation but I did not find it. So how could I make
my BLOB column a primary key?
Lemasson Sylvain
Ingénieur
I'm trying to search a table for duplicate entries.
A record is a dup if fields Fee, Fie, Foe are equal in two records.
Would this query be correct to search the table for duplicates?
Select Fee,Fie,Foe
From TableFoo
Group by Fee,Fie,Foe
Having Count(*) 1;
Thanks,
Jeff
--
MySQL General
Hello everyone,
I have a mysql table tha holds a variety of ip address. I am trying
to work out a select statement that will give me a count(*) grouped by
the first 2 octets of the ip.
if the ip table contains:
10.102.1.1
192.168.123.34
192.168.123.4
192.168.123.43
192.168.123.3
On maandag 8 december 2003 14:08 Jay Blanchard told the butterflies:
[snip]
Well Todd, it is a little more complex than this. How much do you
know about XML?
In fact, exporting is quite simple. Just give
mysqldump --xml --password=[password] \
[-u username] \
Hi, I tried this and it seems to work:
SELECT SUBSTRING_INDEX(INET_NTOA(ip), '.',3) AS addr, COUNT(*) AS addrsum FROM
ips GROUP BY addr;
Perhaps you don't have your IP adresses stored as integers but instead as
text. Then the following query is for you!
Your query:
SELECT ip, COUNT(*) from
Hi,
May be the answer is in the documentation but I did not find it. So
how could I make my BLOB column a primary key?
My guess is you cannot.
With regards,
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL MS SQL
Server.
Upscene Productions
Bryan Harris [EMAIL PROTECTED] wrote:
I'm pretty new to MySQL, but I already like it. Kudos to the developers!
I recently did a mysqlimport on a few data files, and it came back with over
4000 warnings. How can I actually see what the warnings were? I'm still
not sure what it was upset
Lemasson Sylvain [EMAIL PROTECTED] wrote:
I try to add a primary key on a BLOB column and I have got an error (ERROR 1170:
BLOB column 'value5' used in key specification without a key length).
May be the answer is in the documentation but I did not find it. So how could I make
my BLOB
Lemasson,
When you refer to a column as a primary key, I tend to think that this key
will be your main relationship point to the data in your table. Now, when
you combine the primary key concept with a BLOB (binary large object), it
seems to me that you are almost defeating the purpose of a
I've got an entry in a table where the value is 875. If I run a query on
that table with the clause AND sqaurefeet = '$squarefeet' and $squarefeet
has a value of say 1000 the row with the squarefeer value of 875 will
appear. The column is of type varchar(10) and using the binary flag.
What am I
On 8 Dec 2003 at 11:30, Ed Curtis wrote:
I've got an entry in a table where the value is 875. If I run a query
on that table with the clause AND sqaurefeet = '$squarefeet' and
$squarefeet has a value of say 1000 the row with the squarefeer value
of 875 will appear. The column is of type
You have a few ways to do this.
What's happening here is that you do a comparison in a string context,
which means that it will sort according to the ascii values, and 1 comes
before 8.
To sort the way you want you need to specify to MySQL that you want to do
it in a numeric context.
You have two
Thanks for the sugestions from all. I just switched the column type to
integer.
Thanks again,
Ed
On Mon, 8 Dec 2003, Tobias Asplund wrote:
You have a few ways to do this.
What's happening here is that you do a comparison in a string context,
which means that it will sort according to
If i have done all the steps to the replication, How often is the data
updated to the slave ?. Can i set the time ?
Regards
Spectrum.
_
Charla con tus amigos en línea mediante MSN Messenger:
I compiled MySQL 4.1.1 --with-openssl --with-vio and when I look at the
variables with mysqladmin, has_openssl is set to NO. I've got
OpenSSL 0.9.7c installed. I'm seeing this on both Solaris and Debian
hosts. I'm not seeing any errors during the configure or compile phases.
What could have
Hello,
been trying to figure out the correct SQL query to get
percentage from a table that list a Min, and Max., price
range and the percentage associated to the range.
Here is the current data in the table:
1 0.00 4999.00 13.0
2 5000.00 .00 12.5
3 1.00 14999.00 12.0
4 15000.00
Sorry..
The query should be:
select percentage from table_name where
min = 500.00 and 500.00 = max;
database.
Original Message
Subject: Query Range
Date: Mon, 08 Dec 2003 11:23:28 -0600
From: Mike Blezien [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
Organization: Thunder Rain
Hello people.
I have a table structured like this
+--+---+
| Field| Type |
+--+---+
| dt_imp | date |
| imp | decimal(5,2) |
+--+---+
If I want to get the total
You have the first inequality backwards. You want:
SELECT percentage FROM table_name
WHERE min = 500.00 AND max = 500.00
Michael
Mike Blezien wrote:
Sorry..
The query should be:
select percentage from table_name where
min = 500.00 and 500.00 = max;
database.
Original Message
There's actually a MySQL Database Appliance out there. Have you looked
at that yet?
http://pogolinux.com/mysql/index.html
You could run MySQL on any number of different machines. Intel, Athlon,
PowerPC, etc. Linux, FreeBSD, Windows, Mac OS X.
- Gabriel
On Dec 7, 2003, at 4:41 PM, Defryn, Guy
Hi,
I've been using postgres for a while but have today taken the plunge and
installed MySQL 4.0.16 on my Linux box. It's all now working perfectly.
Is there a simple way of copying a postgres database to MySQL? I was hoping
that postgres's backup 'pg_dump' utility (which dumps a database into
i think you can because the dump file is a sql file and it is universal for both
exception that mysql hasn't subselects. If you havent subselects it should work
Matthew Stanfield [EMAIL PROTECTED] wrote:Hi,
I've been using postgres for a while but have today taken the plunge and
installed
Hi Ya,
I have a typical select as follows
SELECT * FROM ytbl_development AS t1
WHERE (t1.txtDevName LIKE '%#form.searchtext#%')
However users a complaining that if they search for for a name that
contains a quote eg a development named King's Reach it is not found.
A)
Now it simply
I'm all for using what works and do not try to avoid MS (as long as it fits
the requirements).
However, I found out that MySQL does not work very well under load under
Windows 2000. It is considerably slower than a similar configured Linux
system. It may be how MySQL AB compiled the Windows
This looks like a flash server. I am not sure if we will have enough
Mysql use to justify this. Does anyone have an idea for what kind of use
(amount of db etc) that I would use this kind of server?
Guy
-Original Message-
From: Gabriel Ricard [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 9
Hello, I am experiencing a strange problem with a MySQL server on a
FreeBSD machine here in college. The problem began after I de-installed
the 4.1 ALPHA versions of both the client and the server, removed the
/var/db/mysql/ directory so the install would start afresh and installed
the 4.0.6
Have you flushed priv's recently?
-Original Message-
From: Schrodinger [mailto:[EMAIL PROTECTED]
Sent: Monday, December 08, 2003 1:02 PM
To: MySQL General Lists
Subject: Login Problems
Hello, I am experiencing a strange problem with a MySQL server on a
FreeBSD machine here in college.
Fellow Mysqlians,
Can anyone tell me why mysql refuses to use the fulltext index
in the second query?
Query 1;
mysql explain select straight_join distinct i.ID from INTEREST i use index
(COMMENT)
inner join PERSON p on p.ID=i.PERSON_ID where match(i.COMMENT)
No I haven't. How do I do that?
-Original Message-
From: Brian Duke [mailto:[EMAIL PROTECTED]
Sent: 08 December 2003 20:07
To: 'Schrodinger'; 'MySQL General Lists'
Subject: RE: Login Problems
Have you flushed priv's recently?
-Original Message-
From: Schrodinger [mailto:[EMAIL
There is one server that we have and that I can possible use
Dual Pentium 1.2 ghz CPU
1 gig of Ram
18 gb SCSI
0+1 Raid
What performance can I expect from this machine. What usage would it be
able to handle?
cheers
-Original Message-
From: Defryn, Guy
Sent: Tuesday, 9 December 2003
I had tips from some people here to install the complete MySQL from Server
Logistics
on my Mac OS X 10.2 and so I did (I also installed Apache 2 and PHP from
them).
Now I'm on Step one, but got stuck here. (I always get stuck while trying
this MySQL).
In the pdf-file that came along with the
Uros Kotnik wrote:
It makes sense, but Sergei G. said :
And are you sure the numbers are correct, the first query - the one
without IN BOOLEAN MODE - is faster ? I would expect the opposite.
I guess that for my DB I can't expect satisfied in boolena mode times
?
But also when searching without
Is there a way to write an if statement in mysql to affect the following?...
if field a=0,b=0,c=0 then update d='complete'
where the table consists of...
a int(1),
b int(1),
c int(1),
d char(8)
|a |b |c |d |
|1 |0 |0 |null |
|1 |1 |0
UPDATE table SET d='complete' WHERE a=0 AND b=0 and c=0;
-Original Message-
From: Larry Brown [mailto:[EMAIL PROTECTED]
Sent: Monday, December 08, 2003 3:58 PM
To: MySQL List
Subject: if function?
Is there a way to write an if statement in mysql to affect the following?...
if field
Thanks for the reply.
As you said, we can always create one if it doesn't exist.
How about using show command ? Can we execute 'show tables' command from
a program using MyODBC ? If yes, can we give a pattern to 'like' which
doesn't
match anything. i.e. show tables like 'something which will
Are you using MySQL?
OK, if you are then first simplify your query:
select date_format(dt_imp,'%Y/%m') as date,
SUM(imp)
from sp
group by 1
order by 1
Then add the AVG column which will work ok with the group by :
select
Your shell, in Terminal, is tcsh. So, when you entered `echo $SHELL`,
the response you got was /bin/tcsh. The file .tcshrc is a plain text
file where you can customize your shell (Terminal) environment. It
belongs in your home directory, as stated in the directions, not in
hello guys,
im just wondering if there are any limitations in cross database queries like:
SELECT one.* FROM db1.one, db2.two;
are there any differences in joining tables from within various databases to joinin
tables from within the same database?
the background of my question is that various
Hi,
I have a question concerning the portability of the files of the
database. Is there a way to export the content of a database from PC
(win or *NIX) to Mac ?
Great thanks
--
Mélet Pierre-Etienne
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
use mysqldump to dump all your databases.
man mysqldump should help further.
regards,
/H
On Mon, 08 Dec 2003 22:49:30 +0100
Pierre-Etienne Mélet [EMAIL PROTECTED] wrote:
Hi,
I have a question concerning the portability of the files of the
database. Is there a way to export the
Pierre-Etienne Mélet wrote:
Hi,
I have a question concerning the portability of the files of the
database. Is there a way to export the content of a database from PC
(win or *NIX) to Mac ?
Great thanks
Use 'mysqldump' to dump your database(s), and then import them into your
new computer
On 08-Dec-2003 Srinivas B.S.S wrote:
Hi,
I am a newbie to mysql db. I need a select statement which will just
execute and doesn't
return any results. Also, it should not depend on any table which is
specific to a database.
For example, Oracle has a table named 'tab' which will be
Setting up MySQL and PHP on my Mac OS X 10.2
Just made it work... well, at least I now have a databse
that I created and a table with two things inserted.
I can also see them when I do a SELECT...
So, since I know it's working, I started my DW MX
to try to work from there, but I just get an error.
hi guys,i need some help, the problem is when i try to execute a report from
vb6 the report says it cant open the server,
im using mysql 4.1, myodbc 3.51, cr8 and vb6, the strange thing is when i
open the report directly from CR it works!! =)
but when i call it from vb6 it not works =(
i have
I have another question regarding specs for a server.
I have talked to a DBA who has no mySQL knowledge but did work with
Oracle, etc
He said I should do some more investigation on disk configuration and
how mysql benefits from
Separating log files, data files, etc.
All feedback welcome!
hi!! im again i found the aswer to my problem in this site
http://www.necrug.org/Crystal-Training/crystal-forum-message.asp?site=topic
id=2244
for all who also have the same problem
=)
-Mensaje original-
De: Rick [mailto:[EMAIL PROTECTED]
Enviado el: Lunes, 08 de Diciembre de 2003
We are running MySQL 3.23 in production, and have replication
setup in the following manner: There are two machines (m1 and m2).
Replication is setup in a circular way. Both machines are master and
slave, more specifically, m1 is master to m2 and m2 is master to m1.
I checked today and saw that
.
I'm new to MySQL joins with PHP and I can't get this to work - and I don't
understand *why* it won't work.
Table 1 - Countries - has fields: country
Table 2 - Properties - has fields: area, reference_number
Table 3 - Images - has fields: image_filename, reference_number
The first page goes -
From: fatblokeonbike [mailto:[EMAIL PROTECTED]
$Query=SELECT properties.area, images.image_filename FROM
properties,
images WHERE properties.reference_number=images.reference_number AND
properties.area=$id;
but it doesn't work - I get the usual ...not a valid MySQL
result resource
Greetings,
I am having a difficult time understanding my replication error. I have
two mysql installs both 3.23.54. I executed the following for my
replication setup.
On master:
- stop mysql
- add the following to my.cnf:
[mysqld]
log-bin
server-id=1
- tar up data dir, copy to slave
-
.
$Query=SELECT properties.area, images.image_filename FROM
properties,
images WHERE properties.reference_number=images.reference_number AND
properties.area=$id;
but it doesn't work - I get the usual ...not a valid MySQL
result resource
If you can help, thanks in advance.
If $id is a
Hi Iain,
Did you alter the tables since your original message? In the original
message, you didn't have a caption column in the properties table. It
might be easiest if you showed us your current table structures and partial
data, like this:
Countries
+--+---+
|
I've got an application that uses a fairly large (~50MM rows, ~1GB of
disk) table of read-only data. The table changes maybe once a month,
but when it changes, (almost) EVERY row in the table changes.
The app needs to be replicated into several datacenters worldwide
using relatively slow backend
Hi All,
I want to create a small database that allows a user to populate a report by
choosing many different parameters whcih are linked to a variety of images
and text entries. The front end would be HTML/ASP based and would feature
several choices that the user makes to define what is included
Hopefully someone can help me out with this -
I have two tables in mySQL: comments and diary
I want to populate a new field in comments with the current values of diary
- but only if they meet certain criteria.
Now, the problem is this - my webserver is using an older version of mySQL
that
Hello Greg,
I think mySQL would work great for this application. Using PHP would
be another language to keep in mind when developing your project, but
it seems like it should be well within the capablities of mySQL.
Jeff Homan
JCS Web Hosting
http://www.jcswebhosting.com
On Tue, 9 Dec 2003
Hello Lemasson.
Monday, December 8, 2003, 8:16:18 PM, you wrote:
LS I have a table witch has a column of type VARCHAR(10)
LS BINARY. When I tried to insert white spaces in it (insert into
LS mytable (mycolumn) values('')), an empty String is stored. Why?
This is a documented behavior:
Thanks for the reply. It just have to be no-op and it need not
necessarily be
a select statement. Any one of the options given by you will work for me if
they are executable from a program written using MyODBC.
Thanks,
Srinivas.
Don Read wrote:
On 08-Dec-2003 Srinivas B.S.S wrote:
Hi,
I am
You need not select a table in MySQL as you do in Oracle.
Select 2 + 2;
Is valid in MySQL and should return 4. It at least lets you know if
MySQL is functional. By mysqladmin ping will do that too.
Steve Cersosimo
[EMAIL PROTECTED]
Bellsouth Internet Services
When all is said and done, more is
Hi all,
Can any one tell me the command to list all mysql users ???
Thanks in advance
Binay
76 matches
Mail list logo