Now that MySQL 4.0.2 has been released, does anyone know if Support for
always-index words is available?
This is mentioned in the todo:
http://www.mysql.com/doc/F/u/Fulltext_TODO.html
'Support for always-index words. They could be any strings the user wants
to treat as words, examples are C++,
I am using Mysql Db that contains Isam table types,I
am developing a project
that is using interrelated tables,unfortunatily isam
table type doesn't support
the commit and transaction,but i should implement
that,can anyone give a
logic for that
thanks in advance
with regards
chandar
www.mysqlfront.de
- Original Message -
From: Thomas Edison Jr. [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, July 10, 2002 1:27 PM
Subject: Connectiing mySQL db on Localhost to mySQL DB on Server
Hi,
I would like to export Table Data which is on my
localhost mySQL Server,
why not using innodb tables ?
smart chandar wrote:
I am using Mysql Db that contains Isam table types,I
am developing a project
that is using interrelated tables,unfortunatily isam
table type doesn't support
the commit and transaction,but i should implement
that,can anyone give a
logic
Hi,
Thanks for ur reply.
When i commented out the mysql_data_seek() function, mysql_fetch_row()
returns me a non-NULL value (this should be the first row from the MResult).
This results show that I've a valid connection and/or query. And when I
call mysql_fetch_row() again (retrieving the 2nd
Hello,
I just start trying building a program in C++ using MySQL++ API.
I want to use sql_create_basic_n macros to manage results of queries on my
database.
So I defined structures using this macro based on the tables of the db.
for example, in the db I have a table defined as follow:
Hi,
We updated one of our slave servers to 3.3.51 from 3.23.38 and in common
with lots of other posts i've seen we're getting lots of errors where the
slave loses the connection to the master:
020710 7:24:05 Error reading packet from server: (server_errno=1159)
020710 7:25:05 Slave: Failed
Hi,
If i understand well you use twice mysql_data_seek.If you use
mysql_data_seek() after mysql_fetch_row() the effect is NULL.
Because mysql_data_seek() (in fact) set the cursor (if we can said like
this...) in the MResult (MYSQL_RES) and not in the row (MYSQL_ROW).
Regards,
Gelu
Seems fairly impossible to me to really emulate transactions on a
non-transactional db.
Even if you develop a system where you :
a. collect all queries untill the end and then perform them in 1 block
b. keep your own logs of the queries and be able to roll them back in case
of error
even then it
Hi all.
Which is the best journaling file system for mysql and innodb?
Ext3 or Reiserfs?
Innodb needs a journaling file system or is better use ext2?
Iago.
-
Before posting, please check:
http://www.mysql.com/manual.php
Hi,
Continuing my troubles with AUTO_INCREMENT (which nobody has yet
responded to), I've now ruled the Perl DBI out of the equation and
reproduced the same problem using the mysql.exe command-line tool.
Hopefully somebody will be tempted to help this time now that there is
no Perl involved
o
POWER( (monto+12), 2 )
o
POW( (monto+12), 2 )
- Original Message -
From: Daniel BI [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, July 10, 2002 10:16 AM
Subject: Re: [mysql] Elevar un numero a potencia
(monto+12)*(monto+12)
:)
- Original Message -
From: Hernan
Hi Gelu,
Thnx for the prompt reply.
I called mysql_data_seek() once and I called it before mysql_fetch_row().
With this, mysql_fetch_row() returns NULL row.
Then I decided to check if the connection (and query) is valid by commented
out mysql_data_seek(). I called only mysql_fetch_row() and
[EMAIL PROTECTED] wrote:
Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To bypass the filter you must include
one of the following words in your message:
sql,query
If you just reply to this message, and include the entire text of it in the
Thanks Chuck!
The last example you gave looked just right, but when I ran it, it returned
an error.
A quick look at the mysql manual revealed that UNION SELECTs are on the TO
DO list for mysql :(
With the examples you provided though, I was able to create the following
statement which returns
Hi,
If i understand well, mysql_fetch_row() work fine but if you add
mysql_data_seek() the row is NULL.
...you use pointers when declare variables ?In my pre-previuos e-mail i fill
what (i considered) it's not was OK.
MYSQL_RES *MResult;
MYSQL_ROW *row;
MYSQL *MQuery;
instead...
MYSQL_RES
is there any debian package of mysql supporting innodb ?
thanks,
Pierre
--
sql,query
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list
There is a script for RH Linux for each day automatic full backup of mysql
databases?
(the results may be like: backup_mmdd.sql, so it can be easily imported)
tx in adv for any help
-
Before posting, please check:
Hi,
If i have two seperate mySQL Tables in my database,
with some information.. and i would like to connect
the two tables so as to get Relevant Data picked up
from the relevant Table and it's relevant fields.
Do we need to use a Foriegn/Primary key for this
purpose? If so, how do you use
hi guys
im sure theres a function to check for a valid email address entered by user
before storing it into the db but i cant locate it in php manuel NOR in
mysql manuel
will someone plz tell me bout it ?
thnx a million
toby .
JvdW,
Tuesday, July 09, 2002, 3:03:17 PM, you wrote:
J I have a quick newbie question. How would I limit the size a database can grow
J to in mysql? Let's say I want to limit my database to 20MB. How would I do
J this? Would this be done on a user level or the actual database?
You can't do it
oliver,
Wednesday, July 10, 2002, 2:33:06 AM, you wrote:
Description:
o I was trying to find every row in a table which contains the umlaut
o ü (ue). MySQL listed every row which contained the umlaut and rows
o which contained the letter y, but no umlaut... Client and
Thomas,
Wednesday, July 10, 2002, 8:27:06 AM, you wrote:
TEJ I would like to export Table Data which is on my
TEJ localhost mySQL Server, to a Table in mySQL on the
TEJ Internet Web Server. How can i do that? Basically it's
TEJ just moving mySQL Table Data from localhost to web
TEJ server on the
Thomas,
Wednesday, July 10, 2002, 1:15:35 PM, you wrote:
TEJ If i have two seperate mySQL Tables in my database,
TEJ with some information.. and i would like to connect
TEJ the two tables so as to get Relevant Data picked up
TEJ from the relevant Table and it's relevant fields.
TEJ Do we need
robbat2,
Wednesday, July 10, 2002, 7:01:39 AM, you wrote:
r Description:
r I have been writing an SQL tokenizer for the phpMyAdmin project, on which I
am a core developer.
r I used this page (Manual 6.1.2 Database, Table, Index, Column, and Alias Names) for
reference
r as to what a
hi,
I'm trying to get Visio work with mysql to get a visual representation of
my data base.Visio asks for a 'Visio Database Driver' for mysql.Does
anyone know if such a driver exists or if what I;m trying to do can be
done or not?
Thanks,Aris
Hi Gelu,
Yes, you are right in getting my problem.
I tried using pointers when declaring the variables
MYSQL_ROW *row;
MYSQL *MQuery;
However, I do not get the desired result too.
Besides pointer, do you know any other possible mistakes?
Really appreciate your response.
wv
Is there a way to do pass through authentication from NT to mysql
running on linux. I looking for something like what samba does. If I
can't do that what about ldap authentication. I don't want to have to
setup a new account for all the users because a) that another account I
have to maintain
Hi,
In the MySQL documentation, it is stated that
foreign keys in SQL are not used to join tables, but are used mostly for
checking referential integrity (foreign key constraints).
Does it mean that constraints are not supported? I need to have Update and
perhaps Delete Referential Integrity.
Hi,
Resume
I understand that you use C API functions in the right order:
mysql_init()
mysql_option()
mysql_real_connect()
mysql_real_query()
mysql_store_result()
mysql_data_seek()
mysql_fetch_field()
mysql_fetch_row()
mysql_free_result()
mysql_close()
Question :
What version of libmysql.dll and
Can your INT id be overflowing, i.e. reaches the max value for int and
starting at 1 again?
Rich
- Original Message -
From: Steve Hay [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, July 10, 2002 4:12 AM
Subject: Bug with AUTO_INCREMENT
Hi,
Continuing my troubles with
I was starting to write something in JSP which would run under TOMCAT.
I don't think I'll bother now - this looks cool.
Here is the link http://www.anse.de/mysqlfront/
Nice one!!
Regards thanks Cesar
Kevin
-Original Message-
From: César Aracena [mailto:[EMAIL PROTECTED]]
Sent: 10
Richard Fox wrote:
Can your INT id be overflowing, i.e. reaches the max value for int and
starting at 1 again?
Rich
I don't think it is because (a) the last value that was successfully
INSERT'ed - usually around 40,000-odd - is well short of the maximum
INT, and (b) it doesn't always fall
Hi all. I found in one of these DB lists a word about a tool called
MySQL - Front so I went there, downloaded it and ran it today for the
first time and well...
¡¡TWO THUMBS UP!!!
It really seems like a great GUI app. I installed it over Win XP Pro and
had no troubles with it so far.
Mihail,
Are you still experiencing these problems? We've seen the same thing
happen our 2 of our slaves. It seems to happen for a day or two and then
go away.
We've done a snoop while this happens and it looks like the master is
closing the socket to the slave. However, the master reports no
Ah! Thanks, this gave me the clue. I had to up the limit of openfiles
(csh/OpenBSD) limit openfiles 1024 (from 64) and it works like a
charm now. Thanks!
- Original Message -
From: Gelu Gogancea [EMAIL PROTECTED]
To: Steve Mertz [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Tuesday,
Microweb provides exactly that. I haven't used it, but I did research on
comparing it with running Apache from a CD-ROM. Currently I'm leaning
toward the Apache implementation, because PHP will run as a dll, rather than
through CGI. But if we need a database, I'll probably go with the Microweb
Dear MySQL User,
I am sending the table schema of 5 tables.Here pid (partner ID) is in the top layer,
aid (Affiliate ID) is in the middle layer and uid (User Id OR Customer ID) is in the
bottem layer.User may promoted to Affiliate and affiliate may promoted to partner.We
have to store there
Hi,
I have a mysql table which has a run_id which together with user_id forms
the
primary key for the table. run_id is not null and auto-increment. I delete
records from this table, and add new records. I want the run_id to keep
incrementing and not reuse values, but here is the actual
* Hanxue Lee
In the MySQL documentation, it is stated that
foreign keys in SQL are not used to join tables, but are used mostly for
checking referential integrity (foreign key constraints).
This could have been formulated in a better way, IMHO. I would even say the
statement is wrong. In
On Wed, 10 Jul 2002, Victoria Reznichenko wrote:
oliver,
Wednesday, July 10, 2002, 2:33:06 AM, you wrote:
Description:
o I was trying to find every row in a table which contains the umlaut
o ü (ue). MySQL listed every row which contained the umlaut and rows
o
Hi,
If you know very well to work with Macro and have knowledge about MYSQL
API , you can use the last version of GMySQL typelibrary.
Download from www.gonetsoftware.com/gmysql
If you have any question about GMySQL , e-mail me.
Regards,
Gelu
is it possible to start a server in 'read only' mode ?
so that users cannot write in my slave server ?
thanks,
Pierre
--sql,query
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
Set variable net_read_timeout to some bigger value.
http://www.mysql.com/doc/S/H/SHOW_VARIABLES.html
Nilesh Shah
-Original Message-
From: Mark Hughes [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 10, 2002 3:36 AM
To: [EMAIL PROTECTED]
Subject: Replication - Error reading packet
Here's a trivial example. Run something like this out of cron every
night.
--- cut
#!/bin/sh
DATE=`/bin/date +%Y-%m-%d`
mysqldump -u root -p [password] --all-databases --opt \
/path/to/large/partition/backup_${DATE}.sql
--- cut
-Original Message-
From: adi [mailto:[EMAIL
That is the normal behavior for ISAM type files.
Convert them to MYISAM.
Richard Fox wrote:
Hi,
I have a mysql table which has a run_id which together with user_id forms
the
primary key for the table. run_id is not null and auto-increment. I delete
records from this table, and add new
Thomas Spahni wrote:
Steve,
I tried your example on MyIsam tables; no problems with auto_increment at
all, except for a few
ERROR 1040: Too many connections
when 100 scripts are inserting concurrently at full speed.
Thomas
I've tried the same myself on MyISAM tables as well now, and I also
On Wed, 10 Jul 2002, Steve Hay wrote:
Richard Fox wrote:
Can your INT id be overflowing, i.e. reaches the max value for int and
starting at 1 again?
Rich
I don't think it is because (a) the last value that was successfully
INSERT'ed - usually around 40,000-odd - is well short of the
Hi,
i have a table with 2000 rows.
One column (name answer)has a string (ok --) in all the rows.(e.g ok --
yes we support this.).
now i want to remove all these 'ok --' in this column..leaving(e.g yes we
support this)
I tried to do it with the replace query but being a newbie to mysql i
couldnt
Hey can someone provide me some help in installing and configuring mysql ver3.23.51 on
my Linux server? I downloaded the file from mysql.com to my servers hard drive and now
want to install it. I right-clicked the installation file and clicked install. It
appears to have installed something,
I was trying to connect into an MYSQL database, and I keep getting the error
message
Can't connect to MySQL server on '10.10.10.250' (10054)
but I know that the database is running and I can connect fine on the server
itself!
Any suggestions would be greatly appreciated.
Hi there,
I would like to find out the top 10 of some ratings. There are 2 columns.
One for the rating and one for the amount of ratings.
To find out the top 10 I would have to divide those 2 values and sort it.
Somehow this does not work. I do not have a clue why. Maybe someone of you
guys do
OK THANKS,
read to config.log, change some options...
-Message d'origine-
De : Ismael Touama [mailto:[EMAIL PROTECTED]]
Envoyé : mardi 9 juillet 2002 18:54
À : [EMAIL PROTECTED]
Objet : Error at compilation...can I ingore ?
Oï,
I just configure my Makefile (is that the good one ?),
Hi. When I use a select to extract information of two tables using inner
join the time response is slowly.
Thanks
Carlos Rovetto
P.d: I use Visual Basic 6.0 with ODBC to work with MySQL
From: Thomas Edison Jr. [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: How to Connect two mySQL Tables
This is somewhat OT here, but you may try Killersoft.com:
http://www.killersoft.com/print.php?sid=2
On Wednesday 10 July 2002 08:08, toby - wrote:
hi guys
im sure theres a function to check for a valid email address entered by
user before storing it into the db but i cant locate it in
This question relates to both mysql in general and the mysql++ C++ API in
particular, thus the adressing to both lists.
I have a DateTime object (really a formatted string) say 2002-07-10
11:38:38. I want to subtract some variable number of hours (from 0 to 11)
from it. How do I accomplish this
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Steve Hay wrote:
| Thomas Spahni wrote:
|
| Steve,
|
| I tried your example on MyIsam tables; no problems with auto_increment at
| all, except for a few
|
| ERROR 1040: Too many connections
|
| when 100 scripts are inserting concurrently at full
Thanks, I had a look at that and it seems that slave_net_timeout is the
variable that should be used and this is set to 3600 seconds - however it
appears that the net_read_timeout is being used and by changing this from
30 to 3600 seconds the messages seem to have gone away.
In the 3.23.38
Are you using RPM or installing from source, i.e. running make? Also if you
need to find where files are located change to root directy cd / then
type find -name mysql that will get you started as to where your mysql
files are located. The find command is very helpful when searching for
On Wednesday, 10. July 2002 18:13, Anil Garg wrote:
Hi!
I tried to do it with the replace query but being a newbie to mysql i
couldnt find the right syntax.
Can someone help.
http://www.mysql.com/doc/U/P/UPDATE.html
Regards
Georg
Do a telnet 10.10.10.250 3306
then a ctrl-] to end it.
What do you see?
-Original Message-
From: Brett Whittaker [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 10, 2002 10:29 AM
To: [EMAIL PROTECTED]
Cc: Brett Whittaker
Subject: help !
I was trying to connect into an MYSQL database,
Brett Whittaker [EMAIL PROTECTED] wrote on 10.07.2002 18:28:54:
I was trying to connect into an MYSQL database, and I keep getting the error
message
Can't connect to MySQL server on '10.10.10.250' (10054)
but I know that the database is running and I can connect fine on the server
itself!
Hi guys,
I have a problem sorting values comming out of a db. It is not as easy.
Here is the prob:
One table containing user points.
Other table containing reports with rankings
For each top 10 report (the 10 reports with the most ranking) there are 20
extra points granted
Now I would like to
-Original Message-
I was trying to connect into an MYSQL database, and I keep
getting the error
message
Can't connect to MySQL server on '10.10.10.250' (10054)
but I know that the database is running and I can connect
fine on the server
itself!
Any suggestions would be
Group,
Given the following code:
$sql = qq! select * from table where suffix1 ''!;
$db_action = $DB-prepare($sql);
$db_action-execute or die could not do $sql - $DBI::errstr;
$rows = $db_action-rows;
$rec = $db_action-fetchall_arrayref;
-Original Message-
Hey can someone provide me some help in installing and
configuring mysql ver3.23.51 on my Linux server? I downloaded
the file from mysql.com to my servers hard drive and now want
to install it. I right-clicked the installation file and
clicked install. It
On 10 Jul 2002, at 12:13, Anil Garg wrote:
One column (name answer)has a string (ok --) in all the rows.(e.g
ok -- yes we support this.). now i want to remove all these 'ok --'
in this column..leaving(e.g yes we support this) I tried to do it with
the replace query but being a newbie to
Does anyone know of an Apache Module for auth-ing against a MySQL
database? MySQL lists one on its website and its no longer
supported by the developers. I found Apache lists one that is
also not supported anymore.
mod-auth-mysql-2.20 from bourbon.netvision.il was one of the ones
not
Well, if it is read only, it won't be able to update from the master.
GRANT your users no write permission.
Pierre Baridon wrote:
is it possible to start a server in 'read only' mode ?
so that users cannot write in my slave server ?
thanks,
Pierre
--sql,query
No. You cann't have one slave connected to more than one master.
Nilesh
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 09, 2002 10:30 PM
To: [EMAIL PROTECTED]
Subject: mysql replication
Hi All,
I have 3 mysql servers with Red Hat 7.2 as the
I have a small c program that is supposed to run a select query against a
MySQL database. It keeps bombing with a segfault during what I think is the
db connect. I recompiled everything with debug and ran mysql_debug in the
code and am getting the following:
[youngd@fett]:~/src/logit $
Richard Fox wrote:
This question relates to both mysql in general and the mysql++ C++ API in
particular, thus the adressing to both lists.
I have a DateTime object (really a formatted string) say 2002-07-10 11:38:38. I
want to subtract some variable number of hours (from 0 to 11) from it.
On Wed, Jul 10, 2002 at 09:57:56AM -0700, Mark Hughes wrote:
Thanks, I had a look at that and it seems that slave_net_timeout is the
variable that should be used and this is set to 3600 seconds - however it
appears that the net_read_timeout is being used and by changing this from
30 to 3600
Does anyone know of an Apache Module for auth-ing against a MySQL
database? MySQL lists one on its website and its no longer
supported by the developers. I found Apache lists one that is
also not supported anymore.
mod-auth-mysql-2.20 from bourbon.netvision.il was one of the ones
not
Woops, sent this to support. Sorry Support!
-Original Message-
From: Luc Foisy
Sent: Wednesday, July 10, 2002 1:37 PM
To: 'Mysql-Support (E-mail)
Subject: RE: calculating inside query
-Original Message-
Hi there,
I would like to find out the top 10 of some
I've sent a couple of messages to the MySQL list today that didn't seem to
get through. Have there been any problems with the list and/or the manager
today? One of them was returned as being too large to be posted and it
really wasn't all that long. One of them never made it through and was never
One of our servers (of many running the same software and mysql version) is
frequently getting
ERROR 1030: Got error 127 from table handler
on two of its tables.
mysql version is 3.23.49.
We can not recover with myisamchk -r, but instead have to use myisamchk -o
which ends up wiping
Yeah, I'm getting these errors all the time on 3.23.51, also. I agree that
the slave_net_timeout variable is definitely not being paid any attention.
However, I'm not comfortable just upping the net_read_timeout without
knowing what other effects it might have.
--jeff
- Original Message
I was wondering if anybody heard about a possible release of books that help you
prepare for the Mysql certification?
Cheers
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
Dear Dan,
Thanks for your timely help. Yes, removing the concatenation has reduced the
running time nearly 10 times . So finally my sql looks like the below,
SELECT distinct
Is there a web-based interface for bug reporting? Or is there a way to use
the mysqlbug program when my database machine isn't connected to the
internet?
Thanks,
--jeff
- Original Message -
From: Jeremy Zawodny [EMAIL PROTECTED]
To: Mark Hughes [EMAIL PROTECTED]
Cc: Nilesh Shah [EMAIL
I have about 40,000 email addresses in a MySQL database.
I also have a list of 1500 email addresses that need to be removed.
I am searching for a way to delete these 1500 email addresses en masse,
but I have come up short.
I sure would appreciate a nudge in the right direction from somebody
So, I had mysql up and running a week ago, but at some point the
system on which it was installed was rebooted. Now when I try to connect
I get a Cannot connect through socket 'var/lib/mysql/mysql.sock' error
message. I've read some of the archives and found similar problems. The
On Wed, Jul 10, 2002 at 03:13:55PM -0700, Jeff Kilbride wrote:
Is there a web-based interface for bug reporting? Or is there a way
to use the mysqlbug program when my database machine isn't connected
to the internet?
You can submit a but directly to [EMAIL PROTECTED] If your
message
running the script 'safe_mysqld ' should start the server.
- Original Message -
From: Alex Jarvis [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, July 10, 2002 3:21 PM
Subject: can't connect
So, I had mysql up and running a week ago, but at some point the
system on which it
You can tell if the server is running by looking at the process list. There
should be at least 1 mysqld process.
You can also do a
'mysql -S /path/to/socket/file' if it cannot find the file.
-Chait
-Original Message-
From: Alex Jarvis [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July
Using Linux/Unix I'd say:
echo SELECT concat('DELETE FROM mailtab WHERE
mailaddress=',mailaddress,';') FROM mailtab WHERE some strange
conditions here | mysql db | mysql db
[EMAIL PROTECTED] wrote:
I have about 40,000 email addresses in a MySQL database.
I also have a list of 1500 email
why is it that this doens't work?
INSERT INTO mytable (column0, column1, column2, column3, column4) values
($value0, (SELECT id from othertable where login='$ENV{REMOTE_USER}'),
$value2, $value3, $value4);
the error i'm getting says that there's an error in my sql syntax near
'select id from
personally, i'd just use perl:
my @deademails = (long, list, of, emails);
take the output of:
select email from table
drop that into another array (@allemails)
then do a for loop through all the emails
checking to see if each line of @allemails matches any line of @deademails
if it does
Both my slave server say they are replicating correctly in the
mysqld.log but they arn't. Any change made to the master is not
reflected to the slaves. I have tried reseting the master and slaves but
didn't change anything. Also tried redumping the databases to the slaves
but that didn't effect
Not surprisingly, I'm still confused. Could you hold my hand?
Here's what I've got --
This is my table --
CREATE TABLE churchmail (
email varchar(30) NOT NULL
);
It has one field containing 40,000 email addresses.
I have a text file -- remove.txt, which contains 1,500 email addresses
Easy question I hope, relatively new user ( 6 months) here wanting to know
how to fashion a MySQL
select statement based on the following:
there is a list of managers and their email addresses. This list changes
all the time as we add and subtract different companies from the db. I
would like
Use SELECT DISTINCT.
Matthew Scarrow
ComIT Solutions Inc.
www.comit.ca
Phone: 519-442-0100
Fax: 519-442-0429
-Original Message-
From: Kirk Babb [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 10, 2002 9:59 PM
To: [EMAIL PROTECTED]
Subject: help with MySQL SELECT statement
Easy
wait, how will the MySQL SELECT DISTINCT pick only one between these two
addresses (as an example):
[EMAIL PROTECTED]
[EMAIL PROTECTED]
I only need one email address each for alltel.com, one for ualr.edu, one for
target.com, etc. when there might be 50 email addresses from each of those
When running ./configure I am getting the error no termcap libraries but in
/usr/lib/termcap the libs are there. What should I do? I have my mysqlbug
file attached.
SEND-PR: -*- send-pr -*-
SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as
SEND-PR: will all comments
I'm not exactly sure if this is the right syntax. I can see that maybe a
couple of domains would get cut out of this if there spelt almost the same.
What you need to find out is the char count of the smallest domain name.
Then replace smallestdomain with that number. What the rest of the select
I have a database in which one MYD file has apparently been corrupted:
mysql use tracerlock;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Didn't find any fields in table 'news_feed_item'
Database changed
I had a problem using mysql-max stable versin running
on redhat linux 7.1. The data has been lost every
other day it will come back again. What should I do?
__
Do You Yahoo!?
Sign up for SBC Yahoo! Dial - First Month Free
http://sbc.yahoo.com
Pada Wed, 10 Jul 2002 20:17:51 -0700
Bennett Haselton [EMAIL PROTECTED] menulis :
I have a database in which one MYD file has apparently been corrupted:
mysql use tracerlock;
Reading table information for completion of table and column names
You can turn off this feature to get a
Hello,
Greetings!
I am trying hard to connect to MySQL database stored on Linux machine
through a
VB program running on windows on another machine.
My problems are ..
Problem No1:
My Windows machine is under a Windows NT domain.
Linux machine is under another Windows NT domain.
I created a
1 - 100 of 101 matches
Mail list logo
