You have to implement the view functionailty in code. Or maybe someone
else has a better suggestion :)
There are PHP classes that create views. Check the Repository for them.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: Oh Chye Yong [EMAIL
Hi List
Is there any way to get an estimate of the release date of the next
stable version of MySQL? The reason I'm asking; I am currently busy
configuring new webservers, but it is not crucial as to the exact time I
deploy them ( they will replace currently running servers), so if I knew
4.1
On 18-Jun-2003 Becoming Digital wrote:
...
if(!mysql_query($array[$i])) {
$flag = false;
break;
}
after the loop I do
if($flag)
mysql_query(commit);
else
mysql_query(rollback);
Be careful with that last if() statement. I would either change the
script to
read '$flag =
I am using mmysql 3.23.41 and am having querrying problems. I am using my
database to organize music. Whenever I query my database for a album with an
apostrophee in it, It returns no results this is my sintax:
select * from lyric where album like '%Blind Man\'s Zoo%';
I am trying to find songs
use double quotes in internal quotes... so it dhould be something like:
select * from lyric where album like '%Blind Man\''s Zoo%'
I think it'll work.
George Christoforakis.
- Original Message -
From: Weston Skeans [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, June 15, 2003
If you're using PHP, format the result with addslashes(). This will escape-out
any quotes in the string.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: Weston Skeans [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, 15 June, 2003 13:47
Subject:
4- I want when echo the return $row[address] to highlight the entered
keyword (that the user has entered in the search form) in the output with a
different font backcolor or by just another color... to let the user see
what he was searching for
?
$length = strlen( $keyword );
$position =
Hello, mysql,
Do any sql tools support MySql like Oracle (PL/SQL) Development Tools ?
Oracle (PL/SQL) Development Tools is really imporve the efficient of development,but
it doesn't support MySql.
Do any other tools instead of it?
Best regards.
MaFai
[EMAIL PROTECTED]
2003-06-18
--
MySQL
I asked the same question 2 or 3 months ago, and was told a week or two.
The guys from MySQL have to make sure the release is stable first.
- Original Message -
From: Sebastian Bergmann [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, June 18, 2003 3:51 PM
Subject: Re: ETA on 4.1
I want to upgrade from 3.23 to 4.0 version. Could anybody explain to me
how to proceed??
Thank you very much
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
High priority message ?
Then you should read the manual.
http://www.mysql.com/doc/en/Upgrade.html
- Original Message -
From: MOSSANO [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, June 18, 2003 9:43 AM
Subject: upgrading
I want to upgrade from 3.23 to 4.0 version. Could
Terence wrote:
I asked the same question 2 or 3 months ago, and was told a week or
two.
You're probably mistaking the (already happened) release of MySQL 4.1.0
with a general availability release of MySQL 4.1.
--
Sebastian Bergmann
http://sebastian-bergmann.de/
Yes, in the last day the messages came twice and earlier.
Iulian
- Original Message -
From: Jeremy Zawodny [EMAIL PROTECTED]
To: Jay Blanchard [EMAIL PROTECTED]
Cc: MySQL LIST [EMAIL PROTECTED]
Sent: Wednesday, June 18, 2003 1:38 AM
Subject: Re: Long turn-around time
On Tue, Jun
RE: SCSI needed for best performance -
While this is true in some cases, if you are using striping or any
RAID level (RAID 5 for example) that splits reads and writes across
drives, then there will be several IDE channels feeding data to the
RAID card at a time. Two ATA100 IDE channels
hi!
i had some trouble inserting utf-8 unicode into a table
in mysql 4.1.0.alpha. i creat the table with
CREATE TABLE chartab (
.
) TYPE=MyISAM CHARSET=utf8;
then I tried to insert utf-8 data, using a file with sql statements:
mysql
Lingua2001 [EMAIL PROTECTED] wrote:
If not, is there a way to get the same effect in MySQL?
Nope. VIEWs currently are not supported in MySQL:
http://www.mysql.com/doc/en/ANSI_diff_Views.html
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is
Hi All,
The 3.23.54 Manual states in;
Section 1.4.4.3 Transactions
If you only obtain a read lock (as opposed to a write lock), then reads and
inserts are still allowed to happen. The new inserted records will not be seen
by any of the clients that have a
David Kruszewski [EMAIL PROTECTED] wrote:
Description:
1: running safe_mysqld it just stops at end of statement
bash-2.05a# safe_mysqld
Starting mysqld daemon with databases from /var/lib/mysql
030618 10:09:11 mysqld ended
You can find what was wrong in the error log file
K.L. [EMAIL PROTECTED] wrote:
The 3.23.54 Manual states in;
Section 1.4.4.3 Transactions
If you only obtain a read lock (as opposed to a write lock), then reads and
inserts are still allowed to happen. The new inserted records will not be seen
by any of
So, when client X has Read lock, the client Y cannot have Write lock, Egor?
Iulian
- Original Message -
From: Egor Egorov [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, June 18, 2003 1:33 PM
Subject: Re: Lock Tables - Manual Ambiguity
K.L. [EMAIL PROTECTED] wrote:
The
Actually, I think the more appropriate fix for this problem, would be to do
what a call to mysql_escape_string does.
The problem occuring is common, the characters being used are taken
literally as part of the string, rather than as quotes what you want them
as. MySQL's C library has the
[snip]
The argument usually used by people looking for
- triggers
- functions + procedures
- foriegn keys
is the persuit of data integrity, and encapsulating business logic
within the
database.
Whilst this goal is noble, it can be fully achieved within the
application
code, and not in the
Primaria Falticeni [EMAIL PROTECTED] wrote:
So, when client X has Read lock, the client Y cannot have Write lock, Egor?
Yes, if client X obtaines read lock on the table client Y can't have write lock on
this table until client X releases lock.
Iulian
- Original Message -
From:
OK, I have been working on this for the last day. I read the manual
sections that were recommended on floating point calculations and I am
still seeing some weird things.
I simply want to see if the average value of two columns named upper and
lower (both are decimal(20,8) unsigned) is within
Hi,
I think this is an error, anyways i'm trying to join 6 tables together.
and when i do EXPLAIN SELECT i get the message in comments
Impossible WHERE noticed after reading const tables
this is my statment basically
SELECT table1.id
FROM table1,table2,table3,table4,table5,place
WHERE
Primaria Falticeni wrote:
Why nobody answered me?
I posted two questions on this list.
When did the website claim that all questions would be answered on the
list? More importantly, as someone else has already pointed out, please
consider paying for support if you really want guaranteed
Joanne Yow [bizfront] wrote:
Hi,
I am trying to install MySQL 3.23 to Solaris 2.8.
After the step - scripts/mysql_install_db
I try the command - chown -R root, error show usage: chown [-fhR] owner[:group]
file...
You entered the command incorrectly.
You gave it no files or directories to
Hi,
I saw the error.
For interested it is in the place.latitude BETWEEN section
Anthony
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I'm new to mysql. Currently I am using php myadmin to manage my database. I'd like
to be able to export mysql database as xml and, in turn, import the xml into a
filemaker pro 6.0 database. If someone else has worked on something similar, any
advice would be very appreciated.
Thanks!
-Zac
PROCESSLIST shows this for the offending process:
| 77 | cpms | localhost | cpms | Query | 8076 | update | INSERT INTO
cpms_orders (order_id, add_timestamp) VALUES ('20030618-3', now()) |
I've still got it running, if anyone has any suggestions for a way to
get more debug data. The mysql
Thanks to all. Simon's response outlines the direction I will be headed.
KC
[snip]
The argument usually used by people looking for
- triggers
- functions + procedures
- foriegn keys
is the persuit of data integrity, and encapsulating business logic
within the
database.
Whilst this goal is
Please note, as always that 72.83% of all statistics are made up on the
spot.
As someone (who, specifically, is oft-disputed) once said:
There are three kinds of lies: lies, damn lies, and statistics.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From:
Hello everyone,
I am running MySQl and PHP on a Mac OS Jaguar. When I try to restart
my MySQL Local Server using mysqld_safe, but I keep getting this error
[psg:/usr/local/mysql] psgarcha% sudo echo
Password:
[psg:/usr/local/mysql] psgarcha% sudo ./bin/mysqld_safe
[4] 524
Joanne Yow [bizfront] schrieb:
I am trying to install MySQL 3.23 to Solaris 2.8.
After the step - scripts/mysql_install_db
I try the command - chown -R root, error show usage: chown [-fhR] owner[:group]
file...
and the command - chrgrp -R mysql, error show chgrp [-fhR] group file...
$ man
Hey gang...
In my dbMove application I have the following.
Ask SQL how many records I am moving- OK
Display that amount - OK
Delete all from corresponding MySQL table - OK
Long pause, get a coffee, take a nap
java.sql.SQLException: Communication
Sometime recently Zac Korpi said:
I'm new to mysql. Currently I am using php myadmin to manage my database. I'd like
to be able to export mysql database as xml and, in turn, import the xml into a
filemaker pro 6.0 database. If someone else has worked on something similar, any
advice
Hi All,
I hope someone can help with this connection problem.
We have MySQL 4.0.12 installed on a W2K server and we are using the
Connector/J version 3.0.7 driver to connect our Java applet to the
database. The applet and the database are both on the same machine.
I recently changed my kernel (as noted in another message) to one that
supports ACPI (for my laptop running RH9) and a couple other patches (I
don't know all of them, one may have been the preemptive kernel patch).
I've installed MySQL 4.0.12 from RPM's on the myslq.com site. When I
start mysql
I need to find out why the mysqld is not starting up ? Can someone
please throw some light to the location of this file on a Mac?
Thanks in adavnce.
--Pushpinder
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
What problems am I going to have with 3.23, 4.0.13, and 4.1 alpha installed
on the same machine (Win XP?)
I am developing some software and wanting to test against these versions but
I am starting to have intermittent problems with MySql-Front where it
declares that a table is now missing.
Pushpinder Singh Garcha wrote:
Hello everyone,
I am running MySQl and PHP on a Mac OS Jaguar. When I try to restart
my MySQL Local Server using mysqld_safe, but I keep getting this error
[psg:/usr/local/mysql] psgarcha% sudo echo
Password:
[psg:/usr/local/mysql] psgarcha% sudo
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
John R Langan wrote:
Hi All,
I hope someone can help with this connection problem.
[snip]
When attempting to connect from the PC on the intranet the trace gives
the following:
java.lang.ClassNotFoundException: com.mysql.jdbc.Driverat
No. It complains as well. The error I get
Can't open file: platforms.InnoDB
The funny thing is that I have never seen a file ending with Innodb. I
created this table just last night of type InnoDB and the extension was .frm
Reggie
-Original Message-
From: Primaria Falticeni
The most sure way is to keep the same version of server on the same
database. If you want to test more versions make one database per server
version.
Iulian
- Original Message -
From: Reggie Burnett [EMAIL PROTECTED]
To: 'Primaria Falticeni' [EMAIL PROTECTED]
Cc: 'MySQL LIST' [EMAIL
Hello... I am currently working on a User Account Management
system. I am actually a Unix SA who is moonlighting at work as a MySQL
DBA and web developer. I am learning a lot and enjoying the work, but I am
severely lacking in database design fundamentals. I have created a couple
very
How do you DELETE or RENAME a table?
Thanks.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On Wed, Jun 18, 2003 at 12:13:16PM -0400, [EMAIL PROTECTED] wrote:
How do you DELETE or RENAME a table?
Search the manual. The answer is there. :-)
--
Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo!
[EMAIL PROTECTED] | http://jeremy.zawodny.com/
MySQL 4.0.13: up 15 days,
DROP TABLE tablename;
ALTER TABLE tablename RENAME newname;
http://www.mysql.com/doc/en/ALTER_TABLE.html
http://www.mysql.com/doc/en/DROP_TABLE.html
Regards,
Mike Hillyer
www.vbmysql.com
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 18,
[EMAIL PROTECTED] wrote:
How do you DELETE or RENAME a table?
Thanks.
alter table TABLENAME rename NEWNAME;
drop table TABLENAME;
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hello everyone,
I am unable to start the mysqld, i keep getting mysqld ended error.
-
[psg:/usr/local/mysql] psgarcha% sudo ./bin/mysqld_safe
[5] 703
[psg:/usr/local/mysql] psgarcha%
After testing a lot of different configurations (which was quite a
headache), I came up with the following. First of all, for both speed
and reliability, you will want SCSI. The list of reasons are quite long
for SCSI, and as you are doing research on the subject, it is an obvious
choice and I
I figured it out. The between clause needs lower then upper, and I had
upper then lower. The extraneous values I found must have been
artifacts from the abs comparison, which was clearly not working anyway.
I am just going to use the between clause. It seems to return the
results I expect.
Hi,
I am getting the error
You have an error in your SQL syntax near 'select max(news_id) from news)'
at line 1
while trying to run this query.
SELECT * FROM News where News_ID = (SELECT MAX(News_ID) FROM News);
The table type is INNODB. Is it some MySQL related problem because I know
the
# [EMAIL PROTECTED] / 2003-06-18 12:24:06 -0400:
[psg:/usr/local/mysql] psgarcha% sudo ./bin/mysqld_safe
[5] 703
[psg:/usr/local/mysql] psgarcha% Starting mysqld daemon with databases
from /usr/local/mysql/data
030618 11:50:09 mysqld ended
[5]Done sudo
Hi Folks,
so there I am,
mysql server version 3.23.49-8.4
OS linux debian woody
box type i386
I've set up binlogs in my.cnf
I do get the binlog files created and rotated this with flush logs as
master reset.
I have the checkpoint and log_pos table set up.
what I do not get is that the binlog
If you're using a non-persistent connection, PHP will close the
connection when the script terminates, and the MySQL server will roll
back
implicitly. For a non-persistent connection, the connection remains
open
and you may not see the rollback behavior your expect.
I thought this was
Hi,
I am trying to do something like:
select distinct S.US_FOLIO US_FOLIO
, ifnull(SD.US_FOLIO,'false') FOLIO2
from SEGUIMIENTO S
,SEGUIMIENTO_DETALLE SD
where S.US_FOLIO=SD.US_FOLIO(+)
this is using Oracle,
[snip]
Let's say that I have users Mary, Joe, Frank, and Dan. I also have
servers panther, cheetah, jaguar and lion. The data for each account that I
want to maintain is UID, GID, home directory, and default shell.
In designing a table or tables to handle this example what can I
make as a
Hey gang... sorry, I duped the subject of someone elses message... so I'm
going to send this again
In my dbMove application I have the following.
Ask SQL how many records I am moving- OK
Display that amount - OK
Delete all from corresponding MySQL
Muazzam Siddiqui wrote:
Hi,
I am getting the error
You have an error in your SQL syntax near 'select max(news_id) from
news)' at line 1
while trying to run this query.
SELECT * FROM News where News_ID = (SELECT MAX(News_ID) FROM News);
You don't say what version of MySQL you are running.
Try something like
select distinct S.US_FOLIO US_FOLIO
, ifnull(SD.US_FOLIO,'false') FOLIO2
from SEGUIMIENTO S LEFT OUTER JOIN SEGUIMIENTO_DETALLE
SD
on (S.US_FOLIO=SD.US_FOLIO)
-Original Message-
From: Gustavo Mejia
Just a couple of quick notes:
1. While I use PHP CLI for a lot of things (can we say cron?), it is not
a sufficient replacement for triggers. What happens when someone is
using the Mysql command prompt to alter data? Or using a non-PHP
application?
2. While I agree that having application code
What sort of throughput are you seeing in that setup?
God, I can't remember anymore. I can run a test again though. If you
have one you want me to run, just send it. We don't have other people's
money to spend, so all our disks are U160 18GB 15K IBM. They were less
than $100 each when we got
On Fri, 30 May 2003, Jeremy March wrote:
The problem is that querying with a LIKE expression is treated case
and accent sensitive. [...] Has anyone else experienced this with
multibyte utf8?
Yes. mysql-standard-4.1.0-alpha-pc-linux-i686 running with
--default-character-set=utf8 gives me:
Hey,
Here is what I want to do
I have 2tables
let's say table A and B for simplicity.
in table A I have column id
and in table B I have column A_id
I insert a new value into table A insert into a values(NULL)
Since id is auto_incremenet and the primary key it will have an auto value.
Now I want
This is a rather long message but I am stuck and am really in a bind so
I wanted anyone who might be willing to point me in the right direction
to have the full picture.
I recently installed MySql 4.0.13 on a Intel Linux box running Red Hat
9. I used the RPM that I found on the MySQL site. I
Check out LAST_INSERT_ID() in the manual
-Original Message-
From: Jonas Geiregat [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 18, 2003 12:26 PM
To: 'Mysql'
Subject: probably a stupid question
Hey,
Here is what I want to do
I have 2tables
let's say table A and B for simplicity.
in
Hello,
I have had problems with some of our equipment and copying the files
around if they are greater than 2gb (one of our nfs file servers is not
large file safe). Because on occasion I have had to copy InnoDB files
around and hit this problem we have been using 2gb InnoDB files.
Does using
---Original Message-
--From: Adam Nelson [mailto:[EMAIL PROTECTED]
--Sent: Tuesday, June 17, 2003 11:56 AM
--To: 'Bernd Jagla'; 'mysql'
--Subject: RE: RAID hardware suggestions/experience
--
--We recently bought a kick $%#%% machine for ~10k
--
--HP DL380
--2x2.8GHz Xeon
--1GB RAM
--5
On 18-Jun-2003 NIPP, SCOTT V (SBCSI) wrote:
Hello... I am currently working on a User Account Management
system. I am actually a Unix SA who is moonlighting at work as a MySQL
DBA and web developer. I am learning a lot and enjoying the work, but I
am
severely lacking in database
I'm using php + mysql for my project
I want to get the last insert ID.
I could use the php function mysql_last_id();
but I could aslo use @@identity.
Now some people have advised me NOT to use @@identity, cause it's not
save buggy sometimes slow ..
is this true am I better of with the php
This may not be the correct solution exactly, but what I do to ensure that I
get the correct ID back is the following:
I know what I just inserted, therefore I can use this information in a WHERE
clause to ensure retrieving the correct ID.
Example: INSERT name='scott', age=20 into
On 18-Jun-2003 Jonas Geiregat wrote:
snip
I insert a new value into table A insert into a values(NULL)
Since id is auto_incremenet and the primary key it will have an auto
value.
Now I want that the column A_id contains that id nr.
I could query for the biggest id in column A and insert
The below query is not good, due to the fact that if name and age aren't
unique, I'll be returning multiple ids with it. One should always use the
LAST_INSERT_ID() or after an insert, select max(id) from myTable.
-Original Message-
From: Carter, Scott [mailto:[EMAIL PROTECTED]
Sent:
On Wednesday 18 June 2003 13:59, Carter, Scott wrote:
This may not be the correct solution exactly, but what I do to ensure that
I get the correct ID back is the following:
I know what I just inserted, therefore I can use this information in a
WHERE clause to ensure retrieving the correct ID.
Wednesday, June 18, 2003, 2:38:53 PM, you wrote:
---Original Message-
--From: Adam Nelson [mailto:[EMAIL PROTECTED]
--Sent: Tuesday, June 17, 2003 11:56 AM
--To: 'Bernd Jagla'; 'mysql'
--Subject: RE: RAID hardware suggestions/experience
--
--We recently bought a kick $%#%% machine for
Where'd you get it. I've had bad experiences with generic machines but
I'll take a peak if you send the link?
There are a couple of things I didn't mention
2U Form Factor with tool-less rails
Redundant Power Supply
Redundant Fans (any 2 fans can go)
Battery Backed RAID for full commit even on
One should always use the
LAST_INSERT_ID() or after an insert, select max(id) from myTable.
Select max(id) from myTable should never be used to get the last insert id.
On a high traffic table you are not guaranteed it will be the ID for the
record you just inserted, another could have been
Following select statement works OK on Localhost, OK within Dreamweaver
test, OK on phpmyadmin on site, BUT NOT OK on webpage.
It's the IF part where it states if(m.matchtypeid 3, etc
Here on the webpage itself it shows the 'in-/uitschrijven' or 'gesloten'
bit on those lines where it
On 18-Jun-2003 Jonas Geiregat wrote:
I'm using php + mysql for my project
I want to get the last insert ID.
I could use the php function mysql_last_id();
but I could aslo use @@identity.
Now some people have advised me NOT to use @@identity, cause it's not
save buggy sometimes slow ..
is
2 x 2.8 GHZ Xeon
4 GB of RAM
5 15K SCSI Drives
ICP SCSCI RAID control card with 1 Gb of ram on it.
I just bought 30 of these boxes to build out my mysql farm for close to
400-600 queries a second with 60 connections a second of mix read /
writes.
What kind of queries are you doing? Our
The download bundle for MySQL Solaris SPARC 32-bit includes instructions
for installing Windows and Linux versions, but apparently not Solaris SPARC versions.
(There are notes, but not instructions)
Can anyone please point me to installation instructions for Solaris SPARC?
-Doug
--
MySQL General
I tried to copy a table and got this mesagem, but I ´ve done this several
times ago...
Got error -1 from table handler
Hi,
with MySQL 3.23.x i was able to retrieve information about Foreign keys by
using the JDBC's method getImportedKey.
The same code running on MySQL 4.0.13 alway return a null vector.
I'm using mysql-connector-java-3.0.8-stable-bin.jar to access MySQL.
There's somthing that I must set on MySQL
Don Read wrote:
On 18-Jun-2003 Jonas Geiregat wrote:
I'm using php + mysql for my project
I want to get the last insert ID.
I could use the php function mysql_last_id();
but I could aslo use @@identity.
Now some people have advised me NOT to use @@identity, cause it's not
save buggy sometimes
Thank you for your reply, Edward,
And, where's the repository?
Lingua
- Original Message -
From: Becoming Digital [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, June 18, 2003 1:04 AM
Subject: Re: is CREATE VIEW possible in MySQL?
You have to implement the view functionailty
I'm getting this error in my log:
--
030618 15:08:24 mysqld started
030618 15:08:24 InnoDB: Started
030618 15:08:24 /usr/sbin/mysqld: Can't create/write
to file '/var/run/mysqld/mysqld.pid' (Errcode: 2)
/usr/sbin/mysqld: ready for connections.
Version: '4.0.12'
Hi,
What would happen to my_table (~70MB of indexes) and its indexes if someone kills a
an optimize table query - 'OPTIMIZE TABLE my_table' . Im wondering if i should provide
a cancel button in my application during the optimization period. It is generally more
user friendly to provide one,
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Luca wrote:
Hi,
with MySQL 3.23.x i was able to retrieve information about Foreign keys
by using the JDBC's method getImportedKey.
The same code running on MySQL 4.0.13 alway return a null vector.
I'm using
From: Paul DuBois [mailto:[EMAIL PROTECTED]
At 21:09 +0200 6/16/03, Fernando Martins wrote:
In AUTO_INCREMENT fields, inserting a 0 into the field requests a new
sequence number.
Is it possible to turn off this behaviour? (without messing with
the code,
of course)
No.
Using NULL to
Hi all,
Is it possible to crypt the passwords on MySQL. If yes, how does it
work, and how is it to be implemented.
Any link would be great.
Thank you.
Grégoire Dubois.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
At 23:50 +0200 6/18/03, Fernando Martins wrote:
From: Paul DuBois [mailto:[EMAIL PROTECTED]
At 21:09 +0200 6/16/03, Fernando Martins wrote:
In AUTO_INCREMENT fields, inserting a 0 into the field requests a new
sequence number.
Is it possible to turn off this behaviour? (without messing with
There is a PASSWORD('your_clear_text_password_here') function you can use
wherever you define a new password. See the manual for more.
Lian
-Original Message-
From: Grégoire Dubois [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 19, 2003 12:55 AM
Cc: 'Mysql'
Subject: Can we crypt
Hi,
Using PASSWORD function to crypt password is not recommended, it's mainly
used for internal mysql password encryption.
Prefer using MD5/SHA1 functions to encrypt a password.
Regards,
Jocelyn
- Original Message -
From: [EMAIL PROTECTED]
To: Grégoire Dubois [EMAIL PROTECTED]
Cc:
A lot of table scans do to bitmasked column values.
So
SELECT * FROM search_table where AND colN 4;
Such that the above query will not utilize a key.
I was told at the last convention that mySQL had some good ideas on
allowing indexes for bitwise (arithmetic) columns but they are not
I've googled, but haven't got a hit, so please excuse if this has been
covered many times before.
System: linux, (debian for what it matters)
tomcat 4.0
java 1.3.1
mysql 2.23.x
Curently we are using the older org.gjt.mm.mysql.Driver drivers.
We support many different
John,
what Linux kernel version you are running? Did the first crash occur because
of the same assertion failure?
The InnoDB tablespace is probably corrupt and it asserts in purge or insert
buffer merge.
You can try starting with
innodb_force_recovery=4
in the [mysqld] section of your my.cnf.
I am trying to install MySql++. When I issue the
./configure command all seems to go well until it
generates an error which you can see below.
The version I am trying to install is 1.7.9 from
memory. I am using Mandrake 9.1 which has MySQL as one
of the installable options, which I have chosen.
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
William R. Mussatto wrote:
I've googled, but haven't got a hit, so please excuse if this has been
covered many times before.
System: linux, (debian for what it matters)
tomcat 4.0
java 1.3.1
mysql 2.23.x
Curently we
At 13:14 2003-06-17, Bernd Jagla wrote:
Sorry I forgot to mention:
We are using IRIS on an Origion2000, 7GB memory, 8 CPUs. I was thinking of
spending up to $10K.
I also wanted the redundant data for speeding up the seeks, I also need to
speed up the writes.
Bernd
I assume You mean IRIX on O2k.
1 - 100 of 125 matches
Mail list logo