There seems to be a significant penalty imposed by the optimizer when these
3 clauses are uses together. If we use the Full Text Search the penalty is
gone. However, the Full Text Search is not a very good option in my case as
it does not offer the granularity needed.
Please see below:
On our Linux server we get this error:
030722 08:09:55 mysqld started
/usr/local/mysql/bin/mysqld: ERROR: unknown variable 'ft_min_word_len =
2'
030722 08:09:55 mysqld ended [...]
It's strange becouse I can set this variable through my.ini on my
Windows. Anyone can help me solve this problem ?
At 8:20 +0100 7/22/03, Marek Lewczuk wrote:
On our Linux server we get this error:
030722 08:09:55 mysqld started
/usr/local/mysql/bin/mysqld: ERROR: unknown variable 'ft_min_word_len =
2'
030722 08:09:55 mysqld ended [...]
It's strange becouse I can set this variable through my.ini on my
At 8:20 +0100 7/22/03, Marek Lewczuk wrote:
On our Linux server we get this error:
030722 08:09:55 mysqld started
/usr/local/mysql/bin/mysqld: ERROR: unknown variable
'ft_min_word_len =
2' 030722 08:09:55 mysqld ended [...]
It's strange becouse I can set this variable through my.ini
Description:
MySQL v4.1.0-alpha only allows a client to prepare a maximum of 254
statements. On the 255th mysql_prepare() call, a failure is returned
with no information returned by mysql_error(). This occurs even if
the statements are closed after each use.
How-To-Repeat:
The following program
Where do I go to set the max_connections settings so I can have over
100?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
search for
my.cnf
If it does not exist you can create it,
http://www.mysql.com/doc/en/Option_files.html
Peter
-Original Message-
From: Richard Sumilang [mailto:[EMAIL PROTECTED]
Sent: 22 July 2003 07:56
To: [EMAIL PROTECTED]
Subject: Setting max_connections
Where do I go to set
Hi!
On Jul 22, Marek Lewczuk wrote:
On our Linux server we get this error:
030722 08:09:55 mysqld started
/usr/local/mysql/bin/mysqld: ERROR: unknown variable 'ft_min_word_len = 2'
030722 08:09:55 mysqld ended [...]
the correct syntax is WITHOUT quotes and WITHOUT spaces.
the correct syntax is WITHOUT quotes and WITHOUT spaces.
--ft_min_word_len=2
or
-O ft_min_word_len=2 -- but -O is obsolete
but not
-O 'ft_min_word_len = 2'
But we want to set this variable in my.cnf, so the syntax shouldn't be
like this:
set-variable =
Cory The field contains 1234.5678, MySQL returns 1234.57, don't want that!
select Round (field/1000, 4) from ...
Ivan
__
One World, one Web, one Program
-- Microsoft promotional ad
Ein Volk, ein Reich, ein Fuhrer
-- Adolf
Hi!
On Jul 22, Marek Lewczuk wrote:
the correct syntax is WITHOUT quotes and WITHOUT spaces.
--ft_min_word_len=2
or
-O ft_min_word_len=2 -- but -O is obsolete
but not
-O 'ft_min_word_len = 2'
But we want to set this variable in my.cnf, so the syntax
Ed [EMAIL PROTECTED] wrote:
There seems to be a significant penalty imposed by the optimizer when these
3 clauses are uses together. If we use the Full Text Search the penalty is
gone. However, the Full Text Search is not a very good option in my case as
it does not offer the granularity
Michael Satterwhite [EMAIL PROTECTED] wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Monday 21 July 2003 04:14, Egor Egorov wrote:
Michael Satterwhite [EMAIL PROTECTED] wrote:
I'm trying to add a foreign key to a table. All tables are INNODB. Table
a has following partial
I have a script that dumps the grants of a MySQL
Database and I want to contribute this.
What should I do now ?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Troy Hakala [EMAIL PROTECTED] wrote:
Is it possible to limit the query time in MySQL (3.x or 4.0)? For
example, I'd like to have any query that takes more than a specified
number of seconds just quit automatically. Seems dumb, but on a web
site, nobody is going to wait minutes for a query
HI
Is there ANYONE that can help me with a my.cnf for a large site for
version 3.23.56, or even just where I can download one? I am trying to
download that version and then get my own, but the dl times out...
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Tuesday 22 July 2003 00:04, [EMAIL PROTECTED] wrote:
You are right above the max date query and I really appreciate your
help, but the subselect query its other question. I try the subselect
query with the 4.0.12-max win32 with the --new option
From the manual:
REPLACE(str,from_str,to_str)
Returns the string str with all occurrences of the string from_str replaced
by
the string to_str:
mysql SELECT REPLACE('www.mysql.com', 'w', 'Ww');
- 'WwWwWw.mysql.com'
This function is multi-byte safe.
Terry Spencer
Haigh Consultancy Services
+44
Why not post it here, or give us a link to download it from your server?
- Original Message -
From: Francesc Guasch [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, July 22, 2003 4:47 AM
Subject: Contributing to MySQL
I have a script that dumps the grants of a MySQL
Database and
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Tue, 22 Jul 2003, Petre Agenbag wrote:
Is there ANYONE that can help me with a my.cnf for a large site for
version 3.23.56, or even just where I can download one? I am trying to
download that version and then get my own, but the dl times out...
Hi,
I guess there is no way to limit COUNT(*). Is that right? We cannot use the
result of COUNT in WHERE condition or LIMIT doesn't help. In this case so
far I have retrieved a field and used LIMIT. Is there a better way to
control it?
Thanks
--
MySQL General Mailing List
For list archives:
Lenz
Thanks for the reply, will go to the link immediately.
I would just like to clarify something:
I have 3.23.56 , your's is 4.x, does it matter?
I should obviously just leave out the stuff that is not relevant like
InnoDB support etc...
CAn you give me possibly pointers to the absolute
Perhaps you could post some examples of what you have tried.
I don't understand what you are asking.
Mojtaba Faridzad wrote:
Hi,
I guess there is no way to limit COUNT(*). Is that right? We cannot use the
result of COUNT in WHERE condition or LIMIT doesn't help. In this case so
far I have
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
[EMAIL PROTECTED] wrote:
Description:
MySQL v4.1.0-alpha only allows a client to prepare a maximum of 254
statements. On the 255th mysql_prepare() call, a failure is returned
with no information returned by mysql_error(). This occurs even if
the
If you are using the result set as part of an application, you could select,
then count the rows or use a function such as in PHP : mysql_num_rows()
Jerry
- Original Message -
From: Mojtaba Faridzad [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, July 22, 2003 1:08 PM
Subject:
I have a table containing the fields unit_id,
temperature and date. This has data for around 20
units, with many 1,000's of records for each.
Further information on each unit is in another table
with just 1 entry per unit.
I need to select the most recent record for each unit
together with its
for example:
SELECT COUNT(*) as numfound FROM mytable WHERE mycondition;
in this query, mytable and mycondition are variable and on run time, they
are changed. I use this query to jump to the last page of a grid form.
sometimes the query may have more than million records and I want to give a
At 9:25 +0100 7/22/03, Marek Lewczuk wrote:
the correct syntax is WITHOUT quotes and WITHOUT spaces.
--ft_min_word_len=2
or
-O ft_min_word_len=2 -- but -O is obsolete
but not
-O 'ft_min_word_len = 2'
But we want to set this variable in my.cnf, so the syntax shouldn't be
like
- Original Message -
From: Mojtaba Faridzad [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, July 22, 2003 4:40 PM
Subject: Re: how to limit COUNT(*)
for example:
SELECT COUNT(*) as numfound FROM mytable WHERE mycondition;
in this query, mytable and mycondition are variable
Hello, mysql,
I have met a problem. Look at the following, please.
mysql grant all on school.* to [EMAIL PROTECTED]/24 identified by win123;
ERROR 1064: You have an error in your SQL syntax near '/24 identified by win123' at
line 1
I just want to limit liuxin from some limit hosts to access
- Original Message -
From: Liu Yang [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, July 22, 2003 5:00 PM
Subject: how can I use a subnet mask to limit
Hello, mysql,
I have met a problem. Look at the following, please.
mysql grant all on school.* to [EMAIL PROTECTED]/24
--- [EMAIL PROTECTED] wrote:
Hi! This is the ezmlm program. I'm managing the
[EMAIL PROTECTED] mailing list.
I'm working for my owner, who can be reached
at [EMAIL PROTECTED]
To confirm that you would like
[EMAIL PROTECTED]
added to the mysql mailing list, please send
an empty
Hi All,
I have a database consisting of 2 tables.
patient_info ( Patient Information ).Looks like
lastname VARCHAR(10)
fname VARCHAR(10)
ssno INT(9) PRIMARY KEY
IDINT(4) AUTO_INCREMENT
patientins_info ( PatientInsurance Information)
insco VARCHAR(10)
insid VARCHAR(10)
First of all, I don't wanna let the query run to the end and after that,
count the number of records. as I mentioned, some tables are huge and takes
a long time to run COUNT(*) query for all records.
About LIMIT, it doesn't effect on COUNT query. but for the second query (
retreiving a field ) I
-Ursprngliche Nachricht-
Von: Victoria Reznichenko [EMAIL PROTECTED]
An: [EMAIL PROTECTED]
Gesendet: Dienstag, 22. Juli 2003 11:56
Betreff: Re: Limiting query time
Troy Hakala [EMAIL PROTECTED] wrote:
Is it possible to limit the query time in MySQL (3.x or 4.0)? For
example, I'd
a LIMIT will not work in any case with COUNT since you will always get exactly one row.
and what shall a LIMIT 1 on 1 row do here?
but you can try the MAX function here: (i guess it exists :)
SELECT MAX(COUNT(*), 10001) as numfound FROM mytable WHERE mycond;
-yves
-Ursprüngliche
Mojtaba Faridzad wrote:
First of all, I don't wanna let the query run to the end and after that,
count the number of records. as I mentioned, some tables are huge and takes
a long time to run COUNT(*) query for all records.
About LIMIT, it doesn't effect on COUNT query. but for the second query
Would that help at all - since the COUNT(*) would execute fully and then
MAX would limit it? (or is the order of operations different than that?)
-M
-Original Message-
From: Yves Goergen [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 22, 2003 10:26 AM
To: Mojtaba Faridzad; [EMAIL
On 22 Jul 2003 at 9:30, gerald_clark wrote:
If you are using MYISAM tables, count(*) does not scan the table to
get the count.
That's only true if you have no WHERE clause and thus are counting
all the rows in the table. That doesn't seem to be what the original
poster is doing.
--
Keith
Hello,
I coded a program by using VB 6.0 I will use this program on network(nearly 12
user). is it necessary to code two different program for both of server and client.
Or, Can I solve this problem by MYSQL Control Center.
Hseyin DEMRA
stikbal Furniture nt.
Hi,
On Tue, Jul 22, 2003 at 09:40:31AM -0400, Mojtaba Faridzad wrote:
for example:
SELECT COUNT(*) as numfound FROM mytable WHERE mycondition;
in this query, mytable and mycondition are variable and on run time, they
are changed. I use this query to jump to the last page of a grid form.
I have been running 4.0.13 for several weeks now and though I'd like to test 4.1.0.
4.0.13 is under c:\MySQL. I downloaded 4.1.0 under c:\4.1 Alpha\MySQL. When I try to
launch mysql it brings me to the old version, how do I access the new one without
killing the old one? (I have also tried
thanks Fred! that's better. actully I took a field with one character but
it's better to run SELECT '1' FROM
as I know, if there is not ORDER BY in the query, mySQL doesn't need to
check all records and retreives LIMIT number of them. I checked speed with
limit and without limit, limit was
Good Morning,
I'm running Alpha 4.1 on Linux. I'm new to MySql but familliar with other
databases. I set up a user with Create Temporary Tables permissions. That
user can create temp tables but can not alter or update the table. That
user is getting Update command denied to user... for
Hi there,
How can I extract values for members whose level is below '3', and
their names are between the alphabets 'a' and 'b' ?
For example, one of the results should be 'Alex', whose level is '1'.
Or 'Bob', whose level is '2'. But not Charlie, or Tom...etc.
I tried a query like
SELECT uid
Hi,
On Tue, Jul 22, 2003 at 11:30:47AM -0400, Mojtaba Faridzad wrote:
thanks Fred! that's better. actully I took a field with one character but
it's better to run SELECT '1' FROM
as I know, if there is not ORDER BY in the query, mySQL doesn't need to
check all records and retreives
- Original Message -
From: Lingua2001 [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, July 22, 2003 10:37 AM
Subject: between A and B with another condition?
Hi there,
How can I extract values for members whose level is below '3', and
their names are between the alphabets 'a'
Hi,
On Tue, Jul 22, 2003 at 02:37:14AM -0500, Lingua2001 wrote:
How can I extract values for members whose level is below '3', and
their names are between the alphabets 'a' and 'b' ?
For example, one of the results should be 'Alex', whose level is '1'.
Or 'Bob', whose level is '2'. But not
Like this?
mysql select * from t2;
+-++
| name| number |
+-++
| bob | 3 |
| bob | 2 |
| bob | 1 |
| al | 1 |
| al | 2 |
| al | 3 |
| al | 4 |
| adam| 4 |
| adam| 3 |
| adam
Peter Gorelczenko [EMAIL PROTECTED] wrote:
Good Morning,
I'm running Alpha 4.1 on Linux. I'm new to MySql but familliar with other
databases. I set up a user with Create Temporary Tables permissions. That
user can create temp tables but can not alter or update the table. That
user is
Geez, do I have to do all your work for you, :)
First thing I can think of is,
Ok this makes no sence you have a units table with unit_id as its main
descriptor, but there can be several cases with the same unit_id but you
want the one with the max date. Date on the other hand is stored in
Degan, George E, JR, MGSVC [EMAIL PROTECTED] wrote:
I have been running 4.0.13 for several weeks now and though I'd like to test 4.1.0.
4.0.13 is under c:\MySQL. I downloaded 4.1.0 under c:\4.1 Alpha\MySQL. When I try
to launch mysql it brings me to the old version, how do I access the new
Liu Yang [EMAIL PROTECTED] wrote:
I have met a problem. Look at the following, please.
mysql grant all on school.* to [EMAIL PROTECTED]/24 identified by win123;
ERROR 1064: You have an error in your SQL syntax near '/24 identified by win123'
at line 1
I just want to limit liuxin from
Lingua2001 wrote:
How can I extract values for members whose level is below '3', and
their names are between the alphabets 'a' and 'b' ?
For example, one of the results should be 'Alex', whose level is '1'.
Or 'Bob', whose level is '2'. But not Charlie, or Tom...etc.
I tried a query like
SELECT
OK, now we are both confused.
There is only 1 instance of each unit in the unit
table. Unit_id id the primary key.
There are thousands of instances of each unit in the
log table. Each record in this table holds unit_id,
temperature and date.
If I understand correctly, your suggested
So, CREATE TEMPORARY TABLES only allows the initial create and insert into a
temporary table. Any other privileges like alter, update, delete, and
possibly drop are reserved for real tables and database grants.
Don't get me wrong, I'm glad we have the create temp table grant/option. We
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
MySQL 4.0.14, a new version of the popular Open Source/Free Software
Database, has been released. It is now available in source and binary form
for a number of platforms from our download pages at
http://www.mysql.com/downloads/ and mirror sites.
Hello,
I run two MySQL servers on Windows with the two services.
I read in the docs that it exists a way to identify the servers in my.cnf by
groups and about a tool from Linux to manage the groups.
How can I start a server on Windows through the my.cnf/my.ini 's groups?
Thanks Anticipated,
At 19:37 +0300 7/22/03, Primaria Falticeni wrote:
Hello,
I run two MySQL servers on Windows with the two services.
I read in the docs that it exists a way to identify the servers in my.cnf by
groups and about a tool from Linux to manage the groups.
How can I start a server on Windows through the
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
We're doing a select query on our INNODB database.
Linux 2.4.21 on x86 (Athlon). Mysql is 4.0.13. Anyone seen this problem before?
- -
InnoDB: Error: trying to access page number 538587904 in space 0
InnoDB: which is outside the tablespace bounds.
Hello and thank you for the info,
As I said earlier, I already did the other ways of starting multiple
servers.
But from these docs I lived with the idea that one/unique my.cnf is able to
start two servers on Windows.
Must I see that two configuration files is needed?
Iulian
- Original
David,
- Original Message -
From: David Bernick [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Tuesday, July 22, 2003 8:02 PM
Subject: mysql crashing regularly
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
your database is corrupt. It is trying to access a page at 8 TB.
I did a find for it and found...
-
# find / my.cnf | grep my.cnf
/etc/my.cnf
/etc/virtualhosting/templates/mysql/etc/my.cnf
/etc/my.cnf.admin_appl
/home/virtual/site1/fst/etc/my.cnf
/home/virtual/site2/fst/etc/my.cnf
I am still getting my feet wet on mysql. I, however have seen the MYSQL
Refereence Manual at the mysql site while I have also seen Mysql
Cookbook referenced or mentioned in the list.
As a true novice starting out, can someone tell me which of the two
would be best suited for a true newbie
how can i change the data type of a table? I'm not sure if that is my
problem. If anyone is interested here is a link what I've been trying to
do:
http://www.phpbuilder.com/board/showthread.php?threadid=10248279goto=newpost
Thanks for any help given!
H
Thnks a lot
Patrizio
-Messaggio originale-
Da: Egor Egorov [mailto:[EMAIL PROTECTED]
Inviato: lunedì 21 luglio 2003 14.02
A: [EMAIL PROTECTED]
Oggetto: Re: myisamchk -R
PaT! [EMAIL PROTECTED] wrote:
I need a hint how to use myisamchk
I use this syntax in a shell but it doesn't
At 10:26 -0700 7/22/03, Richard Sumilang wrote:
I did a find for it and found...
-
# find / my.cnf | grep my.cnf
/etc/my.cnf
/etc/virtualhosting/templates/mysql/etc/my.cnf
/etc/my.cnf.admin_appl
/home/virtual/site1/fst/etc/my.cnf
Hi,
I have a table:
+-+--+--+-+-+---
-+
| Field | Type | Null | Key | Default | Extra
|
+-+--+--+-+-+---
-+
| id | int(11)
At 13:28 -0400 7/22/03, Ola Ogunneye wrote:
I am still getting my feet wet on mysql. I, however have seen the MYSQL
Refereence Manual at the mysql site while I have also seen Mysql
Cookbook referenced or mentioned in the list.
As a true novice starting out, can someone tell me which of the two
At 19:50 +0200 7/22/03, PaT! wrote:
Hi,
I have a table:
+-+--+--+-+-+---
-+
| Field | Type | Null | Key | Default | Extra
|
+-+--+--+-+-+---
1) Windows ME seems incapable of applying passwords to usernames. On my
webspace, I can only log into the SQL database if I include the password.
On my WinME PC, only if I do NOT give a password.
2) Using the Opera browser, I open my pages and it sends variables through
As Paul DuBois mentioned, everyone needs the reference manual. But it
is just that, a reference manual not a tutorial.
Paul's MySQL book I thought was excellent. I skipped the first first
few chapters which went over relational concepts, but it walks through
just about everything, including
I found MySQL Cookbook really good for figuring out how to solve a problem -
good if you are coming from another database, or have a list of specific
problems.
I haven't read MySQL Reference Manual, but I have read Mastering MySQL 4 - I
thought it was quite good.
Head to your local book store,
While watching a realtime data acquistion system's MySQL table fill, I
routinely run mysql SELECT * FROM TABLE. After 300+ rows scroll by [in
text mode under *nix], I've usually lost track of which column [out of
23] belongs to what datafield.
Is there an option to have the mysql tool repeat
Contents are Direct Alliance Corporation CONFIDENTIAL
-
How do you type check in mysql. I have a column of type varchar(20) with
both floats and strings. Is there a way to check the type?
Example:
Select
If(is_float(col1), 'is a float', 'not a float') as
X-Original-To: [EMAIL PROTECTED]
X-Original-To: [EMAIL PROTECTED]
Mailing-List: contact [EMAIL PROTECTED]; run by ezmlm
Date: Tue, 22 Jul 2003 13:28:09 -0400
From: Ola Ogunneye [EMAIL PROTECTED]
As a true novice starting out, can someone tell me which of the two
would be best
Hi Paul,
Thanks for the info, but is MySQL, Second Edition the same as the
reference manual? The link you gave me has 3 books and none of them was
the reference manual. Are you saying that I need the reference manual
and then the Second Edition? I just purchased the Second Edition from
Amazon.
At 19:22 +0100 7/22/03, Anthony Hart-Jones wrote:
1) Windows ME seems incapable of applying passwords to usernames.
On my webspace, I can only log into the SQL database if I include
the password. On my WinME PC, only if I do NOT give a password.
The platform on which you run the MySQL server
At 11:30 -0700 7/22/03, MySQL wrote:
While watching a realtime data acquistion system's MySQL table fill, I
routinely run mysql SELECT * FROM TABLE. After 300+ rows scroll by [in
text mode under *nix], I've usually lost track of which column [out of
23] belongs to what datafield.
Is there an
Hi Need emergency help:
I am doing some project use the MySQL to store the video file.
The format of video is either avi or mpg. However I can not successfully insert the
video file into the cooresponding field of a table by using the LOAD_FILE function.
Does anyone know how to store video
At 11:40 -0700 7/22/03, Cory Lamle wrote:
Contents are Direct Alliance Corporation CONFIDENTIAL
-
How do you type check in mysql. I have a column of type varchar(20) with
both floats and strings. Is there a way to check the type?
In this case, the type of the column as far as MySQL is concerned
At 14:45 -0400 7/22/03, Ola Ogunneye wrote:
Hi Paul,
Thanks for the info, but is MySQL, Second Edition the same as the
reference manual? The link you gave me has 3 books and none of them was
the reference manual. Are you saying that I need the reference manual
and then the Second Edition? I just
At 20:12 +0300 7/22/03, Primaria Falticeni wrote:
Hello and thank you for the info,
As I said earlier, I already did the other ways of starting multiple
servers.
But from these docs I lived with the idea that one/unique my.cnf is able to
start two servers on Windows.
Must I see that two
I think the reference manual is basically what's on the web. The book
you ordered, MySQL, Second Edition is indispensible. Since Paul is on
the line, if there's ever a third edition, it would be nice to have the
book and the appendices broken into separate books (they'd be bundled
together at
At 12:03 -0700 7/22/03, Steven Wu wrote:
Hi Need emergency help:
I am doing some project use the MySQL to store the video file.
The format of video is either avi or mpg. However I can not
successfully insert the
video file into the cooresponding field of a table by using the
LOAD_FILE
Your maximum packet size must be greater than the size of the video file.
Steven Wu wrote:
Hi Need emergency help:
I am doing some project use the MySQL to store the video file.
The format of video is either avi or mpg. However I can not successfully insert the
video file into the
On Tue, Jul 22, 2003 at 12:03:44PM -0700, Steven Wu wrote:
Hi Need emergency help:
I am doing some project use the MySQL to store the video file. The
format of video is either avi or mpg. However I can not successfully
insert the video file into the cooresponding field of a table by
using
2) Using the Opera browser, I open my pages and it sends variables through
?var1=value1var2=value2 perfectly until I tried using a form and
realised I am not getting anything back from $PHPSELF...
try $PHP_SELF
Peter
--
http://www.dragonstalon.co.uk/
Latest news at
Thanks. I have been fighting with this all afternoon, now it seems I
can get to 4.1.0 and not 4.0.13. My databases still seem to be there
but I can't point to them either in mysql or in mysqlcc/DBManager. I
guess I have moved port 3306 to the 4.1.0 database. How do I name, say,
3307 as the
Hi Jeremy D. Zawodny:
I did not get any error message. It hust said zero column change and
the filed, VIDEO contains NULL data after I give SELECT * from GAME
command.
Steven Wu
- Original Message -
From: Jeremy Zawodny [EMAIL PROTECTED]
To: Steven Wu [EMAIL PROTECTED]
Cc: [EMAIL
1st search list for binary storage to read about pro/cons (been debated
before)
If you still want to do it either use load_file, or a loader
application...
I don't reccomend using longblob to store big files.. Use the 64k blob
and inode/chunk the data.. better for streaming it out if that's
Hi,
I am compiling MySQL 4.0.14 with GCC 3.2.3, Glibc 2.3.1 and Linux 2.4.21
on a x86.
CFLAGS=-O2 -march=athlon CXX=gcc CXXFLAGS=-march=athlon -O2
-felide-constructors ./configure --prefix=/usr/local/mysql
--with-charset=latin5 --without-docs --with-mysqld-ldflags=-all-static
--disable-shared
Cory,
I'm not sure I understand what you're asking. MySQL casts the data to the
appropriate column type when that data is entered into the database. Data
in a varchar column is always stored as a string, just as data in an INT
field is always going to be of type INT.
-Rob
-Original
Yes, that's the problem.
Until now I started the two servers from the command line/batch file/service
and each server had its own my.ini. The two servers are in replication: one
master and another slave. Two days ago I read that I can use a unique my.ini
for the both servers; and MySQL for
If you actually get binary data loaded into your table, DO NOT run a
select * from table command.. It will stream out all the data and it's
not pretty..
instead run a select col1, col2, length(binarycol) ..
On Tue, 22 Jul 2003, Steven Wu wrote:
Hi Jeremy D. Zawodny:
I did not get any
At 14:15 -0500 7/22/03, Degan, George E, JR, MGSVC wrote:
Thanks. I have been fighting with this all afternoon, now it seems I
can get to 4.1.0 and not 4.0.13. My databases still seem to be there
but I can't point to them either in mysql or in mysqlcc/DBManager. I
guess I have moved port 3306
O'Reilly's Managing Using MySQL is a good intro.
--
Ray Thompson
As a true novice starting out, can someone tell me which of the two
would be best suited for a true newbie
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
I am looking for a simple extraction/load program to load data daily from a
Progress 8.3B database via ODBC to a mysql 3.23.57 database. It does not
necessarily need to do any data-type transforms. It need to run on Windows
2000 and be able to run it as a service, or as a cron task if running
Does your university have a webpage indicating what advice is acceptable and
not considered plagarism?
- Original Message -
From: Antonio Jose Rodrigues Neto [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Tuesday, July 22, 2003 9:54 PM
Subject:
Hi all.
I need to test whether the first bit of a field is numeric.
For example, the field might contain:
154 boxes
I'm currently testing it by doing:
if(abs(left(field,locate(' ', field))0),'Numeric bit at front', 'Not
Numeric bit at front')
It seems to work.
Well it kinda works. If 'field'
1 - 100 of 120 matches
Mail list logo