 | | | MySQL General | | Hi
I have a table table_a and table_b
table_a {
id
name
}
table_b {
table_a_id
b_value
}
Table A is a table with names and table B is a table with values for a
specific name (optional thereforHi
MySQL 5.0.22 a new version of the popular Open Source Database
Management System has been released. The Community Edition is now
available in source and binary form for a number of platforms fHi
MySQL 4.1.20 a new version of the popular Open Source Database
Management System has been released. The Community Edition is now
available in source and binary form for a number of platforms fI 'd start by looking at your schema.. Quite a lot of use of
varchars... I 'd suggest using chars (takes more space but processes
faster).. Or even better normalize the data so that you have a table
At 17 38 +0200 5/31/06 Gilles MISSONNIER wrote
>Thank you Paul DuBois.
>
>I have 2 questions for you
>
>1-Why the error code (1064) can 't lead explicitly to the syntax problem ?
I 'm sorry I don '-----BEGIN PGP SIGNED MESSAGE-----
Hash SHA1
Hi
MySQL Connector/J 3.1.13 a new version of the Type-IV all-Java JDBC
driver for MySQL has been released.
Version 3.1.13 is a bugfix release for theHi Michael
Have you tried the link at the bottom of every email? If not then have you looked here? http //lists.mysql.com/faq.php
Shouting at everybody who chooses to subscribe (which you have at sLew E. Lefton wrote
> Hi
>
> I hope this is an appropriate place to ask this question if you think
> it is better suited for another list/forum please let me know.
>
> I have a table that loLukasz Budnik wrote
> Hi All
>
> I 'm using 5.0.21 on Gentoo.
>
> I 've got very strange problem.
>
> I have clients table with id_c and name columns.
>
> I 'm running simple selects
>
> mysql > sYes and no. The binary log is a long list of all changes to the
system so if that 's enabled you can get what was done. My binary log
(on 4.1.19) shows the query thread but not the user/host that dI am using MySql 5.0.21-community Edition for widows XP. I can successfully connect to the MySql Server as a root and create a database 'a '. Which creates a directory 'a ' under my mysql\data directoryWhat 's the error you are getting? What MySQL version are you using?
On 5/26/06 Neeraj <neeraj@(protected) > wrote
> Hi all
>
>
>
> I have a table with following structure
>
>
>
> CREATE TABLE `On 6/1/06 Colin Charles <colin@(protected) > wrote
> Deniz Ersoz wrote
> >
> > Is there a way to get the time spent in the server for each query? Write it
> > in a log or append it to the result ???
>At 15 46 +0200 5/30/06 Gilles MISSONNIER wrote
>Hello
>
>I could not find the answer through the online "Search the MySQL manual ".
>I run MySQL 4.1
In the 4.1 manual the reserved words are listed Thanks Dilipkumar
the syntax works fine
mysql > grant file on *.* to 'wr '@ 'localhost '
so the "file " privilege is for ALL databases.
----
by the way to allow "alter " the syntax is like
mysql >Dear MySQL
I am interested in clustering for MySQL. This claims to offer the
redundancy scalability and performance we require.
One thing I am really disappointed at is that clustering seems not Hi
yes it makes a huge difference
as the tables are stored in files and therefore if
the filesystem is case-insensitive (Windows) you can
use either case in your queries while on a case-sensitive
fAt 13 13 -0700 5/30/06 Jeremy Cole wrote
>Hi Wang
>
> > select 9000000000000.10*19.80 wrong result 178200000000001.97
> > if < 900000000000.10*19.80 right result 17820000000001.98
> >This ihttp //dev.mysql.com/doc/refman/5.0/en/multiple-servers.html
-Sheeri
On 5/29/06 Michael Monaghan <mickmon@(protected) > wrote
> Hi
>
> I have a machine [Solaris 9 x86] that has MySQL v3.22.xx instalOn Thursday 01 June 2006 03 05 Mathieu Bruneau wrote
> Harish TM a ?crit
> > hi...
> > I need to store something like a couple of million rows is a MySql
> > table. Is that ok or do I have tChris Sansom wrote
> At 19 44 +1000 31/5/06 Logan David (SST - Adelaide) wrote
> > I would agree I have found it useful as well. It does have a few
> > limitations (well the versions I 've used)
BThi
i am creating web newsprogram by php and mysql.
how to i can use text data type for saving contents of articles in database?
when i use text format contents save in the tables unless eny new line.
At 17 06 +0200 5/29/06 schlubediwup wrote
>2. problem
>according do the mysql docu TEXT/BLOB fields depend solely on the db
>environment and can grow to any length
>
>
> 11.4.3. The |BLOB| anNico
please post more output. Maybe the SELECT from H.albero is just entering
InnoDB and therefore the associated transaction has not yet started.
The output shows lots of file reads. There shoulPeople who 've asked the same question have gotten the answer that it 's
not possible with MySQL if I 'm remembering correctly.
-Sheeri
On 5/29/06 Ghaffar <aghaffar@(protected) > wrote
> Hello all
Dear All
While migrating from MySQL 4.0 to MySQL 4.1 I found that the database
could not be loaded in 4.1 because MySQL 4.1 uses a reserved keyword "div "
that was not "reserved " in 4.0.
Is On 5/29/06 Cory wrote
> I have the following query that is running VERY slowly. Anyone have
> any suggestions?
>
> ---
> SELECT pnr.ID ID_pnr pnr.reservationdatetime pnr.conf_number
> pnr.creatIn the last episode (May 29) wang shuming said
> Hi
> table a1
>
> qty int(10) unitpri float(10 2)
> 350 19.80
> ...
> 350 19.80 (total 48 lines)
>
> select sum(qty*unitpriif04029@(protected) wrote
> Sory if my question makes you confused
> I 've a problem with my sintax
> I don 't know how to select a list whether it 's not registered in another
> table but itLog into the server and type "use mysql " without the quotes.
Look at the "user " table - that defines what user can connect to the database the ip addresses they can use and the password
they mu |
|
|
