hi,
I run your code , but worked propertly. I suggested to check the table USERS ,
ROLES, is the column userid / roleid same data type (INT(10) UNSIGNED ) with
your userroles table ?
==
mysql> create table users (userid INT(10) UNSIGNE
This looks like much more of a python question than a MySQL question..
I'll reply offline.
- michael dykman
On Sun, Oct 4, 2009 at 2:04 PM, Victor Subervi wrote:
> Hi;
> I have the following python code:
> sql = 'insert into products values(%s, %s, %s, %s, %s, %s, %s, %s, %s,
> %s, %s, %s
What is the exact error you are getting?
John Daisley
MySQL & Cognos Contractor
Certified MySQL 5 Database Administrator (CMDBA)
Certified MySQL 5 Developer (CMDEV)
IBM Cognos BI Developer
Telephone +44 (0)7812 451238
Email j...@butterflysystems.co.uk
-Original Message-
From: Sharique
Hi,
I'm trying to create a table with 2 columns both are primary key
(combined) and both are foreign key as well. I'm getting error cannot
create table. Here is the sql
CREATE TABLE `userroles` (
`roleid` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`userid` INT(10) UNSIGNED NOT NULL DEF
Hi;
I have the following python code:
sql = '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, price, bedrooms, bathrooms, conditions, acreage, construction,
location, estate, address, furnished, pic1,
Thanks to Martin and John for their help!
Mark
On Sat, Oct 3, 2009 at 5:53 PM, Martin Gainty wrote:
> enforcing by username/password to the DB is your safest method
> and if you want to really be safe put ssh access onto the MySQL Server
>
> here is how to install SSH and MySQL onto Ubuntu
> h
Can anyone help me figure out the following issue surrounding MySQL and
phpMyAdmin:
I load phpMyAdmin ver3.2, log in, and create a new database. I see the
following warning at the bottom:
Your PHP MySQL library version 5.0.51a differs from your MySQL server
version 5.1.39. This may cause unpredict