Excuse my naivety but how do I create a Table in MySQL?
I cant find any Text/Windows based programme that allows be to create and
edit the table, fields, data types, size etc?
Im not looking for anything complex.
Many thanks,
Ed
Edward Hasted
Contact Information:
E-mail : [EMAIL PROTECTED
the
message to user.FRM but still crashes.
The err file also showed a problem as a result from the
incorrect GRANT command:
Found invalid password for user: 'edward@%'; Ignoring user
Moving the *bin*, *err*, and mysql/ directory and replacing
age to user.FRM but still crashes.
The err file also showed a problem as a result from the
incorrect GRANT command:
Found invalid password for user: 'edward@%'; Ignoring user
Moving the *bin*, *err*, and mysql/ directory and replacing
them from a backup
What does your script look like? Code?
Ed
On May 13, 2006, at 5:46 PM, Steve wrote:
I'm fairly new to all this and duing everything step by step...
I made my first (test) php site - and it works... then, i have this
script
where i'm supposed to find out if MySQL and PHP talk with each
oth
Ahmad Al-Twaijiry wrote:
Hi everyone
SELECT * FROM tbl_name WHERE SUM(Total)=100 ORDER BY ID
SELECT ID FROM tbl_name GROUP BY ID HAVING SUM(Total)=100 ORDER BY ID
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[E
Doesn't that change when you hook up to a database?
On Oct 30, 2006, at 12:56 PM, João Cândido de Souza Neto wrote:
Ok, we are in the same snag.
Who gets the solution firstly please, share it.
""Joshua J. Kugler"" <[EMAIL PROTECTED]> escreveu na mensagem
news:[EMAIL PROTECTED]
On Sunday 29
Francis wrote:
Question about MyISAM vs InnoDB ? What is the best to use, I have
a large table contain around 10 millons of records. What is the best
for me ? Use MyISAM or InnoDB ?
Depends VERY much on your application. If any concurrency and/or
durability is required then I would
Francis wrote:
Question about MyISAM vs InnoDB ? What is the best to use, I have
a large table contain around 10 millons of records. What is the best
for me ? Use MyISAM or InnoDB ?
Depends VERY much on your application. If any concurrency and/or
durability is required then I would
Dear Community,
My team and I have been experiencing an interesting mysql error
during the past few weeks of testing. Here is the scenario we are
trying to accomplish. We are essentially working to use MsAccess as a
windows client for a linux based mysql databases. We have installed
myO
Marcus Bointon wrote:
I installed (as root) the standard rpms over a working 4.1.10a
installation (also from standard rpms) from the mysql site with rpm - U,
and all went ok, except that the server failed to start after the
upgrade. I had a look at it from webmin too and noticed that it was
Michael Stassen wrote:
Stephen A. Cochran Lists wrote:
On Sep 27, 2005, at 3:29 AM, Jasper Bryant-Greene wrote:
mysql> SHOW CREATE TABLE Player|
| Player | CREATE TABLE `Player` (
`id` int(16) NOT NULL auto_increment,
`first_name` varchar(32) NOT NULL default '',
`last_name` varchar(32
Kevin Liu wrote:
This looks great! Is there anything like this for Mac OS X?
Kevin
On 10/2/05 10:39 PM, "Ligaya Turmelle" <[EMAIL PROTECTED]> wrote:
+1 - it is wonderful.
olinux wrote:
You will love this.
http://www.fabforce.net/dbdesigner4/
I know it's not 'running on OSX', but I do m
Graham Reeds wrote:
Bruno Cochofel wrote:
Does anyone know a sw that can reverse engineering a mysql table? I
want to
be able to draw a entity-relationship model from an already made MySQL
table.
[snip]
Also people say great things about DBDesigner4 but I haven't used it to
talk about it
Bruno Cochofel wrote:
Thank you all for the posts. Can anyone explain to me how can I connect
DBDesigner4 to MySQL 4.x? I've never used MySQL 3.x and I believe
there's some kind off trick to connect DBDesigner4 to MySQL 4.x because
the program doesn't support the MySQL 4.x
Or the ODBC connection
Bruno Cochofel wrote:
From http://www.mysqlusers.com/msg/37105.html we have:
<>Reset the password to pre-4.1 style for each user that needs to use a
pre-4.1 client program. This can be done using the SET PASSWORD
statement and the OLD_PASSWORD() function:
mysql> SET PASSWORD FOR 'some_user'@'so
.
---
Edward David
Sr. Systems Analyst
University of Calgary
Information Resources
Information Technology Service
---
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
The MySql manual in section 2.4.15.6.2 mentions building MySql from the
Windows source distribution. I need to do this in order to add SSL
support to my MySql server on Windows.
From where do I download the Windows source distribution ?
The source distributions listed at
http://dev.mysql.com/
Warren Young wrote:
> Edward Diener wrote:
>>
>> The source distributions listed at
>> http://dev.mysql.com/downloads/mysql/5.0.html#source do not specify
>> any as the Windows source distribution. I downloaded the .zip file,
>> thinking that might be the one, but
In the MySql manual section 5.5.7.2 it specifies how to build MySql on a
Unix/Linux platform with SSL by using 'configure'. I need to build MySql
for Windows with SSL support. In section 2.4.15.6.1 for building MySql
for Windows itr specifies the available options for using win/configure,
but S
I have a few questions about the parameters for SslOption/mysql_ssl_set
( C++/C ) and about SSL in general between the server and the client.
I do understand what a certificate, a private key, and a public key is
in general but I am having trouble understandng how they work in MySql.
1) Are the
I have a few questions about the parameters for SslOption/mysql_ssl_set
( C++/C ) and about SSL in general between the server and the client.
I do understand what a certificate, a private key, and a public key is
in general but I am having trouble understandng how they work in MySql.
1) Are the f
I had previously installed the 64-bit version of MySQL 5.1 server under
Windows Vista x64 and both the installation and configuration were
successful. Then for compatibility reasons with something on which I am
working I realized I needed to install the 32-bit version of MySQL 5.0
server. Since
Hi, I am having all sorts of problem getting apache to accept its MD5
version, this is from a CRM using perl
I've tried concat $apr1$foo$ and md5(bar)
as best I can tell It doesnt like the md5 part
Is there anyway to get this to work? the only thing that does is encrypt,
and thats sad, with only
rk
> Am 06.03.2011 05:34, schrieb Edward avanti:
> > Hi, I am having all sorts of problem getting apache to accept its MD5
> > version, this is from a CRM using perl
> > I've tried concat $apr1$foo$ and md5(bar)
> > as best I can tell It doesnt like the md5 part
We have aded an internal domain, its assigned the latest id ( 20433), we
have safeguards in our portal that stop domains with id less than 5 from
being deleted, the table doesnt show "3" so it is not used, but when I try
alter the table it fails:
update virtual_domains set id='3' where id='20433'
#x27; matches though Is such a thing possible?
MySQL full-text searching is out as I'm using InnoDB tables.
Does anyone have any suggestions?
Thanks!
Edward
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
>
> Hello i use this query:
>
> select i.item_id
> from orders o
> INNER JOIN item i ON i.nr=i.nr
Should the line above not be
... ON i.nr = o.nr ?
> INNER JOIN user_cart u ON u.nr=i.nr
> where (i.count !=0 or i.count!=NULL) and i.isactive=1 and i.kolWo>0
> order by i.count DESC
> LIMIT 5
>
Hi,
I am trying to join a bunch of tables together. I want a row for each
"learner", and on the row, I want some "user", "centre", "client" and
"centreManager" information if there is any. Thus, I am trying to outer join
from the "learner" table to 4 other tables. The query I have so far is bel
Hi,
I hope this finds itself as an answer to my last post. I'm new to this email
message format of lists.
It turns out that the problem with the join was that I had a column being
selected that I removed from my posting example for brevity which was
causing the select to fail. The extra c
ainst using any upper-case characters in your web folder
names (URLs) as this can lead to annoying problems later down the line. It's
much simpler to keep it all lowercase.
Edward
> -Original Message-
> From: Nicoleen Nel [mailto:[EMAIL PROTECTED]
> Sent: 17 January 2008 13:3
gt; and if i starts from id 6, i should be able to select 6 and 9 and no more.
>
> How can I do that?
>
SELECT * from list WHERE properties = 1 AND id >= [starting ID] LIMIT 2;
Edward
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi,
I have a load of reviews in a table and, for each person I want to pull out
the most recent review.
So, if I wanted to do this for a single person I would order by date desc
and use "limit 1". But I'm not sure how to do this in bulk.
Thanks.
PROTECTED]
Cc: mysql@lists.mysql.com
Subject: Re: Selecting the most recent entry for each object.
Hi,
On Thu, Mar 20, 2008 at 10:35 AM, Edward Corbett <[EMAIL PROTECTED]> wrote:
> Hi,
>
>
>
> I have a load of reviews in a table and, for each person I want to pull
out
> the
> We have just moved to a new web server where we are running mysql
> version: 5.0.45
> On the old machine, when we gave the following command:
> update table1 set passwd = password('xx') where user_name="xx";
Here you're updating 'table1'...
> and then gave the following command,
> SELECT us
Hi, this is my first time installing the MySQL server. I have built
and installed the databases/mysql60-server via the FreeBSD ports
system (using default configuration options). But let me discuss my
installation procedure, adopted from the manual:
The mysql group and user are already added by th
I signed up for the Server | General Discussion mailing list using an
e-mail address I created at my web host, and through which I have
received numerous e-mails without problem. The subscription went
correctly. I then attempted to send a message to the GMane newsgroups
which mirrors the list.
> How can I change character_set_xxx variables in MySQL 4.1.x in Linux?
SET NAMES ''
http://dev.mysql.com/doc/refman/4.1/en/charset-connection.html
Edward
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
fields).
Ideally I should be able to achieve this with ORDER BY
CONCAT(first_name,last_name,company_name) but of course this doesn't work
because CONCAT returns NULL if any of its arguments are NULL (which will
always be the case).
Any ideas?
Edward
--
MySQL General Mailing List
For
> From: Baron Schwartz
> Hi Edward,
>
> Edward Kay wrote:
> > Hi,
> >
> > I have a query that returns data from a join of two tables, person and
> > company. The results look like:
> >
> > FIRST_NAME | LAST_NAME | COMPANY_NAME
> > -
etter in my opinion.
I've just download Toad - and have to say it looks pretty good. It doesn't
appear to have the graphical representation of DB Designer but it may well be a
good replacement for the three MySQL AB tools mentioned above.
I'd be interested to hear other options though...
Edward
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
#x27;data' not 'date' :) He is talking about a reference number that
needs to be in a certain format.
I too would argue that this requirement is more application layer than in
the database. Surely anyone editting the tables directly should know what
they're doing and adhere to th
single_rooms, double_rooms, twin_rooms) < 10,1,0) from TABLE;
Edward
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ooms from TABLE;
Or, if you want a boolean value depending if there are less than 10:
SELECT IF((single_rooms+double_rooms+twin_rooms) < 10,1,0) from TABLE;
Edward
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
to do
>
> inet '192.168.1/24' >> inet '192.168.1.5'
>
> http://www.postgresql.org/docs/current/static/functions-net.html
>
> Is there anyway to do this using MySQL?
>
Although it wouldn't be as need as using the >> and similar operators, you
co
asking here for an answer?
Assuming you now want to do this transformation at the database layer,
select the three date components out separately with the string functions
and then use DATE_FORMAT() to print them how you want.
http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html#fun
> SELECT * FROM news WHERE display='yes' ORDER BY id desc limit 1
>
> Think this would get the lastest article that is to be displayed
> but how do I get the second one.
>
Just add an offset to the LIMIT clause:
SELECT * FROM news WHERE display='yes'
to be able to create and update databases
> > (tables, indexes and so forth). I would rather do this than do it via a
> > command line. I would appreciate any links available.
> >
> > Andrew
> >
Also look at Toad: http://www.quest.com/toad-for-mysql/
Edward
--
MySQL
Hi,
I have the following mySQL query in my script which has been working fine
but due to a recent change, I had to modify one of the columns,
bt.category_ID. This used to be defined as tinyint(3) but I've changed that
now to varchar(20) as it needs to hold values such as 15, or 74:79 or
43:56
will work fine. If it's an integer type, you are going to have a
problem because you have bt.category_ID holding things which can't be
represented as integers and will therefore never match. IF both
column type are being changed here, your query will work fine as is.
- michael dykman
On
defined function to do those comparisons.
On 6/14/07, Edward Quick <[EMAIL PROTECTED]> wrote:
Thanks, that's interesting. Actually the uc.ID column is still type
tinyint
as it holds only one number, but are you saying if I change this to
varchar
my query will work e.g. 15 = 15:17 wo
ience with
mySQL. If it's not too much trouble, could someone give me a bit more help
on how to do that please?
Ed.
no, those won't match based on just the datatype change.. you will
have to define a user defined function to do those comparisons.
On 6/14/07, Edward Quick <[
rimary = 0
);
Normally, I'd only return the address_id in the sub-SELECT, but I need the
is_primary column for the HAVING clause.
Any ideas on how to achieve this?
Thanks,
Edward
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.m
> -Original Message-
> From: Dan Nelson [mailto:[EMAIL PROTECTED]
> Sent: 15 June 2007 19:24
> To: Edward Kay
> Cc: MySQL List
> Subject: Re: Hiding columns used in GROUP BY and HAVING clauses
>
>
> In the last episode (Jun 15), Edward Kay said:
> >
it doesn't have to be in the
> HAVING clause.
No, because that's not the same thing. Imagine the following data:
address_id primary_entity_id is_primary
---
1293 0
2 293 1
With my
t; >
> >
> > With my query above, the sub-query result set would be empty since
> > count(primary_entity_id) = 2.
> >
> > If I move the is_primary = 0 requirement to a WHERE clause,
> then the first
> > row would be incorrectly updated since the group function would only be
> > working on the sub-set of data (where is_primary = 0).
> >
> > It's a subtle but important difference.
>
> Then I think what you really want in your HAVING clause is "AND
> MIN(is_primary)
> = 0".
>
> Baron
But I'm first grouping by primary_entity_id and then only selecting the rows
where count(primary_entity_id) = 1, so is_primary clause will only ever be
working on one value.
Edward
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
> -Original Message-
> From: Baron Schwartz [mailto:[EMAIL PROTECTED]
> Dan Nelson wrote:
> > In the last episode (Jun 18), Edward Kay said:
> >> From: Dan Nelson [mailto:[EMAIL PROTECTED]
> >>
> >>>>>> At the moment, I have thi
he right join
statement. I think
right join user friend on ... should be
right join friend on ...
Edward
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
gine? If so, what is
> >the command/process to make this happen.
> >
Can't you just remove the INSERT/UPDATE/DELETE priviledges from the user(s)
concerned?
Edward
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ta infile "table.csv"
into table table_name
fields terminated by ',' enclosed by '"'
lines terminated by '\r\n' starting by ''
ignore 1 lines;
The CSV file has Windows line endings and is imported by MySql on Linux. You
wouldn't need the enclosed by bit for your data though.
HTH,
Edward
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
llation settings, if this is the cause for my problem,
> or if there might be any other reason for it. My mysql version is
> 5.0.26-12, running on a Suse Linux 10.2.
>
> Best regards,
> H.
Try using the SET NAMES 'utf8' statement [1] to tell MySQL that your client
is s
es less than a second, so there is practically no
downtime.
Note that this works well as most of my DB is 'read-only'. I have to be more
careful when updating any tables that are written to via the app.
HTH,
Edward
--
MySQL General Mailing List
For list archives: http://lists.mysql.co
always
> matched the OS time.
>
> Thoughts appreciated.
>
> Thanks,
>
> David
I suspect MySQL is configured with a differect timezone/locale from your OS.
See http://dev.mysql.com/doc/refman/5.0/en/localization.html for info.
Edward
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ery Browser and MySQL Administrator) but I prefer Toad:
http://www.quest.com/toad-for-mysql/
HTH,
Edward
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
public static function TranslateAccentedChars($strInput) {
$strAccentedChars=
"¥µÀÁÂÃÄÅÆÇÈÉÊËÌÍÎÏÐÑÒÓÔÕÖØÙÚÛÜÝßàáâãäåæçèéêëìíîïðñòóôõöøùúûüýÿ";
$strNonAccentedChars =
"SOZsozYYuAAACDNOOYsaaaconooyy";
return strtr($strInput, $strAccentedChars,
$strNonAccentedChars);
}
HTH,
Edward
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
?
>
You could create an extra 'standardised' column that is used for searches. I
discussed this in another post last week -
http://lists.mysql.com/mysql/209197
Edward
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Forgive me for blowing my own trumpet here.
The advantage with ShellSQL over this method is
1 - The output is not cluttered with headers, and a means exist to
easily separate fields when there is more than one column or row in the
query.
2 - The connection is persistant, whereas running "mys
Hello,
The new version of DBACentral for MySQL has been released.
DBACentral v1.6 presents powerful report building functionality,
query-based forms, reports and web pages, lookup fields showing
multiple column values, and other improvements
Download the new version of DBACentral for MySQL righ
hey all,
I'm trying to convince some people here to adopt MySql as a relational database
here. However, we can't start from a clean slate; we have a very mature oracle
database that applications point to right now, and so we need a migration path.
I was thinking of taking the following steps:
On Sun, Jun 05, 2005 at 04:41:16PM -0700, sol beach wrote:
> IMO, you have much more a lively imagination than realistic, in depth
> & technical knowlege in either MYSQL or Oracle.
> Current production MYSQL does NOT have stored procedures.
Current production mysql doesn't, but current development
Hi
Announcing ShellSQL 0.7 to an unsuspecting world...
ShellSQL is a utility to allow SQL to be intergrated easily into
UNIX/LINUX shell scripts.
The web page is at http://www.edlsystems.com/shellsql - and at
sourceforge at http://sourceforge.net/projects/shellsql .
Version 0.7 includes many bu
Funny you should mention that
May I guide you to my recent announcment of ShellSQL 0.7 - web page at
http://www.edlsystems.com/shellsql - a utility to do just as you want (I
think) released under GPL.
It must be good - I wrote it myself :-)
Yours
Eddy
Andy wrote:
Hi all
I just wanted to know
are the same).
Thanks for your patience
Eddy
Edward Macnaghten wrote:
Hi
Announcing ShellSQL 0.7 to an unsuspecting world...
ShellSQL is a utility to allow SQL to be intergrated easily into
UNIX/LINUX shell scripts.
The web page is at http://www.edlsystems.com/shellsql - and at
sourceforge at http
I've got a task that's gonna require me to compare one table to another
and remove the rows from the first table that are found in the second
table that match email_address.
I'm running 4.0.20a-nt-log. The first table has 10 colomns and about 50K
records, and the second table has 46 columns and
help?
Ed
Stefan Kuhn said the following on 7/20/2004 12:05 PM:
I would expect that the speed problems are due to missing indices. Did you do
proper indexing? If unsure, post your table structures and query.
Stefan
Am Tuesday 20 July 2004 17:45 schrieb Edward Ritter:
I've got a task that'
d:
ALTER TABLE la_entire
ADD INDEX idx_email_address (email_address);
ALTER TABLE la_final
ADD INDEX idx_email_address (email_address);
See:
http://dev.mysql.com/doc/mysql/en/ALTER_TABLE.html
On Tue, 2004-07-20 at 09:22, Edward Ritter wrote:
Stefan:
I added an index column t
Thanks, adding the indexes worked beautifully. I'll go knock my head on
the desk now. Thanks for your time :)
Ed
Edward Ritter said the following on 7/20/2004 1:08 PM:
Thanks, I'll take a look at that. The id isn't unique, so that's why I
added the idx column.
Does my qu
rson who may need our products with
this coupon.
--
Best regards,
Edward Smirnov
microOLAP Technologies LTD
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hello All,
DBACentral for MySQL has been released!
===
The long-awaited headliner of the DBACentral Product Family has been
finally released!
We are proud to present an absolutely new product which brings MySQL
database management to the new level of fastness
I am with a small business in Southern California that would like to migrate
our MS Access databases to MySQL server. Are their any computer service
companies who can help me?
-
Before posting, please check:
http://www.mysql.
Hello,
I'm using MySQL 3.23.32 and PHP. When an URL is retieved from the database,
two things can happen:
1. it's working
2. it's not working and in look like:
"http://localhost/"http://www.test.com/";
My big question: WHY using the same DB the URL is well retreived in a page
and wrong in another
Hello,
I'm using MySQL 3.23.32 and PHP. When an URL is etieved from the database,
two things can happen:
1. it's working
2. it's not working and in look like:
"http://localhost/"http://www.test.com/";
My big question: WHY using the same DB the URL is well retreived in a page
and wrong in
Is it possible to have global access to all databases using the new odbc
driver? For example I have an app that uses more than one table owner. In
Mysql, I had to set up a db for each owner but when I try to connect through
the odbc, I don't have access to all the databases, just one. How can I
Is it possible to specify more than one owner in a mysql db? I want to
create tables with different owners.
Thanks,
Eddie
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.
, 2002 11:00 AM
To: [EMAIL PROTECTED]
Subject: more than one owner?
Edward,
Friday, March 01, 2002, 5:25:23 PM, you wrote:
EP> Is it possible to specify more than one owner in a mysql db? I want to
EP> create tables with different owners.
Yes, it's possible. You can specify many
eate tables
prefixed by the db name, eddie.table1, eddie.table2. correct
Thanks,
Eddie
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of Van
Sent: Friday, March 01, 2002 12:57 PM
To: Edward Peloke
Cc: [EMAIL PROTECTED]
Subject: Re: more than one owner?
Does anyone know if there is a good profiler to use on MySql, for example,
in SQL Server, you can start the 'profiler' and it will tell you everything
that is happening on the server.
Thanks,
Eddie
-
Before posting, please chec
I need to have access to all the databases on my server using one ODBC
connection. Currently, I have to specify the db and only have access to
that one...is there a way around this? How about SQL Links?
Thanks,
Eddie
-
Before
I asked yesterday but got no responses...anyone have any ideas how I can use
one odbc connection but have access to all databases on the MSSQL server???
Thanks,
Eddie
-
Before posting, please check:
http://www.mysql.com/manua
Does anyone have any good tools for putting a trace on an MySql server. I
want to be able to see what is happening on the server.
Thanks,
Eddie
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
ot initiate the
>download. My provider is Comcast Cable.
>
>What is the problem?
-------
Edward F. Chase III | [EMAIL PROTECTED]
Providence College | http://www.providence.edu
Computer Services | http://s
I am working with the MySql++ 1.7.9 on windows98 using borland C++ 6.0.
I have found and fixed a memory leak ( applicable on all platforms that need
the __USLC__ conditional defined) , and sucessfully ported the system to
borlanbd C++ 6 with a very minimum of modifications. (mostly resolving
in
How do I add defaults to a table? In SQL Server I can simply write
columnname bit null constraint defaultname default (0)
when I create the table.
Thanks,
Eddie
-
Before posting, please check:
http://www.mysql
program on RH 6.2 (binutils 2.9.5.0.22) could not strip
the executable (format not recognized). but I could strip it on RH 7.2
(binutils 2.11.90.0.8).
Could the rpms be repackaged with stripped executables?
Edward Rudd
-
Before
I am new to MySql and am trying to learn PHP in conjunction with MySql. The
webpage that I want to create will benefit from stored procedures. Are
these available with MySqlMax? If so, is it setup the same way as MySql?
Thanks,
Eddie
--
So is there really any benefit to using MySql Max?
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of
Iikka Meriläinen
Sent: Thursday, September 05, 2002 3:53 PM
To: Edward Peloke
Cc: [EMAIL PROTECTED]
Subject: Re: mysql max
Hello,
As of this writing
Hi
You should use the following construction:
SELECT LAST_INSERT_ID ();
This will return the last auto-increment value for the current connection.
There is also an API function, and in PHP: mysql_insert_id or something like
this.
-Original Message-
From: Jason Brunk [mailto:[EMAIL PRO
You should refer to manual, your case depends on the type of your table.
MyISAM tables do assign new number always, and there's some another kind of
table which is reusing numbers the same way you need. I don't remember what
type exactly, so refer to the manual.
-Original Message-
From:
the root login.
Is there any other way to restore the database, or should i try and
re-install? (No data will be lost)
Also, if a reinstall is the only way, does anyone have any experience of
doing this remotely, on a Cobalt Raq4 server?
Thanks very much in a
hey all,
I'm getting the following error when i try to compile 3.23.33 -
ha_berkeley.cc:105: type specifier omitted for parameter
ha_berkeley.cc:105: parse error before `)'
ha_berkeley.cc: In function `bool berkeley_init()':
ha_berkeley.cc:143: no matching function for call to `__db_env::set_not
On Fri, Feb 23, 2001 at 11:20:03AM -0700, Ashley M. Kirchner wrote:
> Edward Peschko wrote:
>
> > I *then* talked to berkeley db, and they said 'well, mysql distributes its own
> > copy of berkeleydb with modifications. Is this true? If so, where do I get it?
>
1 - 100 of 143 matches
Mail list logo
