Re: About EXPLAIN: Extra column information

Hi, "Can anybody explain me the difference between "using index", "using index condition" and "using where" in the EXTRA column information of EXPLAIN query?" using index: the columns selected are part of an index that is used to return the results, ther

About EXPLAIN: Extra column information

Can anybody explain me the difference between "using index", "using index condition" and "using where" in the EXTRA column information of EXPLAIN query? I have read the official doc but i am confused. Thank you.

Re: store transaction rollback information

s changed in a transaction in a way I can store it and > rollback later? James, The way you describe it sounds like you have a modeling issue with your system. Committed transactions are not supposed to be rolled back. Your System Architect has to arrange things in such a way that all t

Re: MySQL Connection Information

On Tue, November 13, 2012 22:38, Prabhat Kumar wrote: > No, If you are using non-persistence connection & once the query get > complete you are closing the connection properly. > Is this true if you are using mod_php or equivalent? > > On Wed, Nov 14, 2012 at 11:44 AM, Trimurthy wrote: > >> hi eve

Re: MySQL Connection Information

No, If you are using non-persistence connection & once the query get complete you are closing the connection properly. On Wed, Nov 14, 2012 at 11:44 AM, Trimurthy wrote: > hi every one, i am working with some application which is > developed in php and back end is mysql. in th

Re: Database lock on mysql import - Information

When you say locked, do queries on the other databases fail with an error? If so, whats the error? Is it all queries, or just inserts? Also, how are you doing your export and import? Sent from my iPad On Sep 10, 2012, at 2:38 AM, Roland RoLaNd wrote: > > Dear all, > > I realize this is a very

Database lock on mysql import - Information

Dear all, I realize this is a very newbie question so bear with me please. I know that when you import/export a DB its tables are locked to ensure consistency and no data corruption. but why would other DBs on the same server get locked if im importing/exporting one DB ? in other words: expo

store transaction rollback information

I have a large series of mysql changes(inserts/deletes/updates) taking place in a transaction. After committing there may be some times where I need to roll those changes back later on. Is there an easy way of determining what was changed in a transaction in a way I can store it and rollback late

Patching MySQL CLI to log information

Has anyone ever patched the MySQL or libmysql to log to some logfiles with information like the UNIX user, time, server connected to, port etc? I'm just trying to save myself a bit of C patching. Cheer

Re: libmysqlclient.so.16 no version information available

Am 31.01.2011 19:31, schrieb Joerg Bruehe: > 2) Both MySQL 5.1 and 5.5 come with version 16 of "libmysqlclient", so >an application built against MySQL 5.1 can directly use that of 5.5 In theory! Build a mysql 5.5 rpm for fedora 13 and install it No way - Without the compat-package it will

Re: libmysqlclient.so.16 no version information available

Harald, Reindl Harald wrote: > You need mysql-5.1 compat-libs package > or rebuild applications against 5.5 Your advice is correct in general, but not in this case: 1) Noel builds from source, as he writes later. 2) Both MySQL 5.1 and 5.5 come with version 16 of "libmysqlclient", so an applic

Re: libmysqlclient.so.16 no version information available

Noel, all, Noel Butler wrote: > Arg! This abomination 5.5 is causing more headaches, > > postfix will not run, I've heard dovecot may not either, amongst others > > > postconf: /usr/lib/libmysqlclient.so.16: no version information > available (required by postcon &

Re: libmysqlclient.so.16 no version information available

gt; >> Am 31.01.2011 09:24, schrieb Noel Butler: > >> > > >> > Arg! This abomination 5.5 is causing more headaches, > >> > > >> > postfix will not run, I've heard dovecot may not either, amongst others > >> > > >> > > >&

Re: libmysqlclient.so.16 no version information available

gt;> Am 31.01.2011 09:24, schrieb Noel Butler: >> > >> > Arg! This abomination 5.5 is causing more headaches, >> > >> > postfix will not run, I've heard dovecot may not either, amongst others >> > >> > >> > po

Re: libmysqlclient.so.16 no version information available

