a
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
Thanks, Tyler,Â
That's very helpful.
Dennis
--- On Sat, 9/3/11, Tyler Poland wrote:
From: Tyler Poland
Subject: Re: select ... into local outfile ... ???
To: mysql@lists.mysql.com
Date: Saturday, September 3, 2011, 3:45 AM
Dennis,
The following closely simulates the default "IN
"select ... into LOCAL file"
statement.Any suggestion is appreciated.
Dennis
ll,
body longtext not null),
primary key(patnote),
unique id(patnote)";
mysql_query($query);
mysql_close();
then the closing question mark and carat on this line this does
not build a file and I am wondering what syntax I am missing here
login MySQL with "root" and use:
RESET MASTER
that's all you need to do.
Kaushal Shriyan wrote:
Hi
I am referring to
http://dev.mysql.com/doc/refman/5.0/en/purge-master-logs.html
whats the exact syntax to purge this MySQL Binary Logs
-rw-rw 1 mysql 701 1.1G May 5 07:39 host1-bin.000681
I've got a column called time with the datatype time. When querying the
column from asp/ado the values are the current date with a vartype of date.
query browser: select time from syslog.mailinfo limit 1
result:
"time"
"03:18:26"
asp/ado:
<%set conn=server.createobject("adodb.connection")
conn.
DATE_FORMAT()
Doesn't seem like the most elegant solution, but it does seem to work.
Thanks.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Is there a function that I can use in a query to return values in a
different datatype? I've got a column which is time datatype and I'd like to
return the values in a vb-compatible datatype.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:htt
, '', image_id FROM wesHoldKategori
);
===
Anyone who can explain why this is happening and how i can solve it?
Thanks in advance
Dennis Duggen
--
Airconditioners and computers have one thing in common:
Once you open windows everything fa
I'm getting lots of duplicate rows even though I have a
unique index defined over multiple columns.
The issue is that multiple NULL values are allowed,
even when some values are not null.
This could be as specified by the SQL standard,
but it's certainly confusing for the developer.
(By the way, on
#x27;inc'] being set to
"Value of -1 lists all records in a table"
which gets converted to a SQL statement using LIMIT 0,-1
This does not make for a smooth migration from MySQL 4.0 to 4.1
and the solution suggested in the documentation is a step backwards
in elegance (IM
Please CC me, I am on digest.
What is an int(11) as in the following table creation statement? I
looked online at the documentation, and not only is the documentation
MUCH different than the last time I looked at it, (been awhile), but I
didn't see anything related to a parameter to the size of
way to estimate whether it's any where close to finishing.
If I abort the mysql process doing the optimization, will the table or
the index be damaged? The system is a development system and is really
sluggish while the optimize is going on.
--
Dennis T.Cook
--
MySQL General Mailing Li
rsion 4.0.17 .
Kind regards,
+-----
+ Dave Dennis
+ Seattle, WA
+ [EMAIL PROTECTED]
+ http://www.dmdennis.com
+-
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
SELECT COUNT(*) FROM tbl WHERE where_clause limit 200;
-Original Message-
From: Lorderon [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 17, 2004 6:45 PM
To: [EMAIL PROTECTED]
Subject: limit stop count
How can I limit a count to stop when he reaches 200 rows?
SELECT COUNT(*) FROM tbl W
Thanks so much!!
SELECT (SUM(( ads.col * 1.91) * ads.depth ) / 131.77) * 100
FROM ads
WHERE date = '2004-02-26'
AND editionID = '13'
AND ads.page = '16'
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 25, 2004
Good afternoon,
How can I take the 3 results below add them together then divide by
131.77?
Can it all be done in one SQL statement?
Thanks in advance.
mysql> describe ads;
+---+---+--+-+++
Just started using MYSQL. And in doing some reading about MYSQL I read
that MYSQL does not support nested Selects.Is this true?
Are there any help files for MySQL Control Center at this time?
Dennis H. Strickland
SatisFacts Research, LLC
2360 W. Joppa Road., Joppa Concourse Building
Suite 322
Lutherville, MD 21093
Toll Free: 866.655.1490 ext. 103
Fax: 866.655.1491
Local: 410.583.9080
Where can I find the configure string MySQL AB uses to compile their
solaris binaries?
-James
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
gettimeofday(&tv,0);\
(ABSTIME).tv_sec=tv.tv_sec+(time_t) (SEC);\
(ABSTIME).tv_nsec=tv.tv_usec*1000;\
}
uname -a shows: SunOS hostname 5.8 Generic_108528-21 sun4u sparc
SUNW,Ultra-60
Any help would be VERY appreciated!
- James Dennis
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Robert,
ADO seems to prefer blobs to be at the end of the select. Try the following
to see if it works:
Select Picture, Questions, Answers FROM FAQ ORDER by OrderID
Dennis
-Original Message-
From: Helpdesk3 ( Mid North Coast Internet )
[mailto:[EMAIL PROTECTED]
Sent: Wednesday
I have a complex web application consisting of several programs totalling
about 100k lines of C code that has been running successfully under Linux.
To improve security, I want to port the application to MacOS X, where
considerably less effort goes into designing security breaches. When I try
com
Hello,
Is it possible to store Java objects in the mysql database?
Kind regards,
Dennis
Get advanced SPAM filtering on Webmail or POP Mail ... Get Lycos Mail!
http://login.mail.lycos.com/r/referral?aid=27005
--
MySQL General
(B[EMAIL PROTECTED](B
$B%D%?%M%9([EMAIL PROTECTED](B
(B
(BHello,
(B
(BI am trying to install MySQL 3.23.55 on HP-UX 11.11
(B
(BWhen I ran ./configure, I got the following messages :
(B
(B Configure: WARNING: sys/socket.h: present but cannot be compiled
(B Configure: WARNING: sy
long long unsigned int, const iovec*,
(Bint)
(B'
(B
(B>Fix:
(B
(B
(B>Submitter-Id:
(B>Originator:Dennis Francis Tutanes
(B>Organization:
(B
(B
(B>MySQL support: [none | licence | email support | extended email support ]
(Bnone
(B>Synopsi
How do I unsub from this list? The unsub link doesn't work?
}
echo("Quick it's all most closing time!!!");
more_help();
?>
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
Sent: Sunday, June 15, 2003 8:46 PM
To: [EMAIL P
>Description:
The file scripts/mysql_install_db crashes when trying to create the
databases. Since the system isn't configured MySQL cannot start
>How-To-Repeat:
Just a simple build from source will do the trick. There are no
compile errors and even the make install
| N |
N |
+--++--+-+-+
-+-+-+---+-+
---+--+---++-+--
--++
5 rows in set (0.00 sec)
Ragards,
Dennis Kruyt,
-
Before posting, please check:
http://www.mysql.com/manual.php (th
I can not confirm this, but it would make sense that this was updated in
4.05. After all, you are only deleting your records, not re-building the
table. The new functionality you describe is also present in SQL Server and
Oracle.
Filter: Mysql , sql , query
Good Luck,
Dennis Salguero
I think you did not properly process this request.
Dennis Schwerdel
Date: Sun, 15 Dec 2002 20:51:14 +0100
From: [EMAIL PROTECTED]
To: Dennis Schwerdel <[EMAIL PROTECTED]>
Subject: Re: Bug in auto_increment
X-WEBDE-TAG: S
Sender: [EMAIL PROTECTED]
Your message cannot be posted to
Inspection of the mysql.log shows that the failing sql query
alter table foo add index foodex( colone, coltwo, colthree);
where foo is a BerkeleyDB type table with 150,000 entries of 500 bytes
organized into 10 fields dies when it runs out of locks.
How does one change the size of the
> On Wed, Dec 11, 2002 at 11:12:33AM -0500, shawn xu wrote:
> > We have MySQL 3.23.53 running on Intel machine with OS
> > BSDI 4.3.
> >
> > The problem happened more often like this.
> >
> > MySQL eated up 99% cpu time which was told by running
> > "top". When this happened, I guess it still an
> Does anyone know of a package that computer novices can use to build simple
> web pages. Even if they know nothing of HTML?
>
> I'm using mysql and I figure there might be something out there all ready
> built. This is for a small college that teachers can use to put on there
> stuff.
>
typo/g
Using the sql:
alter table foo add index dex( keycol1, keycol2, keycol3 );
causes a Error 1030 with the annotation "table handler error 12". The particular table
involved has about 15 entries, contains 10 or so varchar() fields with a record
size of O(500) bytes. The table is decla
I have found a work around, but I do wonder what the problem is with
MySQL and BDB tables.
When I rerun the load with the table type set to ISAM it all
works. Looks like there may be some limitation of the BDB implementation
I am triggering.
In my previous post, I reported receiving an Error
I have a moderately large database (150K records of nine fields, a bit under 500 bytes
per record with a primary key. The database is of Type BDB.
To improve query performance I concluded I needed to add a three element index.
Running
alter table foo add index udex( w_1, w_2, w3 );
e page and the access the array elements via
JavaScript. While this raises quite a few issues (I'll leave that exercise
to you), it is a way to access your database information with JavaScript.
Good Luck!
Dennis
Filter: MySQL, SQL, Query
- Original Message -
From: "Michael
Doh!
Just when you think you have a softball . . .
Yes, the answer should include the FROM:
SELECT name, table1.position, table2.position
FROM table1,table2
WHERE table1.name=table2.name
Filter: MySQL SQL
- Original Message -
From: "Jocelyn Fournier" <[EMAIL PROTECTED]
Doh!
Just when you think you have a softball . . .
Yes, the answer should include the FROM:
SELECT name, table1.position, table2.position
FROM table1,table2
WHERE table1.name=table2.name
Filter: MySQL SQL
- Original Message -
From: "Jocelyn Fournier" <[EMAIL PROTECTED]
You might want to add some unique IDs or something else in common to make
this query a bit better, but the following is what you should be doing:
SELECT name, table1.position, table2.position
WHERE table1.name=table2.name
Good Luck!
Dennis
- Original Message -
From: "Osman
't mean that you can't use the earlier suggestion.
You should pull the records, split the data based on the comma and then
insert them individually into new fields and then run your query on the new
table.
Good Luck!
Dennis
--
On the other hand, if your reports are not complex at all, then you can
simply rely on something like PHP or ASP and have web-based reports. This
may not always be the best option for all reports, but if you're only
running a few reports and need a cost-effective solution, this may not be so
You can't decrypt the password from MySQL, instead, you should encrypt the
input from PHP and then do the string comparison.
Good Luck,
Dennis
- Original Message -
From: "Elaine Kwek" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, October 31, 200
I just upgraded to Linux-Mandrake 9.0 and installed mysql via the RPM
files. Everything installed just fine and dandy except when I try to
run mysql it can't find /var/lib/mysql/mysql.sock file. I'm read how to
protect that file, but where does it come from?
It looks like you're missing a comma in your SQL statement in between
placeOfBirth and civilStatus.
Good Luck!
Dennis
- Original Message -
From: "Mylin Campos" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, October 23, 2002 2:13 AM
Subject: sql
Have you tried using a GROUP BY statement - maybe something like:
SELECT ExpDepDate, ActArrDate, Count(Ref) as NoOfRefs FROM oceandata
GROUP BY ExpDepDate, ActArrDate, Ref
Good Luck!
Dennis
- Original Message -
From: "Morsky Juha" <[EMAIL PROTECTED]>
To: <[EMA
ould easily be a "load data from
server" also.
Dennis
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e
.
Something like:
Copy Server:dbase:table to localhost:dbase:table
Any ideas would be appreciated.
Dennis
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the
root 178 Mar 23 12:05 /usr/lib/libc.so
Configure command:
CFLAGS="-O3" CC=gcc CXX=gcc CXXFLAGS="-O3 -felide-constructors
-fno-exceptions \
-fno-rtti" ./configure --prefix=/usr/local/mysql --enable-assembler
s \
--with-mysqld-ldflags=-all-static
I've read docs until my eyes are popping out. I need a bit of a rescue
here.
TIA.
/dennis
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
s \
--with-mysqld-ldflags=-all-static
I've read docs until my eyes are popping out. I need a bit of a rescue
here.
TIA.
/dennis
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
>Description:
Make reports this:
libmysql.c: In function `mysql_real_connect':
libmysql.c:1325: warning: passing arg 5 of `gethostbyname_r' from
incompatible pointer type
libmysql.c:1325: too few arguments to function `gethostbyname_r'
libmysql.c:1325: warning: assignment makes pointer from integ
sql query
We have data stored as BIGINT in unix, and there are 32bit unsigned values
but nothing larger. I would assume if we convert this to integer in win98
it would seem that values over 31bits would be wrong. Are there workarounds
for this? Is this also an issue in later version of windows
ample.
>
>You have written the following:
>
>
>Is it possible to export 32-bit unsigned values stored as a BIGINT in unix
>as a usable value in Access? there doesnt seem to be an "unsigned" option.
>
>Dennis
---
Its not clear from the docs if external mySQL databases (say running on a
linux system) can be linked to Windows database with myODBC. Does this work
bi-directionally (ie can I retrieve info from the linux databases and
update records on the linux box with queries from windows?
Thanks,
DB
-
Hi!
First of all I would like to congratulate you for MySQL, which I, among many
users, have found a both useful and powerfull tool.
My name is Dennis Bekatoros. I am a pretty new user of MySQL but having some
experience with other SQL platforms I managed to get used to MySQL
environment in
at I was looking for.
Dennis
- Original Message -
From: "Ritesh Nadhani" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, May 19, 2002 9:25 AM
Subject: A new GUI for mySQL
> greetings...
> Webyog has released mySQLyog, a win32 based Query
> analyzer.
NULL..
Any help would be greatly appreciated!
Dennis
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAI
Hi all,
I have different scripts which use Mysql databases. Now is my question;
Is it better to have different databases for the different scripts or should
I use 1 database for all the scripts?
The scripts aren't used a lot.
Thanks,
D
Concerning my actual question to the group, I got the feeling that the
function mysql_fetch_object is just not working correctly.
Is it possible that mysql_fetch_object is not working, if something gone
wrong during compilation-time or if there's a wrong entry in any
cnf-file (or php.ini)?
I
What is wrong, I just cannot explain??? Im
> completely pzzled and confused.
>
> Please help me. It would be nice if you'd cc to my email-address too.
>
> Thank you very much for your interest.
>
> dennis
>
>
>
> $host = "localhost";
> $user
er, which is
intented for the job, but now the username fails, unless it's working on
my machine. What is wrong, I just cannot explain??? Im completely pzzled
and confused.
Please help me. It would be nice if you'd cc to my email-address too.
Thank you very mu
sql, query
>
>Hello Dear Group
>
>
>I want to use the command LOAD DATA INFILE
>
>I have a table with 18 columns. But to fill the columns unfortunately I
>don't have one input file put two.
>
>The first on shall fill 16 of the 18 columns. The second one contains
>the data of column 8 and colum
et
it right.
Thanks in advance,
Dennis
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTEC
> server-side part and will only produce the html-code you want it to
> produce.
>
> If your users have ftp-access to docs, you have a problem.
> Yours
> Henning
>
> Dennis Peyerl wrote:
>
>> Hello
>>
>> I want to realize the following thing:
>> A
Hello
I want to realize the following thing:
A user shall be able to connect through a php-website into mysql. I have
a form with to input types (standard html). The two input types are
text and password.
I don't know how to use that, to log a user in. Do I have to create a
special table for
Hi there
Server: i386
System: LAMPS (Suse Linux 8.0, Apache, MySQL, PHP, SSL)
I've installed MySQL now several times and I am running already two
databases. Sounds if I would have understood how things working?
I still don't know where the mysql-stuff actually is. Now I want to set
up a new se
I downloaded mysql-3.23.49-win-src.zip.
There are various files missing (e.g. Makefile) that would enable compiling with gcc.
Has anyone out there made mysql from source on Win platform with gcc? I had been
trying to compile my own client but was getting a lot of undefines at link time - the
Thank you very much
it workes now.
Could you tell me, how come, that the search-path points to /tmp/mysql.sock?
I've just created a link, but isn't it possibly to change the apache of
trying to connect to /tmp/mysql.sock?
thnax
dcp
Me& wrote:
>Correction!
>
>Look for the line socket in the [
Hi there
The database is now running, i've created my tables and put the data
inside. This is fine.
Next step is to create a PHP-Website which communicates with the
database, but i am not able to connect over my apache (this is what it
seems to me).
to log into the database I use
> mysq
Hi I am new to the list
My boss told me I have three days of time to develop a php-website that
is capable to handle SQL-Requests into a database.
Problem is I don't have any experiences.
Now I have startet with compiling Apache with PHP support and installing
the MySQL package which comes wi
Hello,
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?
Cheers!
Dennis
I am trying to do a select that will display events by category, but
will NOT display a category name if it is empty (has no events).
2 tables: categories and events
events contains a field called category_id that corresponds to the id of
a category in categories.
I am doing a 'while' loop for
> -Ursprüngliche Nachricht-
> Von: Sinisa Milivojevic [mailto:[EMAIL PROTECTED]]
> Gesendet: Donnerstag, 10. Januar 2002 15:29
> An: Dennis Jacobfeuerborn
> Cc: [EMAIL PROTECTED]
> Betreff: Re: AW: Stability problems on 4-way server
>
>
> Dennis Jacobfeuerb
> -Ursprüngliche Nachricht-
> Von: Sinisa Milivojevic [mailto:[EMAIL PROTECTED]]
> Gesendet: Mittwoch, 9. Januar 2002 15:06
> An: [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]; Dennis Jacobfeuerborn; [EMAIL PROTECTED]
> Betreff: Re: Stability problems on 4-way server
>
I just found out that this is Freebsd 4.1 running v3.22.23 of mySQL. Is
there an issue with v3.22 related to this?
Dennis
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http
At 12:09 PM 01/09/2002, Dan Nelson wrote:
>In the last episode (Jan 08), Dennis said:
> > We have a database that seems to have grown too large, and now any
> > operation fails on it. How can we fix this?
>
>If you can SELECT from it, create a new MYISAM table with the RAID
At 11:26 PM 01/08/2002, you wrote:
>On Tue, Jan 08, 2002 at 08:03:07PM -0500, Dennis wrote:
> > At 07:07 PM 01/08/2002, you wrote:
> > >Dennis,
> > >
> > >You may want to look into using InnoDB tables. I believe InnoDB tables
> > >are immune t
At 07:07 PM 01/08/2002, you wrote:
>Dennis,
>
>You may want to look into using InnoDB tables. I believe InnoDB tables
>are immune to the 2gb limit (which usually comes from the filesystem).
>Also, InnoDB claims that the innodb tables are faster than MyISAM tables
>i
We have a database that seems to have grown too large, and now any
operation fails on it. How can we fix this?
Dennis
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http
curs. They just run slower because of the high load.
Regards,
Dennis
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this
My question pertains to the implementation of stored procedures in MySQL.
According to the MySQL documentation, this is scheduled for the 4.1 release.
Is this still accurate?
When will we be seeing the first downloads of 4.1 available?
Thanks,
Dennis
way you have broken out the data shows
at least some understanding of Normalization rules and you are avoiding
repetitive data,which is good. Yes, it may be a pain to have to create a SQL
statement with a join, but the fact is that you have a one-to-many
relationship here and
so I'm behind the times :-)
-Dennis
Carl Troein wrote:
> Dennis Herndon writes:
>
>
>>Ok, I have read through the manual and archives and still I cannot find
>>this problem I'm having.
>>
>>" can't connect to local MySql server through
Ok, I have read through the manual and archives and still I cannot find
this problem I'm having.
" can't connect to local MySql server through socket '
var/lib/mysql/mysql.sock' (2) "
Help!
Thanks in advance.
-
Before posti
meant as a robust managing or editing tool.
If anyone thinks that they may use a tool like this for MySQL, or want to
request a copy, please e-mail me. Any other thoughts on a "release
structure" are also welcome.
Thanks,
Dennis Salguero
an board - easy to configure and rig to the case), 512Mb RAM and 30 gb
hard-drive - works like a charm.
Good Luck,
Dennis Salguero
**
Beridney Computer Services
[EMAIL PROTECTED]
http://www.beridney.com
-
s.
> Note also that there's a good chance your question has been answered in
the
> past. Please spend a minute or two checking one of the MySQL List
archives,
> eg. the one at the MySQL site (http://lists.mysql.com/).
See above; this archive is a
e
some resources for that already out there.
Good Luck,
Dennis Salguero
**
Beridney Computer Services
[EMAIL PROTECTED]
http://www.beridney.com
-
Before posting, please check:
're much better off
creating two connections rather than having two simulatneous servers.
Good Luck,
Dennis Salguero
**
Beridney Computer Services
[EMAIL PROTECTED]
http://www.beridney.com
--
I'm pretty sure that the "complete" implementation is not done yet, in the
sense that there is no RDI enforcement.
Good Luck,
Dennis
**
Beridney Computer Services
[EMAIL PROTECTED]
http://www.beridney.com
- Original Message
Take a look at:
http://www.mysql.com/doc/M/i/Missing_Foreign_Keys.html
Basically, MySQL does not support foreign keys. Therefore, referrential data
integrity (RDI) is also not available.
Good Luck,
Dennis
**
Beridney Computer Services
http
Cheer up - I too am having similar problems using Mandrake 8.0. I can run
php files, I have MySql running etc. Hopefully I will try a couple of the
things mention here and see what happens.
-Original Message-
From: Chakravarthy K Sannedhi [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, Se
rver on '24.254.141.32' (10061)
>
> /members/admin/login-action.asp, line 66
For a problem like this, it never hurts to include the code that the error
is referring to.
Dennis
-
Before posting, please check:
h
I have the same problem and have looked all over for the solution. You have
to delete the anonymous user from which table? I would assume the users
table?
-Original Message-
From: Roman Festchook [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 29, 2001 10:05
To: Peter Moscatt; MySQL
een is to create a stand-alone COM component to interface
with the LDAP server. Its quite simple really, take in the userID and
password and return a negation or access rights - one of the easiest COM
components you'll ever write! Making it a COM component can then let you
work with it in
that, keep in mind that
it's an ADO world and you should be just fine when creating Windows
applications with MySQL.
Good Luck,
Dennis
**
Beridney Computer Services
http://www.beridney.com
- Original Message -
From: "Christian He
Are you looking for:
SELECT table1.name, table2.subject
FROM table1, table2
WHERE table1.id=table2.student_id
Good Luck,
Dennis
**
Beridney Computer Services
http://www.beridney.com
- Original Message -
From: "Jamie Burns" <[EM
I prefer to use Auto_Increment for ease of use. In addition, I don't think
that MySQL supports sequences outright (like you may be used to with
Oracle). There are some workarounds availabe within the MySQL manual, do a
search with "sequences".
Goo
1 - 100 of 157 matches
Mail list logo
