MySQL

• MySQL Questions

• • extract mysql data into xml using jsp

    hi there.. i've got problems on extracting mysql data into xml format by using jsp. All my data...

    By t_ple81

  • Data sync offline

    SJA is available for both Linux and Windows.Karam Alex Greg <alex.greg (AT) gmail (DOT) comwrote:...

    By karamchand

  • "Error 2013 Lost connection to MySQL server du...

    I'm using PuTTY to tunnel to one of my MySQL servers. I can connection locally via the CLI no ...

    By arpoodle

  • How to migrate from 7.5( 32 bit) to 7.6( 64 bit)

    Hello Albert,ad 1) You need-7_6_00_16.tgz/from/pickKevin already gave an answer to question 2.Regard...

    By schroeder_alexander

  • Recomended RAM for production server. 3Gb overboar...

    Hi, I'm looking at buying a new production server, as soon as i mentionedmysql the Dell salesme...

    By bradbrad

• • Data migration Verification

    Hi all,I have somebody creating a C# class to migrate data from one SQL database toanother slightly ...

    By paulizaz, 3 Comments

  • How to move innodb table

    Hi,I am newbie in MySql. Currently we are using MySql version 5, and first i develop all the thing i...

    By doreamon, 1 Comments

  • Mac OS X Table Corruption

    Dan Tappin <dan (AT) wavefront (DOT) cawrote on 07/06/2005 11:26:13 AM:I am running into repeatab...

    By sgreen, 9 Comments

  • Blocking read as in Bug 5449

    Hi,today I stumbled over the problem as described inIf one unplugs the network cable from a machine ...

    By franksonntag, 1 Comments

  • extract numeric value from a string.

    Hi at all, I've this necessity.In a table I've a field popolated by a string where the fir...

    By dixie, 5 Comments

