Donna Robinson wrote
> I am using OpenBSD 2.8
Why 2.8?
> and spent a frustrating evening last night trying to
> make MySql come to heel. Installed just fine - the first sign of
something
> not right was inability to complete the "run-all-tests" scripts - just
hung
> there gobbling up 95% CPU.
On Mon, 08 Apr 2002 21:04:36 -0500
"Terry & Cheryl Haimann" <[EMAIL PROTECTED]> wrote:
> I have installed mysql-3.23.49a from an rpm(both the development and the client) on
>a Redhat 7.1 system. After installation I
> ran the mysql_install_db. Now everytime I try to run any of the client progr
Hi Aleksandar,
On Mon, Apr 08, 2002 at 04:43:11PM +0200, Aleksandar Bradaric wrote:
> > Table example:
> > _The Rock
> > Scary Movie
> > X-Files
>
> > With order I want the output
> > Scary Movie
> > _The Rock
> > X-Files
>
> After reading your message again, look like this is what
> you've
On Tue, 9 Apr 2002 13:17:59 +0800
Alvin Chen <[EMAIL PROTECTED]> wrote:
> hi. I'm using MySQL 3.23.38, default settings for the mysql variables(my-large.cnf),
> linux 2.2.14-5.0smp kernel - Red Hat 6.2, Records 140750, Size 101.0 MB, mem 1G, CPU
>PIII 800.
> But for some reason queries take too
hi. I'm using MySQL 3.23.38, default settings for the mysql variables(my-large.cnf),
linux 2.2.14-5.0smp kernel - Red Hat 6.2, Records 140750, Size 101.0 MB, mem 1G, CPU
PIII 800.
But for some reason queries take too many time.
During the long query, I did a "mysqladmin proc" to see what was goi
At 22:21 8/4/2002 +0200, ServiceCenter resources wrote:
Hi!
>I have a problem with my MySQL server, it has started to stop working
>after approximately 10 days of uptime.
Seems to me an issue in your environment, not a MySQL service code
issue. Take a look in the properties of the service calle
On Tue, 9 Apr 2002 10:15:00 +0530
"pradeep" <[EMAIL PROTECTED]> wrote:
> Hi ,
> I m new to MYSQL. While trying to run the deamon safe_mysqld .I am getting
> the following message.
> ***
> ./safe_mysqld
> chown: unknown user id m
Hi...
You need to create a user mysql and also create a group mysql and add the user
to the group..You will find this in the installation docs..
regards
kannan
"pradeep" <[EMAIL PROTECTED]> on 04/09/2002 10:15:00 AM
Hi ,
I m new to MYSQL. While trying to run the deamon safe_mysqld .I am getting
the following message.
***
./safe_mysqld
chown: unknown user id mysql
Starting mysqld daemon with databases from /usr/local/mysql/var
020408 05:30:51
On Mon, Apr 08, 2002 at 11:33:02AM -0600, Barry Blatz wrote:
>
> I have a system here based on Red Hat's 7.2 distribution and I am
> wanting to get MySQL up and running. After browsing your web page
> it seems that I will have go to a different version of gcc. Would I
> be safe to go to the late
i'm building a table in MYSQL that has about 30 fields..
is this inefficient to have a large number of columns?
if anyone can direct me to some good info on efficient design tips/
techniques i'd be grateful.
thanks
dan
---
Gilbert,
You wrote:
> 7) More problems, use 'locate' to delete all (I thought) mysql files;
don't
> think I really did delete all of them though.
...
> I was thinking of updating the 'locate' database, and then searching for
all
> files that have 'mysql' in them, again. Is this the best way to
This has come up before. In fact, I had the exact same problem. You can
see the the thread "Coredump when running scripts/mysql_install_db " at
http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:msp:93051
The conclusion is in "Problem with setrlimit on HPUX 10.20" at
http://lists.mysql.com/cgi-ez
At 17:52 -0700 4/8/02, Jim Dickenson wrote:
>I am having problems getting the "load data local infile" working.
>
>I am running Mac OS X 10.1.3 build 5Q110 with all available updates
>installed.
>
>I had installed version 3.23.49 from
>http://www.entropy.ch/software/macosx/mysql/ and found that a
At 21:14 -0400 4/8/02, Carl Schmidt wrote:
> If I set a mysql table def time to default like so:
>
> eventTime time NOT NULL DEFAULT '0';
>
> Will it default to the current time like the TIMESTAMP does? If not, is
> it possible with something like CURTIME() to make this happen?
No.
>
> Car
I have installed mysql-3.23.49a from an rpm(both the development and the client) on a
Redhat 7.1 system. After installation I
ran the mysql_install_db. Now everytime I try to run any of the client programs, I
get an illegal instruction(core dump.) What
do I need to do to make this a working
If I set a mysql table def time to default like so:
eventTime time NOT NULL DEFAULT '0';
Will it default to the current time like the TIMESTAMP does? If not, is
it possible with something like CURTIME() to make this happen?
Carl
--
I am having problems getting the "load data local infile" working.
I am running Mac OS X 10.1.3 build 5Q110 with all available updates
installed.
I had installed version 3.23.49 from
http://www.entropy.ch/software/macosx/mysql/ and found that a change was
made in verion 3.23.49 as related to the
If your databases have any size to them (like more than 1/2 the amount of
ram you have), you'll need to manage memory. SQL Expects to be an only
child. Check out sp_configure in books on line to learn how to limit the
amount of RAM sql will take
At 06:56 PM 4/8/2002 -0500, Tod Harter wrote:
On Friday 05 April 2002 02:25, David Williamson wrote:
> Hi there,
>
> I will shortly be installing a MySQL server at my place of work, the box I
> will be installing it on currently has MS SQL server running as well. (I
> believe its a "wintel" box).
> Anyway, I am wondering if there are any know
On Friday 05 April 2002 11:32, Steve Rapaport wrote:
> I'm currently running MySQL for a big, fast app without
> problems. BUT:
>
> I'm in the middle of specifying a new application with a high
> load, and I'm consideing looking for alternatives to MySQL
> because without InnoDB, it gets really s
On 8 Apr 2002, at 18:18, Ari B Kahn wrote:
> OK. Now notice that insFreq has DOUBLED when used in conjunction with
> with delFreq!
> mysql> select t1.andersonStart_pos, sum(t2.insFreq), sum(t1.delFreq)
> from InsertionFreq t2, DeletionFreq t1 where (t2.andersonStart_pos =
> 1072) and (t1.ande
Hi,
I've built MySQL++ 1.7.9 libs on an smp machine. But every application which
is built using mysql++ crashes with segfault when invoking connect() method.
For example:
#include
#include
void main()
{
try
{
Connection con( use_exceptions );
con.connect();
}
c
I have MySQL v. 3.23
The SUM function seems to be doubling one of my values when used in
conjunction with another SUM function.
Here I show that I have only 95 in insFreq:
mysql> select t2.andersonStart_pos, sum(t2.insFreq) from InsertionFreq
t2 where t2.andersonStart_pos = 1072 group by t2.and
it worked for me:
mysql> describe t_timesheet;
++---+--+-+-++
| Field | Type | Null | Key | Default | Extra |
++---+--+-+-++
| id | int(11) | | PRI | NULL|
still OT, but here goes anyway...
you can in fact use PHP or ASP or whatever to generate PDFs. See
http://www.pdflib.com/pdflib/index.html
> -Original Message-
> From: va ku [mailto:[EMAIL PROTECTED]]
> Sent: Monday, April 08, 2002 5:04 PM
> To: Christopher Thompson; [EMAIL PROTECTED]
I have a table with the following fields:
id=autoincrement, int (11)
ts_h=decimal
ts_pid=int (11)
ts_day=text
There is a unique record where ts_pid=60 and ts_day="2002032800"
(ts_h=0).
If I do [update t_timesheet set ts_h=0 where ts_pid=60 and
ts_day="2002032800" ],
Hi,
Thanks for the reply. I also need few 'doc' features such as
1. Bold letters
2. Formatted paragraphs
The document I want to take a report is a student declaration form
where on top it will display student details in the middle the declaration and at the
end Signature. The document consists
>Description:
1. Distributed Binary version crashes with scripts/mysql_install_db
Output vvv
Preparing db table
Preparing host table
Preparing user table
Preparing func table
Preparing tables_priv table
Preparing columns_priv table
Insta
[EMAIL PROTECTED] wrote:
>
> I read somewhere that mysql reads /etc/my.cnf before it does any
> command line options, is this correct? If so, how can I have a my.cnf
> file
> and then run two servers if I have to have a [mysqld] section in the
> my.cnf
> file that tells the server which port and
Thanks! Thats a great help.
I didn't know that about the performance advantage. I was using INT but
thought SMALLINT might be better cos it uses less space. Much obliged.
- Original Message -
From: "Madscientist" <[EMAIL PROTECTED]>
To: "'Luke van Blerk'" <[EMAIL PROTECTED]>
Sent: Monday
Yes, I found this about 2 seconds after I sent my email..
However, I still can not get mysql to run on either
a) different ip address on port 3306
or
b) same ip address on port 3307
Either way, I get the error:
020408 15:47:00 mysqld started
020408 15:47:00 Can't start server: Bind on
this is actually OT, btw, but I'll try to answer...
> need to make it smaller. Is it possible to somehow store
> these descriptions
> in a mysql table or on another page and then have them linked
> to when you
> put your mouse over the link?
No.
There are methods of accessing databases from t
WinXp
Crashed my D: drive and I had most everything backup..
So when I reinstalled ActivePerl 5.6.xx I downloaded via PPM
(perl package installer) the DBI, DBIx::AnyDBD but could not find
DBD:mysql. Where is the package for Windows..
I did find, at CPAN, the mysql.gz.tar version which I use
I have a problem with my MySQL server, it has started to stop working after
approximately 10 days of uptime. After a reboot it works fine again. The users get the
error "can't connect to server on localhost".
I also have a testserver with similar setup, on that MySQL has run for 54 days with n
Hey Guys,
I'm not sure if this is the right place to ask this question, but to be
honest I didn't know where else to turn since my script deals with mysql.
Here's my problem:
I am using stylesheets and javascript to display a small blurb about a
review on my site and it display is in a stylesheet
Hi,
You give up so quicly?
What OS use for MySQL?
- Original Message -
From: Kathy Reyes <[EMAIL PROTECTED]>
To: mysql <[EMAIL PROTECTED]>
Sent: Monday, April 08, 2002 10:10 PM
Subject: Uninstall Mysql
> Can anyone tell me how can I uninstall mysql. I have done it again. I have
> messe
Dear all of member,
Would you help me, how to install, setup, and configure MySQL in my server
with O/S windows 2000 server and IIS v. 5
Thank you,
Best Regards,
-
Before posting, please check:
http://www.mysql.com/manual.
On Mon, Apr 08, 2002 at 03:04:58PM -0500, Johnny Withers wrote:
>
> I need to run two MySQL servers on one machine.
>
> One needs to use /var/lib/mysql.sock
> and the other needs to use /home/mindbender/production/db/mysql.sock
>
> One needs to run on one ip address:
> ie: 10.0.0.10:3306
> and
I need to run two MySQL servers on one machine.
One needs to use /var/lib/mysql.sock
and the other needs to use /home/mindbender/production/db/mysql.sock
One needs to run on one ip address:
ie: 10.0.0.10:3306
and the other on 10.0.0.11:3306
how do I tell mysql to run only on a certain IP addre
On Mon, Apr 08, 2002 at 01:40:02PM -0500, Steve Buehler wrote:
> If I want to use temporary tables I know I can create tables
> that are unique without using "CREATE TEMPORARY TABLE table_name".
> What I want to know, because it might be more efficient, is if I use
> "CREATE TEMPORARY TABLE
Thank You. That is what I was hoping for. I would assume that this would
be faster than actually coming up with a random name, using srand and rand,
for a table, creating it and deleting it when done.
Thanks
Steve Buehler
At 02:19 PM 4/8/2002, you wrote:
>Yes a TEMPORARY TABLE is specific to
Can anyone tell me how can I uninstall mysql. I have done it again. I have
messed up my permission.
I dont know what is is that i'm doing that makes me loose my previleges.
I keep getting the access denied error
Kathy Reyes
Live Technology International
2975 Westchester Avenue
Suite 103
Pu
Hello.
On Mon, Apr 08, 2002 at 11:24:56AM -0400, [EMAIL PROTECTED] wrote:
[...]
> still...I wonder why I got a 'Query OK, 1 row affected' message
[...]
> > insert into table (key, field) values (1, 'test'||CHAR(59)||' string');
> >
> > it seems to work initially...(Query OK, 1 row affected (
On 8 Apr 2002, at 20:20, Roger Baklund wrote:
> The best type to use is the one big enough to hold your expected biggest
> value, but not bigger.
But when calculating your expected biggest value, keep in mind that
the autoincrement counter increases on every attempted insert, even
if the inser
Hi,
Yes, you are right but be aware with the delete cascade feature, maybe in
the way?.
Regards
- Original Message -
From: Carl Schmidt <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, April 07, 2002 7:16 PM
Subject: FOREIGN KEY Constraints
> From the mysql docs, it looks like
If I want to use temporary tables I know I can create tables that are
unique without using "CREATE TEMPORARY TABLE table_name". What I want to
know, because it might be more efficient, is if I use "CREATE TEMPORARY
TABLE table_name" and more than one person hits the page (I am using PH
First, I assume that the same value for "userlevel" may be used by multiple
users. That is, multiple users can have userlevel equal to 1 or equal to 2
or 3 or whatever. Therefore, you CANNOT use userlevel as PRIMARY KEY.
PRIMARY KEY is a UNIQUE identifier. Thus, I recommend that each user be
id
* Tab Alleman
> Anybody have any idea what kind of concurrent user load MySQL is (or at
> least should be) capable of handling?
This depends on a lot of factors, the application and the hardware beeing
the most important ones... the recent benchmark test in eweek may give you
some hints:
http://
At 12:48 -0400 4/8/02, Jay Hill wrote:
>I'm having trouble keeping MySQL running on my computer (PowerBook
>G3 -Firewire, 576MB RAM, G3/400 - 40GB HD with plenty free in the
>main OS X partition). I'm running OS X 10.1.3.
>
>1. I installed MySQL (binary) in \Users\hill\MySQL\ directory
>(logg
* Luke van Blerk
> What is the best field type to use for an ID field which is the
> primary key and auto-increment?
>
> I wanted to use SMALLINT UNSIGNED because its half the bytes of
> INT but was
> wondering what happens when it reaches 65535, does the auto-increment go
> back to 1 or will it
FieldID INT UNSIGNED DEFAULT '0' NOT NULL,
-Original Message-
From: Soheil Shaghaghi [mailto:[EMAIL PROTECTED]]
Sent: Sunday, April 07, 2002 11:10 PM
To: [EMAIL PROTECTED]
Subject: RE: Help with Tables Please
Thanks for the tip Dan,
I changed it, but it still gives me the same error.
Hello.
I'm using MySQL-3.23.38 on 5 RedHat 7.1/7.2 servers composed by one master
and 4 mysql slave, every write is made on the master and then replicated to
the slave.
The problem is that if one client crash or must be rebooted i've to:
- on the mysql master stop mysql, delete binlogfile, tar
Hi,
I am setting up a mysql database, with two tables. One keeps the user
authentication info such as user name, password and user level. The other
table with contains files for upload and download. Is there a good way to
setup the user authentication table so it can check appropriate user rights
Also, the CREATE TABLE statement doesn't look right. It should probably
be:
create table 185_s_Prices (
PriceID INT NOT NULL DEFAULT 0,
Service CHAR (80),
Category CHAR (20)
);
See the MySQL Manual section on "CREATE TABLE".
On Mon, 8 Apr 2002, Jim Swanson wrote:
> I have a script I'm
I have the same exact setup down to the hardware (believe it or not).
Your best game plan is to install the MySQL binary distro into
/usr/local/mysql as the root user. And then run the MySQL server as root.
You'll have to start the MySQL Server when you start the laptop.
Otherwise, you can log ou
The semi-colon (;) after "Service CHAR(80)" should be a comma (,).
On Mon, 8 Apr 2002, Jim Swanson wrote:
> I have a script I'm trying to run through the mysql command. When I run
> the script, I get a 1064 error, specifically
>
> CREATE TABLE 185_s_Prices\g
>
> PriceID INT NOT NULL DEFAUL
I have a system here based on Red Hat's 7.2 distribution and I am wanting to
get MySQL up and running. After browsing your web page it seems that I will
have go to a different version of gcc. Would I be safe to go to the latest
version (3.0.4) of gcc?
Barry Blatz
Pason Systems Corp.
(403) 301-3
Hi,
I don't know is this is the correct form.
I am looking for some help in developing report on Java. I am using
MYSQL and Java for development.
I need to generate a formatted output which contains values from
database, some paragraphs etc. I am expecting a report in 'doc' or 'rtf' or 'pdf
Anybody have any idea what kind of concurrent user load MySQL is (or at
least should be) capable of handling?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
Hi everyone,
What is the best field type to use for an ID field which is the primary key
and auto-increment?
I wanted to use SMALLINT UNSIGNED because its half the bytes of INT but was
wondering what happens when it reaches 65535, does the auto-increment go
back to 1 or will it cause an error?
looks to me like the error is with the semicolon at the end of the
Service CHAR (80);
That would indicate the end of the statement, not that something follows
Rance Hall
308.238.2455
Internal Office Extensions: 2455 or 6655
PC Programmer, The Buckle, Inc.
[EMAIL PROTECTED]
-Original Mes
ERROR 1064 at line 1: You have an error in your SQL syntax near ' ' at
line 1
- perhaps you'd prefer the semicolon to complete your query -
C:~
-Original Message-
From: Jim Swanson [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 08, 2002 9:07 AM
To: [EMAIL PROTECTED]
Subject: SQL S
You have a semicolon(;) after the line
Service CHAR (80)
Besides after CREATE TABLE tablename syntax you have to define the columns
and their datatypes in parenthesis.
See: http://www.mysql.com/doc/C/R/CREATE_TABLE.html
Gurhan
-Original Message-
From: Jim Swanson [mailto:[EMAIL PROTE
Victoria,
Thanks for replying. How does one know what parameter to pass on as
"position", in other words how do I know from what point to start the
roll-forward from the binlog? What's more what format is this parameter?
(timestamp, integer??)
Thanks,
Balteo.
P.S. I tried "mysqlbinlog --help" b
I'm having trouble keeping MySQL running on my computer (PowerBook G3
-Firewire, 576MB RAM, G3/400 - 40GB HD with plenty free in the main
OS X partition). I'm running OS X 10.1.3.
1. I installed MySQL (binary) in \Users\hill\MySQL\ directory
(logged in as me/hill, not root)
2. I can run the
Thanks, It worked :)
It was my mistake!
Thanks again,
Soheil
Soheil,
Monday, April 08, 2002, 7:09:44 AM, you wrote:
SS> Thanks for the tip Dan,
SS> I changed it, but it still gives me the same error.
SS> Any other suggestion?
hm ... I have tested your example and it worked fine ...
What ver
Hello!
On your homepage i have seen that you did Benchmark tests with MYSQL and MS
Access 2000(on Windows) and compared the Benchmark results. I also want to do
this but i dont know how to do such Benchmarktests on MYSQL and Access
because i am a beginner in working with these databases.
so pleas
After a orderly system and MySQL shutdown and restart of both slave and master,
replication failed to start on the slave. Any suggestions on how to get
replication going again without shutting down, taking a snapshot and
starting replication would be greatly appreciated.
The error logs on th
Thanks, I got it :) I am using phpMySQL and command line and I couldn't see
anything because it was showing everything but now I am cool. Again everyone
thanks.
Chuck Payne
On 4/8/02 12:03 PM, "Rick Emery" <[EMAIL PROTECTED]> wrote:
> SELECT name,birthday FROM mytable
>
> -Original Message
6.6.2 DESCRIBE Syntax (Get Information About Columns)
http://www.mysql.com/doc/D/E/DESCRIBE.html
... aka MySQL(homePage)->Search::.
C:~
-Original Message-
From: Rick Emery [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 08, 2002 9:04 AM
To: 'Chuck "PUP" Payne'; MySQL Mailing List (E-ma
sometimes, all you can say is
LOL
and walk away shaking your head...thinking...
*...the poor guy actually went to the trouble of defeating the filter,
only later to invite the flames of hell upon his head*
> -Original Message-
> From: va ku [mailto:[EMAIL PROTECTED]]
> Sent: Monday, Ap
SPAM ALERT
-Original Message-
From: va ku [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 08, 2002 11:04 AM
To: [EMAIL PROTECTED]
Subject: mysql
mysql
See Dave Matthews Band live or win a signed guitar
http://r.lycos.com/r/bmgfly_mail_dmb/http://win.ipromotions.com/lycos_02
0201/s
select name, birthday from ??? order by name;
Along those lines anyway.
Chuck \"PUP\" Payne wrote:
> *
> This Message Was Virus Checked With : SAVI 3.54 Feb 2002
> Last Updated 25th March 2002
>
>From the limited info given, I'd say you need to use the WHERE clause in
your SELECT statement.
SELECT * FROM blank WHERE something=something
Mike
- Original Message -
From: "Chuck "PUP" Payne" <[EMAIL PROTECTED]>
To: "MySQL Mailing List (E-mail)" <[EMAIL PROTECTED]>
Sent: Monday, April
I have a script I'm trying to run through the mysql command. When I run
the script, I get a 1064 error, specifically
CREATE TABLE 185_s_Prices\g
PriceID INT NOT NULL DEFAULT 0,
Service CHAR (80);
Category CHAR (20),<--- here
Can anyone tell me what's wrong with th
have got a backup script that locks the MySQL tables then use cp to copy
the tables.
It then tar, then zips them up.
So my queston is what is the minimum privileges that this MySQL back user
needs just to lock tables?
Thanks
Simon Green
--
Live Life in
SELECT name,birthday FROM mytable
-Original Message-
From: Chuck "PUP" Payne [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 08, 2002 10:49 AM
To: MySQL Mailing List (E-mail)
Subject:
Ok, I know I am going to get yell about this but how can I do an SQL and
only show to fields from a tab
mysql
See Dave Matthews Band live or win a signed guitar
http://r.lycos.com/r/bmgfly_mail_dmb/http://win.ipromotions.com/lycos_020201/splash.asp
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual
Chuck,
Monday, April 08, 2002, 6:49:20 PM, you wrote:
CPP> Ok, I know I am going to get yell about this but how can I do an SQL and
CPP> only show to fields from a table. For example I only like to see the names
CPP> and birthday? Or will as so all fields for a given table.
If you want to see da
On Monday 08 April 2002 9:49 am, Chuck \"PUP\" Payne wrote:
> Ok, I know I am going to get yell about this but how can I do an SQL and
> only show to fields from a table. For example I only like to see the names
> and birthday? Or will as so all fields for a given table.
SELECT field1, field2 FRO
Hi there,
currently I am using a single server for my webapp. Within
the next days I get another box which will host the
mysql-database (which is currently running on the other server).
I want to set up replication between the 2 ones, using my current
server as SLAVE and the new on as master. D
Chris,
Monday, April 08, 2002, 4:52:26 PM, you wrote:
CL> I'm having some trouble with mysql.. Running the mysql_install_db renders
CL> this...
CL> Installing all prepared tables
CL> At this point the script locks at this point & won't go any further.
CL> I am using
CL> MySQL-3.23.49a-1.i386
Soheil,
Monday, April 08, 2002, 7:09:44 AM, you wrote:
SS> Thanks for the tip Dan,
SS> I changed it, but it still gives me the same error.
SS> Any other suggestion?
hm ... I have tested your example and it worked fine ...
What version of MySQL server do you use and how did you changed column
ty
root,
Monday, April 08, 2002, 12:24:42 PM, you wrote:
r> i tried to use the foreign key feature in mysql 4.0.1 using innodb tables .
r> then i have tried the delete cascade feature but it didn't work . I don't
r> know why ? have you any suggestions ? .
InnoDB does not yet support ON DELETE C
I am trying to restore some data from the binary log and I am not sure on
b> how to proceed.
b> I understand restoring data is a two-stage process:
b> 1. You start by restoring data saved with mysqldump.
b> 2. Using mysqlbinlog, you restore the data logged in the binary log from the
b> point wh
Carl,
Monday, April 08, 2002, 3:16:26 AM, you wrote:
CS> From the mysql docs, it looks like you can only use foreign keys if your
CS> tables are type InnoDB. Is this correct?
Yes, you are right. In MyISAM tables you can use REFERENCE
clause, but it does nothing.
CS> Carl
--
For t
豤Èñ,
Monday, April 08, 2002, 10:44:47 AM, you wrote:
> I Wonder If Cross Comile is Possbile.
Yes, it's possible, but this case needs deep involvement and a long-time check-up
works... Maybe Monty will clarify something.
> I was trying to make Makefile by using configure shell script(Mysql 4
Taavi,
Monday, April 08, 2002, 3:39:29 PM, you wrote:
TT> Is it possible to add new 8-bit character encoding to compiled
TT> mysql (version 3.23.49-win) without recompiling?
No, you should re-configure and re-compile after adding new character
set. You can read instruction how to add new charact
Ok, I know I am going to get yell about this but how can I do an SQL and
only show to fields from a table. For example I only like to see the names
and birthday? Or will as so all fields for a given table.
Chuck Payne
-
Before
Hi.
Have a look at http://www.mysql.com/doc/E/x/Extensions_to_ANSI.html
(rather at the end). || has a different meaning in MySQL started
without explicit --ansi. Also see
http://www.mysql.com/doc/A/N/ANSI_mode.html.
Bye,
Benjamin.
On Mon, Apr 08, 2002 at 11:08:15AM -0400, [EMAIL PROTEC
nevermind...instead of using '||' to concat the fields i needed to use the CONCAT()
function. So the syntax should have been:
insert into table (key, field) values (1, CONCAT('test',CHAR(59), ' string'));
still...I wonder why I got a 'Query OK, 1 row affected' message
-Don
>
The only thing I wish is to know who his client was or is and set them
straight on MySQL and get some extra work ;). Probably trying to sell them
the hacker proof Oracle..LMAO.
MySQL Select *
-
Before posting, please check:
Subject: Re: 200 milions records
From: Vic Cekvenich <[EMAIL PROTECTED]>
===
1. Use PostgreSQL.
2. Use multi channel disk cache controller
3. Get rid of not NULL.
4. index a primary seqnecy key
It should be subsecond.
Vic
ddd wrote:
> HI,
>
> I want to insert into db 200.000.000 records of
Hi guys,
Our java code blows up when we try to insert a string with a ';' inside of it. So we
tried to do a work-around by replacing ';' with '||CHAR(59)||' to insert it, using the
char function and the character's respecitve ascii value. So instead of:
insert into table (key, field) values (1
>-Original Message-
>From: Hugh O'Loughlin [mailto:[EMAIL PROTECTED]]
>Sent: Saturday, April 06, 2002 7:32 AM
>To: [EMAIL PROTECTED]
>Subject: Do any of your applications work?
>
>
>Responsible Person,
>We have been asked by a client, to use your products in our intergration
>efforts. You
Hi,
> Table example:
> _The Rock
> Scary Movie
> X-Files
> With order I want the output
> Scary Movie
> _The Rock
> X-Files
After reading your message again, look like this is what
you've been searching for. Sorry :(
select * from movies order by substring_index(movietitle, '_', -1);
And
At 21:36 -0700 4/7/02, Son Nguyen wrote:
>--- BD <[EMAIL PROTECTED]> wrote:
>> Son,
>>
>> At 09:48 PM 4/7/2002, you wrote:
>> >mysql> desc threads;
>>
>>+-+--+--+-+-++
>> >| Field | Type | Null | Key | Default | Extra
Hi Marc,
Thanks for the suggestion. I hope you would be kind enought to
provide another. My application is "transactional", in the business
sense, in that, at the point of sale, the transactions must be quick.
So inventory must be updated quickly to move the people through the
line. The qu
hmmm, it's gotta be a troll. I'm so gullible I don't even
know if it is or not. If it is, life is good. My favorite it the
church lady who storms the linux groups and demands that they stop
supporting this operating system because she has ample proof that it is
being run on web servers that
1 - 100 of 125 matches
Mail list logo
