Hello,
I need to select some data from a table where a column is not a numerical value
but can't seem to get the right syntax for this.
Basically we need to do something like this:
SELECT * FROM tablename WHERE column_name (IS NOT A NUMERIC VALUE)
what is the correct syntax to accomplish
Hi,
You could use regular expression to do this, here is the example with the
reference site that might help you:
If your data is 'test', 'test0', 'test', '111test', '111'
SELECT * FROM myTable WHERE col1 REGEXP '^[0-9]+$';
Result: '111'
In regex ^ mean begin, and $ - end.
SELECT * FROM
/
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
- Original Message -
From: Sukhjinder K. Narula
To: Mike Blezien
Cc: MySQL List
Sent: Tuesday, October 08, 2013 8:08 AM
Subject: Re: Check for numeric values
Hi,
You could use regular expression to do this, here is the example with the
reference site that might help you
;
-Original Message-
From: Girish Talluru [mailto:girish.dev1...@gmail.com]
Sent: Tuesday, February 12, 2013 1:37 AM
To: mysql@lists.mysql.com
Subject: Please check the stored procedure
DROP PROCEDURE IF EXISTS Cursor_Test;# MySQL returned an empty result
set
(i.e. zero rows).
DELIMITER
In mysql 5.0 ,how to check how big a database is?
Thanks
On 11/15/2011 2:10 PM, Angela liu wrote:
In mysql 5.0 ,how to check how big a database is?
Thanks
See Database size at http://www.artfulsoftware.com/queries.php
PB
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
Thanks, this is really helpful.
From: Peter Brawley peter.braw...@earthlink.net
To: mysql@lists.mysql.com
Sent: Tuesday, November 15, 2011 12:41 PM
Subject: Re: how to check how big a database is
On 11/15/2011 2:10 PM, Angela liu wrote:
In mysql 5.0 ,how
December 2010 20:25
To: 'mysql'
Subject: /etc/init.d/mysql start WITHOUT integrity check?
Is there a way to /etc/init.d/mysql start WITHOUT doing an integrity
check?
Can I pass in a command line parameter or set something in the my.cnf file?
Our DB is a Billion rows (with a B) and that check can
Let me know with you whether I understood what do you want to do. Normally,
after mysqld restart on OSs as Ubuntu/Debian, we can observe a script
execution, which will check integrity of all databases tables and present a
message of Corrupt What I did when I wanted to get rid this check
-Original Message-
From: andrew.2.mo...@nokia.com [mailto:andrew.2.mo...@nokia.com]
Sent: Thursday, December 30, 2010 2:45 AM
To: dae...@daevid.com; mysql@lists.mysql.com
Subject: RE: /etc/init.d/mysql start WITHOUT integrity check?
Daevid,
I'm not quite sure I understand
Comment WHAT lines?
I looked through /etc/init.d/mysql and don't see anything related to
check or chk. I eyeballed each line in the file and nothing stands out
as the culprit causing an integrity check of the databases.
develo...@mypse:/etc/init.d$ ps aux | grep mysql
46:root 10239 0.0
On 12/30/2010 5:00 PM, Daevid Vincent wrote:
Comment WHAT lines?
I looked through /etc/init.d/mysql and don't see anything related to
check or chk. I eyeballed each line in the file and nothing stands out
as the culprit causing an integrity check of the databases.
develo...@mypse:/etc/init.d
There are different and connected things being discussed here.
1-) Is there a way to read new configurations from my.cnf whithout restart
server?
= No. A simple mysqladmin reaload don't submit server to read configuration
file again.
2-) Is there a way to avoid debian-script to check databases
Is there a way to /etc/init.d/mysql start WITHOUT doing an integrity
check?
Can I pass in a command line parameter or set something in the my.cnf file?
Our DB is a Billion rows (with a B) and that check can take HOURS.
All we want to do is restart the server to put another slave online
Hi,
I want to check daily a large database. If I execute a mysqlcheck, its
execution is longer the 8 minutes.
What is the best practice to check tables daily ? medium option? Fast
option?
Regards,
David
a
backup on that script for inserting into another table.
ANYWAY, what I am wondering is, is what would be the best way to check all
my tables for errors/issues, and then run a repair on the table if it finds
an issue?
I have at least 30 tables, each having about 3-6 million rows in each, and
each
this built in command is probably a good start:
http://dev.mysql.com/doc/refman/5.0/en/mysqlcheck.html
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
might be this will help you.
http://adminlinux.blogspot.com/2010/05/mysql-checking-and-reparing-tables.html
On Fri, Jun 18, 2010 at 6:59 PM, a.sm...@ukgrid.net wrote:
this built in command is probably a good start:
http://dev.mysql.com/doc/refman/5.0/en/mysqlcheck.html
--
MySQL
You gota see thesde prices! http://heatsummer.com
Hi
For example ,
Student_TBL
Student_id Student_Name Student_regNo ,
Am going to Alter the StudentregNo To StudentRegister_No ,
Am not sure who are all used this field , that any of the views depend this
StudentRegister_No ,
How to check it ,
Is there any function Do this,
Thanks
are all used this field , that any of the views depend this
StudentRegister_No ,
How to check it ,
Is there any function Do this,
Thanks
Ok. I have already gotten the answer.
On Wed, Jun 3, 2009 at 4:15 PM, Moon's Father yueliangdao0...@gmail.comwrote:
Hi.
I want to know which lock method is used within MySQL?
For example, if I query the following statements within MySQL client.
mysql begin;
Query OK, 0 rows affected
Mind sharing ? :-) I don't really have the issue, but it sounds like a
useful trick.
On Fri, Jun 5, 2009 at 11:44 AM, Moon's Father yueliangdao0...@gmail.comwrote:
Ok. I have already gotten the answer.
On Wed, Jun 3, 2009 at 4:15 PM, Moon's Father yueliangdao0...@gmail.com
wrote:
Hi.
I'm a little concerned and disappointed that the GRANT command doesn't do
any sort of checking (like a foreign key for example) to verify that the
database and table exist?!
I get the case of *.* but it seems crazy to me that it would allow foo.bar
when neither a database named 'foo' nor a table
*shrugs* I, for one, appreciate a tool that doesn't try to be smarter than I
am. If I want to be treated like an idiot, I'll use microsoft software.
On Wed, May 27, 2009 at 2:38 AM, Daevid Vincent dae...@daevid.com wrote:
I'm a little concerned and disappointed that the GRANT command doesn't
NULL becomes indistinguishable from an emtpy string.
On Tue, Feb 17, 2009 at 2:47 AM, PJ af.gour...@videotron.ca wrote:
I know this is not working, but how can I check for NULL; or how can I
configure my field sub_title so I can check if $booksub_title contains
anything or is empty
Hi !
Johan De Meersman wrote:
In SQL, the correct syntax is IS NULL or IS NOT NULL.
Random programming languages more often than not have no decent support for
NULL content, although your DB library might have an isnull() function or
something similar. Once you've exported a field into a
variable,
however, most often NULL becomes indistinguishable from an emtpy string.
On Tue, Feb 17, 2009 at 2:47 AM, PJ af.gour...@videotron.ca wrote:
I know this is not working, but how can I check for NULL; or how can I
configure my field sub_title so I can check if $booksub_title contains
I know this is not working, but how can I check for NULL; or how can I
configure my field sub_title so I can check if $booksub_title contains
anything or is empty.
This problem as been breaking my back...don't know what to put in as a
default to be able to check against string input (VARCHAR
On Thu, Oct 9, 2008 at 6:44 PM, Sudhir Menon [EMAIL PROTECTED] wrote:
Hi all,
I would like to check or set the following values in MySQL Server . How
can
that be done ?
1. MySQL Database Free Space for any database.
2. Maximum Database size allowed.
3. Calculate Index Size.
4
Any additional tools will satisfy your demand.
On Mon, Oct 13, 2008 at 7:34 PM, Sudhir Menon [EMAIL PROTECTED] wrote:
My reply was with regards to the answer in this post.
http://lists.mysql.com/mysql/214827
Anyways thanks for the concern from your end.. Mike :) My query was
answered.
My reply was with regards to the answer in this post.
http://lists.mysql.com/mysql/214827
Anyways thanks for the concern from your end.. Mike :) My query was
answered.
Thanks Regards
Sudhir Menon
Thanks Amit ...
Thanks Regards
Sudhir
At 09:11 AM 10/10/2008, Sudhir Menon wrote:
Thanks Amit ...
Thanks Regards
Sudhir
Sudhir,
What following values? I think you're missing part of your post.
(send text only)
Mike
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Hi all,
I would like to check or set the following values in MySQL Server . How can
that be done ?
1. MySQL Database Free Space for any database.
2. Maximum Database size allowed.
3. Calculate Index Size.
4. Maximum table size
5. Free table space
6. Free Index space
7. Calculate Table size
Hi Sudhir,
#show table status command will give you most of what all is required. Have
a look at the results post any further query if you have.
Regards,
Amit Sharma
On Thu, Oct 9, 2008 at 6:44 PM, Sudhir Menon [EMAIL PROTECTED] wrote:
Hi all,
I would like to check or set the following
Hi,
Configure my.cnf in such a way so that it uses 3.5 GB of physical memory.
Please check max_connecions. Out of memory problem also occur due to lots of
connections
Thanks
Krishna
On 9/27/07, Amarnath Shivashankar [EMAIL PROTECTED] wrote:
We have found that the MYSQL on all Email DB servers
buffers/cache
2605
1448
swap:
4094
150
3943
Please help me out to change the parameter values
Regards,
Amarnath S
Amarnath Shivashankar wrote :
We have found that the MYSQL on all Email DB servers starts throwing
Out of
memory; check if mysqld or some other
I have Mysql 5.0.45 using innodb tables.
Occasionally, I get corrupted tables. I can go into Mysql administrator
gui and see the bad table and I can repair the index or whatever is
wrong from the gui.
I need a command line way to periodically detect for issues and if it
finds one the I need a
Bryan Cantwell wrote:
I have Mysql 5.0.45 using innodb tables.
Occasionally, I get corrupted tables. I can go into Mysql administrator
gui and see the bad table and I can repair the index or whatever is
wrong from the gui.
I need a command line way to periodically detect for issues and if it
We have found that the MYSQL on all Email DB servers starts throwing Out of
memory; check if mysqld or some other process uses all available memory;
error. The error goes once we restart MySQL. But after a week again the same
problem occurs. We have 4 GB of physical memory on the server but Mysql
Amarnath Shivashankar a écrit :
We have found that the MYSQL on all Email DB servers starts throwing Out of
memory; check if mysqld or some other process uses all available memory;
error. The error goes once we restart MySQL. But after a week again the same
problem occurs. We have 4 GB
Hi,
I am getting a lot of these ones after a power outage. I have a huge amount
of tables and databases on the server. Is there any automated way to check
the health of ALL databases and ALL tables? And maybe some automated way to
repair if problems?
Got error: 1016: Can't open file
-
From: Ryan Stille [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 28, 2007 5:10 PM
To: mysql@lists.mysql.com
Subject: Re: MySQL Daylight Savings Time Patch - easy check
I am on 4.1.20-1.
Maybe your OS isn't patched?
Try this: SELECT @@global.time_zone;
If you get back SYSTEM
To: mysql@lists.mysql.com
Subject: Re: MySQL Daylight Savings Time Patch - easy check
I am on 4.1.20-1.
Maybe your OS isn't patched?
Try this: SELECT @@global.time_zone;
If you get back SYSTEM, then MySQL is looking to the OS for
timezone
data. And its only loaded when MySQL starts, so
What version of MySQL are you using? I'm running 4.1.21, and that check
doesn't work even after I've updated (I think) the time zone tables.
I should probably eyeball the output of mysql_tzinfo_to_sql.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT
Jerry Schwartz wrote:
What version of MySQL are you using? I'm running 4.1.21, and that check
doesn't work even after I've updated (I think) the time zone tables.
I should probably eyeball the output of mysql_tzinfo_to_sql.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington
MySQL starts, so if you haven't
restarted MySQL since you patched your OS, you need to do that.
-Ryan
Jerry Schwartz wrote:
What version of MySQL are you using? I'm running 4.1.21, and that check
doesn't work even after I've updated (I think) the time zone tables.
I should probably eyeball
that.
-Ryan
Jerry Schwartz wrote:
What version of MySQL are you using? I'm running 4.1.21, and that check
doesn't work even after I've updated (I think) the time zone tables.
I should probably eyeball the output of mysql_tzinfo_to_sql.
Regards,
Jerry Schwartz
Global Information Incorporated
. And its only loaded when MySQL starts, so if you haven't
restarted MySQL since you patched your OS, you need to do that.
-Ryan
Jerry Schwartz wrote:
What version of MySQL are you using? I'm running 4.1.21, and that
check
doesn't work even after I've updated (I think) the time zone tables.
I
- Original Message -
*From:* Ryan Stille [EMAIL PROTECTED]
*To:* mysql@lists.mysql.com
*Date:* Sat, 24 Feb 2007 15:28:25 -0600
Ryan Stille wrote:
Paul DuBois wrote:
At 4:40 PM -0600 2/20/07, Ryan Stille wrote:
Is there an easy way to test to see if MySQL already has the proper
Ryan Stille wrote:
Paul DuBois wrote:
At 4:40 PM -0600 2/20/07, Ryan Stille wrote:
Is there an easy way to test to see if MySQL already has the proper
tables loaded?
-Ryan
Yes, reload them. :-) After that, they're current! ...
After digging around on the net for a while I found an
|
+---+---+
Thx's
Mickalo
- Original Message -
From: Ryan Stille [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Saturday, February 24, 2007 3:28 PM
Subject: Re: MySQL Daylight Savings Time Patch - easy check
Ryan Stille wrote:
Paul DuBois wrote:
At 4:40 PM
will weigh in on this.
Is your OS updated? On Linux you can check by running 'zdump -v
/etc/localtime | grep 2007'. You should see some lines mentioning March 11.
If your OS is not ready for the change, that could be your problem.
You could also try updating the MySQL timezone tables
PROTECTED]
To: mysql@lists.mysql.com
Sent: Saturday, February 24, 2007 4:07 PM
Subject: Re: MySQL Daylight Savings Time Patch - easy check
I'm not exactly sure what you should do, hence my earlier question about the
empty time zone tables. I get the same (correct) result on both of my
servers
Hello,
Your friend thinks you might like this ...
What is your favorite laptop? SONY VAIO, Apple POWERBOOK, IBM Thinkpad,
TOSHIBA, DELL, HP
http://www.teenwag.com/poll?n=159
Thanks,
Take back news
sent via http://www.teenwag.com
Personal Message : Hey I found this
C K wrote:
please check bugs and please give the answer
Bug ID=24216 and 24216
They are both the same bug ID, so I will only bother answering once.
You probably are using InnoDB tables to store your data, and this is
expected behaviour for InnoDB - MySQL provides a rough guess as to how
please check bugs and please give the answer
Bug ID=24216 and 24216
CPK
Hi
I have 3 fields like this:
id date_in date_out
1 2006-09-05 2006-09-10
2 2006-09-15 2006-09-20
3 2006-09-25 2006-09-30
Example: if I have an time interval like '2006-09-05' and '2006-09-21',
I have to search, in the same time, only the records that not included
in time
I'm not 100% sure I'm understanding your requirements, but this query:
select id from datetest where date_in not between '2006-09-05' and
'2006-09-21' and date_out not between '2006-09-05' and '2006-09-21';
should do exactly as you want for getting id3 if I'm understanding
the requirements
I run CHECK commands against all tables nightly. Our dataset is
small, so it's quick easy; for large and/or static datasets daily
might be impractical. However, if you don't run CHECK regularly, you
don't know your data is good, and it's possible you might have
corruption for a long time
Hi!
Given the commands like ANALYZE, OPTIMIZE and CHECK, what is the
preference order to execute these commands?
We would like to schedule and execute these commands every month...
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
In the last episode (Oct 27), wolverine my said:
Given the commands like ANALYZE, OPTIMIZE and CHECK, what is the
preference order to execute these commands?
OPTIMIZE calculates statistics as it rebuilds the table, so there's no
need to run an ANALYZE pass after it. You shouldn't ever need
Will L wrote:
Rob Munsch,
I am a member of the Nabble project. This is regarding a bad post by user
itguy321.
Just want to explain a few things. Nabble is a free mailing list
archive/gateway that works like Gmane. Users can browse, search, and post
via Nabble's web interface and the post
Will L. wrote:
Nabble hates spam as much as you do. We are currently monitoring this
user and we will take necessary action just like a mailing list owner
will do.
If you hated spam as much as I did, you would have terminated this user,
based on the egregious and well-documented abuse of this
On 3 Aug 2006 at 10:16, John Trammell wrote:
snip
If you hated spam as much as I did, you would have terminated this user,
based on the egregious and well-documented abuse of this list.
snip
This message has been scanned for viruses by McAfee's Groupshield.
You say you hate spam then spam
I think equating a tagline indicating something's been spam-checked
with a full out message for a web product is a little absurd.
On 8/3/06, Ian [EMAIL PROTECTED] wrote:
You say you hate spam then spam the list with an advert for McAfee!
Ian
--
I'm American, fatboy. What's your excuse?
--
You know this might be a little bit more convincing if you gave the name of the
product and a little bit more personal reason why you recommended it other than
check out brand x product I vote this is spam.
-Original Message-
From: itguy321 [mailto:[EMAIL PROTECTED]
Sent: Wednesday
Mee too.
John Meyer [EMAIL PROTECTED] escreveu na mensagem
news:[EMAIL PROTECTED]@gmail.com...
You know this might be a little bit more convincing if you gave the name of
the product and a little bit more personal reason why you recommended it
other than check out brand x product I vote
shortly be blacklisted as well.
Have a *great* day.
Tracking link:
http://www.nabble.com/check-out-this-free-software-i-found-to-document-your-it-infrastructure-tf2041675.html#a5620241
No recent reports, no history available
Resolves to 72.21.53.35
Routing details for 72.21.53.35
contacted about your spamming activity,
sirrah. If they are a respectable service, you will get the boot; if
they are not, i expect they shall shortly be blacklisted as well.
Have a *great* day.
Tracking link:
http://www.nabble.com/check-out-this-free-software-i-found
Hi!
The application I develop requires mysqlclient library.
What lines should I add to configure.in to make configure script to
check for mysql libs and to set proper values for libs and includes?
Thanks!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
I create a table using the follow statement:
CREATE TABLE test_check(NO_W_ID int ,NO_D_ID int,MM int,CT int,CHECK(MM
3));
But server allow a insert statement as follow,why?
insert into test_check values(1,1,1,1);
Because MySQL does not support CHECK constraints.
Yes, it parses
I create a table using the follow statement:
CREATE TABLE test_check(NO_W_ID int ,NO_D_ID int,MM int,CT int,CHECK(MM
3));
But server allow a insert statement as follow,why?
insert into test_check values(1,1,1,1);
Hello.
I'm a bit sorry, but my English doesn't allow me to clearly see your
problem. Could you repost your message and include the output of the
following statements:
SHOW SLAVE STATUS
SHOW MASTER STATUS
SHOW TABLE STATUS
Execute SHOW TABLE STATUS both on the Slave and Master. Use as
Nice to meet you.
My name is katakura.
I might want to ask the replication.
It is that whether the slave side has synchronized though show master
status is done
on the side of ..show slave status.. mastering on the slave side and
Read_Master_Log_
Pos and Position agree that Rows in the value of
. Well, using myisamchk -o worked. I
then ran check table in the mysql client to see what it would say. It
said all was well. I'm just suprised that it took 45 minutes to run.
Anyone run check table on large databases? What kind of times did you
encounter? I must say this is on an OLD box
worked. I
then ran check table in the mysql client to see what it would say. It
said all was well. I'm just suprised that it took 45 minutes to run.
Anyone run check table on large databases? What kind of times did you
encounter? I must say this is on an OLD box ... maybe 512 RAM and right
now I
1062 (23000): Duplicate entry '' for key 1
Mathias
Selon Michael Kruckenberg [EMAIL PROTECTED]:
Hi,
Use enum with a default type and let mysql do the check for you.
The problem with an enum is that if you insert a value that's not in
the enum, MySQL doesn't stop the insert, it leaves
Dear List,
My system is RedHat EL3 and MySQL 5.0.7-beta.
I wanted to implement a check constraint (below), but after some testing
and googling, it seems I can't do this with MySQL. I've read suggestions
that check(s) should be done using triggers. Is a trigger a preferred
method of achieving
A trigger is a good place to check the value, and change it, bit I
don't believe you can actually generate a MySQL error within the
trigger that will prevent the data from being inserted. Currently
(unless there's been an update to triggers that's not yet in the
docs), you can only change
Another approach would be to use a view with a CHECK OPTION. This will
allow the view to behave exactly like a check constraint:
CREATE VIEW tblJob_view AS
SELECT JobId, CustomerId, JobType, Description,
QuotationDate, OrderDate
FROM tblJob
WHERE JobType IN ('DesignOnly
permit
any person or program to insert data directly via the table.
Rhino
- Original Message -
From: Partha Dutta [EMAIL PROTECTED]
To: 'Michael Kruckenberg' [EMAIL PROTECTED]; [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Sent: Saturday, June 25, 2005 11:11 AM
Subject: RE: CHECK constraint
Selon Michael Kruckenberg [EMAIL PROTECTED]:
A trigger is a good place to check the value, and change it, bit I
don't believe you can actually generate a MySQL error within the
trigger that will prevent the data from being inserted. Currently
(unless there's been an update to triggers that's
Hi,
Use enum with a default type and let mysql do the check for you.
The problem with an enum is that if you insert a value that's not in
the enum, MySQL doesn't stop the insert, it leaves the column empty.
This doesn't enforce data integrity like I think Chris wanted.
mysql desc
FYI
-Original Message-
From: Gleb Paharenko [mailto:[EMAIL PROTECTED]
Sent: Sunday, May 29, 2005 5:18 PM
To: mysql@lists.mysql.com
Subject: Re: Could not initialize master info structure, check
permisions on master.info
Hello.
Are you restoring the database on the running slave
Hello.
Are you restoring the database on the running slave? What is the
sequence of steps which you're doing? Find the master.info file -
it is usually located in the data directory and check it's permissions.
See:
http://dev.mysql.com/doc/mysql/en/slave-logs.html
Is it possible
Hi Everybody,
I am new to the list,infact this is my first mail to the list.
Ok here goes the query :-
While restoring the database from backup, I am getting the following
error.
ERROR 1201 at line 1: Could not initialize master info structure,
check permisions on master.info .
I am doing
On 5/16/05, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
Hi,
with a similar structure, you can have :
mysql select * from users where uid =262140;
++--+
| uid| nickname |
++--+
| 262140 | text |
| 262141 | text |
| 262142 | text |
| 262143 |
(NULL,.) results in a new row with
uid=2147483647
* several combinations of CHECK TABLE, myisamchk (-r|-o|), dump
remore_wrong_record restore, drop the entire database:
- data is OKAY, select results in no records above 11k, next insert
will have uid=2147483647
The table fits in about
@lists.mysql.com
Subject: auto_increment trouble (not the usual check || alter table
solution, though)
Hi everyone,
First time on the list, although I've been (quietly) a (not-so)long-time
quiet observer. This isn't a FAQ and I can assure
you I've tried every procedure out there (both on and off-list
Partha,
On 5/16/05, Partha Dutta [EMAIL PROTECTED] wrote:
This may not be a very elegant solution, but you can do this just to get the
inserts going again:
ALTER TABLE users
MODIFY COLUMN uid INTEGER UNSIGNED NOT NULL AUTO_INCREMENT;
If you don't have any negative uids, then you will be
sure it doesn't have any uid above =~10k, delete
the table and restore the table (and data) from disk:
- data is okay, select * from users where uid11k shows ZERO records
- insert into users values (NULL,.) results in a new row with
uid=2147483647
* several combinations of CHECK TABLE
Partha,
Partha Dutta wrote:
This may not be a very elegant solution, but you can do this just to get the
inserts going again:
ALTER TABLE users
MODIFY COLUMN uid INTEGER UNSIGNED NOT NULL AUTO_INCREMENT;
If you don't have any negative uids, then you will be able to store 2
billion more uids.
Just
-
From: Jacek Becla [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 03, 2005 4:00 PM
To: Jay Blanchard
Cc: [EMAIL PROTECTED]
Subject: Re: how to check if keys disabled?
Jay
Are you sure? DESCRIBE tells me the table has an index, but not whether
the index is enabled or not:
mysql create
Hi,
How can I find out if keys are enabled/disabled for a given table?
Suppose I do:
create table t1 (x int primary key);
create table t2 (x int primary key);
alter table t1 disable keys;
How can I now find out that t1 has keys disabled, and t2 enabled?
thanks,
Jacek
--
MySQL General Mailing List
[snip]
How can I find out if keys are enabled/disabled for a given table?
Suppose I do:
create table t1 (x int primary key);
create table t2 (x int primary key);
alter table t1 disable keys;
How can I now find out that t1 has keys disabled, and t2 enabled?
[/snip]
DESCRIBE t1 or DESCRIBE t2
--
Jay
Are you sure? DESCRIBE tells me the table has an index, but not whether
the index is enabled or not:
mysql create table t1 (x int primary key);
Query OK, 0 rows affected (0.01 sec)
mysql create table t2 (x int primary key);
Query OK, 0 rows affected (0.01 sec)
mysql alter table t1 disable
Try show index from t1;
Show index from t2;
-Original Message-
From: Jacek Becla [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 03, 2005 4:00 PM
To: Jay Blanchard
Cc: mysql@lists.mysql.com
Subject: Re: how to check if keys disabled?
Jay
Are you sure? DESCRIBE tells me the table has
: Tuesday, May 03, 2005 4:00 PM
To: Jay Blanchard
Cc: mysql@lists.mysql.com
Subject: Re: how to check if keys disabled?
Jay
Are you sure? DESCRIBE tells me the table has an index, but not whether
the index is enabled or not:
mysql create table t1 (x int primary key);
Query OK, 0 rows affected
1 - 100 of 342 matches
Mail list logo