On Wed, Jan 08, 2003 at 08:34:18AM -0500, Charles Mabbott wrote:
> I got a gift certificate for book store. I am looking for good MySql
> books with reference, examples, etc? Anyone have some ideas on good
> books to look at
>
MySQL by Dubois is a good starter book. Not sure how it works for th
How do I correct this SQL code:
2 tables there,
lcopen: id, bank, unit_price_us, order_cbm
lcreceive: id, amount_us, due_date
#this condition :lcreceive.due_date < current_date
#only affect to : SUM(lcreceive.amount_us)
#and NOT :
#SUM(lcopen.unit_price_us*lcopen.order_cbm) * 7.8 AS
open
SELE
Hi:
I am using expect scripts to display huge number of tables in mysql, I wonder is there
any command in mysql that display out the timestamp it takes to load the databases.
Thanks
-
Before posting, please check:
http://ww
Thank you all very much for ur replies. I think using load data
infile without local is all right for the time being, as the
database i m going to use is pretty much going to be static with
very little changes over time. so that is sufficient for me.
However, if u do have any new ideas or thoug
Thank you all very much for ur replies. I think using load data
infile without local is all right for the time being, as the
database i m going to use is pretty much going to be static with
very little changes over time. so that is sufficient for me.
However, if u do have any new ideas or thoug
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 ..
At 18:39 +0100 1/8/03, Stefan Hinz, iConnect (Berlin) wrote:
Charles,
I posted the same problem a couple of days ago. LOCAL will not work
because of a security "improvement" the MySQL folks applied.
LOAD DATA INFILE "C:\\mysql\\fred.txt" INTO TABLE data_table;
Hope this helps, but only a
Hello all,
I've compiled Mysql-3.23.54a in HP-UX-11.11 using gcc. It compiles ok
and while running
"make test", i got following error.
Can't create interrupt-thread (error 251, errno: 22)
mysqld ended
how to overcome this? plz help me asap.
Advance Thanks and Regards,
-sadha
Please see last line "comments text null,"
I do not believe you need the ',' between the
End of statement and the ')'
Try this:
create table guestbook
(
name varchar( 40 ) null,
location varchar( 40 ) null.
email varchar( 40 ) null,
url varchar( 40 ) null,
comments text null
)
;
Regards,
Chuck
At 17:23 -0500 1/8/03, Keith C. Ivey wrote:
On 8 Jan 2003, at 12:08, Paul DuBois wrote:
You must perform the conversion yourself, displaying the URL both
as the href atttribute and body text of an tag. Don't forget
to URL-encode it for use in the attribute, and HTML-encode it for
use in th
Hi,
I'm using MySQL 4.0.7 gamma version. I just want to
know if MySQL support sub select statement. The
example of sub select statement is as below. I've
tried many times but then get an error.
Example:
select alc, fdate, sum(totalpax) from (select distinct
alc, fln, fdate, totalpax from billin
Hi:
Go look in the section where they keep the O'Reilly books and pick up
"MySQL Cookbook" by Paul DuBois ISBN 0-596-00145-2.
It is fair to say that Paul has an above average grasp of the topic.
He is often quoted on this list.
Regards,
Doug
On Wed, 08 Jan 2003 08:34:18 -0500, Charles Mabbott
I have a php/mysql application that allows a user to
add/remove/update/delete text and records from various tables. To avoid
table overhead that comes when column sizes change etc - I am
considering implementing an optimization query that will optimize all
tables in the db every time the use
Thanks everyone for your input.
Stefan,
> >From, within phpMyAdmin?
1. In the left frame, choose the database you want to backup / copy.
2. Click the EXPORT tab in the right frame.
3. Choose the tables in the database you want to backup.
4. Choose "Structure and data".
5. Check "Enclose table an
How do I correct this SQL code:
2 tables there,
lcopen: id, bank, unit_price_us, order_cbm
lcreceive: id, amount_us, due_date
#this condition :lcreceive.due_date < current_date
#only affect to : SUM(lcreceive.amount_us)
#and NOT :
#SUM(lcopen.unit_price_us*lcopen.order_cbm) * 7.8 AS
open
SELE
On Wed, Jan 08, 2003 at 01:31:44PM -0800, Lennart Stevens wrote:
>
>
> I created a new forum for all of you who do not like to dig throught tons of
> a-mail to find one that really matters.You can talk about Linux, mysql and
> pretty much whatever else is computer realted. Check it out here
>
It might be a permissions problem. Mysql is trying to create a temporary
file to do the ALTER but cannot.
Check for the write permissions/ownership on the data directory.
Regard,
Bhavin.
- Original Message -
From: "Nick Stuart" <[EMAIL PROTECTED]>
To: "MySQL" <[EMAIL PROTECTED]>
Sent: Wedn
Hi All,
Not sure how to do this (or even if you can) but thought I would ask
anyway.
I have a database of names and would like to do a selection based on the
number or words in a name
eg the name "Peter Smith" has 2 words
the name "Peter John Smith" has 3 words
the name "Peter John Fred Smith" h
On 1/8/03 8:34 AM, "Rick Tucker" <[EMAIL PROTECTED]> wrote:
> I just imported a .csv file and one of the columns of data was websites
> addresses. Those addresses aren't being recognized as links when I output
> an html table from my queries. I'm scratching me head on how to make the
> conversio
Thats what I thought, but wasnt the case. The directory was open to full
control by everyone. I did fix the problem though. It turns out this is
an issue with windows not letting anyone edit a file that is in use. And
when a table is used mysql will cache and hence windows thinks it's in
use and wi
Dear Editor,
After installed the MySQL version 3.23.53, I tried to test the MySQL by
typing the following command, relevant error message appears, please advise
how to fix.
Command: Display Error Message:
mysqlshowmysqlshow: Can't connect to MySQL server on
'local
At 20:39 +0100 1/8/03, Stefan Hinz, iConnect (Berlin) wrote:
Octavian,
I've read the following in a MySQL book:
It's a rather old book, which deals with MySQL 3.23, and not with MySQL
4.x.
Actually, he's talking about MySQL Cookbook (p549). Which is a new book,
which is why I said *may* re
>ERROR 7: Error on rename of '.\helpdesk\call_information.MYI' to
>'.\helpdesk\#sql2-b90-81.MYI' (Errcode: 13)
>Any ideas on why I would get this??
Errorcode 13 is permission denied or file not found. Either
.\helpdesk\#sql2-b90-81.MYI exists and your mysqld user does not have
permission to over
HTML doesn't just see a URL and automatically make it a hyperlink it is not
"helpful" like MS products. So what you are seeing is expected behavior. I
would alter the while loop to look like this...
while ($row = mysql_fetch_array($resultID)){ #fetch_array adds little
overhead and gives you an
Aside from designating a row as a primary key, is
their any SQL syntax to force that entries within a
row are unique (such as a string value)? Thanks!
Steve Nakhla
__
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mai
Hi Rick!
You could also do something like the following (I'm assuming that the
http://www part isn't in $field already. . .).
=
print "";
foreach ($row as $field)
{
print "http://www.$field/";>http://www.$field";
}
print "";
=
Cheers!
-warre
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 ...
-
What I did was setup my file in mysql directory (i.e. fred.txt)
LOAD DATA INFILE "C:\\mysql\\fred.txt" INTO TABLE data_table;
Hope this helps, but only a workaround...
Chuck
http://68.43.100.7:81/aa8vs
==
"Patriotism is the willingness to kill and
be kil
On Wed, Jan 08, 2003 at 10:27:30AM -0800, Steven Nakhla wrote:
> Aside from designating a row as a primary key, is
> their any SQL syntax to force that entries within a
> row are unique (such as a string value)? Thanks!
Hello Steve,
You can create a UNIQUE key for a column that will ensure t
At 10:27 -0800 1/8/03, Steven Nakhla wrote:
Aside from designating a row as a primary key, is
their any SQL syntax to force that entries within a
row are unique (such as a string value)? Thanks!
Steve Nakhla
Well, other than using a PRIMARY KEY, you can use a
UNIQUE index, but aside from a cou
On 8 Jan 2003, at 12:08, Paul DuBois wrote:
> You must perform the conversion yourself, displaying the URL both
> as the href atttribute and body text of an tag. Don't forget
> to URL-encode it for use in the attribute, and HTML-encode it for
> use in the body text.
I think Paul meant to say yo
>Imagine an ISP giving every customer write privileges for the mysql/bin
directory ... ;-/
Why would they have to do that? The file does not need to be in that
directory. In order to use LOAD DATA INFILE without LOCAL the file just
needs to be somewhere on the server that mysqld is running on and
Bonjour,
Consultant / Chef de Projet Indépendant à la recherche d'une mission,
je vous propose ma collaboration.
Mes principales compétences techniques sont les suivantes :
Systèmes : Windows NT / 2000 / XP, Linux, Unix (Solaris)
Réseaux : Windows NT / 2000 / XP, TCP/IP, DNS, IIS, Netscape
/
I had this same problem. Based on a similar thread, I went into the
properties for the service, changed it run under a user account with admin
privileges, applied the changes, then changed it back to run under the local
account and applied the changes. No more problem. Go figure.
-Original
I created a new forum for all of you who do not like to dig throught tons of
a-mail to find one that really matters.You can talk about Linux, mysql and
pretty much whatever else is computer realted. Check it out here
http://www.linuxforum.hopto.org
thanks
_
Frank,
> >I need to copy a MySql Production database to QA. What is the best
method of
> >doing this? Do I need to write SQL queries or is there another
quicker method?
There are alot of possibilities to accomplish this fast.
> > From the command line?
shell> mysqldump -uusername -ppassword yo
I'd like to be able to create a new database using Perl/DBI instead of using
the MySQL command line (and other) utilities. It looks like you can create a
new database with the driver handle but I can't seem to make it work.
-
Bef
Alexander,
> Have you tried to reproduce them?
Bug #1: GRANT USAGE doesn't seem to create a user:
mysql> GRANT USAGE ON *.* TO 'foo'@'foohost';
Query OK, 0 rows affected (0.26 sec)
mysql> SHOW GRANTS FOR 'foo'@'foohost';
Empty set (0.03 sec)
mysql> SELECT Host, User, Password FROM mysql.user W
I got a gift certificate for book store. I am looking for good MySql
books with reference, examples, etc? Anyone have some ideas on good
books to look at
Chuck
=
"Incoming rounds always have the right of way"
- Rules of War
-
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Rick,
How are you pulling the data? PHP? Perl? ASP? HTML doesn't
automatically insert hyperlinks where it finds
http://www.somedomain.com. It has to be told that it is a link by the
http://www.somedomain.com";>SomeDomain
tag.
If you are pu
FYI:
Setting up a lab environment for this database answered my question.
I moved the big field to a dedicated table, and queries on data_static got
much faster. Instead of 60 seconds, the query is done in less than 1.
Thanks for all the ideas people sent me privately.
Cheers,
Jim
--
Octavian,
> I've read the following in a MySQL book:
It's a rather old book, which deals with MySQL 3.23, and not with MySQL
4.x.
> DELETE FROM tbl_name WHERE 1 > 0;
In MySQL 3.23, this was a workaround to force the server to delete a
table row by row. By default, 3.23 would on DELETE FROM tbl
On 1/8/03 8:34 AM, "Rick Tucker" <[EMAIL PROTECTED]> wrote:
> I just imported a .csv file and one of the columns of data was websites
> addresses. Those addresses aren't being recognized as links when I output
> an html table from my queries. I'm scratching me head on how to make the
> conversio
At 9:33 +0200 1/8/03, Octavian Rasnita wrote:
Hi all,
I've read the following in a MySQL book:
A special case of record deletion occurs when you clear out a table
entirely using a DELETE with no WHERE clause:
DELETE FROM tbl_name;
In this case, the sequence counter may be reset to 1, even f
>Student | Class
>--
>Steve Lefevre | Math101
>Stacy Adams | Intro to SQL
>Something like
>SELECT Student.Name, Classes.Name FROM Students, Classes WHERE
>Students.StudentID = " . $ID . " AND Classes.Name IN ( SELECT
Classes.Name
>FROM Classes WHERE ClassID = Students.Clas
Got another problem with 4.0.7 when trying to alter the table.
Trying to run:
ALTER TABLE `call_information` CHANGE `close_date` `close_date`
TIMESTAMP DEFAULT '' NOT NULL
and it returns a:
ERROR 7: Error on rename of '.\helpdesk\call_information.MYI' to
'.\helpdesk\#sql2-b90-81.MYI' (Errcode: 13)
Try...
while ($row = mysql_fetch_row($resultID))
>{
>print "";
>foreach ($row as $field)
>{
print "$field";
>}
>print "";
>}
>print "";
>mysql_close ($linkID);
I don't use print so I'm not sure about that, I use echo.
Larry S. Brown
Dimension Networks, Inc.
(727) 723-8388
-Original Message
On 8 Jan 2003, at 15:27, Svens Klave wrote:
> | image | check |
> | 6782 | 0 |
> | 2732 | 1 |
> | 6734 | 1 |
>
> so I want to make query
> select * from foo1 where [so is it possible to make some if check=1 then
> image is image but if check=0 then into image goes othe
I seem to have found a bug with 4.0.7. I just want to make sure the
issue hasn't been covered before I submit a report.
I have 4.0.7 installed on windows 2000 server with all the service packs
and stuff. When I connect to the database through a Linux client
(haven't tried it on the box itself) and
Larry,
This is the code I'm using. I'm pretty new to PHP, so there may be a simple
solution within PHP of which I'm unaware. I just thought it could be done
from the MySQL side of things.
$resultID = mysql_query("SELECT * FROM ports", $linkID);
print "Port #";
print "TransportApplicationRFC/V
On Wed, Jan 08, 2003 at 08:34:25AM -0800, Rick Tucker wrote:
> I just imported a .csv file and one of the columns of data was websites
> addresses. Those addresses aren't being recognized as links when I output
> an html table from my queries. I'm scratching me head on how to make the
> conversio
> 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
Hi Prathmesh,
What is the behaviour that you see when you try to LOAD DATA. Any messages?
Regards,
Bhavin.
- Original Message -
From: "Prathmesh J. Mahidharia" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, January 06, 2003 11:22 PM
Subject: Load local data infile problem
> he
can you send the description of your table. There are lots of reasion for
slowing down your query but I dont thint Date_formate () is a cause for
slowing down the query.You have very less data only 35,000..
You can try to optimize by using
1. Create INDEX on case_id
2. optimize and check table [t
can you send the description of your table. There are lots of reasion for
slowing down your query but I dont thint Date_formate () is a cause for
slowing down the query.You have very less data only 35,000..
You can try to optimize by using
1. Create INDEX on case_id
2. optimize and check table [t
From: Lefevre, Steven <[EMAIL PROTECTED]>
> ...I think I need a subselect...
It's rare that a sub-select is actually ~needed~, but it does happen. You can almost
always get around it with a JOIN of some sort.
> Final result should look like
> Student | Class
> --
> St
From: Rick Tucker <[EMAIL PROTECTED]>
> Those addresses aren't being recognized as links when I output
> an html table from my queries.
[ snip ]
> I figured there would by a hypertext datatype of some sort...
Do you mean like this:
CREATE TABLE stuff (
link hypertext
);
INSERT I
Rick Tucker wrote:
> I just imported a .csv file and one of the columns of data was websites
> addresses. Those addresses aren't being recognized as links when I output
> an html table from my queries. I'm scratching me head on how to make the
> conversion. I figured there would by a hypertext
Hello mysql,
I try use 4.0.8 (max & standard)in our production box,
and it was crash every TCP connection, For 4.0.7 (standard) i has over 20 days
uptime.
Best regards,
Andrew Sitnikov
e-mail : [EMAIL PROTECTED]
GSM: (+372) 56491109
-
At 8:34 -0800 1/8/03, Rick Tucker wrote:
I just imported a .csv file and one of the columns of data was websites
addresses. Those addresses aren't being recognized as links when I output
an html table from my queries. I'm scratching me head on how to make the
conversion. I figured there would b
Charles,
>> I posted the same problem a couple of days ago. LOCAL will not work
>> because of a security "improvement" the MySQL folks applied.
> LOAD DATA INFILE "C:\\mysql\\fred.txt" INTO TABLE data_table;
> Hope this helps, but only a workaround...
Without LOCAL, quite alot of things will not
I think the problem is in your table structure. If you did this:
Students:
- Name
- StudentID
Classes:
- ClassID
- Name
StudentsClasses:
- StudentID (PK)
- ClassID (PK)
(You make them a combined key by doing PRIMARY KEY (StudentID,ClassID) in
your table def.)
When you add a student to a class
is there an snmp mib or something available for snmp to monitor mysql
server? or, does anyone have a script that they would like to share that
they use to monitor and gather statistics about mysql?
thanks,
shon
-
Before posting,
> What I can easily do without breaking 4.0.x "gamma" status, is to add
> command line switch --disable-fulltext-stopwords. It can help as a
> temporary solution, untill a proper fix - per-index options, that is -
> will be implemented.
That would be helpful for me, but what about Thomas Spahni's
Resending this, since the first one didn't seem to get posted on the MySQL
list.
> -Original Message-
> From: Erlend HopsÛ StrÛmsvik
> Sent: 7. januar 2003 10:18
> To: [EMAIL PROTECTED]
> Subject: RE: MySQL fulltext. Question about the stopword list
>
>
> > What I can easily do without
-Original Message-
From: Lefevre, Steven [mailto:[EMAIL PROTECTED]]
>
> Hey folks-
>
> 'nother question.
> I'm not an SQL expert, and I think I need a subselect, which
> means I need a workaround on MySQL 3.23 or whatever version it is.
>
> Here's the tables I have, with the relevant column
Hello Paul,
I have tried the code you have written, before posting to list and it did not work.
When I have seen the sentence "This requires that you have MySQL 4.x" at your mail I
realized the problem. I am using mySQL 3.23.49. :(
Thanks for your help.
Paul DuBois <[EMAIL PROTECTED]> wrote:
On Wed, Jan 08, 2003 at 09:00:51AM -0700, David Rock wrote:
>
> Are many people using MySQL version 4 yet? I'm interested in it
> because I want to use it's SSL capabilities but would like to hear
> that people are not having trouble with it first.
I've had very good luck with MySQL 4 in several
I need to copy a MySql Production database to QA. What is the best method of
doing this? Do I need to write SQL queries or is there another quicker method?
From the command line?
From, within phpMyAdmin?
-
Before posting, pl
FROM must precede WHERE.
Terence Ng wrote:
How do I correct this SQL code:
2 tables there,
lcopen: id, bank, unit_price_us, order_cbm
lcreceive: id, amount_us, due_date
#this condition :lcreceive.due_date < current_date
#only affect to : SUM(lcreceive.amount_us)
#and NOT :
#SUM(lcopen.unit_pr
On Wed, Jan 08, 2003 at 03:27:51PM +0200, Svens Klave wrote:
>
> Can anybody help me
> with select query
>
> how to do this:
>
> I have table "foo1" with two fields "image" "check"
>
> | image | check |
> | 6782 | 0 |
> | 2732 | 1 |
> | 6734 | 1 |
>
> so I want to ma
>I'm having trouble getting the two to work, when I try to connect to
the
>database in Crystal I get an error message saying "ODBC Error:
[TCX][MyODBC}
>Could not read table names"
It is worth a try. Here are the instructions for the registry fix.
Download odbcregs.zip from Crystal Decisions.
h
On Sunday 05 January 2003 16:10, Francesco wrote:
> I tried to drop a table with Mysql 4.0.1 alpha nt and I have encountered
> the following problem:
> ERROR &: Error on delete of .'\camcomm.tmpge.MYI'
> The problem persists. I don't know the reason of this error.
> I ask if a new version of Mysql
Hi Stefan,
-Original Message-
From: Stefan Hinz, iConnect (Berlin)
>
> Alexander,
>
> > - After having set up both machines completely, I installed
> > the Win32 binary distribution of MySQL 4.0.7-gamma. Although
> > I did not upgrade from an earlier version, the privileges
> > tables stil
On Tuesday 07 January 2003 11:49, Leonid Prokopets wrote:
> I'm having a problem running MySQL as NT service on Win2000 plattform. It
> works allright in manual mode (by 'mysqld' command), but refuses to run as
> service. I installed the service by 'mysqld-max-nt --install' command.
> The syste
On Wednesday 08 January 2003 06:55, CM Miller wrote:
> Have a new years resolution, to get MySQL to run
>
>
> Here are the errors that I keep getting...
>
> I don't understand what this is telling me?
>
> from /var/log
>
> 021214 19:13:21 mysqld started
> 021214 19:13:21 /usr/local/libexec/mys
On Monday 06 January 2003 14:51, Daniel Kiss wrote:
> Does anyone know why 'on update cascade' option does not work in InnoDB
> foreign keys?
> Is it supported anyway?
It's supported since 4.0.8:
http://www.mysql.com/doc/en/News-4.0.8.html
--
For technical support contracts, goto http
On Wednesday 08 January 2003 03:17, Adam Dershewitz wrote:
> After digging through the mysql web site and hunting on google I couldn't
> find the answer to a problem that I am having.
>
> It looks like MySQL is having problems differentiating between the
> "Т"(ascii 244) and the "o" characters.
* Svens Klave
> Can anybody help me
> with select query
I can try.
> how to do this:
>
> I have table "foo1" with two fields "image" "check"
>
> | image | check |
> | 6782 | 0 |
> | 2732 | 1 |
> | 6734 | 1 |
>
> so I want to make query
> select * from foo1 where [so is
Jonas,
We use mysqlhotcopy as a command line script set to run daily as a cron
job. Seems to work fine. You can add flags that allow you to maintain
previous copies of the db in case you need to go back a version or two. It
took about 10 minutes to set up. We then run TSM backups to storage of
Hi all,
I've read the following in a MySQL book:
A special case of record deletion occurs when you clear out a table
entirely using a DELETE with no WHERE clause:
DELETE FROM tbl_name;
In this case, the sequence counter may be reset to 1, even for table types
for which values normally are no
At 14:03 +0100 1/8/03, Walter Procopio wrote:
Hi,
I have installed mysql max 4.0.7 gamma on a Suse (ver. 8.0 professional)
linux server. I have tried many full text queries and I had only a problem
with a query like this:
SELECT count(a.rsori) pippo
FROM ecoras a, ecotxt b
WHERE MATCH ( b.rstxt
At 7:27 -0500 1/8/03, Veysel Harun Sahin wrote:
Hello,
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 o
>Are many people using MySQL version 4 yet? I'm interested in it
because I
>want to use it's SSL capabilities but would like to hear that people
are not
>having trouble with it first.
We have been using 4.0.x for about five months now on a production
system and have had no problems.
Scott Pipp
- Original Message -
From: "Lefevre, Steven" <[EMAIL PROTECTED]>
> The problem (as I see it) is that I'm storing the last name and the first
> name in two seperate fields. I can make an SQL statement like "Select *
from
> Students Where LastName Like "Smith%";", but can I make something li
At 18:06 +0200 1/8/03, Vladimir Zheleznyak wrote:
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: delay on executing mysql_free_result with underfetched query
Description:
If to execute mysql_use_result on the query that returns large amount of
records and then
execute mysql_free_result -
I just imported a .csv file and one of the columns of data was websites
addresses. Those addresses aren't being recognized as links when I output
an html table from my queries. I'm scratching me head on how to make the
conversion. I figured there would by a hypertext datatype of some sort, but
I
Hey folks-
'nother question.
I'm not an SQL expert, and I think I need a subselect, which means I need a
workaround on MySQL 3.23 or whatever version it is.
Here's the tables I have, with the relevant columns:
Students
- Name
- StudentID (PK)
- ClassID
Classes
- ClassID (PK)
- Name
Each
On Mon, 6 Jan 2003, Beogradjanin wrote:
> Hello mysql,
>
> I want to learn MySQL and PHP I've installed Apache , PHP and MySql
> Whan I try to make tables
>
> create table guestbook
> (
> name varchar( 40 ) null,
> location varchar( 40 ) null.
> email varchar( 40 ) null,
> url varchar( 40 ) nu
The problem you are having is a result of the permissions that are set on
the data and log directories that are identified in my.cnf, and is
documented in the MySQL Reference Manual. If you change the ownership of
the data and log directories to mysql (both user and group), the error
should go awa
That would be my guess, the extra time is the data transfer. You can
easily verify this by changing your query to:
SELECT COUNT(*)
FROM data_static
WHERE case_id = 0;
That will give you the raw query time without the data transfer or
formatting overhead.
On Wednesday, January 8, 2003, at 10:32
Hello,
I would like to ask three questions related to MySQL and MERGE tables.
I have a program that reads from mysql server (4.0.5 for Solaris 2.8 on a
V880 with 8 processors and 32 GB of memory), using Perl DBI MySQl driver,
two tables FULLM (merge of 3 tables) and RECKM (merge of 15 table
Hi Beogradjanin
As Paul mentioned yesterday, the final column defination does not require a
comma because it is the final defination.
Bhavin.
- Original Message -
From: "Beogradjanin" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, January 06, 2003 7:38 PM
Subject: I'm new in Mys
You don't even need the "check" field you can just directly check the
contents of the image field. Although I'm not sure if you are trying to
set a filter or display something different. If you want to display a
conditional on a field then you need to specify that field directly.
select *,if(im
Are many people using MySQL version 4 yet? I'm interested in it because I
want to use it's SSL capabilities but would like to hear that people are not
having trouble with it first.
Thanks,
David Rock
-
Before posting, please
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: delay on executing mysql_free_result with underfetched query
Description:
If to execute mysql_use_result on the query that returns large amount of
records and then
execute mysql_free_result - execution the last function take time equal to
fet
I've got what would be best described as a medium sized table, which
normally queries quickly, except for this one...
Table "data_static" has around 35,000 records.
This trivial query:
SELECT tracking_id,
complainant_email,
DATE_FORMAT(import_date,'%Y-%c-%e') AS date,
subject
> Why can't you use an Env variable to point to the server you want to query
> from and switch the value back and forth as needed in the case that you want
> to periodically switch back and forth between servers? Or write a function
> that runs on server1 to query against the tables on server2 mak
Hi,
I have installed mysql max 4.0.7 gamma on a Suse (ver. 8.0 professional)
linux server. I have tried many full text queries and I had only a problem
with a query like this:
SELECT count(a.rsori) pippo
FROM ecoras a, ecotxt b
WHERE MATCH ( b.rstxt ) AGAINST ( '-linux' IN BOOLEAN MODE )
AND a.rs
Why can't you use an Env variable to point to the server you want to query
from and switch the value back and forth as needed in the case that you want
to periodically switch back and forth between servers? Or write a function
that runs on server1 to query against the tables on server2 making the
1 - 100 of 124 matches
Mail list logo