7;ve heard dovecot may not either, amongst others > > > > > > postconf: /usr/lib/libmysqlclient.so.16: no version information available > > (required by postcon > > /etc/init.d/postfix start > > * Starting Postfix Mail Transport Agent postfix

Re: libmysqlclient.so.16 no version information available

hrieb Noel Butler: > > Arg! This abomination 5.5 is causing more headaches, > > postfix will not run, I've heard dovecot may not either, amongst others > > > postconf: /usr/lib/libmysqlclient.so.16: no version information available > (required by postcon > /etc

libmysqlclient.so.16 no version information available

Arg! This abomination 5.5 is causing more headaches, postfix will not run, I've heard dovecot may not either, amongst others postconf: /usr/lib/libmysqlclient.so.16: no version information available (required by postcon /etc/init.d/postfix start * Starting Postfix Mail Transport

MySQL 5.5.8 GA's library files have not version information by default?

hi,everyone today, i installed the MySQL 5.5.8 from source tarball,everything looks like OK. and when i try to start PHP-FPM process,the error printed below: [r...@powerpc mysql-5.5.8]# php-fpm php-fpm: /usr/local/mysql/lib/libmysqlclient.so.16: no version information available (required by php

RE: Information Schema

iour. Its the same in MS SQL Server and similar in Oracle and DB2. It also gives users no more information than they could get using MySQL SHOW commands. Regards John > Hmm, seems indeed every non-privileged user can access it: > > Your MySQL connection id is 13949 > Server version: 5.1

RE: Information Schema

postoffice.co.uk] Sent: woensdag 29 april 2009 5:58 To: Scott Haneda Cc: mysql@lists.mysql.com Subject: Re: Information Schema Scott Information_schema is a virtual database only. I think it was added in MySQL 5.0.2 to comply with SQL:2003 specifications. information_schema provides the same info

Re: Information Schema

. Regards John > I have been meaning to find out about this since I moved to mysql 5. > In version 4, I never saw the table "information schema". With it > being in version 5, I assume it was something only the root users, or > a higher level user could see. > > I now k

Information Schema

I have been meaning to find out about this since I moved to mysql 5. In version 4, I never saw the table "information schema". With it being in version 5, I assume it was something only the root users, or a higher level user could see. I now know that it shows up under any a

Information missing (was: Re: drop down menu to a table)

Sam, if you like to get help (that's one of the things this list is made for), then you need to give us the necessary information - without it, all you can get is wild guesses: sam rumaizan wrote: > How do I insert data from a drop down menu (select box) to a table In general, any

Reading table information......

Hi all, Below are the two examples. In the example 2 its giving 'Reading table information.' where as in the example 1 its not giving. I am not able to find out why it is. Example 2 server is configured by me where as example 1 server is configured by some body else

why is information schema so slow?

We have a pretty large database (several terabytes and hundreds of tables). When I do a simple query from the information schema, e.g. select table_name from tables, it can minutes to come back with the answer. Yet, if I do a show tables, describe or "show create table" the response

RE: Displaying information from table graphically

>-Original Message- >From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] >Sent: Sunday, November 23, 2008 6:12 AM >To: Jujitsu Lizard >Cc: mysql@lists.mysql.com >Subject: Re: Displaying information from table graphically > >Does it support interaction in terms of a

Re: Displaying information from table graphically

re is another table > >> called > >> >> "patients". Patients are being placed into beds, and beds are in the > >> >> rooms. PHP application currently displays all information in textual > >> mode > >> >> via regular HTML ta

Re: Displaying information from table graphically

table called "beds". There is another table >> called >> >> "patients". Patients are being placed into beds, and beds are in the >> >> rooms. PHP application currently displays all information in textual >> mode >> >> via regula

Re: Displaying information from table graphically

On Sat, Nov 22, 2008 at 10:14 PM, Micah Stevens <[EMAIL PROTECTED]>wrote: > On 11/22/2008 04:30 PM, Jujitsu Lizard wrote: > > Summary: (a) Both approaches are quite good, and (b) the CPU efficiency > > argument for stuffing prepared images into a table or similar may be > weak. > > > > The Lizard

Re: Displaying information from table graphically

