[mysql] Forum Topics

Hi, How to create an account in Mysql that does not require SSl Vinay

[COLOR="Navy"]Hi everyone, I just finished my summer internship last week and part of what my boss told me at the end of the program was to work on DBMS skills. I am thinking of working on MySQL and from experience I know the best way to master any programming skill(or …

Having built a work around for the counting feature not working, in any of the normal ways Ihave the following problem. [b]This works perfectly:[/b] [b][size=1][color=#ff0000][i] <%[/i][/b][/color][/size][size=1] [i][b]RSPage[/b] [/i][/size][i][size=1][color=#008000]=[/color][/size][size=1] [b]TRIM[/b][/size][size=1][color=#008000]([/color][/size][b][size=1]Request[/b][/i][/size][i][size=1][color=#008000].[/color][/size][b][size=1]QueryString[/b][/i][/size][i][size=1][color=#008000]([/color][/size][size=1]"page"[/size][size=1][color=#008000]))[/color][/size][/i][size=1] [/size][b][size=1][color=#008000][i]If[/i][/b][/color][/size][i][size=1] [b]Len[/b][/size][size=1][color=#008000]([/color][/size][b][size=1]RSPage[/b][/i][/size][i][size=1][color=#008000])[/color][/size][size=1] [/size][size=1][color=#008000]=[/color][/size][size=1] [/size][size=1][color=#ff00f0]0[/color][/size][size=1] [/size][b][size=1][color=#008000]Then[/b][/i][/color][/size][i][size=1] [b]RSPage[/b] [/size][size=1][color=#008000]=[/color][/size][size=1] [/size][size=1][color=#ff00f0]1[/color][/size][/i][size=1] [i][b]Max[/b] [/i][/size][i][size=1][color=#008000]=[/color][/size][size=1] [/size][size=1][color=#ff00f0]10[/color][/size][/i][size=1] [/size][b][size=1][color=#008000][i]If[/i][/b][/color][/size][i][size=1] [b]RSPage[/b] [/size][size=1][color=#008000]=[/color][/size][size=1] [/size][size=1][color=#ff00f0]1[/color][/size][size=1] [/size][b][size=1][color=#008000]Then[/b][/i][/color][/size][i][size=1] [b]Offset[/b] [/size][size=1][color=#008000]=[/color][/size][size=1] [/size][size=1][color=#ff00f0]0[/color][/size][/i][size=1] [/size][b][size=1][color=#008000][i]If[/i][/b][/color][/size][i][size=1] [b]RSPage[/b] …

Hi all I am pretty new to website design and am trying to incorporate my website into a database. At the moment I am simply trying to put some basic code together and will finalise details later. I have however come accross a problem, I have managed to get working …

Hi, I have a row where it has multiple columns distinguishing the number of votes a user has. so it'll look like this: [inlinecode] [ user ] [ option_1 ] [ option_2 ] [ option_3 ] [ option_4 ] bobby........ 1 ......... 3 ............ 7 ......... 3 [/inlinecode] Is there …

[COLOR="Navy"]Hello all, I installed MySQL 5.O but due to some errors I need to uninstall the file , but while trying to delete the file, I keep getting a message that some files (under a specified directory) are shared by other processes or used by other users so I can't …

Hi, I have a calendar table that has event comments and a date tagged to it. I would like to view "Upcoming Events" only. I was wondering what type of syntax I'll need to be using? heres how the table would look: comment | d1 | d2 | d3 ---------------------------- …

Hello there, I know (i think) this can be done (i saw it somewhere, but can't remember where), so maybe you guys can help me. I need my primary key to have left values on the auto_increment. For example P20060001 P20060002 P20060003 ... I need to have P2006 values on …

Has anyone used the tools for this before? How does it handle the code differences, e.g. no SYSDATE in MySQL. Does it automatically change the differences. Thanks

This is the first time I try to use MySQL for very large tables. Experienced users warned me against possible problems with *index* definition for large tables: they claim MySQL indices are stored completely in memory, which is problematic to me : I have a huge table and limited memory …

Hi, I have two fields...both are not unique, but both can't be the same. So two fields: user | fruit | joe11 apple angel bananna bobby apple jeff orange julie orange angel apple angel orange ---------- So lets say the above was my table, notice how both fields are not …

Hi, Need in brief: [COLOR="Blue"]Have 3 tables. I need to extract data from two tables and fill the third table.[/COLOR] Table structure: COM PROFILER: CREATE TABLE comprofiler ( [COLOR="Green"] id int(11) NOT NULL default '0', user_id int(11) NOT NULL default '0', firstname varchar(100) collate latin1_general_ci default NULL, middlename varchar(100) collate …

I am looking to make a site that will have a big database and concurrent users. I have a choice between MySQL and MS SQL. what is the best one to use for max concurrent users? I need this info as soon as possible. Thnx for any help.

Dear all I have a few questions. I would be grateful if you could take the time to answer. I have installed on windows xp home apache2, php 5 and mysqlserver 5. The [URL="http://localhost"]http://localhost[/URL] page of apache works fine. The <?php echo phpinfo(); ?> page works fine. However when i …

I can't find it anywhere! :rolleyes: I want to install it onto a test Red Hat box so that I can replicate our live environment before doing an upgrade. I've scoured and scoured. If the internet had been a saucepan, it'd have very little of its copper bottom left. :lol: …

I create 2 connectionsand then try to select the current active database: [code] $aaa_link = mysql_connect("host1","user1","pass1") or die(mysql_error()); $bbb_link = mysql_connect("host2","user2","pass2")or die(mysql_error()); mysql_select_db("dbname1", $aaa_link) or die(mysql_error()); [/code] However, mysql_select_db fails with error: [code]Access denied for user: "user2" to database "dbname1"[/code] What is wrong here?

[code]mysql> insert into fund_history select * from temp_fund_history where data_date='2006-06-30' and index_num between 1 and 10; Query OK, 0 rows affected (0.03 sec) Records: 10 Duplicates: 10 Warnings: 0[/code] I am really wondering why this INSERT statement is not inserting 10 records. Its saying 10 Duplicates: 10, and there is …

Sir, I had mysql file ss.sql. Now I want upload the file in the Database. Is there any way to do the same. Kindly help me in the matter. Ashwin Perti

I have a table with three columns that I want to group. The columns are driver, passenger and date. Basically what I want is something like... SELECT COUNT(*) FROM TABLE GROUP BY driver,passenger,date; However what can happen is that the driver and passenger can be the opposite on the same …

hi,everyone my name uma,I use powerbuilder with mysql and have some problem.I have a table that have 2 primary key first a character and second a numeric.I create a datawindow that has 2 argument(primary key) for retrieve data.if second argument(numeric) has value more than 9 the datawindow can't retrieve data.I …

I'm having problem in inserting into table. I'm inserting data from one table into another [I]insert into table1 select * from table2 where condition = expression[/I] I have 962 records in table2 for specified condition, but only 105 rows are getting inserted. Both tables are in same database. What could …

I have a serious problem. I am trying to update an entry in a parent table which has three children tables which are coupled in such a way that either on delete or update they are affected. What I want is to know if there is a way to update …

Thanks so much Can anyone please tell me. I have Mysql 4.0 my users are listed by auto increment not null On the site I offer you a form to send a member a message you fill out the form. The form inputs are named = message from and user_id, …

Hello Pro Programmers! Can you help me, Please!!! What I want to do is let my users message each other, I have my form and message page setup I love it! It’s working the messages are going in the right ID’S in the Mysql database, BUT! It is overwriting as …

I need to set ft_min_word_length=3, so that my users can perform boolean fulltext searches for words of three characters instead of four. However, I share the MySQL server with other customers of my ISP. My ISP's administrator is willing to change this system variable, [B]provided[/B] I can show him an …

Hello, I get the error bolow on my page, could anyone with an idea tell me how to go around it? mysql_num_rows(): supplied argument is not a valid MySQL result Regards, omesa

ok, im not too sure how to explain this, but ill try... i have a website that a friend hosts for me on his server. it is an oscommerce website that seems to run fine. i felt that working from the webserver was a little slow for all the images …

I am using MS Excel 2003, Win XP, MyODBC driver 3.51.12.This problem is associated with the use of MS Excel with Mysql Connector/ODBC3.51.12 . Connector/ODBC was installed and tested successfully.However,I tried to import data to Excel from the MySQL database that resulted in error message "[MySQL][ODBC 3.51 Driver]User cancelled. Procedure …

I have a txt file (log) that an application writes to regularly that I want to automate import into a MySql table. I intially thought about using LOAD DATA INFILE but can not use this in a stored procedure. Any thoughts or suggestions? Thanks in advance... Greg

I just got this [B]Error Returned when i tryied Type the url of my site [/B] mySQL query error: SELECT e.*,b.blog_name, b.blog_friendly_url FROM ibf_blog_entries e,ibf_blog_blogs b LEFT JOIN ibf_blog_categories bc ON ( e.blog_id=bc.blog_id and e.category_id=bc.category_id ) WHERE e.entry_status='published' AND (b.blog_private=0 or b.blog_id = 1) AND ((bc.blog_id IS NULL) or (b.blog_id …