OFF TOPIC
Remove space between '-p' and the password in you command line.
That isbash-2.05a$ mysql -uwcjporoot -pwc_jpo
/OFF TOPIC
- Original Message -
From: Egor Egorov [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, March 23, 2004 6:36 AM
Subject: Re: created user but
What result are you getting?
First off, I see that your HTML is possibly incorrect; should it be:
echo tdWarranty ID:/td\n;
th is a table header.
Second, if you are expecting a single result row, then you do not need the while()
loop. Do a
single fetch and display the result.
rick
People
/var/lib/mysql/mysql.sock is created when the mysql server starts. It disappears when
mysql shuts
down.
Did you provide access to the databases as root? Is there a password associated with
access? For
instance, how do you statr mysql from the command line: mysql -u root -ppassword
I am attempting to interface between a simple C program and MySQL client library, but
without luck.
I searched the MySQLforum archives to see if there was info specific to this problem.
While there
were other folks who had problems connecting C/C++ to MySQL, none of the issue were
similar to
I am attempting to interface between a simple C program and MySQL, but without luck.
I searched the MySQLforum archives to see if there was info specific to this problem.
While there
were other folks who had problems connecting C/C++ to MySQL, none of the issue were
similar to this,
that is
See my original post below prior to reading the next 4 lines..
In addition to what I tried below, I tried the following (with this result):
$ ld -lmysqlclient -o myprog myprog.o
ld: warning: cannot find entry symbol _start; defaulting to 08048208
/usr/lib/libmysqlclient.so: undefined reference to
SELECT name,birthday FROM mytable
-Original Message-
From: Chuck PUP Payne [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 08, 2002 10:49 AM
To: MySQL Mailing List (E-mail)
Subject: no subject
Ok, I know I am going to get yell about this but how can I do an SQL and
only show to fields
FieldID INT UNSIGNED DEFAULT '0' NOT NULL,
-Original Message-
From: Soheil Shaghaghi [mailto:[EMAIL PROTECTED]]
Sent: Sunday, April 07, 2002 11:10 PM
To: [EMAIL PROTECTED]
Subject: RE: Help with Tables Please
Thanks for the tip Dan,
I changed it, but it still gives me the same error.
First, I assume that the same value for userlevel may be used by multiple
users. That is, multiple users can have userlevel equal to 1 or equal to 2
or 3 or whatever. Therefore, you CANNOT use userlevel as PRIMARY KEY.
PRIMARY KEY is a UNIQUE identifier. Thus, I recommend that each user be
it worked for me:
mysql describe t_timesheet;
++---+--+-+-++
| Field | Type | Null | Key | Default | Extra |
++---+--+-+-++
| id | int(11) | | PRI | NULL|
Since you are writing out the file, you must select which character to
ESCAPE with. How would you expect mysql to choose?
-Original Message-
From: Cliff [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 04, 2002 11:46 PM
To: [EMAIL PROTECTED]
Subject: Escaped by 2 things?
Short and
No, this is NOT a bug.
According to the manual (you read it, right?), TIMESTAMP is created so that
when a record is UPDATEd or INSERTed, the time of the change is entered into
the record. If you want a date that does not changem use the DATE fiel
-Original Message-
From: Hihn Jason
:48 AM
To: 'Rick Emery'
Subject: RE: Problems with UPDATE in v3.23.49 (is this a bug)
Yes I did, but it is very long, and it was very long ago.
Could someone please explain to me why this was done? It seems more
confusing to do this than to not do this. Why when you can just say SET
field=NOW
-Original Message-
From: Phil Schwarzmann [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 05, 2002 4:02 PM
To: [EMAIL PROTECTED]
Subject: [PHP] MYSQL maximum query size?
Is there a maximum number of characters you can use in a query?
I have a giant query using the UPDATE command
delete from tableB;
INSERT INTO tableB SELECT * FROM tableeA;
see manual:
6.4.3.1 INSERT ... SELECT Syntax
INSERT [LOW_PRIORITY] [IGNORE] [INTO] tbl_name [(column list)] SELECT ...
-Original Message-
From: Graham Nichols [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 04, 2002 9:44 AM
SELECT * FROM mytable WHERE date_field now() id_field=ID ORDER BY
date_field DESC
-Original Message-
From: Anthony R. J. Ball [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 04, 2002 10:30 AM
To: [EMAIL PROTECTED]
Subject: Getting the most recent record per id before date X
I am
SELECT * FROM mytable WHERE first_name=$first last_name=$last
-Original Message-
From: Chuck Barnett [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 04, 2002 10:28 AM
To: [EMAIL PROTECTED]
Subject: Query help
Hi. I have two fields, firstname, lastname. I populate a select box with
Use CHAR, not TEXT for Nombre and Password
Also, INT will NOT be set to length of 1 in permiso
-Original Message-
From: Gastón Sancassano [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 04, 2002 12:10 PM
To: [EMAIL PROTECTED]
Subject: SQl query in MySQL (1)
My name is Gastón
It is not inserting NULL. when $login is NULL or blank, then a a record,
with emplogin equal to a string of zero characters is inserted, which is
valid. A string with zero characters is NOT a NULL value. So, it is
accepted.
-Original Message-
From: Andrew Hazen [mailto:[EMAIL
su as root
then restart mysqld
-Original Message-
From: john [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 04, 2002 4:10 PM
To: MySQL Lists
Subject: Help. I have truly blundered.
Please help with ignorance, I was in mysqld making some changes to a
database. I run a Linux 6 box with
UPDATE mytable SET field1=field2;
-Original Message-
From: Chuck Barnett [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 03, 2002 10:10 AM
To: [EMAIL PROTECTED]
Subject: copying field x to field y for each record in table
Hi, how do I do the following:
I have a table I have added a
if your app is PHP, then use stripslashes() on field
-Original Message-
From: Pal Lucian [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 03, 2002 10:58 AM
To: [EMAIL PROTECTED]
Subject: underline char in a [char][varchar][text] field ?
Hello everybody,
I have a problem inserting a
no stored procedures yet. maybe vers 4.1
-Original Message-
From: Kevin D [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 03, 2002 12:59 PM
To: [EMAIL PROTECTED]
Subject: transactions, referntial integrity
I've been reading the docs but I just want to verify. It seems like the
look at the manual, section :
6.4.9 LOAD DATA INFILE Syntax
LOAD DATA [LOW_PRIORITY | CONCURRENT] [LOCAL] INFILE 'file_name.txt'
[REPLACE | IGNORE]
INTO TABLE tbl_name
[FIELDS
[TERMINATED BY '\t']
[[OPTIONALLY] ENCLOSED BY '']
[ESCAPED BY '\\' ]
]
$r = mysql_query(SELECT * FROM hwureviews ORDER BY category,num DESC);
what are you trying to do with this statement?:
while ($info = mysql_fetch_row($max)) {
-Original Message-
From: Alex Behrens [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 03, 2002 4:08 PM
To: [EMAIL PROTECTED]
mysql version 4.x does this
-Original Message-
From: David yahoo [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 01, 2002 5:28 PM
To: [EMAIL PROTECTED]
Subject: multiple delete for mysql
Hi all,
How can i do a delete from multiple table in mysql?
Eg :
I want ot delete record
select id, shortdescription, title from reviews where title REGEXP
'^[0-9#$].*' ORDER BY title ASC
-Original Message-
From: Jay Paulson [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 01, 2002 6:32 PM
To: [EMAIL PROTECTED]
Subject: easy query question
I want to do a query that will find
What happened when you tried this experiment?
-Original Message-
From: Viraj Alankar [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 02, 2002 8:50 AM
To: [EMAIL PROTECTED]
Subject: insert delayed and timestamps
Hello,
When using 'insert delayed' syntax and there is a timestamp field
$retval = .= nbsp;nbsp;nbsp;nbsp;a href=\.$a[url].
\img src=\.$a[picurl].\border=\0\/abrnbsp;nbsp;.
- a href=\.$a[url].\.$a[title]./abrbr;
-Original Message-
From: Alex Behrens [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 02, 2002 3:46 PM
To: [EMAIL PROTECTED]
Subject: need some
From the manual:
DELETE [LOW_PRIORITY | QUICK] FROM table_name
[WHERE where_definition]
[ORDER BY ...]
[LIMIT rows]
Please note: there can be no SELECT clause..
-Original Message-
From: sunny [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 29, 2002 8:15 AM
To:
$query = SELECT * FROM gigs WHERE date '$today' ORDER BY date ASC LIMIT
3;
-Original Message-
From: David Rice [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 28, 2002 2:20 PM
To: [EMAIL PROTECTED]
Subject: Queries help (part II)
Hey thanks i got it to work sort of
$query = SELECT *
I have a column that is VARCHAR(32). I use it to store MD5 hash values.
MD5 hashes are always 32 byte.
So use char(32) instead. I do.
-Original Message-
From: Joel Rees [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 26, 2002 11:30 PM
To: Tino Didriksen
Cc: [EMAIL PROTECTED]
Subject:
You cannot update multiple tables in a single UPDATE.
Did you read the manual?
-Original Message-
From: Javier Armendáriz [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 27, 2002 2:04 PM
To: MySQL
Subject: What is wrong in this query???
Can someone tellme the problem in this
delete from user where user=wus;
-Original Message-
From: Manuel Hendel [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 25, 2002 12:24 PM
To: MYSQL List
Subject: problems deleting a user from user db
I got problems deleting a user which I've created before.
mysql delete from user
I don't understand your question
-Original Message-
From: Sukhdev Sethi [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 22, 2002 7:20 AM
To: [EMAIL PROTECTED]
Subject: querying check constraints
Hi,
I have created a table as below:
create table myTable
(
Field1 int auto_increment
What is the problem you wish to resolve? Define it.
-Original Message-
From: Buding Chen [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 21, 2002 6:33 AM
To: [EMAIL PROTECTED]
Subject: how to do when the table files become bigger and bigger
Hi, all:
I am doing a project that we
AND date = 2002-03-17;
-Original Message-
From: rory oconnor [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 21, 2002 10:49 AM
To: mysql list (choose midget)
Subject: Query syntax help
I'm trying to figure out a query that will tell me the total number of
people in our house email
this file is created when MYSQL starts
check the directory to ensure it has the correct read-write permissions
check the list archives; this question has been asked almost every day
-Original Message-
From: colin o [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 19, 2002 3:05 PM
To:
MySQL does not currently support sub-selects.
The manual says:
DELETE [LOW_PRIORITY | QUICK] FROM table_name
[WHERE where_definition]
[ORDER BY ...]
[LIMIT rows]
Did you review the manual first?
-Original Message-
From: Riccardi Moreno [mailto:[EMAIL PROTECTED]]
Sent:
ensure that /tmp has correct read-write-execute permissions
-Original Message-
From: Hresko, Christian A. [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 13, 2002 10:57 AM
To: '[EMAIL PROTECTED]'
Subject: starting mysql
i'm moving MySQL over to unix and i can't for the life of me get
have you tried forking the process, then terminating the parent? All open
file desciptors, including sockets, would be available to the child. The
child would contain the code in try1.c.
-Original Message-
From: Manvendra Bhangui [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 11, 2002
1. The auto_increment will not occur on failure. Try it yourself to
verify; I did.
2. When you delete a row, you DO NOT WANT the auto-increment to re-number.
You SHOULD have gaps. Why?
Because if the auto_incremented field is a primary key, and there are other
tables who fields refer to that
MySQL by Paul DuBoise
Paul monitors this mailing list, so if you have questions concerning what
you've read, he may answer.
-Original Message-
From: Danis Stéphane (NHQ-AC) [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 21, 2002 1:08 PM
To: Mysql (E-mail)
Subject: MySQL Book
Any
oops...
Do I get credit for capitalizing the B in DuBois? GRIN
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 21, 2002 3:57 PM
To: Rick Emery; 'Danis Stéphane '; Mysql (E-mail)
Subject: RE: MySQL Book
At 13:25 -0600 2/21/02, Rick Emery wrote
try:
select * from MapConfig mc LEFT JOIN ConfigString USING (id)
LEFT JOIN ConfigInt cf on mc.id=cf.id WHERE MapConfig.layername = Roads;
-Original Message-
From: Christopher Thompson [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 21, 2002 4:24 PM
To: [EMAIL PROTECTED]
Subject:
assuming that engaedto refers to an id, your query might be:
SELECT a.lname,a.fname,b.engagedto FROM mydata a LEFT JOIN mydata b
ON(a.id=b.engagedto);
-Original Message-
From: Dean Householder [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 19, 2002 11:22 AM
To: [EMAIL PROTECTED]
do you need to search on it? If not, perhaps storing these files separately
with a pointer storedd in the database. This will improve searching speed I
understand.
-Original Message-
From: Lee [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 19, 2002 10:29 AM
To: MySQL
Subject:
select id, lname, fname, pic from database where engagedto=id;
Sorry, mate, that won't work. That will find folks who are engaged to
themselves, i.e., narcissists
-Original Message-
From: Oliver Heinisch [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 19, 2002 11:30 AM
To: [EMAIL
From the manual:
In MySQL Version 3.23, you can use the TEMPORARY keyword...
Sorry, mate, you are SOL until you upgrade
-Original Message-
From: Brian Warn [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 19, 2002 12:09 PM
To: 'MySQL List'
Subject: v3.22.32 and temp tables
Hi,
I
You're very close:
mysql select p1.lname, p1.fname, p2.lname as engaged_lname, p2.fname as
engaged_fname from members p1, members p2 where p1.id = p2.engagedto;
but the REAL question is What do you want out of the query?
-Original Message-
From: Dean Householder [mailto:[EMAIL
CREATE TABLE newtable SELECT * FROM oldtable LIMIT 0;
-Original Message-
From: Todd Ellner [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 18, 2002 12:58 PM
To: [EMAIL PROTECTED]
Subject: sql: Copying the structure of DBs
I need to create multiple databases from time to time. This
and the URL is???
it's not www.codemonsters.net; I just checked
-Original Message-
From: Brian P. Austin [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 18, 2002 3:20 PM
To: [EMAIL PROTECTED]
Cc: mysql
Subject: RPMS for Development Branch
Hello all,
I have finished setting up a web
does your test app connect with root as the user?
-Original Message-
From: Lonnie Cumberland [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 15, 2002 12:12 PM
To: [EMAIL PROTECTED]
Subject: connections to MySQL
Hello All,
I am new to this list and hope that someone could answer this
Show us your table structure, some table values and the SELECT statement
that works and the one that doesn't
-Original Message-
From: Miretsky, Anya [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 15, 2002 12:13 PM
To: '[EMAIL PROTECTED]'
Subject: Left Join problem - Please Help
timestamp is automatically updated
-Original Message-
From: George Labuschagne [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 15, 2002 1:20 PM
To: [EMAIL PROTECTED]
Subject: When does the timestamp field gets updated?
Hi all,
If one uses the timestamp data type for a column inside
what the experts think.
-Original Message-
From: Miretsky, Anya [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 15, 2002 2:17 PM
To: 'Rick Emery'
Subject: RE: Left Join problem - Please Help
Biblio has 11,901 and keyword has 87,971, also I indexed the keyword column
in the keyword
possibly
-Original Message-
From: Miretsky, Anya [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 15, 2002 2:32 PM
To: 'Rick Emery'
Subject: RE: Left Join problem - Please Help
When I do this without specifying a left join with just :select biblio.*
from biblio,keyword where p_biblio
Why is the internal order important? When SELECTing, the internal order is
of no importance to MYSQL. It does not speed-up the query or access. When
discussing relational database systems, all that matters is the order of
output.
-Original Message-
From: Victoria Reznichenko
-Original Message-
From: Peter Ruan [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 14, 2002 4:04 PM
To: [EMAIL PROTECTED]
Subject: [PHP] MySQL question...not sure if this is the correct forum to
ask.
Hi,
Can the UPDATE statement have conditional check embedded in it? I
have a
Show us your code.
What are your table structures like?
-Original Message-
From: AOK Lansing [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 07, 2002 12:37 PM
To: [EMAIL PROTECTED]
Subject: PHP does not see Table updates
I am using PHP to access a MySQL DB. If I stop MySql and
What do your tables look like? Structure?
What are you trying to do?
What does your data look like?
-Original Message-
From: Ed Lazor [mailto:[EMAIL PROTECTED]]
Sent: Sunday, February 10, 2002 8:12 PM
To: [EMAIL PROTECTED]
Subject: Can this be done?
I'm trying to update a database.
The following deletes all records and re-starts renumbering from 1;
DELETE FROM mytable;
The following deletes all records and continues counting from where the
table last left off:
DELETE FROM mytable WHERE 1;
If you are trying to restart numbering while not deleting records,
forget-about-it.
try:
DELETE FROM relay_ip WHERE UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP(rei_ts)
600;
-Original Message-
From: Odhiambo Washington [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 11, 2002 1:22 AM
To: [EMAIL PROTECTED]
Subject: Clear table contents
Hello gurus,
Please allow me to
something easier:
DELETE FROM relay_ip WHERE NOW() - rei_ts 1000;
-Original Message-
From: Rick Emery
Sent: Tuesday, February 12, 2002 3:03 PM
To: 'Odhiambo Washington'; [EMAIL PROTECTED]
Subject: RE: Clear table contents
try:
DELETE FROM relay_ip WHERE UNIX_TIMESTAMP(NOW
A quick method is to create a new table:
CREATE TABLE newtable SELECT DISTINCT * FROM oldtable;
note; manually verify newtable has your data. Then proceed:
DROP TABLE oldtable;
CREATE TABLE oldtable SELECT * FROM newtable;
DROP TABLE newtable;
-Original Message-
From: Rich
I apologize for using bandwidth...it appears my posts are no longer going to
the [EMAIL PROTECTED] mailing list.
I'm just verifying before rteporting it, if necessary
magic words: sql,database,query
-
Before posting, please
Also, how do I reset an auto-increment value back to 1 (with all
rows being already deleted of course).
The following deletes all records and re-starts renumbering from 1;
DELETE FROM mytable;
The following deletes all records and continues counting from where the
table last left off:
DELETE
I'm not certain about the list.
I mailed several message on Tuesday about 3 PM central time. They did not
appear until 4:30 AM Wednesday. Many of my messages were duplicated because
I did not see them in the list when I mailed them so I was uncertain whether
I had even mailed them.
Today, I
I posted a message at 7:22 AM (US Central). It just appeared at 11:15 AM
(US Central)
--
-Original Message-
From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]]
Sent: 13 February 2002 01:15
To: [EMAIL PROTECTED]
Subject: Is The MySQL
If you're using mysql 4.0, you might try:
DELETE addrbkb FROM addrbkA,addrbkB WHERE addrbkA.phone=addrbkB.phone;
This functionality was added with 4.x. I haven't tested this, so BEWARE
The following is from the 4.0 manual:
DELETE t1,t2 FROM t1,t2,t3 WHERE t1.id=t2.id AND t2.id=t3.id
In the
show us your table structure
show us your table values
-Original Message-
From: Barry J. Wiegan [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 05, 2002 11:00 AM
To: [EMAIL PROTECTED]
Subject: Table join question
Hi,
I'm trying to build a query to solve a fairly simple problem.
I
If I understood you correctly you are comparing Record_ID to Phase_ID
try this:
SELECT rx.* FROM records rr LEFT JOIN records rx ON rr.Record_ID=rx.Phase_ID
WHERE rr.Record_Date@date1 rr.Record_Date@date2
NOT (rx.Record_Date@date3 rx.Record@date4);
This assumes that @date1, @date2,
If I understood you correctly you are comparing Record_ID to Phase_ID
try this:
SELECT rx.* FROM records rr LEFT JOIN records rx ON rr.Record_ID=rx.Phase_ID
WHERE rr.Record_Date@date1 rr.Record_Date@date2
NOT (rx.Record_Date@date3 rx.Record@date4);
This assumes that @date1, @date2,
If I understood you correctly you are comparing Record_ID to Phase_ID
try this:
SELECT rx.* FROM records rr LEFT JOIN records rx ON rr.Record_ID=rx.Phase_ID
WHERE rr.Record_Date@date1 rr.Record_Date@date2
NOT (rx.Record_Date@date3 rx.Record@date4);
This assumes that @date1, @date2,
I'm trying to figure out the bloody hell you're looking for.
What is date3? Where does it come from?
I think I speak for most folks here when I say...
What is date4? Where does it come from?
What is date4? Where does it come from?
Why is record 2 good, but not record 3?
How does Phase enter
Show us your code.
What are your table structures like?
-Original Message-
From: AOK Lansing [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 07, 2002 12:37 PM
To: [EMAIL PROTECTED]
Subject: PHP does not see Table updates
I am using PHP to access a MySQL DB. If I stop MySql and
The following deletes all records and re-starts renumbering from 1;
DELETE FROM mytable;
The following deletes all records and continues counting from where the
table last left off:
DELETE FROM mytable WHERE 1;
If you are trying to restart numbering while not deleting records,
forget-about-it.
There is no reason to add comments like There's no successful career path
for a hand-held dba. People come to this list looking for help. Comments
such as this will cause some folks not to ask questions for fear of public
ridicule.
Simply answer the question and move on. If you feel a need to
: Thursday, January 31, 2002 5:32 PM
To: Rick Emery
Subject: Re: Is this possible in one SQL statement
if you do this
select * from table where field like '%æ%';
you get records which contains both ascii 228 (ä) and ascii 230 (æ)
Do I have to set something special in my configuration of MySQL (3.23.44
?php
$recno = 7;
$query = DELETE FROM mytable WHERE field=$recno;
mysql_query($query) or die(Error: .mysql_error());
$query = SELECT * FROM mytable WHERE field$recno LIMIT 1;
$result = mysql_query($query) or die(Error: .mysql_error());
?
-Original Message-
From: Zak Grant [mailto:[EMAIL
It's created when that field is the first field in a multi-field index.
For example:
mysql describe mytable;
+---+-+--+-+-+---+
| Field | Type| Null | Key | Default | Extra |
+---+-+--+-+-+---+
| id| int(11) | YES | |
MYSQL does not support STORED PROCEDURE, TRIGGERS or VIEWS.
maybe, someday...
-Original Message-
From: Narendra [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 31, 2002 12:34 AM
To: mysql
Subject: Please clarify the doubt
Hi,
i am developing a software on linux platform and Mysql
Please restate the following more completely. I think some typos got in
there. If not, then we need more detail of what you really want.
the condition is then value 1 and 3 and the record I want is A1 and A3 due
to the fact that a recorc exists in table B with a value of on and one
record
Do away with that wretched MYSQL_ASSOC. I've seen it cause much pain and
misery. It is not needed.
while ($row_1=mysql_fetch_array($result_1))
-Original Message-
From: Anthony Rodriguez [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 31, 2002 7:32 AM
To: [EMAIL PROTECTED]
Subject:
mysql select distinct a.* from tableA a left join tableB b1 using(id),
tableB b2 where a.id=b1.id b1.id=1 b2.id=3;
-Original Message-
From: Steen Rabol [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 31, 2002 2:51 PM
To: Rick Emery; [EMAIL PROTECTED]
Subject: Re: Is this possible
The Linux version no longer has 2 GB limit. It is now whatever your disk
capacity is.
-Original Message-
From: Steve Kramer [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 30, 2002 11:34 AM
To: Christopher Thompson
Cc: MySQL
Subject: RE: Size Limitations
The manual doesn't specify
mysql describe mytable;
+---+--+--+-+-+---+
| Field | Type | Null | Key | Default | Extra |
+---+--+--+-+-+---+
| id| int(11) | YES | | NULL| |
| keyq | int(11) | YES | | NULL| |
| name |
Sorry, I meant:
mysql select name,max(dateq) from mytable group by keyq;
-Original Message-
From: Rick Emery
Sent: Wednesday, January 30, 2002 2:14 PM
To: 'P.Agenbag'; mysql
Subject: RE: SQL help plz
mysql describe mytable;
+---+--+--+-+-+---+
| Field
Further, I'd advise NOT using field names like date and key. Using
eserved words is never a good prcatice.
-Original Message-
From: Rick Emery
Sent: Wednesday, January 30, 2002 2:16 PM
To: 'P.Agenbag'; 'mysql'
Subject: RE: SQL help plz
Sorry, I meant:
mysql select name,max(dateq
mysql must be in your PATH. Is it?
-Original Message-
From: Egor Egorov [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 29, 2002 8:30 AM
To: [EMAIL PROTECTED]
Subject: [NEWBIE]Can't run mysql client
Stephane,
Monday, January 28, 2002, 1:29:40 PM, you wrote:
SP I've installed mysql
select Item.Item_Description, Item.Retail_Value, Item.Bid_Description,
Contributors.Name from Item, Contributors where Contributors.Contributor_ID
1;
-Original Message-
From: David S. Jackson [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 25, 2002 12:14 PM
To: Gurhan Ozen; [EMAIL
Is this a bug? I can't find an answer to this question in FAQs or archives.
CREATE TABLE aa ( a int);
INSERT INTO aa VALUES (1),(2),(3),(2),(4),(5),(1),(6),(3);
the following :
mysql select a,count(*) as z from aa where z1 group by a;
displays this error:
ERROR 1054: Unknown column 'z' in
|
+--+--+
6 rows in set (0.40 sec)
-Original Message-
From: Nathan [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 18, 2002 3:34 PM
To: Rick Emery
Subject: Re: Column Alias Bug??
What does the count(*) do? If that's failing, maybe the alias doesn't get
created?
Shot
To answer your second question about how to retrieve the auto_incremented
values:
$dbh-do(SELECT last_insert_id() AS myvalue);
execute the above IMMEDIATELY after inserting the record
-Original Message-
From: Ben Curran [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 15, 2002 5:59
did you start mysqld ?
-Original Message-
From: David Burklin [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 16, 2002 1:36 PM
To: '[EMAIL PROTECTED]'
Subject: MySQL newbie question
Hello, and sorry for the bother with what is probaby a very simple problem.
I'm new to MySQL. I
If the value was set with AUTO_INCREMENT, then immediately after inserting
the row, do:
SELECT last_insert_id() AS myvalue;
-Original Message-
From: Ing. Gustavo Edelstein [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 14, 2002 10:03 AM
To: [EMAIL PROTECTED]
Subject: ROW ID
Hi list
I use http://www.nomonthly fees.com
Initial buy-in is $200. However, that includes domain name registration,
500 megs of disks pace, 5 giga-bytes of band-width per month.
Complete PHP and MYSQL support. Bunch of other stuff too, like 1000 POP3
email boxes, PGP, shopping carts, etc.
After
In my previous email, I mentioned that http://www.nomonthlyfees.com provided
500 megs of disk space per account. I host several a domains by redirecting
domains (5) to sub-directories within that 500. I don't have a 500-meg
account for each domain. After the first year, the 500-megs cost
Perhaps, add the DISTINCT modifier:
SELECT distinct * FROM tutoriais,scripts WHERE tutoriais.nome LIKE '%mysql%'
OR tutoriais.descricao LIKE '%mysql%' AND scripts.nome LIKE '%mysql'
-Original Message-
From: Davis Zanetti Cabral [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 31,
You don't really have to do the two searches and if-then-else. You can use
joins to first get all grads, then a join to get all profs.
SELECT user.*,graduser.* FROM graduser LEFT JOIN user USING(userid);
SELECT user.*,profuser.* FROM profuser LEFT JOIN user USING(userid);
These assume USERIDs
1 - 100 of 182 matches
Mail list logo