On 11/22/2008 07:14 PM, Micah Stevens wrote: > On 11/22/2008 04:30 PM, Jujitsu Lizard wrote: > >> Summary: (a) Both approaches are quite good, and (b) the CPU efficiency >> argument for stuffing prepared images into a table or similar may be weak. >> >> The Lizard >> >> >> > By using pr

Re: Displaying information from table graphically

On 11/22/2008 04:30 PM, Jujitsu Lizard wrote: > Summary: (a) Both approaches are quite good, and (b) the CPU efficiency > argument for stuffing prepared images into a table or similar may be weak. > > The Lizard > > By using pre-drawn images and HTML img tag calls you distribute the processing

Re: Displaying information from table graphically

is table > >> called "rooms", and table called "beds". There is another table called > >> "patients". Patients are being placed into beds, and beds are in the > >> rooms. PHP application currently displays all information in textual > mode

Re: Displaying information from table graphically

ble called >> "patients". Patients are being placed into beds, and beds are in the >> rooms. PHP application currently displays all information in textual mode >> via regular HTML tags. But I would like to have that information displayed >> in graphical mode inst

Re: Displaying information from table graphically

placed into beds, and beds are in the > rooms. PHP application currently displays all information in textual mode > via regular HTML tags. But I would like to have that information displayed > in graphical mode instead of textual mode. > > Is there a way to display this information from

Displaying information from table graphically

I have a PHP application that accesses data from MySQL. There is table called "rooms", and table called "beds". There is another table called "patients". Patients are being placed into beds, and beds are in the rooms. PHP application currently displays all informati

Re: Basic information: MySQL Table crash?

Roman Eberle wrote: hi, someone else had a similar question, but didn't get any useful reply here on the list - I'll give it another try. :-) I need some basic understanding of MySQL table crashes. Maybe you can help me, I think it's so basic, no one ever wrote about it. (Until now! ;)) The mys

Basic information: MySQL Table crash?

hi, someone else had a similar question, but didn't get any useful reply here on the list - I'll give it another try. :-) I need some basic understanding of MySQL table crashes. Maybe you can help me, I think it's so basic, no one ever wrote about it. (Until now! ;)) The mysql manual just says 'i

Re: Restore information

erver? And this restore is what you want to verify? > > That is correct. > > Warren - Confidentiality Notice: The following mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential a

Re: Restore information

Olaf Stein wrote: Is my assumption correct that you dump your main production db and restore it to a second server? And this restore is what you want to verify? That is correct. Warren -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://list

Re: Restore information

Hi Warren, R u using any tool/script for backup/restore procedure, if yes, then log files generated by them should let u know, if they were successfull or failed. regards anandkl On 7/21/08, Warren Windvogel <[EMAIL PROTECTED]> wrote: > > Hi All, > Is there a simple way of checking when the back

Re: Restore information

--- Confidentiality Notice: The following mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. The recipient is responsible to maintain the confidentiality of this information and to

Restore information

Hi All, Is there a simple way of checking when the backup db server performed its last restore and whether it was successful or not. I need to ensure that the dump and restore of the production box has run successfully every night until proper backup/DRP procedures are in place. I'm not famili

RE: RE: what is the proper way to store timezone information?

tml > > You can convert back and forth using the system's time zone table. > Read the MySQL manual I've linked to above for more information. I am using just that, and I have also read the manual on the subject, but nonetheless I have to store the time-zone identifier somewhe

RE: RE: what is the proper way to store timezone information?

