Steve,
But still only one record, that first one, come in ... at least as
evidenced by the SELECT * FROM [table_name]. What do I try next?
Next thing is you send the CREATE TABLE statement of your table, plus
at least two lines of your import text file (not as attachment, the
list manager
Hi Richard, hi Richard :)
I still suspect some memory limitation on the Sparc 20 preventing the
un-dump from completing. In re-checking my server data list, the 20
has 1/2 the memory of the E250 (256 Meg on the 20 vs. 512 on the E250 -
also 512 on the W2K machine).
Just to make sure it's
It will then be a networking problem. As far as I know, you may need a
networking file system like NFS or Samba. You should mount your remote
machine as a network drive. Then you can use mysqldump to make a backup but
redirect the output to the network drive.
There may be other methods. In
Hello.
I'm very new to MySQL (and SQL databases at large), so please apologize if
I'm just missing an obvious point, or if it has already been discussed before.
As I understand, auto-incremental columns (quite useful for primary
indexes) are always incremented. Even if rows are deleted,
Hi everybody,
I have problems with foreign key creation.
I have installed mysql server cersion 3.23.53 on red hat linux 7.3.
Then I have created innodb datebase to be able to use FOREIGN KEY
Constarints.
This is concerning piece of my my.cnf file:
# Uncomment the following if you are using
I think you have no need to worry overflow if you use int type. You may have
added assurance if you also define it as unsigned. I just listed the max. of
different unsigned integer type for your reference
tinyint 255
smallint 65535
mediumint 16777215
int 4294967295
bigint 18446744073709551615
Hello,
I just tried compiling and using MySQL-4.0.11 (from the BitKeeper
repository) on RedHat 8.0, and this problem seems to have gone
away:
Unfortunately the problem is still occurring even after retrieving the
latest source from the repository (I used the compile_pentium_debug
script).
Hi all.
I need some help figuring out how to update a many-to-many relationship
from a text file.
For the fun of it, let's call the tables 'sku' and 'agent'. Each sku
can have multiple agents (usually 10, always 0), and each agent can
be associated with an unlimited number of records skus.
Need to know the correct syntax for granting a new user access to a =
MySQL database with select, insert and updates privileges only and only on a =
particular database and table (although there are multiple tables).
Tried using the following:
grant Select,Insert,Update on Ruby.oCeremony to
Hello folks
(B I just installed mysql4.x into the home/username directory of a remote
(Bmachine. It is running good and I created a new user tester with all
(Bprivileges.
(BBut how can i connect to the remote server running on a home directory using
(Ba front end tool like MySQLFront. It is
I'm very new to MySQL (and SQL databases at large), so please
apologize if I'm just missing an obvious point, or if it has
already been discussed before.
Did a little search of MARC on auto-increment rollover, and it hit a
thread from 1999. (This has been discussed many times before and since,
On Wed, Feb 19, 2003 at 06:35:07PM +0900, Joel Rees wrote:
Did a little search of MARC on auto-increment rollover, and it hit a
thread from 1999. (This has been discussed many times before and since,
of course. My choice of search term wasn't very good, I guess.)
On Wed, Feb 19, 2003 at 10:43:41AM +0059, Jedi/Sector One wrote:
Ok, except speculation on real life, there's no correct way to handle
this.
Self-correction : it looks like MySQL returns ER_DUP_ENTRY when an
overflow occurs, even with InnoDB tables.
Great :)
--
__ /*- Frank DENIS
This one is still biting us.. any suggestions on where to troubleshoot
would be appreciated.
Mac OS X Server, 10.2.1 - MySQL 3.23.51
Heavy usage, but no more than 50 open connections at a time
Occasionally, MySQL just quits serving databases. The first indication
is a forum or something comes
Using the hostname or IP adders of the machine it is on.
(B
(BJerry
(B
(B- Original Message -
(BFrom: "kk" [EMAIL PROTECTED]
(BTo: "list mysql" [EMAIL PROTECTED]
(BSent: Wednesday, February 19, 2003 9:24 AM
(BSubject: Connecting to remote server
(B
(B
(B Hello folks
(B I just
Hello.
I'm using replication both master and slave are MySQL 4.0.10.
But, When I insert many record( ten thousands of record) at a once,
I got follow error message.
###
030219 18:03:20 Error reading packet from server: binlog truncated in the
middle of event (server_errno=1236)
030219 18:03:20
newbie-question, sorry...
is it possible to write this (working) query in a shorter form:
SELECT * FROM $table WHERE (col1 LIKE '%$term%') OR (col2 LIKE '%$term%') OR
(col3 LIKE '%$term%')
thanks for your help!
Reto Baudenbacher
Hi,
I have one question about InnoDB-tables especial the filesize of all tables.
In the past I took MyISAM but found out, some things in InnoDB make the
system more stable.
But I want to get more free space. In MyISAM the space grows automatically,
but not in InnoDB by default.
In my /etc/my.cnf
We try to evaluate MySQL on Linux for IBM S390 but
the binary distribution fails with a cannont execute in my_print_defaults
and the source distribution errror is below:
How-To-Repeat:
make reports the folling:
../innobase/row/librow.a(row0sel.o): In function
Hi!
Is it a bug?
C:\mysqlmysql -u root
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 29 to server version: 3.23.55-max-nt
mysql create database R;
Query OK, 1 row affected (0.06 sec)
mysql grant all privileges on `R%`.* to b;
Query OK, 0 rows affected
--- [EMAIL PROTECTED] wrote:
Your message cannot be posted because it appears to
be either spam or
simply off topic to our filter. To bypass the filter
you must include
one of the following words in your message:
sql,query,queries,smallint
If you just reply to this message, and include
* Ayyaparaju Ganapathiraju
1). Is there an equivalent to creating a schema in MySQL. I would like to
create tables in multiple schemas within the same database. Some of the
tables will have foregign keys across schemas.
No, there is no consept of 'schema' in mysql, other than the implicit
http://www.mysql.com/doc/en/ALTER_TABLE.html
- Original Message -
From: Prabu Subroto [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, February 19, 2003 11:58 AM
Subject: MySQL
--- [EMAIL PROTECTED] wrote:
Your message cannot be posted because it appears to
be either spam
Prabu,
Is it possible to define Foreign Key and Primary Key
of my database after the tables have been created ?
If yes, how?
Yes. Use the ALTER TABLE command for this. Here's how it works generally:
ALTER TABLE yourtablename
ADD [CONSTRAINT symbol] FOREIGN KEY (...) REFERENCES
Thank you my friend..
--- Jerry [EMAIL PROTECTED] wrote:
http://www.mysql.com/doc/en/ALTER_TABLE.html
- Original Message -
From: Prabu Subroto [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, February 19, 2003 11:58 AM
Subject: MySQL
--- [EMAIL PROTECTED] wrote:
Thank you very much. That information is very helpful as I am just starting
to use/learn MySQL.
Raju Ganapathiraju
From: Roger Baklund [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
CC: Ayyaparaju Ganapathiraju [EMAIL PROTECTED]
Subject: Re: How to create a schema
Date: Wed, 19 Feb 2003 13:32:32
Jedi,
The behavior of the auto-increment mechanism is not defined if a user gives
a negative value to the column or if the value becomes bigger than the
maximum integer that can be stored in the specified integer type.
Does it mean that MySQL databases will definitely stop working at a
On Wednesday 19 February 2003 13:58, Prabu Subroto wrote:
I did something very stupid in my development. I
created a database with a couple of tables...but I
forgot to defining the foreign key and the primary
key
So if my user updated a record of one table than the
corresponding row
On Wednesday 19 February 2003 10:46, [EMAIL PROTECTED] wrote:
I have problems with foreign key creation.
I have installed mysql server cersion 3.23.53 on red hat linux 7.3.
Then I have created innodb datebase to be able to use FOREIGN KEY
Constarints.
This is concerning piece of my my.cnf
On Wednesday 19 February 2003 11:24, kk wrote:
I just installed mysql4.x into the home/username directory of a remote
machine. It is running good and I created a new user tester with all
privileges.
But how can i connect to the remote server running on a home directory
using a front end
On Wednesday 19 February 2003 13:21, Rusch (ext) Reiner wrote:
I have one question about InnoDB-tables especial the filesize of all
tables. In the past I took MyISAM but found out, some things in InnoDB make
the system more stable.
But I want to get more free space. In MyISAM the space grows
On Wednesday 19 February 2003 12:51, Reto Baudenbacher wrote:
newbie-question, sorry...
is it possible to write this (working) query in a shorter form:
SELECT * FROM $table WHERE (col1 LIKE '%$term%') OR (col2 LIKE '%$term%')
OR (col3 LIKE '%$term%')
The short answer - yes, you can write
Greetings all,
Not sure if this is the right place to ask this,...I use the
following script on an OS X server to backup my mysql databases:
#!/bin/sh
DATE=`/bin/date +%Y%m%d_%H%M%S`;
cd /Users/usernmae/Documents;
/usr/bin/mysqldump -hhost -uusername -ppassword --all-databases
I am trying to install DBD-mysql-2.1025 on a RH8 machine. When I do a make
I get an error saying that it can't find libz.a or libz.so etc
I tried modifying the perl Makefile.PL using --libs= and the path to my
libz.so file.
As a fix, it did say that I could fix this by installing libz-devel,
Looks to my like skuagent should be using the varchar fields instead of
the int fields.
Then you could just insert ignore each line from your test file.
Paul Chvostek wrote:
Hi all.
I need some help figuring out how to update a many-to-many relationship
from a text file.
For the fun of it,
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Duncan Maitland wrote:
Hello,
I just tried compiling and using MySQL-4.0.11 (from the BitKeeper
repository) on RedHat 8.0, and this problem seems to have gone
away:
Unfortunately the problem is still occurring even after retrieving the
latest
Hi,
Newbie here so please bear with me.
I am running MySQL 3.23.22 with PHP4.01 on WinNT client / Linux host,
everything is working okay and I'm just getting to grips with some basic
database handling.
Although I can use mysql_query to get a list of records using Select * from
`mydata` - for what
Hi,
there's a Password()-Function in MySQL. Can somebody tell my on what standard is
based (MD5 etc.) and if there's something similar in a DBMS that also supports
triggers? InterBase does not support many functions...
Thanks
Bernhard
Mark,
I read in the release notes that there is an implementation of XADataSource
(MySQLXADataSource), which does exist in the 2.0.14 release. I've looked in
the 3.x releases and do not see it. Am I just not seeing it? Is this also
planned for the 3.x releases?
Thanks,
Frank
Use and id column, like an auto increment one and use that in the html you
are writing out +1 or -1 to get the next.
i.e.
select id, X, X, X from table where id=1
returns 1, value of X, value of X, value of X etc etc etc
then in the html use the id .
id+1
a href=wizzyScript.php?id=2Next/a
Bernhard Döbler wrote:
there's a Password()-Function in MySQL. Can somebody tell my on what standard is based (MD5 etc.) and if there's something similar in a DBMS that also supports triggers? InterBase does not support many functions...
Its deprecated; use MD5() or SHA1() ...
--
Michael T.
I thought this was PHP
Andrew
-Original Message-
From: Bernhard Döbler [mailto:[EMAIL PROTECTED]]
Sent: 19 February 2003 14:53
To: [EMAIL PROTECTED]
Subject: Hash-Functions
Hi,
there's a Password()-Function in MySQL. Can somebody tell my on what
standard is based (MD5 etc.) and if
You are right. read previous simply not exist. I think this is due to both
historical reason and 'client/server model'.
In fact, 'read next' is available by reading next row in a query. However,
the record cursor is one direction only and cannot be read back.
In my experience, I will store the
I have a database that I've worked hard to set up, and while
many of my queries are working well, I have a few that are
proving to be extremely slow, despite my best efforts to
properly index them. I'd be grateful for any advice on how to
speed these up, or an explanation of how there's no way to
Yeah, we are gettign a single row each time.
The file is
hocatID (auto-increm) primary key
Hocat (varchar - index)
description (varchar)
...plus many other numeric/varchar fields.
We are looking to display a single record on a page at one time with an
option for the user to step through the
Hi!
What to choose - InterBase/FireBird or MySQL - depends on the tasks you are
going to solve with your SQL server. InterBase/FireBird is intended for
managing a quite large and complicate databases, where a lot of business
rules should be realized and stored in common database instead of being
Stefan,
H. On the solaris machines (both), there is currently NO my.cnf
file anywhere, yet MySQL has been working just fine. I imagine default
values are being used for everything. I'll have to select one of the
.cnf files from support-files. I'll let you know how it works.
-Richard
Hi List,
I'm using 4.0.10-max-nt of mysql.
I update to this version from 4.0.5. With this version I have no trouble
with load data local infile.
But now if i try to use it from the mysql-Command-line tool i get
an errror 1148, This command is not allowed with this mysql version.
On my server
Hi all.
In my application I use generators generated manually. I have a table named
table_POID with contains the last generator used for the table table.
With table type MYISAM I use the follow secuence to obtain the next
generator:
LOCK TABLE table_POID;
SELECT instanceNo FROM table_POID;
I have a database with tables representing data from various years
1997, 1998, 1999, 2000 etc. In the tables I have data representing
widget sales, zip codes, types of widgets, for example.
Not all widget types were sold in every year, so there are entries
in some tables that dont occur in
Otherwise, you may ask whether MySQL is an option or
not. It means that if
your logs and related information can go to other
mean such as a text file
then you are no need to buy license.
In theory we can find option for any db appliance,
let say, we can store data in regular files.
Otherwise, you may ask whether MySQL is an option or
not. It means that if
your logs and related information can go to other
mean such as a text file
then you are no need to buy license.
In theory we can find option for any db appliance,
let say, we can store data in regular files.
Hi there,
this problem was asked in this list before and i thought i solved
it but i was wrong. Heres the description:
I am running mysql 3.23.54 on Debian Linux with 2.4.20 Final
System has 2 GB Ram.
I compiled from source.
Here are relevant passages from my.cnf
port= 3306
Hello,
Earlier I asked Mark about XA and Connector/J. He said that it was
dropped from the 3.0 releases because MySQL doesn't natively support XA,
but when it does he will add it back in. Mark suggested that I ask for
XA on these lists if I wish to expedite it in the pipeline.
I am raising
Hello,
I am having some cockpit trouble with the following
MYSQL_RES *mysql_list_fields(MYSQL *mysql, const char *table, const char
*wild);
and it is like lack of understanding on my part. Syntax is:
if (mysql_list_fields( mysql, some table name, some field name))
mysql_store_result and
As far as I know, if you only require MySQL as an option or just an added
features, your company do not need to purchase a license.
KH
Otherwise, you may ask whether MySQL is an option or
not. It means that if
your logs and related information can go to other
mean such as a text file
If you have ssh installed on your target machine couldn't you do the
following?
mysqldump database | scp username@hostname:.
KH Chiu wrote:
It will then be a networking problem. As far as I know, you may need a
networking file system like NFS or Samba. You should mount your remote
machine
Richard,
H. On the solaris machines (both), there is currently NO my.cnf
file anywhere, yet MySQL has been working just fine. I imagine default
values are being used for everything. I'll have to select one of the
.cnf files from support-files. I'll let you know how it works.
At 10:57 -0600 2/19/03, William R. Mattil wrote:
Hello,
I am having some cockpit trouble with the following
MYSQL_RES *mysql_list_fields(MYSQL *mysql, const char *table, const char
*wild);
and it is like lack of understanding on my part. Syntax is:
if (mysql_list_fields( mysql, some table
Sefan,
Stefan Hinz wrote:
Richard,
H. On the solaris machines (both), there is currently NO my.cnf
file anywhere, yet MySQL has been working just fine. I imagine default
values are being used for everything. I'll have to select one of the
.cnf files from support-files. I'll let you
You could just ftp them wherever you want for storage.
I made a simple script where I took the provided mysqlhotcopy script,
added it and used it every day as a cron to make a copy of all my databases,
then run through a check of each one then tar them all up and ftp them to a
remote server.
Its
thanks a lot, I managed it now.
was just a little misconfigured my.cnf-file
-Ursprüngliche Nachricht-
Von: Victoria Reznichenko [mailto:[EMAIL PROTECTED]]
Gesendet: Mittwoch, 19. Februar 2003 14:34
An: [EMAIL PROTECTED]
Betreff: re: InnoDB
On Wednesday 19 February 2003 13:21,
At 11:13 -0600 2/19/03, Paul DuBois wrote:
At 10:57 -0600 2/19/03, William R. Mattil wrote:
Hello,
I am having some cockpit trouble with the following
MYSQL_RES *mysql_list_fields(MYSQL *mysql, const char *table, const char
*wild);
and it is like lack of understanding on my part. Syntax is:
Hi,
On Wed, 2003-02-19 at 15:56, Michael Katzmann wrote:
I have a database with tables representing data from various years
1997, 1998, 1999, 2000 etc. In the tables I have data representing
widget sales, zip codes, types of widgets, for example.
Not all widget types were sold in every year,
I had a problem inserting a date...which format do I need to use?...I'm
using -mm-dd, but when I throw a query, the records display -00-00.
Thx in advance
-
Before posting, please check:
Thank you KH
I think that statistics information might
become important part of our system, so it is safer to
buy license or have a look on others RDBMS.
As far as I know, if you only require MySQL as an
option or just an added
features, your company do not need to purchase a
license.
sql
I have a zip code db named MSI_Zipcodes that contains
city
state
zipcode (index)
I also have a db named MSI_List that contains
ID (index)
email
city(empty)
state(empty)
zip
My problem is:
How can i bring the proper info from MSI_Zipcodes(city and state)
and enter it (city and state) into
Hello,
I'm a newbie with MySQL, so it's possible my qustions are answered
somewhere, but I haven't found those answers yet...
When I start my mysqld deamon, I get this message: Can't initialize InnoDB
as 'innodb_data_file_path' is not set. I've been reading through Reference
Manual and I realise
Hello,
I am running MySQL version 3.23.39 on a Mac running OS X 10.2.4
This query works without error:
Drop table if exists temp;
create temporary table temp select @canread := false, @canread := if(Institution_Id
= 8,true,false), @canread AS canread from persons;
select * from temp;
This
Description:
How-To-Repeat:
Fix:
'bool' type and configure CXXFLAGS errors
Setup:
% uname -a
SunOS hurricane 5.6 Generic_105181-29 sun4u sparc SUNW,Ultra-60
% gcc --version
2.95.3
% setenv CFLAGS -O3
% setenv CXX gcc
% setenv CC gcc
% setenv CXXFLAGS -O3 -felide-constructors -fno-exceptions
I *really* don't want to have a pair of indexes on 60-character varchars
that cover forty million records. That would increase the size of each
index from 280MB to 4.8GB. Just for the indexes. I don't think so.
Also, I don't see how it would address the issue of updates. The
problem is that
Multiple table update is only supported from 4.04 or above. If you are using
3.x, I think you should put the result into another table, delete MSI_List
and rename the table to MSI_List.
I would also very interested to know whether there exist a more elegant
solution for 3.x.
Best regards,
Greetings:
If you're responsible for developing or maintaining data-driven Web
sites powered by MySQL, you may be interested in the recent release
of the Lasso Resource Guide. This free guide contains a listing of
various resources that aid building and serving data-driven Web
sites. And of
How do you determine whether or not it is faster/more efficient to run a
complicated query or to run multiple simple queries and join / manipulate
the results with PHP?
sql
Larry S. Brown
Dimension Networks, Inc.
(727) 723-8388
I have the same db on master and slave and I want to use
replicate-rewrite-db to change the replicating name of this db on the
slave.
Slave my.cnf:
---
[mysqld]
datadir=/var/lib/mysql
socket=/tmp/mysql.sock
master-host=master.company.com
master-user=repl
Richard,
set-variable = max_allowed_packet=16M
Yikes!!! I knew that running default configuration gave you SOME
values, but I didn't know they were so small. I've placed the
my-medium.cnf as my.cnf in /etc on the Sparc 20, and also in C:\ on
the W2K machine. Database access is much
Nikola,
When I start my mysqld deamon, I get this message: Can't initialize InnoDB
as 'innodb_data_file_path' is not set. I've been reading through Reference
Manual and I realise that I have to configure my.cnf file if I want to use
InnoDB, and the problem would dissapear, but the problem is
Alejandro,
I had a problem inserting a date...which format do I need to use?...I'm
using -mm-dd, but when I throw a query, the records display -00-00.
You can insert a date as a string or as a number. Examples:
20030219 -- today, as a number
'2003-02-19' -- today, as a string
You
I am perplexed trying to retrieve all the rows I need in the query I'm
doing.
I have a table with keeping track of people using ID numbers as the primary
key and another table with coupon numbers and a reference to the first
table. But not all the second table is going to have correlating
Hi All
I just installed a RedHat Linux 8.0 box with
mysql-server-3.23.52-3
mysql-3.23.52-3
mysql-devel-3.23.52-3
Changed the password for root using mysqladmin
logged in using a mysql client (locally)
and
mysql GRANT ALL ON *.* TO araheja@'%' IDENTIFIED BY 'amanraheja';
I DID THE SAME STEPS ON
Well then you are looking to do a left join.
SELECT table1.id, table2.coupon FROM table1 LEFT JOIN table2 ON
table1.id=table2.person_id;
In your example, the WHERE is not only a join condition, but also a
filter. It gives you exactly what you asked for, only those records
whose id's match. A
Hi,
I want to be able to use the MySQL binary logs and mysqlbinlog to restore
data if needed.
This works fine, except when the log contains sql that is written when I
save a binary stream to a BLOB column in a table. I will get one of those
messages like 'there is an error in your SQL at
Quick question: Are the binlog and relaylog files the same format?
Initial tests seem to indicate that they are the same. Can I use
mysqlbinlog -o Relay_Log_Pos Relay_Log_File | mysql
to get the slave more up to date (without having the slave SQL thread
running)? I tried the above but the
Hi!
I want to emebed libmysqld.lib into a DLL I am making for Visual Basic. I
need to make the DLL in C because it is going to perform other functions
(i.e I do not want to use the Public Declare in VB to access the DLL).
I need the libmysqld.lib library.
I could use LoadLibrary to load it
Rick,
I am able to restore from logs that had binary data (even though the
output looked real strange and messed up the terminal window). I did
have a problem once when I tried filtering data between mysqlbinlog and
mysql. Be careful if you do that.
What version of mysql are you using?
I have
I have one master and two slaves all running 3.23.55-max on RedHat 7.3. I've
had replication up and running smoothly for several days. Today, I decided
to try out LOAD DATA INFILE on the master. After successfully loading on the
master, I checked both slaves and neither one had the new data. There
Hi,
mysqlbinlog -j Relay_Log_Pos Relay_Log_File | mysql
works fine. I used -o instead of -j before. So I answered my last
question. When doing this:
mysqlbinlog -j Relay_Log_Pos Relay_Log_File | more
I see that it had advanced to the query after the one with the problem
in the trace file. In
I need to move the MySQL database from it's existing server to a newer server. Is
there anything I need to be aware of and can it be copied from it's present location
to the new server, with changes to config file?
Thanks
Jon L. Miller, MCNE, CNS
Director/Sr Systems Consultant
MMT Networks
Hi,
Is there a mySQL field type that returns True or False after a
SQL Statement executed by MyODBC driver (ADO)?
Thank's a lot
Alisson
-
Before posting, please check:
Jeff Mao [EMAIL PROTECTED] writes:
Greetings all,
Not sure if this is the right place to ask this,...I use the following
script on an OS X server to backup my mysql databases:
#!/bin/sh
DATE=`/bin/date +%Y%m%d_%H%M%S`;
cd /Users/usernmae/Documents;
/usr/bin/mysqldump -hhost
Stefan and Gerald--
Thanks for the input. Here's how I solved it ... I used a textfile that
had worked for me the very first time I did such an exercise weeks ago.
This particular textfile came on a CD with the book I was using. And by
copying and pasting, so that all the spacing and line
Hi,
And fixed.
Sorry for the waste of time. Only 4 days before I was set to replace the
disk the database was on, and it is going bad. :(
-steve-
sql,query
-
Before posting, please check:
http://www.mysql.com/manual.php
Assume the ip address of your remote machine is 192.168.0.88
You should perform a
nslookup 192.168.0.88
on your LOCAL machine that hold the mysqld
If it cannot resolve into a symbolic name then you will get into trouble.
Add an entry to /etc/hosts or your DNS will solve the problem.
Regards,
You should use LEFT JOIN.
Regards,
I am perplexed trying to retrieve all the rows I need in the query
I'm doing.
I have a table with keeping track of people using ID numbers as the primary
key and another table with coupon numbers and a reference to the
first table. But not all the
All,
Is this query possible to do:
I am going to select an id from a table
SELECT order_id FROM orders WHERE order_start = 1324
I will then use the order_id from this query and insert it as well as
some others values I have into another table.
So in summary, I want to perform a SELECT and
Hi, this is my first post here, I hope it's easily answered
I've got Mandrake Linux 9, with the ext3 file system
What is the absolute maximum table size I can have?
And what do I need to change to achive that?
I've spent half the night googling, and couldn't find a real answer
so now I
Hello all.
I've only been using MySQL for a few days, but I'm experienced with
Oracle. So consider this a sort-of-newbie question.
Is there any way to determine what foreign keys exist on a table? I
have tried myisamchk, describe, show index, show create table,
all to no avail.
Is there
Yes. You can use INSERT INTO table select from ..
Regards,
All,
Is this query possible to do:
I am going to select an id from a table
SELECT order_id FROM orders WHERE order_start = 1324
I will then use the order_id from this query and insert it as well as
some others values I
Dear Jeff,
There are many ways to lookup MySQL metadata. I was used to familiar with
them. Unluckily, I am 'spoiled' by phpMyAdmin recently.
I strongly recommend you to have a try with phpMyAdmin.
Regards,
Hello all.
I've only been using MySQL for a few days, but I'm experienced with
Yes. You can use INSERT INTO table select from ..
If this matters, I will be doing this in 2 different applications. 1
database is MySQL, and the other is MS Access.
Not if the two tables are on different database servers. But maybe I'm
reading that wrong and the application is just being
1 - 100 of 112 matches
Mail list logo