if you want to use excel i suppose you have also windows with more than 3 GO
free disk.
install win32 mysql
put the files in the data directory of one existing database
connect and use that database
export data to an outfile by :
select * from yourtable into outfile csv fields terminated by
Hi all you mysql gurus,
I have 400 000 unique strings where each and every one of these strings are
associated with 1 - 50 (appr.) integer values.
Now, pretty simple for you guys I guess, but how will I design my
database to make a search interface against this data as rapid as possible?
My
I tried the SHOW GRANTS statement
SHOW GRANTS FOR 'dtk10mv'@ 'localhost'
and got this:
Grants for [EMAIL PROTECTED]
GRANT SELECT, SHOW DATABASES, CREATE TEMPORARY TABLES, LOCK TABLES ON *.* TO
'user1'@'localhost' IDENTIFIED BY PASSWORD '08862e71234184bc'
GRANT UPDATE (column1) ON database1.table1
Hello,
I was wondering if there is any way to get SELECT result with
`table_name.col_name` column names.
It seems to me that I have had such result set before (Not with my
current installation/configuration / :4.0.23_Debian-4). ( I know about
column aliases, but is this a the best or the only
Hello,
I am writing a program for packet sniffing in Linux platform using C
language. I am using MYSQL as my database for storing packet information like
IP, port, packet payload, etc. I have created a table using the following query:
create table idsmatch(sip text,sport integer,dip
Dear Fellows,
How to deal with the following error:
regards
mysqld-nt --console
050608 11:12:42 InnoDB: Operating system error number
1453 in a file operation.
InnoDB: See http://www.innodb.com/ibman.html for
installation help.
InnoDB: Error number 1453 means 'Unknown error'.
InnoDB: See
Ashok Kumar wrote:
Sorry. I think i gave some unwanted info in my query.
C-CGI is nothing but - CGI is scripting lang like
JScript and its mainly for web related applications.
we can use this scripting in any languages. i had
chosen VC++ - Console appln.
In this i used MySQL C-API to
Wrong path, you are referring to an uri, not a path. Way off topic to
starting explaining basic file system stuff here.
You should be the same path you used when your uploaded the
file. Something like:
/home/chris/datafile.txt
Frank
At 10:06 PM 6/7/05, Chris wrote:
Well, in
Hi,
snprintf(query_length,query,
INSERT INTO
idsmatch(sip,sport,dip,dport,HEX(payload))VALUES('%s',%d,'%s',%d,'%s'),
inet_ntoa(ip-saddr),dbsport,inet_ntoa(ip-daddr),dbdport,temp);
--
Philippe Poelvoorde
COS Trading Ltd.
--
MySQL General Mailing List
For list archives:
Tommy Svensson \(InfoGrafix\) [EMAIL PROTECTED] wrote on 06/07/2005
04:49:09 PM:
Hi all you mysql gurus,
I have 400 000 unique strings where each and every one of these strings
are
associated with 1 - 50 (appr.) integer values.
Now, pretty simple for you guys I guess, but how will I
On Tuesday 07 June 2005 04:22 pm, Kevin Burton wrote:
Subqueries in 4.1 are totally broken. They don't use indexes. They're
evil. We're told we have subqueries but there's no way anyone on earth
could use them. To make matters worse a lot of developers are TRICKED
into using them and
Uh-oh ;-)
I think you put the HEX in the wrong part. Shouldn't it be in the VALUES
clause?
snprintf(query_length,query,INSERT INTO
idsmatch(sip,sport,dip,dport,payload)
VALUES('%s',%d,'%s',%d,HEX('%s')),
inet_ntoa(ip-saddr),dbsport,inet_ntoa(ip-daddr),dbdport,temp);
Shawn Green
Database
Hello.
I can see such behavior in test database because mysql.db table
has records which allows updates to any user, and database
privileges ORs with global privileges. Send us the contents
of your privileged tables. See:
http://dev.mysql.com/doc/mysql/en/request-access.html
Upgrade to
Hello.
It seems not at the moment. See discussion at:
http://bugs.mysql.com/bug.php?id=9056
Juri Shimon [EMAIL PROTECTED] wrote:
Hello mysql,
Is mysqldump from 5.0 dumping a stored procedures?
If it isn't, then when (if planned)?
--
For technical support contracts,
Hello.
According to:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/debug/base/system_error_codes.asp
It is ERROR_WORKING_SET_QUOTA. 1453Insufficient quota to complete the
requested service. Check your disk quota.
A Z [EMAIL PROTECTED] wrote:
Dear
No, I don't have Windows.
I need some one to load my tables, export to excel and email me the
excel docs.
On Jun 7, 2005, at 11:54 PM, [EMAIL PROTECTED] wrote:
if you want to use excel i suppose you have also windows with more
than 3 GO
free disk.
install win32 mysql
put the files in the
[EMAIL PROTECTED] wrote:
Uh-oh ;-)
I think you put the HEX in the wrong part. Shouldn't it be in the VALUES
clause?
snprintf(query_length,query,INSERT INTO
idsmatch(sip,sport,dip,dport,payload)
VALUES('%s',%d,'%s',%d,HEX('%s')),
Hi.
I need to index about 300 million 20-byte records, but it takes
forever (it isn't finished yet, after almost 24 hours, so I don't have
actual numbers).
I'm using RHEL, kernel 2.6.9, Mysql 4.1.11, MyISAM table, on a dual
Xeon with 4GB RAM and IDE disks. I'm using the following values from
Hi,
Another question, to help me better understand MySQL indexing:
In MyISAM, does DISABLE INDEX followed by insertions and then
ENABLE INDEX freeze the original index and batch-updates it, or does
it drop it completely and recreate it from scratch?
--thanks, Roi
--
MySQL General Mailing List
Hi guys.
I'm having a problem deciding whether a left join is suitable for what i
want to do.
I have two tables
A Users
-userID
-isactive
B BuddyList
-userID
-buddyID
what i want to do is to get all the users from A that don't exist as a
buddyID for a user (buddyList) also the user must be
In the last episode (Jun 08), Jeff Smelser said:
On Tuesday 07 June 2005 04:22 pm, Kevin Burton wrote:
Subqueries in 4.1 are totally broken. They don't use indexes.
They're evil. We're told we have subqueries but there's no way
anyone on earth could use them. To make matters worse a lot
Angelo Zanetti [EMAIL PROTECTED] wrote on 06/08/2005 12:06:51 PM:
Hi guys.
I'm having a problem deciding whether a left join is suitable for what i
want to do.
I have two tables
A Users
-userID
-isactive
B BuddyList
-userID
-buddyID
what i want to do is to get all the users from A
On Wednesday 08 June 2005 10:56 am, you wrote:
In the last episode (Jun 08), Jeff Smelser said:
On Tuesday 07 June 2005 04:22 pm, Kevin Burton wrote:
Subqueries in 4.1 are totally broken. They don't use indexes.
They're evil. We're told we have subqueries but there's no way
anyone on
[snip]
Thats funny.. looks like it will be added to 5.1.. Dunno why they think
fixing
it is adding a feature..
[/snip]
The best open-source database on the market today? Free
Constant improvements to database? Free
Ability to complain when we don't get what we want? Priceless
--
MySQL General
Angelo Zanetti [EMAIL PROTECTED] wrote on 08/06/2005 17:06:51:
Hi guys.
I'm having a problem deciding whether a left join is suitable for what i
want to do.
I have two tables
A Users
-userID
-isactive
B BuddyList
-userID
-buddyID
what i want to do is to get all the users from
thanks shawn it seems to be working but i forgot to add that i need it
for a single user ID, in other words it must bring back all user ids in
the user table if they do not exist for that user in the buddylist.
so what i've tried is this:
SELECT u.* FROM users u LEFT JOIN buddylist bl ON
I would increase your myisam_sort_buffer_size considerably just for
this operation. You've got your key_buffer set high, but your sort
buffer is comparatively low for creating a big index.
One way you can tell how far along the index is, is to look at how
quickly the index file is growing and
By the way, I am using 4.0.18-log on i686.linux2.6.10.
Greetings,
I did the following two explain select ... According to whether I put
the single quotation mark or not, I will get totally different results:
1. Without single quotation mark:
explain SELECT * FROM test T1 force index
On Wednesday 08 June 2005 11:16 am, you wrote:
[snip]
Thats funny.. looks like it will be added to 5.1.. Dunno why they think
fixing
it is adding a feature..
[/snip]
The best open-source database on the market today? Free
Constant improvements to database? Free
Ability to complain when
Greetings,
I did the following two explain select ... According to whether I put
the single quotation mark or not, I will get totally different results:
1. Without single quotation mark:
explain SELECT * FROM test T1 force index (idx_test)
WHERE *T1.STUDID = 099 AND T1.Prog_link =
In the last episode (Jun 08), Ying Lu said:
By the way, I am using 4.0.18-log on i686.linux2.6.10.
I did the following two explain select ... According to whether I put
the single quotation mark or not, I will get totally different results:
1. Without single quotation mark:
explain
[snip]
On Wednesday 08 June 2005 11:16 am, you wrote:
[snip]
Thats funny.. looks like it will be added to 5.1.. Dunno why they
think
fixing
it is adding a feature..
[/snip]
The best open-source database on the market today? Free
Constant improvements to database? Free
Ability to complain
[snip]
Thats funny.. looks like it will be added to 5.1.. Dunno why they think
fixing
it is adding a feature..
[/snip]
The best open-source database on the market today? Free
Constant improvements to database? Free
Ability to complain when we don't get what we want? Priceless
MySQL
On Wednesday 08 June 2005 11:49 am, you wrote:
Easy there boss, I was just responding to the thread and meant no
offense. I saw the whole thing as funny.
Oh.. email sucks that way..
My apologies as well..
Jeff
pgpvHgJLsGjaw.pgp
Description: PGP signature
Angelo Zanetti wrote:
thanks shawn it seems to be working but i forgot to add that i need it
for a single user ID, in other words it must bring back all user ids in
the user table if they do not exist for that user in the buddylist.
so what i've tried is this:
SELECT u.* FROM users u LEFT JOIN
Jay Blanchard wrote:
[snip]
On Wednesday 08 June 2005 11:16 am, you wrote:
[snip]
Thats funny.. looks like it will be added to 5.1.. Dunno why they
think
fixing
it is adding a feature..
[/snip]
The best open-source database on the market today? Free
Constant improvements to database? Free
Let me rewrite what it's meant to do as i mgiht not have been clear.
ok for a single user I want to get all the users (from the user table)
that aren't a buddy for that user.
users
1 bob
2 tom
3 mike
buddylist
1 2
1 3
2 1
2 3
3 1
//therefore if i searched for mike it would return tom as he
Chris wrote:
Thank you for your detailed response.
You're welcome.
It seems my problem is trying to define the path to my data file and this is
where I seem to be missing something.
No, the problem is permissions. As I explained previously, a relative
path (one without a leading /)
Angelo Zanetti [EMAIL PROTECTED] wrote on 06/08/2005 01:38:42 PM:
Let me rewrite what it's meant to do as i mgiht not have been clear.
ok for a single user I want to get all the users (from the user table)
that aren't a buddy for that user.
users
1 bob
2 tom
3 mike
buddylist
1 2
1 3
[snip]
I personally find the idea that just because a product is free that
people are not allowed to...
[/snip]
I was just trying to fling a little humor on to the situation, not start
a flame war about who is right and what rights they do or do not have. I
too believe that criticism, in the
[EMAIL PROTECTED] wrote:
Michael's last answer:
SELECT u.UserID
FROM Users u
LEFT JOIN BuddyList bl
ON u.userID = bl.buddyID
AND bl.userID = '$userid'
WHERE u.isactive =1
AND bl.userID is null;
Should do all of what you want except exclude the original user (so that
Using MySQL 4.0.24 with PHP 4.3.11
I have the following code:
if($queryID = mysql_query(SELECT * FROM WhInventory WHERE Match(Booking)
AGAINST (' . mysql_escape_string($form['booking']) . ' IN BOOLEAN MODE)
ORDER BY Booking,$dbLink)) {
Which works fine if I have an exact entry but fails for
Although it was nice to hear a few versions ago that they were thinking
about adding this, I did not think it was absolutely necessary. There are
many other ways to handle embedded queries. You can also offload some of
the server side work by doing so. Depends on how you use it I suppose.
As far
I need to come up with a high availability, high performance MySQL
server setup. I have two database servers half way across the country
from one another being replicated through a VPN. These db servers serve
two very busy web sites with multiple applications accessing the db.
During busy
Hi All,
I had posted a query few days back that I couldn't connect to mysql database
from a network machine. So for that I added two entries in my firewall
exceptions.
I added the Port 3306 and mysqld, so firewall should allow any connection to
database from external computer. My problem
You can try
if($queryID = mysql_query(SELECT *
FROM WhInventory
WHERE Booking like ('%15%')
ORDER BY Booking,$dbLink))
-Original Message-
From: Don [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June
Tried that but no luck.
What I want is a search that will look for '15' (for example) in the
field BOOKING.
So if I enter '1' in my search field, it will find all instances of BOOKING
with a '1' in it.
Conversely, if I enter '12345' in my search field, it will find all
instances of BOOKING
Maybe a good question to ask is where can I find documentation on:
MySQL WHERE where_definition
Specifically, all the options available for the 'where_definition'
-Original Message-
From: Don [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 08, 2005 3:40 PM
To: mysql@lists.mysql.com
[snip]
Tried that but no luck.
What I want is a search that will look for '15' (for example) in the
field BOOKING.
So if I enter '1' in my search field, it will find all instances of
BOOKING
with a '1' in it.
Conversely, if I enter '12345' in my search field, it will find all
instances of
[snip]
Maybe a good question to ask is where can I find documentation on:
MySQL WHERE where_definition
Specifically, all the options available for the 'where_definition'
[/snip]
http://www.mysql.com/select should do it
--
MySQL General Mailing List
For list archives:
Here are the string functions. LIKE and RLIKE are useful for partial
string searches:
http://dev.mysql.com/doc/mysql/en/string-comparison-functions.html
RLIKE uses a variation of regular expressions. Here is the syntax MySQL
uses:
http://dev.mysql.com/doc/mysql/en/regexp.html
This section
Dear All, I have two tables entity1 and entity2; the second one should
contain only data with the same PLZ as listed in table entity1.
Unfortunately, I am able to insert in table entity2 data in the field PLZ,
different from those in the field PLZ in the table entity1.
What is going wrong?
Many
A long time ago when I was doing support for Lotus Notes, I was told that
the customer who 'complains' about legitimate bugs may be the most valuable
type of customer of all. This is because they care enough to vent. Who
knows how many unhappy customers one has if none ever complain? What if
Hello.
Error 2013 means: Lost connection to MySQL server during query. See:
http://dev.mysql.com/doc/mysql/en/gone-away.html
rtroiana wrote:
Hi All,
I had posted a query few days back that I couldn't connect to mysql
database
from a network machine. So for that I
Please tell me there is a way to fix this bug in mysql Ver 12.22 Distrib
4.0.18, for pc-linux-gnu (i686)
I have a column defined like so:
Type
enum('Schedule','Report','Admin','Search','General','License','Access')
If I SELECT, and ORDER BY Type, it is ordering in the order defined by the
the
It's not a bug at all. You just hit one of the features of enum :)
If you want to order alphabetically as you describe cast the enum name
to a string like this
select col from t order by concat(my_enum);
-Eric
Daevid Vincent wrote:
Please tell me there is a way to fix this bug in mysql
Is anyone familiar with how to dump a database from Microsoft sequel server
to mysql? I know nothing about Microsoft products and am looking for a
utility or similar to do the conversion. Maybe Microsoft has something
built in? Although I doubt it.
TIA
Kirk
--
MySQL General Mailing
Kirk wrote:
Is anyone familiar with how to dump a database from Microsoft sequel server
to mysql? I know nothing about Microsoft products and am looking for a
utility or similar to do the conversion. Maybe Microsoft has something
built in? Although I doubt it.
There are tools around - some
Import via odbc ?
I used an app called sqlyog to import via odbc.
On 09/06/2005, at 9:45 AM, Kirk wrote:
Is anyone familiar with how to dump a database from Microsoft sequel
server
to mysql? I know nothing about Microsoft products and am looking for a
utility or similar to do the
Jeff Smelser wrote:
Thats funny.. looks like it will be added to 5.1.. Dunno why they think fixing
it is adding a feature..
WOW! That's just insane! This seriously has to be fixed in 5.0 or sooner...
The thing is that MySQL has both promised this feature and is claiming
that 5.0 is now
Greg Whalin wrote:
Granted, Kevin's tone was a bit harsh, but his sentiments should be
encouraged (frustration w/ a lack of feature). The concept that
people should be happy with what they get for a free product only
serves to keep the quality of free products below what they could be.
It
I think MySQL has a little ways to go yet before I would subjectively call
it best.
I posted twice to the list with questions about porting my application that
runs on (SQL Server, Oracle, PostgreSQL, Sybase SQL Anywhere, MS Access, and
DB2) to MySQL. No one on the mysql list, or the internals
Ashok Kumar wrote:
Hi Peter,
If i give the localhost/IP addr, How can i set the
security previleges in my server/system( i have
installed apache server to run the scripts). as i told
earlier i'm using win2000 os, its expecting lot of
securitie prevleges. i can't find those settings. if u
ANNOUNCEMENT:
A RFD (REQUEST FOR DISCUSSION) has been posted for the creation of a
new Usenet newsgroup: comp.databases.mysql
The proposal and related discussion can be read in the Usenet group
news.groups ... feel free to weigh in and make any suggestions you
may have.
Message-ID:
I use Mysql 4.0.22.
When I press show innodb status,I got the error message:
ERROR 1105: Unknow error
what's the problem?
Is the innodb enable in 4.0.22 by default? How can I check if the innodb
enable or not?
_
MSN Messenger:
65 matches
Mail list logo