> -Original Message- > From: Per Jessen [mailto:[EMAIL PROTECTED] > Sent: Saturday, June 14, 2008 6:23 AM > To: mysql@lists.mysql.com > Subject: RE: what is the proper way to store timezone information? > > Boyd, Todd M. wrote: > > >> > >> When

RE: what is the proper way to store timezone information?

Boyd, Todd M. wrote: >> >> When recording this information, do I store the full name or just >> the 'time_zone_id' which is present in mysql.time_zone_name ? > > This is entirely a matter of choice. It's like asking if you should > store formatting whe

RE: what is the proper way to store timezone information?

> -Original Message- > From: Per Jessen [mailto:[EMAIL PROTECTED] > Sent: Friday, June 13, 2008 5:17 AM > To: mysql@lists.mysql.com > Subject: what is the proper way to store timezone information? > > All, > > I will be recording timezone information based on

what is the proper way to store timezone information?

All, I will be recording timezone information based on user input using the time zone names from mysql.time_zone_name - names like 'America/Los_Angeles'. When recording this information, do I store the full name or just the 'time_zone_id' which is present in mysql.time_zone_

Re: Incorrect information in file: './maindb/users.frm'

Sorry, should've sent an update last night. That was indeed the problem. It's fixed now. Thanks to everyone who helped. -Stut -- http://stut.net/ On 5 Jun 2008, at 09:04, Ben Clewett wrote: It could be the size of your InnoDB log files. Or something else which stops InnoDB running. I o

Re: Incorrect information in file: './maindb/users.frm'

It could be the size of your InnoDB log files. Or something else which stops InnoDB running. I once changed server and by mistake changed the size of the innodb_log_file_size. The result was that InnoDB could not start and instead dissabled its self. Therefore every table I created became M

Re: Incorrect information in file: './maindb/users.frm'

On 5 Jun 2008, at 00:41, Phil wrote: Just a very quick guess but is innobd engine running ? SHOW STATUS like '%inno%' Output shown below. I've just finished importing the backup file again (into a different DB) and it's ignored the engine=innodb on each create table and has used MyISAM ins

Re: Incorrect information in file: './maindb/users.frm'

Just a very quick guess but is innobd engine running ? SHOW STATUS like '%inno%' On Wed, Jun 4, 2008 at 6:44 PM, Stut <[EMAIL PROTECTED]> wrote: > On 4 Jun 2008, at 23:10, Stut wrote: > >> HELP!! >> >> Our database just died. SHOW TABLE STATUS shows the message in the status >> line for every ta

Re: Incorrect information in file: './maindb/users.frm'

On 4 Jun 2008, at 23:10, Stut wrote: HELP!! Our database just died. SHOW TABLE STATUS shows the message in the status line for every table except the one that's MyISAM - the rest are InnoDB. Is there any way to rebuild the .frm files for the InnoDB tables? Can anyone help? I know I haven

Incorrect information in file: './maindb/users.frm'

HELP!! Our database just died. SHOW TABLE STATUS shows the message in the status line for every table except the one that's MyISAM - the rest are InnoDB. Is there any way to rebuild the .frm files for the InnoDB tables? -Stut -- http://stut.net/ -- MySQL General Mailing List For list arc

Re: Information schema question.

On Tue, Mar 18, 2008 at 9:58 AM, Carlos Savoretti <[EMAIL PROTECTED]> wrote: > Hi all! > > Well, question is how could I to retrieve information about > types supported . In PostgreSQL the query would be: > >

Re: Information schema question.

Carlos Savoretti schrieb: Hi all! Well, question is how could I to retrieve information about types supported. IMHO, no -- Sebastian -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Information schema question.

Hi all! Well, question is how could I to retrieve information about types supported . In PostgreSQL the query would be: -- SELECT pg_type.oid, typname, usename, obj_description(pg_type.oid) FROM pg_type, pg_user WHERE typowner

I: information from another table for custom engine

> are you asking how is it you can access information in a MySQL DB without > > connecting to MySQL DB? > > > > please elaborate > > > > No, the thing is that I'm already running in the mysqld process because I'm > talking about a custom eng

Re: information from another table for custom engine

> are you asking how is it you can access information in a MySQL DB without > connecting to MySQL DB? > > please elaborate > No, the thing is that I'm already running in the mysqld process because I'm talking about a custom engine library that I wrote. So my code r

I: information from another table for custom engine

Anyone - Messaggio inoltrato - > Da: Scara Maccai <[EMAIL PROTECTED]> > A: mysql@lists.mysql.com > Inviato: Venerdì 7 marzo 2008, 6:07:42 > Oggetto: information from another table for custom engine > > Hi, > > I'm writing a custom engine to read

Re: Updating rows in a table with the information from the same table

MariSok schrieb: I have a products table with historical price information. Some records are missing price information. I added another field - closest_price, to be populated for records with 0 price. This would be price values from the same table, same product with non-zero price with earliest

Updating rows in a table with the information from the same table

I have a products table with historical price information. Some records are missing price information. I added another field - closest_price, to be populated for records with 0 price. This would be price values from the same table, same product with non-zero price with earliest date. So my

information from another table for custom engine

Hi, I'm writing a custom engine to read data written in a legacy format as it was a regular mysql table. To read data properly I need information from some myisam tables in the same db. How can I query those myisam tables from my custom engine? I don't like the idea of connectin

Re: MySQL master-master replication on windows platform information wanted

At 12:01 PM 11/27/2007, you wrote: Who has experience with setting up master-master replication with MySQL between two Windows-servers. I would like to try setting it up and am looking for experiences, tips an possibly a hands-on manual. Arno Bouwman. Arno, The search engine is your fri

Re: Path information into database

Brian E Boothe wrote: > so how would i get the Actual file path to the folder into the database, > i know ill have to use a file selector in asp / php but i wanna select > the folder not the Files, it would be really great if u could help me > with these issues, > i'm not asking u to Code anything

Path information into database

so how would i get the Actual file path to the folder into the database, i know ill have to use a file selector in asp / php but i wanna select the folder not the Files, it would be really great if u could help me with these issues, i'm not asking u to Code anything for me , just links of exampl

Re: Path information to a database

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Brian, There are several ways you could store this information, either complete paths, or relative paths, something along these lines: Tables: - --- Projcts: ++ | PROJ_ID | PATH

Path information to a database

--Drawings --Labels I need to store all this relavent Path Information into a MySQL database, so i can Link it all into the database instead of using fileshares , has anyone done this before?? on Paths and Storeing into a database anyone have

RE: append information

ew text and the old text. J.R. ---- From: sam rumaizan Sent: Friday, April 06, 2007 12:31 PM To: [EMAIL PROTECTED] Subject: re: append information How About CONCAT_WS() "J.R. Bullington" wrote: Use the CONCAT() func

re: append information

#x27;t normally see in a textfield so that you can differentiate between the new text and the old text. J.R. From: sam rumaizan <[EMAIL PROTECTED]> Sent: Friday, April 06, 2007 12:31 PM To: [EMAIL PROTECTED] Subject: re: append information How Abou

re: append information

ursday, April 05, 2007 12:23 PM To: mysql@lists.mysql.com Subject: append information I have a question if you don't mind. The update statement will replace the existing information. What if I have Textarea instead and I want to add information to the field without erasing previous informat

append information

I have a question if you don't mind. The update statement will replace the existing information. What if I have Textarea instead and I want to add information to the field without erasing previous information. Basically append inform

Re: Incorrect information in file...

: Duane Hill [mailto:[EMAIL PROTECTED] > Sent: Thursday, August 31, 2006 10:18 AM > To: Mikhail Berman > Cc: mysql@lists.mysql.com > Subject: Re: Incorrect information in file... > On Thursday, August 31, 2006 at 2:02:42 PM, Mikhail confabulated: >> Hi Duane, >> Have you t

Re: Incorrect information in file...

To: Mikhail Berman > Cc: mysql@lists.mysql.com > Subject: Re: Incorrect information in file... > On Thursday, August 31, 2006 at 2:02:42 PM, Mikhail confabulated: >> Hi Duane, >> Have you tried to repair "test" table using "REPAIR" to see if that >>

RE: Incorrect information in file...

TED] Sent: Thursday, August 31, 2006 10:18 AM To: Mikhail Berman Cc: mysql@lists.mysql.com Subject: Re: Incorrect information in file... On Thursday, August 31, 2006 at 2:02:42 PM, Mikhail confabulated: > Hi Duane, > Have you tried to repair "test" table using "REPAIR"

Re: Incorrect information in file...

.test | repair | error| Incorrect information in file: './testdb/test.frm' | +-++--+-+ I even tried with the USE_FRM option and received the same result. > -Original Message- &g

Re: Incorrect information in file...

yet. I will try that. Thanks. > -Original Message- > From: Duane Hill [mailto:[EMAIL PROTECTED] > Sent: Thursday, August 31, 2006 9:49 AM > To: mysql@lists.mysql.com > Subject: Incorrect information in file... > MySQL v5.0.24 on FreeBSD v6.0-RELEASE > I was a

RE: Incorrect information in file...

Hi Duane, Have you tried to repair "test" table using "REPAIR" to see if that solves your problem? Regards, Mikhail Berman -Original Message- From: Duane Hill [mailto:[EMAIL PROTECTED] Sent: Thursday, August 31, 2006 9:49 AM To: mysql@lists.mysql.com Subject: Inco

Incorrect information in file...

option from 8 to 4. That was the only changes I made in the configuration file. Upon restarting MySQL, I could not select anything from any of the InnoDB tables and received this error: ERROR 1033 (HY000): Incorrect information in file: './testdb/test.frm' I did

Re: refrenceing information thru seperate tables

filter resultset otherwise join query returns all recordset from both tables The above query has been written using inner join , This Query returns resultset only the cutomers belongs to particular productid information in the cusstomer table. We hope it is ok for you . Thanks Visolve DB Team

refrenceing information thru seperate tables

HI all ; i wanna be able to link tables bu either id or Customer , and i also want to have a seperate table for Software information on that Customer, so in one table it would be Customer name : and another table would be products, linked to product id, so when i do a Queru it shows both

Need Information About MySql Support for Application Blocks

Hello, I am a dotnet developer and i want to use Data Access Application Blocks for dotnet, so i want to know whether MySql Supports Data Access APPlication Blocks, and if so pl provide the connector for that. -- Thanks & Regards, veerabhadra rao narra, +91-988-556-5556

Re: Missing information Search

Robert >What I need to be able to do is find any values of K_Code in table 1 that don't >appear in table 2. SELECT t1.k_code FROM table1 t1 LEFT JOIN table2 t2 USING (k_code) WHERE t2.k_code IS NULL; PB - Robert Gehrig wrote: Hi I have two tables that are structured like so: Table 1:

Missing information Search

Hi I have two tables that are structured like so: Table 1: ID int K_Code int Table 2 K_Code int K_Desc char Table 2 has been corrupted and may be missing some records. What I need to be able to do is find any values of K_Code in table 1 that don't appear in table 2. T

RE: deadlock - further information

> As 11 > 4, 4.1.11 is newer than 4.1.4, so this variable is available to you. Gawwddd... I really made an ass of myself that time... :o) Thanks for pointing it out though. > 4.1.11 is almost a year old. Have you read the list of bugs fixed since then? >

Re: deadlock - further information

Rithish Saralaya wrote: in 4.1.xx, you can use the my.cnf option innodb_locks_unsafe_for_binlog to make InnoDB to use a consistent read in the SELECT tables in CREATE ... SELECT. Read the caveats about the my.cnf option, though. Thanks. However, whatever is written in http://dev.mysql.com/do

deadlock - further information

> > > > Hello. > > > > We have a web application for our intranet, which uses MySQL for db > > management. The application has a way of logging query errors that are > > generated in the system. > > > > We get a mysql error recorded as - "Deadlock found when trying to get > > lock; > > try restarti

Information schema for pages ?

All, I've searched the help and even found this very useful link http://www.xcdsql.org/Misc/MySQL_INFORMATION_SCHEMA.html regarding all the Information schemas. What I can find is information regarding some way to retrieve the number of pages used to store an index. Perhaps this is be

Re: deadlock - further information

Rithish, - Original Message - From: ""Rithish Saralaya"" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Monday, March 20, 2006 10:02 AM Subject: deadlock - further information --=_NextPart_000_0059_01C64C23.16088020 Content-Type: text/

deadlock - further information

Hello. We have a web application for our intranet, which uses MySQL for db management. The application has a way of logging query errors that are generated in the system. We get a mysql error recorded as - "Deadlock found when trying to get lock; try restarting transaction" when one of the files

RE: Inserting information into multiple tables and problems

todd hewett wrote: >>>mysql> INSERT INTO BOARD_SERIAL_NUMBER (BOARD_SERIAL_NUMBER) >>>mysql> VALUES(36534); >>> >>>ERROR 1216: Cannot add a child row: a foreign key constraint fails > > >>Can you please post the output of: > > >>SHOW CREATE TABLE BOARD_SERIAL_NUMBER; > > > mysql> SHOW CREATE

Re: Inserting information into multiple tables and problems

todd hewett wrote: mysql> INSERT INTO BOARD_SERIAL_NUMBER (BOARD_SERIAL_NUMBER) mysql> VALUES(36534); ERROR 1216: Cannot add a child row: a foreign key constraint fails Can you please post the output of: SHOW CREATE TABLE BOARD_SERIAL_NUMBER; mysql> SHOW CREATE TABLE BOARD_SERIAL_NUMB

RE: Inserting information into multiple tables and problems

>> mysql> INSERT INTO BOARD_SERIAL_NUMBER (BOARD_SERIAL_NUMBER) >> mysql> VALUES(36534); >> >> ERROR 1216: Cannot add a child row: a foreign key constraint fails >Can you please post the output of: >SHOW CREATE TABLE BOARD_SERIAL_NUMBER; >> mysql> INSERT INTO BOARD_TYPE (BOARD_TYPE) VALUES(INPUT

Re: Inserting information into multiple tables and problems

Todd Hewett wrote: mysql> INSERT INTO BOARD_SERIAL_NUMBER (BOARD_SERIAL_NUMBER) mysql> VALUES(36534); ERROR 1216: Cannot add a child row: a foreign key constraint fails Can you please post the output of: SHOW CREATE TABLE BOARD_SERIAL_NUMBER; mysql> INSERT INTO BOARD_TYPE (BOARD_TYPE) VALUE

Re: Inserting information into multiple tables and problems

SNIP--- You need to end each INSERT INTO statement with a semicolon (;), not a comma (,). Also pressing after each one will allow you to easier diagnose any problems that might come up. - I have run th

Re: Inserting information into multiple tables and problems

Todd Hewett wrote: I currently am failing with the following: mysql> INSERT INTO VCS_PO_NUMBER (VCS_PO_NUMBER) VALUES(899234), -> INSERT INTO BOARD_SERIAL_NUMBER (BOARD_SERIAL_NUMBER) VALUES(36534), -> INSERT INTO BOARD_TYPE (BOARD_TYPE) VALUES(INPUT MODULE N12310), -> INSERT INTO RE

Inserting information into multiple tables and problems

Howdy Folks I hope this is not too much information. I have mysql Ver 11.18 Distrib 3.23.58, for redhat-linux-gnu (i386) I have multiple tables. All are innoD Tables. All AI on a Primary key integer All Columns are varchar 255 that are not keys. Table VCS_PO_NUMBER Has

Re: Can I use the information from "SHOW STATUS" in a SELECT statment ?

Speaking of Perl scripts that do this: http://codenode.com/mysqlreport I almost never use SHOW STATUS directly anymore since most the values have to be transformed one way or another to really be meaningful. -Daniel Sid Lane wrote: I don't know if you can do it directly in a mysql shell like t

RE: Can I use the information from "SHOW STATUS" in a SELECT statment ?

> -Original Message- > From: Sid Lane [mailto:[EMAIL PROTECTED] > Sent: 16 August 2005 14:54 > To: mysql@lists.mysql.com > Subject: Re: Can I use the information from "SHOW STATUS" in > a SELECT statment ? > > I don't know if you can do it direc

Re: Can I use the information from "SHOW STATUS" in a SELECT statment ?

I don't know if you can do it directly in a mysql shell like that (like you would with v$, dba_ in Oracle) but if you call a show command from PERL (via DBI) it hashes the result just like it were from a select. may not be the most elegant solution but its the best I've come up with though I'll ha

Can I use the information from "SHOW STATUS" in a SELECT statment ?

Hello to everyone on [EMAIL PROTECTED], In 2 words, what I wish to do is something like : mysql> SELECT @@Qcache_queries_in_cache / @@Qcache_hits; Is it possible ? Thank you. -- Cheers, Maxim Vexler (hq4ever). Do u GNU ? -- MySQL General Mailing List For list archives: http://lists.mysql.

  1   2   3   4   >