Good Day All,
Let's say I have a paragraph within a field name [summary]
=
United States jets reportedly continued bombing targets Thursday
in Kandahar, and United States special forces were on the ground
coordinating with ethnic Pashtun tr
Today my slave aborted replication with error (this is the third time in
2 days)
---
06 9:21:23 Slave: error running query 'insert into user_lock
(what,user,locked) values('front edit','ninas'Ý¿ô;'
06 8:27:40 Error running query, slave aborted. Fix the problem,
and re-start the sla
On Thu, 15 Nov 2001, Gabor Penoff wrote:
> can you tell me an estimated speed about filling 100 records with
> mysql insert by using the C api?
Last insert job I ran did c. 400 inserts per second. This is real
("wall") time and some computations were involved.
(Dont go running fetching a ca
Erik Price writes:
> Hello all,
>
> Some of you may recognize this post somewhat, I've asked about this
> problem before:
>
> I am unable to execute the "shutdown" command with mysqladmin, running
> on Darwin 1.4.1 (from Mac OS X 10.1.0).
>
> Originally, I had compiled MySQL 3.23.44 from source
On Thu, 15 Nov 2001, Rick Robinson wrote:
> I'm using a MyISAM table in a high availability environment as a rudimentary
> persistent FIFO queue. The table definition is simple - the key is an
> auto_increment unsigned bigint and the data is a blob (it holds the contents
> of a C structure with a
Max writes:
> >Description:
> I am using russian values(cp1251 charset) for ENUM items.
> Here is an example how to damage ID field by query to change
> F_Category Enum.
> >How-To-Repeat:
> # Create tableA with ID field.
> CREATE TABLE tableA (
> ID int(11) NOT NULL auto
Which drivers do you want to install?
1) MySQL only
2) mSQL only (either of mSQL 1 or mSQL 2)
3) MySQL and mSQL (either of mSQL 1 or mSQL 2)
4) mSQL 1 and mSQL 2
5) MySQL, mSQL 1 and mSQL 2
Enter the appropriate number: [3] 1
Do you want to install the MysqlPerl emu
Hello,
does anyone have workspace and project files to compile MySql with Microsoft
Visual Studio? I would like to compile it mysql and debug it on some weird
behavour but I truely have no clue what files to compile (eg. what compiles
are the core engine and which ain't)
Or is this documented so
Just wondering if anyone who knew the answer to this might have missed it
before -- sorry to keep nagging but I really need to find out how, or
whether, you can determine which fields in a table are foreign keys
referencing another table.
Is it not possible to determine, after a table is creat
Hi
I have just installed mysql directly onto my f:\ drive (instead of
installing on c: and moving it across). I run Windows ME. However, when I go
to my MS-DOS mode and navigate to my bin directory, then input the following
command:
F:\MySql\bin>mysql -h localhost -u root -p
it tells me Error 20
From:
Gani Pola
PCI Data
Marketing Division
434 Ridgedale Avenue, PMB # 11-108
East Hanover NJ 07936
Tel: 1-888-248-3443 OR 1-888-713-7201
Fax:1-603-297-5644
mailto:[EMAIL PROTECTED]
Attention: Recruiting Department/Human Resources Department
==+=++
Did you put the my.ini file in the c:\windows directory?
- Original Message -
From: "Shabbir Yusufali" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, October 30, 2001 2:30 AM
Subject: SQL server
Hi
I have just installed mysql directly onto my f:\ drive (instead of
installin
Hi.
Is it planning add macro defintions to MySQL ?
Thanx.
--
Goodbye.
Dannis.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To reques
In a database that enforced referential integrity, if you say that a field
in one table is a foreign key referencing another table, then any value in
the foreign key field in the first table must reference an existing row in
the second table. (Right?)
But suppose you have a database storing,
Bennett Haselton wrote:
> The problem is, how would you add a new bus and a new driver to the
> database? Whichever one is added first, you're going to get an error
> because its counterpart doesn't exist yet, violating referential integrity.
I was under the impression that databases enforced re
Hello,
I installed binary mysql-3.23.44-sgi-irix6.5-mips on irix 6.5.10 following
README. When I issue 'mysql mysql' or 'mysql versions' I got:
ERROR 1135: Can't create a new thread (errno 1). If you are not out of available
memory, you can consult the manual for a possible OS-dependent bug
Hello,
I have problems using the Binary version for SGI
MySQL 3.23.44 SGI Irix 6.5 (6.3M)
It looks like an error in the distribution cq binary program.
After running bin/safe_mysqld on a SGI Indy with Irix 6.5 i get the errors
beneath.
bin/safe_mysqld[133]: ./bin/my_print_defaults: Program no
database,sql,query,table
-
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 PROTECTED]>
To unsubscri
06 13:38:46 mysqld restarted
InnoDB: Database was not shut down normally.
InnoDB: Starting recovery from log files...
InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 5 778892274
InnoDB: Doing recovery: scanned up to log sequence number 5 778957312
InnoDB: Doing re
Rich,
>06 13:38:46 mysqld restarted
>InnoDB: Database was not shut down normally.
>InnoDB: Starting recovery from log files...
>InnoDB: Starting log scan based on checkpoint at
>InnoDB: log sequence number 5 778892274
>InnoDB: Doing recovery: scanned up to log sequence number 5 778957312
>In
Sinisa, everyone,
That's great news! I'm excited to hear that. Which version would that
be... 4.0? Or perhaps another 3.x version?
In the meantime, my boss is going to wonder why I'm not populating a
database for him. He will make me use Access if I don't get cracking,
so... do you know of a
Why don´t you try
select TO_DAYS(end_date)-TO_DAYS(start_date) as duration : this will return
the difference in days
if you need mor accuracy i.e. difference in hours, you should word on a
TIMESTAMP 14 instead of date ; this data type holds up to seconds and is
mathematically easy to operate ...
i
Hi,
I'm currently working on a project in which I am working with CGI scripts
for a web based user interface, and MySQL for my database. I'm a student at
a University of Waterloo (in Canada). The program is a hotel reservation
system (irrelevant) and I'm coding in C and C++. The system is being
de
On 15 Nov 2001, at 22:32, Carsten H. Pedersen wrote:
> > Thanks for the response, but I think you missed the key
> > collection_field_value right under the primary key above.
>
> You're right -- Sorry. Have you tried COUNT'ing something
> other than *? i.e. document_id or resource_id?
I tried
> Rich,
>
>>06 13:38:46 mysqld restarted
>>InnoDB: Database was not shut down normally.
>>InnoDB: Starting recovery from log files...
>>InnoDB: Starting log scan based on checkpoint at
>>InnoDB: log sequence number 5 778892274
>>InnoDB: Doing recovery: scanned up to log sequence number 5 7789
Install the zlib RPM.
Abimael Ailton Machado wrote:
> Which drivers do you want to install?
>
> 1) MySQL only
> 2) mSQL only (either of mSQL 1 or mSQL 2)
> 3) MySQL and mSQL (either of mSQL 1 or mSQL 2)
>
> 4) mSQL 1 and mSQL 2
> 5) MySQL, mSQL 1 and mSQL 2
>
> Enter
On Thu, 15 Nov 2001 23:29:27 -0800, Jeremy Zawodny used
a few recycled electrons to form:
| On Thu, Nov 15, 2001 at 04:14:58PM -0600, Michael Brunson wrote:
| >
| > Has anyone ran any benchmarks as to what affect different number of
| > RAID_CHUNKS has on speed?
|
| The more chunks, the slower yo
You are missing the password and user, and the proper privilege
configuration at your server.
Read up on GRANT in the manual.
[EMAIL PROTECTED] wrote:
> Hi,
> I'm currently working on a project in which I am working with CGI scripts
> for a web based user interface, and MySQL for my database. I
Hi.
How can I make FTS index single-character words? I have tried changing the
ft_* values in my.cnf and rebuilding the tables/indices, but I still seem to
be unable to get indexing of single-character words to work.
For example, if I need to index occurences of c++, it doesn't work. I
unders
I am currently working on developing a database "viewer" specifically for
MySQL. I anticipate being able to finish it by this weekend and hopefully
release it sometime next week.
While I mostly developed it for myself, I would be interested in hearing
about the demand for something like this. My
This is a remedial question, but I am trying to get myisamchk to run from
the database directory. All I keep hearing is "put it in your path" and you
can run it from anywhere (as opposed to having to be in the bin directory to
execute it). I have searched the web, but haven't found a simple ans
you're probably not running the server on port 3306. when you start the
mysql server, use --port=3306
[EMAIL PROTECTED] wrote:
> Hi,
> I'm currently working on a project in which I am working with CGI scripts
> for a web based user interface, and MySQL for my database. I'm a student at
> a Uni
>Description:
I have 2 Servers one master and one slave.
The Master was 3.23.36 and the slave 3.23.44 and i start a replication
between these servers. Then i get errors:
error 'Unknown table 'o,i'' on query 'drop table db_logistik.o,db_logistik.i
from the replication server.
I found the bug i
George,
At a minimum, you have to setup a user with permissions to access the
database. Once you have that done I think it might work
[EMAIL PROTECTED] wrote:
>
> Hi,
> I'm currently working on a project in which I am working with CGI scripts
> for a web based user interface, and MySQL for my
Hi,
I've downloaded MySQL 3.23.44 and compiled on a Sparc Solaris 2.6
machine using gcc 2.95.3 and installed and started it all fine. But when
I goto try to use the MySQL client I receive an error that it cannot
find libstdc++.so.2.10.0. I've checked my system for this shared library
and
Hi all,
I feed data into a db and a jscript draws that data from the db and dumps it
in a Marquee on the pg but what happens is everytime i feed in data, there
is an sql update query which updates my db overwriting earlier data... but i
need to archive the data which i wrote earlier so am trying
Hi
I have items in a table identified by a Part Number. The Part Number may be
selected by inputting into a php search box (perhaps from users memory).
Example
Original
71HF-9601-AB
Searched for
71HF 9601 AB
or
71HF9601AB
or
Original
36 44 A9
Searched for
36-44-A9
or
3644A9
or with other se
Did you *start* mysqld? :>
Sounds to me like mysqld hasn't been launched. Check to make sure the server software
is actually running.
HTH
/Rob
>Hi:
>
>I telnet to the server. But I can not get into MySql
>database. What's the problem?
>
>
>% mysql
>ERROR 2002: Can't connect to local MySQ
At 04:38 -0500 2001/11/16, Jennifer Slis wrote:
> when I type "myisamchk" my server claims "command not found".
Check to see that myisamchk is in your path. Or go directly to the
/usr/local/mysql/bin directory (or where ever it's installed) and type ./myisamchk
[options]
HTH
/Rob
--
Robert
Stephen,
the manual erroneously states that CHECK TABLE only works for MyISAM tables.
I will update the manual. Thanks for pointing out!
>>> Run CHECK TABLE on your tables to check if they are corrupt.
>Does CHECK TABLE work on INNODB tables? According to the docs it only work
>for the MyISAM ty
I searched the archives and the manual online but could not find the
answer,
I believe this has been covered in the list though. Is it possible to
rename a
database? If not, is it possible to move/copy a table from a database to a
new
database? Could someone point me to the details on this?
--
Ch
I may found a solution to my problem
>Today my slave aborted replication with error (this is the third time
in 2 days)
Note that it worked for couple of months without a glitch
>It has aborted since the sql query had an error ?
>1. i think that if the query would have an error it should no
>Description:
-- trying to compile source dist 3.23.44 from tarball
-- OS: SuSe 7.0 with gcc 2.95.2
-- configure went fine, with the below specified options
-- I appended the configure output
-- make interrupts with the following error
sql_base.cc: In func
Hi,
I am a very beginner of mysql and studying the manul.
I tried "set password for user1=PASSWORD('paasw'); "
after logging in as root user.
Then I quit, try to login as 'user1':
C:\>mysql -u user1 -p
and then entered the password "paasw". There always an
error:
Access denied for user:'use
I'm using Free Pascal 1.0.4 and MySQL 3.22.32
System is RedHat 7.2 (but the same is on RH 6.2)
The Free Pascal package contains mysql unit which makes able to pipe sql
queryes from pascal to mysql.
All worked fine until 3.22.32.
But in 3.23.xx (tested on 3.23.38 and 3.23.44),the error with incor
stop mysql
cd /var/lib/mysql
mv olddbname newdbname
start mysql
[EMAIL PROTECTED] wrote:
> I searched the archives and the manual online but could not find the
> answer,
> I believe this has been covered in the list though. Is it possible to
> rename a
> database? If not, is it possible to move/
Hello,
I am trying to add a user to the mysql server so that they can access only
certain tables from one of the databases on the server. Anyway the command
that I give is:
GRANT SELECT,DELETE,UPDATE,INSERT,INDEX on clubnet.hsa_exec_listserv to hsa@"%"
identified by 'hsaadmin';
The table that
Before login with new account you must reload server with this command:
mysqladmin -u root -ppass reload
and then you could login with new account
-Messaggio originale-
Da: wei song [mailto:[EMAIL PROTECTED]]
Inviato: venerdi 16 novembre 2001 17.41
A: [EMAIL PROTECTED]
Oggetto: Access den
Ah, good idea. That should resolve my issue.
Thanks!
Zach
-Original Message-
From: Carsten H. Pedersen [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 15, 2001 2:08 PM
To: Zach Curtis; [EMAIL PROTECTED]
Subject: RE: Calculating Age
> I am trying to calculate an approximate age from
I've been setting up a Linux server at home to have for projects on the
side. I'm new to Linux game, but I think I've got everything set up okay.
The only trouble I'm having is getting MySQL to start up when the server
boots. I thought I'd ask here first--in case I have something w/ MySQL
configur
On Fri, 16 Nov 2001 [EMAIL PROTECTED] wrote:
> Date: Fri, 16 Nov 2001 11:40:06 + (GMT)
> From: [EMAIL PROTECTED]
> To: Rick Robinson <[EMAIL PROTECTED]>
> Cc: "Mysql \\(E-mail\\)" <[EMAIL PROTECTED]>
> Subject: Re: What maintenance is needed for MyISAM tables?
>
> On Thu, 15 Nov 2001, Rick Ro
Good morning, this is my first post to the group...
The brew is
Solaris 8(sparc/sunblade)
GCC.2.95.3 <---pkg install
Flex 2.5.4a < ---pkg install
Bison 1.28 <--- pkg install
Mysql 3.23.44 < compiled ( listed as stable version)
Apach
Hello all,
As I have written about in two earlier threads this week (you can read
them in the mysql.com archives at these URLs:
http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:sss:91326#b
and
http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:sss:91495#b
), I am unable to execute the "shutdown" command in my
This method will cause problems if you have entries in
you mysql.db table for that database.
Just make sure you correct your permissions.
On Fri, 16 Nov 2001 11:46:31 -0500, Danny Rathjens
<[EMAIL PROTECTED]> wrote:
| stop mysql
| cd /var/lib/mysql
| mv olddbname newdbname
| start mysql
|
| [
Erik Price writes:
> Sinisa, everyone,
>
> That's great news! I'm excited to hear that. Which version would that
> be... 4.0? Or perhaps another 3.x version?
>
> In the meantime, my boss is going to wonder why I'm not populating a
> database for him. He will make me use Access if I don't get
Dear all,
I have the following query:
SELECT distinct pf.*
FROM homo_sapiens_lite_120.gene lg,
homo_sapiens_lite_120.gene_prot lgp,
homo_sapiens_core_120.protein_feature pf
WHERE lg.chr_name = 'chr22'
AND lg.gene = lgp.gene
AND lgp.translation_id = pf.transla
On Thu, 15 Nov 2001, Jonothan Farr wrote:
> There's no way to know that without knowing the schema of the
> table you're inserting into. How you index it is going to be the
>biggest factor there.
just a plain file with 2 columns - one of them is a decimal field -
taht's all.
cu,
fns
-[ mailto:[
Well, I really do need the exact timespan in human-readable format. What I
did do was get the difference in seconds, then properly format that manually.
:/
Thanks anyway though.
On Friday 16 November 2001 07:24 am, Walter D. Funk wrote:
> Why don´t you try
> select TO_DAYS(end_date)-TO_DAYS(st
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
El Viernes 16 Noviembre 2001 08:23, escribiste:
> Hola a todos.
> Alguien tiene una herramienta para exportar tablas dbf a MySql?
>
> saludos
> Gastón
>
Puedes usar dbf2mysql. Saludos.
- --
Alfredo J. Cole
Tegucigalpa, D. C., Honduras
http://www.ac
Hi all,
it turns out that I'm trying to join a varchar(40) to an int(10). I didn't
know MySQL allows this (and does it correctly, apparently through an
intermediate table).
Sorry to not have noticed earlier.
Is there a way to get more strict behaviour, just to catch errors like this ?
Thanks
A couple of weeks ago, Stephanie Wall, Associate Publisher with New Riders offered
list members copies of Paul
DuBois' "MySQL and Perl for the Web", in exchange for a review.
I managed to end up with an extra copy. It would be expensive to send back. Stephanie
has granted
permission/asked me to
Hi!
On Nov 16, Erik Price wrote:
> Until the next release is available, I must use the
> dreaded "kill -9" shell command to shut down the MySQL daemon, which
> may corrupt data in the database
It shouldn't if you'll execute FLUSH TABLES before.
Actually,
mysqladmin shutdown && sleep 60 && k
Hi all,
I am trying to insert data from a form which has 4 fields such that the data
always sits at the top in my database occupying locations :
SEC_ID: 1, 2 , 3 & 4
Everytime i insert data the data gets appended at the end i,e, if the first
4 fields are occupied my data takes the postions 5,6
In the last episode (Nov 16), Erik Price said:
> Alternatively, I am open to a workaround until the working version is
> released. I can actually use MySQL (as far as I know), it's just the
> "shutdown" that hangs. I have to use "kill -9" in order to kill the
> daemon. This makes me worry about
> I need to know how if the same structure of a data
base can be
> placed mysql in different nodes from mosix, soon to
make a
> question and that can respond to me as if outside a
single one.
>
> Example:
>
> NODE1 NODE2 NODE3
> DBTABLE DBTABLE DBTABLE
> DAT
The answer, I guess, is don't use DECIMAL.
I understand now the need for a fraction (someone pointed out that Euro
calculations must be done in upto 4 decimal places with rounding).
All I can say is that:
(a) you multiply the amounts by 1 (so as to deal with integers), and
(b) Split each am
--- Dan Nelson <[EMAIL PROTECTED]> wrote:
> As long as there are no active connections, killing mysql will not
> affect the database. If you kill mysql during an update, you risk
> corrupting any indexes on the tables being modified. If your tables
> are BDB or InnoDB format, you should be able
Kristian Köhntopp wrote:
> Bennett Haselton wrote:
>
>>The problem is, how would you add a new bus and a new driver to the
>>database? Whichever one is added first, you're going to get an error
>>because its counterpart doesn't exist yet, violating referential integrity.
>>
>
> I was under the
Today I'm discovered strange behavior of SQL query
UPDATE tablename SET value=value+const WHERE ...
UPDATE tablename SET value=value-const WHERE ...
UPDATE tablename SET value=value*const WHERE ...
UPDATE tablename SET value=value/const WHERE ...
I have incorrect results of this queries only in R
In the last episode (Nov 16), Erik Price said:
> --- Dan Nelson <[EMAIL PROTECTED]> wrote:
> > As long as there are no active connections, killing mysql will not
> > affect the database. If you kill mysql during an update, you risk
> > corrupting any indexes on the tables being modified. If your
Is there a way I can import data from a mysql using the mysql files?
They weren't created using mysqldump; they were just copied from another
directory. For example, I have the files:
databasename/table1.frm
databasename/table1.MYD
databasename/table1.MYI
how can I bring these into mysql? Mysq
Find where the tablespaces are located on your server (mine is under:
/usr/local/mysql/data).
Move all your files(table1.*) below to the tablespace directory you choose.
Then login to mysql and do a "show tables". Remeber you must login as
some_user and choose the table space name you moved you
Hi there,
I'm wondering if someone can help me figure out how the following SELECT can
be improved.
SELECT count(*)
FROM mm_ind_intrst mm0 STRAIGHT_JOIN ind
STRAIGHT_JOIN mm_ind_intrst mm1
WHERE ind.cust=8 AND ind.mail_list=1
AND ( (mm0.intrst='148' AND mm
If they are not owned by mysql, mysqld can't read them.
Chris Bergeron wrote:
> Is there a way I can import data from a mysql using the mysql files?
> They weren't created using mysqldump; they were just copied from another
> directory. For example, I have the files:
>
> databasename/table1.fr
Hi,
I tried to compress some very big table on Linux and it seems to me that
myisampack does not properly remove temporary files after abort.
After myisampack cannot write to a file (because the filesystem is
full), it should at least remove the .TMD file after itself, I hope. :(
Since then,
I have a database defined, and a data file that needs to be imported into
the table.
I'm using Red Hat Linux 7.0 as my operating system, and mysql server is
loaded and running on linux.
When I type >LOAD DATA INFILE '/home/usrename/datafile.ext' ; I receive the
following error:
Error 13: Can
Hi Roger,
You might just need to set File_priv='Y' in the "user" table in the "mysql"
database for the user that you logged into MySQL as.
Don't forget to do a "flush privileges;" after you make the change so that
it takes affect.
-Joe
> -Original Message-
> From: Greenlaw, Roger [mail
>>I tried changing my file using chmod 777 datafile.ext and confirmed that I
am the file's owner. Can anyone help me?
Your user directory /home/usrename doesn't allow the mysql process to read
files within it (it uses user 'nobody')
Either change the access to your home directory, or put the dat
Hello,
I am wondering if there is any method available to switch this
Mysql list to digest mode?
I do not want to unsubscribe, but this list generates tons of
email everyday. I have looked at the site and do not see any
indication that this is within the list structure.
Thank you for your assis
System: FreeBSD 4.4-STABLE
MySQL version: 3.23.43
UDF code: http://www.aros.net/~lump/udf_int_ip.cc
I've been trying to implement my own loadable function for mysql. I needed
a function which converts a 4-byte integer into an IP address. I wrote a
UDF for mysql, and It compiles fine, but when
I have a FreeBSD 4.4-STABLE machine with two CPUs running mysql-3.23.44.
I'm wondering about how to make MySQL use both CPUs. Am I correct in
saying:
1. The binary distribution of MySQL for FreeBSD from www.mysql.com does
not make use of both CPUs.
2. The only way to make MySQL use both CPUs on
Hello Sandeep!
> I am trying to insert data from a form which has 4 fields such that the data
> always sits at the top in my database occupying locations :
>
> SEC_ID: 1, 2 , 3 & 4
>
> Everytime i insert data the data gets appended at the end i,e, if the first
> 4 fields are occupied my data tak
On Fri, Nov 16, 2001 at 10:18:44PM -0500, Philip Mak wrote:
>
> I have a FreeBSD 4.4-STABLE machine with two CPUs running
> mysql-3.23.44. I'm wondering about how to make MySQL use both
> CPUs. Am I correct in saying:
>
> 1. The binary distribution of MySQL for FreeBSD from www.mysql.com does
>
INSERT always places data at the "end" of the table. SQL makes no assumptions
about the ordering of data. If you specify no order, you get "arrival
sequence", being the order the data was written to the table. If you want to
see the data in a certain order, you must order it with the ORDER BY clau
On Fri, 16 Nov 2001, Jeremy Zawodny wrote:
> > Where can I find instructions for compiling MySQL on LinuxThreads?
>
> Try out the FreeBSD MySQL port. I've been told that it's trivial.
What's the URL for that?
-
Before posting
In the last episode (Nov 16), Philip Mak said:
> I have a FreeBSD 4.4-STABLE machine with two CPUs running
> mysql-3.23.44. I'm wondering about how to make MySQL use both CPUs.
> Am I correct in saying:
>
> 1. The binary distribution of MySQL for FreeBSD from www.mysql.com
> does not make use of
In the last episode (Nov 16), Philip Mak said:
> On Fri, 16 Nov 2001, Jeremy Zawodny wrote:
>
> > > Where can I find instructions for compiling MySQL on LinuxThreads?
> >
> > Try out the FreeBSD MySQL port. I've been told that it's trivial.
>
> What's the URL for that?
http://www.freebsd.org/p
G'Day All.
I'm trying to do the following in a query, in mySQL.
All my previous years of SQL has been on MS-SQL, and i'm having some little
problems with tricky sql statements.
*
i'm trying to insert a new record if the name doesn't exist in the table. If
i insert, return ID, else return 0
*
88 matches
Mail list logo
