On 6/13/06, Rob Desbois <[EMAIL PROTECTED]> wrote:
If you are going to specify values for all columns in your insert, you should
put NULL as the value for an AUTO_INCREMENT column, e.g.
mysql> insert into SalesSupData values (NULL,2,2,'test',140);
My preferred way however is to put the column n
I have a problem with inserting data into table in Mysql.
I have a Auto_increment Column in Table which throws errors when I try
to insert into the table.
This is table description.
mysql> desc SalesSupData;
+-+-+--+-+-++
| Field | Type
Hello,
I am using MySql-5.0.21 on Suse-Linux-10, i created tables using
lowercase names
for example ;
mysql> create table a (id int);
Query OK, 0 rows affected (0.04 sec)
mysql> select * from A;
ERROR 1146 (42S02): Table 'mysql.A' doesn't exist
mysql> select * from a;
Empty set (0.01 sec)
I hav
Hello,
I am using MySql-5.0.21 on Suse-Linux-10, i created tables using
lowercase names
for example ;
mysql> create table a (id int);
Query OK, 0 rows affected (0.04 sec)
mysql> select * from A;
ERROR 1146 (42S02): Table 'mysql.A' doesn't exist
mysql> select * from a;
Empty set (0.01 sec)
I hav
You hit the nail on the head Irek,thanks the problem was skip
networking was on.
Regards
Digz
On Tue, 2005-06-07 at 17:34, Irek Słonina wrote:
> Digvijoy Chatterjee wrote:
> > can somebody explain the events below:
> >
> > mysql is running but its not listening on 3306,.
can somebody explain the events below:
mysql is running but its not listening on 3306,...as a result clients on remote
machines are not able to connect..
The server name is spiti
confirm that mysqld is running:
[EMAIL PROTECTED] ~]$ ps -ef |grep [m]ysql
root 31515 1 0 15:30 pts/3
: HOW DO I COMMIT AND ROLLBACK
Thanks and Regards
Digz
On Mon, 2005-06-06 at 19:39, Digvijoy Chatterjee wrote:
> How do i explicilty create an innodb table ?
>
> I tried searching thro Manual...but did not get anything important in the
> create t
>
> table section.
How do i explicilty create an innodb table ?
I tried searching thro Manual...but did not get anything important in the
create t
table section.
Thanks
DIgz
*** CAUTION - Disclaimer ** This e-mail
contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely
Hi all,
I have been using /var/mysql/data as my data directory till now ,
suddenly i realise its all filled up with some 20M left which will
finish in a day or two , repartioning my disks is not an option , what
do i do to restart mysql with a new data directory say
/usr/local/mysql/data/: changin
Hello all,
My question is if unix Epoch time started on January 1st 1970 ,and mysql uses
the same implementation of time , what is the logic mysql developers have
used to offset it by 30 odd years that is the max date for mysql is 2068 and
not 2038 18th January, i work in a Financial services f
download the source tar ball and
try installing mysql from the source the configure script does it all
you , u dont need to worry,
for custom compilation use ./configure --help
Regards
Digvijoy Chatterjee
Suryya Ghosh wrote:
Hi,
I have gone through the sites which you have recomended where it is
Hi All,
I have just started using My-sql 4.1.9 mysql Ver 14.7 Distrib 4.1.9,
for pc-linux-gnu (i686)
Is there a way I could rollback my changes , i tried to go through the
documentation but it wasn't of much help.
regards
Digvijoy
t; Suppose the values in my table are,
> Name = rama
> Eno = NULL
> Age = 23
>
>
> The prob is it does not retrieve 23 from the table.
> The prob is I cannot give eno is NULL as I donât know (in practice)
> whether the field will be NULL.
>
> Digvijoy Chatterjee
I have Mysql 4.1.9 on RHES-3.0 installed by rpms..the default socket
path and database creation directory is /var/lib/mysqlnow there is a
a dearth of space in /var therefore i would like to move the database
files to something like /usr which has lots of free space , creating
Symlinks does not
14 matches
Mail list logo
