 | | | MySQL General | | Emmanuel Mwesigwa <emmanuelmwesigwa@(protected) > wrote on 08/16/2005
04 57 53 AM
> Hi
>
> I am running MySQL 4.0.13-nt-log on Windowns XP and I
> need help on the following
>
> 1) I have written Hi
> Why can 't I revoke usage from user?
> mysql > show grants for ' '@ '172.20.16.110 '
> +Hello.
Specify the correct value for datadir when you start mysqld_safe.
For these purposes I normally use configuration file and launch
mysqld_safe with --defaults-file /path/to/my/file cDoes anyone have any experience using multiple my.cnf files on a single box?
If so how is the my.cnf specified during startup and shutdown? I need
multiple my.cnf files to test ibbackup software becMisa wrote
> How can I receive a TRUE or FALSE result?
>
> Example
>
> SELECT `name` `description` FROM `table1`
>
> I don 't want to show the description cause they 're big. I only want to
> showYes theres all this talk about timestamp returning different results
in 4.1 vs. 4.0
but i took the MYI and MYD and frm files from a winnt running 4.0.14
and transferred to a 4.1.11-Debian_4-log
ahttp //www.briandunning.com/helios.shtml
Sorry this is WAY OFF TOPIC but it 's a pretty darn scary picture.
--
MySQL General Mailing List
For list archives http //lists.mysql.com/mysql
To unsubscrHello.
I am trying to obtain a list of products and related information from
three tables using JOINs and GROUP BY.
my tables look like this
products
id int
name varchar
ratings
user_id intWell you could use the FROM_UNIXTIME() function to convert it into a
datetime MySQL understands.
SELECT
COUNT(*) AS score
FROM downloads
WHERE
date_add(FROM_UNIXTIME(dateline) interval 1 h
> Does MySQL 5 provide native XML support? ie can I have a stored
> procedure return an XML string instead of a recordset? Can I pass in
> an XML string/doc and have the DB update relational tablHello.
May be set FOREIGN_KEY_CHECKS 0 alter the definitions of your tables
and set FOREIGN_KEY_CHECKS 1. See
http //dev.mysql.com/doc/mysql/en/innodb-foreign-key-constraints.html
Still no answer perhaps but ther 'es still no question.
Per my earlier response... What version of MySQL is the old version
you refer to what version is the new version you refer to? With that
Hello.
I have used a shell on a Solaris box and successfully ran MySQL Server
under my non-root account. I didn 't have any problems installing
it except that I was unable to start it automaHello.
What version of MySQL do you use? On my 5.0.11 I have a correct result
mysql > show create table dateTest\G
*************************** 1. row ***************************
Tim Johnson wrote
> <grin > it get worse ..... most of my commercial work is running on
> servers with ver 3.23.X (sun and RH servers). I enjoy a
> great relationship with my domain Manoj wrote
> Dear All
> I am trying to join two tables say a & b. Both tables have a set
> of dates. I want to join the tables in such a fashion that I retrieve
> all dates from table A. If tabMysql 's query cache has two option 's [query_cache_limit] and [query_cache_size].
The documentation is not clear (for me) on their purpose and correct
usage tactics.
What does the [query_cache_size] s
> I need to drop a database named ????????? using the mysql client. I 'm
> getting "you have an error in your sql syntax " for the command
>
> DROP database ?????????
>
> I 'm sure this is a charactHi
I use ther version 4.1.11 and when I run this query
SELECT c.id c.subject c.res_type c.news_id c.com_thread c.timestamp +
0 as timestamp FROM comments c WHERE c.id IN (SELECT d.id FROM
commenI just revived a database that was in a version 3.23 server and moved it
to a 4.1 There are big fields of TEXT based data. They have a way of
compressing the amount of TEXT data by identifying coHi
Try in in two fold.
1. Get all the ID you have in your remote DB
2. check those localy with the ones you have in cache
3. Get all the info you need after you remove the ID you already have.
2005CF
>tbl_NotAvailable {
> TAid - int(11)
> StartDate - DateTime
> EndDate - DataTime
>}
<snip >
>Question one
>Now how can I return a calendar of the dates where the TA is AVAILABLE
Pooly wrote
> Hi
>
> I try to convert a varchar to a char but it doesn 't seems to work.
From the manual "...all CHAR columns longer than three characters are
changed to VARCHAR columns. "
<URLSuppose I want to create an animal kingdom database
that gives me the option of displaying the following
taxonomic hierarchies
1) A bread crumbs navigation string including ALL
taxons e.g. AnimaliAt 16 27 -0400 8/12/05 douglass_davis@(protected) wrote
>To the powers that be Can we get a MySql GIS/spatial list?? This
>is going to be a very popular area (actually it is already).
>
>
>I ajavabuddy wrote
> But still I can 't get the part where my column size totals to 560 but MySql
> complaining that I have exceeded 1024. Did I went anywhere wrong???
Are you sure you 've thought your-----BEGIN PGP SIGNED MESSAGE-----
Hash SHA1
Hi
MySQL 5.0.11-beta a new version of the popular Open Source Database Management
System has been released. The Community Edition is now available inJust in the spirit of refining my own skills here is how I would tackle
the problem. It parses but I haven 't populated the tables so I don 't know
if it works
SELECT s.dateshipped COUNT(r.type "
Please note that this answer is not meant to support one OS or another
but the information on that page is not useful. The information is
seriously out of date. The comparison is
on Windows NT I would like to install MySQL 5.0.x beta into two computers and test them.
They will run Windows XP Home Edition (of course with massive updates and
whatsnot) and Linux (SlackWare 10.0 vanilla). I a |
|
|
