At 20:31 13-4-01 +, [EMAIL PROTECTED] wrote:
Hi,
Can i make a user friendly interface for Sales people to make a
contact to my data base on mysql running on my linux server.
PHP, Perl also seen message from people who use VB and ODBC to connect to
MySQL. Take a look at this lists
On Thu, 12 Apr 2001, ilker YILDIZ wrote:
Install MyODBC
Adrian
Hi,
I want connect mysql databse with ms front page 200.
How?
What do i?
Thanks.
-
Before posting, please check:
http://www.mysql.com/manual.php (the
Hi,
Does anyone know whether this MySQL support sub queries?
such as:
select ref from tool1
where detail = 'xxx'
and ref in
(select ref from tool1
where detail='yyy');
No matter it's within the same table or different table. However below is
the error I've got, anyone can help?
ERROR 1064:
On Fri, Apr 13, 2001 at 04:02:31PM +0800, Yen wrote:
Does anyone know whether this MySQL support sub queries?
Anyone who has checked the MySQL Manual does.
(Hint: http://www.mysql.com/doc/M/i/Missing_Sub-selects.html)
Jeremy
--
Jeremy D. Zawodny, [EMAIL PROTECTED]
Technical Yahoo - Yahoo
Hi
MS FrontPage does not handle database connections. MS FrontPage is nothing
more than a WYSYWYG HTML Editor. Database connectivity is handled by what
is known as an Application Server e.g Miva Mia, PHP, IIS, ColdFusion, etc
So the answer is consult the documention for your chosen Application
Hi
At 21:17 12/04/2001 -0400, Jocelyn Bernier wrote:
Hi everybody,
I am currently running MySQL 3.23.35 on Windows NT 4.0 SP6. I checked the
mailing list regularly and didn't see any complaint or bug report
regarding version 3.23.37. In fact I would like to know what is the most
stable
Hi
The short answer is no, but you could get around this by using JOIN
Sub-queries are not yet supported
At 21:39 12/04/2001 -0400, James Gonthier wrote:
The following works ok in SQL Server, can it work in mySQL?
select * from users where id in (select userid from group where name='sales')
I will like to mail all the users in Mysql database having valid email
record, their data with user name and password.
How to go about this? does anyone have a free script to share?
I also want a column to be updated with random password for each user.
This is an application issue. You can do
Hello!
I'm trying to use Microsoft Query (from MS Office 97) with MySQL
3.23.33 via MyODBC 2.50.36.
(MySQL runs on a FreeBSD 4.3RC machine)
It sometimes works, but often MySQL reports strange errors about
inexistants tables or fields names.
Often, in MySQL log file, I see something like
I can make this query: select a from table.
I can count it: select count(a) from table.
I can select it: select distinct a from table.
But how can i count it?
select count(distinct a) from table doesn't works
Z
-
Before
On Fri, Apr 13, 2001 at 12:37:40PM +0200, Z_da_eXTaZie wrote:
I can make this query: select a from table.
I can count it: select count(a) from table.
I can select it: select distinct a from table.
But how can i count it?
select count(distinct a) from table doesn't works
It works for me
Is MySQL support distributed database or not ?
If yes, then please let me know , how it's doing .
Maybe not in a sense you'd like, but it has support for replication. Just
read up on the manual, as in (the url will propably wrap):
On Fri, 13 Apr 2001 [EMAIL PROTECTED] wrote:
Hi,
Can i make a user friendly interface for Sales people to make a
contact to my data base on mysql running on my linux server.
Sure.
--
/"\
\ /ASCII RIBBON CAMPAIGN
X AGAINST HTML EMAIL
/ \AND POSTINGS
- Original Message -
From: [EMAIL PROTECTED]
To: "Agustin Eloy Barrios Arteaga" [EMAIL PROTECTED]
Sent: Friday, April 13, 2001 8:22 AM
Subject: Re: Diferences
Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To bypass the filter
Could you please let me know whether MySQL database can be used with QNX
Neutrino Realtime Platform ? If so, what version?
Thanks for the help
Lekha Das
-
Before posting, please check:
http://www.mysql.com/manual.php (the
Hi!
To avoid mixing to a German company Innobase AG, we are changing the
name of the product Innobase to InnoDB in 3.23.37.
- In my.cnf you have to change the parameter names innobase_...
to innodb_...
- The SQL parser in 3.23.37 will still know the table type innobase, but
before July 15,
does anyone that is using replication have any
suggestions at all about how to get past this problem?
is anyone using replication successfully?
- Forwarded message from Jim Ziegler [EMAIL PROTECTED] -
Envelope-to: [EMAIL PROTECTED]
Delivery-date: Tue, 10 Apr 2001 16:42:26 -0400
Paul's book on MYSQL,
and the Wroc book on PHP... and you'll be good to go.
On Thu, 12 Apr 2001 21:51:53 -0600, Mike wrote:
I am looking at using MySQL,Apache and PHP on a Web app and was wondering if
there was a good book out there. I seen a few on the MySQL site that look
really
Hi,
There might be some kind of bug in UPDATE. Let's say there is a 4 row
table, which looks like this:
| fd_01 | int(11) unsigned | | PRI | 0 | |
| fd_02 | text | | | | |
| fd_03 | varchar(4) | | |
Hi
Though it is a simple question, i want help reg this. In the manual
it is giving we can create table with foreign key and references table
to make foreign key concept though it is not supporting the same. When
i try to create the table with foreign key it is giving
ERROR 1064: You have
Is a more complex single query going to run faster on a server than
several smaller queries where the results are set to variables and then
used as criteria in tertiary queries.
Bryan
-
Before posting, please check:
Hello all, When I use mysql_create to create the struce to access table,
I have a question about the BOLB type.
My table defined as follow:
drop table ClipBoard; #4-13
create table ClipBoard( # added 4-12 xuan li
id INTEGER NOT NULL,
data blob,
primary key(id)
);
Then I use
On 2001 Apr 13, Maciek Dobrzanski [EMAIL PROTECTED] wrote:
| fd_10 | varchar(20) | | MUL | | |
| fd_11 | varchar(20) | | | | |
Now when I do this update:
UPDATE test SET fd_11='value' WHERE fd_10='some_value'
it usually
Hi,
gnorpm did not list any other RPMs. I only downloaded one from mysql.com. At
any rate, since I'm running Red Hat on that machine, I tried going to Red
Hat's site, and they had several RPMs and I found the ones I needed. Is
there a reason that msyql.com doesn't list any clients other than the
MYSQL
I am trying to create tables that will be used in merge definition. The
merge seems to be very strict in the definition of like tables. So I tried
to use the "create table y select * from x;" but it does not create the
indexes in the new table. I did copy the x.frm to y.frm and all
Dennis Nichols [EMAIL PROTECTED] writes:
At 4/13/01 03:42 AM, Peter Holm wrote:
mysql select floor(23.49 + 0.5); = 23
mysql select floor(23.499 + 0.5); = 24
Why are there different results?
Apparently the closest (most accurate) expression of the
first
I keep getting the following error everytime i tried to use Load Data
mysql load data infile '/home/laovision/lvdb/region.dat'
- into table tlu_region fields terminated by '\t';
ERROR 13: Can't get stat of '/home/laovision/lvdb/region.dat' (Errcode: 13)
I get same error using mysqlimport
This is because with the first query it can use the index. With
the second query, it has to check the whole table. Why? Because
obviously you're using numbers. And let's make some_value == 10.
I thought that maybe MySQL should check the field type and do the conversion
to string.
Hi,
On Fri, Apr 13, 2001 at 08:39:52PM +0530, Venkatesh T wrote:
when i try to create this
create table details(code varchar(10), scode varchar(20), order
smallint(2), foreign key (code) references master(code));
ORDER is a reserved word in SQL. If you really want, you can use it
for
On 2001 Apr 13, Maciek Dobrzanski [EMAIL PROTECTED] wrote:
This is because with the first query it can use the index. With
the second query, it has to check the whole table. Why? Because
obviously you're using numbers. And let's make some_value == 10.
I thought that maybe MySQL
On Fri, Apr 13, 2001 at 09:35:38AM +0800, Leon Harris wrote:
I believe that the session was idle. It also does it when I give the
-2 option to ssh ( ssh2 is supposed to not time out, according to
some usenet posts I have read). The point of the excercise is to
have an encrypted connection
Hi, I downloaded the source of mysql and I am able to compile it fine. When
i run "make" i get the following
error,
"my_pthread.c", line 456.5: 1506-068 (S) Operation between types "struct
hostent*" and "int" is not allowed.
I am using an IBM C++ compiler. I also followed all of the
I'm 2/3 of the way to getting my daisy chained replication
working.
Here's my set up
Machine 1:
Compaq Proliant 6000, RedHat Linux 7, mysql 3.23.36, 1 NIC, 2 IPs
server id 1 bound to IP 65.64.51.104
server id 2 bound to IP 65.64.51.105
Machine 2:
Ultrasparc 450, Solaris 2.6, mysql 3.23.26,
Hi,
I need to export data from development to production.
Development - Win98
Production - Unix
What is the best way to transport data to fro dev
prod ?
mysqldump doesn't seem to work - keeps giving me
errors (of course, I don't know if I'm doing it the
right way, and whether that command
On Fri, Apr 13, 2001 at 01:48:26PM -0700, Ravi Jayagopal wrote:
Hi,
I need to export data from development to production.
Development - Win98
Production - Unix
What is the best way to transport data to fro dev prod ?
mysqldump doesn't seem to work - keeps giving me errors (of
try
http://www.avukatpro.com/mysql.html
Regards.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail
Hello.
On Fri, Apr 13, 2001 at 09:15:32AM -0400, [EMAIL PROTECTED] wrote:
At 04:55 2001-04-13, John Dean wrote:
At 21:17 12/04/2001 -0400, Jocelyn Bernier wrote:
I am currently running MySQL 3.23.35 on Windows NT 4.0 SP6. I checked the
mailing list regularly and didn't see any complaint
How do you guys uniquely identify companies within your mysql databases,
both foreign and domestic?
Tax ID numbers?
Name and State and City(US)
Other?
In the database I am designing
the PublicMembers are identified by email/login/person/member(num),
and only has financial capabilities with my
Tax ID numbers are a good solution for companies in the US, as they're
unique. Same with Taxpayer IDs (SSN) for employees. I use both as
primary keys (or at least unique keys) in databases I develop.
Short of placing a phone call, there's not much way to assure a company
representative.
Is a more complex single query going to run faster on a server than
several smaller queries where the results are set to variables and then
used as criteria in tertiary queries.
Bryan
-
Before posting, please check:
Since I'm sick of the misinformation being spread about
MySQL, and a google search didn't bring up anything conclusive,
here I am scratching the itch.
Obviously, I'm not perfect. I'd love comments or criticism, and
maybe with some help this could become a valuable resource.
I am running Redhat 7 and mysql and I have tried to install Msql-Mysql DBI
module But I get errors when I do a make
I have enclosed a screen dump of the output I get. I seams to be getting
stuck with dbimon. I have installed DBI-1-14.tar.gz.
User name for connecting to database test? [undef]
I've having a HORRIBLE time compiling this new version of MySql. Can
someone please tell me what could be wrong?
I have upgraded glibc to 2.96 per recommendations on the website, with no
change in results.
Here is the error I get
6 -DDBUG_OFF -c my_error.c
my_error.c: In function `my_error':
On Fri, Apr 13, 2001 at 06:49:51PM -0400, Michael Bacarella wrote:
Since I'm sick of the misinformation being spread about MySQL, and a
google search didn't bring up anything conclusive, here I am
scratching the itch.
It certainly can't hurt! :-)
Obviously, I'm not perfect. I'd love
After intsalling mysql is there a default password assigned to root?
I type "./mysqladmin -u root -p password 'new-password'"
Well, I don't know what the old/default password is deermind for the
american
How do I fix it?
thx,
DAVE
Does anyone know any good source of info for the conversion of MS Sql
databases to MySql? Perhaps a prog that does this? Thanks for any
information in advance,
AJ Workman
-
Before posting, please check:
AJ,
In the past, I have used ACCESS ODBC to create an Update Query to move data
between Access and MySQL. My stuff was small so I did it by hand.
Andy
AJ
47 matches
Mail list logo