1
yasir
what is the best SQL editor - local language
  • 2006/5/9 15:50

  • yasir

  • Not too shy to talk

  • Posts: 109

  • Since: 2005/5/16


what is the best SQL editor
that support local languages such as
ARABIC

2
eric235u
Re: what is the best SQL editor - local language
  • 2006/5/9 17:04

  • eric235u

  • Not too shy to talk

  • Posts: 149

  • Since: 2004/12/19


just about any text editor works fine for editing SQL. i like jEdit for any playing with text. Or jEdit X.

3
ukandrewf
Re: what is the best SQL editor - local language
  • 2006/7/19 22:46

  • ukandrewf

  • Friend of XOOPS

  • Posts: 198

  • Since: 2002/12/2


I like the look of jedit - unlike excel it does recognise the data format.

But how do I get in to lines of data to edit. I have 3000 links waiting for validation (this is one of my complaints about XOOPS you can't activate a load of links as once by ticking boxes for example).

this is an example of the data:-
INSERT INTO `xoops_mylinks_links` VALUES (3067, 30, 'Browser Hijack Recover(BHR)', 'http://www.browser-hijack.com', '', '', 2369, 0, 1103090123, 0, 0.0000, 0, 0);
INSERT INTO `xoops_mylinks_links` VALUES (3068, 1, 'Source Code Browser', 'http://www.rebrandsoftware.com/showsoftware2.asp?soft_id=7', '', '', 2656, 0, 1103110638, 0, 0.0000, 0, 0);
INSERT INTO `xoops_mylinks_links` VALUES (3069, 5, 'Time Meter for MS Outlook', 'http://www.timemeter.com/index.shtml', '', '', 1541, 0, 1103116954, 0, 0.0000, 0, 0);
INSERT INTO `xoops_mylinks_links` VALUES (3070, 5, 'Time Meter for MS Outlook', 'http://www.timemeter.com/index.shtml', '', '', 1541, 0, 1103116954, 0, 0.0000, 0, 0);

I need to get in an change the 0 to a 1 to activate over 3,000 links is there a way?

The zero i need to change is ['', '', 1541, 0,] last one.

Any ideas maybe a macro?

thanks

Andrew

4
skenow
Re: what is the best SQL editor - local language
  • 2006/7/19 23:54

  • skenow

  • Home away from home

  • Posts: 993

  • Since: 2004/11/17


Might be easier to add them all to your db, then use SQL to change that field.

5
davidthomas1
Re: what is the best SQL editor - local language

If your host supports it, try PHPMyAdmin
http://www.phpmyadmin.net/

You just need to run an SQL query on the links table.

e.g.

UPDATE xoopsprefix_linkstable set fieldname 1 WHERE (optional where statement);
みんなちがってみんないい。

XOOPS 2.0.13.2

6
ukandrewf
Re: what is the best SQL editor - local language
  • 2006/7/24 8:25

  • ukandrewf

  • Friend of XOOPS

  • Posts: 198

  • Since: 2002/12/2


ok yes i have phpmyadmin access

(although I have next to no knowledge of it or sql queries).

would i type exactly
Quote:
UPDATE xoopsprefix_linkstable set fieldname = 1 WHERE (optional where statement);

to achieve what i want?

Do I need to specificy like find '0' replace with '1'?

thanks

Andrew

Login

Username:
Password:

Lost Password? Register now!

Who's Online

70 user(s) are online (31 user(s) are browsing Support Forums)


Members: 0


Guests: 70


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Jun 30
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits