*plonk*
- Original Message -
> From: "Charles Brown"
> To: "Reindl Harald"
> Cc: "MySql"
> Sent: Thursday, 22 March, 2012 5:37:00 AM
> Subject: tables do not have the same number of columns.
>
> I have two mysql instances in my mysql cluster. I noticed that their
> MysSQL.user tables d
Just use another term will solve your problem.Or you can use pager more in
mysql command line client.
On Sun, Sep 28, 2008 at 12:44 AM, Dan Nelson <[EMAIL PROTECTED]>wrote:
> In the last episode (Sep 27), Alex Katebi said:
> > Hi,
> >
> > When selecting (example: select * from mysql.db ) some o
In the last episode (Sep 27), Alex Katebi said:
> Hi,
>
> When selecting (example: select * from mysql.db ) some of the mysql
> database tables the result set does not fit in a standard xterm window. Is
> there any terminal display program in Linux that has a horizontal scroll bar
> that I can u
Is there any terminal display program in Linux that
has a horizontal scroll bar that I can use?
TheUsual/PHP (http://www.artfulsoftware.com/theusualReadMe.html) do and
phpMyAdmin do that in web interfaces.
PB
Alex Katebi wrote:
Hi,
When selecting (example: select * from mysql.db ) some o
select * from mysql.db\G
2008/9/27, Alex Katebi <[EMAIL PROTECTED]>:
>
> Hi,
>
> When selecting (example: select * from mysql.db ) some of the mysql
> database tables the result set does not fit in a standard xterm window. Is
> there any terminal display program in Linux that has a horizontal sc
Peter South wrote:
Ok here is what I'm trying to do.
Table 1 Table 2
Table 3
Column1(id) Column2 (score) Column1(id) Column2(score)Column1(id) Column2(name)
1
[snip]
[snip]
Can anyone tell me how to add up values in different tables? For example
Table1.Column1 + Table2.Column2 + Table1.Column3 Where id(row) =3D n
[/snip]
SELECT t1.c1 + t2.c2 + t3.c3 FROM table WHERE id =3D n
The above doesn't work I'm afraid.
[/snip]
Don't be afraid, you must join th
[snip]
Can anyone tell me how to add up values in different tables? For example
Table1.Column1 + Table2.Column2 + Table1.Column3 Where id(row) =3D n
[/snip]
SELECT t1.c1 + t2.c2 + t3.c3 FROM table WHERE id =3D n
The above doesn't work I'm afraid.
[/snip]
Don't be afraid, you must join the tables
How about:
select sum(t1.column1 + t2.column2 +t3.column3) as Columnsum
from
Table1 t1
inner join Table2 t2 on t1.id=t2.id
inner join Table3 t3 on t2.id=t3.id
where t1.id=n
group by t1.id
This is a rough cut that assumes the id value in the join exists in all
three tables. If it's missing in
[snip]
Can anyone tell me how to add up values in different tables? For example
Table1.Column1 + Table2.Column2 + Table1.Column3 Where id(row) = n
[/snip]
SELECT t1.c1 + t2.c2 + t3.c3 FROM table WHERE id = n
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscr
Thank you Gleb, I will try that out and let you know how I did..
Thanks again,
Anoop
On 5/5/05, Gleb Paharenko <[EMAIL PROTECTED]> wrote:
>
> Hello.
>
> Remove mysqld-nt and install mysqld-nt-max. See:
>
> http://dev.mysql.com/doc/mysql/en/windows-start-service.html
>
> >jNo - mysqld-nt-max i
Hello.
Remove mysqld-nt and install mysqld-nt-max. See:
http://dev.mysql.com/doc/mysql/en/windows-start-service.html
>jNo - mysqld-nt-max is not running - I can see in the task manager that
>jonly mysqld-nt is running!!
>jI also confirmed this by checking in my services - I only have
No - mysqld-nt-max is not running - I can see in the task manager that only
mysqld-nt is running!!
I also confirmed this by checking in my services - I only have mysqld-nt
present as a service for mysql!
Should I run mysqld-nt-max for this functionality to work??
Also - I need to run only myisa
Hello.
mysql.exe is a client utility, I've meant the server process. Check that
you're running mysqld-max-nt.exe.
>I am not sure about max - but I am running mysql.exe (I think it is the
>same as mysqld-nt).
>
>No - when I do a select * from on a table in the moved database - I get
>th
Is there a link that someone can suggest which details out how to move
databases from one location to another in mysql?
Thanks in advance.
Anoop
On 5/4/05, Anoop kumar V <[EMAIL PROTECTED]> wrote:
>
> I am not sure about max - but I am running mysql.exe (I think it is the
> same as mysqld-nt).
I am not sure about max - but I am running mysql.exe (I think it is the same
as mysqld-nt).
No - when I do a select * from on a table in the moved database - I get the
error that the table does not exist.
well - how can i tell if i have disabled symlinks???
I have not checked using 4.1.11.
Th
Hello.
Are you sure that you are running mysqld-max (mysqld-max-nt)? Are you
able to select data from invisible tables? Is it possible that you have disabled
symlinks? Does the problem remain with 4.1.11 version?
>I use mysql 4.0.23-nt on win XP.
>
>In order to shift some of my datab
Hello.
Not enough information to make a suggestion. You have a very
old version. Upgrade it.
Jeff Schwartz <[EMAIL PROTECTED]> wrote:
> [-- text/plain, encoding 7bit, charset: us-ascii, 12 lines --]
>
> I'm running MySQL 4.0.14 and it's locking tables for everything including
> counti
Carlos Bergueira wrote:
Hi,
I need to know some things:
- Where can i get (url of document) the MySql database fields ? (For example, i
need to list all tables of a database (database: mydb) and for each table
properties like comments, size, record number, etc ?). I use PHP to write
output.
- I nee
Hi, Carlos
> - Where can i get (url of document) the MySql database fields ? (For
example, i
> need to list all tables of a database (database: mydb) and for each table
> properties like comments, size, record number, etc ?).
You should use "SHOW TABLE STATUS" it will provide you with any info tha
Hello.
If your tables are MyISAM and you think that they are damaged, I
suggest you to stop the MySQL server, make a backup of the data
directory (just copy to other place) and then run a myisamchk
program to repair them. See:
http://dev.mysql.com/doc/mysql/en/repair.html
http://dev.
On Thu, 23 Dec 2004 11:54:30 -0500, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>
> Yes, it should be possible to 'alias' an entire table through a view
Thank you all for your help. Of course the production server is 4.1,
but I will start immediately to test version 5
--
Ciao
Nico
--
MySQL G
On Thu, 23 Dec 2004 11:30:34 -0500, Rhino <[EMAIL PROTECTED]> wrote:
>
> It is always best if you post followup questions/remarks back to the list.
Sorry, wrong button.
--
Ciao
Nico
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.m
based on a Join is ALWAYS read-only.
>
> Rhino
>
> - Original Message -
> From: <[EMAIL PROTECTED]>
> To: "Rhino" <[EMAIL PROTECTED]>
> Cc: "mysql" ; "Nico Alberti"
<[EMAIL PROTECTED]>
> Sent: Thursday, December 23, 2004 11:
]>
Sent: Thursday, December 23, 2004 11:54 AM
Subject: Re: Tables "shortcuts"?
> Yes, it should be possible to 'alias' an entire table through a view
> (assuming your version of MySQL has views). Views will be "updateable" so
> long as none of the columns
you.
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
"Rhino" <[EMAIL PROTECTED]> wrote on 12/23/2004 11:30:34 AM:
>
> - Original Message -
> From: "Nico Alberti" <[EMAIL PROTECTED]>
> To: "Rhino" <[EMAIL PROTECTED]
- Original Message -
From: "Nico Alberti" <[EMAIL PROTECTED]>
To: "Rhino" <[EMAIL PROTECTED]>
Sent: Thursday, December 23, 2004 10:25 AM
Subject: Re: Tables "shortcuts"?
> On Thu, 23 Dec 2004 08:46:13 -0500, Rhino <[EMAIL PROTECTED]&g
>
To: <[EMAIL PROTECTED]>
Sent: Sunday, November 07, 2004 5:23 AM
Subject: Re: Tables Crash when I Delete A Row
Hi.
From which version did you upgrade? If you upgraded from 4.0 you should
carefully read:
http://dev.mysql.com/doc/mysql/en/Upgrading-from-4.0.html
May be REPAIR with USE_FRM
Hi.
>From which version did you upgrade? If you upgraded from 4.0 you should
carefully read:
http://dev.mysql.com/doc/mysql/en/Upgrading-from-4.0.html
May be REPAIR with USE_FRM will be helpful. Some times after ugrade tables have
to be rebuilt or repaired.
Aaron <[EMAIL PROTECTE
Thanks for the reply.
Yves
On Tue, 19 Oct 2004 14:22:01 +0300, Egor Egorov <[EMAIL PROTECTED]> wrote:
> Yves Arsenault <[EMAIL PROTECTED]> wrote:
>
> > Does a very large number of tables in a database affect MySQL's performance?
>
> Strictly saying, yes. But the difference won't really matter.
Yves Arsenault <[EMAIL PROTECTED]> wrote:
> Does a very large number of tables in a database affect MySQL's performance?
Strictly saying, yes. But the difference won't really matter. So read - no, it
won't affect performance.
--
For technical support contracts, goto https://order.mysql.com
Stuart Felenstein wrote:
I have two tables
StatesTable CitiesTable
StateID(char) RunningCountID (int)
State (varchar) StateID (char)
City (varchar)
Both are innodb tables, with CitiesTable having a
foreign key referencing StatesTable.StateID
Basicall
Hi Edward,
thanks a lot for your hints. I will try it as soon as possible.
Best regards,
Glenn
"Becoming Digital" <[EMAIL PROTECTED]> schrieb im Newsbeitrag
news:[EMAIL PROTECTED]
> SQL isn't a spreadsheet program. It's a database programming language.
As
> such, it's not going to output tables i
At 12:25 +0200 6/12/03, Glenn wrote:
Hi,
I have this:
++---++
¶ Jahr ¶ Name ¶ Budget ¶
++---++
2003 Hans 2000
2003 Fritz 5000
2004 Hans 1500
2005 Pia 3500
How is it possible to make this in sql?
+-+
¶ 2003 Hans
SQL isn't a spreadsheet program. It's a database programming language. As
such, it's not going to output tables in the manner you want.
>From what I see, it looks like you want to get individual results and a total
for each year. As best I can figure (without sub-selects), that will take two
qu
t;
Sent: Wednesday, 11 June, 2003 16:33
Subject: Re: tables size in mysql database
I got these :
| Name | Type | Row_format | Rows| Avg_row_length
| Data_length | Max_data_length | Index_length | Data_free |
Auto_increment | Create_ti
me | Update_time | Check_time | Create
I got these :
| Name | Type | Row_format | Rows| Avg_row_length
| Data_length | Max_data_length | Index_length | Data_free |
Auto_increment | Create_ti
me | Update_time | Check_time | Create_options | Comment
I guess Data_length shows the size in bytes of the table. if
On Wed, Jun 11, 2003 at 10:08:47AM +0500, Sohail Hasan wrote:
> Hi there,
>
> How can I see per table size of all tables in a particular database.
SHOW TABLE STATUS
--
Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo!
<[EMAIL PROTECTED]> | http://jeremy.zawodny.com/
MySQL 4.0.
On Friday 20 December 2002 04:48, cable at ionbits dot net wrote:
> i cant create SQl tables andoso cant del the tables.. it always shows
> table is read only.. anyway to solve?
Is your table packed with myisampack utility?
Check also that MySQL server has permissions to write in these files.
Have you checked that your network/database administrator has given you
write access to this database?
Phil.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 19, 2002 6:48 PM
To: [EMAIL PROTECTED]
Subject: Tables read only
i cant create
On Wednesday 11 December 2002 17:52, Jason Hall wrote:
> What are some of the reasons why table/index key crashes?
Here is listed some of them:
http://www.mysql.com/doc/en/Corrupted_MyISAM_tables.html
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
: gerald_clark [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 11, 2002 11:12 AM
To: Jason Hall
Cc: '[EMAIL PROTECTED]'
Subject: Re: Tables/Index Crashing?
Power failure/unplug/turn-off server.
kill -9
OS crash.
Operating handheld radios next to the server.
I am sure others can come up
Power failure/unplug/turn-off server.
kill -9
OS crash.
Operating handheld radios next to the server.
I am sure others can come up with more.
Jason Hall wrote:
What are some of the reasons why table/index key crashes?
sql, query
---
:01 PM
To: whiskyworld.de
Cc: MySql Lists Geral (E-mail); MyODBC
Subject: Re: Tables in MySQL
Don't do it this way. Do something like the following:
Assume two tables, "transaction" and "itemlist".
transaction
---
transaction_id
customer_id
purchase_da
Putting the efficiency issues aside to the extent we already have, I don't
see why you can't just use a simple join table for this purpose. You do have
the minor complication of symmetry, but with a simple ordering operation
against your original insertion join even this can be overcome.
Let's wri
Don't do it this way. Do something like the following:
Assume two tables, "transaction" and "itemlist".
transaction
---
transaction_id
customer_id
purchase_date
whatever other junk is relevant to a given transaction...
itemlist
transaction_id
item
* [EMAIL PROTECTED]
> I encountered a problem with my pictures-DB which I with PHP.
> The table's stops at row 126, all photos I store in DB afterwards all get
> the ID 127.
>
> I don't know if it's php or MySQL causing this.
>
> My table structure is
> field typeAllow Nulls
On Friday, 22. March 2002 14:04, [EMAIL PROTECTED] wrote:
Hello,
> I encountered a problem with my pictures-DB which I with PHP.
> The table's stops at row 126, all photos I store in DB afterwards all get
> the ID 127.
>
> I don't know if it's php or MySQL causing this.
>
> My table structure is
Dear Chris,
look here: http://www.mysql.com/doc/J/O/JOIN.html
It's one of the JOINs (INNER JOIN or LEFT JOIN) you are looking for.
Regards,
--
Stefan Hinz
Geschäftsführer / CEO iConnect e-commerce solutions GmbH
# www.js-webShop.com www.iConnect.de
# Gustav-Meyer-Allee 25, 13355 Berl
Hello
I use TQuery for select requests and TTable for update, insert and delete, it's easier
than typing an SQL sentence :-)
My problem has been resolved by a checkbox on the MyODBC driver: I checked "Safety
(check this if you have problems)" and I've no problem anymore. Strange or magic,
isn
How are you updating in delphi and what is the error?
if you are running a query, setting the edit state and request live (either
at design or run time) and then updating the data and it complains that
someone else has changed the record then check the TQuery settings, there
is one that determ
>> I use Delphi 5 and MyODBC to access a MySQL database.
>>
>> In my program, I've sometimes a tables locked and I don't understand why
>! I am the only user on this database and I change records correctly (as I
>do it for other programs on other databases).
>>
>> Does somebody have this problem ?
Patrick Prémartin wrote:
> I use Delphi 5 and MyODBC to access a MySQL database.
>
> In my program, I've sometimes a tables locked and I don't understand why ! I am the
>only user on this database and I change records correctly (as I do it for other
>programs on other databases).
>
> Does so
Yee Chuan Loh <[EMAIL PROTECTED]> writes:
> The document at
> http://www.mysql.com/doc/T/a/Table_size.html
> seems to suggest that the reason why there's a limit to the table size is
> because of the number of bytes used by the file system to store offsets,
> so its more or less file system depe
The document at
http://www.mysql.com/doc/T/a/Table_size.html
seems to suggest that the reason why there's a limit to the table size is
because of the number of bytes used by the file system to store offsets,
so its more or less file system dependant (pls correct me if i'm wrong).
It also wrote t
(sql, to fool lame filter)
ryc <[EMAIL PROTECTED]> writes:
> The OS may not have a 2GB limit, however the table MAY. If you do a
> myisamchk on the table it will tell you if you are running out of space in
> the table. If you are.. you need do something like "alter table tablename
> max_rows=100
The OS may not have a 2GB limit, however the table MAY. If you do a
myisamchk on the table it will tell you if you are running out of space in
the table. If you are.. you need do something like "alter table tablename
max_rows=1000".. (its in the manual)
ryan
> > I have a Linux machine (Linux
Guðmundur Ólafsson <[EMAIL PROTECTED]> writes:
> Hi,
>
> I have a Linux machine (Linux cartman 2.4.2-2smp #1 SMP Sun Apr 8
> 20:21:34 EDT 2001 i686 unknown) that is running MySQL 3.23.38-log and
> now I have a table that is getting VERY near to the ext2 filesystem
> limitation of 2gb.
Ext2 does
- Original Message -
> No, MySQL does not help in enforcing referential integrity. You need to
>do that with your application. In some people's opinion (not mine), it is
>one of the major drawbacks to using MySQL.
I agree. MySQL needs to have RI as its first priority on its TODO list.
Has anyone ever bothered to make a front-end API to MySQL that does maintain
referential integrity and/or allow function calls on events? It might make
an interesting library to write for RDBMS migrators ...
- Original Message -
From: "Christopher R. Jones" <[EMAIL PROTECTED]>
> No, My
"Andis Grasis" <[EMAIL PROTECTED]> wrote:
> Is it's possible to make some kind of relationships between tables
> as it's realised in MsAccess. In MsAccess databases it's called
> "Enforce referential integerity" and it's have some subchoises:
MySQL does not have referential integrity. Though it'
No, MySQL does not help in enforcing referential integrity. You need to do
that with your application. In some people's opinion (not mine), it is one
of the major drawbacks to using MySQL.
>Is it's possible to make some kind of relationships between tables as it's
>realised in MsAccess. In
Thierry Coopman writes:
> Hi,
>
> I have read on some presentation that you can create a table in
> memory that then gets written to disk once every few hours.
>
> I can't find information about that in the documentation, but it
> would be a perfect solution for me. I need 500+ updates
Hi,
check the following for a description on HEAP tables.
http://www.mysql.com/documentation/mysql/commented/manual.php?section=HEAP
HEAP tables are suitable as temporary tables since they are not saved to
disk. What you can do if heap tables suite your needs is to write a script
which writes a
64 matches
Mail list logo
