Hello, what is the best way to handle record id in MySQL? Has MySQL
some kind of automatic record id?
/Peter
--
I´m using
MySQL 3.23.39-nt, Windows 2000 Server
--
-
thank you.. for your answer... i think i know what wrong it is.. :).
-Original Message-
From: "Chris Bolt" <[EMAIL PROTECTED]>
Date: Wed, 25 Jul 2001 22:29:00 -0600
To: <[EMAIL PROTECTED]>
Subject: RE: Invalid SQL..?
Re: >>> Database error: Invalid SQL: select id, subid from policy whe
> I need to build a search utility which can query records based
> on multiple text parameter,
> my table will have about 10 fields and users can search on
> 3-5 parameters in one query. is there any way to achieve this
> other than doing a full table scan.
http://www.mysql.com/doc/F/u/Fullt
When compiling with gcc3.0 mysql 3.23.4 I get the following error trying to
link the mysqlbinlog (I think) any idaes?
Rick
lmach -lexc
mkdir .libs
gcc -O3 -DDBUG_OFF -O3 -felide-constructors -fno-exceptions -fno-rtti
-fno-implicit-templates -fno-exceptions -fno-rtti -o mysqlbinlog
mysqlbinlog.o
But what happens when the customer returns the product? You no longer
have the cC to do a chargeback
On Wed, 25 Jul 2001, Elvis wrote:
> Date: Wed, 25 Jul 2001 20:53:26 -0400 (EDT)
> From: Elvis <[EMAIL PROTECTED]>
> To: Steve Brazill <[EMAIL PROTECTED]>
> Cc: Fletcher Sandbeck <[EMAIL PROTECT
Hi,
I am having some trouble connecting to a database through DBI. I get the error in my
error log:
DBI->connect failed: Can't connect to local MySQL server (2)and then the name
of the script.
I have had no troubles up until the last 24 hours, and it happened all at once. I have
the
Hi! How are you?
I send you this file in order to have your advice
See you later. Thanks
"MMS " made the following
annotations on 07/25/01 21:49:44
--
[ALERT] -- Virus Manager:
Viruses were detected in this message a
> I am currently trying to examine the benefits of continuing to
> use MySQL over Oracle. I need to know what MySQL's features are
> vs. those of Oracle.
http://www.mysql.com/information/crash-me.php
> Also I am looking for performance data.
Oracle prohibits benchmarks, so good luck finding the
Hello
I need to build a search utility which can query records based
on multiple text parameter,
my table will have about 10 fields and users can search on
3-5 parameters in one query. is there any way to achieve this
other than doing a full table scan.
thanks
raghu
---
>>> Database error: Invalid SQL: select id, subid from policy where
>>> id='2' and subid='0'
>>> MySQL Error: 1054 (Unknown column 'id' in 'field list')
>>> Session halted.
>
> the output look like this..
> mysql> desc policy;
> +++--+-+-+---+
> | Field
> SELECT * FROM listaemail WHERE id LIKE "%%" OR nome LIKE "%%" OR empresa
> LIKE "%%" OR email LIKE "%%" OR ativo LIKE "%%" ORDER BY nome;
>
> Time: 11 Lock_time: 0 Rows_sent: 30567 Rows_examined: 30568
>
> before anyone jumps out and points it out, it is far
> from being optimized. it should (an
> Hi,
>
> I have looked through the documentation (http://www.mysql.com/docs)
> and the mailing list archives
> (http://www.geocrawler.com/lists/3/Databases/8/0/)
> and find no mention of a feature that I was hoping was available:
>
> * text or varchar columns that are automatically compressed/u
Hi folks.
I have a local Access database here which I have created tab seperated
text files of each of the tables from to import into the Mysql db we are
running on our ISP's server.
However I have one field in one of the tables that is a text file and
contains sometimes very long descriptions o
I think it is time for you to learn about regular expressions; page 520 ff
of Dubois.
(sql, mysql, database - to get past the filter)
At 01:14 AM 7/26/01 +0100, you wrote:
>Hi all,
>
>I have a problem, I have some VARCHAR data in a column called Sequence
>looking like this:-
>
>5;6
>12;6
On Wed, 25 Jul 2001, Paul DuBois wrote:
> I doubt if "they" are trying to irritate you. The maximum size of a MySQL
> database depends on your file system constraints, not on the size of
> a LONGTEXT.
> Some OSes have a max file size of 2GB, for example; others don't.
Linux ext2 filesystem onl
I think it is time for you to learn about regular expressions; page 520 ff
of Dubois.
(sql, mysql, database - to get past the filter)
At 01:14 AM 7/26/01 +0100, you wrote:
>Hi all,
>
>I have a problem, I have some VARCHAR data in a column called Sequence
>looking like this:-
>
>5;6
>12;6
>120;
I recently moved my MySQL databases from one RedHat Linux 6.x machine to a new RedHat
7.0 machine. Now, I can't seem to add databases. I get the following error message:
"mysqladmin: CREATE DATABASE failed; error: 'Can't create database 'jrtest'. (errno:
13)'"
And, I think I lost some sequenc
I would suggest that you use an INT column type to store the ip address.
This would use a lot less space than a varchar column (when dealing with the
magnitude that you describe)... the smaller the faster... The following
functions make this very easy:
INET_NTOA and INET_ATON
They are described
At 10:11 PM -0500 7/25/01, Mike wrote:
>I have throughly looked at the documentation and I am beginning to
>get frustrated. It says that a LONGTEXT field's max length is L+4
>bytes, where L < 2^32. I understand the extra 4 bytes(+4) which is
>to keep track of the size sense LONGTEXT is no more
I have throughly looked at the documentation and I am beginning to get frustrated. It
says that a LONGTEXT field's max length is L+4 bytes, where L < 2^32. I understand the
extra 4 bytes(+4) which is to keep track of the size sense LONGTEXT is no more than a
really big VARCHAR field. If my calc
Since the dump is ascii text with lots of repeating characters, it should
zip or gzip quite nicely.
The compressed file will take a lot less time in transfer over FTP, if
network time/bandwidth is a problem. This becomes important when doing
over-WAN stuff.
The time involved for 1-3GB arch logs (c
At 7:53 PM -0600 7/25/01, David Lott wrote:
>(please reply directly)
>
>
>I'm new to mysql and I'm working on a design for an application that
>will require a LOT of lookups on IP addresses. Data set is on the
>order of millions of addresses. In my reading, I have not
>encountered a TYPE of i
At 10:17 AM +1000 7/26/01, Alan Tse wrote:
>I have a date field, how do I check if it is null or
>empty in sql statement.
>
>I tried :
>select *
>
>where fDate = NULL;
Wrong test. NULL is special. Use:
where fDATE IS NULL
>
>and also tried
>where fDate = '';
>
>Both return nothing but act
(please reply directly)
I'm new to mysql and I'm working on a design for an
application that will require a LOT of lookups on IP addresses. Data
set is on the order of millions of addresses. In my reading, I have not
encountered a TYPE of ip_address or some such. Did I miss it?
If th
Apologies in advance:
I am a developer with mysql and active and my work
involved CAPI of MYSQl,Database DeZign with Dezign and
database development.
Currently looking out for job opportunities in mySQl
related areas.Can suggest me any exclusive websites
and openings in mysql related areas.
..
Could anyone shed some light on how to go about uploading a text file with a
web interface using php into a mysql database. wow, that was a mouthfull.
I would much appreciate it.
Kit
_
Get your FREE download of MSN Explorer at h
maybe below info answer your question.
--- copy from mySQL Reference Manual for version 3.23.22-beta, section
7.3.6.2 The DATETIME, DATE and TIMESTAMP types ---
Illegal DATETIME, DATE or TIMESTAMP values are converted to the ``zero''
value of the appropriate type ('-00-00 00:00:00', '-00
You can always degrade the credit card.
1) verify AUTH ONLY (not capture) with your CC provider. (if you want to verify they
have funds available and the CC is valid)
2) store the CC # in the database
3) ..do your order processing thing or whatever you need to have the CC for...
4) capture fund
Hi all,
I am currently researching an issue with slave thread terminating when an
error occurs.
background:
Win2000 server SP2
MySQL server/client ver 3.23.38
MySQL ODBC ver 2.50.33
Program language Clarion 5.5
Our database program can insert and update records without a problem. When a
new rec
I have a date field, how do I check if it is null or
empty in sql statement.
I tried :
select *
where fDate = NULL;
and also tried
where fDate = '';
Both return nothing but actually there are records
with no value.
__
At 6:52 PM -0400 7/25/01, Alan Zaitchik wrote:
>I know I've seen the solution to this somewhere...
In the manual:
http://www.mysql.com/doc/W/i/Windows_running.html
You want to use mysqlc, not mysql.
>Running bin\mysql in a DOS window I find that my up arrow will not recall
>commands from a co
Hi all,
I have a problem, I have some VARCHAR data in a column called Sequence
looking like this:-
5;6
12;6
120;6
5;6;1
12;6;12
120;6;105
So there could be anything from 2 to n numbers seperated by ;
Each number could be 1 to 3 digits long (eg 5 12 or 121).
I have tried various searches like
Hi everyone!
I just install the RH 7.1 with mySQL.
I'm developer JAVA, and I'd like to know how I start
the service (mysql) on linux RH 7.1.
The directory is
/usr/share/mysql
I want to set the port and create a table.
I know the comand to create a table, insert data and
so on...
But I dont know
AND, you'd want to 'protect' the data from viewing if you've 'dumped' the
database or backed it up to an 'insecure' media or location (to
tape/disk)... Encrypting the data, with the 'key' or 'salt' located
somewhere else, would allow you to 'transport' the tables containing the
sensitive data
I know I've seen the solution to this somewhere...
Running bin\mysql in a DOS window I find that my up arrow will not recall
commands from a command buffer, even when DOSKEY is loaded in the parent DOS
window. But I know that on a Linux machine where I used to run mysql I could
up arrow through pr
In possibility 1, if the database is truly running on local, you should be
able to:
a)mysqldump --all-databases > all_that_dump.sql
b)mysql (logon stuff for remote machine) < all_that_dump.sql
Because the database is running on local the client (mysql) should also be
loaded.
Have a great da
MyVbQL is a direct interface to MySQL databases ... you don't need to use the ADO/ODBC
combination ... you can get some more details on the MyVbQL web page ...
http://www.icarz.com/mysql/index.html
Eric
Stephen Sherlock wrote:
> I've been told that it's possible to connect directly to a mySQ
On 7/25/01 at 7:12 PM, Alexander Skwar wrote:
> However, if you need to reconstruct it, nothing is safe. And that's
> quite simple:
> a) You need to get access to the MySQL server. Impossible to do from
> the outside if '--skip-networking' is used.
> b) So, only possible from the localhost. Th
On Wed, Jul 25, 2001 at 07:12:17PM +0200, Alexander Skwar wrote:
[snip]
> 'encryption'? Hmm, how about: none? If you don't need to reconstruct
> the cc#, md5 will be good.
Indeed. That is however rarely the case with credit card numbers.
> However, if you need to reconstruct it, nothing is saf
>>> >>I've been trying upgrade our current MySQL 3.23.39 to the 3.23.40 I have tired
>with both the binary distro and source distro with no luck. The install seems to go
>OK, but I can't start the mysql server. This is on a RH/Linux 6.2 Kernel 2.4.6 i686
>system.
>>>
>>> Please disregard thi
Anyone,
I've noticed that when I do a mysqldump, all of the backup information is
also written into the binary log. Am I doing something wrong or is there a
way to not log the mysqldump??
Thanks,
Phil
-
Before posting, plea
Greetings all,
I have a RedHat 7.1 on i386 (Pentium III), and I am trying to build the
2.23.40-1 src rpm, and I get the following error:
---
th-extra-charsets=complex --exec-prefix=/usr
--libexecdir=/usr/sbin --sysconfdir=/etc
--datadir=/u
Mysql:
We have installed mysql 3.23.26 beta version to a BSD 4.2 server. It works
fine, however when we test a php file which just function to insert some
data to a table in database, and display all data on the web page. After
run this, the data have been inserted and displayed; however,
At 4:08 PM -0500 7/25/01, MikeBlezien wrote:
>On Wed, 25 Jul 2001 16:04:17 -0500, Paul DuBois <[EMAIL PROTECTED]> wrote:
>
>>>Source distributions don't really come with any table handler enabled
>>>by default, because there are no binaries included in the distribution.
>>>To see what options co
Hi All:)
I'm running mysql-3.23.30-gamma on FreeBSD 4.3-stable and running into a
problem with max file sizes.
I've got a table, names, which is taking 4294967288 bytes. I notice this
is 8 bytes less than 2^32, so I assume there's a 32 bit pointer issue
within mysql somewhere.
large_files_supp
We have an optimization question that probably could be easily resolved
with some of the additional features of some commercial database products,
but, being stubborn about migrating away from MySQL (What can't it do
again?) I'm looking for a solution to a particular design and optimization
issue
Sorry ---
How about this WITHOUT SELECT:
---
INSERT INTO Table VALUES(Lamer_ID, ENCRYPT("you are
lame...!","sa"));
---
uses the unix-crypt()-function, means, i
"MikeBlezien" <[EMAIL PROTECTED]> writes:
> Hello All,
>
> >>I've been trying upgrade our current MySQL 3.23.39 to the 3.23.40 I have tired
>with both the binary distro and source distro with no luck. The install seems to go
>OK, but I can't start the mysql server. This is on a RH/Linux 6.2 Ker
I posted a question a couple weeks back and received some half-dozen or so
responses, thankyou. I also bought a mysql/php book, which also has helped.
What I finally came up with (on my own no less) is the following -
printf("* %s
%s %s",
$row["bulletin_subject"], $row["bulletin_date"], $row
On Wed, 25 Jul 2001 16:04:17 -0500, Paul DuBois <[EMAIL PROTECTED]> wrote:
>>Source distributions don't really come with any table handler enabled
>>by default, because there are no binaries included in the distribution.
>>To see what options control the table handlers, run this command:
>>
>>
How about this:
---
INSERT INTO Table VALUES(Lamer_ID, SELECT ENCRYPT("you are
lame...!","sa"));
---
uses the unix-crypt()-function, means, its a One-Way-Crypt!
sa must be a 2-char lo
At 2:55 PM -0500 7/25/01, MikeBlezien wrote:
>Hello All,
>
>>>I've been trying upgrade our current MySQL 3.23.39 to the 3.23.40
>>>I have tired with both the binary distro and source distro with no
>>>luck. The install seems to go OK, but I can't start the mysql
>>>server. This is on a RH/Linux
> Dear Peter,
>
> > Even if i delete the record where id=65535
> > DELETE FROM cust WHERE id=65535
> > AUTO_INCREMENT starts with 65535 and i cant add any more records.
>
> Sad, but true, MySQL "remembers" the biggest number inserted into an
> auto_increment column. If you delete the row in ques
On 25-Jul-2001 S A wrote:
>
> Do the names of indexes have any significance to MySQL internals or is the
> name merely a convenience for the DB operator ?
>
> For now I try to match the index names to the column names used but I'm
> wondering if the name matters at all.
>
It doesn't.
As a ma
> Do the names of indexes have any significance to MySQL internals
> or is the name merely a convenience for the DB operator ?
Well, "PRIMARY KEY" does carry some significance... ;-)
Other than that, no. But you need them if you should ever
want to do an ALTER TABLE to change the index definiti
I think mysqld may have a problem parsing long lines in my.cnf. I recieve
the following error when trying to start mysqld:
/usr/local/libexec/mysqld: unrecognized option `--r3/ibdata31:2G'
Here is the line that is offending mysqld (it is all one line in my.cnf). If
I remove or shorten this line
Do the names of indexes have any significance to MySQL internals or is the name merely
a convenience for the DB operator ?
For now I try to match the index names to the column names used but I'm wondering if
the name matters at all.
thanks,
- Sam.
-
Do You
If this is a MyISAM table you can use myisamchk to set the auto_incriment
value. Check out the man page.
ryan
- Original Message -
From: "Stefan Hinz" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; "Peter Wiherkoski"
<[EMAIL PROTECTED]>
Sent: Wednesday, July 25, 2001 12:15 PM
Subject: Re:
Hello All,
>>I've been trying upgrade our current MySQL 3.23.39 to the 3.23.40 I have tired with
>both the binary distro and source distro with no luck. The install seems to go OK,
>but I can't start the mysql server. This is on a RH/Linux 6.2 Kernel 2.4.6 i686
>system.
Please disregard this
> Did you read about optimizing joins?
Yes I've read the manuals & docs.
I see in the manual a section entitled "Optimising LEFT JOIN and RIGHT JOIN" but my
JOIN in question is neither LEFT or RIGHT.
Can you please point me at some specific URLs ?
thanks,
- Sam.
Werner Stuerenburg <[EMAIL PRO
Hi,
I have configured MySQL with charset latin2 on a Linux box. I made a big
table with a mediumtext filed and a search engine using MySQL
match-against. On the Linux box everything looked fine. Now we replaced
our server to FreeBSD. I compiled the same source with the same
configuration settings
George,
current binary versions do not yet support
rows of size > 8000 bytes. The next binary
version 3.23.41 will do it.
If you want right now to use > 8000 byte rows,
you have to download the source distribution
innodb-3.23.39b from www.innodb.com, replace
the InnoDB files in the source distri
You probably want to GRANT ALL ON oneDatabase.* TO login@%. I can't
image a situation where letting everyone see everything (including
the mysql database with all the permissions) would ever be a good
idea.
Walter
At 7:44 PM +0200 7/25/01, Stefan Hinz wrote:
>Dear KJ,
>
>> How can
>> I set up
I am currently trying to examine the benefits of continuing to use MySQL
over Oracle. I need to know what MySQL's features are vs. those of Oracle.
Also I am looking for performance data. What kind of scalability does MySQL
have vs. that of Oracle. Is there (or will there be) any support in MyS
hello kynn,
you have to :
first you must UNDERSTAND the USER-table from mysql-DB on your box.
from that point you are able to insert directly values into USERS like
values into any other MySQL-Table:
example:
INSERT INTO USER VALUES
('localhost','Testuser','PASSWORD('little
lamer'),'Y','Y',
the output look like this..
mysql> desc policy;
+++--+-+-+---+
| Field | Type | Null | Key | Default | Extra |
+++--+-+-+---+
| service_charge | int(2) | | | 0 | |
+-
Hello All,
I've been trying upgrade our current MySQL 3.23.39 to the 3.23.40 I have tired
with both the binary distro and source distro with no luck. The install seems to
go OK, but I can't start the mysql server. This is on a RH/Linux 6.2 Kernel
2.4.6 i686 system.
The main problem seems to be,
Dear Jay,
1st possibility:
a) mysqldump --all-databases > all_that_dump.sql
b) FTP all_that_dump.sql to remote machine
c) [on remote machine:] mysql < all_that_dump.sql
2nd possibility: Like above, but using PhpMyAdmin (www.phpmyadmin.com)
for writing to (a) and reading from (c) dump file. Yo
Dear KJ,
> How can
> I set up users so that they do not need to supply a password to use
> mysql?
Use MySQL Monitor (the command line tool, mysql) and type:
GRANT ALL ON *.* TO ""@%
This will grant all rights on all databases and tables to anyone ("")
from anywhere (%) without password.
R
Dear Peter,
> Even if i delete the record where id=65535
> DELETE FROM cust WHERE id=65535
> AUTO_INCREMENT starts with 65535 and i cant add any more records.
Sad, but true, MySQL "remembers" the biggest number inserted into an
auto_increment column. If you delete the row in question, the next
i
So sprach »Alan Cox« am 2000-02-20 um 11:57:47 -0500 :
> Greetings: I was wondering if anyone has any ideas about the best way to
> store credit cards in a database ... and I'm not referring that much to the
> field type, but rather encrytption techniques.
'encryption'? Hmm, how about: none? If
Depending on the 'environment' (i.e. O/S you're using), the tools available
might be different...
But, using Linux (and I'm sure any other 'flavor' of Unix), my company
used the latest 'libmcrypt' to encrypt the credit card numbers (as well as
the user passwords) within a PHP function prior to
Hello,
Try
SELECT messages.message_id, messages_1.message_id
FROM messages as messages_1
INNER JOIN connections
ON messages_1.message_id = connections.child
INNER JOIN messages
ON messages.message_id = connections.parent
ORDER BY messages.message_id, messages_1.message_id
or
SELECT messages.me
to all, warm regards from brazil.
here's the plot: my isp has been complaining
for last couple of days about this query,
generated automatically by a query generator
(no, duh??)...
SELECT * FROM listaemail WHERE id LIKE "%%" OR nome LIKE "%%" OR empresa
LIKE "%%" OR email LIKE "%%" OR ativo LIKE
in the mysql command line, try this:
use databasename;
repair table tablename;
(repeat that last line for each of your tables)
I haven't tried myisamchk at all. This is what I use.
Walter
At 12:13 PM -0400 7/25/01, Marko Andrus wrote:
>Hi-
>
>I am getting error 127 and I cant seem to get the m
Dear Zhang,
check for the "regular expression" section in the MySQL manual. You can
filter out any patterns you want with RegExp :)
Regards,
--
Stefan Hinz
Geschäftsführer / CEO iConnect e-commerce solutions GmbH
# www.js-webShop.com www.iConnect.de
# Gustav-Meyer-Allee 25, 13355 Berl
Dear /roger,
some suggestions ...
- Check mysqladmin variables to get the value for "datadir" (that's
where the server will expect the mysql database (containing the host
table) to be.
- Check /etc/my.cnf to see if the datadir variable has been set
correctly.
Obviously, your server does not fi
Dear Maggie,
http://mysql.com/Downloads/MySQL-3.23/mysql-3.23.39-win.zip has a
SETUP.EXE which will install MySQL (database server plus client tools to
work with the server) - by default it will install in C:\mysql. After
setup, it's easiest to restart Windows. Now, the MySQL server should
load.
>> Only use placeholders. $dbh->quote() is unreliable (and this fact is
>> documented in DBI documentation).
PD> Please show me the part of the documentation that you're referring to,
PD> and please supply a counter-example. quote() is extremely useful for
PD> producing SQL statements that will
At 9:02 AM -0700 7/25/01, John Meyer wrote:
>http://builder.cnet.com/webbuilding/0-7537-8-6580620-1.html?tag=sd
>
>It's a general overview of MySQL, but it's a pretty fair comparison.
From the article:
>Transactions and commit/rollback is another management feature
>that's not directly suppor
At 4:47 PM +0200 7/25/01, Peter Wiherkoski wrote:
>Hi, got a problem:
>
>My table (part of it) looks like this:
>CREATE TABLE cust (
>id SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT,
>name CHAR(30) NOT NULL,
>PRIMARY KEY (id)
>);
>
>When i type
>INSERT INTO cust VALUES(NULL,"Peter");
>the value of id
At 5:23 PM +0400 7/25/01, Ilya Martynov wrote:
>PD> At 10:43 AM +0530 7/25/01, [EMAIL PROTECTED] wrote:
>>> Hi,
>>>
>>> I just want to know how to insert a BLOB data type in a field of a
>>> table. I want to put the binary data stream not the file link in the
>>> filed. The language i m using
Greetings: I was wondering if anyone has any ideas about the best way to
store credit cards in a database ... and I'm not referring that much to the
field type, but rather encrytption techniques.
Thanks.
Alan Cox
[EMAIL PROTECTED]
---
Hi,
It seems like what you are trying to do is select all messages
that have child messages and display the results sorted by the
parent message ID.
How about...
select
messages.message_id,
messages_1.message_id
from
messages,
connections,
messages messages_1
Hi-
I am getting error 127 and I cant seem to get the myisamchk command to work for me.
Can anyone help me with this issue?
Is there a phone-based support option available? Money is no object - I am desperate
and looking to fix this issue before my client finds out.
Thanks,
Marko
At 10:44 AM -0600 7/25/01, Michael Nezi wrote:
>Saw your post on mysql.com and wondering if you could help me.
Working with the Mac OS X Terminal
Mac OS X comes with a Terminal application that can be used for
issuing instructions to the OS from a command line. You will find it
necessary at ti
I recently did my first mySQL installation (the OS is Linux). How can
I set up users so that they do not need to supply a password to use
mysql?
I want to be able to issue commands like
mysql -e "select host,db,user from db" mysql
instead of having to do something like
mysql -e "select
Hi,
I have looked through the documentation (http://www.mysql.com/docs)
and the mailing list archives
(http://www.geocrawler.com/lists/3/Databases/8/0/)
and find no mention of a feature that I was hoping was available:
* text or varchar columns that are automatically compressed/uncompressed
I
Hello !
This is a syntax taken from MS Access:
SELECT messages.message_id, messages_1.message_id
FROM messages AS messages_1 INNER JOIN (messages INNER JOIN connections ON
messages.message_id = connections.parent) ON messages_1.message_id = connections.child
ORDER BY messages.message_id, messag
I hope this is not to stupid.
I have looked at how to encrypt strings in my database. I know that you need
to use a blob
and I think I can figure out how to encrypt from a query or SELECT but how
do I
encrypt on the INSERT.
Thanks for your help
Jason
--
Try doing it as root if you're not already.
Tyler Longren
Captain Jack Communications
[EMAIL PROTECTED]
www.captainjack.com
- Original Message -
From: "Michael Nezi" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, July 25, 2001 11:08 AM
Subject: Problems running ./mysql_ins
hi all,
I'm having a problem wrt character sets in mysql. i'm trying to add the euro
symbol to a table (MyISAM), but it seems that it is being replaced with '?'.
Having looked into the problem a bit, I assume it is that the table is using the
default latin1 character set, which does no
- Original Message -
From: "Jay McGarry" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, July 25, 2001 7:57 AM
Subject: Mysql
> what's the easiest way to transfer a local database to a remote one?
Depends on many factors really. Are you doing this as a one-off thing or
some
When installing mysql the only problem I receive is the following
which cannot install the grant tables. I am unable to view the log
because my access is denied.
What to do? Anyone?
[localhost:/usr/local/bin] nezi% ./mysql_install_db
mkdir: /usr/local/var/mysql: Permission denied
chmod: /us
http://builder.cnet.com/webbuilding/0-7537-8-6580620-1.html?tag=sd
It's a general overview of MySQL, but it's a pretty fair comparison.
John Meyer
[EMAIL PROTECTED]
Programmer
If we didn't have Microsoft, we'd have to blame ourselves for all of our
programs crashing
what's the easiest way to transfer a local database to a remote one?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this threa
Hi, got a problem:
My table (part of it) looks like this:
CREATE TABLE cust (
id SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT,
name CHAR(30) NOT NULL,
PRIMARY KEY (id)
);
When i type
INSERT INTO cust VALUES(NULL,"Peter");
the value of id will increase by 1 every time i insert a record.
By "misstak
On 2001 Jul 23, [EMAIL PROTECTED] wrote:
> >Description:
> Whenever I compile mysql 3.23.40 with Berkeley DB support,
> I get a signal 11 when attempting to start the mysql server.
> If I omit Berkeley DB support, everything starts fine.
> >Synopsis:solairs 8 x86 get signal
Stephen,
you have to add to the my.cnf or my.ini file
the following parameters, to the [mysqld] section:
Suppose you have a Windows NT machine with 128 MB RAM and a single 10 GB
hard disk. Below is an example of possible configuration parameters in
`my.cnf' for InnoDB:
[mysqld]
# You can write
Artem V. Ryabov writes:
> Hello All,
>
> When I use "order by .. DESC" in query, time always more then in
> "order by .. ASC" case.
> Explain say "Using filesort",in "DESC" case query.
>
> Why???
>
> --
> Best regards,
> Artem mailto:[EMAIL PROTECTED]
Hi!
This i
1 - 100 of 115 matches
Mail list logo
