Hi list:
I don't know if this the right forum to ask the following questions:
Will MySQL production version 5.0 support grant in prepared statements?
The yet part is encouraging in ERROR 1295 (HY000) at line 17: This
command is not supported in the prepared statement protocol yet
Will
I am using Mandrake 10, MySQL 4.1.5 from RPM downloaded from
dev.mysql.com.
Look at this session:
$ mysql -u root -p permarn
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 4 to server version: 4.1.5-gamma-standard
Type 'help;' or '\h'
since for some reason the
messages from the list are taking a while to get in my mailbox.
Done!
--
__
/ \\ @ __ __@ Adolfo Bello [EMAIL PROTECTED]
/ // // /\ / \\ // \ // Bello Ingenieria S.A, ICQ: 65910258
the last 5 rows for instance? Can this be done?
SELECT * FROM blah-blah ORDER BY whatever DESC LIMIT 0,5
--
__
/ \\ @ __ __@ Adolfo Bello [EMAIL PROTECTED]
/ // // /\ / \\ // \ // Bello Ingenieria S.A, ICQ: 65910258
On Mon, 2003-01-27 at 11:23, Pedro Leite wrote:
Hi, I'm getting the same error message. mysql here is in /etc/rc.d/init.d,
don't ask me why, I'm new to this things.
Any more help would be much appreciated.
TIA
That's the directory where it should be.
You can also start with
service mysql
?
--
__
/ \\ @ __ __@ Adolfo Bello [EMAIL PROTECTED]
/ // // /\ / \\ // \ // Bello Ingenieria S.A, ICQ: 65910258
/ \\ // / \\ / // // / //cel: +58 416 609-6213
/___// // / _/ \__\\ //__/ // fax: +58 212 952-6797
www.bisapi.com
' AND
evtstory.stypubdate = '2003-01-24' AND
evtstory.styexpdate '2003-01-24'
ORDER BY
evtstoryorder.stoorder
__
/ \\ @ __ __@ Adolfo Bello [EMAIL PROTECTED]
/ // // /\ / \\ // \ // Bello Ingenieria S.A, ICQ: 65910258
--
__
/ \\ @ __ __@ Adolfo Bello [EMAIL PROTECTED]
/ // // /\ / \\ // \ // Bello Ingenieria S.A, ICQ: 65910258
/ \\ // / \\ / // // / //cel: +58 416 609-6213
/___// // / _/ \__\\ //__/ // fax: +58 212 952-6797
www.bisapi.com
.
__
/ \\ @ ____@ Adolfo Bello [EMAIL PROTECTED]
/ // // /\ / \\ // \ // Bello Ingenieria S.A. / ICQ: 65910258
/ \\ // / \\/ // // / //cel: +58 416 609-6213
/___ / _/\__\\//__/ // fax: +58 212 952-6797
www.bisapi.com //pager: www.tun
On Sun, 2003-01-19 at 14:48, M A wrote:
HI
i am new to mysql.. i have just installed the source code under
/user/local/mysql
but the commnads don't work unless i have ./ infront of the command
for example: mysqladmin won't work unless its written ./mysqladmin.
please let me know if i am
On Sun, 2003-01-19 at 19:09, Nasser Ossareh wrote:
Isn't there a typo somewhere...
Shouldn't you expect 5 instead of -5 (15 - id where id = 10)??
Nevermind, let's assume that there is a typo somewhere and the correct expected
value is -5... however, in the domain of unsigned arithmetics
, query
__
/ \\ @ ____@ Adolfo Bello [EMAIL PROTECTED]
/ // // /\ / \\ // \ // Bello Ingenieria S.A, Presidente
/ \\ // / \\/ // // / //cel: +58 416 609-6213
/___ / _/\__\\//__/ // fax: +58 212 952-6797
www.bisapi.com //pager: www.tun-tun.com
the virtual host
stuff and modify you /etc/hosts if you are going to use it locally.
thanks for any help.
Will
HTH
sql, query
__
/ \\ @ ____@ Adolfo Bello [EMAIL PROTECTED]
/ // // /\ / \\ // \ // Bello Ingenieria S.A, Presidente
/ \\ // / \\/ // // / //cel: +58
__
/ \\ @ ____@ Adolfo Bello [EMAIL PROTECTED]
/ // // /\ / \\ // \ // Bello Ingenieria S.A, Presidente
/ \\ // / \\/ // // / //cel: +58 416 609-6213
/___ / _/\__\\//__/ // fax: +58 212 952-6797
www.bisapi.com //pager: www.tun-tun.com (# 609-6213
you can do this:
mysql set password for newsletter@localhost=PASSWORD(testPass);
or
mysql update user Set Password=Password(testPass)
- where user=newsletter;
Don't forget the flush privileges thing after the update command.
__
/ \\ @ ____@ Adolfo Bello
Does MySQL allow using foreign keys or not?
It does. Try it by yourself with version 4.0.8 +.
Adolfo
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the
the
user to enter some data, for example, First Name and Last Name. Yes, I
know one should check it at the application level but, isn't MySQL being
a little too flexible with this?
__
/ \\ @ ____@ Adolfo Bello [EMAIL PROTECTED]
/ // // /\ / \\ // \ // Bello Ingenieria S.A
name implies, should create automatically a key.
I would it is a wanted feature.
__
/ \\ @ ____@ Adolfo Bello [EMAIL PROTECTED]
/ // // /\ / \\ // \ // Bello Ingenieria S.A, Presidente
/ \\ // / \\/ // // / //cel: +58 416 609-6213
As far as I know and how I understand it, the relationships are basically all
in your head... You just have to coordinate it in your queries and other functions
This is not true. Fot type innodb tables, you can define REFERENCES
using ON DELETE (CASCADE|RESTRICT) and/or ON UPDATE CASCADE
I have two tables whose structures are below.
- Table1 -
table1id int not null auto_increment
data varchar(30)
- Table2 -
table2id int not null auto_increment
table1id int not null
data varchar(30)
These two tables are connected to each other with the
table1id column. I need to
On Wed, 2003-01-08 at 15:30, Dejan Milenkovic wrote:
Hi,
Is there a difference in speed between these two querys:
SELECT whatever, somethin_else FROM table1 WHERE 1 AND (
table1.whatever='value' OR )
SELECT whatever, somethin_else FROM table1 WHERE table1.whatever='value'
OR ...
I have multiple SQL files that create different tables.
Is there a way for me to create a single SQL file that will
call these
other files?
Since I am using phpMyAdmin, I am assuming that call this file from
phpMyAdmin?!
Since phpMyAdmin is a HTTP interfase, I don't think it is
It sounds to me that a trigger would help, but mysql doesn't has them
yet.
Adolfo
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 03, 2003 8:04 PM
To: Kevin; [EMAIL PROTECTED]
Subject: Re: auto increment question
At 15:28 -0800 1/3/03,
It sounds to me that a trigger would help, but mysql doesn't has them
yet.
Adolfo
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 03, 2003 8:04 PM
To: Kevin; [EMAIL PROTECTED]
Subject: Re: auto increment question
At 15:28 -0800 1/3/03,
By looking at your query and table description, I guess you can try
something like:
SELECT cus.`Code` AS `Customer Code`,
cus.`Name` AS `Customer`,SUM((1-bil.direction)*bil.Total) AS Loan,
SUM(bil.direction*bil.Total) AS Credit
FROM customer AS cus,
bill AS bil
WHERE bil.`Customer` = cus.`ID`
I would try storing the SHA1() result as a hexadecimal string.
Adolfo
-Original Message-
From: Benjamin Pflugmann [mailto:[EMAIL PROTECTED]]
Sent: Sunday, December 29, 2002 7:35 AM
To: Philip Mak
Cc: [EMAIL PROTECTED]
Subject: Re: Storing a SHA1 checksum
On Sun 2002-12-29 at
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]]
Sent: Saturday, December 28, 2002 6:44 PM
To: Gloria L. McMillan; [EMAIL PROTECTED]
Subject: Re: SELECT query
At 14:38 -0700 12/28/02, Gloria L. McMillan wrote:
RE: MySQL SELECT and COUNT or SUM
Hi, all!
service mysql start
Search the list for more information
Adolfo
On Tue, 2002-12-24 at 09:07, Amitié Plus wrote:
Hello,
I'm a beginner with mysql and i installed it with linux.
I'm getting this message when i tried to be connected :
Error 2002 : can't connect to local MySQL server through
On Tue, 2002-12-24 at 12:11, [EMAIL PROTECTED] wrote:
I wish to get a count of records contained in 1 table as compared to the
contents of a different table. What I have is a list of realtors in 1
table (agents.name) The listings are contained in a different table
(listings) and each can be
-Original Message-
From: Ricardo Fitzgerald [mailto:[EMAIL PROTECTED]]
Sent: Sunday, December 22, 2002 11:22 AM
To: [EMAIL PROTECTED]
Subject: Help with database Design
create table recipes(
rid int not null primary key,
rname ) ;
create table ingredient(
iid int not null,
Create 2 tables with identical columns definition, one with index and
the other without.
Start adding records to the two tables and querying them.
This way you'll find out the number of recors for which the performance
is about the same. After that, you can decide wich way to go.
Adolfo
service mysql start
-Original Message-
From: bruno peracchio [mailto:[EMAIL PROTECTED]]
Sent: Sunday, December 22, 2002 12:41 PM
To: mysql-list
Subject: mysql.sock
Hi
how can I do to restore mysql.sock?
Thank in advance
PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--
Adolfo Bello [EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php
Is mysql service started?
Check with:
ps -ax mysql | grep -i mysql
If it does't appear on tje list, start the service with:
service mysql start
Adolfo
P.S. I have mysql.sock in /var/lib/mysql which is the default. Check
also basedir in your /etc/my.cnf.
-Original Message-
From:
:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--
Adolfo Bello [EMAIL
:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--
Adolfo Bello [EMAIL
. :(
The second is that the command will -- I think -- place the last name right
up against the first name with no space before. Is there a way to do that so
it looks like Foo Bar?
All My Best,
Jeffrey
on 12/21/02 1:23 PM, Adolfo Bello at [EMAIL PROTECTED] wrote:
The following query adds NAME
' field, grabbing only MMDD and
working from there? What am I not thinking about here?
Any suggestions are very much welcome.
--
Adolfo Bello [EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com
PM, Adolfo Bello at [EMAIL PROTECTED] wrote:
CONCAT(FullName,' ',Address)
regarding the lack of an ID field, create a new table with all the
fields from the original table plus an ID field, auto_numeric, and
insert the registers from the old table to the new one. Then, use the
UPDATE
SELECT * FROM t1,t2,t3 WHERE t1.img_id=t2.img_id AND
t2.caption_id=t3.caption_id
Adolfo
-Original Message-
From: mike [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 19, 2002 8:15 PM
To: [EMAIL PROTECTED]
Subject: Help w/ Join Query
Hello,
I working on a small my
Missing TYPE=INNODB in create table statement.
MySQL parses references for type MyISAM but doesn't use them.
Adolfo
-Original Message-
From: Jeff Snoxell [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 20, 2002 1:14 PM
To: [EMAIL PROTECTED]
Subject: CREATE TABLE issue?
Hi
select * from your_table order by no desc limit 0,1
-Original Message-
From: mustakim abas [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 19, 2002 12:07 PM
To: [EMAIL PROTECTED]
Subject: help me, please
Hello, i am new in mysql. I got a problem. I try write
my C program
There is not link to download the Windows version.
Any date for the Windows version to be published?
sql, query
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--
Adolfo Bello [EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http
Hi Gigi:
I got a 2 steps solution to your problem:
1.- Create a TEMPORARY TABLE with
CREATE TEMPORARY TABLE anyname SELECT
t1.id,t1.description,SUM(t2.quantities) AS Purchases,t3.quantities FROM
products t1 INNER JOIN purchases t2 ON t1.id=t2.id INNER JOIN sellings
t3 ON t1.id=t3.id
Try this:
SELECT t1.id AS prod_id, t1.description AS
Description,SUM(t2.quantities) AS Purchases,
SUM(t3.quantities) AS Sellings, (Purchases-Sellings) AS Inventory
FROM Products t1 INNER JOIN Purchases t2 ON t1.id=t2.prod_id
INNER JOIN Sellings t3 ON t1.id=t3.prod_id
GROUP BY t1.id,t1.description
I guess your question is more about configuring IIS (or PWS) than about
MySQL.
Anyway, you have to create a web site in IIS pointing to your phpMyAdmin
directory and define in it the default document (index.html. default.php
or whatever)
Adolfo
-Original Message-
From: Rachid
)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--
Adolfo Bello [EMAIL PROTECTED
SELECT a.Name,b.Name,c.Name FROM your_table a LEFT OUTER JOIN your_table
b
ON a.Code=b.ParentFemale LEFT OUTER JOIN your_table c
ON a.Code=c.ParentMale
-Original Message-
From: Fam. Tarniceru [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 13, 2002 3:39 PM
To: MySQL Mailing List
Not until version 4.1
-Original Message-
From: Peter Vertes [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 13, 2002 8:43 AM
To: MySQL Help List (E-mail)
Subject: Nested MySQL Statements
Hello All,
Is it possible to do nested select statements with MySQL
? Basically
: Saturday, December 14, 2002 9:16 AM
To: Adolfo Bello; [EMAIL PROTECTED]
Subject: RE: BEGINNER: in mysql, better to do 1 table for one
relationship, even with a one to one relation ?
Hello,
I've tried your way, but my SQL reports error, that I have
specified more than ONE primary key, so I
Using the ALTER statement:
Step 1.- DROP the primary key
Step 2.- ADD the new primary key
Adolfo
-Original Message-
From: Alliax [mailto:[EMAIL PROTECTED]]
Sent: Saturday, December 14, 2002 9:54 AM
To: Adolfo Bello; [EMAIL PROTECTED]
Subject: RE: BEGINNER: in mysql, better to do 1
After loging in mysql as root, enter the command:
SET PASSWORD FOR root=password('the_new_password');
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]
Sent: Saturday, December 14, 2002 5:07 PM
To: [EMAIL PROTECTED]
Subject: Root user password changing
You´re missing the GROUP BY clause
select a.domain, a.transport, sum(c.recipient_count)
sum(c.recipient_size) from transport as a, acl as b,
recipientstats as c where a.id=b.transportId and
b.adminId='1' and c.recipient_email like '%a.domain'
GROUP BY a.domain,a.transport;
-Original
I would really prefer a little variation of the third way you mention:
1) table person personID primary int 11 autoincrement
2) table car carID primary int 11 autoincrement
3) table relation_person_car
personID int 11
carID int 11
PRIMARY KEY (personID,carID)
Adolfo
-Original
I would suggest having
EmpTable (PRIMARY KEY=empID)
EventsTable (PRIMARY KEY=eventID)
AttendantsTable (PRIMARY KEY=[empID,eventID])
From there you can build queries to find persons who attended an event
or which events a person went to.
Adolfo
-Original Message-
From: Brad
SELECT * FROM your_table WHERE your_number_field REGEXP \.
-Original Message-
From: Beauford.2003 [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 12, 2002 3:26 AM
To: [EMAIL PROTECTED]
Subject: Displaying output from MySQL
Hi,
Not sure if this is a PHP of a MySQL
SELECT n.uid, n.name from names_tables n LEFT OUTER JOIN exclude
ON n.uid = exclude.n_uid WHERE exclude.n_uid IS NULL
-Original Message-
From: Michelle de Beer [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 11, 2002 3:22 PM
To: mysql list
Subject: Select Where !=
I have
SELECT ... WHERE Category 'others'
UNION
SELECT ... WHERE Category='others'
-Original Message-
From: Tariq Murtaza [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 10, 2002 7:12 AM
To: Fred van Engen
Cc: [EMAIL PROTECTED]
Subject: Re: Select and Sort?
Thanks for help.
1 - On a Linux/Apache box,
when you create a MySQL db with tables, etc,
Where does MySQL store the files associated with the
db?
Generally, /var/lib/mysql. Check your my.cnf
2 - On subsiquent db's, does MySQL store those files
in the same directory or each db in a seperate folder?
SELECT * FROM table1 t1 LEFT OUTER JOIN table2 t2 ON t1.field1=t2.field2
WHERE t2.field2 IS NULL
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]] On Behalf Of Murad Nayal
Sent: Monday, December 09, 2002 11:38 AM
To: MySQL List
Subject: help on NOT EXISTS SQL
,
- Original Message -
From: Adolfo Bello [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Sunday, December 08, 2002 12:47 AM
Subject: May someone try this script under Mandrake 9 and Mysql 4.0.5
I have used a database creation script for months under 3.23.53a.
Now, I
Use the CONCAT function
Adolfo
-Original Message-
From: tag [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 06, 2002 3:57 AM
To: [EMAIL PROTECTED]
Subject: select question
HI,
I need to do a select query that can do the following:
select * from table where col1 like
drop table if exists your_table;
create your_table (...);
-Original Message-
From: Peter Abilla [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 04, 2002 1:12 PM
To: [EMAIL PROTECTED]
Subject: Drop, Create. . .help
I want to do the following:
1-If table x exists, then
I have used a database creation script for months under 3.23.53a.
Now, I want to upgrade to version 4.0.5 and the script doesn't work. The
first table is created but mysql complains with:
Error 1005 at line 10 Can't create table ./dbdir/tblbasestados.frm
(errno:150)
= = = SCRIPT TO TRY = = =
Taake a look a t /usr/share/mysql (or /usr/share/doc/mysql). You will
find some my.cnf templates in there.
Adolfo
-Original Message-
From: Vidiot [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 04, 2002 2:40 AM
To: MySQL mail list
Subject: No my.cnf - why?
I installed the
I will assume that your hosting service supports MySQL, which most of
them do.
Also, most of hosting services allow you to administer your database
using phpMyAdmin, in which you can create and drop databases and tables,
run SQL scripts, etc.
I will also recommend you to install Apache in your
En el mio tampoco, pero todo funciona OK. Mandrake 9 y MySQL 4.0.5
Adolfo
-Original Message-
From: Fernando Grijalba [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 04, 2002 11:21 AM
To: MySQL Help
Subject: RE: MySQL
En que sistema lo instalaste?
Yo hice la instalacion
on the number
of albums a song can belong to.
If you know the id of a song all you have to do is
Adolfo
-Original Message-
From: Beauford.2003 [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 05, 2002 3:42 PM
To: Adolfo Bello
Cc: [EMAIL PROTECTED]
Subject: Re: Table setup question
SELECT headline, count(*) AS HITS from your_table GROUP BY headline
-Original Message-
From: Michelle de Beer [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 03, 2002 8:27 AM
To: mysql list
Subject: Select and count duplicates
I have a column containing headlines. In this
select oi.id,oi.name, count(o.id) from orderid oi LEFT OUTER JOIN orders
o
ON o.order_id = oi.id group by oi.id,oi.name ;
-Original Message-
From: Charles Verge [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 03, 2002 11:53 AM
To: [EMAIL PROTECTED]
Subject: join count and 0
SELECT Table1.ID FROM Table1 LEFT OUTER JOIN Table2 ON
Table1.ID=Table2.ID
WHERE Table2.ID IS NULL;
-Original Message-
From: Henning Sittler [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 03, 2002 10:16 AM
To: 'mysql users'
Subject: MySQL: Select Not In Table
Just
Missing quotes. It should read:
sNewCallBackSQLINSERT INTO CallBacks
(LearnerID,CallDate,CallTime) VALUES (2113 , '01/01/2002' , '0:00')
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 03, 2002 9:41 AM
To: [EMAIL PROTECTED]; [EMAIL
SELECT * FROM processo_arquivos ORDER BY DATE DESC LIMIT 0,10
-Original Message-
From: Felipe Moreno - MAILING LISTS [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 03, 2002 1:42 PM
To: [EMAIL PROTECTED]
Subject: MySQL: Select HELP!
Importance: High
Hi List Users,
I
I have used a database creation script for months under 3.23.53a.
Now, I want to upgrade to version 4.0.5 and the script doesn't work.
The first table is created but mysql complains with:
Error 1005 at line 10 Can't create table ./dbdir/tblbasestados.frm
(errno:150)
CREATE TABLE tblbasregiones(
Php is widely used for web development, and works nicely with MySQL.
Fuerthermore, it is supported by most hosting services.
I recommend you to give it a try
Adolfo
-Original Message-
From: Colaluca, Brian [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 03, 2002 2:25 PM
To:
Check if mysql is started by entering
ps -ax | grep -i mysql
If not started try:
service mysql start
Adolfo
-Original Message-
From: Jeff Hollingshead [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 03, 2002 5:17 PM
To: [EMAIL PROTECTED]
Subject: mysql.sock error
at
MySQL supports using InnoDB tables.
CREATE TABLE customers (
num INT PRIMARY KEY,
Name VARCHAR(50) NOT NULL);
CREATE TABLE sales(
Product VARCHAR(15) NOT NULL,
Price DOUBLE NOT NULL,
Cust INT NOT NULL,
# PRIMARY KEY definition goes here,
INDEX (Cust),
FOREIGN KEY(Cust) REFERENCES customers(num)
SELECT @myvar := 1 ;
-Original Message-
From: Gerald Norman [mailto:[EMAIL PROTECTED]]
Sent: Sunday, December 01, 2002 10:37 PM
To: [EMAIL PROTECTED]
Subject: Converting Access to MySQL
I have an application that currently is using an Access
database and am
in the process
Try something like
CREATE TABLE album( ida int primary key , title varchar(n) not null ) ;
CREATE TABLE songs( ids intprimary key, song varchar(m) not null ) ;
CREATE TABLE albumsongs(
ida int not null,
ids int not null,
primary key(ida,ids),
foreign key(ida)
The other difference is that it works (BTW, a huge benefit)
Adolfo
-Original Message-
From: Beauford.2003 [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 02, 2002 11:24 AM
To: DL Neil; [EMAIL PROTECTED]
Subject: Re: Table setup question
DL,
OK, I get it now. I thought
Isn't this sort of impossible?
You are asking for something like a set which contains as an element
the set itself
WHERE fooId IN (fooId)
Adolfo
-Original Message-
From: Peter Abilla [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 02, 2002 1:43 PM
To: [EMAIL PROTECTED]
INSERT INTO your_table(fields_list) VALUES
(record_1),(record_2),...,(record_n);
-Original Message-
From: Ed Reed [mailto:[EMAIL PROTECTED]]
Sent: Saturday, November 30, 2002 3:47 PM
To: [EMAIL PROTECTED]
Subject: Multiple Inserts and updates
Can anyone give me an example of
SELECT t1.name AS Nomi, t2.name AS Propo
FROM award t0 INNER JOIN user t1 ON t0.nominee=t1.uid
INNER JOIN user t2 ON t0.proposer=t2.uid
-Original Message-
From: Michael Carter [mailto:[EMAIL PROTECTED]]
Sent: Saturday, November 30, 2002 11:51 AM
To: [EMAIL PROTECTED]
Subject:
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 25, 2002 9:51 AM
To: Mysql maillist
Subject: script
Hi All.
I have written a SQL script that should retrieve all the rows from a
table that match a value given as parameter by the
I am also a newbie so don't misunderstand my question. Is there any
performance or functionality reason to change mysql.sock location?
Adolfo
On Mon, 2002-11-11 at 14:37, Black, Kelly W [PCS] wrote:
You can do this in /etc/my.cnf
~K Black
-Original Message-
Every time I start or restart the PC, the MySQL service doesn't come up,
so we have to start it manually with the command service mysql start.
I am a really newbie to Linux (2 weeks using Mandrake 9). Using drakconf
I checked that the service was scheduled to start at boot time, which it
is. By
--
___
// \\ @ ___ ___@
// // // /\ / \\ // \ // Adolfo Bello
[EMAIL PROTECTED]
// \\ // / \\ / // // / //Bello Ingenieria S.A, Presidente
//___// // / _/ \___\\ //___/ // cel: +58 416 609-6213
// fax: +58 212 952-6797
http
88 matches
Mail list logo
