On Thu, Feb 21, 2002 at 11:29:28PM -0800, Jeff Kilbride wrote:
> Hmmm...
>
> Ok, my original assumption was that if I was grouping by those
> fields in my SELECT, then including them in the index would help --
> if the order of my GROUP BY followed the order of the fields in the
> index.
>
> You
Hmmm...
Ok, my original assumption was that if I was grouping by those fields in my
SELECT, then including them in the index would help -- if the order of my
GROUP BY followed the order of the fields in the index.
Your saying it doesn't make much of a difference whether I include them or
not?
T
On Thu, Feb 21, 2002 at 08:13:51PM -0800, Jeff Kilbride wrote:
>
> For reporting purposes, I usually use a wide index across all the
> fields that are relevant to creating the reports. So, for example,
> my sales table has this type of data:
>
> sale_id
> sale_date
> salesperson_id
> product_id
>
On Thu, Feb 21, 2002 at 08:07:39PM -0500, Anthony W. Marino wrote:
> Is there a timeline/status for 4.x functionality available?
No. It'll be ready when it's ready. :-)
There are folks using 4.0.x in production and/or testing now. This
helps test the code and get folks comfortable enough with
Just recently installed FreeBSD 4.5-RELEASE and cvsup'd to latest
4-STABLE. Updated ports tree and did a make install in
/usr/ports/databases/mysql323-server and received the following on the
mysql_install_db part:
/usr/local/bin/mysql_install_db
Preparing db table
Preparing host table
Preparing
Hi,
I have the following problem:
I had to install a complete new server with Suse 7.2 (MySql: 3.23.37-8).
>From the the old installation I only got the backup files (created with
'mysqldump database > my_databases.sql') and the the database file (ISD,
ISM, frm).
My problem is: I can't read the
Given two tables (t1 and t2) with fields "start" and "end", what is the most
efficient method of finding the all the intervals in the first table that
overlap any interval in the second table?
Right now, I use a query like:
SELECT t1.name, t2.name FROM t1, t2
WHERE t1.start <= t2.end AND t1.en
For reporting purposes, I usually use a wide index across all the fields
that are relevant to creating the reports. So, for example, my sales table
has this type of data:
sale_id
sale_date
salesperson_id
product_id
referral_id
[other sales data]
sale_id is an auto_incrementing primary key. Most
Are there any open source ERD programs for MySQL for doing basic data
modelling? I tried myERD at sourceforge and it couldn't parse the sql dump
from my database. It died with a parse exception on the "unsigned" attribute
for my int columns.
Any other choices out there?
Thanks,
--jeff
Hi,
On Fri, 2002-02-22 at 11:29, [EMAIL PROTECTED] wrote:
> Have u encountered this kind of query?
>
> mysql> select edate from traffic where year(edate)='2001' group by
> month(edate);
>
> ++
> | edate |
> ++
> | 2001-04-29 |
> | 2001-05-01 |
> | 2001-06-01 |
> | 2
I can't see any way of making this statement faster, however:
One method to increase speed, especially since the amount of data is large
is to create seperate tables into your lowest common denominator, here year
(e.g. traffic_2000,traffic_2001 etc).
Then create a merge table with the same name
My concern here is the query speed
Mysql query on the statement result so slow...is there a way to improve it?
R.B.Roa
Traffic Management Engineer
PhilCom Corporation
Tel.No. (088) 858-1028
Mobile No. (0919) 30856267
-Original Message-
From: Daniel Rosher [SMT
I presuming you are expecting more results from the first select statement,
hence the reason and indicating this in the second, should then your first
statement be:
select edate from traffic where year(edate)='2001' group by
edate;
?
Regards,
Dan
> -Original Message-
> From: [EMAIL PRO
If you only interested in getting the overall sum from the child tables you
could try the following:
1)
Change your child create statements to:
CREATE TABLE child1
(
auto_nr int(11) unsigned zerofill NOT NULL,
link int(11) unsigned ,
value int(11),
PRIMARY KEY auto_nr(auto_nr),
KEY link1_key(li
Hello all,
Suppose I have 3 tables,
1. master (auto_nr, link, dat)
CREATE TABLE master
(
auto_nr int(11) unsigned zerofill NOT NULL,
link int(11) unsigned zerofill NOT NULL,
dat DATE NOT NULL,
PRIMARY KEY auto_nr(auto_nr),
KEY link_key(link)
)
2. child1 (auto_nr, link1, value1)
CREATE TABLE c
Everyone,
Have u encountered this kind of query?
mysql> select edate from traffic where year(edate)='2001' group by
month(edate);
++
| edate |
++
| 2001-04-29 |
| 2001-05-01 |
| 2001-06-01 |
| 2001-07-01 |
| 2001-08-01 |
| 2001-09-01 |
| 2001-10-30 |
| 2001-11-01 |
Is there a timeline/status for 4.x functionality available?
I would like to use MySQL 4.x, however, I'm looking for some of the highly
requested functionality (ie; subselects, SP's, triggers and Views) and would
like to know where/when in the sequence of things todo does everything fall
into pl
Hi there,
the other comments may have got you where you want but as no one had
mentioned your final option thought I'd mention (from /h at the mysql
command line)
source (\.)Execute a SQL script file. Takes a file name as an
argument.
so you can run the script from the mysql prompt.
ch
>>alias mysql='mysql -u root -p"big_secret"'
Another, more reliable way, is to use the long-form options and say
mysql --user=root --password=big_secret
--
Shankar.
-
Before posting, please check:
http://www.mysql.com
James Austin wrote:
>
> I put this line (with no space after the -p) in the .bashrc file and
> sourced it;
>
> alias mysql='mysql -u root -p"big_secret"'
>
> It gets me in ok. Van suggested the mysql way putting this in a .my.cnf
> file in my home directory.
> [client]
> user=username
> passwo
Hi Byron,
On Fri, 2002-02-22 at 03:23, Byron Scott wrote:
> I have the following table:
>
> CREATE TABLE phpSP_users (
>primary_key mediumint(8) unsigned DEFAULT '0' NOT NULL auto_increment,
> [...]
>PRIMARY KEY (primary_key),
>KEY user (user),
>KEY primary_key (primary_key)
> );
I put this line (with no space after the -p) in the .bashrc file and
sourced it;
alias mysql='mysql -u root -p"big_secret"'
It gets me in ok. Van suggested the mysql way putting this in a .my.cnf
file in my home directory.
[client]
user=username
password=big_secret
I know this is basic stuff,
shockingly enough it works like this:
alias mysql='mysql -u username -p"password"'
On Thu, 21 Feb 2002, Paul DuBois wrote:
> At 14:30 -0800 2/21/02, James Austin wrote:
> >Yes. Thank you. Just put a pair of " around password and it works
> >fine. I had thought this could be handled in mysql,
At 17:18 -0500 2/21/02, John Fulton wrote:
>Neil,
>
>Thank you for giving me that idea. That exact syntax did not
>work with "=" but using "like" worked well. Problem solved.
You might find that using FIND_IN_SET('afternoons',availability)
works as well.
>
>Thanks,
> John
>
>
>mysql> select
At 14:30 -0800 2/21/02, James Austin wrote:
>Yes. Thank you. Just put a pair of " around password and it works
>fine. I had thought this could be handled in mysql, but hey, this
>works.
I don't see how it *could* work. When the password is given on the
command line, it must follow the -p with
On Thursday 21 February 2002 3:29 pm, 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";
Heh. It's been too long since I worked with SQL.
Thanks, that worked perfectly.
---
At 22:15 + 2/21/02, DL Neil wrote:
> >MySQL by Paul DuBoise
>>
>>Paul monitors this mailing list, so if you have questions concerning what
>>you've read, he may answer.
>
>You added an "e" to my name deliberately just to see if I'd reply,
>didn't you! :-)
>
>Not really, but because he thinks
On Thu, Feb 21, 2002 at 04:10:58PM -0500, Lou Picciano / Essex Systems wrote:
> Have a feeling I know the answer already, but here goes! ...
>
> Does anyone know if (and how) MySQL supports raw devices? I¹ve been
> searching the docs; can find nothing...
InnoDB can use raw devices.
--
Jeremy
actually someone sent an email to the list suggesting using .my.cnf file,
which is probably better than using the .bashrc file
On Thu, 21 Feb 2002, James Austin wrote:
> Yes. Thank you. Just put a pair of " around password and it works
> fine. I had thought this could be handled in mysql,
Yes. Thank you. Just put a pair of " around password and it works
fine. I had thought this could be handled in mysql, but hey, this
works.
rc wrote:
>
> one way would bein bash - edit your .bashrc file to include the
> following:
>
> alias mysql='mysql -u username -p password'
>
> On Th
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:
>MySQL by Paul DuBoise
>
>Paul monitors this mailing list, so if you have questions concerning what
>you've read, he may answer.
You added an "e" to my name deliberately just to see if I'd reply,
didn't you! :-)
Not really, but because he thinks you are Paul of Idaho!
=dn
---
I am trying to do an inner join between three tables. Here is what I have
tried:
select * from MapConfig LEFT JOIN ConfigString USING (id) LEFT JOIN ConfigInt
USING (id) WHERE MapConfig.layername = "Roads";
What I am trying to do is to pull back all rows from MapConfig associated
with matchi
Neil,
Thank you for giving me that idea. That exact syntax did not
work with "=" but using "like" worked well. Problem solved.
Thanks,
John
mysql> select availability FROM application;
+---+
| availability
Luc,
I new to this mailinglist ( this is my first posting) But I have worked a little
with replication.
Try if the replicator is still down.
set sql_slave_skip_counter = 1; slave start
on the slave as long as you are sure the master is ok.
Let me know is this worked.
-chad
On Thu, 21
On Thursday 21 February 2002 03:06, Heikki Tuuri wrote:
Oh, Duh. The bigger Oops was mine. Doesn't help much to have a transaction if
you don't ask for a lock! ;o). Thx.
> Oops,
>
> the syntax is
>
> SELECT ... FROM ... WHERE .. LOCK IN SHARE MODE;
>
> Heikki
>
> -Original Message-
> Fr
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 Emery wrote:
>MyS
At 13:25 -0600 2/21/02, Rick Emery wrote:
>MySQL by Paul DuBoise
>
>Paul monitors this mailing list, so if you have questions concerning what
>you've read, he may answer.
You added an "e" to my name deliberately just to see if I'd reply,
didn't you! :-)
>
>-Original Message-
>From: Dani
If I have a table with a set such as this:
CREATE TABLE application (
application_num int(6) NOT NULL auto_increment,
availability set('weekdays','weekends','mornings','afternoons')
default NULL, PRIMARY KEY (application_num)
) TYPE=MyISAM;
is it possible to search based on members of the s
James Austin wrote:
>
> Hi all,
>
> A novice question:
>
> How can I do away with having to use the -u user and -p password
> arguments every time I execute the mysql command? When I create a table
> with a script the only way I can get it to work is with the command:
>
> $> mysql samp_db -u
Hi all,
A novice question:
How can I do away with having to use the -u user and -p password
arguments every time I execute the mysql command? When I create a table
with a script the only way I can get it to work is with the command:
$> mysql samp_db -u root -p < create_member.sql
$> Enter pass
Hi,
I am running SuSE 7.3 Professional and i downloaded the binary files for Max
4.0 version from here: http://www.mysql.com/downloads/mysql-max-4.0.html
I followed the installation procudure to the letter from this file:
/mysql-max-4.0.1-alpha-pc-linux-gnu-i686/INSTALL-BINARY in the archive.
Have a feeling I know the answer already, but here goes! ...
Does anyone know if (and how) MySQL supports raw devices? I¹ve been
searching the docs; can find nothing...
Thanks - Lou
-
Before posting, please check:
http:/
Would anyone be able to tell me why this happened, and how I could fix it?
mysql> show slave status\G
*** 1. row ***
Master_Host: 209.217.92.34
Master_User: repslave2
Master_Port: 3306
Connect_retry: 60
Log_F
The bible is MySQL by PAul DuBois
ISBN: 0735709211
homepage: http://www.kitebird.com/mysql-book/
Gurhan
-Original Message-
From: Danis Stéphane (NHQ-AC) [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 21, 2002 2:08 PM
To: Mysql (E-mail)
Subject: MySQL Book
Any book you guys recom
On Thu, Feb 21, 2002 at 01:47:50PM -0500, Luc Foisy wrote:
>
> maybe the variable you are using is not right
>
> my 'show variables' indicates log with a value of OFF
> | log | OFF
>
> yet mysql still generates its standard error file
Hi Luc,
Thanks for the reply (but ple
Hi!
>> Or should I look at the InnoDB tables (which are still considered beta).
InnoDB tables are classified as gamma by Innobase Oy and MySQL AB. The text
on the MySQL-Max download page is lagging behind (says beta), but to balance
it, on the front page MySQL AB classifies MySQL-Max as stable
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
>Description:
>How-To-Repeat:
>Fix:
>Submitter-Id:
>Originator:root
>Organization:
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis: Install Crash : MySQL-3.23.49-1 /RedHat 7<>
>Severity:
>Priority:
>Category:
Any book you guys recommend for learning the specific strenght of MySQL, I'm
have a Oracle background and would like to learn more on MySQL.
Stephane
SQL, Query
-
Before posting, please check:
http://www.mysql.com/manual.php
020221 13:12:19 mysqld started
020221 13:12:20 /usr/local/libexec/mysqld: Can't find file:
'./mysql/host.frm' (errno: 13)
020221 13:12:20 mysqld ended
also it would be important to note /etc/my.cnf
[mysqld]
datadir=/usr/data/mysql
pid-file=/usr/data/mysql/tmcdbs01.mysql.pid
ahh could be a per
Hello,
Have a look at :
http://www.compagnie.com/stef/solution1.jpg
http://www.compagnie.com/stef/solution2.jpg
I'm searching for a solution to change a high traffic
mysql server with a
distributed system.
1)Is the solution 1 is good for a writing + reading
access ? Are there
problems with lock
I've encountered a similar problem which seems to stem from a "larger"
problem of MySQL thinking it's out of memory. It manifests itself in several
ways:
- when INSERT'ing a row into a table which stores binary data in a LONGBLOB
column, I get one of several "out of memory" errors ("Out of memory
Using foreign keys is a really, really good idea. Programs can't be
trusted (and what about running sql queries ad hoc). Even with a really
big database I wouldn't get rid of the keys, just time to move to a
bigger better machine/configuration.
-Original Message-
From: David Felio [mail
maybe the variable you are using is not right
my 'show variables' indicates log with a value of OFF
| log | OFF
yet mysql still generates its standard error file
even though this is not a standard variable, it is the variable used in
safe_mysqld, perhaps you could add this
Ok. I do indeed have /usr/local/etc/rc.d/mysql-server.sh
And oops I do have /usr/local/libexec/mysqld
Are these supposed to be started up automatically?
I tried to run /usr/local/etc/rc.d/mysql-server.sh start
TMCBSD101# mysql-server.sh start
mysql-server.sh: Command not found.
On Thu, Feb 21, 2002 at 01:02:02PM -0500, Luc Foisy wrote:
> Does mysql have permission to write to that location?
Yes. I'm starting and stopping MySQL using an init script a la Redhat.
This calls 'safe_mysqld' with some args (e.g. --user,--pid-file etc.) -
all started as user root as usual.
The
In the last episode (Feb 21), Luc Foisy said:
> I didn't pick the operating system( I don't know it well at all ),
> and didn't do the install of mysql on this system, but now I have to
> figure out where things are and how to fix it. What I am use to, is
> installing on Red Hat with the rpm. ( if
Does mysql have permission to write to that location?
-Original Message-
From: alastair [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 21, 2002 10:33 AM
To: [EMAIL PROTECTED]
Subject: Logging problem with --log, my.cnf etc.
Hello,
I am using MySQL 3.23.36 on Linux. This is a small
Dennis Wu wrote:
> I have a table with a column defined as BLOB. However, when I dump
> this table using ./mysqldump, the dump file cannot be imported. Is
> that because a binary field cannot be dumped into a text file? Any
> solution if I really need to do the backup by dumping the table?
W
I didn't pick the operating system( I don't know it well at all ), and
didn't do the install of mysql on this system, but now I have to figure out
where things are and how to fix it.
What I am use to, is installing on Red Hat with the rpm. ( if someone knows
the differences in the operating syste
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
>Description:
I'm seeing random hung reads() after a mysql insert that appears to be
related to a sig alarm race condition. The basic workflow of this program
is
while (1)
recvfrom() /* few hundred packets a sec */
parse packet
insert into sql
However, once per second a sig alarm is ge
I have the following table:
CREATE TABLE phpSP_users (
primary_key mediumint(8) unsigned DEFAULT '0' NOT NULL auto_increment,
user varchar(50) NOT NULL,
password varchar(30) NOT NULL,
userlevel smallint(3) DEFAULT '0' NOT NULL,
service_name varchar(50) DEFAULT 'A Childs Place',
I am having problems connecting to the mysql databse from a Java application in
Windows 2K, I am using JDBC and have the mySQL odbc software installed. I am running
mysql from the command line prompt in Windows 2k. I fear I may be doing something
wrong, if anyone has a step by step solution, i
Varshavchick Alexander <[EMAIL PROTECTED]> writes:
> Gentlemen,
>
> Can you advice please if I'd wish to change the database format from
> myisam to innodb should I upgrade to mysql 4.0 to get better performance
> and stability, or switching to innodb alone under 3.23 will do the
> trick?
Switc
On Thu, Feb 21, 2002 at 10:17:52AM -0600, Scalper wrote:
> I am a new MySQL user, so forgive my stupidity for asking the
> following question (perhaps taboo). What is the latest on NuSphere
> vs MySQL AB? What about Gemini. I have searched everywhere for
> info, but can't seem to find anything
>Description:
>How-To-Repeat:
>Fix:
>Submitter-Id:
>Originator:root
>Organization:
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis:
>Severity:
>Priority:
>Category: mysql
>Class:
>Release:
Gentlemen,
Can you advice please if I'd wish to change the database format from
myisam to innodb should I upgrade to mysql 4.0 to get better performance
and stability, or switching to innodb alone under 3.23 will do the trick?
What brings more effect - innodb/myisam types or 4.0/3.23 versions of
Hi,
I have the following problem:
I had to install a complete new server with Suse 7.2 (MySql: 3.23.37-8).
>From the the old installation I only got the backup files (created with
'mysqldump database > my_databases.sql') and the the database file (ISD,
ISM, frm).
My problem is: I can't read th
I have a MySQL InnoDB table for ACH (checking account) transactions that
includes, among other fields, the below:
trans_id (PRIMARY KEY)
cust_type
routing_num
status
site_id
payment_type
auth_type
trans_type
trace_num
All of the above fields (except the primary key) are related to other
tables th
Yes, this problem is happening at the 'make test' step
while installing these modules... I have performed
the perl Makefile.PL, and the make, they seem to go
ok, just when I perform the make test, it seems to
fail with this relocation and symbol errors
--- Ken Menzel <[EMAIL PROTECTED]> wrot
I am a new MySQL user, so forgive my stupidity for asking the following
question (perhaps taboo). What is the latest on NuSphere vs MySQL
AB? What about Gemini. I have searched everywhere for info, but can't
seem to find anything after November of last year.
I have serious needs for transac
Hi Darren,
The tests rely on the perl BDB and mysql-modules packages for perl.
Have you installed and tested these?
Ken
- Original Message -
From: "Darren Ball" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, February 21, 2002 10:27 AM
Subject: PERL DBB::MYSQL MAKE TEST PROB
Andrew,
Thursday, February 21, 2002, 3:31:16 AM, you wrote:
AB> I have created a table in the mysql db, using phpmyadmin with the following
AB> statement:
AB> create table books
AB> ( isbn char(13) not null,author char(30),title(60),price float(4,2),primary
AB> key(isbn));
AB> which works fine
Thanks for the advice ... I'll take a look at dbg2 ... if I get stuck, I'll
shoot you a plea for help!
Gerald Jensen
-Original Message-
From: BD [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 21, 2002 9:38 AM
To: Gerald R. Jensen
Cc: [EMAIL PROTECTED]
Subject: Re: MySQL PHP Developm
At 06:37 AM 2/21/2002 , you wrote:
>This off topic, but one of our programmers is interested in NuSphere's PHPEd
>development interface and I would liek some feed back from other users.
>
>His interest lies not so much in using for database table modeling, but for
>PHP and Perl development. I am w
Hello,
I am using MySQL 3.23.36 on Linux. This is a small gripe about a product
I am otherwise very happy with. I hope I have not missed the obvious or
been stupid some other way.
The problem - I want to log somewhere other than $DATADIR. Things are
set up like ;
| log | ON
InterAKT produce a Dreamweaver Ultradev extension called Phakt that is
pretty good. It creates PHP scripts that manipulate MySQL databases. It is
free and allows comparable functionality to the 'native' UltraDev languages
(ASP, JSP, Cold Fusion).
For more info - http://www.interakt.ro/products/PHA
I've been having some troubles install dbd::mysql on
Solaris 2.4 - make test is failing and I can't figure
out what is going wrong. The following shows the
results coming back from make test
If anybody can help me out here, I would appreciate
it. Thanks.
make[1]: Entering directory
`/hom
InterAKT produce a Dreamweaver Ultradev extension called Phakt that is
pretty good. It creates PHP scripts that manipulate MySQL databases. It is
free and allows comparable functionality to the 'native' UltraDev languages
(ASP, JSP, Cold Fusion).
For more info - http://www.interakt.ro/products/PH
Ive just downloaded Mysql Max 4.0 binary distribution
for Windows ...
Does this distribution supports Innodb tables ?
How do I turn on this feature ?
I follow the instruction (modifying my.ini to include support for innodb )
buy Mysql does not start ( I am using Winmysqladmin ) and I am using
my
There is three options I use:
1. Macromedia Dreamweaver UltraDev4 with a PHP plugin or extension
2. PHPEdit, its free I forget the website. Its a good IDE, but kinda
annoying editor.
3. Notepad
-Original Message-
From: Joel Wickard [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 22
This worked for me:
create table tblZips(
id int unsigned not null auto_increment primary key,
city char(24) not null default '',
state char(2) not null default '',
zip char(5) not null default ''
) Type=InnoDB;
Saved CSV file as a UNIX (instad of DOS format file)
LOAD DATA
INF
> This off topic, but one of our programmers is interested in NuSphere's
PHPEd
> development interface and I would liek some feed back from other users.
>
> His interest lies not so much in using for database table modeling, but
for
> PHP and Perl development.
If he's not really that interes
Hi,
Clive Arnold wrote :
>
> Apart from timestamp are there any other fields that will automatically generate
>data for themselves when a new record is created ?.
>
> I'm having trouble using timestamp with Macromdia Dreamweaver so something that just
>generates a unique number for each recor
Theo,
Wednesday, February 20, 2002, 6:37:15 PM, you wrote:
TVS> Hello,
TVS> I am new with MySQL and have it running on Windws 2000 server and
TVS> programming with VC++ 6.0
TVS> Now converting from SQL 7.0 to MySQL
TVS> I wonder if there is a way to print out the data structure of the
TVS> ta
Clive,
Thursday, February 21, 2002, 3:22:47 PM, you wrote:
CA> Apart from timestamp are there any other fields that will
CA> automatically generate data for themselves when a new record is
CA> created ?.
CA> I'm having trouble using timestamp with Macromdia Dreamweaver so
CA> something that j
Geoff,
Thursday, February 21, 2002, 1:33:47 PM, you wrote:
GD> Hi
GD> Apols for being dense but I have basic problem with
GD> MySQL for Win98.
GD> I have downloaded and unzipped
GD> mysql-3.23.47-win-src.zip
GD> The next step is to do the setup.exe but there is no
GD> file called this. So how
Natalino,
Thursday, February 21, 2002, 1:46:11 PM, you wrote:
NP> Hi,
NP> I found that mysql doesn't used indexes if there is a <> in the where
NP> statement...
NP> for example
NP> mysql> explain select * from testtable where id <> 5;
NP> +-+--+---+--+-+-
Neil,
Thursday, February 21, 2002, 12:18:27 AM, you wrote:
NZ> Hello,
NZ> I searched the manual but it seems like MySQL does not support ANSI SQL
NZ> CHECK constraints. These are often used to check that rows inserted into
NZ> tables meet specified criteria. For example table T created as follo
Jorge,
Wednesday, February 20, 2002, 7:44:50 PM, you wrote:
JG> Hello
JG> I'm new to MySQL, Unix and Replication.
JG> I would like to know if in a scenario where I have one master and
JG> several slaves I can convert one of the slaves to master in the event
JG> my master goes down.
It will be a
>His interest lies not so much in using for database table modeling, but
for
>PHP and Perl development.
>How does PHPEd stack up compared to other PHP IDE's? What experience (good
>or bad) has anyone had with it? Is there another product that is better?
I've just finished using Quanta+ for doin
Apart from timestamp are there any other fields that will automatically generate data
for themselves when a new record is created ?.
I'm having trouble using timestamp with Macromdia Dreamweaver so something that just
generates a unique number for each record would be good e.g 1,2,3,4,5,6,7, ..
This off topic, but one of our programmers is interested in NuSphere's PHPEd
development interface and I would liek some feed back from other users.
His interest lies not so much in using for database table modeling, but for
PHP and Perl development. I am well aware of the conflict a few months a
Hi,
I have the following problem:
I had to install a complete new server with Suse 7.2 (MySql: 3.23.37-8).
>From the the old installation I only got the backup files (created with
'mysqldump database > my_databases.sql') and the the database file (ISD,
ISM, frm).
My problem is: I can't read the b
On Thursday, 21. February 2002 12:46, Natalino Picone wrote:
> Hi,
> I found that mysql doesn't used indexes if there is a <> in the where
> statement...
> for example
> mysql> explain select * from testtable where id <> 5;
It would only make sense to use an index, when you want to select the id
Hi Geoff,
> Apols for being dense but I have basic problem with
> MySQL for Win98.
Perhaps not "dense", just baffled by 'new' terminology.
You appear to have downloaded the source code.
If you want to download MySQL and not have the extra, compile, step to negotiate, then
find the *-win.zip
opt
Hi,
I found that mysql doesn't used indexes if there is a <> in the where
statement...
for example
mysql> explain select * from testtable where id <> 5;
+-+--+---+--+-+--+---++
| table | type | possible_keys | key | key_len | ref | rows
Hi
Apols for being dense but I have basic problem with
MySQL for Win98.
I have downloaded and unzipped
mysql-3.23.47-win-src.zip
The next step is to do the setup.exe but there is no
file called this. So how do I proceed?
(There is a small zip program also on the download
page, but this is 'not a
1 - 100 of 104 matches
Mail list logo
