Martijn van den Burg wrote:
On Wednesday 28 September 2005 20:47, Siegfried Heintze wrote:
Other databases allow one to store comments describing each field in a
table definition. These are stored in the database. In addition, one can
store comments about the table. Examples include MS SQL
I'm trying to compile the mysql c++ api with mingw
When I run configure I get this error what could it be ?
loading cache ./config.cache
checking whether to enable maintainer-specific portions of Makefiles... no
checking for MySQL library directory... configure: error: Didn't find
the mysql
[EMAIL PROTECTED] wrote:
How do you DELETE or RENAME a table?
Thanks.
alter table TABLENAME rename NEWNAME;
drop table TABLENAME;
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hey,
Here is what I want to do
I have 2tables
let's say table A and B for simplicity.
in table A I have column id
and in table B I have column A_id
I insert a new value into table A insert into a values(NULL)
Since id is auto_incremenet and the primary key it will have an auto value.
Now I want
I'm using php + mysql for my project
I want to get the last insert ID.
I could use the php function mysql_last_id();
but I could aslo use @@identity.
Now some people have advised me NOT to use @@identity, cause it's not
save buggy sometimes slow ..
is this true am I better of with the php
Don Read wrote:
On 18-Jun-2003 Jonas Geiregat wrote:
I'm using php + mysql for my project
I want to get the last insert ID.
I could use the php function mysql_last_id();
but I could aslo use @@identity.
Now some people have advised me NOT to use @@identity, cause it's not
save buggy sometimes
- Original Message -
From: Jonas Geiregat [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, 17 June, 2003 13:44
Subject: transactions with php
I'm trying to implement transaction (mysql) in my php code. Could anyone
tell me if this is a good way of using them. I make an array with all
www.becomingdigital.com
- Original Message -
From: Jonas Geiregat [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, 17 June, 2003 13:44
Subject: transactions with php
I'm trying to implement transaction (mysql) in my php code. Could anyone
tell me if this is a good way of using them. I make an array with all
I'm trying to implement transaction (mysql) in my php code. Could anyone
tell me if this is a good way of using them. I make an array with all
the query's I loop through them. like this mysql_query($qarray[$i])or
die($flag = false);. After the loop I do if($flag) commit; else rollback;
Is this
I really don't get the user of NOT NULL
anyone knows a good page on the manual that talks about it I can't seem
to locate one.
Or any good resource help to help me figure this out would be greate regards
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
| user_id | Marks | Now I have an other table where I keep the name
etc.. from each user. You will all kill me for this, but in access you
could the setup a relation between user_id and the id of the user in the
user table. Is something like that possible in mysql ?
So that if I select some
Hey,
I've been learning sql using mysql. Now I got the basics. But I'm stuck
I want to learn more advanced things, and since all the site's I know
handle mysql stuff with php it doesn't get really advanced.
Anyone knows any good resources with advanced sql based on mysql stuff ?
Like joins and
I install mysql4.0.13 on windowsXP by using the installation wizard.
Next I start mysql using NET START mysql, then I try to change my root
password 'mysqladmin -u root password foobarke. Try to login with the
new root passwd I get error access denied. But I can login as root using
nothing as
13 matches
Mail list logo