Hi,
I have been backing up via the dubious method of copying the database data folder onto
another machine where it is properly backed up onto DLT.
(yes, I know I should have used mysqldump!)
Recovering some tables today I copied the files back into their position (including the ibdata1 file and
Hi,
Is it possible to obtain the last_insert_id() for a particular column in
a particular table?
eg, say i wanted to obtain the last insert id of a column called id in
table reference, something along the lines of:
last_insert_id(reference.id)
The reason I ask is because I want to initially in
whoops, yes, thanks, missed that
Victor Pendleton wrote:
One thing that stands out is the data types are different sizes.
http://www.mysql.com/doc/en/InnoDB_foreign_key_constraints.html
-Original Message-
From: R.Dobson [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 24, 2003 8:42
Hi,
I have two innodb tables produced as show below
CREATE TABLE `monogenic` (
`id` smallint(5) unsigned NOT NULL default '0',
`exp_design` varchar(50) default NULL,
`disease` varchar(50) default NULL,
`omim` varchar(20) default NULL,
`phenotype_ID` smallint(5) unsigned NOT NULL default '0',
the name and
gene tables? would it not be better to have a gene_id column in name,
put an index on it, and then issue:
"alter table name add foreign key(gene_id) references gene(id) on delete
cascade;"
In fact, I'm not sure you can actually create the constraint as you
currently desc
Hi, I have a db where I have converted all the tables innodb. I have 2 tables in particular called gene and name.
They both have a primary key call id. I want the primary key from name to be deleted when the corresponding key is deleted from gene.
It doesn't seem to be happening as yet!
show col
Hi, i'm using Distrib 4.0.1-alpha, for sun-solaris2.8 (sparc)
Victoria Reznichenko wrote:
"R.Dobson" <[EMAIL PROTECTED]> wrote:
mmm, i've just tried the example within the mysql docs:
CREATE TABLE parent(id INT NOT NULL, PRIMARY KEY (id)) TYPE=INNODB;
CREATE TABLE c
| InnoDB free:
55296 kB |
+--+++--++-+-+--+---++-+-+++---+
1 row in set (0.00 sec)
cheers
Rich
Egor Egorov wrote:
&q
hi,
2 ways to do this:
a) don't store the file actually in the db but store the path to it.
b)use the function LOAD_FILE(filename) to get the contents of a file as
a string value and store as a blob.
decide which to use depending on how many pics you have
cheers
Rich
toby gibbson wrote:
>
to load files into mysql:
create a table:
create table newtable (column1 int(10),column2 varchar(250));
import the data:
load data infile '/path/to/file/file.csv' into table newtable
fields terminated by ',' lines terminated by '\n'
Alia Mikati wrote:
>Hello everybody
>I hope u can help me
hi ,if you're on windows I would use mysqlfront. It has been
discontinued but you can still get it from:
http://mysqlfront.sstienemann.de/
alternatively, you could use urSQL:
http://www.urbanresearch.com/software/utils/urbsql/
cheers
Rich
David Kramer wrote:
>Can anyone point me in the d
Hi,
the latest version of mysql supports ssl connections.
'phpMyAdmin' is a browser based gui written in php. If your apache has
mod_ssl then you could connect securely.
http://www.phpwizard.net/projects/phpMyAdmin/
Alternatively, you could also use something like 'mysqlgui' and set up
ssh
create temporary table tmp
SELECT IndustryID FROM
Company_Industries CI WHERE CI.CompanyID = C.CompanyID;
SELECT
U.UserID
FROM
Transaction_Data T, Rfq_Data R ,Company C
WHERE
T.TransactionID = R.TransactionID AND
(R.Industryid=1 or R.IndustryID=tmp.IndustryID)
Cheers
Rich
Arul w
> Hi,
>
> select table1.col_name FROM table1 left join table2
> on table1.col_name = table2.colnmae where table2.clnmae is null
>
> Rich
> Inbal Ovadia wrote:
>
>> Hi
>> i want to do in mysql query like that:
>>
>> SELECT col_name FROM table1 NOT IN (select col_nmae FROM tablse2)
>>
>> how can i
erface language: there is only one command which
>returns a result set for processing, and that is the final result. This
>approach does require additional logic to extend to more than the top two
>scores, which requires another pair of SQL statements per result. If you are
>looking for ord
Hi,
thanks for all of the replies to my query.
I'm not sure that I explained my problem very well as the solutions
received are solutions to the problem I described, but not the one I
meant :-) (I don't think anyway)
I have a table in the format:
family | member | score
-
Hi,
I have a table containing data on a number of families.
I want to retrieve members of each family that have the two highest
scoring values for a column. i.e the max and second max.
Is there a function similar to max() or greatest() that will return the
top 2 values when grouping by family I
17 matches
Mail list logo
