Hi. I have a question about rollbacks and innodb.
Suppose that a query begins with begin. Then a couple inserts happen but
before the commit statement is executed, the client hits stop in the
browser. What is going to do the rollback? If there is a persistent
connection, is it going to wait for 8
can mysql use the linux password /etc/passwd for the authentication
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread
Re: Proposed Guidelines for Posting to the MySQL list
> - Replies are directed to the POSTER and not to the list.
> This keeps traffic and clutter down.
This I think is the only point that I have an issue with. If you look above,
there are two (at least right now) replies posting that this is
Hello
As I understand it, MySQL with InnoDB or BDB support can support
transactions. Is there a doc on the shortcomings of these tables and which
one is better? MySQL documentation has a shortcomings page for InnoDB (but
couldn't find one for BDB)
http://www.mysql.com/doc/I/n/InnoDB_restrictions
>Description:
We have a production server with mysql as db server. Currently we
are using 1 server for only processing a mysql queries and ther is
4 mysql servers running on it each using diiferent IP. When I try
to make 1 common mysql server it just recieving signa
this is just a test, please ignore
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi;
I would like to test the following:
update maps set map where site=mysite;
to see if there is such an entry in maps. If there is, then update. If there
is not, then I would like to execute an insert statement. How do I do that?
TIA,
Victor
Perfect. Thank you.
Victor
On Sun, Jul 26, 2009 at 2:18 PM, Darryle Steplight wrote:
> Hi Vicor,
>Look into INSERT ON DUPLICATE or REPLACE statements. You need to
> have a primary key or unique key for these too work.
>
> On Sun, Jul 26, 2009 at 1:11 PM, Victor Subervi
> wr
rsor.execute('use spreadsheets;')
Warning: Can't create database 'spreadsheets'; database exists
What do?
TIA,
Victor
Right. Perhaps you could enlighten me as to what I should code to prevent
that warning? It repeats 2,400 times and makes finding the real errors a
pain in the behind.
Victor
On Tue, Aug 25, 2009 at 12:42 AM, peng yao wrote:
> Warning: Can't create database 'spreadsheets'
e some way to do the same thing from within MySQL? Can I at
least print everything to screen and copy it? Where would I find my database
in Windoze?
TIA,
Victor
t;
> > -Original Message-
> > From: news [mailto:n...@ger.gmane.org] On Behalf Of Emile van Sebille
> > Sent: Wednesday, September 02, 2009 7:18 AM
> > To: mysql@lists.mysql.com
> > Cc: python-l...@python.org
> > Subject: Re: Problem w/ mysqldump
> >
>
together. Hence the need
> for a mysql dump tool ;-)
>
> Mysql dump is the better way to go in either situation.
>
> > -Original Message-
> > From: Victor Subervi [mailto:victorsube...@gmail.com]
> > Sent: Wednesday, September 02, 2009 1:43 PM
> > To:
Hi;
Please give me the syntax below such that I can force the insert statements
to use only selected values ("item1", "item2", "item3"):
create table (field SOMETHING_HERE item1 item2 item3,
...
)
TIA,
Victor
That's it! Thanks,
V
On Tue, Sep 29, 2009 at 12:13 PM, David Giragosian wrote:
> On Tue, Sep 29, 2009 at 11:09 AM, Victor Subervi >wrote:
>
> > Hi;
> > Please give me the syntax below such that I can force the insert
> statements
> > to use only select
Hi;
I'm new to join statements. Here's my python syntax:
cursor.execute('select * from %s left join products on
%s.Item=products.Item (left join categories on
products.Category=categories.ID);' % (client, client))
I believe it's clear how I want to nest, but I don't know how to repair my
syntax
On Thu, Oct 1, 2009 at 4:03 PM, Gavin Towey wrote:
> Joins aren't nested like that, unless you use a subquery. I think you just
> need to remove the parens around the second join.
>
I tried that and no go :(
>
> For better help:
> 1. show the real SQL -- echo the statement. Most people here d
Well, your syntax is *exactly* what I had (with a few cosmetic changes).
I've been over the MySQL manual on joins with no luck. I'll read over your
resources tonight. Any other ideas would be appreciated.
Thanks,
V
On Thu, Oct 1, 2009 at 4:49 PM, Gavin Towey wrote:
> Victor,
>
Thanks! Got it! I was missing the word "from"...
select * FROM %s c ...
Thanks again ;)
V
On Thu, Oct 1, 2009 at 5:08 PM, Gavin Towey wrote:
> Victor,
>
>
>
> Just noticed, the join condition from client to productions should be
> changed:
>
>
>
> se
Hi;
I get the following error:
*SQL query:*
SELECT ID, Item
FROM products
JOIN categories ON categories.ID = products.Category
LIMIT 0 , 30;
*MySQL said:*
#1052 - Column 'ID' in field list is ambiguous
Please note the error is about ambiguity. "products" has an ID field and so
does "categorie
Thanks
V
On Fri, Oct 2, 2009 at 11:08 AM, Mark Goodge wrote:
> Victor Subervi wrote:
>
>> Hi;
>> I get the following error:
>>
>> *SQL query:*
>>
>> SELECT ID, Item
>> FROM products
>> JOIN categories ON categories.ID = products.Category
&g
, 'New', '1.5', 'new', 'princesse', 'princesse', '123 princesse', 'Not
furnished', '', '', '', '', '', '');
which I can enter into the database directly. However, when I try to do it
through the script, I get the following error:
AttributeError: 'tuple' object has no attribute 'encode'
Why is that? There are no tuples here!! Nothing but strings!!
TIA,
Victor
think is the 2 param form of cursor.execute() which
> takes a string statement and a tuple of arguments:
>
> cursor.execute('insert into products values(%s, %s, %s, %s, %s, %s, %s, %s,
> %s,
> %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)' , (id, name, title,
> description,
4, pic5, pic6) values('1', 'name1',
> 'title1', 'descr1', '1.1', '2', '1', 'New', '1.5', 'new', 'princesse',
> 'princesse', '123 princesse', 'Not furnishe
Kd6áÃã5 3...@â4ÃwrÅân ¤ââ-º I dEÅÃOJP[î!8SÅ
¨õáAâE P QE H»QÃë à ^Å[bï $0ò⡠Ãq~ â BOy§ª(8®óg¸Ãç. Ã#±d ñCÆŸË<Ëñ *FûŸ,
ٻû¸Ãò{sGu];U Ã?þ eH»vü ¦¯å5] ~@'õ§?âh$Å (¢â¬Â¢Å ( (¢â¬Â¢Â©U (ªUh (¢ÆÿÃ', '', '',
'', '', '', '')
MySQL complains about the image in string form. I'm sure the solution is
simple, but I don't know what it is.
TIA,
Victor
and the only differences between
them are that the first have the strings in quotes AND there is a % sign
between the string widgets and the variables that replace them. That's it!
Wonder what the *#&^%( difference that makes.
V
On Thu, Oct 15, 2009 at 4:54 PM, Michael Dykman wro
Hi;
I created a user and then granted privileges:
grant all to victor identified by 'pw';
Looked good. Tried to log in as victor an no go. Please advise.
Victor
Never mind. Had to add @'localhost'
On Mon, Nov 9, 2009 at 4:20 PM, Victor Subervi wrote:
> Hi;
> I created a user and then granted privileges:
> grant all to victor identified by 'pw';
> Looked good. Tried to log in as victor an no go. Please advise.
> Victor
>
eptions.ProgrammingError: (1064, "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 'foreign key references categories
(ID),\\n Child integer not null foreign key' at line 3")
Please advise.
TIA,
Victor
On Thu, Nov 19, 2009 at 9:34 PM, Ye Yuan wrote:
> Hi Victor,
>
> It looks to me the foreign key syntax is wrong. Can you create the
> Relationship table on your database by using below ddl?
>
> create table if not exists Relationship
> (ID integer auto_increment primary key,
.
TIA,
Victor
On Sun, Nov 22, 2009 at 9:29 PM, Gavin Towey wrote:
> The form would be like:
>
> CREATE TABLE products
> SELECT b0basics, b0fieldValues, s0prescriptions,
> s0prescriptions0doctors, s0prescriptions0patient, pics FROM table1
> UNION
> SELECT b0basics, b0fieldValues, s0prescriptions,
> s0prescripti
Hi;
I remember vaguely how to do this but don't know how to google it:
show tables like categories$;
such that it will return tables such as:
categoriesProducts, categoriesPrescriptions, etc.
TIA,
Victor
On Sat, Dec 5, 2009 at 11:09 AM, Michael Dykman wrote:
> show tables like 'categories%';
>
Thanks.
V
ories';
will give me the column and its enumerations. How do I supply one of the
enumerations from a column 'Categories' and get the ID?
TIA,
Victor
---+---+
3 rows in set (0.00 sec)
Why the error?
TIA,
Victor
Oops. Never mind.
V
On Sat, Dec 5, 2009 at 1:19 PM, Victor Subervi wrote:
> Hi;
>
> mysql> insert into categories (Category, Parent) values ('test', NULL);
> ERROR 1062 (23000): Duplicate entry '0' for
ect * from categoriesProducts;
++--++
| ID | Category | Parent |
++--++
| 1 | prodCat1 | None |
| 2 | prodCat2 | None |
++--++
2 rows in set (0.00 sec)
So I'm at a loss. No, 'prodCat2' isn't a column, but I don't understand how
I specified that in my query. Please advise.
TIA,
Victor
On Sun, Dec 6, 2009 at 2:42 PM, Steve Edberg wrote:
> At 1:26 PM -0500 12/6/09, Victor Subervi wrote:
>
>> Hi;
>> I have the following:
>>
>> mysql> select * from categoriesProducts as c inner join
>> relationshipProducts
>> as r on c.ID = r.Child i
ect column_type from information_schema.columns where
table_name='products' and column_name='Categories';
will give me the column and its enumerations. How do I supply one of the
enumerations from a column 'Categories' and get the ID?
TIA,
Victor
On Mon, Dec 7, 2009 at 8:08 AM, Tom Worster wrote:
> On 12/7/09 5:26 AM, "Victor Subervi" wrote:
>
> > Hi;
> > I posted this Saturday. Perhaps it's too challenging for those who read
> it
> > to answer. I hope someone can.
> >
> > I need
+--+
| sizes | colorsShadesNumbersShort |
+---+--+
| | |
+---+--+
1 row in set (0.00 sec)
Huh?
TIA,
Victor
On Fri, Dec 11, 2009 at 4:48 AM, Jørn Dahl-Stamnes
wrote:
> On Friday 11 December 2009 10:38, Victor Subervi wrote:
> > Hi;
> >
> > mysql> update products set sizes="('Small', 'Large')" where ID=0;
> > Query OK, 0 rows affected, 1 war
On Fri, Dec 11, 2009 at 4:48 AM, Jørn Dahl-Stamnes
wrote:
> On Friday 11 December 2009 10:38, Victor Subervi wrote:
> > Hi;
> >
> > mysql> update products set sizes="('Small', 'Large')" where ID=0;
> > Query OK, 0 rows affected, 1 war
On Fri, Dec 11, 2009 at 4:43 AM, wrote:
>
> On Fri, 11 Dec 2009 04:38:01 -0500, Victor Subervi
>
> wrote:
> > Hi;
> >
> > mysql> update products set sizes="('Small', 'Large')" where ID=0;
> > Query OK, 0 rows affect
On Fri, Dec 11, 2009 at 5:13 AM, wrote:
>
> On Fri, 11 Dec 2009 05:09:52 -0500, Victor Subervi
>
> wrote:
>
> > mysql> update products set sizes="('Small', 'Large')" where
> SKU='prodSKU1';
> > Query OK, 0 rows af
On Fri, Dec 11, 2009 at 5:33 AM, wrote:
>
> On Fri, 11 Dec 2009 05:28:41 -0500, Victor Subervi
>
> wrote:
> > On Fri, Dec 11, 2009 at 5:13 AM, wrote:
> >
> >>
> >> On Fri, 11 Dec 2009 05:09:52 -0500, Victor Subervi
> >>
> >>
On Fri, Dec 11, 2009 at 8:43 AM, Johan De Meersman wrote:
> On Fri, Dec 11, 2009 at 11:19 AM, Mark Goodge
> wrote:
>
> > Jørn Dahl-Stamnes wrote:
> >
> >> On Friday 11 December 2009 10:38, Victor Subervi wrote:
> >>
> >>> Hi;
> >&g
Hi;
I have a column defined as a set. How do I insert data into that column?
Please give me an example.
TIA,
Victor
On Sat, Dec 12, 2009 at 10:58 AM, David Giragosian wrote:
> On Sat, Dec 12, 2009 at 9:54 AM, Victor Subervi
> wrote:
>
>> Hi;
>> I have a column defined as a set. How do I insert data into that column?
>> Please give me an example.
>> TIA,
>> Victor
||
| Quantity | int(3) unsigned | YES | | NULL||
+--+-+--+-+-++
3 rows in set (0.00 sec)
Please advise.
TIA,
Victor
On Sun, Dec 13, 2009 at 12:21 PM, Pinter Tibor wrote:
> Victor Subervi wrote:
>
>> Hi;
>>
>> mysql> insert into *tem126072414516* (ProdID, Quantity) values ("2", "2");
>> mysql> select * from *tem126072385457*;
>>
>
>
mys
he above select join statement fails. Please
advise.
TIA,
Victor
On Mon, Dec 14, 2009 at 12:37 PM, Peter Brawley wrote:
> > ... on t.ProdID-p.ID;
>
> Your join clause subtracts the two IDs, so it's on IDs that differ, and
> apparently there aren't any.
>
I beg to differ:
mysql> select SKU, Quantity, Name, Price, p.sizes,
p.colorsShadesNumbersShort from tem1
On Mon, Dec 14, 2009 at 1:04 PM, Peter Brawley
wrote:
> ...on t.ProdID-p.ID... _subtracts_ the two IDs. To match them use '='
> rather than '-'.
>
Thank you for all of you that caught that.
V
+
1 row in set (0.00 sec)
mysql> select last_insert_id() from products;
+--+
| last_insert_id() |
+--+
|0 |
+--+
1 row in set (0.00 sec)
mysql>
Now, I was expecting 1, not 0! What up?
TIA,
Victor
On Sun, Dec 27, 2009 at 11:27 AM, Mattia Merzi wrote:
> 2009/12/27 Victor Subervi :
> > mysql> select * from products;
> [...]
> > mysql> select last_insert_id() from products;
> [...]
> > Now, I was expecting 1, not 0! What up?
>
> [...] LAST_INSER
On Sun, Dec 27, 2009 at 12:00 PM, Michael Dykman wrote:
> last_insert_id() returns the last id auto-incremented in *the current
> session*. If you disconnect and reconnect, it can not be retrieved.
>
Ahah! So how do I retrieve the last id inserted irrespective of connection?
TIA,
V
On Sun, Dec 27, 2009 at 1:30 PM, Gary Smith wrote:
> Victor Subervi wrote:
>
>> On Sun, Dec 27, 2009 at 12:00 PM, Michael Dykman
>> wrote:
>>
>>
>>
>>> last_insert_id() returns the last id auto-incremented in *the current
>>> session*. If
that
one association may have 2 products and another 20. What is the best way to
MySQL this?
TIA,
Victor
--
The Logos has come to bear
http://logos.13gems.com/
|
+-+--+---+
| Warning | 1265 | Data truncated for column 'colorsShadesNumbersShort' at
row 1 |
+-+--+---+
1 row in set (0.00 sec)
Please advise.
TIA,
Victor
--
The Logos has come to bear
http://logos.13gems.com/
On Fri, Jan 1, 2010 at 4:34 PM, Don Read wrote:
> On Fri, 1 Jan 2010 14:34:48 -0500 Victor Subervi said:
>
> > Hi;
>
>
> > The following insert chokes when I try to insert multiple values from the
> > sets:
> >
> > insert into products (SKU,
On Sat, Jan 2, 2010 at 11:20 AM, Arthur Fuller wrote:
> Hi Victor.
>
> I think that the first thing you need to consider is whether a product can
> be in more than one package, and second is whether a package can be in
> another package. Also, I don't know why you need to aut
On Sat, Jan 2, 2010 at 12:03 PM, prabhat kumar wrote:
> primary key
Oh! PK is primary key!
> a compound key is a key that consists of 2 or more attributes that uniquely
> identify an entity occurrence.
Thanks.
V
On Sat, Jan 2, 2010 at 11:20 AM, Arthur Fuller wrote:
> Hi Victor.
>
> I think that the first thing you need to consider is whether a product can
> be in more than one package, and second is whether a package can be in
> another package. Also, I don't know why you need to aut
On Mon, Jan 4, 2010 at 10:40 AM, Arthur Fuller wrote:
> The ProductPackages table is what is known as an associate table, and is
> used to implement a many-to-many relationship. You only need it if a given
> product can be in multiple packages. If not, then you can eliminate the
> associative tabl
arge', 'XXXLarge')",
colorsShadesNumbersShort="('aqua:7FFFD4', 'blue:99', 'gray:465945',
'navy-blue:CC7722', 'black:FF', 'maroon:B03060', 'purple:50404D',
'yellow:9ACD32', 'fuchsia:FF77FF')" where ID="2";
Everything inserts but the sets which throw warnings. What am I missing?
TIA,
Victor
--
The Logos has come to bear
http://logos.13gems.com/
; colorsShadesNumbersShort='aqua:7FFFD4, blue:99, gray:465945,
> navy-blue:CC7722, black:FF, maroon:B03060,
> purple:50404D,yellow:9ACD32, fuchsia:FF77FF'
> where ID="2";
>
> watch for the line-wraps in the SET data specifications.. I did both
>
On Wed, Jan 6, 2010 at 12:14 PM, Michael Dykman wrote:
> so you dropped the quotes around the unneccessarily bracketed
> expression? It's hard to diagnose when your example isn't even what
> you think is syntactically correct.
>
Here's my example again. Syntactically correct. From my original p
On Wed, Jan 6, 2010 at 2:18 PM, Hassan Schroeder wrote:
> On Wed, Jan 6, 2010 at 11:39 AM, Victor Subervi
> wrote:
>
> > Here's my example again. Syntactically correct. From my original post:
> >
> > update products set SKU="prodSKU2", Category=&
On Wed, Jan 6, 2010 at 2:34 PM, Hassan Schroeder wrote:
> On Wed, Jan 6, 2010 at 1:25 PM, Victor Subervi
> wrote:
>
> > mysql> update products set SKU="prodSKU2", Category="prodCat1",
> > Name="name2", Title="title2", Descripti
On Wed, Jan 6, 2010 at 2:40 PM, Michael Dykman wrote:
> How about you show us the schema for the table so we know what is
> defined as what?
>
Done in last email.
>
> Also, as the update does succeed, it would be interesting to see what
> value actually got stored. After you have accounted for
OK, guys, I'm totally confused:
mysql> insert into products (SKU, Category, Name, Title, Description, Price,
SortFactor, Availability, OutOfStock, Weight, ShipFlatFee, ShipPercentPrice,
ShipPercentWeight, sizes, colorsShadesNumbersShort) values ("prodSKU1",
"prodCat1", "name1", "title1", "descr",
On Fri, Jan 8, 2010 at 2:26 AM, Thiyaghu CK wrote:
> Hi Victor,
>
> You have given space after the comma(shown here: ('Small, Medium,
> XSmall')). Take out the space and try, it will work.
>
> Example:
>
> mysql> insert into products(sizes) values ('Smal
On Fri, Jan 8, 2010 at 9:29 AM, Thiyaghu CK wrote:
> Hi Victor,
>
> Take out the double quotes from[ "('Small,Medium,XSmall')",
> "('teal_E2725B,black_FF,yellow_9ACD32')"]. Its working fine for me.
>
> mysql> insert into produ
Hi;
I have a shopping cart that will spawn a tmp table for every shopping cart
instance. Would it be better to create a separate database for these instead
of having them in the same database as all the other tables for the shopping
cart?
TIA,
Victor
--
The Logos has come to bear
http://logos
On Mon, Jan 11, 2010 at 10:35 AM, Baron Schwartz wrote:
> Victor,
>
> On Sun, Jan 10, 2010 at 1:20 PM, Victor Subervi
> wrote:
> > Hi;
> > I have a shopping cart that will spawn a tmp table for every shopping
> cart
> > instance. Would it be better to cre
On Mon, Jan 11, 2010 at 10:49 AM, Baron Schwartz wrote:
> Victor,
>
> > That strikes me as messy. Each tmp table has as many rows as necessary
> for
> > the products that are to be bough. To do as you say I would have to
> create a
> > table with a zillion ro
On Mon, Jan 11, 2010 at 11:38 AM, Keith Murphy wrote:
> Victor,
>
> Don't want to butt in, and not trying to be rude, but he gave you advice.
> You don't seem inclined to take it. How else can he, or anyone else, help
> you? Clearly you don't understand some fund
On Mon, Jan 11, 2010 at 3:21 PM, mos wrote:
> At 09:56 AM 1/11/2010, Johnny Withers wrote:
>
>> Victor,
>>
>> The temporary table solution is not a good one. Use a single table and
>> store
>> each item put into a cart identified by the session ID of the user
On Wed, Jan 13, 2010 at 2:33 PM, Johnny Withers wrote:
> No one designs a shopping cart system this way.
>
> http://www.google.com/search?q=shopping+cart+database+table+design
>
> If you are dead set on this crazy design it doesn't matter if you put the
> temp tables in the main database or anothe
On Thu, Jan 14, 2010 at 1:35 AM, Chris W <4rfv...@cox.net> wrote:
> I think the reason the other poster was so harsh is because others have
> suggested the right way to do it, if not in a lot of detail, and you have
> just argued with them.
>
I don't recall anyone doing that. I don't recall argui
||
| weight | tinyint(3) | YES | | NULL||
++--+--+-+-++
3 rows in set (0.01 sec)
So, why didn't the foreign key get created? It exists as a primary key in
Customers. Please advise.
TIA,
Victor
light/Passengers.frm' (errno:
150)
So apparently it didn't like my foreign key. Do I need to do something with
the table I'm referencing or what?
TIA,
V
>
>
> On Tue, May 18, 2010 at 3:44 PM, Victor Subervi
> wrote:
>
>> Hi;
>> mysql> create table if not
On Tue, May 18, 2010 at 1:09 PM, Shawn Green wrote:
> Johan De Meersman wrote:
>
> For additional details about failed FK attempts, check the error details in
> the SHOW INNODB STATUS report.
>
I get this:
100518 10:26:22 Error in foreign key constraint of table
seaflight/Passengers:
constrain
On Tue, May 18, 2010 at 2:23 PM, Shawn Green wrote:
> Shawn Green wrote:
> I may be confused but how can the ID of the Passengers table be both the ID
> of the Flight they are taking and their Customer ID at the same time?
>
> http://dev.mysql.com/doc/refman/5.1/en/innodb-foreign-key-constraints.h
On Wed, May 19, 2010 at 10:59 AM, Shawn Green wrote:
> Shawn Green wrote:
>
> AH! that's your mistake. You think that creating the FK will also create
> the column. That does not happen. You have to define the table completely
> before you can associate the columns on this table (the child table)
On Wed, May 19, 2010 at 12:02 PM, Shawn Green wrote:
> Victor Subervi wrote:
>
>> On Wed, May 19, 2010 at 10:59 AM, Shawn Green > >wrote:
>>
>> Shawn Green wrote:
>>
>>
> look again closely at your FK definitions. The pattern should be
>>
light/Baggage`, CONSTRAINT `Baggage_ibfk_2`
FOREIGN KEY (`customer_id`) REFERENCES `Customers` (`id`))')
However, when I try from the MySQL prompt after duly printing it out from
the code, it works. Why?
TIA,
Victor
I'm canceling this thread. It belongs in the Python list. Sorry!
V
On Fri, May 21, 2010 at 1:24 PM, Victor Subervi wrote:
> Hi;
> When I try to execute this code from my Python script, I get this error:
>
> Traceback (most recent call last):
> File
> "/var/www/
This is just for the sake of future googlers of this thread. The correct
mysql command is:
ursor.execute('create table if not exists Passengers (id int(11)
auto_increment primary key, flights_id int(11) not null, customer_id int(11)
not null, foreign key (flights_id) references Flights (id), forei
| int(11) | NO | | NULL||
+-+-+--+-+-++
5 rows in set (0.00 sec)
Please advise how to alter Flights to take the foreign key.
TIA,
Victor
Problem solved. I tried everything that *should* have worked and didn't.
Then I just wiped the test database and started with everything *fixed* (all
engine=innodb, all keys of same type, etc.) and it all worked.
V
On Tue, Jun 22, 2010 at 11:53 AM, jayabharath wrote:
> Hi Victor,
>
> The actual problem is with the key field.
>
> Flights.pilot_id is set to INT NOT NULL and you had specified Pilots.id to
> INT NULL.
>
> You have to change both the columns to NULL or else NOT N
n two
fields. How do?
TIA,
Victor
2010/6/29 João Cândido de Souza Neto
> As far as I know, if you have an auto_increment primary key, you cant have
> any other field in its primary key.
>
Makes sense. Actually, I was just copying what someone else gave me and
adding the auto_increment, then I got to wondering, what is the purp
2010/6/29 João Cândido de Souza Neto
> I think the best, or may be the right way is to use picture_id as primary
> key and a unique index to product_sku.
>
Yes, sounds good. So the purpose, then, is to speed lookups on fields
commonly accessed. I'd forgotten that.
Thanks,
V
ke to create the equivalent of an enum in which I could
utilize data like that. Of course, I could lump the whole key-value pairs
into one data and create an enum like that, then parse them later. I'm just
wondering if there's a more elegant way to do this.
TIA,
Victor
) | NO | | NULL
||
+---+--+--+-+++
13 rows in set (0.00 sec)
How drop it?
TIA,
Victor
e.
How?
TIA,
V
>
> Regards
>
> John Daisley
>
> Microsoft SQL Server 2005/2008 Database Administrator
> Certified MySQL 5 Database Administrator
> Certified MySQL 5 Developer
> Cognos BI Developer
>
> Telephone: +44 (0)7918 621621
> Email: john.dais...@butterflysyste
1 - 100 of 732 matches
Mail list logo
