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 prep
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'
27;t know what you mean. Sorry.
> Thanks.
> PS. plese CC me directly since for some reason the
> messages from the list are taking a while to get in my mailbox.
Done!
--
__
/ \\ @ __ __@ Adolfo Bello <[EMAIL PROTECTED]>
electing 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
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 mysq
>Services->mysql->start?
--
__
/ \\ @ __ __@ Adolfo Bello <[EMAIL PROTECTED]>
/ // // /\ / \\ // \ // Bello Ingenieria S.A, ICQ: 65910258
/ \\ // / \\ / // // / //cel: +58 416 609-6213
/___// // / <_/ \__\\ //__/ //
ND
Replace above line with:
(evtphoto.phtusage = 1 OR nophoto.phtusage IS NULL) AND
> evtstorysection.secid = 3 AND
> evtstoryorder.secid = 3 AND
> evtstoryorder.stodate = '2003-01-24' AND
> evtstory.stypubdate <= '2003-01-24' AND
&g
On Wed, 2003-01-22 at 00:31, Lane Johnston wrote:
> $query = "SELECT * FROM books WHERE ".$searchType." LIKE
> '%".$searchTerm."%'";
echo $query;
It might help seeing query syntax.
__
/ \\ @ _
ant? If
so, then the result must be empty.
I guess you will need a TEMP table.
HTH
--
__
/ \\ @ __ __@ Adolfo Bello <[EMAIL PROTECTED]>
/ // // /\ / \\ // \ // Bello Ingenieria S.A, ICQ: 65910258
/ \\ // / \\ / //
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 arithmet
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 kn
e tool is not called/used, then that date
will not be in the master table. In this case a LEFT JOIN won't help.
__
/ \\ @ ____@ Adolfo Bello <[EMAIL PROTECTED]>
/ // // /\ / \\ // \ // Bello Ingenieria S.A. / ICQ: 65910258
/ \\ // / \\/ // // / //
But I realized this is all wrong cause the same cell cannot be both Joe and
> Bill =)
>
> mysql query smallint
HTH
__
/ \\ @ ____@ Adolfo Bello <[EMAIL PROTECTED]>
/ // // /\ / \\ // \ // Bello Ingenieria S.A, Presidente
/ \\ // / \\/ // // / //ce
wbie?
I use with Apache and it is faily easy. Just remember 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]&
> Mark
Have you granted permissions to [EMAIL PROTECTED]?
sql, query
__
/ \\ @ ____@ Adolfo Bello <[EMAIL PROTECTED]>
/ // // /\ / \\ // \ // Bello Ingenieria S.A, Presidente
/ \\ // / \\/ // // / //cel: +58 416 609-6213
/___ / <_/\__\\//__/ // f
't forget the "flush privileges" thing after the update command.
> __
>/ \\ @ ____@ Adolfo Bello <[EMAIL PROTECTED]>
> / // // /\ / \\ // \ // Bello Ingenieria S.A, Presidente
> / \\ // / \\/ // // / //cel: +58 416 609-6213
> /___ / <_/\__\\/
you 100%.
A foreign key,as its name implies, should create automatically a key.
I would it is a wanted feature.
__
/ \\ @ ____@ Adolfo Bello <[EMAIL PROTECTED]>
/ // // /\ / \\ // \ // Bello Ingenieria S.A, Presidente
/ \\ // / \\/ //
pty. Doesn't this violate the NOT NULL
> >>constraint on the field?
> >>
> Well, by empty you probably mean "", which is not null, is it?
This is wierd. If you define a field as not null is because you want the
user to enter some data, for example, First Name and
> 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 l
> 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
Ado
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 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" co
> 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 p
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/
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/
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`
GRO
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-1
> -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
> >
> >>
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
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 thro
>
> table meals(
> m_id primary,
> m_name,
> m_ingredients, # a comma separated list of ingredient ID's in a text field
> )
>
> table ingredients(
> as above
> )
>
> so then you can read in a list of ingredient id's for each recipe, then
> '
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
>
>
>
>
> ---
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
> -
> -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
e website.
>
> All My Best,
> Jeffrey
>
>
> on 12/21/02 2:02 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 tab
ff into a temp file or something and
> running the results using PHP? I really don't know what direction to
> take, but I do see what appears to be a lot of repeating work, with only
> little changes in time chunks.
>
> Should I perhaps create a 'date' field, grabbing only Y
t don't know how to create one
> now. :(
>
> 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
>
(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]>
gt;
>
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php (the manual)
>http://lists.mysql.com/ (the list archive)
>
> To request this thread, e
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: Ri
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?
>
>
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
HATSUP | 172.173.81 |
> | [EMAIL PROTECTED] | 80.143.42 |
> | xmartyx | 68.5.149|
> | xym180| 216.41.132 |
> | zook10| 213.89.57 |
> +-----
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/
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 p
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 GROUP
-
> Before posting, please check:
>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]>
> Troub
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 Abdelkh
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
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
>
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 m
> Sent: 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
&g
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
> ?
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
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 Harr
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
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 Mess
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
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 My
> 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 fo
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 h
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 S
> Mysql 4.0.5
>
>
> Adolfo,
>
> - 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
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 = = =
CRE
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
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 li
ther table so you don't have any limit 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: A
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 in
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 Wi
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 instal
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) O
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
>
>
>
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:
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(
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,
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 P
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 w
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 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
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 PROTECTE
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 th
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) referen
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
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 exampl
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: Se
> -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
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-
From:
tp://lists.mysql.com/php/unsubscribe.php
--
___
// \\ @ ___ ___@
// // // /\ / \\ // \ // Adolfo Bello
<[EMAIL PROTECTED]>
// \\ // / \\ / // // / //Bello Ingenieria S.A, Presidente
//___// // / <_/ \___\\ //___/ // cel: +58 416 609-6213
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
89 matches
Mail list logo
