четверг, 15 декабря 2005 г.
|
| Full-text Implementation Guest 22:11:30 |
| | Hi, I need a little explanation about how full-text index works internally. Mainly, i'm interested in two-level b-tree. When MySQL is processing a query on full-text index, what search on the first part of then index? and on the second?
Thanks. Sorry for my english  |
| | Add comment |
понедельник, 12 декабря 2005 г.
|
| Im a Student in High School and I can not get thought this... Guest 18:49:36 |
| | Im a Student in High School and I can not get thought this fire wall HELP ???? Please Thank You guys |
| | Add comment |
четверг, 1 декабря 2005 г.
|
| well i have a question i just got this computer from work... Guest 05:14:33 |
| | well i have a question i just got this computer from work and i cant log as admin cause nobody knows the password anyway to log in as admin? |
| | Add comment |
пятница, 18 ноября 2005 г.
|
| i need a new username on party poker Guest 01:29:25 |
| | i need a new username on party poker |
| |  3 answer | Add comment |
четверг, 17 ноября 2005 г.
|
| System Call within a Procedure Guest 23:03:04 |
| | Is there a function or method to make a system call within a procedure in a mySQL database? I would like to call mail within the procedure and know how to do it with Oracle but can't find it in mySQL, which I'm very new to. Any help would be greatly appreciated. |
| | Add comment |
суббота, 12 ноября 2005 г.
|
| hello there how are you Guest 22:46:25 |
| | hello there how are you |
| | Add comment |
воскресенье, 6 ноября 2005 г.
|
| try puttin da qutes arond wole string... Guest 22:45:02 |
| | try puttin da qutes arond wole string 'testUser@host_name_or_ip'
so it would be :
GRANT ALL PRIVILEGES ON *.* TO 'testUser@host_name_or_ip' IDENTIFIED BY
'some_password' WITH GRANT OPTION; |
| | Add comment |
воскресенье, 23 октября 2005 г.
|
| >Hi, > I 've heared that We need the "dbms_lob.sql" to... Guest 19:10:26 |
| | Hi, > I 've heared that We need the "dbms_lob.sql" to store. PLs guide me. This is >swathi. |
| | Add comment |
четверг, 13 октября 2005 г.
|
| I'm trying to write a c program that utilizes looping to... Guest 21:41:15 |
| | I'm trying to write a c program that utilizes looping to print a table of values, and i'm having problems, can someone assist me? |
| | Add comment |
воскресенье, 25 сентября 2005 г.
|
| SQL-power since 1963 unused Guest 11:09:44 |
| | All SQL commands till today are used in science and
business without explosions of nested combinatorics:
Example: Nested ( IF EXISTS NOT(AND IF NOT EXISTS)).
It's time to go further and apply more mathematical
functions. |
| | Add comment |
четверг, 25 августа 2005 г.
|
| need program to down load parts in stock to our computer so... Guest 17:47:01 |
| | need program to down load parts in stock to our computer so that we can put parts/aan customer in computer |
| | Add comment |
воскресенье, 26 июня 2005 г.
|
| What also helps is not to install mysql as 'mysql', but... Guest 14:40:24 |
| | What also helps is not to install mysql as 'mysql', but choose e.g. 'mysql4' |
| | Add comment |
пятница, 24 июня 2005 г.
|
| MyODBC build fails Guest 15:31:16 |
| | Hi all,
I'm building MyODBC 3.51.11 on RedHat 9.0 Linux platform for iODBC and mysql-version 4.1.7 (standard).
I run the configure with following options
#./configure --prefix=/usr/local/MyODBC-3.51/ --with-iODBC=/usr/local/iodbc/ --with-iodbc-includes=/usr/local/iodbc/include/ --with-iodbc-libs=/usr/local/iodbc/lib/ --with-mysql-path=/usr/local/mysql-standard-4.1.7-pc-linux-i686/ --enable-shared=yes
after that, i did make and observed following errors
---------------------------------------------------------------------------
gcc -DHAVE_CONFIG_H -I. -I. -I. -I/usr/local/iodbc/include/ -O3 -DDBUG_OFF -DPORTABLE_GUI -I/usr/local/mysql-standard-4.1.7-pc-linux-i686//include -mcpu=pentiumpro -MT connect.lo -MD -MP -MF .deps/connect.Tpo -c connect.c -fPIC -DPIC -o .libs/connect.o
In file included from /usr/local/mysql-standard-4.1.7-pc-linux-i686/include/my_global.h:291,
from myodbc3.h:65,
from connect.c:41:
/usr/include/asm/atomic.h:40:2: warning: #warning Using kernel header in userland program. BAD!
In file included from ../util/MYODBCUtil.h:25,
from connect.c:47:
../driver/myconf.h:117:1: warning: "PACKAGE" redefined
In file included from /usr/local/mysql-standard-4.1.7-pc-linux-i686/include/my_global.h:70,
from myodbc3.h:65,
from connect.c:41:
/usr/local/mysql-standard-4.1.7-pc-linux-i686/include/my_config.h:867:1: warning: this is the location of the previous definition
In file included from ../util/MYODBCUtil.h:25,
from connect.c:47:
../driver/myconf.h:174:1: warning: "VERSION" redefined
In file included from /usr/local/mysql-standard-4.1.7-pc-linux-i686/include/my_global.h:70,
from myodbc3.h:65,
from connect.c:41:
/usr/local/mysql-standard-4.1.7-pc-linux-i686/include/my_config.h:989:1: warning: this is the location of the previous definition
In file included from ../util/MYODBCUtil.h:41,
from connect.c:47:
/usr/local/iodbc/include/iodbcinst.h:340: conflicting types for `_myodbc_SQLGetPrivateProfileString'
myodbc3.h:122: previous declaration of `_myodbc_SQLGetPrivateProfileString'
make[2]: *** [connect.lo] Error 1
make[2]: Leaving directory `/home/opsxml/iodbc/MyODBC-3.51.11/driver'
make[1]: *** [all] Error 2
make[1]: Leaving directory `/home/opsxml/iodbc/MyODBC-3.51.11/driver'
make: *** [all-recursive] Error 1
---------------------------------------------------------------------------
Please help to resolve this issue.
Thank in advance
Soma |
| | Add comment |
среда, 22 июня 2005 г.
|
| Note: The setter methods (setShort, setString, and so on)... Guest 11:08:15 |
| | Note: The setter methods (setShort, setString, and so on) for setting IN parameter values must specify types that are compatible with the defined SQL type of the input parameter. For instance, if the IN parameter has SQL type INTEGER, then the method setInt should be used.
it says you can use it but not how to |
| | Add comment |
среда, 8 июня 2005 г.
|
ISAM => INNODB (Novice)  Francesco 18:29:05 |
| | Hi all.
I have a mysql database with isam tables created by an application. I have got all frm,fry.
I wrote another (java) application (using this db via jdbc) that must convert the tables in innodb type (i use transactions) and import data in them.
What is the right way to do it (programmatically)?
If i brutally copy the database files in data directory i obtain errors on ibd files.
I cannot obtain a dump for the database.
Can you help me? |
| | Add comment |
среда, 11 мая 2005 г.
|
| No, it's not possible Guest 00:00:09 |
| | No, it's not possible |
| | Add comment |
среда, 13 апреля 2005 г.
вторник, 12 апреля 2005 г.
|
| If you still have the problem, try uninstalling Admin v... Guest 23:52:43 |
| | If you still have the problem, try uninstalling Admin v. 1.0.19 and installing 1.0.20. If that works, please send $$$ Mark Lawton - mark.lawton@itsysteminc.com |
| | Add comment |
понедельник, 11 апреля 2005 г.
|
| MYSQL primary key joanne loh 07:02:28 |
| | i am developing a system using MySQL. i have a field called Code_ID which is the primary key as well as auto incremented. the problem i faced is when i delete one row of data for example row with Code_ID=3, then Code_ID=3 will not ever be used when i insert new data. i want the Code_ID to automatically sort to the most current Code_ID. for example if Code_ID=3 is deleted then Code_ID=4 will change to 3 and so on. is it possible? |
| | Add comment |
четверг, 31 марта 2005 г.
|
| Q: With MySQL, after a long time of in-activity, I got... Guest 16:41:22 |
| | Q: With MySQL, after a long time of in-activity, I got
java.sql.SQLException: Communication link failure: java.net.SocketException.
A: This happens because of a connection timeout on the MySQL side.
You need add "autoReconnect=true" in the jdbc url. You may also want configure
your mysql server and add an entry
set-variable = interactive_timeout=50000
in the file my.cnf (the default is 28800, 8hr).
Note that, in later Bugzero versions, this exception shall not cause any
real harm. It will simply try re-connect. It is logged in the log file, but
end-user does not see it.
You may also see a similar java.sql.SQLException:
Communication link failure: java.io.IOException.
Regards
Lakshmanan
lakshmanan@iicindia.com |
| | Add comment |
среда, 23 марта 2005 г.
|
| mysqlclient.lib and C on windows Guest 16:07:18 |
| | Hi,
i've been tryinkg to build a simple program that connects to mysql server
the problem is:
i can not build it on windows!
has anybody tried it or know how to do it?
i've tried bcc compiler, devc++, vc++ |
| | Add comment |
|
