At 13:49 +0800 10/19/05, ⧠àÆ wrote:
yes.
I look reference manual of mysql5.0.12.
For example,there a variables named
"bdb_..",but i can't find these variables
used "show variables".
Your server probably doesn't have BDB support compiled in.
From:
n/server-system-variables.html
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
At 10:13 +0800 10/19/05, ⧠àÆ wrote:
Are there any difference between max_connection and max_user_connection?
thanks!
The difference is explained here:
http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL
ent field. This doesn't work
either, it just says to check my syntax, but I can't see a problem.
Any ideas?
The manual is your friend:
http://dev.mysql.com/doc/mysql/en/insert-select.html
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
--
M
SELECT * FROM t1;
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ere:
http://dev.mysql.com/doc/mysql/en/gis-introduction.html
Which indicates that the GIS spec is here:
http://www.opengis.org/docs/99-049.pdf
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.co
the data line by line, I get no warnings.
How can I see what is going wrong?
SHOW WARNINGS
immediately after your LOAD DATA statement.
Requires 4.1 or higher.
http://dev.mysql.com/doc/mysql/en/show-warnings.html
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB,
first 40 characters of a field? Thanks in advance.
LEFT(str,len) ?
http://dev.mysql.com/doc/mysql/en/string-functions.html
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
At 18:50 -0600 10/2/05, s. keeling wrote:
Incoming from Paul DuBois:
At 16:39 -0600 10/2/05, s. keeling wrote:
>
>The admin account, with no password, doesn't function at all. perl
>programs appear to ignore ~/.my.cnf forcing me to open() them and
>slurp username and
I think I'd probably set up aliases that invoke mysql or mysqladmin
with a --defaults-extra-file option that contains the username/password
for the appropriate account.
At 16:39 -0600 10/2/05, s. keeling wrote:
I've checked everywhere I can find (Paul DuBois' MySQL, ML archives
At 13:00 -0400 10/1/05, Jerry Swanson wrote:
I have field in database type "float". When I insert number like 12345.27 ,
number is inserted 12345.3
Why it happened?
Rounding.
What is the exact data type of the column?
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, US
e the extra parentheses in there, anyway?
Other web sites all seemed to indicate this was an issue of
nesting queries within each other, particularly SELECT within
SELECT. But my query seems more straight forward than that, so I'm
not sure if that advice applies.
--
Paul DuBois, M
he deleted records are deleted
and you restart.
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
At 20:47 +0100 9/6/05, Shaun wrote:
Hi,
Given two dates, can Mysql calculate and return all the dates that occur
between them?
No.
Given two dates, MySQL can determine which of a set of already-existing
dates stored in a table occur between them and return those.
--
Paul DuBois, MySQL
UNIQUE KEY name (name,ppathref),
KEY ppathref (ppathref),
KEY typeref (typeref),
CONSTRAINT paths_ibfk_1 FOREIGN KEY (ppathref) REFERENCES paths (id),
CONSTRAINT paths_ibfk_2 FOREIGN KEY (typeref) REFERENCES pathtypes (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
--
Paul DuBois, MySQL D
o try mysql_hex_string() to store the data in hex format.
my question is: after the data is encoded in hex by mysql_hex_string(), how
is it returned to its original format?
The server decodes the hex value when it executes the statement.
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MyS
ned NOT NULL default '0',
`Tested` tinyint(1) unsigned NOT NULL default '0',
`CoreID` smallint(3) unsigned NOT NULL default '0',
KEY `BID` (`BID`,`ReleaseID`),
KEY `ReleaseID` (`ReleaseID`)
) TYPE=MyISAM;
--
Paul DuBois, MySQL D
". It's not intended that you
pass mysql_hex_string() a complete SQL statement.
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ke 'NAD83'??
I think that is unlikely to happen. The OpenGIS spec defines the
SRID to be an integer, and the SRID() function to be an integer-valued
function.
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
--
MySQL General Mailing List
For
character set
chapter in the manual:
http://dev.mysql.com/doc/mysql/en/charset.html
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
side of the SQL syntax.
http://dev.mysql.com/doc/mysql/en/string-comparison-functions.html
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.m
nnect call. I would much rather set
it on the connection after it is established.
Is there a good reason why the server behaves differently than the
manual indicates, or is it a bug?
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
--
MySQL General M
manual has the "delimiter ;" line following the //
line, not preceding it.
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual
that corresponds to your MySQL server version for the right syntax to use
near 'RETURN CONCAT('Hello, ',s,'!'
. Thanks.
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ading:
http://dev.mysql.com/doc/mysql/en/privilege-system.html
http://dev.mysql.com/doc/mysql/en/user-account-management.html
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubs
174dfa mysql_execute_command__FP3THD + 16634
0x81771a9 mysql_parse__FP3THDPcUi + 249
0x816f8b4 dispatch_command__F19enum_server_commandP3THDPcUi + 1732
0x816f1e4 do_command__FP3THD + 196
0x816e7a4 handle_one_connection + 740
0x4ce341 (?)
0x1ddfee (?)
--
Best regards,
Rob Hall - Red Hat Certified Engi
the same thing.
it's not a big problem. just wondering what's going on here. i
checked http://dev.mysql.com/doc/mysql/en/char.html , but found
nothing related to this.
i'm running version 4.1.11.
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB,
ut no SHOW CREATE TABLE.
It appears "deeper" in the TOC than the other statements. The main page
TOC goes only to three levels. (Otherwise it'd be a mile long.)
- philip
On May 28, 2005, at 8:38 PM, Paul DuBois wrote:
At 20:26 -0500 5/28/05, Philip George wrote:
this is what
;s the sql syntax (in mysql) for exporting a table's structure
and and data (the one that reiterates the original CREATE TABLE
statement)?
..so that i'll end up with something that can be put in a .sql
script for later imports if needed.
thanks.
- philip
--
Paul DuBois, MySQL Docume
ports if needed.
SHOW CREATE TABLE tbl_name
From the command line:
mysqldump --no-data db_name [tbl_name] ...
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsub
x27;,'_')),';');
mysql> prepare stmt from @tt;
Query OK, 0 rows affected (0.00 sec)
Statement prepared
mysql> execute stmt ;
mysql> deallocate prepare stmt;
mysql> show tables like 'flow%';
+-+
| Tables_in_world (flow%) |
+--
At 11:00 -0400 5/28/05, Jason Dixon wrote:
On May 28, 2005, at 8:51 AM, Paul DuBois wrote:
At 8:12 -0400 5/28/05, Jason Dixon wrote:
I'm trying to rename some tables for archival, but the table
renaming is failing when I use CONCAT() to form the table string
name:
CONCAT() produ
row in set (0.00 sec)
Is there some magic pixie dust I need to throw around the CONCAT()
to have it interpolate into the RENAME TABLE command correctly?
This is on mysql-server 3.23.58 on a RHEL 3 clone.
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
} for LOAD DATA INFILE.
Thanks for any insights.
Scott Klarenbach
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
. Please give me solutions at the
earliest as mirgration from oracle to mysql is started and i need to
meet the solution as soon as possible.
Views are implemented in MySQL 5.0, not MySQL 4.1.
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
--
MySQL General
27;t seem to find it...
I'm also a beginner in using mysql. I've tried to googling and
searching the mysql mailing list for this but I didn't have any luck
finding an answer.
This information is stored in the user table of the mysql database.
http://dev.mysql.com/doc/mysql/en/pr
?
If it's obsolete, I'd like to know that, too. I'll remove it from
MySQL++ in that case.
It's not obsolete, just undocumented. There is, in fact, a bug report
noting that fact:
http://bugs.mysql.com/bug.php?id=9816
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
My
nnot use aggregate functions in a WHERE clause.
WHERE determines which rows to select.
Aggregate values are calculated from the selected rows.
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/m
t for days now
a clear guideline will help
i tried reading at the mysql.com
but no help .. i am new to linux.. anyone who had this experience
and solve it please reply
i am running on suse 9.3 and using mysql-4.1.11 ( source file )
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, US
x27;ends with', so I could move to
'contains'.
Anyway, I think you see what my concern is, wonder what the preferred method
to fix is, or if someone can tell me when, if ever, the error string has
ever changed format in mysql.
Error strings do change format sometimes.
And they won'
written
to it until they commit.
The preceding comments apply to InnoDB, of course. If you're concerned
about tables for other storage engines, it might be a different question.
For MyISAM, I recommend starting the server with --myisam-recover=BACKUP,FORCE.
--
Paul DuBois, MySQL Documentat
x27;t know what phpMyAdmin means by "unavailable collations". But
if SHOW COLLATION shows a collation, it's available.
Andre
On 5/2/05 4:44 PM, "Paul DuBois" <[EMAIL PROTECTED]> wrote:
At 16:15 -0400 5/2/05, Andre Matos wrote:
Hi Paul,
It does appear in the list,
orking without
compiled?
Yes. Some character set information is loaded at runtime.
Andre
On 5/2/05 4:04 PM, "Paul DuBois" <[EMAIL PROTECTED]> wrote:
At 15:28 -0400 5/2/05, Andre Matos wrote:
Hi List,
I was checking the list of collations for a character set "latin" that I
have
0 |
| latin1_general_cs | latin1 | 49 | | | 0 |
| latin1_spanish_ci | latin1 | 94 | | | 0 |
+---+-+----+-+--+-+
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
--
MySQL G
At 16:35 -0700 4/29/05, Hassan Schroeder wrote:
Paul DuBois wrote:
Before MySQL 5, DECIMAL values are stored as strings, so operations
are less efficient than for integers.
In MySQL 5, the representation of DECIMAL has changed to binary format,
so it's more efficient than before. It'
ay that
integer is still a bit more efficient, but the difference between integer
and DECIMAL will be less than before.
Details:
http://dev.mysql.com/doc/mysql/en/precision-math-decimal-changes.html
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
--
MySQL
tually) as the data in the column is not what the data was
> intended to be.
> (Actually MS SQL shows the error and does not even insert the data...)
>
> Does MySQL not care or maybe I need to activate some option in MySQL
> like
> verbose or stict checking etc... It just
At 16:56 +0200 4/26/05, Jigal van Hemert wrote:
From: "Paul DuBois"
>I realise that it may (and is) defined in such a way, but it still does
not
>explain *why* part of a PRIMARY key might not be NULL. If the combination
of
>parts in the PRIMARY key is such that it can uniquel
That would be true for the entire key, but not for each part of the key...
You have it backwards. Any individual column in a primary key might
contain duplicates. But the combination of values in all of the columns
must be unique.
Regards, Jigal.
--
Paul DuBois, MySQL Documentation Team
Madis
At 16:25 +0200 4/26/05, Jigal van Hemert wrote:
From: "Paul DuBois"
Hi Paul,
A primary key absolutely forbids duplicate values.
Indexes created with the UNIQUE keyword do not allow duplicates, except
for the special case that multiple NULL values are allowed.
I realise that it m
h a unique index therefore cannot be a primary key. However, for the
purposes you describe above, it sounds like the solution is simply to
define your columns as allowing NULL, and to create your index using UNIQUE
rather than PRIMARY KEY.
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin,
Why do you think it's expensive?
It would be nicer if DBD could read the config file during the "use
phase" (for example in BEGIN { ... } ). But I guess I am getting a
little to perl-ish now :-)
DBD reads the config file (once) when it connects to the server.
How would readin
unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
--
MySQL General
the priv_type and I am unclear exactly how to pull this together. If
all tables are allowed to be used can someone help me out with this?
If you want the account to have read-only access, priv_type should be
SELECT.
GRANT SELECT ON db_name.* TO 'some_user'@'some_host'
IDENTIFIED
ree within
the InnoDB tablespace?
If the latter, SHOW TABLE STATUS for any InnoDB table in the tablespace
shows the approximate free space, but this is for the entire tablespace.
If your tablespace has other files besides the raw partition, the free
space value won't answer your question.
At 10:22 -0500 4/21/05, Darryl Hoar wrote:
Greetings,
I am running Mysql 3.23. Is there an sql statment that will allow me
programmatically
to retrieve the names of the tables in a database ?
http://dev.mysql.com/doc/mysql/en/show-tables.html ?
--
Paul DuBois, MySQL Documentation Team
Madison
"own" the databases.
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
]
website: http://www.nusconsulting.com.au
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
--
MySQL General Mailing List
For list
ose you could convert the integer to string instead:
WHERE CONCAT(`id`) = "4aef"
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
At 20:32 +0930 4/14/05, David Lloyd wrote:
David,
Can anyone recommend this book? Or, if not, what book can you
recommend for a newbie.
I always recommend Paul Dubois' New Riders Book:
* http://www.kitebird.com/mysql-book/
Paul's probably lurking on the list. I bought the 1999 edi
8, and beside making sure the data
> is encoded in utf-8 properly (which i think i did), what else do i
> need to do on the programming level?
> or could i have done wrong in some of the steps?
> or could i have not done some necessary steps to work with mysql
> charset fe
re sp_equipment_find (
IN L_ORDER_BY MEDIUMTEXT
)
BEGIN
SELECT * from mytable ORDER BY @L_ORDER_BY;
END$
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, US
,d';
insert into t set s = 'a,b,c,d';
select s, bit_count(s) from t;
Result:
+-+--+
| s | bit_count(s) |
+-+--+
| a |1 |
| a,b |2 |
| a,c |2 |
| b,c,d |3 |
| a,b,c,d |
Alejandro.
On Mon, 28 Mar 2005 14:21:28 -0600, Paul DuBois <[EMAIL PROTECTED]> wrote:
At 16:30 -0300 3/28/05, Alejandro D. Burne wrote:
>Hi, I'm testing 5.0.3.
>I make a rpm update from 5.0.2.
>After it mysqld through mysqlamanager doesn't start. I'll be watching
what is it?
It's listed here:
http://dev.mysql.com/doc/mysql/en/mysql.html
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
difference between @@ and @?
@ is used for user variables (variables that you define yourself)
@@ is used for system variables, such as storage_engine or sql_mode.
http://dev.mysql.com/doc/mysql/en/set-option.html
http://dev.mysql.com/doc/mysql/en/variables.html
--
Paul DuBois, MySQL Documentation Te
MySQL, Third Edition (Sams Developers Library, 2005) has been published.
More information is available at the book's Web site:
http://www.kitebird.com/mysql-book/
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
--
MySQL General Mailing List
For
At 19:45 +0100 3/10/05, Dr. Winter wrote:
Hello,
I have a question, which nobody could answer me yet:
What does the "my" stand for in "MySQL"?
http://dev.mysql.com/doc/mysql/en/history.html
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.
te?
You might want to use DROP USER instead:
http://dev.mysql.com/doc/mysql/en/drop-user.html
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
v.mysql.com/doc/mysql/en/bit-functions.html
--
Tom Crimmins
Interface Specialist
Pottawattamie County, Iowa
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
but I'll guess that the
answer to your questions is: Include an explicit DEFAULT clause in
your column definitions.
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
t archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--
Paul DuBois, MySQL Documentation Team
Madison, Wisc
http://dev.mysql.com/doc/mysql/en/c-api-datatypes.html
Check out the description for the type member of the MYSQL_FIELD
structure.
If you mean something else, you'll need to say what. If you can
be more specific, that would help.
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, US
1
--
+---+
| 1 |
+---+
| 1 |
+---+
1 row in set (0.00 sec)
Bye
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
x27;d have to use a BDB table, because only BDB allows a single
NULL per UNIQUE index.
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 22, 2005 3:13 PM
To: Gustafson, Tim; mysql@lists.mysql.com
Subject: Re: UNIQUE Key Allowing Duplicate NULL Values
At
--+
And I can insert even more NULL rows if I want to. Shouldn't the UNIQUE
key prevent this from happening?
Not for NULL values, no. See the description for UNIQUE indexes here:
http://dev.mysql.com/doc/mysql/en/create-table.html
--
Paul DuBois, MySQL Documentation Team
Madison
coded in PHP to allow variable passing on the
query line, err!
I hope I'm missing something.
Thanks a lot for any help you can provide.
Scott.
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
--
MySQL General Mailing List
For list archives: http://list
At 19:44 -0800 2/17/05, Matt Florido wrote:
Paul DuBois wrote:
At 19:21 -0800 2/17/05, Matt Florido wrote:
I'm wondering if anyone can provide any tips as to how to conserve
resources. Currently, I see 10 instances of mysqld running. Each
instance is approximately 18MB. For my applicati
some of
the startup options by half.
key_buffer_size=32M
back_log=25
table_cache=32
net_buffer_length=1M
max_allowed_packet=3M
query_cache_limit = 1M
query_cache_size = 16M
query_cache_type = 1
read_buffer_size=2M
read_rnd_buffer_size=8M
--
Paul DuBois, MySQL Documentation Team
Madison, Wis
iable begins counting
from 0 again.
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
data in my log files, while other logs
are very informative and important. How can I do that?
See:
http://dev.mysql.com/doc/mysql/en/set-option.html
Check the descriptions for SQL_LOG_BIN and SQL_LOG_OFF.
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
--
MyS
tore dates as separate
year, month, and date columns. But that might be more of a hassle
than you want to deal with.
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
host_name?
Perhaps you want:
DBI:mysql:club:localhost
I get the following error: "DBI connect<'gjw:club','gjw'...> failed: Unknown
MySQL server Host 'club' <11001> at line 6";
How do I find out my server HOST name is? What else is wrong?
I have done
my test directory that was
created on install... ie mysql owns everything.
When entering the command mysql> use BagusDatabase;
mysql reports that:
Didn't find any fields in table 'editors'
How can I get my old tables into my new database?
Thanks,
Bagus
-Original Message
at for some of you out there. Can someone help me figure
out how to recreate my database?
Thanks,
Bagus
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--
Paul DuBois, MySQL Documentation Team
Madison, Wiscon
is still incrementing the field. How can I
avoid this if
it is possible? I am trying to avoid to use the function MAX() to get the
last ID inserted.
Thanks for any help.
>> Andre
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
--
MySQL Gen
CAT. Right?
Right.
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
7;;
Query OK, 0 rows affected (0.00 sec)
mysql> SELECT 'a' || 'b';
++
| 'a' || 'b' |
++
| ab |
+----+
1 row in set (0.14 sec)
There are a lot of ways you can make the server behave differently
by changing the SQL mode
e server as a service, you can remove
the service with mysqld --remove. Then reinstall the service, but this
time specify an option file name. For example:
mysqld --install mysql --defaults-file=C:\my-opts.cnf
http://dev.mysql.com/doc/mysql/en/Windows_start_service.html
--
Paul DuBois, MySQL D
AMP type that's stored as second since the epoch.
DATETIME is stored like this:
Part 1 is a 32-bit integer containing year*1 + month*100 + day.
Part 2 is a 32-bit integer containing hour*10000 + minute*100 + second.
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB,
, then the unique key is
functionally the same as a primary key).
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ysql -p DB < test.sql
Is there any way I can show the warning and message?
Try increasing the verbosity level, for example, with -vv or -vvv.
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
--
MySQL General Mailing List
For list archives: http://l
ere any way I can show the warning and message?
Try increasing the verbosity level, for example, with -vv or -vvv.
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
there is some single quotes that may be messing it up or
something like.
What is the best way to do this?
Thanks
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
ON
(SELECT * FROM FOO WHERE ID = 2)
ORDER BY COL_A
.. see the change in the ORDER BY... I can't call if FOO.COL_A I
have to call it COL_A
Kevin
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
--
MySQL General Mailing List
For list archives: http://
do it the
correct way...
thanks
What did mysqld --help report for the set of option files that mysqld will
read?
-Original Message-----
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 15, 2004 11:08 AM
To: Randy Paries; [EMAIL PROTECTED]
Subject: Re: Help getting mysqld to re
;$d/bin/mysql_print_defaults"
break
fi
done
fi
# Hope it's in the PATH ... but I doubt it
test -z "$print_defaults" && print_defaults="my_print_defaults"
Fi
==SNIP===
--
MySQL General Mailing L
_query (my_connection,temp,strlen(temp))) return \"0\";
if(!(result=mysql_store_result(my_connection))) return \"0\";
row=mysql_fetch_row(result);
mysql_free_result(result);
mysql_close(my_connection);
return row[0];
}
If you have any ideas what can
d with debugging support?
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Grant_priv: N
References_priv: N
Index_priv: N
Alter_priv: N
That is all the colums in mysql.user. Please help, and thank you in
advance.
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.my
201 - 300 of 2906 matches
Mail list logo
