Hi Paul
On Monday 08 April 2002 12:56 am, Paul DuBois wrote:
> You're inserting a specific value into the AUTO_INCREMENT field, which
> doesn't result in the creation of a new automatic sequence number.
>
> If you want to insert a record with a specific value in that column, *and*
> you want the
I am running MySQL 3.23.41-17 on a stock SuSE 7.3 install. I have a table
"customers" with an auto-incrementing primary key "customer_id". If I insert
a record:
mysql> insert into customers(customer_id) values ("10");
and then ask for the last insert:
mysql> select last_insert_id();
(which I t
Does anyone know why it is that the MyODBC authors prefer not to allow that
to be distributed in the unixODBC package, or with distros (eg the SuSE CDs
don't contain it)?
Is it a licensing issue, something to do with the ODBC spec, or just plain
"don't want to do that, so there" (which, I hast
On Monday 17 December 2001 15:04, David VanHorn wrote:
> I killed all Mysql processes, and confirmed that they are killed (ps -ef |
> grep mysql)
> Then I restart with safe_mysqld --skip-grant-tables
> Trying to log in to mysql in any way, including mysql -h localhost mysql
> or mysql root or my
Have you had a look at The Exchange Project?
www.theexchangeproject.org
Kevin
On Wednesday 05 December 2001 22:07, rory o'connor wrote:
> I'm looking for a new commerce package, something run of a MySQL database.
> it's gotta have bulletproof (well, as close as you can get) session
> management.
So far as I know, yes. You need to set up two different connection strings,
though, and reference those in the different queries.
Kevin
On Friday 07 December 2001 08:14, Ares Liu wrote:
> Can I implement parallel queries to mySQL by using sevial query sentences
> in a single PHP file? Who kn
Hi Josep
We have to be clear about definitions.
You seem to be making a couple of mistakes here:
1 - guestbook.sql is not the db, but probably a script to create the db (you
can check by opening it in a text-editor - it will probably have a CREATE
TABLE statement at the top, then the field defin
Can you give some more info?
Eg what is Fink, what distro are you using, how can you install if you don't
have perms for the directory, etc.
Kevin
On Saturday 08 December 2001 15:17, Espen Isaksen wrote:
> I installed MySql through Fink but now that I try to start up I type
> "mysqld" at the
>
One of three issues:
1 - the db is not set up correctly;
2 - the user is not set up correctly;
3 - the PHP script is not calling the db properly - this could be due to
wrong syntax, misnaming of the db table, or incorrect username parameters.
You would need to post some more info, in particular
On Monday 10 December 2001 10:30, Benjamin Pflugmann wrote:
> You may want to have a look at "replication" in the fine manual:
> http://www.mysql.com/doc/R/e/Replication.html
A lot of info there! But it seems to apply mainly to v4. I'm not sure of
Ananth's situation, but what I want to do is h
Hi Mike
> This command executes and immediately ends:
> > safe_mysqld --log &
>
> [2] 855
> root@linux:/var/lib/mysql > Starting mysqld daemon with databases from
> /var/lib/mysql
> 04 07:45:16 mysqld ended
>
> This command seems to run quite nicely:
> > safe_mysqld --skip-grant-tables &
>
>
I'm using 3.23.37, and I am taking a random subset of records from a table,
and putting them into another table:
insert into targettable select * from sourcetable;
I then want to delete these records from the source table. I have tried
various permutations of:
delete from sourcetable select *
Hi Jason
On Friday 09 November 2001 00:26, [EMAIL PROTECTED] wrote:
> I am lost. I am a very VERY green newbie, and I am struggling on just
> how to begin. Basically, I have bought a book, entitled, "PHP and MYSQL
> Web Development" . , I have downloaded mysql-3.23.43.tar.gz, the install
>
13 matches
Mail list logo
