Hello,
I have a table with the following column among others:
text VARCHAR(120) CHARACTER SET utf8
The provider I am using however only offers MySQL version 3.23.58,
so I cannot use this statement. At first I thought I was not going
to be able to store UTF8. So I changed the column to the follo
Hello,
I need to backup a mysql database in such a way that the output is
simply a bunch of insert statements. I do not want the database
schema as output as well: just the insert statements. This is
because I already have a script with CREATE statements and
would like to rebuild the database fro
Hello,
Is there a way to specify MyISAM for all tables in a given file rather
than having to specify it at the end of each table declaration. I think
this would make porting databases back and forth to MySQL somewhat easier
since including MyISAM as part of the table declaration is not compatibl
Hello,
I believe that MySQL is in error in reporting the following message just
because I did not specify that the PRIMARY KEY should not be NULL. These
days there are standards and SQL92, AFAIK, specifies that if the primary
key is not explicitly set to NOT NULL then the RDBMS should automatical
On Mon, 2 Jun 2003, Frank Nørvig wrote:
> Hello,
>
> I was wondering if the following could be done with an advanced
> sql-statement in MySQL 3.23:
>
> I have 5 tables with the following columns: id, name, phonenumber
> I need to check for duplicate phonenumbers in the 5 tables, that is if the
Hello,
I have a script with INSERT statements. I run it quite often and
today for the first time I got the following message while inserting
from the mysql client:
BUG IN DYNAMIC LINKER ld.so: rtld.c: 621: dl_main: Assertion
`_dl_rtld_map.l_libname' failed!
I simply reran the script and it wo
uot;
and "DISABLE CHECK IC" or something similar, with the default
set to DISABLED in the intrest of speed, but with the syntax
in the table data definition language (DDL) still being parsed
and accepted in both cases, as for foreign keys.
Thank you f
Hello,
What are MySQL's coolest and most useful vendor specific features?
Here is a partial list of features, none of which are part of any
SQL standard but which I nevertheless find quite useful from time
to time. I would like to invite you to add to this list:
1. AUTO_INCREMENT columns
2. LIM
Hint:
The user and host combinations for allowed MySQL connections are stored
in a table called mysql. You can access this table by issuing:
$ mysql -u root
mysql> use mysql;
mysql> SELECT user, host, password FROM user;
If you have set up a root password then issue:
$ mysql -u root -ppassword
Only table field names are allowed after the ORDER BY clause in
standard SQL. The answer to your question is that SQL is not designed to
do that kind of thing. Rather, I would suggest computing a random
permutation of the numbers 1, 2, 3, and 4 in the PHP application prior to
constructing your
Use the PASSWORD() MySQL builtin function as follows:
INSERT INTO Table
VALUES ('0', 'username', PASSWORD('password'), 'email')
This function is not part of the SQL standard. It is
used for storing passwords in the MySQL user table in
the mysql database schema named mysql among other things.
N
On Fri, 10 May 2002, Paul DuBois wrote:
> At 12:06 +0100 5/9/02, Sandeep Murphy wrote:
> >Hi,
> >
> >What appears to be the problem with the fwg query:
> >
> >select code,date from multimedia_header where rubrica=87 and now() >
> >'08-03-2002 13:10:53' and date IS NOT NULL
> >
> >The records re
I will guess that the NULL field you defined is of a numeric
type such as INT. In standard SQL the empty string '' is not
the same as the special value NULL, and this is also true in
MySQL, but not in Oracle. Probably you are inserting a ''
into the database column but MySQL correctly interprets
Check out the mysqldump command line utility.
It also has its own man page.
Bye,
Neil
On Sun, 31 Mar 2002, kaps wrote:
> hi guys
>
> how can i get a backup of the database using the mySQL Server terminal
> access with my mySQL Sever?
>
> any help?
>
> cheers
>
> kaps
>
>
> -
Hello,
I searched the manual but it seems like MySQL does not support ANSI SQL
CHECK constraints. These are often used to check that rows inserted into
tables meet specified criteria. For example table T created as follows
CREATE TABLE T (
X INT,
CHECK (X <= 10)
);
has a check constraint s
http://mmmysql.sourceforge.net/
On Thu, 24 Jan 2002, Rahadul Kabir wrote:
> hi,
> I recently installed MySQL3.23.47 and now I need the JDBC drivers for
> it. Does anyone know where can I find a Free JDBC driver that would work
> with MySQL 3.23.47-1?
> thanks so much
>
> --rahad
>
>
> -
On Sat, 12 Jan 2002, Tom Jones wrote:
> >Table: flights
> >Fields: depart, depart_time, arrive, arrive_time, flight_no, flight_group
>
> I'm trying to do a search on "depart" and "arrive" and show only the records
> which have matching "flight_group"
SELECT depart, arrive
FROM flights
WHERE
Good try but under Red Hat 7.2 the scripts /usr/share/mysql/mysql.server
and /etc/init.d/mysql differ in some respects. Try the latter script
instead.
Bye,
Neil
On Sat, 5 Jan 2002, Alexander Trauzzi wrote:
> Here's a quick update to the problem I posted (which I'll include just for
>convinie
Before you proceed I would advise you to revise your relational model.
For instance why do you have both id and artistid in both tables?
Can more than one artist sing or participate in the production
of the same song? If yes then your database should probably look like:
Artists(artist_id, artist
On Thu, 29 Nov 2001, Brian P. Austin wrote:
> The RPMS that are available from the MySQL WebSite are OK to use on 6.2.
> I personnaly prefer to use the source or .src RPMS.
>
> But the RPMS work fine on my 6.2 box.
But once the RPMs are installed you still need to rebuild php with mysql
support
On Thu, 29 Nov 2001, Graham Nichols wrote:
> 'category' can be made up as records such as:
>
> christmas|birthday|easter
> easter|thanksgiving
> birthday|christmas|thanksgiving|easter
The standard way to deal with this kind of problem is to create
a table modelling the event entity set and one
If I were you I would simply upgrade to Red Hat 7.1 or better 7.2.
It probably takes just as much time to install a whole distro
than having to worry about installing apache, then mysql, then
php, all over again, and most likely getting something wrong
and having to go back. Also there may be pro
On Thu, 29 Nov 2001, anandakkumar araskumar wrote:
> Hi all
> Iam new to php and iam learning that from scratch.I
> came across a problem in connecting mysql from php
> script.I run php in windows2000 under IIS configured
> to personal web server.I have installed mysql
> with server and client a
Dear mysql developers,
Personally, I think your web pages are very nice
and also user friendly. I have no idea about
what this fuss is all about.
Regards,
Neil
-
Before posting, please check:
http://www.mysql.com/manual.p
asure of fairness towards
> competitors is always indicated.
>
> Cheers,
> Christian
>
> > -Ursprungliche Nachricht-
> > Von: Neil Zanella [mailto:[EMAIL PROTECTED]]
> > Gesendet: Montag, 26. November 2001 21:00
> > An: Ken Kinder
> > Cc: Mamun Murtaza
On Mon, 26 Nov 2001, Ken Kinder wrote:
> Oracle is certainly more full-featured, but if you know very little about
> databases, Oracle is not the right choice.
I agree. First of all the system requirements are high. For instance the
Oracle Universal Installer took something like three hours on
I think you want to do the following (notice the parentheses next to the
mysql function named now):
SELECT * FROM Table WHERE col1 <= now() AND col2 >= now();
Bye,
Neil
On Wed, 21 Nov 2001, Auri Net SAC wrote:
> > Hi
> >
> > it is possible
> >
> > "select * from table where col1 <= now and c
On Sat, 10 Nov 2001, 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 !)
You could process the output of SHOW TABLES.
You can also DROP TABLE IF EXISTS table_name
and
Hello,
I would like to know if it is possible to issue a command from the
mysql command line interface which will read SQL commands contained
in a file and execute them immediately without having to cut and
paste them one gpm buffer size at a time.
Thanks,
Neil
--
Out of curiosity, why would you want to do this?
Are you trying to use mysql with ASP
instead of with PHP? Just curious...
Neil
On Tue, 25 Sep 2001, Indramin Darmadi wrote:
> Hi all,
>
> I'm a newbie. My question is : Is it possible to access a MySQL table using
> RealBasic?
>
> If any of yo
It is possible and not very hard at all.
But why would you need expect? Why not
just use a shell script?
Neil
On Mon, 24 Sep 2001, Chris Aitken wrote:
> Hi,
>
> Just a quick query. I haven't been able to locate any documentation on it,
> but has anyone ever used an expect script to connect to
On Thu, 6 Sep 2001, Chadrick Mahaffey wrote:
> I realize that I'm going to be in the minority here but I have to say it.
> Open source would go much farther if they had self explanatory GUIs and had
> basic pre-setup apps that were ready for the average user to use.
Perhaps your company should
On Tue, 4 Sep 2001, Sinisa Milivojevic wrote:
> Trond Eivind Glomsrød writes:
> > Tony Bibbs <[EMAIL PROTECTED]> writes:
> >
> > > 7.1 doesn't install php with mysql support enabled.
> >
> > Yes, we did.
Red Hat 7.1 has a very nice apache + mysql + php installation and invoking
mysql function c
I would like to comment on the following mysql.com question
"We have made our product available at zero price under the GNU
General Public Licence (GPL), and we also sell it under a commercial
licence to those who do not wish to be bound by the terms of the GPL."
Out of curiosity, how does t
RedHat 7.1 users:
The command used to start mysqld on this platform is simply (as root):
# /etc/init.d/mysqld start
This is _all_ that is required.
Once that works you can set
the mysql root user's password
with mysqladmin if you are
concerned about security
on your intranet.
Neil
---
On 27 Aug 2001, Trond Eivind Glomsrød wrote:
> Neil Zanella <[EMAIL PROTECTED]> writes:
>
> > 4. Are the Linux versions shipped with Red Hat 7 and 7.1 entirely
> >distributed under the GPL?
>
> Yes.
This appears to be true after noticing the following file
und
I would like to discuss the MYSQL licensing policy.
Please do not take anything personally. I do think
that MySQL is one of best database management
systems out there.
Pertaining to the FAQ on the mysql.com site:
--- begin snip
Q:Does MySQL AB devel
In order for this to work you must have privileged access
to the mysqld server on which you must be able to execute
a GRANT statement to allow access from your host. If
you do not have this privilege then you're out of luck.
Connecting from other hosts then the server host is
considered to be a s
On Wed, 13 Jun 2001, Benjamin Pflugmann wrote:
> Hello.
>
> Only a minor correction:
>
> On Tue, Jun 12, 2001 at 09:35:19PM -0230, [EMAIL PROTECTED] wrote:
> [...]
> > GRANT ALL ON 'database'.'table' TO 'user'@'host' IDENTIFIED BY 'password'
> >
> > - the PRIVILEGES keyword is redundant.
> > - da
On Tue, 12 Jun 2001, Martin Scherer wrote:
> I am told that mysqladmin is not an understood command.
Looks like you need to update your PATH variable.
Neil
-
Before posting, please check:
http://www.mysql.com/manual.php
On Tue, 12 Jun 2001, David Simcik wrote:
> Trying to grant super-user level permissions on my root account, but I keep
> getting back an error:
>
> mysql> GRANT ALL PRIVILEGES ON *.* TO root@% IDENTIFIED BY 'user' WITH GRANT
> OPTION;
> ERROR 1064: You have an error in your SQL syntax near '% IDE
On Mon, 11 Jun 2001, h3rb wrote:
> Ok. I have read the manual =) But one thing I am not clear on. Is if I can
> create a user who can create their own database's..modify them..and drop them
> if need be. But they wouldn't have access to any database on the server. I
> am asking because I hos
On Sun, 10 Jun 2001, Brian Walker wrote:
> [root@www data]# telnet www.sfslsports.com 3306
> Trying 209.15.183.134...
> Connected to www.sfslsports.com.
> Escape character is '^]'.
> (
> 3.23.38)fHv:[?e
>
> Bad handshakeConnection closed by foreign host.
If you can see version number then
Sorry about this questions but why would you want to run two copies of
mysqld when it is capable of hosting as many different databases as
you need? Even if you needed two databases with the same name you
could still just create two different MySQL users for it.
Thanks,
Neil
On Sat, 9 Jun 2001
Perhaps you need the MySQL-DBI-perl-bin RPM (?).
Is there such a thing?
On Fri, 8 Jun 2001, Mike Jimenez wrote:
> Perl is already installed installed on the server.
> Mike
>
>> You don't need MySQL-bench-3.23.38-1.i386.rpm to run mysql but if you
>> still want to use it, you need to install per
On Fri, 8 Jun 2001, technical Support wrote:
> Hello All,
>
> I have tried the settings as suggested in this FORUM like using htmlentities
> etc... however, my pound sign in the database is displayed as: ú
Are you seeing this stuff from the standard Windows telnet client?
If so get yourself a be
On Fri, 8 Jun 2001, Rolf Hopkins wrote:
> What you wrote here and what you wrote below are not the same
>
> update vusers set name="Adrian D'Costa" where id=3;
>
> update vusers set name='Adrian D\'Costa' where id=3;
>
> will both work. Look up the section on escaping special characters in the
Did you add user to your database with the SQL GRANT statement?
Neil
On Thu, 7 Jun 2001, Martin wrote:
> Warning: MySQL Connection Failed: Access denied for user:
>'[EMAIL PROTECTED]' (Using password: YES) in setup.php on line 92
>
> I am sure that all information is correct as far D
On Fri, 8 Jun 2001, nyon wrote:
> I installed MySQL on Windows NT.
> Currently, I login in using annoyomous user.
> I can't seem to login in as root user.
> The syntax is : mysql -u root -p xxx
With the above command mysql thinks you are trying to access
database xxx using a password to be spec
Hello,
I notice that there are two places where a database can be specified
for the mysql client: (i) at the end of the line and (ii) after the
-D flag. Are there any particular reasons for this design decision?
I also notice that the -D flag is not supported by mysql 3.22.32
which produces a se
On Wed, 6 Jun 2001, Ian Ford wrote:
> Name your config file config.inc and if any of the below situations
> happen your password and username will not show up in plain text for the
> casual browser.
> (EXAMPLE:
>
> CONFIG.INC
> $DBname = 'test';
> $DBuser
On Wed, 6 Jun 2001, Dibo Chen wrote:
> use 'mysql -h server_machine -u user_name -p ' to connect/query your
> MySQL server. You don't need telnet.
My apologies for introducing some confusion here. You can use telnet to test
whether mysqld accepts incoming connections from the host on which
If you really want to connect from the windows client computer then you
must execute the grant statement on the server but this may expose you
to security risks. In this case it would be best to have both computers
behind a firewall.
Neil
On Wed, 6 Jun 2001, sanborn wrote:
> Thanks for your ma
On Tue, 5 Jun 2001, Don Read wrote:
> Better yet, put the file outside the $DOCUMENT_ROOT, in case your server is
> poorly configured.
>
> include("$DOCUMENT_ROOT/../config.php");
This is a very good idea. One day if the system administrator decides to
back up all the user data and upgrade the
telnet your.mysql.server 3306
On Tue, 5 Jun 2001, sanborn wrote:
> How is MySQL used over a network? I assume there is a port involved, and
> some kind of transaction server built into mysql? How do I configure, test
> this? In the several documents I have read so far, I haven't found much o
$ MYSQL=/usr/local/mysql
$ ./configure --with-mysql=$MYSQL
Then PHP finds the following files in $MYSQL/lib:
$ ls $MYSQL/lib
libdbug.a libmygcc.a libmysqlclient.a libmystrings.a libmysys.a
With the RPM files one finds:
$ ls /usr/lib/mysql
libdbug.a libmerge.a libmyisammrg.alibmysq
> >php nothing error: when make and make install
> >./configure --with-mysql=/usr/local/mysql \
> >--with-apache=/usr/src/apache \
> >--enable-track-vars
I have a question. What should go after --with-mysql for RPM installtions?
I cannot find the answer to this question anywhere.
Thanks,
Neil
If you are uncomfortable with RPM try
the following:
rpm -qa | grep mysql
rpm -qa | grep MySQL
rpm -ql MySQL-client*
Also red the maximum rpm manual:
slocate RPM; slocate rpm | grep pdf
I think mysqladmin might be under /usr/sbin.
And to find out where a file came from do
rpm -qf path-to-file.
On Thu, 31 May 2001, Jean-Philippe Durrios wrote:
> Hi,
> How do I set the root password after installing MySQL server and client?
> I followed the after installation instructions,@they don'T work.
>
> mysqladmin -p password 'new-password' I don't get it.
The message from the RPM file is w
Did you manage to compile PHP with mysql support?
I think by default red hat disables it.
Neil
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list ar
Hello,
I just reinstalled Red Hat 6.2 and reinstalled MySQL 3.23.38 and got the
following message as usual:
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
This is done with:
/usr/bin/mysqladmin -u root -p password 'new-password'
/usr/bin/mysqladmin -u root -h tulip.math.ualberta.ca
On Tue, 16 Jan 2001, Pavel Kveton wrote:
> On Sunday 14 January 2001 16:25 Martin Borg wrote:
> > I am trying to install Mysql 3.23.7 on a Red Hat 6.0 Server system. When
> > I try to install the binary rpm-distribution i get an error saying that
> > bin/usr/perl5 is needed. The perl version ins
On Fri, 12 Jan 2001, Miguel Angel Solórzano wrote:
> At 09:08 12/01/2001 -0500, Jenny Lie wrote:
> Hi!
>
> I forget to say you in the last mails that you need to do
> the login in the NT/W2k machine as Administrator privilege
> or with an user which has the privilege to install services
> in th
On Fri, 12 Jan 2001, Frederick L. Steinkopf wrote:
> I've got a new acronym for all of you flamers out there who are clutterring
> up the list with off - topic responses and flames to newbies. (And yes this
> is off topic) If you see a message from a newbie that bothers you, just
> PTFDK (Press
On Fri, 12 Jan 2001, Peter Mietlowski wrote:
> I seem to be having the same problem, Installed Mysql by the book, but can't
> get it running. I checked my logs and found this:
>
> 010111 14:27:01 mysqld started
> 010111 14:27:02 /usr/local/mysql/bin/mysqld: Can't create/write to file
> '/usr/
On Thu, 11 Jan 2001, John W Cunningham wrote:
> Hi,
>
> I just installed MySQL via rpms on a fresh installation of Redhat 7 pro
> server. It seems fine at first and it seems to be running. When I check
> the process with: ps aux |grep mysql, I get:
> root 925 0.0 0.4 1516 588 pts/0
The books you are using are probably outdated as installation
instructions tend to change from release to release.
Installation instructions are perhaps one thing that should
not be put in a book. Rather a book should tell you where to
find the installation instructions. The MySQL RPMS do adhere
On Thu, 11 Jan 2001, Rolf Hopkins wrote:
> Fresh installation? Then you don't need -p option. If not, what password
> are you using when it ask you to enter the password. It's not newpassword
> as you typed in the prompt, it's your old password
Hi Rolf,
Thanks for your helpful comment. I am
Hello,
I have installed the RPMs and I am now trying to set the MySQL root
password as the output of the RPM files tells me to do...
[root@tulip /root]# su mysql
[mysql@tulip /root]$ /usr/bin/mysqladmin -u root -p password newpassword
Enter password:
/usr/bin/mysqladmin: connect to server at '
Hello,
I don't know whether or not the developers of MySQL are aware of this
but I got the following error three time when I installed the
MySQL-3.23.30-1.i386.rpm and MySQL-client-3.23.30-1.i386.rpm packages
on Red Hat Linux 6.2:
/usr/bin/mysql_install_db: test: integer expression expected bef
On Wed, 10 Jan 2001, Michael A. Peters wrote:
> Try rpm --nodeps -Uh MySQL-3.23.30-1.i386.rpm
>
> I doubt that MySQL is dependant upon that particular file existing, if
> it wants perl (for benchmark package??) your local perl should work
> fine. If MySQL doesn't work- you can remove it, rpm -e
Hello,
I am running Red Hat Linux 6.2 which is supposedly the platform on
which the latest MySQL RPMs were built. However there are problems
when I try to install the package even though I follow the instructions
in the manual:
[root@tulip /tmp]# rpm -i MySQL-3.23.30-1.i386.rpm
error: failed d
Hello,
There is a documentation error the MySQL manual:
--
4.6 Installing a MySQL Binary Distribution
9.Change ownership of the installation directory to the user that you will
run mysqld as:
shell> chown -R mysql /usr/local/
73 matches
Mail list logo
