Hi Kodrik,
- Original Message -
From: Kodrik [EMAIL PROTECTED]
To: Franklin Schmidt [EMAIL PROTECTED]
* Transaction
* Subselects
* Foreign keys
* Stored Procedures
Do you actually believe that the lack of NO DEFAULT is much worst than
those
features above, which cannot be as
Hi just ported a web site from one server
to my own. MySQL is running just fine.
When I run my page that talks to my
database however, I get this;
mySQL: table does not exist or has no columns
...then the rest of the page comes in just fine.
Any idea what I have missed here?
THX
Mike
I am setting up a replication slave.
Master is server-id = 1
Slave is server-id = 2
Relevant section of /etc/my.cnf from the slave
# The MySQL server
[mysqld]
port= 3306
socket = /tmp/mysql.sock
skip-locking
set-variable= key_buffer=16M
set-variable=
That is all good :)
I'm mostly aware of the possibilities I had offered to me the last time I set
up my developing environmenta and the db design decision I had to make
accordingly.
I guess in less then a year, when 4.x will have some good mileage, I'll set
myself a new developing environment
Hello,
Ive been using MySql for about a year now, and have finally become comfortable with
sql and php scripting. Now my life has changed as Ive taken the next step into the
actual server, which Im finding myself not to be cut out for...!
This is my problem: I have a win2000 professional
How does one go about securing database access username and password
information that's kept in a script's config file?
Most of the PHP and Perl applications floating around Sourceforge, as
well as most of the commercially available scripts, store the database
access username and password in a
On Saturday 10 Nov 2001 21:00, Franklin Schmidt wrote:
The worst thing any development tool can do is silent unwanted favors.
Java and C don't do unwanted favors which is why they are great.
Javascript and most Microsoft tools do lots of unwanted favors which is
why I hate them. This is a
i want to convert my access database to mysql. and then it will run on a
linux server if i ever figure out how to run these darn scripts though
i downloaded mysql for windows 98. i have tried for a week to run these
scripts and even reinstalled mysql and even tried it on another computer
Tryhttp://www.anse.de/mysqlfront/ easy to use Windoze
graphical front end.
M;)
Barbara Ferrell wrote:
i want to convert my access database to mysql. and then it will run on a
linux server if i ever figure out how to run these darn scripts though
i downloaded mysql for
I want to be able to define a user defined function in a Update query
eg Update Table Set MyField=MyFunction(TestField1,TestField2);
Where Myfunction tests 2 fields to return a result.
I am after a quick solution
Thanks
Dean
On Sat, Nov 10, 2001 at 04:49:59PM -0700, Paul Chilson wrote:
I am setting up a replication slave.
Master is server-id = 1
Slave is server-id = 2
[snip]
This is the first few relevant lines after the first startup, all subsequent
lines are just repeated.
My guess as to the problem:
Paul DuBois writes:
When you distribute a non-GPL application that ONLY works with the MySQL
server and ships it with MySQL. This type of solution is actually
considered to be linking even if it's done over a network.
I believe that bit about even if it's done over the network was
added
Hello,
I am running MySQL version 3.23.44 and I have been trying for quite
some time to install this version of MySQL on Suse Linux Professional 7.2.
When I enter the command bin/safe_mysqld to start MySQL I receive the
following messages:
#Starting mysqld daemon with databases from
DownloadFAST.com wrote:
But hey apparently I did finally get a solution from a helpful chap on this
list
What is it? I would like to know. My email is [EMAIL PROTECTED]
P.S. for spam filter - database,sql,query,table
-
Warren C. Sherard III writes:
#Starting mysqld daemon with databases from /usr/local/mysql/data
011104 mysqld ended
You need to check the log file for error messages. The two most
common reasons that people can't start mysqld are that they've
forgotten to run mysql_install_db (or whatever
Sinisa Milivojevic wrote:
As your entire discussion centers on the non-existence of NO DEFAULT,
I will briefly comment only on that.
I would like to add my support for NO DEFAULT. The lack of this feature
is by far the worst thing about MySQL.
Forcing default on all columns is a design
I just found the following at http://www.mysql.com/doc/B/u/Bugs.html
--
Because MySQL allows you to work with table types that don't support
transactions, and thus can't rollback data, some things behave a little
differently in MySQL
It seems that once again a taiwan.com address has been subscribed
to this mailing list. In case you haven't noticed, taiwan.com
has a very broken mailer, which sends an error message to
whoever posts anything on this list. Apart from this being
annoying (especially since the date on taiwan.com's
I would like to add my support for NO DEFAULT. The lack of this feature
is by far the worst thing about MySQL.
I don't get this argument. What happens when a unique index is
violated? Isn't this the same problem?
Those two comments together are quite interesting.
Can you enlighten me with
My question is how in MySQL I can get information
is table exists or not ( I don't want some query
that return
error but kind of message from serwer !)
I'm beginner and I have no idea how to do it
smart and properly
Please help !!!
It seems that once again a taiwan.com address has been subscribed
to this mailing list. In case you haven't noticed, taiwan.com
has a very broken mailer, which sends an error message to
whoever posts anything on this list. Apart from this being
annoying (especially since the date on
Hi,
Can someone tell me why this will not work, please
SELECT * FROM tbl1 WHERE column =(SELECT * FROM tbl2 WHERE intcolumn =
15);
(Table and column names changed to protect the innocent, 15 could be a
variable or anything)
I thought this was just a common or garden 'Inner Query'. I
Have a
Description:
./configure --help
claims that the default value of localstatedir is PREFIX/var, but
after setting --prefix it appears to be still pointing to '/var'.
How-To-Repeat:
./configure --prefix=/opt/mysql-3.23.44
make
make install
./scripts/mysql_install_db
mkdir: cannot create
I'need know what version of MySQL running in Windows, is free licence ?
Thanks !
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To
[EMAIL PROTECTED] wrote:
:Description:
: ./configure --help
:claims that the default value of localstatedir is PREFIX/var, but
:after setting --prefix it appears to be still pointing to '/var'.
:
:How-To-Repeat:
: ./configure --prefix=/opt/mysql-3.23.44
: make
: make install
:
John Morton writes:
Can someone tell me why this will not work, please
SELECT * FROM tbl1 WHERE column =(SELECT * FROM tbl2 WHERE intcolumn =
15);
That's a subselect, and a search in the manual gave me this
page, which probably has all the info you need:
On Sat, 2001-11-10 at 04:50, DL Neil wrote:
It seems that once again a taiwan.com address has been subscribed
to this mailing list. In case you haven't noticed, taiwan.com
has a very broken mailer, which sends an error message to
whoever posts anything on this list. Apart from this being
On Sat, 2001-11-10 at 04:33, Artur Kowal wrote:
My question is how in MySQL I can get information
is table exists or not ( I don't want some query
that return
error but kind of message from serwer !)
I'm beginner and I have no idea how to do it
smart and properly
Please help !!!
On Sat, 2001-11-10 at 05:53, John Morton wrote:
Hi,
Can someone tell me why this will not work, please
SELECT * FROM tbl1 WHERE column =(SELECT * FROM tbl2 WHERE intcolumn =
15);
There are no subselects in MySQL (yet). However, they're usually a bad
idea anyway, which is why it's
NOt supported... Yet. Rumor has it sub-selects will be in 4.1
John Morton wrote:
Hi,
Can someone tell me why this will not work, please
SELECT * FROM tbl1 WHERE column =(SELECT * FROM tbl2 WHERE intcolumn =
15);
(Table and column names changed to protect the innocent, 15 could be a
Hi All!
I am sorry that I posted that message with a syntactical error. but
what i meant to write was this..
insert into table_name(field_name1,data_file) values
(1,load_file('/absolute/path/file_name.jpg'));
sorry abt the error guys..
but guys this still returns a NULL value. please help.
Steve Meyers wrote:
There are no subselects in MySQL (yet). However, they're usually a bad
idea anyway, which is why it's never been such a big rush to get them in.
Sometimes (just sometimes), there is no way to do it except with a subselect.
For instance, we have a table where we get
almost of all my application (Java with JDBC) use select
encrypt(password,salt) to encrypt and store user's password. it work well
in linux/unix. but i have just found that encrypt command does not work in
windows version of MySQL.
pls help me !
Thanks !
we can use subselect now with MySQL-Max version.
- Original Message -
From: Steve Meyers [EMAIL PROTECTED]
To: John Morton [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Saturday, November 10, 2001 8:13 AM
Subject: Re: Beginner SQL Question
On Sat, 2001-11-10 at 05:53, John Morton
in some case, we have to use some programming technique to resolve that
problem, ex: we create a new Connection or new Statement (with one
Connection) . we can have many statement.
rs2 = stmt2.executeQuery(select unique filename, max(received_time) from
file_updates group by orig_file_path);
Nguyen Trong Phuc wrote:
we can use subselect now with MySQL-Max version.
I think not. I know it failed with 3.23.43, when I tried it just now
(mysqld-max).
Regarding encrypt(), the manual does say that encrypt() returns NULL on
OSes where the crypt() function is not available. True.
yeah, mysql is compatible for small business with small and simple database.
We can use PostgreSQL for subselect query as a free SQL server, but it's too
slow.
-
Before posting, please check:
http://www.mysql.com/manual.php
Guys... this is the internet just delete the spam... and dont complain
like a school girl with a skinned knee... I am a system admin and if i
blocked every domain that sent spam mail people would only be able to email
to other on our domain.. Spam Happens.. delete it and go on with your
Um.
I block every domain I catch spamming and my users don't seem to have
problems.
kronos wrote:
Guys... this is the internet just delete the spam... and dont complain
like a school girl with a skinned knee... I am a system admin and if i
blocked every domain that sent spam mail
am trying to design a good database, that has a matrix of data per record.
For example, 1 record already has 80x43 = 3440 datafields which each need to
hold real numbers. The way I would do it would be to hold a row of 3440
columns, but I do not know if that will be a mistake or if that would
From: Sparta Cruz [EMAIL PROTECTED]
Do you think this was due to software constraints(MySQL), or do you
think it had to do with hardware constraints?
I'm sure it was software. Possibly the MyISAM tables I'm using.
-Original Message-
From: Rodney Broom [mailto:[EMAIL PROTECTED]]
am trying to design a good database, that has a matrix of data
per record.
For example, 1 record already has 80x43 = 3440 datafields which
each need to
hold real numbers. The way I would do it would be to hold a row of 3440
columns, but I do not know if that will be a mistake or if that
Why not just use 43 db rows each with 80 fields and a matrix row
index field? Then 350 records with 80x43=3440 fields turns into
350x43=15050 records with 81 fields, which is much more manageable.
PS - Does this table happen to be for recording the contents of a text
window? (43
Hi,
For a university project I've recently started to learn to use MySQL.
Obviously one of the first things I did, having read numerous tutorials was
to create a database and attempt to add some tables. Unfortunately I have
spent the past two weeks trying to do this presumably straight forward
mysql create database colors;
Query OK, 1 row affected (0.01 sec)
mysql use colors
Database changed
mysql CREATE TABLE Colors(
-
- cid INT UNSIGNED NOT NULL,
- data VARCHAR(10) NOT NULL
- );
Query OK, 0 rows affected (0.06 sec)
mysql insert into Colors
Kodrik wrote:
Understand also that the check for a uniq index has to be made by a call to
the DB so it makes sense the DB does it, but a check on the content of a
variable can be made by one line of code without any call to the db.
Anything that the database does, one can also do in code.
In your examples, ID 2 should NOT get returned. What I'm after is analogous to a Perl
hash where you could say:
if (!exists $colors{2}-{blue}) {
...
}
Make sence?
---
Rodney Broom
Programmer: Desert.Net
Spam filter: sql database
Well since you'd only have 80 data columns to refer to instead
of 3440, it could make generating queries easier.
I could see dealing with the data being a little bit more
complex, but if the data represents a matrix, storing the data this way
is probably closer to how it would be
Sorry I misread what the question was asking since I have run into MySQL
related problems that are not problems in other databases, so I just wanted
to check that out. You would have to have some function that could read a
resultset similar to the select * from colors where data !='blue'; since
Can you rename a database? If so, how does it handle all the tables inside it?
Thanks.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list
On Saturday 10 November 2001 01:00 pm, you wrote:
Kodrik wrote:
Understand also that the check for a uniq index has to be made by a call
to the DB so it makes sense the DB does it, but a check on the content of
a variable can be made by one line of code without any call to the db.
Can you rename a database? If so, how does it handle all the
tables inside it?
By shutting down the server, renaming the directory
of that database and restarting the server.
The server will be able to handle the change just fine.
/ Carsten
--
Carsten H. Pedersen
keeper and maintainer of
Greetings list members. I'm trying to build an application for OS X using
CW7 - and though I've gotten mysql++ to build and install properly (from the
command line, using configure gcc) - I can't seem to get CW happy with
using mysql++ ... when I include the sqlplus header, I get about 300+
53 matches
Mail list logo