As far my knowledge goes there is only 1 tablespace available atm.
If you create new datafiles they will get appended to the one and only
tablespace.
IF there would be more than one tablespace you would need to specify one as
default.
You should also be able to "ALTER" a table to another tablespa
Hello,
Can anyone tell me where can i find free mysql test paper
downlodable/online? Is there any such site? I tried to find from
google.com...but there wasn't any favourable result.
Even if anybody has created any test paper or sample test for
person use and would like to share is welcome!
Th
On Tue, Mar 05, 2002 at 01:04:50PM +0530, Battini, Chandrashekar wrote:
> Hi,
>
> As the entries grows in mysql database in linux intel box, the time
> taken to search(select statement) for entries increases
> linearly.
If that's true, you may need to use an index to speed up the query.
This a
Hi,
i want to use MySQL in OpenLDAP 2 instead of the LDBM Database.
I have many questions. Anybody already done this here in the list ??
I tried to build OpenLDAP from the source with SQL support. Configured all as
described in the documentation. I used unixODBC and MyODBC - I don't have any
Hi,
As the entries grows in mysql database in linux intel box, the time taken
to search(select statement) for entries increases linearly. But, when the
entries grows in mysql DB, the time taken to update entries is constant. Why
is it constant at update as entries grows ? Updates includes searc
hello!!
I would like to know about the Database support with QT, specially MySQl, & also
from where can I download these drivers (QMYSQL3)
Regds,
Punita
-
Before posting, please check:
http://www.mysql.com/manual.php (t
On Mon, Mar 04, 2002 at 07:12:32PM -0700, Sasha Pachev wrote:
> On Monday 04 March 2002 02:41 pm, Vladimir V. Kolpakov wrote:
> > --
> > P.S. so far, it's helpful bug: I use it as catch
> > for poor queries!:)
>
> This actually gives me an idea for a
> feature. --disable-disk-temp-tables - fa
On Mon, Mar 04, 2002 at 02:06:00PM -0700, Lopez David E-r9374c wrote:
> Using MySQL 3.23.40
>
> App is logging db with 130 clients to a central MySQL db with 2
> million events per day. Aged events of over 7 days are no longer
> required. The central table is myisam type with fixed size
> (dateti
Hi,
You should use the LOAD_FILE fonction to load your documents in the BLOB
field.
Ex: UPDATE table_name SET blob_column=LOAD_FILE("/some/where/picture");
You could find better explaination of that fonction in the manual at:
http://www.mysql.com/doc/S/t/String_functions.html
Regards,
Sébastie
Hi, please help me with this one!
I now the date_format function, it converts the standard format sql
(-mm-dd)
to any format, but my problem is that i want to convert from another format
(eg. dd/mm/) to the standard format, in this way i can use insert with
my format.
Can I u
Greetings!
If you do not have an index on any column in a table, how does mysql
handle repeated queries (i.e. SELECT * FROM report;)
I am noticing that if I run the following three queries, I get different
results for the third query:
SELECT * FROM report;
SELECT * FROM report ORDER BY lastname
On Monday 04 March 2002 09:32 pm, you wrote:
> On Mon, Mar 04, 2002 at 09:30:16AM -0500, Ken Menzel wrote:
> > Hi Heikki,
> >
> > I don't know if this has been requested, but what about a tool to
> > 'pre-create' dataspace? This tool would allow someone to create a
> > new dataspace, then a qui
On Mon, Mar 04, 2002 at 09:30:16AM -0500, Ken Menzel wrote:
>
> Hi Heikki,
>
> I don't know if this has been requested, but what about a tool to
> 'pre-create' dataspace? This tool would allow someone to create a
> new dataspace, then a quick restart (After adding the name of the
> space to 'my
man crontab
http://www.perl.com
Varsha Gaware wrote:
>Hi !!
>
>Can I schedule a task in mysql ? I want to perform some operation on
>database after a specific period of time. Is it possible ?
>
>Please, tell me the link, from where do I get the information about the
>same..
>
>Waiting for your
On Mon, Mar 04, 2002 at 01:47:42PM -0600, BD wrote:
>
> Jeremy,
>
> PMFJI, but has anyone done any testing to see if persistent
> connections with MySQL and PHP is actually faster in practice?
What's PMFJU?
Without testing, I suspect that it is faster but that the gains are
very small.
On Mon, Mar 04, 2002 at 08:33:27AM -0800, Dreamtime.net Inc. wrote:
>
> We have FreeBSD 4.2-RELEASE and I can't say for sure how much time
> it might take to upgrade to 4.3 or higher. It might take anywhere
> from one reboot to several hours (if something won't work).
Well, if it stops the probl
Hi,all:
Thanks to Egor Egorov, you are right. Also thanks to Rob Emerick.
Unfortunately, I encountered another problem as following:
mysql> explain SELECT max(iSpeed),avg(iSpeed) FROM appsvr_trarte where
lFromTime >= 1009818000 and lFromTime < 1012496400 and iSvrType = 33;
+---
You need to add the 'IN BOOLEAN MODE' modifier. Try:
SELECT * FROM articles WHERE MATCH (title,body) AGAINST ('+database
+tutorial' IN BOOLEAN MODE);
and
SELECT * FROM articles WHERE MATCH (title,body) AGAINST
('+database -tutorial' IN BOOLEAN MODE);
--jeff
- Original Message -
From:
This is the message I am getting. I am currently running MySQL (or trying
to) on a Cobalt Raq3. I recently uninstalled and reinstalled, but am unable
to remove this message. I can't start mysql or do anything. That's the
message I keep getting. Any ideas?
---
On Mon, Mar 04, 2002 at 03:06:46PM -0500, [EMAIL PROTECTED] wrote:
> I am currently implementing a database-ran webserver dll:
> Info:
> Ms Visual C++
> MySQL ++ 1.7.1
> MySQL-nt 3.23.47
> MyISAM db.
> 3or 4 Queries in the application
>
> Biggest Query:
> 66,000 records
> using LIKE "something%"
Hi all.
I have to do an a/v resources reservation application with the following
normalized data model:
Categories
category
name
Inventory
item
category
Reservation
id
date
time_from
time_until
Reservation_details
id
item
Categories holds items in major groups as in 'laptops',
'data projec
On Monday 04 March 2002 02:41 pm, Vladimir V. Kolpakov wrote:
> --
> P.S. so far, it's helpful bug: I use it as catch
> for poor queries!:)
This actually gives me an idea for a feature. --disable-disk-temp-tables -
fail all queries that need a disk temp table, and --restrict-disk-temp-tables
At 18:21 04/03/2002 -0500, [EMAIL PROTECTED] wrote:
Hi,
>Hi Miguel,
> Yes, they are there. Already had the my.ini set up in c:\winnt since I
>needed to specify a non-standard location for my data files.
>(I used the medium conf. file included with the binaries as a starting
>point).
>
> UPDATE:
On Mon, Mar 04, 2002 at 04:29:16PM -0500, Natividad Castro wrote:
>
> Thank you very much!! that was very helpful. By the way, is there
> any other way to get rid of duplicate records from a text file?
I can think of others, but they're not nearly as easy or efficient.
Jeremy
--
Jeremy D. Zawod
Hi Robbie,
There are a few ways you can capture the output to a file..
First of all, you can have all your sql statement in a file , say
myquery.sql file, and call it from command line and redirect it to a
different file such as this:
C:\mysql\bin\mysql < myquery.sql > outputfile.txt
Or, you ca
Hi Miguel,
Yes, they are there. Already had the my.ini set up in c:\winnt since I
needed to specify a non-standard location for my data files.
(I used the medium conf. file included with the binaries as a starting
point).
UPDATE:
I decided to try the install on a different Win2k machine slight
Hi,
On Tue, 2002-03-05 at 10:53, destr0 wrote:
> Is it faster for mysql to return all of the rows in a table, or to return a
> set of rows picked out with a call like LIMIT 20, 40
Well, the server has to first create the whole result set in the proper
order etc, before it can do the limit. But t
As a DOS guy trying to learn linux here ya go
At your dos window type the following:
then Greater Then Sign > then
ourput path and filename, Or output device like LPT1 for printer. Examples
would be;
mysqladmin > commands.txt
The above command should put the commands into a file called co
Section 6.1.6 of the Manual:
(http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.htm
l#Reference)
WHEN is a reserved word.
HTH
Greg
> -Original Message-
> From: Jonathan Farrow [mailto:[EMAIL PROTECTED]]
> Sent: Monday, March 04, 2002 6:45 PM
> To: [EMAIL PROTECTED]
>
My web hosting company recently upgraded me to a new server running
freeBSD. In the process, I find that the sql query that includes the
following statement no longer works:
if (now()-when>200,'!','')
If, however, I add the name of the table "assigned" that contains the
row "when" then it wo
This may be a simple MS-DOS question, but I'm a UNIX guy
and am pretty clueless...
I'm trying to capture some mysql command output, but my
DOS screen runs out of space. In other words, the data
goes beyond what I can scroll up to get. Is there any
way for me to either:
(1) Redirect output
At 16:53 -0800 3/4/02, destr0 wrote:
>Is it faster for mysql to return all of the rows in a table, or to return a
>set of rows picked out with a call like LIMIT 20, 40
The latter. Less traffic over the network.
>
>I tried to test this myself from the shell, but seeing as how it's running
>on lo
System: 600 Mhz Intel desktop importing data from a dual 800 server, DSL connection,
Access
2000(all service packs current), newest MyODBC driver, MySQL 3.22
I have been trying to import tables from a MySQL database using Access
2000, but it takes over an hour for a 5000 record table. The dat
Is it faster for mysql to return all of the rows in a table, or to return a
set of rows picked out with a call like LIMIT 20, 40
I tried to test this myself from the shell, but seeing as how it's running
on localhost I just get 0 seconds everytime.
--
I have a fairly straightforward problem, and I was hoping for some
advice. If anyone can come up with a more elegant solution to this
problem, I'd be grateful.
I'm developing a small web-based PHP application. One of its features
is that users can go to a certain page, enter in some data abo
* Nathan Cowles
> $query2 = "SELECT SEC_TO_TIME(TIME_TO_SEC('$lastout') -
> TIME_TO_SEC('$firstin'))";
> $result2 = mysql_db_query($database, $query, $connection) or die
> ("Error in query: $query. " . mysql_error());
You are assigning the query to $query2, but you execute $query... ;)
--
Rog
>The file is attached and is also available at
>http://estore.homeip.net/time/pctimesheetnew.php.txt.; What do you mean by
>supplying a column alias...how would I do that? Thanks.
Instead of writing:
SELECT some-long-expression
Write:
SELECT some-long-expression AS xyz
Then the output colum
The file is available at
http://estore.homeip.net/time/pctimesheetnew.php.txt.; How would I supply
a column alias? Thanks.
Nathan Cowles
On Mon, 4 Mar 2002, Paul DuBois wrote:
> At 13:54 -0800 3/4/02, Nathan Cowles wrote:
> >lastout and firstin contain times such as 13:28:01 and 13:27:54.
> >
This is what I have on our dual PIII (1.1 Ghz) 1 GB ram
[mysqld]
set-variable = sort_buffer=1M
set-variable = record_buffer=1M
set-variable = table_cache=256
set-variable = key_buffer=128M
set-variable = tmp_table_size=16M
set-variable = interactive_timeout=7200
set-variable = wait_timeout=240
At 13:22 04/03/2002 -0500, [EMAIL PROTECTED] wrote:
Hi!
>Hi All,
> New to mysql. Running: Win2k as Administrator
> mysql-3.23.49-win.zip (binaries)
>
> Keep getting error (complete output below sig):
> mysqld: Table 'mysql.host' doesn't exist
Take a look in the \mysql\d
Description:
According to the manual, new boolean operators should be available in MySQL
v. 4.0.
I have found that the + and - operator does not work at all, as the
testcase below shows.
I have used the fulltext search example from the manual as the testcase:
How-To-Repeat:
CREATE TABLE artic
Hi,
a while ago I had problems with users on mysql.
I am trying to login as root from the local host using password and I get
access denied using password=YES
the host column of my user table is set to % and I have done a flush
privileges
and from other certain hosts I cannot login as root re
At 13:54 -0800 3/4/02, Nathan Cowles wrote:
>lastout and firstin contain times such as 13:28:01 and 13:27:54.
>
>If I use the query you gave me from within phpMyAdmin, the result I get is
>7 seconds, exactly what it should be...but I do not know how to use PHP to
>get the correct result, it is giv
lastout and firstin contain times such as 13:28:01 and 13:27:54.
If I use the query you gave me from within phpMyAdmin, the result I get is
7 seconds, exactly what it should be...but I do not know how to use PHP to
get the correct result, it is giving me 23. I am accustomed to using
mysql_result
At 13:35 -0800 3/4/02, Nathan Cowles wrote:
>Paul,
>
>You're awesome...thank you. One more question pertaining to this...
>
>I'm accustomed to selecting a variable and using something like this:
>
>$firstin = mysql_result($result,$row,firstin);
>
>to set my variable.
>
>What do I want to do here
Paul,
You're awesome...thank you. One more question pertaining to this...
I'm accustomed to selecting a variable and using something like this:
$firstin = mysql_result($result,$row,firstin);
to set my variable.
What do I want to do here to get the right result into my variable?
$query2 = "S
At 16:29 -0500 3/4/02, Natividad Castro wrote:
>Thank you very much!! that was very helpful. By the way, is there any other
>way to get rid of duplicate records from a text file?
What's wrong with the command Jeremy suggested?
>
>Thanks again
>Nato
>
>-Original Message-
>From: Jeremy Zaw
Hi!
This is the test table:
DROP TABLE IF EXISTS asinfo;
CREATE TABLE asinfo (
asinfoID int(10) unsigned NOT NULL auto_increment,
art char(1) binary NOT NULL default '',
KNR char(5) NOT NULL default '',
RECHNR char(6) NOT NULL default '',
POSNR char(2) NOT NULL default '',
ARTNR char
Hi!
One of the users on a webserver I'm running are having some serious
problems connecting to the MySQL server. He get's the following error:
mysql error: Can't create a new thread (errno 11). If you are not out of
available memory, you can consult the manual for a possible OS-dependent
bug.
I'
I have the same problem using Linux RedHat 7.2. Just what do I have to
configure my binary MySQL : Ver 8.23 Distrib 3.23.49a, for pc-linux-gnu on
i686?
The rest of MySQL works as advertised.
Regards Tom Birchmire
Michael Widenius <[EMAIL PROTECTED]> wrote:
>
> Hi!
>
> > "Sinisa" ==
Thank you very much!! that was very helpful. By the way, is there any other
way to get rid of duplicate records from a text file?
Thanks again
Nato
-Original Message-
From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 04, 2002 3:00 PM
To: Natividad Castro
Cc: [EMAIL PROT
>Hello,
>
>I am trying to get an accurate (nearest 15 minutes would be
>fine) difference between two times that I have in my database. They are
>both of type time, and are in the format 00:00:00.
>
>For example, if I want the difference between 09:20:00 and 10:43:00, I
>would like it to give me 0
Using MySQL 3.23.40
App is logging db with 130 clients to a central MySQL db
with 2 million events per day. Aged events of over 7 days
are no longer required. The central table is myisam type
with fixed size (datetime, enum and foreign keys only).
Selects are done infrequently while inserts are
Hello,
I am trying to get an accurate (nearest 15 minutes would be
fine) difference between two times that I have in my database. They are
both of type time, and are in the format 00:00:00.
For example, if I want the difference between 09:20:00 and 10:43:00, I
would like it to give me 01:23:00
Short version: I have 2 identical tables and I created a merge table to query them all
at once (v 3.23.47). I can select on only two of the four keys in the table.
Attempts to select data from the merge table "WHERE column = xxx" always return 0 rows
for the other two keys. Queries using "WH
On Monday 04 March 2002 03:21 pm, Heikki Tuuri wrote:
> Erik,
>
> this is probably not a bug.
>
> Your log files probably are not the ones which belong together with the
> current data file(s).
>
> When you start the database it tries to use the obsolete log files in
> recovery.
>
> From the manua
Erik,
this is probably not a bug.
Your log files probably are not the ones which belong together with the
current data file(s).
When you start the database it tries to use the obsolete log files in
recovery.
>From the manual:
"
If something goes wrong in an InnoDB database creation, you shoul
> I'm new using mysql. I'm trying to load data from a text file to one of my
> table. This text file contains duplicate records. My question is how do you
> tell mysql to delete duplicate records and load just the ones that are not
Why not just filter the data through uniq first?
~~~
I have the same problem (silent install). In details:
I run setup.exe with command line options -r to create response file needed for silent
installation in InstallShield.
By default it is created in the windows directory with name setup.iss.
Then I move this setup.iss to the same folder as setu
I am currently implementing a database-ran webserver dll:
Info:
Ms Visual C++
MySQL ++ 1.7.1
MySQL-nt 3.23.47
MyISAM db.
3or 4 Queries in the application
Biggest Query:
66,000 records
using LIKE "something%"
Question:
I am currently using a connection every time I query, but since this is a
stat
On Mon, Mar 04, 2002 at 02:48:06PM -0500, Natividad Castro wrote:
> I'm new using mysql. I'm trying to load data from a text file to one
> of my table. This text file contains duplicate records. My question
> is how do you tell mysql to delete duplicate records and load just
> the ones that are n
I'm having problems restarting a MySQL server after a certain table
reached maximum capacity. I managed to dump my entire database to a flat
file before I restarted the server however when I tried to re-import my
data the operation failed. My database size set to 500M in the innodb
section of my m
Spambusting: MySQL
> Richard,
>
> There has been talk of this before.
> (I haven't checked but) wouldn't be surprised if it's on the ToDo list
> - did you know that such info is available within the manual?
> If it's not, then propose such as a 'wish list'.
>
> Regards,
> =dn
>
> - Original
At 01:13 PM 3/4/2002 , you wrote:
>On Mon, Mar 04, 2002 at 11:19:54AM +0100, Takacs Istvan wrote:
> > Hi,
> >
> > We use mysql 1.23.47 as a database for our PHP based accounting
> > system. We use mysql_pconnect() to get a connection to the DB.
> > This morning we couldn't log in because mysql se
Hi to all,
I'm new using mysql. I'm trying to load data from a text file to one of my
table. This text file contains duplicate records. My question is how do you
tell mysql to delete duplicate records and load just the ones that are not
duplicate? I already tried the REPLACE and IGNORE key words b
Richard,
There has been talk of this before.
(I haven't checked but) wouldn't be surprised if it's on the ToDo list
- did you know that such info is available within the manual?
If it's not, then propose such as a 'wish list'.
Regards,
=dn
- Original Message -
From: "Richard Clarke" <[E
Is this a true export? Because I've never had garbage lines in my files.
Dave
On Mon, Mar 04, 2002 at 10:33:14AM -0600, Paul DuBois wrote:
> At 10:58 -0500 3/4/02, Richard Bolen wrote:
> >I'm exporting data from Oracle and importing it into MySQL. The
> >problem is Oracle puts garbage lines at
Hi!
> "Sinisa" == Sinisa Milivojevic <[EMAIL PROTECTED]> writes:
Sinisa> [EMAIL PROTECTED] writes:
>> >Description:
>> LOAD DATA LOCAL INFILE ...
>>
>> leads to 'The used command is not allowed with this MySQL version'
>>
>> This happens regardless of whether I have a
>>
>> local-infile
On Mon, Mar 04, 2002 at 12:25:44PM +0100, Angela Harneit wrote:
> I've a question concerning negations of regular expressions - e.g. I
> want the sentence "this is nice" to match, while the sentence "this
> is not nice" should not match. I only found possibilities for the
> negation of single ch
On Mon, Mar 04, 2002 at 11:19:54AM +0100, Takacs Istvan wrote:
> Hi,
>
> We use mysql 1.23.47 as a database for our PHP based accounting
> system. We use mysql_pconnect() to get a connection to the DB.
> This morning we couldn't log in because mysql sent back a 'too many
> open connection!' (or
Correct.
Richard
- Original Message -
From: "DL Neil" <[EMAIL PROTECTED]>
To: "Richard Clarke" <[EMAIL PROTECTED]>; "Christopher Thompson"
<[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, March 04, 2002 6:34 PM
Subject: Re: extra max() function possibly very useful?
> LIMIT to b
Hi everyone,
I'd like to know how to load files, such as MS-Word documents or PDF
documents, in a mySQL database. I've setup a blob type in a table, but
where do I go from there?
The purpose of this is to store files uploaded from a web page and processed
with Java servlets. Then, the files sh
I added the line "set feedback off" at the beginning of my Oracle report script and
that suppressed the output of the garbage lines.
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 04, 2002 11:33 AM
To: Richard Bolen; MySQL Mailing List (E-mail)
Subjec
Currently ezmlm supports mysql, I was wondering if there was a way to get
db2 to talk to mysql, so that when someone subscribes to the mailing list,
their credentials get passed to db2.
Thanks for any help.
Arthur
-
Before po
I need to have access to all the databases on my server using one ODBC
connection. Currently, I have to specify the db and only have access to
that one...is there a way around this? How about SQL Links?
Thanks,
Eddie
-
Before
At 15:39 +0200 3/4/02, savaidis wrote:
>I give this query:
>
>ALTER TABLE `companies` ADD `Tel3` CHAR(30) BINARY
>
>but it creates tel3 as VARCHAR(30) !
You have other variable-length columns in your table.
http://www.mysql.com/doc/S/i/Silent_column_changes.html
>
>Why?
>
>Makis
Hi All,
New to mysql. Running: Win2k as Administrator
mysql-3.23.49-win.zip (binaries)
Keep getting error (complete output below sig):
mysqld: Table 'mysql.host' doesn't exist
I've tried running each binary msqld version (mysqld, mysql-max).
I haven't seen any soluti
Christian Rabe writes:
>Are there plans on creating more than on tablesspace plus making them
>selectable ?
>So that I can tell the DB:
>- in which datafiles to store the tablespace X
>- in which tablespace to store table Y
This is one of the things I was wondering about.. If I have multiple Inn
Because that wouldn't give the correct results.
I want the top 5 rows for EACH id.
A short example would be,
mytable:
IdValHits
1 a 10
1 b 15
1 c 17
2 q 200
2 r 205
2 s 101
2 t 50
3 zz 10
3 yy 20
3
On Monday 04 March 2002 10:50 am, Richard Clarke wrote:
>
> create table mytable (id int, val char(255), hits int);
> insert some data...
>
> select max(5,hits) from mytable group by id;
>
> This would allow selecting of the top 5 rows for each id according to the
> hit column.
>
> Without this fu
Hi,
What would the plausability of a function like this being implemented in the
future.
create table mytable (id int, val char(255), hits int);
insert some data...
select max(5,hits) from mytable group by id;
This would allow selecting of the top 5 rows for each id according to the
hit column
This has nothing to do with MySQL. Check out freesql.org and talk to them
about your problems.
On Monday 04 March 2002 1:31 am, Zandona Marcello BGV wrote:
> sql-problem!
>
> hello,
> please could you help me? after you made some
> work on your server.. the side of
>
> www.fcliestal.chdoes
I give this query:
ALTER TABLE `companies` ADD `Tel3` CHAR(30) BINARY
but it creates tel3 as VARCHAR(30) !
Why?
Makis
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.
--- Horváth_Szabolcs <[EMAIL PROTECTED]> wrote:
> Hello everyone!
>
> I would like to use my mysql server via Perl.
> Does anyone send me links or documents about it?
> Thanks
> Szabolcs
I am using DBI module in Perl to connect to mySQL database. More
information can be found at the below lin
John Dean <[EMAIL PROTECTED]> writes:
> Hi
> All you need to do is include a symlink on libmysqlclient.so.11 to
> point to libmysqlclient.so.10
>
> e.g ln libmysqlclient.so.11 libmysqlclient.so.10
Not a good suggestion for libraries in general. If a library so name
has changed, it means it not
Thanks for that.
It's actually more the UltraDev/Phakt thing I'm having problems with. I just
wondered how you would set the SQL statement in such a way that UltraDev
wouldn't complain - it doesn't like SELECT * from customers".$surname_query.
Do you know of a good way of handling conditional st
hello
i creates two table t1 and t2;
CREATE TABLE t1 (
id INT UNSIGNED NOT NULL AUTO_INCREMENT,
PRIMARY KEY (id)
) TYPE=InnoDB;
CREATE TABLE t2 (
id INT UNSIGNED NOT NULL AUTO_INCREMENT,
t1id INT UNSIGNED NOT NULL,
PRIMARY KEY (id),
KEY (t1id),
FOREIGN KEY (
Try using something a little different:
if ($surname_all){ //checks to see if the variable is set
$surname_query = "WHERE surname between $surname_from and $surname_to";
} else {
$surname_query = "";
}
-Original Message-
From: Craig Shepherd [mailto:[EMAIL PROTECTED]]
Sent: Monday, Mar
At 10:58 -0500 3/4/02, Richard Bolen wrote:
>I'm exporting data from Oracle and importing it into MySQL. The
>problem is Oracle puts garbage lines at the end of it's output files.
As you've noted, the problem is Oracle.
If you're using Unix, you could use tail to see how many of these lines
th
We have FreeBSD 4.2-RELEASE and I can't say for sure how much
time it might take to upgrade to 4.3 or higher. It might take
anywhere from one reboot to several hours (if something won't
work).
Mysql was built on our server.
Sincerely,
Stephen
> -Original Message-
> From: Jeremy Zawod
Hello,
I'm looking to port a MySQL replication set that runs 3.23.25-beta to a
later version of MySQL. I understand that the format for the binary log
changed from .25 to .26 and again at 4. It appears, from looking at the
code for 4, that it looks at the version of the replication master and i
Does anyone know if there is a good profiler to use on MySql, for example,
in SQL Server, you can start the 'profiler' and it will tell you everything
that is happening on the server.
Thanks,
Eddie
-
Before posting, please chec
Hello Emil
You need to increase the max packet size that mysql can handle... try
putting this in your my.cnf file under [mysqld]:
set-variable = max_allowed_packet=5M
and restarting your server (obv. if you're starting mysql from the command
line use the switch --max_allowed_packet)
james
Dear Sinisa,
thanks for the fast answer. I use the GCC-3.0.3 and have already made
automake, autoconf and ./configure. When I make gmake jams on the error that
I have to you before marked. I use gmake the 3.79.1, automake the 1.5 and
autoconf the 2.52.
Thanks still for the kind aid.
Erminio Rie
Using UltraDev 4 with Phakt 1.2.1, linking to a MySQL server 3.22.23
I want to develop a SQL SELECT query where I can vary what customers are
listed depending on the value of various form fields.
For example if the check box surname_all is ticked then all customers are
displayed if not then it di
I'm exporting data from Oracle and importing it into MySQL. The problem is Oracle
puts garbage lines at the end of it's output files. Lines like "300 rows selected"
and "input truncated to 9 chars" as well as empty lines. When MySQL loads these
files, I'm getting rows inserted for the empty
Viraj,
Thursday, February 28, 2002, 9:58:32 PM, you wrote:
VA> I'm not sure if this is a bug or not, but I've noticed that if I have a
VA> 'database=' in my ~/.my.cnf, calling mysqldump with any possible options
VA> always returns:
VA> mysqldump: option `--databases' doesn't allow an argument
V
Buding,
Monday, March 04, 2002, 3:37:08 PM, you wrote:
BC> Hi, all:
BC> I create a table as following:
BC> CREATE TABLE appsvr_trarte (
BC> rte_id bigint(38) NOT NULL auto_increment,
BC> strConfName varchar(70) NOT NULL default '',
BC> lFromTime int(16) unsigned NOT NULL default '0'
torkil,
Monday, March 04, 2002, 10:57:50 AM, you wrote:
tj> I have a database table containing log files that are written by
tj> different individuals almost every day.
tj> So at any given time I want to be able to go through a web
tj> interface and get a list over logs written in any given mo
Erminio Efisio Riezzo writes:
> Hello folks,
> I have a large problem during the compilation of mysql under tru64 unix.
> I have tried is the 1.7.9 that the 1.7.6a with compiler cxx.
> The 1.7.9 jam when the following launch the gmake with message:
>
> gmake all-recursive
> gmake[1]: Entering
1 - 100 of 150 matches
Mail list logo