• MySQL: is the Category's subject.It's has 284 questions,this is No.15 pages.
• "diff list" 1.5.4 to 1.6.0
• Hi,would it be possible for me to receive a list of all files that's beenmodified between the versions 1.5.4 and 1.6?I would really appreciate it.Thank in advance,Maria...
• mariaoberg, Thurs, 11 Mar 2010 09:48:00 GMT, 193 bytes, 1 Answer
• Extremely slow executing of a query
• Hello!My client has a MySQL table with 38594 entries. And I need to remove all the duplicates, these duplicates have the equal value in the 'lyrics_file' field. So, to get a list of duplicates I execute this query: SELECT l1.lyrics_id FROM lyrics AS l1, lyrics AS l2WHERE l1.lyrics_file...
• mikeborozdin, Thurs, 11 Mar 2010 08:41:00 GMT, 910 bytes, 2 Answer
• How to migrate from 7.5( 32 bit) to 7.6( 64 bit)
• search the list for subject "7.3 to 7.5 [NN-PARALLEL] Migration Explained(HWT)" and ignore the 7.3 steps and instead start off with a completebackup and then on the new system to a recovery with initialization. MessageFrom: Beermann, Albert [mailto:A.Beermann (AT) piepenbrock (DOT) de]Sent: Thur...
• kevinwilson, Thurs, 11 Mar 2010 08:37:00 GMT, 1,278 bytes
• Blocking when routing
• Hi!From the Eventum feature description: * Email Routing Interface [] - Control who is authorized to send emails in each issue. - Blocked emails are saved as notes for later use.Any way to turn the blocking off? Despite the possibility of spamming we'dlike to allow other senders to reply to...
• harriporten, Thurs, 11 Mar 2010 08:35:00 GMT, 929 bytes
• Extracting data from SQL Server *.DB file
• I've read through the archives and spent hours on Google but I still can'tfigure this out. I must extract the data from a SQL Server *.DB file. Viewingthe raw text, I can see that there views, grants, etc. at the top of the file,but this is a process that could not possible be done by...
• becomingdigital, Thurs, 11 Mar 2010 08:33:00 GMT, 1,048 bytes, 2 Answer
• Data source name not found and no default driver specified
• i am able to connect to MySQL database on the server from my ASP.NET application on the server.. i am using the following connection string..Driver={MySQL ODBC 3.51 Driver};Server=localhost;Database=mydbname;uid=myu sername;pwd=mypassword;option=3wheremydbname is the name of the database i crea...
• jacksonxyz, Thurs, 11 Mar 2010 08:21:00 GMT, 993 bytes, 4 Answer
• Data restore after system crash
• Hello Guenther,so what is the exact state of the old database, what is left over from it? Can you start it into mode ADMIN or even NLINE? Are only the volumes intact?Best regards,Tilo HeinrichSAP Labs Berlin MessageFrom: Schwab, Guenter [mailto:gschwab (AT) reiner-sct (DOT) com]Sent: Monday, 24,...
• heinrich_tilo, Thurs, 11 Mar 2010 08:19:00 GMT, 1,492 bytes
• SQL for finding years in dates?
• Hello, I not sure if this is the right place to ask this... I am usingmysql.What I need is a SQL statement that can find what years are in thedatabase that is greater than last year.For example...I have a table full of dates ranging from 2001 to 2005..I am straining my brain to figure out a SQL...
• jasontudisco, Thurs, 11 Mar 2010 08:17:00 GMT, 525 bytes, 2 Answer
• How to not repeat fields
• Hi,How do i dreate a table, let's say:CREATE TABLE wl_articles(wl_articles_id INT NT NULL AUTINCREMENTPRIMARY KEY, title TEXT NT NULL, main TEXT NT NULL, extended TEXT NT NULL, permalinkVARCHAR(255) NT NULL, date DATE NT NULL, ip VARCHAR(15), user_agentVARCHAR(50), status INTEGER NT NULL, p...
• deckard, Thurs, 11 Mar 2010 08:16:00 GMT, 553 bytes, 10 Answer
• "DESCRIBE table" not working
• Hi, I've got DMX2004 with Impakt 2.6.2 and MySQL 4.0.16 with ODBC3.51.06. I am trying to get tables descriptions in order to altertheir columns. As following MySQL manual, I use for instance "DESCRIBEtable" or any other method like "SHOW COLUMNS FROM" but it does notwork, i get the followin...
• astpaul, Thurs, 11 Mar 2010 08:14:00 GMT, 630 bytes
• Data migration Verification
• Hi all,I have somebody creating a C# class to migrate data from one SQL database toanother slightly differently structured SQL database.Please can anybody suggest ways to verrify that the data has migratedsuccessfully, in whole and acurrate?I feel a sample approach would not quite be substancial...
• paulizaz, Thurs, 11 Mar 2010 08:11:00 GMT, 672 bytes
• Blob retrieval from database using shell
• to compare binary files "cmp" does a better work thandiff. to answer your question echo might be addinga new-line char (\n) at the end of the file, why don'tyou try printf, most shells include such, also try theecho switches not to print the new-line at the end ofthe command (for bash: echo...
• enriquesanchezvela, Thurs, 11 Mar 2010 08:08:00 GMT, 1,880 bytes
• Oracle query..
• Hi All, I have oracle 7.3 data available with meI see many *.ora files andone Import _Rawdata.bat file. . I dont know which one to import. Now I haveinstalled, 10 g version server and client. Could you pls tell me. howcan I import those data into the 10g so that I could see all thetables.For eam...
• renish, Thurs, 11 Mar 2010 08:04:00 GMT, 508 bytes, 8 Answer
• Oracle buys InnoDb! Arghhh!
• How is this going to affect MySQL users?Mike...
• mos, Thurs, 11 Mar 2010 02:06:00 GMT, 60 bytes
• Extraction of records at specific time interval
• I have a large volume of data that was recorded every second.I want to extract data from the database every "x" number of seconds.i.e. SELECT * FROM data WHERE time = (every 30 seconds);The goal is to reduce the data set down to a number of records over time at an interval determined by the user...
• bk_ziv, Wed, 10 Mar 2010 22:48:00 GMT, 734 bytes, 1 Answer
• sql bind parameter not used for all parameters (#0)?????
• hi,i'm trying to export my access table (zip codes) to a mysql db residing on my server and i'm getting the following error:sql bind parameter not used for all parameters (#0)any clues/suggestions?????...
• phillystyle123, Wed, 10 Mar 2010 22:22:00 GMT, 241 bytes
• BLOB to UNSIGNED, can you do it?
• I posted this earlier, however it has a nasty SPAM tag attached to it, soI thought I would resend it.My end goal is to select arbitrarily large data from a BLB column useSUBSTR to pull out certain pieces of data and do some bit shifting andmasking on that data. I believe you can only do bit shif...
• davidgodsey, Wed, 10 Mar 2010 10:02:00 GMT, 1,819 bytes
• Order by
• When I try order by, it prints in assending order, how can I do this to print in deseding order?...
• matrix28, Wed, 10 Mar 2010 08:29:00 GMT, 96 bytes, 4 Answer
• How to name a table based on the contents of a variable?
• I'm writing a stored procedure that gets a VARCHAR(45) as a parameter.Inside my stored procedure, I want to create a table with a name basedon that parameter.For example, if I docall my_sp('XXX');I want the stored procedure to create a table named foo_XXX.I don't know how to...
• matthewwilson, Tues, 09 Mar 2010 21:53:00 GMT, 685 bytes
• Extract String only from varchar Field?
• hi all, i'm looking for a function to extract the string part of a varcharfield only. like when you stored anstreet address in one field like "foobar street 23" and i want everythingexcept the numeric value of it.is it possible without a regexp? if not, anyone has a regexp for thatpurpose h...
• larsschwarz, Tues, 09 Mar 2010 02:40:00 GMT, 356 bytes
• «««56789101112131415