Remove space between '-p' and the password in you command line.
That is>>bash-2.05a$ mysql -uwcjporoot -pwc_jpo
- Original Message -
From: "Egor Egorov" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, March 23, 2004 6:36 AM
Subject: Re: created user but access denied
D
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 t
/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
mydatabas
What result are you getting?
First off, I see that your HTML is possibly incorrect; should it be:
echo "Warranty ID:\n";
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 will for
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
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 lin
it worked for me:
mysql> describe t_timesheet;
++---+--+-+-++
| Field | Type | Null | Key | Default | Extra |
++---+--+-+-++
| id | int(11) | | PRI | NULL|
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
id
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.
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:
Ok, I know I am going to get yell about this but how can I do an SQL and
only show to fields from a tab
-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 (updati
CTED]]
Sent: Friday, April 05, 2002 10: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 t
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 [mai
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 simp
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 M
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 PROTECTED
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 Sancassano
sult = mysql_query($query);
-Original Message-
From: Chuck Barnett [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 04, 2002 11:21 AM
To: Rick Emery; [EMAIL PROTECTED]
Subject: Re: Query help
This will not work for my example. I have a select box that was populated
from the db with firstname
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
SELECT * FROM mytable WHERE date_field 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 trying to figure out the best way to select
the row of data for a specific id that is the most
rece
GROUP BY is done on column value.
show us you query
-Original Message-
From: Han de Neeling [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 04, 2002 7:15 AM
To: [EMAIL PROTECTED]
Subject: group by year
I have a MySQL database containing records from several years. I want to
calculate
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
T
$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
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 '\\' ]
]
[LIN
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
latest
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 t
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
$retval = .= " ".
"- ".$a["title"]."";
-Original Message-
From: Alex Behrens [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 02, 2002 3:46 PM
To: [EMAIL PROTECTED]
Subject: need some help...
Hey Guys,
I need help indentifiying why I have an error in this line of syntax:
while($a=
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 in
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
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 something
>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 = "SELEC
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 query??
> 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: R
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 no
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
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 w
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: mys
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
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: Wednes
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 5
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
You cannot do nested JOINs. Try:
INNER JOIN FORUMCAT1 ON USERS.ID = FORUMMSG1.AUTHORID
INNER JOIN FORUMMSG1 ON FORUMCAT1.ID = FORUMMSG1.POSTNUMBER
-Original Message-
From: Mat Murdock [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 22, 2002 1:12 PM
To: [EMAIL PROTECTED]
Subject: Re:
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:
oops...
Do I get credit for capitalizing the B in DuBois?
-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 E
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 b
This is not a problem.
Please help me to understand: why would you WANT the primary key field to be
updated?
I ask, because if the fields of other tables refer to the primary keys of
phpSP_users and then the primary key of phpSP_users was updated due to
deletions; the result would be that those
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 PROTEC
>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 wan
> 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
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: approp
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]
Subj
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
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 is
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 wher
he mysql list to see 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
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 a
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
Whene
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
-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 page
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 [mailto:[E
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 abov
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 MyS
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 se
>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 F
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 chec
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 [mailto:[E
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_
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 requ
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.
-
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. H
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
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, @d
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, @d
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, @d
The PHP/MYSQL combo is also a good choice, as is PERL/MYSQL
-Original Message-
From: Joshua J.Kugler [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 11, 2002 11:44 AM
To: Jim Hatridge; [EMAIL PROTECTED]
Subject: Re: forms?
Using Perl/CGI and DBI::MySQL would work for forms. You could
UPDATE mytable SET newcol=oldcol;
-Original Message-
From: Max Mouse [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 06, 2002 3:11 PM
To: [EMAIL PROTECTED]
Subject: Columns
Hey all,
Is it possible to copy the contents of one column to another column using
mySQL? I just
changed my
About 3 months ago, there was a long discussion thread about this very
topic.
Final answer: "the","a","an" must be handled in the language
(perl/php/etc...). Or, you must change data in your fields so that these
words are NOT the first in the field.
-Original Message-
From: abdul - "ÚÈ
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 ha
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 i
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.
-
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
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 t
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 | |
$recno LIMIT 1";
$result = mysql_query($query) or die("Error: ".mysql_error());
?>
-Original Message-
From: Zak Grant [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 01, 2002 6:08 AM
To: [EMAIL PROTECTED]
Subject: Next auto_increment value?
All,
I'm a little (lot!) stuck on generatin
ROTECTED]]
Sent: 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 config
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]
S
SELECT COUNT(p.artID) AS LCNT FROM pages p WHERE p.siteID = 1
-Original Message-
From: Nick Stewart [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 31, 2002 8:20 AM
To: [EMAIL PROTECTED]
Subject: Quick SQL querie on count and embedded SELECT
Hi all,
I want to do this,
SELECT COUN
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: P
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 with
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 V
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
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>
mysql> describe mytable;
+---+--+--+-+-+---+
| Field | Type | Null | Key | Default | Extra |
+---+--+--+-+-+---+
| id| int(11) | YES | | NULL| |
| keyq | int(11) | YES | | NULL| |
| name | cha
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 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
Sounds like a job for a LEFT JOIN. However, before we can help, we need to
know the table structure andhow the two tables are related.
Of course, if sub-selects are out of the question.
-Original Message-
From: BD [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 28, 2002 12:13 PM
To: [EM
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 PROT
1 - 100 of 203 matches
Mail list logo
