Hi,
I've just started with MySQL. I want my table to have a column containing
an ID which is an integer that gets incremented on each insert, just like
Autonumber in Microsoft Access. How do I do this in MySQL ?
Thanks
Dave
hi,
I'd like to calculate hour usage between 2 time value. Which data type I
should to use in mysql? and how to write sql to calculate hour usage
especially when the second time is in the next day??
Thanks
SF
-
to find out where your files ended up:
cd /
find . -name mysql
mine weren't where I expected, but even so MySQL runs just fine where they
are ;)
At 04:38 17/10/01 -0700, you wrote:
The MySQL manual refers to files in /usr/local/.
/usr/local/ in RH7.1 is empty.
Could this be the reason why I'm
Hi
Use Create Table Test
(
ID INT NOT NULL AUTO_INCREAMENT,
..
);
At 08:48 18/10/2001 +0100, Dave Prout wrote:
Hi,
I've just started with MySQL. I want my table to have a column
containing
an ID which is an integer that gets incremented on each insert, just like
Hi John,
looks like an error: AUTO_INCREMENT s the right spelling.
Gerald
*G*
-Ursprungliche Nachricht-
Von: John Dean [mailto:[EMAIL PROTECTED]]
Gesendet: Donnerstag, 18. Oktober 2001 10:38
An: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Betreff: Re: Newbie question
Hi
Use Create Table
MySQL Version: 3.23.42-max-nt
MyODBC Version:2.50.39
OS Version= Windows 2000 Server
If I change the order of fields in a multi-column primary key table,
I cant update the table with SQLSetPos.
ie: If I declare my table :(Primary key fields's order is the same as in table)
create table A( name
MySQL Version: 3.23.42-max-nt
MyODBC Version:2.50.39
OS Version= Windows 2000 Server
If I change the order of fields in a multi-column primary key table,
I cant update the table with SQLSetPos.
ie: If I declare my table :(Primary key fields's order is the same as in table)
create table A( name
Hi all
I'm having a problem getting a query to work where I want to compare the
current_timestamp to the logged timestamp, and return false if less than 300
seconds, can you tell me if it is possible to have the current timestamp
returned as part of a query, so as I can then do my calculations in
Hello all;
I'm running several MySQL installation (all version 3.23.37 under Linux)
under what I presume are some fairly harsh conditions, and wondered what
circumstances cause tables to be corrupted and need fixing with myisamchk.
This is happening once every few days and it's becoming a pain.
Hi
I never could spell :o)
At 10:54 18/10/2001 +0200, Gerald-Markus Zabos wrote:
Hi John,
looks like an error: AUTO_INCREMENT s the right spelling.
Gerald
*G*
-Ursprungliche Nachricht-
Von: John Dean [mailto:[EMAIL PROTECTED]]
Gesendet: Donnerstag, 18. Oktober 2001 10:38
An: [EMAIL
Dear Sir,
I have a problem with mysql-3.23.43 installation during the
configuration step on Solaris 2.7 with Netscape Enterprise Server. The last
three lines are shown as below :
checking for a BSD compatible install... ./install-sh -c
checking for bison... bison -y
checking for
Okay i manage to build mysql++ after building gcc 2.95.3.Now i have problem
in making c++ programs to run with mysql++.
I try to compile the following code
#include sqlplus.hh
#include iomanip.h
#include iostream.h
int main()
{
connection conn(mysql);
Query query = conn.query();
You didn't appear to answer last time (grump) - reply repeated below.
=dn
- Original Message -
From: Adrian D'Costa [EMAIL PROTECTED]
To: Mysql Mailing List [EMAIL PROTECTED]
Sent: 18 October 2001 05:34
Subject: how to get the correct result -- Thrid Time --
Hi,
I have some
Im currently in a debate with someone who prefers PostgreSQL. He says that
MySQL is unstable etc. Can you please give me examples of some well known
sites built on MySQL so I can tell him that MySQL rocks?
Sorry if this is off-topic. But atleast im patriotic :)
/Philip
Eurobell.net Eurobell.com Eurobell.co.uk
We have been runing MySQL over 3 year 24/7/362 and it has never gone
down.
Simon
-Original Message-
From: Philip Johannessen [mailto:[EMAIL PROTECTED]]
Sent: 18 October 2001 12:06
To: [EMAIL PROTECTED]
Subject: What sites?
Im currently in a
On Thu, 18 Oct 2001, Philip Johannessen wrote:
Im currently in a debate with someone who prefers PostgreSQL. He says that
MySQL is unstable etc. Can you please give me examples of some well known
sites built on MySQL so I can tell him that MySQL rocks?
Have a look at http://www.20min.ch/.
You can use NOW() to get the current timestamp:
mysql select NOW();
+-+
| NOW() |
+-+
| 2001-10-18 12:49:29 |
+-+
But it would be easier to let MySQL calculate the elapsed time:
select
IF(TIME_TO_SEC(NOW()) -
You may see list of this sites at MySQL manual:
http://www.mysql.com/doc/U/s/Users.html
On Thu 18 Oct 2001 14:05, Philip Johannessen wrote:
Im currently in a debate with someone who prefers PostgreSQL. He says that
MySQL is unstable etc. Can you please give me examples of some well known
Hi,
i have a problem when executing big selects.
i am using mysql in a client - server environment.
the server database is a mysql database, whereas the
clients are MS Access databases, contining forms, queries, reports
and a lot of VBA code. The tables of the mysql
I just saw the mistake I made in my original post.. I want to Order By
letter, but when I do that with the Limit clause the results are as
shown in the original post.. Anyone know what the problem could be?
Steve Meyers wrote:
That is actually how it is supposed to work -- MySQL gets all the
Neal Probert writes:
Both the alter-table and insert tests in the sql-bench suite fail if the
default-table-type=BDB is set in /etc/my.cnf. This is with version 3.23.43.
Anybody got any ideas about this?
--
Neal Probert [EMAIL PROTECTED]
!Uniphied Thoughts, LLC.
What is the
*This message was transferred with a trial version of CommuniGate(tm) Pro*
Hi,
I need to select from a table all the records that do not contain a certain
string. Any idea how I can do this?
For example if I want to select all the fields that contain the string
my_string I type:
$ select *
I had mysql running fine on linux (redhat 7.1 ).
Today I get this error: can't connect to local Mysql server through socket
'/tmp/mysql.sock.'
Thanks for any advice.
-
Before posting, please check:
Hi Philip!
On Thu, 18 Oct 2001, Philip Johannessen wrote:
Im currently in a debate with someone who prefers PostgreSQL. He says that
MySQL is unstable etc. Can you please give me examples of some well known
sites built on MySQL so I can tell him that MySQL rocks?
At http://www.mysql.com see
Hi
I've been trying to answer this question for a while with no success :) I
know someone here has the answer!
As part of my backup, I have the following line in the my.cnf
# Activate Update Log
log-bin=update-bin.log
I then run a script by logrotated every night, the config file is:
# This
CA $ select * from table_name where column_name like %my_string%.
select * from table_name where column_name NOT like %my_string%.
;)))
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
Ciprian A. wrote:
Hi,
I need to select from a table all the records that do not contain a certain
string. Any idea how I can do this?
For example if I want to select all the fields that contain the string
my_string I type:
$ select * from table_name where column_name like %my_string%.
AJDIN BRANDIC writes:
I am running MySQL 3.22.30 and UPDATE IGNORE is failing. Was this
function introduced in some later version?
Probably. You really should consider upgrading. 3.23 has been
out for ages now.
What is a work around?
I fail to see a situation where you would actually
Thanks for your reply, I have tried using the query as you suggest, see
below:
SELECT user_ip IF(TIME_TO_SEC(NOW()) - TIME_TO_SEC(log_time) 300, 'true',
'false') FROM clinic_log
But this just gives me an error, ie the query won't run?
Does the query seem to be right?
Thanks again
Paul
-
Hi
I have installed mysql 4.0 from source, configured with
./configure \
--with-charset=latin1_de
--
Matthias Ragaz
Informatik - Entwicklung
Schweizerische Bibliothek für Blinde und Sehbehinderte
Albisriederstasse 399
CH-8047 Zürich
Dear All
I've reverted back to 3.23.43 from 4.0.0 as I was unable to get it to
start on my (patched) Redhat 6.2 box.
Has anyone else managed to get the binary distro of 4.0.0-alpha to
start on a Redhat 6.2 box ?
Thanks
Greg
sql
Hello,
I am working on a school project and I want to use mysql db, as a back end.
Anyway, I want to make a column really large. Paragraph size. I know I can
use varchar and make it large, but is that the best way to go, and if so
what is the max size you can use for a varchar?
The user will put
You may also want to point him to this article on PHPBuilder.com
http://phpbuilder.com/columns/tim2705.php3
I've just read it and it seems appropriate.
No it isn't a PHP centered article. It does a pretty good comparison (in my
mind) of the plusses and minuses of both MySQL and PostgreSQL
Hi
I have installed mysql 4.0 from source with
./configure \
--with-charset=latin1_de
--with-extra-charsets=all
Question 1: Is it true that the above does not make latin1_de my default
character set for sorting?
When I tried to set the default character set to latin1_de in
I have a mySQL database that I am trying to bring into SQL7. I have tried
using the enterprise manager of SQL 7 to import the data, however the table
that I am trying to import has many blob fields, which do not come over with
the import. SQL Enterprise manager either tells me that the field is
Make it a text column, this has an allowable length of 0-65535 ..
HTH
Paul
- Original Message -
From: Purcell, Scott [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, October 18, 2001 2:12 PM
Subject: Large Memo Type Field
: Hello,
: I am working on a school project and I
You might want to add an ORDER BY clause.
Sommai Fongnamthip wrote:
Hi,
did someone tell me why group by clause not work? I'd like to group
volume of order from my customer at the same price and my supplier.
here is my code
Select custid, symbol, sum(volume) as sumvol,
Thanks, the query is now working, butit is not producing the required
results. I have now tried many different methods, it does not seem to me to
be possible to compare these times!!
Thanks anyway
Paul
- Original Message -
From: Torgil Zechel [EMAIL PROTECTED]
To: 'p.whiter' [EMAIL
LAST_INSERT_ID()
At 08:48 AM 10/18/2001 +0100, you wrote:
Hi,
I've just started with MySQL. I want my table to have a column
containing
an ID which is an integer that gets incremented on each insert, just like
Autonumber in Microsoft Access. How do I do this in MySQL ?
Thanks
Dave
At 11:06 PM -0500 10/17/01, David Dahl wrote:
WOW, now you can BUY MySQL from blueworld and run it on MacOS X and
Windows 2000 only, or you can download the source code from MySQL and
run it anywhere for free... hmmm... sounds great:)
Bill Adams writes:
Seriously, is there a better forum
Hello Daniel!
I had mysql running fine on linux (redhat 7.1 ).
Today I get this error: can't connect to local Mysql server through socket
'/tmp/mysql.sock.'
Shooting[trouble] tips:
Does 'cat /etc/my.cnf |grep socket' confirm the path to the sock for both
server and client? Should be yes if
Description:
parsing/executing aggregates involving IF() statements. Everything needed
to reproduce the bug available from
http://www.ebi.ac.uk/~lijnzaad/mysql/bugreport.tar.gz
It's tested and reproduced on MySQL, version 3.23.32 on TrueUnix (two bugs)
or version 3.22.32 on
Hi all-
I know this might seem simple, but for some reason I'm stumped. What I'm
trying to do is get a count (from one table) of all the distinct values in a
particular field. So for example, I'd be trying to find out how many unique
email addresses are in the table.
Right now I'm doing this
Hi,
I have just stated with JDBC and MySQL. I just don't know how to start playing
with them. How to set up a test database? How to get a datasource? What's the
URL of a datasource? There are a whole lot of help on how to connect, but just
very few about how to load the driver and create a
hi.
store the information in a datetime column for easy handling.
check out the function DATE_ADD() or DATE_SUB() on this page:
http://www.mysql.com/doc/D/a/Date_and_time_functions.html
it has examples of usage that could be helpful.
i would do something like this:
select TO_DAYS(secondDate) -
Thanks for the help everyone. I tried changing the type to timestamp¹ and
that did not fix the problem, however when I changed the type to
int¹ and it worked as it was suppose to.
Thanks,
Lael
Hello Leon,
Thursday, October 18, 2001, 5:09:13 PM, you wrote:
LN A quick query, in the directory /usr/local/mysql/var there are
LN machinename-bin.001, 002, 003 etc files that are being created. What are
LN these files and what do they do. Can I get rid of them as they are taking up
LN massive
Try tuning mysql for faster queries.
You could try indexing you domain name, If you have data fields which have a
common value you can index the rest of the rows by the one common value.
Takes up a bit more space but is faster.
more info @
I found a MySQL system variable
max_binlog_cache_size| 4294967295
would caching have anything to do with it rather than replication?
thanks
Leon.
-Original Message-
From: SAE's System Administrator [mailto:[EMAIL PROTECTED]]
Sent: 18 October 2001 15:22
To: Leon Noble
Cc:
Thanks Matthias, Jay... I gave that a shot and got an error:
mysql select count(distinct email) from subscribes;
ERROR 1064: You have an error in your SQL syntax near 'distinct email) from
subscribes' at line 1
I have a feeling this has something to do with running 3.22 instead of 3.23.
;)
select count(distinct(email)) from subscribes;
select count(distinct email) from subscribes;
should work just fine
Magic word: sql
--
_/_/ _/_/_/ - Rafa Jank [EMAIL PROTECTED] -
_/ _/ _/ _/ _/ Wirtualna Polska SA http://www.wp.pl
_/_/_/_/
Adrian D'Costa writes:
If you 'office system' is, for example, Sun Solaris, you will see only
1 mysqld process with 'top'. The fact that in Linux 'top' shows
actually more than 1 process can be regarded as a bug in the way 'top'
shows things on Linux for threaded applications (same
select count(distinct(email)) from subscribes;
But that's not legal. Any thoughts/ideas you all could send in would be
great. TIA!
Chris Blessing
[EMAIL PROTECTED]
http://www.330i.net
Try:
select count(distinct email) from subscribes;
Jay Fesco
Magical Mystery Words:
Hello,
I'm reading and doing some testing with Specialized SQL Structures.
I've included both mysql++ and custom-macros.hh . I'm using MSVC as
compiler.
The problem I'm facing is that I can't get it compiled. I get undeclared
identifiers
syntax error : identifier 'sql_dummy_type'
'sql_dummy'
Thankfully we're upgrading in the very near future (this weekend) so I can
take advantage of this and other changes (like temp table memory issues!).
Thanks again for everyone's help!
-Chris
-Original Message-
From: Jay Fesco [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 18, 2001
Hi,
I habe a problem with replication on mysql 3.23.31:
If I issue an ALTER TABLE command at the master, it is not send
to the slaves when the table name is qualified with the database
name.
eg. this doesn't replicate:
ALTER TABLE `database`.`ReplicationTest` ADD `einezahl` INT
DEFAULT
Good reply, Cathy.
I'm not sure why there is such an outspoken negative reaction to a
commercial software company announcing a related product on a mysql
list...Not only can Mysql AB be considered a commercial software company,
but so could myself and many others on this list.
For the record, I
cedric [EMAIL PROTECTED] writes:
The MySQL manual refers to files in /usr/local/.
/usr/local/ in RH7.1 is empty.
Could this be the reason why I'm having so much trouble installing MySQL?
If so, how can I get rpm to install MySQL in /usr/local/?
Files managed by rpm shouldn't be in
I want to import data from text file that contains decimal number
(occasionaly with 9 decimal) but mysql import only 2 decimal.
My columns is set to DECIMAL(6,9)
Hi, Moreno
-
Before posting, please check:
When running MySQL when only got as far as trying to set up users and
passwords for MySQL using 'mysqladmin' before mysqld restarted. This also
happens when connecting to Mysql with clients we have written and also the
'mysql' program and other MySQL utilities suggesting the problem is not with
I am sending this again as I am desperate for some help and believe
this to be a signifigant bug if it actually is one...which it seems to
be. See below for examples.
What is quite puzzling is MySQL's estimation of the number of rows
from each of the self-joins. The conditions on alias
The harm doesn't come from you offering something beneficial to the MySQL
community. It comes when you abuse the privileges of being on this list and
send spam. While there may not be anything in stone that says not to send
commercial software advertisements, you should know better. The only
Hey there,
first off all, please CC me any replies, as I'm no longer a member of the
list... Sorry about that but I just receive too much... Over 2000 emails a
day is no exception and I can no longer keep track of them.
Ok, for the problem, I want to list the possible values of a enum
HI!
Please try our latest 3.23 version and see if problems still persists.
There have been a few bug fixes since 3.23.32 regarding IF().
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED]
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB,
Riccardi Moreno wrote:
I want to import data from text file that contains decimal number
(occasionaly with 9 decimal) but mysql import only 2 decimal.
My columns is set to DECIMAL(6,9)
Someone correct me if I am wrong: The '9' is how many decimal places after
the period you want and eats up
Well, for one, I believe that Slashdot uses InnoDB tables, which tend to handle a
little better under very high load.
Steve Meyers
-Original Message-
From: Matthew Bloch [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 18, 2001 3:34 AM
To: [EMAIL PROTECTED]
Cc: Peter Taphouse;
Trim won't work because the newline is in the middle of the string. Try using the
REPLACE function, ie
UPDATE hotel SET nome_hotel=replace(nome_hotel, '\n', '')
For the second question, it actually doesn't matter if it's CAPS or not. The group by
will be done in a case insensitive manner.
Ravi Raman wrote:
I'm not sure why there is such an outspoken negative reaction to a
commercial software company announcing a related product on a mysql
list...
As another poster pointed out, this is a HELP list. If someone posted to the
list looking for a product where Lasso meets that
Hi Riccardi,
I want to import data from text file that contains decimal number
(occasionaly with 9 decimal) but mysql import only 2 decimal.
My columns is set to DECIMAL(6,9)
Hi, Moreno
try
DECIMAL(15,9)
because I think the first argument specifies the total number of digits.
Anton
I have the same problem with RedHat 7.1 (fully updated) and a Pentium.
Any answer/solution?
-Mensaje original-
De: Jean-Luc Fontaine [mailto:[EMAIL PROTECTED]]
Enviado el: miercoles, 17 de octubre de 2001 9:33
Para: [EMAIL PROTECTED]
Asunto: redaht 7.1 / AMD K6-2: 4.0 rpm error (illegal
It would help if you posted the actual query and results you are getting, instead of
showing simulated results. You mention the query below in your first post, but you
never give the actual results of it.
Steve Meyers
-Original Message-
From: Ashwin Kutty [mailto:[EMAIL
Philip Johannessen wrote:
Im currently in a debate with someone who prefers PostgreSQL. He says that
MySQL is unstable etc. Can you please give me examples of some well known
sites built on MySQL so I can tell him that MySQL rocks?
PostgreSQL: Unless something has changed in the more recent
Matthew Bloch wrote:
I'm running several MySQL installation (all version 3.23.37 under Linux)
under what I presume are some fairly harsh conditions, and wondered what
circumstances cause tables to be corrupted and need fixing with myisamchk.
This is happening once every few days and it's
Elm Gysel writes:
Hello,
I'm reading and doing some testing with Specialized SQL Structures.
I've included both mysql++ and custom-macros.hh . I'm using MSVC as
compiler.
The problem I'm facing is that I can't get it compiled. I get undeclared
identifiers
syntax error : identifier
Hi!
Well, for one, I believe that Slashdot uses InnoDB tables, which tend to
handle
a little better under very high load.
Steve Meyers
-Original Message-
From: Matthew Bloch [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 18, 2001 3:34 AM To: [EMAIL PROTECTED]
Cc: Peter Taphouse;
Since it's a LIKE, you need to put the table name in quotes:
SHOW COLUMNS FROM test LIKE 'Var'
This also allows you to use things like 'Var%' in you query.
Steve Meyers
-Original Message-
From: TD - Sales International Holland B.V. [mailto:[EMAIL PROTECTED]]
Sent: Thursday,
Good morning:
My vendor (Campus Pipeline) directed me to your website to obtain some
documentation, but they did not specify the title of the documentation
to retrieve. I am to locate information on performing data recovery
with update logs and repair scripts. Can you please direct me to the
You never considered reading the manual, eh?
Look up types in the manual - check out TEXT type
-Jason Garber
IonZoft.com
At 08:12 AM 10/18/2001 -0500, Purcell, Scott wrote:
Hello,
I am working on a school project and I want to use mysql db, as a back end.
Anyway, I want to make a column
Hi all,
Is it possible to define an enumeration as a new MySQL data type and then
define columns using the user defined type?
I've heard that you can produce aliases for types but I can't find anything
in the manual about doing this for ENUMs.
Thanks for your help,
Chris
Hi,
I am experiencing a very slow performance while I am building an index on a
table. The following are some facts of system and the table I am dealing
with:
Table size: 13,857,354
Number of distinct value in the column I use as index: 176,322
Platform: Linux system with dual CPUs 1G Hz and 4G
Replying to myself just HAS to be in bad taste. But I guess I burt out my taste
buds a while ago. ;)
Bill Adams wrote:
Ravi Raman wrote:
I'm not sure why there is such an outspoken negative reaction to a
commercial software company announcing a related product on a mysql
list...
As
I am a new mysql user. I have been unable to start mysql on my laptop running
Windows 2000. Each time I start mysql, I get the following error:
ERROR 2003: Can't connect to MySQL server on 'localhost' (10061). I have
searched through the archive for earlier mails on this problem. This looks like
In the last episode (Oct 18), Terry Westry said:
Good morning:
My vendor (Campus Pipeline) directed me to your website to obtain some
documentation, but they did not specify the title of the documentation
to retrieve. I am to locate information on performing data recovery
with update logs
Point well taken.. The query is as follows:-
SELECT * FROM dddeli WHERE title LIKE %$keyword% ORDER BY title desc LIMIT
$start,$end;
Where $keyword is the keyword to search by from the field title, $start
and $end are to dictate which page of the results, etc..
title is varchar(128)
and
Hi,
This is complete crap. One of the tools I use is because of an email I saw
on this list that might have been called spam.
I say that this type of email is on topic. Maybe they could have eased up on
the BS tone of the email, but I would still want to know about a new
product. The only other
Please try our latest 3.23 version and see if problems still persists.
Yes, it also occurs for mysqld Ver 3.23.43 for pc-linux-gnu on i686.
Please try and reproduce it using
http://www.ebi.ac.uk/~lijnzaad/mysql/bugreport.tar.gz.
Hello All!
would be cool. Or another moderated list that contains announcements for all
things MySQL related. I would sign up for that 'though I think a web-site
would be better.
http://www.mysql.com/documentation/lists.html :
[EMAIL PROTECTED] announce
This is for announcement of new
I agree.
The attitude I have towards MySQL-related announcement messages on this list
is roughly the same as the attitude I have towards all the other
messages...read them if they look interesting, ignore them if they don't. I
really doubt most people read _every_ message on this list, and if
Eric,
That's nice and all that you can have an extra tool to use because of spam -
I mean, they ARE real products. Most people consider TV infomercials to be
useless, but some people find use out of them. The problem is that it's
annoying to see these types of advertisements. The reason you don't
At 10:21 AM -0700 10/18/01, Bill Adams wrote:
Now that I have had some coffee I am thinking that the subjects like
URGENT! HELP NEEDED are just the worse ever. Cathy, Please just fix the
capitalization from your marketing dept. the next time and I for one will not
complain. And rest assured
Hi !!!
-Original Message-
From: Cenk Akyüz [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 18, 2001 1:55 AM
To: [EMAIL PROTECTED]
Subject: MyODBC:Update with SQLSetPos doesnt work with some kind of
primary keys?
MySQL Version: 3.23.42-max-nt
MyODBC Version:2.50.39
OS
Carsten H. Pedersen wrote:
What about FAQ-o-Matic?
http://faqomatic.sourceforge.net/
We would just need it hosted somewhere.
Not to put a too fine point on it, but how 'bout
referring them to: http://www.bitbybit.dk/mysqlfaq?
I thought this address was well published by now, but
I do keep forgetting about it. And it seems that MySQL has a 'Dynamic FAQ'
linked from their site. Perhaps we could get them to add a link to the
bitbybit version too? (MySQL Folks?)
Ideally linked from this page:
http://www.mysql.com/documentation/index.html
Hi!
Michael == Michael T Babcock [EMAIL PROTECTED] writes:
Michael On Wed, Oct 17, 2001 at 12:49:26AM +0300, Michael Widenius wrote:
We agreed a long time ago with NuSphere that the small hooks would be
copyrighted by MySQL AB, but as the concrete paperwork has not been
signed, we
Is there a way to select records from multiple tables that have the same
fields, without doing a join?
Basically, I want to merge two tables together, then do a select on the
resulting table. But I want to do this without having to actually create
a new merged table. Example:
table pets1
table pets1
name foodowner
fluffypurina kim
fido kibbles lisa
table pets2
name foodowner
snowy meowmix cheryl
whiskers 9lives lisa
Then I want to select all records from
You can use the table.field notation like:
select * from cats, dogs where cats.owner = 'lisa' || dogs.owner = 'lisa';
select cats.food, dogs.owner from cats, dogs;
etc. etc.
(note: '||' is the or logical operand)
Good luck!
-C
-Original Message-
From: Jessica Tishmack [mailto:[EMAIL
Hello All,
Background:
-Site has 8000 uniques per day, average of 300 online at once hammering the
forums.
-POST table has over 350,000 entries
When doing a backup with mysqldump and then trying to re-import the data to a
test
server, we keep getting:
ERROR 1030 at line 207477: Got error 28
Hello All,
Background:
-Site has 8000 uniques per day, average of 300 online at once hammering the
forums.
-POST table has over 350,000 entries
When doing a backup with mysqldump and then trying to re-import the data to a
test
server, we keep getting:
ERROR 1030 at line 207477: Got error 28
Hi there,
I am trying fulltext to speed up my queries; but what would the query
line be,
when I would like to match the phrase: This is a text?
With a like query i would do WHERE column LIKE '%This Is a text%';
I've tried MATCH column AGAINST('+this +is +a +test'); but this
returns,
all
1 - 100 of 130 matches
Mail list logo