I have created a test table for different data types as follows:
CREATE TABLE AllDataTypes (
id INTEGER,
col_bit BIT,
col_boolean BOOL,
col_tinyint TINYINT,
col_smallint SMALLINT,
col_int INT,
col_integer INTEGER,
col_bigint BIGINT,
col_float FLOAT,
col_double DOUBLE,
col_char
The first column of type timestamp will always be initialized with the
current timestamp. See the fourth and fifth paragraphs of the following
link.
http://www.mysql.com/doc/en/DATETIME.html
Isn't it suppose to be 'NULL'? Thanks
--
Linux: Because rebooting is for adding hardware.
Fingerprint
hay guyz
im havin a weired problem
i ve this search query
$srch_qry = select ctnt_inf.* from ctnt_inf .
where (match (firstName ) against (\.$srch.\) .
or match (lastName ) against (\.$srch.\) .
or match (summary ) against (\.$srch.\) .
or match (body) against (\.$srch.\) .
or
Thanks. That explains it.
Pae
The first column of type timestamp will always be initialized with the
current timestamp. See the fourth and fifth paragraphs of the following
link.
http://www.mysql.com/doc/en/DATETIME.html
Isn't it suppose to be 'NULL'? Thanks
--
Linux: Because
hello,
i wanna setup replication, everything works so far, but the slave
can'tconenct to the master, access denied. but if i connect with the 'mysql'
program from slave machine to master machine, it works!
going crazy .. both mysqld's are 3.23.53 !
what is going wrong here ahh?
regards,
Dear Soenke,
i wanna setup replication, everything works so far, but the slave
can'tconenct to the master, access denied. but if i connect with the
'mysql'
program from slave machine to master machine, it works!
Before you go crazy, check if the slave (user) has sufficient privileges.
Let's
Hi
I would like to know whether MySQL with the Berkeley DB tables supports
two phase commit?
Thanks
Gil
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the
Ares Liu wrote:
As both of them type IV JDBC, which one is the better?
If you're talking about the Apache Group's Turbine, it's not a JDBC
driver, it's a servlet framework that sits on top of JDBC.
-Mark
--
For technical support contracts, visit https://order.mysql.com/?ref=mmma
Matthew Scarrow wrote:
I have an applet and I'm trying to use Connector/ J 3 to connect to my
database.
I have uploaded the applet to my web server.
I have uploaded the mysql-connector-java-3.0.2-beta-bin.jar file to
the same
dir as the applet
I have made a reference to the mysql.jar file in
Notice: Bravo Technical Resources does not allow EXE files into its email
system, they are deleted automatically. Please refrain from sending them in
the future. If there is a legitimate need to send an executable email,
please contact [EMAIL PROTECTED] Thank you.
Antigen for Exchange found
Dear list,
Does any of you guys operate a mysql server in virtual hosting environment?
I need some advice on tuning and restriction based on system resources.
My system is running RH7.2 , on an Intel based server, 2x1Ghz CPU's and 1
giga of RAM.
I have 2 hd's in raid 1 mode (hardware). I
On Sun, Nov 24, 2002 at 10:39:43PM +0200, Sweethome.co.il Webmaster wrote:
Dear list,
Does any of you guys operate a mysql server in virtual hosting environment?
I need some advice on tuning and restriction based on system resources.
One thing you need to nail down is what the abstraction
Hey All,
I'm working on a site that displays all the players on my hockey team and I
want to the page to indicate the captains automatically. Right now im using
the following query to display all the captains, however, captains are
indicated by a 1, is it possible to display a C when a 1 is
Hey Alex
select captain from stats where captain 0 and number = '23' group by
number;
this returns a 1 for any player with the number that matches being a
captain, however it display a 1 is it possible to make that 1 displayed as
a
C on my page?
MySQL allows an IF() within the SELECT
Hey,
I'm not sure how to implement this into my query, i looked it on the
mysql.com documentation and it's confusing.
I tried this query:
select captain from stats where captain 0 if (captain(1,'C') and number
= '$number' group by number;
but i dont think its right cuz its returning a value.
select if(captain = 1, 'C', '')
from stats
where captain 0
and number = $number
group by number
This returns 'C' whenever the captain field is 1 and '' (empty string)
otherwise.
--jeff
- Original Message -
From: Alex Behrens [EMAIL PROTECTED]
To: DL Neil [EMAIL PROTECTED]; MYSQL
[EMAIL
Is it possible to tell MySQL 4.0.5 what special characters it can index? For
instance, I would like it to index - and + characters so that hyphenated words
like full-text and words like C++ are indexed and can be searched. I've been
trying to find a way to do this, but haven't found a solid
hey,
I got that query to work but i dont know how to display it on an HTML page,
I'm using this and its not displaying anything:
$captainquery = mysql_query(select if(captain = 1,'C','') from stats AS
cstatus WHERE captain 0 and number = '19' group by number);
Greetings!
I am aware that MySQL does not support subqueries. I have a 3 gb large
database of bibliographic records. Database is designed by a model that is
accepted by almost every library system, but there is one problem. When
searching that database, nested queries are needed and there's a
hey Alex,
1 swap from stats and AS cstatus - the AS is to put a column name/give
you an associate array element name for the if(captain = 1,'C','')
2 recommend replacing the '' within the if() with captain - that way
something will be returned regardless of the if() comparison
3 recommend
On 11/24/02 4:30 PM, Bruno Batarelo [EMAIL PROTECTED] wrote:
The question is what does Access do in order to perform subqueries on MySQL
via MyODBC driver since it is obvious that they work? What can I do, but I
do not want to use access database as a layer between my application and
mysql
Dear sir,
I want to create a website in my native language.
I would like MySQL support for my native character set, which is Bengali. I
think MySQL does not support this language. How can I add support for it in
MySQL ?
Thanks in advance for any reply.
Shyamal
I am getting this error while trying to Replicate to a second MySQL server.
021124 23:40:25 Slave: reconnected to master
'[EMAIL PROTECTED]:3306',replication resumed in log 'FIRST' at position
4
021124 23:40:25 Error reading packet from server: Binary log is not open
(server_errno=2000)
I have
Greetings,
Im trying to keep the mysql installation to a minimal since space
is limited on a Compact Flash card. The following binaries in the 'bin'
directory total 16megs. Mysql is used very limited, only inserts and reads
from php are done to the database, and replication will be used
NEWEST**
I am now getting this error while trying to Replicate to a second MySQL
server.
021125 0:41:01 Slave: Failed reading log event, reconnecting to retry, log
'bsd1-bin.001' position 73
021125 0:41:01 Slave: reconnected to master
'[EMAIL
Description:
MySQL crashed at final step, when executing script mysql_install_db, with msg:
mysqld got signal 11;
Here is all last output line at finish installation:
/usr/bin/ginstall -c .libs/mysqlmanager /usr/local/bin/mysqlmanager
make[2]: Nothing to be done for
26 matches
Mail list logo